1: package body PA_RATE_ATTR_PKG AS
2: /* $Header: PARATTRB.pls 120.4 2007/02/06 09:46:22 dthakker noship $ */
3: procedure RATE_ATTR_UPGRD(
4: P_BUDGET_VER_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
5: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6: X_MSG_COUNT OUT NOCOPY NUMBER,
7: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
8:
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;
66: l_job_id_tbl SYSTEM.PA_NUM_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;
69: l_bom_resource_id_tbl SYSTEM.PA_NUM_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;
69: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
70: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_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;
72: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
73: l_project_role_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;
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;
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;
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;
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;
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;
70: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_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;
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;
84: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_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;
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;
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;
87: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_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;
90: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_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;
92: l_sys_rlm_ids_tbl SYSTEM.PA_NUM_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;
96:
132: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
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();
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();
143: l_job_id_tbl := SYSTEM.PA_NUM_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();
146: l_bom_resource_id_tbl := SYSTEM.PA_NUM_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();
146: l_bom_resource_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
147: l_non_labor_resource_tbl := SYSTEM.PA_VARCHAR2_20_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();
149: l_item_category_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
150: l_project_role_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();
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();
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();
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();
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();
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();
147: l_non_labor_resource_tbl := SYSTEM.PA_VARCHAR2_20_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();
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();
161: l_incurred_by_res_flag_tbl := SYSTEM.PA_VARCHAR2_1_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();
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();
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();
164: l_unit_of_measure_tbl := SYSTEM.PA_VARCHAR2_30_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();
167: l_rate_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_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();
169: