4: ON igi_ra_customer_trx_all
5: REFERENCING NEW AS NEW OLD AS OLD
6: FOR EACH ROW
7: BEGIN 8: IF igi_gen.is_req_installed('EXP') THEN 9: IF nvl(:new.dial_unit_id,0) = -999
10: THEN
11: :new.DIAL_UNIT_ID := :old.DIAL_UNIT_ID;
12: ELSE
Line 13: IF (igi_gen.is_req_installed('EXP')
9: IF nvl(:new.dial_unit_id,0) = -999
10: THEN
11: :new.DIAL_UNIT_ID := :old.DIAL_UNIT_ID;
12: ELSE 13: IF (igi_gen.is_req_installed('EXP') 14: AND
15: :new.complete_flag = 'Y'
16: AND
17: :new.created_from <> 'RAXTRX')