APPS.PJI_RM_SUM_MAIN dependencies on PJI_RM_SUM_MAIN

Line 1: package body PJI_RM_SUM_MAIN as

1: package body PJI_RM_SUM_MAIN as
2: /* $Header: PJISR01B.pls 120.17 2011/09/22 15:07:06 arbandyo ship $ */
3:
4: -- The main procedure is procedure SUMMARIZE, it is invoked from a concurrent
5: -- program.

Line 340: l_process := PJI_RM_SUM_MAIN.g_process;

336: l_no_work varchar2(255) := 'There is no project to process for the specified parameters';
337:
338: begin
339:
340: l_process := PJI_RM_SUM_MAIN.g_process;
341:
342: if (p_run_mode = 'F') then
343: l_extraction_type := 'FULL';
344: elsif (p_run_mode = 'I') then

Line 374: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process,

370: 'N');
371: end if;
372: Commented for bug 13011859 */
373: l_transition_flag :=
374: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process,
375: 'TRANSITION');
376:
377: if ((l_org_count = 0 and
378: l_project_count = 0) or l_transition_flag = 'Y') then

Line 387: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_RM_SUM_MAIN.INIT_PROCESS;')) then

383: end if;
384:
385: PJI_PROCESS_UTIL.ADD_STEPS(g_process || 1, 'PJI_PJI', l_extraction_type);
386:
387: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_RM_SUM_MAIN.INIT_PROCESS;')) then
388: rollback;
389: return;
390: end if;
391:

Line 814: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_RM_SUM_MAIN.INIT_PROCESS;');

810: 'PARALLEL_PROCESSES',
811: least(g_parallel_processes,
812: g_parallel_limit));
813: Commented for bug 13011859 */
814: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_RM_SUM_MAIN.INIT_PROCESS;');
815:
816: commit;
817:
818: end INIT_PROCESS;

Line 891: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_RM_SUM_MAIN.RUN_PROCESS;')) then

887: l_seq number;
888:
889: begin
890:
891: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_RM_SUM_MAIN.RUN_PROCESS;')) then
892: return;
893: end if;
894:
895: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 926: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_RM_SUM_MAIN.RUN_PROCESS;');

922: -- process finished
923:
924: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'N') thenCommented for bug 13011859 */
925:
926: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_RM_SUM_MAIN.RUN_PROCESS;');
927:
928: commit;
929:
930: -- end if;

Line 1275: pji_utils.write2out(PJI_RM_SUM_MAIN.GET_MISSING_TIME_HEADER);

1271: if (l_header_flag = 'Y') then
1272:
1273: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');
1274:
1275: pji_utils.write2out(PJI_RM_SUM_MAIN.GET_MISSING_TIME_HEADER);
1276: l_header_flag := 'N';
1277: end if;
1278:
1279: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and

Line 1283: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1279: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and
1280: c.TO_DATE > c.CALENDAR_MAX_DATE) then
1281:
1282: pji_utils.write2out(
1283: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1284: c.USER_PERIOD_TYPE,
1285: c.FROM_DATE,
1286: c.CALENDAR_MIN_DATE));
1287:

Line 1289: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1285: c.FROM_DATE,
1286: c.CALENDAR_MIN_DATE));
1287:
1288: pji_utils.write2out(
1289: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1290: c.USER_PERIOD_TYPE,
1291: c.CALENDAR_MAX_DATE,
1292: c.TO_DATE));
1293:

Line 1297: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1293:
1294: elsif (c.TO_DATE > c.CALENDAR_MAX_DATE) then
1295:
1296: pji_utils.write2out(
1297: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1298: c.USER_PERIOD_TYPE,
1299: c.CALENDAR_MAX_DATE,
1300: c.TO_DATE));
1301:

Line 1305: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1301:
1302: elsif (c.FROM_DATE < c.CALENDAR_MIN_DATE) then
1303:
1304: pji_utils.write2out(
1305: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1306: c.USER_PERIOD_TYPE,
1307: c.FROM_DATE,
1308: c.CALENDAR_MIN_DATE));
1309:

Line 1388: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_RM_SUM_MAIN.WRAPUP_PROCESS;')) then

1384: l_schema varchar2(30);
1385:
1386: begin
1387:
1388: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_RM_SUM_MAIN.WRAPUP_PROCESS;')) then
1389: return;
1390: end if;
1391:
1392: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 1689: end PJI_RM_SUM_MAIN;

1685: raise;
1686:
1687: end SUMMARIZE;
1688:
1689: end PJI_RM_SUM_MAIN;