[Home] [Help]
824: return;
825:
826: end if;
827: /* Bug 3756079:-dbora- The following piece of code flips the value of
828: * inclusion_method_code and creation_date in pa_fp_merged_ctrl_items for the existing
829: * working version and the newly created baselined version as this value
830: * would be used in the view included change document page to show various
831: * change documents included in that version
832: */
836: END IF;
837:
838: SELECT ci_id, inclusion_method_code, version_type, creation_date
839: BULK COLLECT INTO l_temp_ci_id_tbl, l_tmp_incl_method_code_tbl, l_version_type_tbl, l_cw_creation_date_tbl
840: FROM pa_fp_merged_ctrl_items
841: WHERE plan_version_id = p_budget_version_id
842: AND project_id = p_project_id;
843:
844: -- selecting creation_date for the baselined version
843:
844: -- selecting creation_date for the baselined version
845: SELECT creation_date
846: BULK COLLECT INTO l_bl_creation_date_tbl
847: FROM pa_fp_merged_ctrl_items
848: WHERE plan_version_id = l_target_version_id
849: AND project_id = p_project_id;
850:
851: IF P_PA_DEBUG_MODE = 'Y' THEN
854: END IF;
855: -- Flipping inclusion_method_code, creation_date, Updating the WHO columns for the baselined version
856: IF l_temp_ci_id_tbl.COUNT > 0 THEN
857: FORALL i in l_temp_ci_id_tbl.FIRST..l_temp_ci_id_tbl.LAST
858: UPDATE pa_fp_merged_ctrl_items
859: SET inclusion_method_code = l_tmp_incl_method_code_tbl(i),
860: creation_date = l_cw_creation_date_tbl(i),
861: last_update_login = FND_GLOBAL.login_id,
862: last_updated_by = FND_GLOBAL.user_id,
869:
870: -- Flipping inclusion_method_code, creation_date, Updating the WHO columns for the working version
871: IF l_temp_ci_id_tbl.COUNT > 0 THEN
872: FORALL i in l_temp_ci_id_tbl.FIRST..l_temp_ci_id_tbl.LAST
873: UPDATE pa_fp_merged_ctrl_items
874: SET inclusion_method_code = 'COPIED',
875: creation_date = l_bl_creation_date_tbl(i),
876: last_update_login = FND_GLOBAL.login_id,
877: last_updated_by = FND_GLOBAL.user_id,
1626: Bug 3106741 For better performance the cursoe has been spilt into c1 and c2.
1627: Cursor c1 would be opened if p_to_bv_id is not null.
1628: Cursor c2 would be opened if p_to_bv_id is null.
1629:
1630: Modified for 3550073. Selected the amount columns in pa_fp_merged_ctrl_items in the
1631: cursors
1632: */
1633:
1634: PROCEDURE Get_Included_Ci
1656: decode(f.version_type,'REVENUE',f.impl_quantity,NULL) impl_rev_ppl_qty,
1657: decode(f.version_type,'REVENUE',f.impl_equipment_quantity,NULL) impl_rev_equip_qty,
1658: f.impl_agr_revenue impl_agr_revenue,
1659: pbv.rev_partially_impl_flag rev_partially_impl_flag
1660: from pa_fp_merged_ctrl_items f,
1661: pa_ci_impacts im ,
1662: pa_budget_versions pbv
1663: where f.plan_version_id = p_from_bv_id
1664: and pbv.budget_version_id=f.ci_plan_version_id
1669: 'FINPLAN_COST','COST',
1670: 'FINPLAN_REVENUE','REVENUE') = f.version_type
1671: and f.project_id=pbv.project_id
1672: and not exists
1673: (select 'x' from pa_fp_merged_ctrl_items t
1674: where t.plan_version_id = p_to_bv_id
1675: and t.ci_id = f.ci_id
1676: and f.version_type = t.version_type
1677: and t.ci_plan_version_id = f.ci_plan_version_id
1691: decode(f.version_type,'REVENUE',f.impl_quantity,NULL) impl_rev_ppl_qty,
1692: decode(f.version_type,'REVENUE',f.impl_equipment_quantity,NULL) impl_rev_equip_qty,
1693: f.impl_agr_revenue impl_agr_revenue,
1694: pbv.rev_partially_impl_flag rev_partially_impl_flag
1695: from pa_fp_merged_ctrl_items f,
1696: pa_ci_impacts im,
1697: pa_budget_versions pbv
1698: where f.plan_version_id = p_from_bv_id
1699: and pbv.budget_version_id=f.ci_plan_version_id