DBA Data[Home] [Help]

APPS.PJI_FM_CMT_EXTR dependencies on PJI_SYSTEM_PRC_STATUS

Line 787: update PJI_SYSTEM_PRC_STATUS

783: if (l_extract_commitments = 'N' or (l_extract_commitments = 'Y' and l_psi_ppr_flag = 'Y')) then -- Changes for bug 13889383
784:
785: for x in 2 .. l_parallel_processes loop
786:
787: update PJI_SYSTEM_PRC_STATUS
788: set STEP_STATUS = 'C'
789: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
790: STEP_NAME =
791: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and

Line 964: update PJI_SYSTEM_PRC_STATUS

960: if (l_row_count = 0) then
961:
962: for x in 2 .. l_parallel_processes loop
963:
964: update PJI_SYSTEM_PRC_STATUS
965: set STEP_STATUS = 'C'
966: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
967: STEP_NAME =
968: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and