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.15 2006/03/23 04:02:24 appldev noship $ */
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:
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:
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') then
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 1276: pji_utils.write2out(PJI_RM_SUM_MAIN.GET_MISSING_TIME_HEADER);

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

Line 1284: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

Line 1290: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

Line 1298: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

Line 1306: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

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

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

Line 1690: end PJI_RM_SUM_MAIN;

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