APPS.PJI_FM_SUM_MAIN dependencies on PJI_FM_SUM_MAIN

Line 1: package body PJI_FM_SUM_MAIN as

1: package body PJI_FM_SUM_MAIN as
2: /* $Header: PJISF01B.pls 120.12 2007/07/11 14:21:02 rvelusam ship $ */
3:
4: -- -----------------------------------------------------
5: -- procedure RUN_SETUP

Line 348: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

344: l_extraction_type := 'PARTIAL';
345: end if;
346:
347: l_transition_flag :=
348: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
349: 'TRANSITION');
350:
351: if (l_project_count = 0 or l_transition_flag = 'Y') then
352: l_extraction_type := 'FULL';

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

355: end if;
356:
357: PJI_PROCESS_UTIL.ADD_STEPS(g_process || 1, 'PJI_EXTR', l_extraction_type);
358:
359: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;')) then
360: rollback;
361: return;
362: end if;
363:

Line 763: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;');

759: 'GL_CALENDAR_FLAG',
760: 'Y');
761: end if;
762:
763: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;');
764:
765: commit;
766:
767: end INIT_PROCESS;

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

839: l_parallel_processes number;
840:
841: begin
842:
843: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;')) then
844: return;
845: end if;
846:
847: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 878: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;');

874: -- process finished
875:
876: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'N') then
877:
878: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;');
879:
880: commit;
881:
882: end if;

Line 1347: pji_utils.write2out(PJI_FM_SUM_MAIN.GET_MISSING_TIME_HEADER);

1343: if (l_header_flag = 'Y') then
1344:
1345: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');
1346:
1347: pji_utils.write2out(PJI_FM_SUM_MAIN.GET_MISSING_TIME_HEADER);
1348: l_header_flag := 'N';
1349: end if;
1350:
1351: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and

Line 1355: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1351: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and
1352: c.TO_DATE > c.CALENDAR_MAX_DATE) then
1353:
1354: pji_utils.write2out(
1355: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1356: c.USER_PERIOD_TYPE,
1357: c.FROM_DATE,
1358: c.CALENDAR_MIN_DATE));
1359:

Line 1361: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1357: c.FROM_DATE,
1358: c.CALENDAR_MIN_DATE));
1359:
1360: pji_utils.write2out(
1361: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1362: c.USER_PERIOD_TYPE,
1363: c.CALENDAR_MAX_DATE,
1364: c.TO_DATE));
1365:

Line 1369: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1365:
1366: elsif (c.TO_DATE > c.CALENDAR_MAX_DATE) then
1367:
1368: pji_utils.write2out(
1369: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1370: c.USER_PERIOD_TYPE,
1371: c.CALENDAR_MAX_DATE,
1372: c.TO_DATE));
1373:

Line 1377: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

1373:
1374: elsif (c.FROM_DATE < c.CALENDAR_MIN_DATE) then
1375:
1376: pji_utils.write2out(
1377: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1378: c.USER_PERIOD_TYPE,
1379: c.FROM_DATE,
1380: c.CALENDAR_MIN_DATE));
1381:

Line 1503: to_char(sysdate, PJI_FM_SUM_MAIN.g_date_mask));

1499:
1500: -- update default report as-of date
1501:
1502: PJI_UTILS.SET_PARAMETER('LAST_FM_EXTR_DATE',
1503: to_char(sysdate, PJI_FM_SUM_MAIN.g_date_mask));
1504:
1505: PJI_UTILS.SET_PARAMETER('LAST_EXTR_DATE',
1506: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'));
1507:

Line 1524: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

1520: begin
1521:
1522: rollback;
1523:
1524: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
1525: 'PROCESS_RUNNING',
1526: 'F');
1527:
1528: commit;

Line 1699: end PJI_FM_SUM_MAIN;

1695: END IF;
1696:
1697: end SUMMARIZE;
1698:
1699: end PJI_FM_SUM_MAIN;