[Home] [Help]
3428: ,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
3429: ,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
3430: ,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
3431: ,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
3432: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3433: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3434: ,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
3435: ,p_cost_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether cost can be implemented or not.
3436: ,p_rev_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether rev can be implemented or not.
3469: l_cost_impact_impl_flag VARCHAR2(1);
3470: l_rev_impact_impl_flag VARCHAR2(1);
3471: l_partially_impl_flag VARCHAR2(1);
3472: l_agreement_num pa_agreements_all.agreement_num%TYPE;
3473: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3474: l_call_rep_lines_api VARCHAR2(1):='N';
3475: l_id_before_bl_insertion pa_budget_lines.budget_line_id%TYPE;
3476: l_id_after_bl_insertion pa_budget_lines.budget_line_id%TYPE;
3477: l_dummy NUMBER;
11022: l_cost_impact_impl_flag VARCHAR2(1);
11023: l_rev_impact_impl_flag VARCHAR2(1);
11024: l_partially_impl_flag VARCHAR2(1);
11025: l_agreement_num pa_agreements_all.agreement_num%TYPE;
11026: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11027: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11028: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11029: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11030: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
11025: l_agreement_num pa_agreements_all.agreement_num%TYPE;
11026: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11027: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11028: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11029: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11030: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
11031: l_total_amount NUMBER;
11032: l_implemented_amount NUMBER;
11033: l_remaining_amount NUMBER;
12242:
12243: 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
12244: ,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
12245: ,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
12246: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12247: ,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
12248: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
12249: ,p_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N
12250: ,p_funding_category IN VARCHAR2 DEFAULT NULL -- The funding category for the agreement