APPS.PJI_PJP_SUM_MAIN dependencies on PJI_FM_EXTR_PLNVER4

Line 951: EXISTS ( SELECT 1 from PJI_FM_EXTR_PLNVER4 ver where ver.worker_id = p_worker_id

947: PJI_XBS_DENORM den
948: where
949: STRUCT_TYPE = 'PRG' and
950: SUB_LEVEL = SUP_LEVEL and
951: EXISTS ( SELECT 1 from PJI_FM_EXTR_PLNVER4 ver where ver.worker_id = p_worker_id
952: and ver.project_id = den.SUP_PROJECT_ID)
953: group by
954: SUP_LEVEL
955: order by

Line 972: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;

968: -- pji_utils.write2log('plan_type_code changes exist count'||l_count);
969:
970: if l_count > 0 then
971:
972: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;
973: DELETE PJI_FP_AGGR_PJP1 where worker_id = p_worker_id;
974:
975: INSERT INTO PJI_FM_EXTR_PLNVER4
976: (

Line 975: INSERT INTO PJI_FM_EXTR_PLNVER4

971:
972: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;
973: DELETE PJI_FP_AGGR_PJP1 where worker_id = p_worker_id;
974:
975: INSERT INTO PJI_FM_EXTR_PLNVER4
976: (
977: WORKER_ID ,
978: PROJECT_ID ,
979: PLAN_VERSION_ID ,

Line 1072: INSERT INTO PJI_FM_EXTR_PLNVER4

1068:
1069: -- pji_utils.write2log('Inserted +ve records into ver4'||sql%rowcount);
1070: -- This sql will insert all the -3,-4 plan versions for Cost and Rev seperate plan_type_id
1071:
1072: INSERT INTO PJI_FM_EXTR_PLNVER4
1073: (
1074: WORKER_ID ,
1075: PROJECT_ID ,
1076: PLAN_VERSION_ID ,

Line 1111: FROM PJI_FM_EXTR_PLNVER4 bv

1107: , DECODE(cbco.plan_version_id, -4, 'Y', 'N') curr_original_flag
1108: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
1109: , bv.SECONDARY_RBS_FLAG
1110: , bv.lp_flag
1111: FROM PJI_FM_EXTR_PLNVER4 bv
1112: , pji_xbs_denorm den
1113: , ( SELECT -3 plan_version_id FROM DUAL
1114: UNION ALL
1115: SELECT -4 FROM DUAL ) cbco

Line 1131: and exists (select 1 from pji_fm_extr_plnver4 ver3

1127: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1128:
1129: DELETE pji_rollup_level_status hdr
1130: where hdr.plan_version_id < -1
1131: and exists (select 1 from pji_fm_extr_plnver4 ver3
1132: where ver3.worker_id = p_worker_id
1133: and ver3.project_id = hdr.project_id
1134: and ver3.plan_version_id = hdr.plan_version_id
1135: and ver3.plan_version_id < -1);

Line 1140: and exists (select 1 from pji_fm_extr_plnver4 ver3

1136:
1137:
1138: DELETE FROM pji_fp_xbs_accum_f fact
1139: WHERE fact.plan_version_id < -1
1140: and exists (select 1 from pji_fm_extr_plnver4 ver3
1141: where ver3.worker_id = p_worker_id
1142: and ver3.project_id = fact.project_id
1143: and ver3.plan_version_id = fact.plan_version_id
1144: and ver3.plan_type_id = fact.plan_type_id

Line 1314: , pji_fm_extr_plnver4 ver

1310: , SYSDATE
1311: , 0
1312: ,ver.PLAN_TYPE_CODE
1313: FROM pji_fp_xbs_accum_f f
1314: , pji_fm_extr_plnver4 ver
1315: WHERE 1 = 1
1316: AND ver.project_id = f.project_id
1317: AND ver.plan_version_id = f.plan_version_id
1318: AND ver.plan_type_id = f.plan_type_id

Line 2685: and exists (select 1 from pji_fm_extr_plnver4 ver

2681: -- pji_utils.write2log('Inserted records into fact'||sql%rowcount);
2682:
2683: DELETE pa_pji_proj_events_log log
2684: where log.event_type = 'PLANTYPE_UPG'
2685: and exists (select 1 from pji_fm_extr_plnver4 ver
2686: where ver.worker_id = p_worker_id and
2687: to_char(ver.project_id) = log.event_object);
2688:
2689:

Line 2692: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;

2688:
2689:
2690: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2691:
2692: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2693:
2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2695:
2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;

Line 2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);

2690: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2691:
2692: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2693:
2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2695:
2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2697:
2698: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);