DBA Data[Home] [Help]

APPS.PA_RATE_ATTR_PKG dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 61: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
65: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 63: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
65: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
66: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
67: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 64: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
65: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
66: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
67: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
68: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 67: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_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;
65: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
66: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
67: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
68: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
69: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
70: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
71: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 75: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

71: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
72: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
73: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
74: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
75: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
76: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
77: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 76: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

72: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
73: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
74: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
75: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
76: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
77: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
80: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 77: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

73: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
74: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
75: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
76: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
77: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
80: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
81: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

74: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
75: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
76: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
77: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_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;

Line 79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

75: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
76: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
77: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_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;

Line 82: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
79: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_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;

Line 85: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_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;
89: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 87: l_unit_of_measure_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;
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;

Line 90: l_rate_expenditure_type_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);
94: l_msg_count NUMBER;

Line 91: l_rate_exp_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_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);
94: l_msg_count NUMBER;
95: l_return_status VARCHAR2(1):= NULL;

Line 138: l_resource_class_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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();
142: l_person_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 140: l_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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();
142: l_person_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
143: l_job_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
144: l_person_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 141: l_incur_by_res_type_tbl := SYSTEM.PA_VARCHAR2_30_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();
142: l_person_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
143: l_job_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
144: l_person_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
145: l_named_role_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 144: l_person_type_code_tbl := SYSTEM.PA_VARCHAR2_30_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();
142: l_person_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
143: l_job_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
144: l_person_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
145: l_named_role_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
146: l_bom_resource_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
147: l_non_labor_resource_tbl := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
148: l_inventory_item_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 152: l_fc_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

148: l_inventory_item_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
149: l_item_category_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
150: l_project_role_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
151: l_organization_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
152: l_fc_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
153: l_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
154: l_expenditure_category_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 153: l_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

149: l_item_category_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
150: l_project_role_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
151: l_organization_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
152: l_fc_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
153: l_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
154: l_expenditure_category_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
157: l_supplier_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 154: l_expenditure_category_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

150: l_project_role_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
151: l_organization_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
152: l_fc_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
153: l_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
154: l_expenditure_category_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
157: l_supplier_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
158: l_spread_curve_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

151: l_organization_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
152: l_fc_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
153: l_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
154: l_expenditure_category_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_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();

Line 156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

152: l_fc_res_type_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
153: l_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
154: l_expenditure_category_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_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();

Line 159: l_etc_method_code_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
156: l_revenue_category_code_tbl := SYSTEM.PA_VARCHAR2_30_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();

Line 162: l_incur_by_res_class_code_tbl := SYSTEM.PA_VARCHAR2_30_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();
166: l_rate_based_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 164: l_unit_of_measure_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();
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();

Line 167: l_rate_expenditure_type_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
171: INTO l_spread_curve_id

Line 168: l_rate_exp_func_curr_code_tbl := SYSTEM.PA_VARCHAR2_30_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
171: INTO l_spread_curve_id
172: from pa_spread_curves_b