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.13 2011/09/20 11:41:32 arbandyo ship $ */
3:
4: -- -----------------------------------------------------
5: -- procedure RUN_SETUP

Line 349: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

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

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

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

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

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

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

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

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

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

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

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

Line 1356: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

Line 1362: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

Line 1370: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

Line 1378: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,

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

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

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

Line 1525: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

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

Line 1700: end PJI_FM_SUM_MAIN;

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