APPS.IGI_SIA_AP_HOLDS_T1 dependencies on IGI_SIA

Line 1: TRIGGER "APPS"."IGI_SIA_AP_HOLDS_T1"

1: TRIGGER "APPS"."IGI_SIA_AP_HOLDS_T1"
2: AFTER UPDATE OF RELEASE_LOOKUP_CODE
3:
4: ON "APPS"."AP_HOLDS" FOR EACH ROW
5: DECLARE

Line 15: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,

11: ,l_SapStatusFlag
12: ,l_SapErrorNum);
13: IF l_SapStatusFlag='Y' THEN
14: IF :NEW.RELEASE_LOOKUP_CODE IS NOT NULL AND :NEW.HOLD_LOOKUP_CODE = 'QTY REC' THEN
15: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,
16: :NEW.LAST_UPDATED_BY,
17: 0
18: );
19: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'Y';

Line 19: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'Y';

15: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,
16: :NEW.LAST_UPDATED_BY,
17: 0
18: );
19: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'Y';
20:
21: ELSE
22:
23: IF (:NEW.RELEASE_LOOKUP_CODE IS NOT NULL AND

Line 25: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,

21: ELSE
22:
23: IF (:NEW.RELEASE_LOOKUP_CODE IS NOT NULL AND
24: :NEW.RELEASE_LOOKUP_CODE = 'MATCHED') THEN
25: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,
26: :NEW.LAST_UPDATED_BY,
27: 0
28: );
29: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'Y';

Line 29: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'Y';

25: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,
26: :NEW.LAST_UPDATED_BY,
27: 0
28: );
29: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'Y';
30: END IF;
31: END IF;
32: END IF;
33: END;