DBA Data[Home] [Help]

APPS.PJI_FM_SUM_BKLG dependencies on PJI_FM_SUM_BKLG

Line 1: PACKAGE BODY PJI_FM_SUM_BKLG AS

1: PACKAGE BODY PJI_FM_SUM_BKLG AS
2: /* $Header: PJISF12B.pls 120.4 2011/09/22 14:30:49 arbandyo ship $ */
3:
4: g_last_activity_date number;
5: g_pji_schema varchar2(30);

Line 19: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);')) then

15: begin
16:
17: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
18:
19: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);')) then
20: return;
21: end if;
22: /*
23: -- Get the minimum activity dates for each project in the current batch

Line 60: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);');

56: map.rowid
57: , map.project_id
58: ;Commented for bug 13011859 */
59:
60: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);');
61:
62: commit;
63:
64: end ROWID_ACTIVITY_DATES_FIN;

Line 79: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);')) then

75: begin
76:
77: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
78:
79: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);')) then
80: return;
81: end if;
82:
83: /* l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 110: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);');

106: )
107: )
108: ;Commented for bug 13011859 */
109:
110: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);');
111:
112: commit;
113:
114: end UPDATE_ACTIVITY_DATES_FIN;

Line 128: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);')) then

124: begin
125:
126: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
127:
128: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);')) then
129: return;
130: end if;
131:
132: -- Get minimum funding dates for each project in the current batch

Line 163: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);');

159: map.rowid
160: , map.project_id
161: ;Commented for bug 13011859 */
162:
163: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);');
164:
165: commit;
166:
167: end ROWID_ACTIVITY_DATES_ACT;

Line 182: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);')) then

178: begin
179:
180: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
181:
182: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);')) then
183: return;
184: end if;
185:
186: /* l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 211: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);');

207: )
208: )
209: ;Commented for bug 13011859 */
210:
211: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);');
212:
213: commit;
214:
215: end UPDATE_ACTIVITY_DATES_ACT;

Line 232: ( l_process, 'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);'

228:
229: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
230:
231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
232: ( l_process, 'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);'
233: )) then
234: return;
235: end if;
236:

Line 272: (l_process, 'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);');

268: )
269: ;Commented for bug 13011859 */
270:
271: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
272: (l_process, 'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);');
273:
274: commit;
275:
276: end SCOPE_PROJECTS_BKLG;

Line 296: 'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);'

292:
293: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
294: (
295: l_process,
296: 'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);'
297: )) then
298: return;
299: end if;
300:

Line 311: 'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);'

307:
308: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
309: (
310: l_process,
311: 'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);'
312: );
313:
314: commit;
315:

Line 1205: ( l_process, 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);')) then

1201:
1202: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1203:
1204: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1205: ( l_process, 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);')) then
1206: return;
1207: end if;
1208:
1209: -- Assigning Values to the variables

Line 1441: STEP_NAME = 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);';

1437:
1438: update PJI_SYSTEM_PRC_STATUS
1439: set STEP_STATUS = 'C'
1440: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x) and
1441: STEP_NAME = 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);';
1442:
1443: commit;
1444:
1445: end loop;

Line 1456: ( l_process, 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);');

1452: null;
1453:
1454: ELSE
1455: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1456: ( l_process, 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);');
1457:
1458: commit;
1459:
1460: END IF;Commented for bug 13011859 */

Line 1470: end PJI_FM_SUM_BKLG;

1466:
1467: begin
1468: g_pji_schema := pji_utils.get_pji_schema_name;
1469:
1470: end PJI_FM_SUM_BKLG;