[Home] [Help]
2784: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
2785: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
2786: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed
2787: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
2788: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2789: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
2790: ,P_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
2791: ,p_cost_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether cost can be implemented or not.
2792: ,p_rev_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether rev can be implemented or not.
2825: l_cost_impact_impl_flag VARCHAR2(1);
2826: l_rev_impact_impl_flag VARCHAR2(1);
2827: l_partially_impl_flag VARCHAR2(1);
2828: l_agreement_num pa_agreements_all.agreement_num%TYPE;
2829: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
2830: l_call_rep_lines_api VARCHAR2(1):='N';
2831: l_id_before_bl_insertion pa_budget_lines.budget_line_id%TYPE;
2832: l_id_after_bl_insertion pa_budget_lines.budget_line_id%TYPE;
2833: l_dummy NUMBER;
10428: l_cost_impact_impl_flag VARCHAR2(1);
10429: l_rev_impact_impl_flag VARCHAR2(1);
10430: l_partially_impl_flag VARCHAR2(1);
10431: l_agreement_num pa_agreements_all.agreement_num%TYPE;
10432: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10433: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10434: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10435: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
10431: l_agreement_num pa_agreements_all.agreement_num%TYPE;
10432: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10433: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10434: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10435: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
10437: l_total_amount NUMBER;
10438: l_implemented_amount NUMBER;
10439: l_remaining_amount NUMBER;
11718:
11719: PROCEDURE impl_ci_into_autobaseline_proj( p_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
11720: ,p_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
11721: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
11722: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
11723: ,p_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
11724: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
11725: ,p_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N
11726: ,p_funding_category IN VARCHAR2 DEFAULT NULL -- The funding category for the agreement