[Home] [Help]
297: if (l_row_count = 0) then
298:
299: for x in 2 .. l_parallel_processes loop
300:
301: update PJI_SYSTEM_PRC_STATUS
302: set STEP_STATUS = 'C'
303: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
304: STEP_NAME =
305: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);' and
777: if (l_row_count = 0) then
778:
779: for x in 2 .. l_parallel_processes loop
780:
781: update PJI_SYSTEM_PRC_STATUS
782: set STEP_STATUS = 'C'
783: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
784: STEP_NAME =
785: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);' and
2465: if (l_row_count = 0) then
2466:
2467: for x in 2 .. l_parallel_processes loop
2468:
2469: update PJI_SYSTEM_PRC_STATUS
2470: set STEP_STATUS = 'C'
2471: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
2472: STEP_NAME =
2473: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);' and
3685: if (l_row_count = 0) then
3686:
3687: for x in 2 .. l_parallel_processes loop
3688:
3689: update PJI_SYSTEM_PRC_STATUS
3690: set STEP_STATUS = 'C'
3691: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
3692: STEP_NAME =
3693: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);' and