[Home] [Help]
460: and eligible.ci_version_type = l_version_type
461: and eligible.project_system_status_code IN ('CI_APPROVED','CI_SUBMITTED')
462: -- filter cis that are already part of target cur working version
463: and eligible.ci_id not in (select merged.ci_id
464: from pa_fp_merged_ctrl_items merged
465: where merged.plan_version_id = p_budget_version_id
466: and merged.project_id = p_project_id
467: )
468: -- filter cis included in current baseline version
466: and merged.project_id = p_project_id
467: )
468: -- filter cis included in current baseline version
469: and eligible.ci_id not in (select merged.ci_id
470: from pa_fp_merged_ctrl_items merged,
471: pa_budget_versions cur_baseline
472: where cur_baseline.project_id = p_project_id
473: and cur_baseline.fin_plan_type_id = l_fin_plan_type_id
474: and cur_baseline.version_type = l_version_type
1768:
1769: IF l_ci_id IS NULL THEN
1770:
1771: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1772: DELETE FROM pa_fp_merged_ctrl_items
1773: WHERE project_id = l_project_id
1774: AND plan_version_id = l_budget_Version_id_tbl(i);
1775: ELSE --(l_ci_id IS NOT NULL )
1776:
1774: AND plan_version_id = l_budget_Version_id_tbl(i);
1775: ELSE --(l_ci_id IS NOT NULL )
1776:
1777: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1778: DELETE FROM pa_fp_merged_ctrl_items
1779: WHERE project_id = l_project_id
1780: AND ci_plan_version_id = l_budget_Version_id_tbl(i);
1781: END IF;
1782: END IF;
2263: ,x_msg_data => l_msg_data );
2264:
2265: -- Start of changes for BUG :- 2634900
2266: -- Copy the links from the links for the source plan version in the
2267: -- PA_FP_MERGED_CTRL_ITEMS table to the target version.
2268:
2269:
2270: pa_fp_ci_merge.copy_merged_ctrl_items
2271: ( p_project_id => p_project_id