APPS.PA_BUDGET_ATTR_UPGR_PKG dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 31: cursor get_rbs_ver_csr(c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE) is

27: (pfo.project_id = p_project_id AND
28: fin_plan_option_level_code <> 'PLAN_VERSION' AND
29: nvl(pfo.fin_plan_type_id,-99)=nvl(pbv.fin_plan_type_id,-99))); /* So that the fetch/update is not done if project/plan type level record is already upgraded */
30:
31: cursor get_rbs_ver_csr(c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE) is
32: select migrated_rbs_version_id,uncategorized_flag from
33: pa_resource_lists_all_bg
34: where resource_list_id = c_resource_list_id;
35:

Line 33: pa_resource_lists_all_bg

29: nvl(pfo.fin_plan_type_id,-99)=nvl(pbv.fin_plan_type_id,-99))); /* So that the fetch/update is not done if project/plan type level record is already upgraded */
30:
31: cursor get_rbs_ver_csr(c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE) is
32: select migrated_rbs_version_id,uncategorized_flag from
33: pa_resource_lists_all_bg
34: where resource_list_id = c_resource_list_id;
35:
36:
37: cursor get_per_mask_id_csr is

Line 44: cursor get_rbs_header_csr (c_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type)

40:
41:
42: -- Bug 3800485, 28-JUL-04, jwhite -----------------------------------------------
43:
44: cursor get_rbs_header_csr (c_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type)
45: is
46: SELECT RBS_HEADER_ID
47: FROM pa_rbs_versions_b
48: WHERE RBS_VERSION_ID = c_rbs_version_id;

Line 57: TYPE get_rbs_ver_tbl is table of pa_resource_lists_all_bg.migrated_rbs_version_id%type

53: TYPE get_per_mask_tbl is table of number
54: index by binary_integer;
55: l_get_per_mask_tbl get_per_mask_tbl;
56:
57: TYPE get_rbs_ver_tbl is table of pa_resource_lists_all_bg.migrated_rbs_version_id%type
58: index by binary_integer;
59: l_get_rbs_ver_tbl get_rbs_ver_tbl;
60:
61: l_period_mask_id pa_period_masks_b.period_mask_id%type;

Line 64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;

60:
61: l_period_mask_id pa_period_masks_b.period_mask_id%type;
62: l_curr_plan_period pa_budget_versions.current_planning_period%type;
63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;
64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;

Line 98: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Bug 3935863

94: l_GL_period_type gl_sets_of_books.accounted_period_type%TYPE := NULL;
95:
96: -- End Bug 3804286, 12-AUG-04, jwhite --------------------------------------------
97:
98: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Bug 3935863
99:
100: --Bug 3977417.These variables will be used for cost and rev separate options. They will have the
101: --Current Planning Period(cpp) for GL/PA time phasing.
102: l_cpp_for_gl_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;