[Home] [Help]
12: /* 07/13/2005 dlai - added parameter p_same_org_id_flag for R12 MOAC effort to remove
13: * dependency on pa_fp_org_fcst_utils.same_org_id
14: */
15: PROCEDURE identify_plan_version_id(
16: p_project_id IN pa_projects_all.project_id%TYPE,
17: p_function_code IN VARCHAR2,
18: p_context IN VARCHAR2 DEFAULT NULL,
19: p_user_id IN NUMBER,
20: p_same_org_id_flag IN VARCHAR2, -- Bug 5276024: Making this field mandatory -- DEFAULT 'N',
32: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
33: l_edit_in_excel_flag VARCHAR2(1) := 'N';
34: l_no_of_fcst_plan_types NUMBER;
35: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;
36: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(2000);
39: l_data VARCHAR2(2000);
40: l_msg_index_out NUMBER;
111: SELECT NVL(Baseline_Funding_Flag,'N')
112: INTO
113: l_baseline_funding_flag
114: FROM
115: Pa_Projects_All WHERE Project_Id = p_project_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
637: exist, then the URL will be returned with the error message and the information
638: for page. */
639:
640: PROCEDURE get_app_budget_pt_id(
641: p_project_id IN pa_projects_all.project_id%TYPE,
642: p_version_type IN pa_budget_versions.version_type%TYPE,
643: p_context IN VARCHAR2,
644: p_function_code IN VARCHAR2 DEFAULT NULL,
645: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
795: /* This API identifies the FORECAST budget plan type based on the shortcut
796: option selected in the Project Home. If the plan type does not exist, then
797: the URL will be returned with appropriate information. */
798: PROCEDURE get_fcst_plan_type_id(
799: p_project_id IN pa_projects_all.project_id%TYPE,
800: p_version_type IN pa_budget_versions.version_type%TYPE,
801: p_context IN VARCHAR2,
802: p_function_code IN VARCHAR2 DEFAULT NULL,
803: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
954: error message and appropriate page information. If the CW version is available, but
955: if the version is either locked or in submitted status, then the URL will be set
956: for Budgeting and Forecasting page with appropriate error message. */
957:
958: PROCEDURE get_cw_version( p_project_id IN pa_projects_all.project_id%TYPE,
959: p_plan_class_code in pa_fin_plan_types_b.plan_class_Code%type,
960: p_version_type IN pa_budget_versions.version_type%TYPE,
961: p_fin_plan_type_id in pa_fin_plan_types_b.fin_plan_type_id%TYPE,
962: p_edit_in_excel_Flag IN varchar2,