[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
1752:
1753: IF l_ci_id IS NULL THEN
1754:
1755: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1756: DELETE FROM pa_fp_merged_ctrl_items
1757: WHERE project_id = l_project_id
1758: AND plan_version_id = l_budget_Version_id_tbl(i);
1759: ELSE --(l_ci_id IS NOT NULL )
1760:
1758: AND plan_version_id = l_budget_Version_id_tbl(i);
1759: ELSE --(l_ci_id IS NOT NULL )
1760:
1761: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1762: DELETE FROM pa_fp_merged_ctrl_items
1763: WHERE project_id = l_project_id
1764: AND ci_plan_version_id = l_budget_Version_id_tbl(i);
1765: END IF;
1766: END IF;
2247: ,x_msg_data => l_msg_data );
2248:
2249: -- Start of changes for BUG :- 2634900
2250: -- Copy the links from the links for the source plan version in the
2251: -- PA_FP_MERGED_CTRL_ITEMS table to the target version.
2252:
2253:
2254: pa_fp_ci_merge.copy_merged_ctrl_items
2255: ( p_project_id => p_project_id