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 572: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');

568:
569:
570:
571: -- PJP summarization tables with persistent data
572: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
573: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_PJP_SUM_MAIN.g_process || '%$%') or
574: NAME like 'PJI_FPM_UPGRADE' or
575: NAME like 'PJI_PTC_UPGRADE' or /*4882640 */
576: NAME like 'PJP_FPM_UPGRADE_DATE' or

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

569:
570:
571: -- PJP summarization tables with persistent data
572: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
573: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_PJP_SUM_MAIN.g_process || '%$%') or
574: NAME like 'PJI_FPM_UPGRADE' or
575: NAME like 'PJI_PTC_UPGRADE' or /*4882640 */
576: NAME like 'PJP_FPM_UPGRADE_DATE' or
577: NAME like 'LAST_PJP_EXTR_DATE%';

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

581: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_XBS_ACCUM_F', 'NORMAL', null);
582: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_AC_XBS_ACCUM_F', 'NORMAL', null);
583:
584: -- PJP intermediate summarization tables
585: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
586: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', 'NORMAL', null);
587: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'PLANTYPE_UPG'; /*4882640 */
588: -------------------
589: