APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PJI_PJP_SUM_MAIN

Line 22: p_worker_id > PJI_PJP_SUM_MAIN.g_parallel_processes or

18:
19: begin
20:
21: if (p_worker_id < 1 or
22: p_worker_id > PJI_PJP_SUM_MAIN.g_parallel_processes or
23: p_worker_id <> trunc(p_worker_id)) then
24: dbms_standard.raise_application_error(-20010, l_invalid_worker_id);
25: end if;
26:

Line 614: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');

610:
611:
612:
613: -- PJP summarization tables with persistent data
614: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
615: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_PJP_SUM_MAIN.g_process || '%$%') or
616: NAME like 'PJI_FPM_UPGRADE' or
617: NAME like 'PJI_PTC_UPGRADE' or /*4882640 */
618: NAME like 'PJP_FPM_UPGRADE_DATE' or

Line 615: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_PJP_SUM_MAIN.g_process || '%$%') or

611:
612:
613: -- PJP summarization tables with persistent data
614: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
615: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_PJP_SUM_MAIN.g_process || '%$%') or
616: NAME like 'PJI_FPM_UPGRADE' or
617: NAME like 'PJI_PTC_UPGRADE' or /*4882640 */
618: NAME like 'PJP_FPM_UPGRADE_DATE' or
619: NAME like 'LAST_PJP_EXTR_DATE%';

Line 627: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');

623: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_XBS_ACCUM_F', 'NORMAL', null);
624: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_AC_XBS_ACCUM_F', 'NORMAL', null);
625:
626: -- PJP intermediate summarization tables
627: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
628: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', 'NORMAL', null);
629: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'PLANTYPE_UPG'; /*4882640 */
630: -------------------
631: