[Home] [Help]
395: pg.agreement_currency_code
396: INTO x_agreement_num,
397: x_agreement_amount,
398: x_agreement_currency_code
399: FROM pa_agreements_all pg, pa_budget_versions bv
400: WHERE
401: bv.project_id = p_project_id
402: and bv.ci_id = p_ci_id
403: and bv.agreement_id = pg.agreement_id
2232: RETURN;
2233: END IF;
2234:
2235: SELECT a.Agreement_Id INTO x_agreement_id FROM
2236: Pa_Agreements_All a,
2237: Pa_Summary_Project_Fundings spf
2238: WHERE
2239: a.agreement_num = p_agreement_number AND
2240: a.agreement_id = spf.agreement_id AND
2425: Impact Implementation page */
2426:
2427: FUNCTION Get_Funindg_Amount(
2428: p_project_id IN pa_projects_all.project_id%TYPE,
2429: p_agreement_id IN pa_agreements_all.agreement_id%TYPE)
2430: RETURN NUMBER IS
2431: l_funding_amount NUMBER := 0;
2432: BEGIN
2433: SELECT SUM(NVL(total_baselined_amount,0)) INTO
7816: X_cost_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for cost bv id --File.Sql.39 bug 4440895
7817: X_rev_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue bv id --File.Sql.39 bug 4440895
7818: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895
7819: X_select_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- The flag which indicates whether the select flag can be checked by default or not --File.Sql.39 bug 4440895
7820: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
7821: X_partially_impl_flag OUT NOCOPY VARCHAR2, -- A flag that indicates whether a partially implemented CO exists for the plan type or not. Possible values are Y/N --File.Sql.39 bug 4440895
7822: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
7823: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
7824: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
8504: ,x_rev_impl_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8505: ,X_cost_impact_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the cost impact is completely implemented --File.Sql.39 bug 4440895
8506: ,x_rev_impact_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the revenue impact is completely implemented --File.Sql.39 bug 4440895
8507: ,X_partially_impl_flag OUT NOCOPY VARCHAR2 -- Can be Y or N. Indicates whether a CI is partially implemented . --File.Sql.39 bug 4440895
8508: ,x_agreement_num OUT NOCOPY pa_agreements_all.agreement_num%TYPE -- Agreement Number. Has meaning only in the context of an approved revenue plan type. --File.Sql.39 bug 4440895
8509: ,x_approved_fin_pt_id OUT NOCOPY Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- If p_fin_plan_type_id is an approved revenue plan type, this is equal to p_fin_plan_type_id --File.Sql.39 bug 4440895
8510: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
8511: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
8512: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
8566:
8567: l_app_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
8568:
8569: l_agreement_amount NUMBER;
8570: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
8571:
8572: l_ci_cost_version_id Pa_budget_versions.budget_version_id%TYPE;
8573: l_ci_rev_version_id Pa_budget_versions.budget_version_id%TYPE;
8574: l_ci_all_version_id Pa_budget_versions.budget_version_id%TYPE;