[Home] [Help]
419: pg.agreement_currency_code
420: INTO x_agreement_num,
421: x_agreement_amount,
422: x_agreement_currency_code
423: FROM pa_agreements_all pg, pa_budget_versions bv
424: WHERE
425: bv.project_id = p_project_id
426: and bv.ci_id = p_ci_id
427: and bv.agreement_id = pg.agreement_id
2266: RETURN;
2267: END IF;
2268:
2269: SELECT a.Agreement_Id INTO x_agreement_id FROM
2270: Pa_Agreements_All a,
2271: Pa_Summary_Project_Fundings spf
2272: WHERE
2273: a.agreement_num = p_agreement_number AND
2274: a.agreement_id = spf.agreement_id AND
2459: Impact Implementation page */
2460:
2461: FUNCTION Get_Funindg_Amount(
2462: p_project_id IN pa_projects_all.project_id%TYPE,
2463: p_agreement_id IN pa_agreements_all.agreement_id%TYPE)
2464: RETURN NUMBER IS
2465: l_funding_amount NUMBER := 0;
2466: BEGIN
2467: SELECT SUM(NVL(total_baselined_amount,0)) INTO
7906: X_cost_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for cost bv id --File.Sql.39 bug 4440895
7907: X_rev_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue bv id --File.Sql.39 bug 4440895
7908: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895
7909: 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
7910: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
7911: 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
7912: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
7913: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
7914: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
7992: l_submit_revenue_check VARCHAR2(1);
7993:
7994: -- Bug 11708214
7995: l_agreement_amount NUMBER;
7996: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
7997:
7998: BEGIN
7999:
8000: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
8636: ,x_rev_impl_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8637: ,X_cost_impact_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the cost impact is completely implemented --File.Sql.39 bug 4440895
8638: ,x_rev_impact_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the revenue impact is completely implemented --File.Sql.39 bug 4440895
8639: ,X_partially_impl_flag OUT NOCOPY VARCHAR2 -- Can be Y or N. Indicates whether a CI is partially implemented . --File.Sql.39 bug 4440895
8640: ,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
8641: ,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
8642: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
8643: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
8644: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
8698:
8699: l_app_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
8700:
8701: l_agreement_amount NUMBER;
8702: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
8703:
8704: l_ci_cost_version_id Pa_budget_versions.budget_version_id%TYPE;
8705: l_ci_rev_version_id Pa_budget_versions.budget_version_id%TYPE;
8706: l_ci_all_version_id Pa_budget_versions.budget_version_id%TYPE;