APPS.PA_RES_LIST_UPGRADE_PKG dependencies on PA_RES_FORMATS_B

Line 138: FROM pa_res_formats_b fmt, pa_resource_classes_b cls,pa_plan_res_defaults def,

134: cursor res_class_csr is
135: SELECT fmt.resource_class_id,cls.resource_class_code,fmt.res_format_id,
136: def.spread_curve_id, def.etc_method_code, def.mfc_cost_type_id,
137: def.object_id,def.object_type,b.res_type_code
138: FROM pa_res_formats_b fmt, pa_resource_classes_b cls,pa_plan_res_defaults def,
139: pa_res_types_b b
140: WHERE fmt.resource_class_flag = 'Y'
141: AND fmt.resource_class_id = cls.resource_class_id
142: AND def.resource_class_id = cls.resource_class_id

Line 181: cursor res_list_form_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type,c_res_for_id pa_res_formats_b.res_format_id%type) is

177: FROM pa_resource_classes_tl t,pa_resource_classes_b c
178: WHERE t.resource_class_id = c.resource_class_id
179: AND language = userenv('LANG');
180:
181: cursor res_list_form_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type,c_res_for_id pa_res_formats_b.res_format_id%type) is
182: SELECT 'Y'
183: FROM pa_plan_rl_formats
184: WHERE resource_list_id = c_res_list_id
185: AND res_format_id = c_res_for_id;

Line 213: TYPE res_class_flag_tbl is table of pa_res_formats_b.resource_class_flag%TYPE

209: TYPE res_class_id_tbl is table of pa_resource_classes_b.resource_class_id%TYPE
210: index by binary_integer;
211: l_res_class_id_tbl res_class_id_tbl;
212:
213: TYPE res_class_flag_tbl is table of pa_res_formats_b.resource_class_flag%TYPE
214: index by binary_integer;
215: l_res_class_flag_tbl res_class_flag_tbl;
216:
217: TYPE res_for_id_tbl is TABLE of pa_res_formats_b.res_format_id%type

Line 217: TYPE res_for_id_tbl is TABLE of pa_res_formats_b.res_format_id%type

213: TYPE res_class_flag_tbl is table of pa_res_formats_b.resource_class_flag%TYPE
214: index by binary_integer;
215: l_res_class_flag_tbl res_class_flag_tbl;
216:
217: TYPE res_for_id_tbl is TABLE of pa_res_formats_b.res_format_id%type
218: index by binary_integer;
219: l_res_for_id_tbl res_for_id_tbl;
220:
221: TYPE rev_cat_tbl is table of pa_resource_list_members.revenue_category%type

Line 239: l_res_format_id pa_res_formats_b.res_format_id%type;

235: l_res_format_tbl res_format_tbl;
236:
237: l_res_format_id_exists varchar2(1) := 'N';
238: l_stage VARCHAR2(240) :='';
239: l_res_format_id pa_res_formats_b.res_format_id%type;
240: l_org_id pa_resource_list_members.organization_id%type;
241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;

Line 591: FROM pa_res_formats_b

587: end if;
588:
589: SELECT nvl(incurred_by_enabled_flag, 'N')
590: INTO l_incur_by_res_flag
591: FROM pa_res_formats_b
592: WHERE res_format_id = l_res_format_id;
593:
594: IF l_debug_mode = 'Y' THEN
595: pa_debug.g_err_stage := 'Updating pa_resource_list_members table';