1: TRIGGER "APPS"."IGI_SIA_AP_HOLDS_T2"
2: AFTER UPDATE
3:
4: ON "APPS"."AP_HOLDS" DECLARE
5: l_SapStatusFlag VARCHAR2(1);
8: l_SapStatusFlag := 'N';
9: IGI_GEN.get_option_status('SIA'
10: ,l_SapStatusFlag
11: ,l_SapErrorNum);
12: IF l_SapStatusFlag='Y' AND IGI_SIA.G_QTY_REC_HOLD_RELEASED = 'Y' THEN
13: IGI_SIA.PROCESS_HOLDS;
14: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'N';
15: END IF;
16:
9: IGI_GEN.get_option_status('SIA'
10: ,l_SapStatusFlag
11: ,l_SapErrorNum);
12: IF l_SapStatusFlag='Y' AND IGI_SIA.G_QTY_REC_HOLD_RELEASED = 'Y' THEN
13: IGI_SIA.PROCESS_HOLDS;
14: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'N';
15: END IF;
16:
17: IF (l_SapStatusFlag='Y' AND
10: ,l_SapStatusFlag
11: ,l_SapErrorNum);
12: IF l_SapStatusFlag='Y' AND IGI_SIA.G_QTY_REC_HOLD_RELEASED = 'Y' THEN
13: IGI_SIA.PROCESS_HOLDS;
14: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'N';
15: END IF;
16:
17: IF (l_SapStatusFlag='Y' AND
18: IGI_SIA.G_MATCH_PO_HOLD_RELEASED = 'Y') THEN
14: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'N';
15: END IF;
16:
17: IF (l_SapStatusFlag='Y' AND
18: IGI_SIA.G_MATCH_PO_HOLD_RELEASED = 'Y') THEN
19: IGI_SIA.PROCESS_HOLDS;
20: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'N';
21: END IF;
22: END;
15: END IF;
16:
17: IF (l_SapStatusFlag='Y' AND
18: IGI_SIA.G_MATCH_PO_HOLD_RELEASED = 'Y') THEN
19: IGI_SIA.PROCESS_HOLDS;
20: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'N';
21: END IF;
22: END;
16:
17: IF (l_SapStatusFlag='Y' AND
18: IGI_SIA.G_MATCH_PO_HOLD_RELEASED = 'Y') THEN
19: IGI_SIA.PROCESS_HOLDS;
20: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'N';
21: END IF;
22: END;