APPS.PA_RATE_ATTR_PKG dependencies on PA_VARCHAR2_1_TBL_TYPE

Line 60: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

56: index by binary_integer;
57: l_min_date_tbl min_date_tbl;
58:
59:
60: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
61: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
62: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
63: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
64: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 84: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

80: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
81: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
82: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
83: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
84: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
85: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
86: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
87: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
88: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 89: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

85: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
86: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
87: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
88: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
89: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
90: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
91: l_rate_exp_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
92: l_sys_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
93: l_msg_data VARCHAR2(2000);

Line 137: l_resource_class_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

133: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
134: end if;
135:
136: l_sys_rlm_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
137: l_resource_class_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
138: l_resource_class_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
139: l_resource_class_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
140: l_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
141: l_incur_by_res_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 161: l_incurred_by_res_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

157: l_supplier_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
158: l_spread_curve_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
159: l_etc_method_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
160: l_mfc_cost_type_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
161: l_incurred_by_res_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
162: l_incur_by_res_class_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
163: l_incur_by_role_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
164: l_unit_of_measure_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
165: l_org_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 166: l_rate_based_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

162: l_incur_by_res_class_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
163: l_incur_by_role_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
164: l_unit_of_measure_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
165: l_org_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
166: l_rate_based_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
167: l_rate_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
168: l_rate_exp_func_curr_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
169:
170: select spread_curve_id