[Home] [Help]
233: , 'N'
234: ) lp_flag
235: FROM
236: pji_pjp_proj_batch_map map,
237: pji_pjp_rbs_header rhd,
238: pa_budget_versions bv,
239: pa_proj_fp_options fpo,
240: pji_pa_proj_events_log pel,
241: pa_projects_all ppa,
295: , 'N'
296: ) lp_flag
297: FROM
298: PJI_PJP_PROJ_BATCH_MAP map,
299: PJI_PJP_RBS_HEADER rhd,
300: PA_BUDGET_VERSIONS bv,
301: PA_PROJ_FP_OPTIONS fpo,
302: PJI_PA_PROJ_EVENTS_LOG pel,
303: PA_RBS_PRJ_ASSIGNMENTS rpa,
357: , 'N' SECONDARY_RBS_FLAG
358: , 'Y' lp_flag
359: FROM
360: PJI_PJP_PROJ_BATCH_MAP map,
361: PJI_PJP_RBS_HEADER rhd,
362: PA_BUDGET_VERSIONS bv,
363: PA_PROJ_FP_OPTIONS fpo,
364: PJI_PA_PROJ_EVENTS_LOG pel,
365: PA_RBS_PRJ_ASSIGNMENTS rpa,
804: FROM
805: pji_pjp_proj_batch_map map
806: , PA_PROJECTS_ALL ppa
807: , pji_pjp_wbs_header whd
808: , pji_pjp_rbs_header rhd
809: WHERE 1=1
810: AND ppa.project_id = map.project_id
811: -- AND map.PROJECT_ACTIVE_FLAG = 'Y'
812: AND map.worker_id = g_worker_id
840: FROM
841: pji_pjp_proj_batch_map map
842: , PA_PROJECTS_ALL ppa
843: , pji_pjp_wbs_header whd
844: , pji_pjp_rbs_header rhd
845: WHERE 1=1
846: AND ppa.project_id = map.project_id
847: -- AND map.PROJECT_ACTIVE_FLAG = 'Y'
848: AND map.worker_id = g_worker_id
875:
876:
877: IF (p_context = 'RBS') THEN
878:
879: DELETE FROM pji_pjp_rbs_header -- Old RBS versions are to be replaced with new ones.
880: WHERE 1=1
881: AND rbs_version_id in (select rbs_version_id
882: from pa_rbs_versions_b
883: where rbs_header_id = l_rbs_header_id) --Modified for Bug#5728852 by VVJOSHI
2431: AND ev.event_type = 'RBS_ASSOC'
2432: AND bv.project_id = TO_NUMBER(ev.attribute1)
2433: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
2434: ( SELECT 1
2435: FROM pji_pjp_rbs_header rh
2436: WHERE rh.project_id = bv.project_id
2437: AND rh.plan_version_id = cbcov.plan_version_id
2438: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
2439: )
2505: AND hd1.plan_version_id > 0
2506: -- AND hd2.plan_version_id > 0
2507: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
2508: ( SELECT 1
2509: FROM pji_pjp_rbs_header rh
2510: WHERE rh.project_id = bv.project_id
2511: AND rh.plan_version_id = bv.budget_version_id
2512: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
2513: )
2580: AND hd1.plan_version_id > 0
2581: -- AND hd2.plan_version_id > 0
2582: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
2583: ( SELECT 1
2584: FROM pji_pjp_rbs_header rh
2585: WHERE rh.project_id = bv.project_id
2586: AND rh.plan_version_id = cbcov.plan_version_id
2587: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
2588: )
6922: ,fact1.PLAN_TYPE_CODE /*4471527 */
6923: FROM pji_fp_aggr_pjp1 fact1
6924: , Pji_RBS_DENORM rbs
6925: , pji_rollup_level_status smart
6926: , pji_pjp_rbs_header rhdr
6927: WHERE 1 = 1
6928: AND fact1.project_id = rhdr.project_id
6929: AND fact1.plan_version_id = rhdr.plan_version_id
6930: AND fact1.plan_type_code = rhdr.plan_type_code /*4471527 */
7184: BEGIN
7185:
7186: print_time ( ' Before update rbs header ' );
7187:
7188: INSERT INTO pji_pjp_rbs_header
7189: (
7190: project_id
7191: , plan_version_id
7192: , rbs_version_id
7215: , bv.plan_type_code
7216: FROM
7217: PJI_FM_EXTR_PLNVER4 bv,
7218: PA_RBS_PRJ_ASSIGNMENTS rpa,
7219: PJI_PJP_RBS_HEADER head
7220: WHERE bv.project_id = rpa.project_id
7221: AND bv.worker_id = g_worker_id
7222: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID
7223: AND bv.PROJECT_ID = head.PROJECT_ID (+)
8326: , pa_resource_asSIGNments ra
8327: , PA_BUDGET_LINES bl
8328: , pa_projects_all ppa
8329: , PJI_ORG_EXTR_INFO oei
8330: , pji_pjp_rbs_header rhdr
8331: , pji_time_cal_period_v prd
8332: , PJI_FM_AGGR_DLY_RATES rates
8333: , pji_fp_txn_accum_header hdr
8334: , pa_rbs_txn_accum_map map
8634: PJI_FM_EXTR_PLNVER4 ver
8635: , pa_resource_asSIGNments ra
8636: , PA_BUDGET_LINES bl
8637: , pa_projects_all ppa
8638: , pji_pjp_rbs_header rhdr
8639: , PJI_FM_AGGR_DLY_RATES rates
8640: , pji_fp_txn_accum_header hdr
8641: , pa_rbs_txn_accum_map map
8642: , PA_PROJ_ELEM_VER_STRUCTURE pevs