APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_SYSTEM_PRC_STATUS

Line 6354: from PJI_SYSTEM_PRC_STATUS

6350: end if ;
6351:
6352: select STEP_SEQ
6353: into l_step_seq
6354: from PJI_SYSTEM_PRC_STATUS
6355: where PROCESS_NAME = l_process and
6356: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);';
6357:
6358: select count(*)

Line 6360: from PJI_SYSTEM_PRC_STATUS

6356: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);';
6357:
6358: select count(*)
6359: into l_count
6360: from PJI_SYSTEM_PRC_STATUS
6361: where PROCESS_NAME = l_process and
6362: STEP_NAME like 'ROLLUP_FPR_WBS%';
6363:
6364: if (l_count = 0) then

Line 6385: insert /*+ NOAPPEND */ into PJI_SYSTEM_PRC_STATUS sps

6381: l_level);
6382:
6383: for x in 1 .. l_level loop
6384:
6385: insert /*+ NOAPPEND */ into PJI_SYSTEM_PRC_STATUS sps
6386: (
6387: PROCESS_NAME,
6388: STEP_SEQ,
6389: STEP_STATUS,

Line 6416: PJI_SYSTEM_PRC_STATUS

6412: nvl(to_number(min(STEP_SEQ)), 0)
6413: into
6414: l_level_seq
6415: from
6416: PJI_SYSTEM_PRC_STATUS
6417: where
6418: PROCESS_NAME = l_process and
6419: STEP_NAME like 'ROLLUP_FPR_WBS%' and
6420: STEP_STATUS is null;

Line 6430: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */ PJI_SYSTEM_PRC_STATUS sps

6426: end if;
6427:
6428: while (l_level > 0) loop
6429:
6430: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */ PJI_SYSTEM_PRC_STATUS sps
6431: set START_DATE = sysdate
6432: where PROCESS_NAME = l_process and
6433: STEP_SEQ = l_level_seq;
6434:

Line 6441: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */ PJI_SYSTEM_PRC_STATUS

6437: l_level,
6438: l_partial_mode,
6439: l_fpm_upgrade);
6440:
6441: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */ PJI_SYSTEM_PRC_STATUS
6442: set STEP_STATUS = 'C',
6443: END_DATE = sysdate
6444: where PROCESS_NAME = l_process and
6445: STEP_SEQ = l_level_seq;

Line 6454: PJI_SYSTEM_PRC_STATUS

6450: nvl(to_number(min(STEP_SEQ)), 0)
6451: into
6452: l_level_seq
6453: from
6454: PJI_SYSTEM_PRC_STATUS
6455: where
6456: PROCESS_NAME = l_process and
6457: STEP_NAME like 'ROLLUP_FPR_WBS%' and
6458: STEP_STATUS is null;

Line 6586: from PJI_SYSTEM_PRC_STATUS

6582: end if;
6583:
6584: select count(*)
6585: into l_count
6586: from PJI_SYSTEM_PRC_STATUS
6587: where PROCESS_NAME = p_process and
6588: STEP_NAME = p_step;
6589:
6590: if (l_count = 0) then

Line 6598: from PJI_SYSTEM_PRC_STATUS

6594: select STEP_STATUS,
6595: STEP_SEQ
6596: into l_status,
6597: l_seq
6598: from PJI_SYSTEM_PRC_STATUS
6599: where PROCESS_NAME = p_process and
6600: STEP_NAME = p_step;
6601:
6602: if (l_status = 'C') then -- Step is complete, do not need to run it again.

Line 6606: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */ PJI_SYSTEM_PRC_STATUS

6602: if (l_status = 'C') then -- Step is complete, do not need to run it again.
6603: return false;
6604: else
6605:
6606: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */ PJI_SYSTEM_PRC_STATUS
6607: set START_DATE = sysdate
6608: where PROCESS_NAME = p_process and
6609: STEP_NAME = p_step and
6610: START_DATE is null;

Line 6633: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */

6629: else
6630: return;
6631: end if;
6632:
6633: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */
6634: PJI_SYSTEM_PRC_STATUS
6635: set STEP_STATUS = 'C',
6636: END_DATE = sysdate
6637: where PROCESS_NAME = p_process and

Line 6634: PJI_SYSTEM_PRC_STATUS

6630: return;
6631: end if;
6632:
6633: update /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */
6634: PJI_SYSTEM_PRC_STATUS
6635: set STEP_STATUS = 'C',
6636: END_DATE = sysdate
6637: where PROCESS_NAME = p_process and
6638: STEP_NAME = p_step;

Line 6650: delete /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */

6646: procedure WRAPUP_PROCESS (p_process in varchar2) is
6647:
6648: begin
6649:
6650: delete /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */
6651: from PJI_SYSTEM_PRC_STATUS
6652: where PROCESS_NAME = p_process;
6653:
6654: delete /*+ NO_PARALLEL(PJI_SYSTEM_PARAMETERS) */

Line 6651: from PJI_SYSTEM_PRC_STATUS

6647:
6648: begin
6649:
6650: delete /*+ NO_PARALLEL(PJI_SYSTEM_PRC_STATUS) */
6651: from PJI_SYSTEM_PRC_STATUS
6652: where PROCESS_NAME = p_process;
6653:
6654: delete /*+ NO_PARALLEL(PJI_SYSTEM_PARAMETERS) */
6655: from PJI_SYSTEM_PARAMETERS