DBA Data[Home] [Help]

APPS.PA_RATE_ATTR_PKG dependencies on PA_NUM_TBL_TYPE

Line 4: P_BUDGET_VER_TBL IN SYSTEM.PA_NUM_TBL_TYPE,

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:

Line 62: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

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;

Line 65: l_person_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;

Line 66: l_job_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;

Line 69: l_bom_resource_id_tbl SYSTEM.PA_NUM_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;

Line 71: l_inventory_item_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;

Line 72: l_item_category_id_tbl SYSTEM.PA_NUM_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;

Line 73: l_project_role_id_tbl SYSTEM.PA_NUM_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;

Line 74: l_organization_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;
78: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 80: l_supplier_id_tbl SYSTEM.PA_NUM_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;

Line 81: l_spread_curve_id_tbl SYSTEM.PA_NUM_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;

Line 83: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_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;

Line 86: l_incur_by_role_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;
90: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 88: l_org_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;
92: l_sys_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 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:

Line 136: l_sys_rlm_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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();

Line 139: l_resource_class_id_tbl := SYSTEM.PA_NUM_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();

Line 142: l_person_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();

Line 143: l_job_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();

Line 146: l_bom_resource_id_tbl := SYSTEM.PA_NUM_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();

Line 148: l_inventory_item_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();

Line 149: l_item_category_id_tbl := SYSTEM.PA_NUM_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();

Line 150: l_project_role_id_tbl := SYSTEM.PA_NUM_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();

Line 151: l_organization_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();
155: l_event_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 157: l_supplier_id_tbl := SYSTEM.PA_NUM_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();

Line 158: l_spread_curve_id_tbl := SYSTEM.PA_NUM_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();

Line 160: l_mfc_cost_type_id_tbl := SYSTEM.PA_NUM_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();

Line 163: l_incur_by_role_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();
167: l_rate_expenditure_type_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 165: l_org_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();
169: