APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_RM_SUM_MAIN

Line 985: l_max_date := PJI_RM_SUM_MAIN.g_max_date;

981: l_row_count <> 0) then
982: return;
983: end if;
984:
985: l_max_date := PJI_RM_SUM_MAIN.g_max_date;
986: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
987:
988: insert into PJI_ROWID_RESOURCES_DENORM
989: (

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

1272: from
1273: dual;
1274:
1275: -- PJP summarization tables with persistent data
1276: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1277: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_RM_SUM_MAIN.g_process || '%$%') or
1278: NAME like 'DANGLING_PJI_ROWS_EXIST' or
1279: NAME like 'LAST_PJI_EXTR_DATE';
1280:

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

1273: dual;
1274:
1275: -- PJP summarization tables with persistent data
1276: delete from PJI_MT_PRC_STEPS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1277: delete from PJI_SYSTEM_PARAMETERS where NAME like (PJI_RM_SUM_MAIN.g_process || '%$%') or
1278: NAME like 'DANGLING_PJI_ROWS_EXIST' or
1279: NAME like 'LAST_PJI_EXTR_DATE';
1280:
1281: -- PJI facts

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

1288: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_PROJ_F', 'NORMAL', null);
1289: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_AC_PROJ_F', 'NORMAL', null);
1290:
1291: -- PJP intermediate summarization tables
1292: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1293:
1294: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJECT_CLASSES', 'NORMAL', null);
1295: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RESOURCES_DENORM', 'NORMAL', null); Commented for bug 13011859 */
1296: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RM_WORK_TYPE_INFO', 'NORMAL', null);