CREATE OR REPLACE TRIGGER APPS.PROMOTION_TRIG
BEFORE INSERT
ON ONT.OE_ORDER_LINES_ALL
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
tmpVar NUMBER;

BEGIN
   select count(*)
   into tmpVar
    from qp_pricing_attr_get_v gets, qp_qualifiers_v qual
where qual.LIST_HEADER_ID=gets.LIST_HEADER_ID
and qual.LIST_HEADER_ID=229557
and gets.PRODUCT_ATTR_VALUE=:new.INVENTORY_ITEM_ID
and qual.QUALIFIER_ATTR_VALUE=:new.SOLD_TO_ORG_ID
and exists
(
select 'x'
from oe_order_lines_all linn
where request_date between trunc(request_date,'MONTH') and last_day(request_date)
and linn.SOLD_TO_ORG_ID=qual.QUALIFIER_ATTR_VALUE
and linn.INVENTORY_ITEM_ID=gets.PRODUCT_ATTR_VALUE

)        ;

if tmpVar>=1 then 

    neglect command ????????????????????????????????????

end if;


   
END ;

raise_application_error