DBA Data[Home] [Help]

APPS.IGI_SIA_AP_HOLDS_T2 dependencies on IGI_SIA

Line 1: TRIGGER "APPS"."IGI_SIA_AP_HOLDS_T2"

1: TRIGGER "APPS"."IGI_SIA_AP_HOLDS_T2"
2: AFTER UPDATE
3:
4: ON "APPS"."AP_HOLDS" DECLARE
5: l_SapStatusFlag VARCHAR2(1);

Line 12: IF l_SapStatusFlag='Y' AND IGI_SIA.G_QTY_REC_HOLD_RELEASED = 'Y' THEN

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:

Line 13: IGI_SIA.PROCESS_HOLDS;

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

Line 14: IGI_SIA.G_QTY_REC_HOLD_RELEASED := 'N';

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

Line 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;

Line 19: IGI_SIA.PROCESS_HOLDS;

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;

Line 20: IGI_SIA.G_MATCH_PO_HOLD_RELEASED := 'N';

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;