APPS.IGI_POST dependencies on GL_JE_BATCHES

Line 11: FROM GL_JE_BATCHES

7: CURSOR C1(P_RUN_ID IN NUMBER) IS
8: SELECT JE_BATCH_ID,
9: BUDGETARY_CONTROL_STATUS,
10: STATUS
11: FROM GL_JE_BATCHES
12: WHERE POSTING_RUN_ID = P_RUN_ID;
13:
14: CURSOR C2(P_JE_BATCH_ID IN NUMBER) IS
15: SELECT JE_HEADER_ID

Line 27: l_posting_run_id GL_JE_BATCHES.POSTING_RUN_ID%TYPE;

23: , JE_CATEGORY
24: FROM GL_JE_HEADERS
25: WHERE JE_BATCH_ID = P_JE_BATCH_ID;
26:
27: l_posting_run_id GL_JE_BATCHES.POSTING_RUN_ID%TYPE;
28: l_je_batch_id GL_JE_BATCHES.JE_BATCH_ID%TYPE;
29: l_ItrStatus_Flag VARCHAR2(1);
30: l_ItrErrorNum NUMBER;
31:

Line 28: l_je_batch_id GL_JE_BATCHES.JE_BATCH_ID%TYPE;

24: FROM GL_JE_HEADERS
25: WHERE JE_BATCH_ID = P_JE_BATCH_ID;
26:
27: l_posting_run_id GL_JE_BATCHES.POSTING_RUN_ID%TYPE;
28: l_je_batch_id GL_JE_BATCHES.JE_BATCH_ID%TYPE;
29: l_ItrStatus_Flag VARCHAR2(1);
30: l_ItrErrorNum NUMBER;
31:
32:

Line 88: -- This replaces trigger IGI_IGI_ITR_GL_JE_BATCHES_T1

84: IF l_ItrStatus_Flag = 'Y' THEN
85: l_posting_run_id := P_POSTING_RUN_ID;
86: FOR Cont3 in C1 (l_posting_run_id) LOOP
87: l_je_batch_id := Cont3.je_batch_id;
88: -- This replaces trigger IGI_IGI_ITR_GL_JE_BATCHES_T1
89: IF Cont3.Status NOT IN ('S','U','I') and
90: Cont3.Budgetary_Control_Status IN ('F','P','N','R') THEN
91:
92: IGI_ITR.Action(1);

Line 100: -- This replaces trigger IGI_IGI_GL_JE_BATCHES_T2

96: IGI_ITR.Action(0);
97: END IF;
98:
99:
100: -- This replaces trigger IGI_IGI_GL_JE_BATCHES_T2
101: IGI_ITR.Process_Batches;
102: END LOOP; -- Cont3
103: -- IGI_ITR.Process_Batches;
104: