APPS.IGI_SIA_AP_INVOICES_ALL_T1 dependencies on IGI_SIA

Line 1: TRIGGER "APPS"."IGI_SIA_AP_INVOICES_ALL_T1"

1: TRIGGER "APPS"."IGI_SIA_AP_INVOICES_ALL_T1"
2: AFTER UPDATE
3: ON "APPS"."AP_INVOICES" FOR EACH ROW
4: DECLARE
5: Cursor cur_get_core_hold_count(p_inv_id ap_holds.invoice_id%type)

Line 44: IGI_SIA.REVERSE_HOLDS(:new.invoice_id, :new.last_updated_by);

40: ,l_SapStatusFlag
41: ,l_SapErrorNum);
42: IF (l_SapStatusFlag='Y' ) and (:new.cancelled_date is not null)
43: and (:old.cancelled_date is NULL) then
44: IGI_SIA.REVERSE_HOLDS(:new.invoice_id, :new.last_updated_by);
45: END IF;
46:
47: -- Bug 3409394 Start --
48:

Line 86: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,:NEW.LAST_UPDATED_BY,0);

82: FETCH cur_get_SIA_hold_count into l_cnt;
83: CLOSE cur_get_SIA_hold_count;
84:
85: if l_cnt <> 0 then
86: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,:NEW.LAST_UPDATED_BY,0);
87: IGI_SIA.PROCESS_HOLDS;
88: end if;
89: end if;
90: END IF;

Line 87: IGI_SIA.PROCESS_HOLDS;

83: CLOSE cur_get_SIA_hold_count;
84:
85: if l_cnt <> 0 then
86: IGI_SIA.SET_INVOICE_ID (:NEW.INVOICE_ID,:NEW.LAST_UPDATED_BY,0);
87: IGI_SIA.PROCESS_HOLDS;
88: end if;
89: end if;
90: END IF;
91: -- Bug 3409394 End --