APPS.PA_BUDGET_ATTR_UPGR_PKG dependencies on PA_PROJECTS_ALL

Line 5: P_PROJECT_ID IN pa_projects_all.project_id%type

1: package body PA_BUDGET_ATTR_UPGR_PKG AS
2: /* $Header: PABDGATB.pls 120.0 2005/05/30 11:28:12 appldev noship $ */
3:
4: procedure BUDGET_ATTR_UPGRD(
5: P_PROJECT_ID IN pa_projects_all.project_id%type
6: , p_budget_version_id IN pa_budget_versions.budget_version_id%type
7: , X_RETURN_STATUS OUT NOCOPY VARCHAR2
8: , X_MSG_COUNT OUT NOCOPY NUMBER
9: , X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 13: cursor get_fin_plan_ver_csr(c_project_id pa_projects_all.project_id%type

9: , X_MSG_DATA OUT NOCOPY VARCHAR2) IS
10:
11: --Bug 4185180.Given a budget version id as parameter the cursor should bring the PLAN_VERSION, PLAN_TYPE level records for that
12: -- project and budget version.
13: cursor get_fin_plan_ver_csr(c_project_id pa_projects_all.project_id%type
14: , c_budget_version_id pa_budget_versions.budget_version_id%type) is
15: select proj_fp_options_id,fin_plan_version_id,pfo.project_id,
16: fin_plan_option_level_code,cost_time_phased_code,fin_plan_preference_code preference_code,
17: revenue_time_phased_code,all_time_phased_code,cost_period_mask_id,

Line 91: l_project_start_date pa_projects_all.start_date%TYPE := NULL;

87:
88:
89: -- Bug 3804286, 12-AUG-04, jwhite -----------------------------------------------
90:
91: l_project_start_date pa_projects_all.start_date%TYPE := NULL;
92: l_org_id pa_projects_all.org_id%TYPE := NULL;
93: l_PA_period_type pa_implementations_all.pa_period_type%TYPE := NULL;
94: l_GL_period_type gl_sets_of_books.accounted_period_type%TYPE := NULL;
95:

Line 92: l_org_id pa_projects_all.org_id%TYPE := NULL;

88:
89: -- Bug 3804286, 12-AUG-04, jwhite -----------------------------------------------
90:
91: l_project_start_date pa_projects_all.start_date%TYPE := NULL;
92: l_org_id pa_projects_all.org_id%TYPE := NULL;
93: l_PA_period_type pa_implementations_all.pa_period_type%TYPE := NULL;
94: l_GL_period_type gl_sets_of_books.accounted_period_type%TYPE := NULL;
95:
96: -- End Bug 3804286, 12-AUG-04, jwhite --------------------------------------------

Line 239: FROM pa_projects_all

235: -- Find Project Start Date and Org_id.
236: -- The Project Record MUST Exist. RAISE error if not found.
237: SELECT start_date, nvl(org_id,-99)
238: INTO l_project_start_date, l_org_id
239: FROM pa_projects_all
240: WHERE project_id = l_get_fin_plan_ver_csr.project_id;
241:
242: exception
243: WHEN NO_DATA_FOUND THEN