APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_RM_SUM_MAIN

Line 933: l_max_date := PJI_RM_SUM_MAIN.g_max_date;

929: l_row_count <> 0) then
930: return;
931: end if;
932:
933: l_max_date := PJI_RM_SUM_MAIN.g_max_date;
934: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
935:
936: insert into PJI_ROWID_RESOURCES_DENORM
937: (

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

1220: from
1221: dual;
1222:
1223: -- PJP summarization tables with persistent data
1224: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1225: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_RM_SUM_MAIN.g_process || '%$%') or
1226: NAME like 'DANGLING_PJI_ROWS_EXIST' or
1227: NAME like 'LAST_PJI_EXTR_DATE';
1228:

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

1221: dual;
1222:
1223: -- PJP summarization tables with persistent data
1224: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1225: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_RM_SUM_MAIN.g_process || '%$%') or
1226: NAME like 'DANGLING_PJI_ROWS_EXIST' or
1227: NAME like 'LAST_PJI_EXTR_DATE';
1228:
1229: -- PJI facts

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

1236: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_PROJ_F', 'NORMAL', null);
1237: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_AC_PROJ_F', 'NORMAL', null);
1238:
1239: -- PJP intermediate summarization tables
1240: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1241:
1242: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJECT_CLASSES', 'NORMAL', null);
1243: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RESOURCES_DENORM', 'NORMAL', null);
1244: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RM_WORK_TYPE_INFO', 'NORMAL', null);