eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 62: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type

58: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
59: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
60: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
61: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
62: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
63: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
64: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
65: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
66: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 66: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type

62: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
63: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
64: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
65: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
66: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
67: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
68: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
69: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
70: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 67: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type

63: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
64: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
65: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
66: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
67: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
68: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
69: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
70: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
71: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 68: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type

64: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
65: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
66: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
67: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
68: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
69: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
70: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
71: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
72: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 72: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type

68: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
69: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
70: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
71: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
72: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
73: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
74: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
75: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
76: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061

Line 143: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

139:
140: l_ra_id_count NUMBER := 0;
141: l_rbs_map_index NUMBER:=0;
142:
143: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
144: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
145: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
146: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
147: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 149: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

145: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
146: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
147: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
148: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
149: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
150: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
151: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
152: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
153: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 150: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

146: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
147: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
148: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
149: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
150: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
151: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
152: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
153: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
154: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 151: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

147: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
148: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
149: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
150: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
151: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
152: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
153: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
154: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
155: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 155: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

151: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
152: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
153: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
154: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
155: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
156: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
157: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
158: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
159: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

Line 159: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

155: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
156: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
157: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
158: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
159: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
160: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
161: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
162: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
163: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

Line 163: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

159: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
160: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
161: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
162: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
163: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
164: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
165: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
166: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
167: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 164: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

160: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
161: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
162: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
163: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
164: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
165: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
166: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
167: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
168: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 165: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

161: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
162: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
163: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
164: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
165: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
166: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
167: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
168: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
169: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 169: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

165: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
166: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
167: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
168: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
169: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
170: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
171: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
172: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
173: l_non_labor_resource_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();

Line 171: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

167: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
168: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
169: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
170: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
171: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
172: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
173: l_non_labor_resource_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
174: l_non_labor_res_rbs_prm_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
175: l_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();

Line 172: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

168: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
169: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
170: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
171: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
172: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
173: l_non_labor_resource_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
174: l_non_labor_res_rbs_prm_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
175: l_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
176: l_project_role_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 190: l_res_class_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

186:
187: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
188: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
189: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
190: l_res_class_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
191:
192: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
193:
194: --Bug 4083605

Line 192: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

188: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
189: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
190: l_res_class_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
191:
192: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
193:
194: --Bug 4083605
195: l_actuals_start_date pa_budget_lines.start_date%TYPE;
196: l_actuals_end_date pa_budget_lines.start_date%TYPE;

Line 1246: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

1242: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1243: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1244: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1245: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1246: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1247: ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1248: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1249: ,p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1250: ,p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()

Line 1247: ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

1243: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1244: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1245: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1246: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1247: ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1248: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1249: ,p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1250: ,p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1251: ,p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()

Line 1248: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

1244: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1245: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1246: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1247: ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1248: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1249: ,p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1250: ,p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1251: ,p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1252: ,p_attribute4 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()

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

1345: PRAGMA exception_init(dml_errors, -24381);
1346:
1347: --Start of variables for Variable for Resource Attributes
1348: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1349: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1350: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1351: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1352: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1353: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1347: --Start of variables for Variable for Resource Attributes
1348: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1349: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1350: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1351: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1352: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1353: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1354: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1355: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 1354: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1350: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1351: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1352: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1353: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1354: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1355: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1356: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1357: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1358: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1358: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1359: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1360: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1361: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1362: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1363: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1364: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1365: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

1359: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1360: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1361: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1362: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1363: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1364: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1365: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1367: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1360: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1361: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1362: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1363: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1364: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1365: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1367: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1368: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

1361: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1362: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1363: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1364: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1365: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1367: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1368: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1369: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1362: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1363: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1364: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1365: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1367: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1368: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1369: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1368: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1364: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1365: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1367: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1368: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1369: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1371: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1372: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

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

1366: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1367: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1368: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1369: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1371: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1372: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1373: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1374: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1374: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1370: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1371: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1372: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1373: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1374: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1375: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1376: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1377: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1378: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1378: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1374: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1375: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1376: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1377: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1378: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1379: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1380: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1381: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 1379: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1375: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1376: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1377: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1378: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1379: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1380: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1381: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1383: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 1380: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1376: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1377: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1378: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1379: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1380: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1381: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1383: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1384: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 1387: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1383: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1384: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1385: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1386: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1387: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1388: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1389: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1390: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1391: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1395: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1391: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1392: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1393: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1394: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1395: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1396: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1397: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1398: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1399: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 1403: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1399: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1400: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1401: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1402: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1403: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1404: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1405: l_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1406: l_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1407: l_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 1404: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1400: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1401: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1402: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1403: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1404: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1405: l_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1406: l_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1407: l_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1408: l_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 1405: l_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1401: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1402: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1403: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1404: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1405: l_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1406: l_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1407: l_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1408: l_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1409: l_ATTRIBUTE4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 1443: l_del_task_level_rec_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1439:
1440: --Start of variables for Variable for TA Validations for p_context = TASK_ASSIGNMENTS
1441: l_task_rec_tbl pa_task_assignment_utils.l_task_rec_tbl_type;
1442: l_resource_rec_tbl pa_task_assignment_utils.l_resource_rec_tbl_type;
1443: l_del_task_level_rec_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1444: l_ra_id_del_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1445: l_ra_id_del_count NUMBER;
1446: --End of variables for Variable for TA Validations for p_context = TASK_ASSIGNMENTS
1447:

Line 1476: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

1472: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1473: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1474: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1475: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1476: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1477: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1478: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1479: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1480: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5314: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5315: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5316: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5317: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5319: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5320: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5321: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5322: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537

Line 5320: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5316: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5317: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5319: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5320: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5321: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5322: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5323: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5324: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5321: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5317: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5319: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5320: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5321: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5322: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5323: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5324: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5325: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5325: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5321: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5322: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5323: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5324: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5325: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5326: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5327: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5328: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5329: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5330: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5331: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5332: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5333: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5331: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5332: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5333: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5332: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5333: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5340: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5333: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5340: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5341: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5334: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5340: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5341: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5342: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5335: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5336: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5340: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5341: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5342: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5343: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5341: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5337: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5338: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5340: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5341: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5342: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5343: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5344: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5345: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

Line 5343: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5339: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5340: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5341: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5342: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5343: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5344: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5345: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5346: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5347: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 5347: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5343: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5344: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5345: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5346: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5347: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5348: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5349: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5350: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

Line 5349: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5345: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5346: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5347: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5348: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5349: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5350: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 5373: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

5369: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5370: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5371: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5372: ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5373: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5374: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5375: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5376: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5377: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE

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

5442: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5443: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5444: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5445: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5446: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5447: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5448: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5449: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5450: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5444: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5445: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5446: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5447: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5448: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5449: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5450: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5451: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5452: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 5449: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5445: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5446: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5447: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5448: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5449: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5450: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5451: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5452: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5453: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 5452: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5448: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5449: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5450: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5451: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5452: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5453: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5454: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
5455: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5456: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 5461: -- l_organization_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5457: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5458: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
5459: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5460: -- bug 3455288, 19-FEB-04, jwhite: Changed varchar2 length to 240 from 30 --------------------------------
5461: -- l_organization_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5462:
5463: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5464:
5465: -- End, bug 3455288, 19-FEB-04, jwhite: ------------------------------------------------------------------

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

5463: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5464:
5465: -- End, bug 3455288, 19-FEB-04, jwhite: ------------------------------------------------------------------
5466:
5467: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5469: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5464:
5465: -- End, bug 3455288, 19-FEB-04, jwhite: ------------------------------------------------------------------
5466:
5467: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5469: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

5465: -- End, bug 3455288, 19-FEB-04, jwhite: ------------------------------------------------------------------
5466:
5467: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5469: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5473: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5466:
5467: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5469: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5473: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5474: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

5467: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5469: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5473: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5474: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5475: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5468: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5469: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5473: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5474: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5475: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5476: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 5474: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5470: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5471: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5473: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5474: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5475: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5476: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5477: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5478: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

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

5472: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5473: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5474: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5475: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5476: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5477: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5478: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5479: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5480: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 5481: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5477: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5478: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5479: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5480: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5481: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5482: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5483: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5485: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 5482: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5478: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5479: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5480: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5481: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5482: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5483: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5485: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5486: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 5500: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5496: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5497: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5498: l_wbs_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5499: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5500: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5501: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
5502: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
5503: l_attribute3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
5504: l_attribute4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 5544: l_rate_exp_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5540: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5541:
5542: -- Added for bug 3698458
5543: l_rate_exp_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5544: l_rate_exp_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5545: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5546: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5547:
5548: /* End of variables for Variable for Resource Attributes

Line 5545: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5541:
5542: -- Added for bug 3698458
5543: l_rate_exp_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5544: l_rate_exp_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5545: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5546: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5547:
5548: /* End of variables for Variable for Resource Attributes
5549: */

Line 5546: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

5542: -- Added for bug 3698458
5543: l_rate_exp_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5544: l_rate_exp_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5545: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5546: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5547:
5548: /* End of variables for Variable for Resource Attributes
5549: */
5550: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 8515: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

8511: ,p_calling_module IN VARCHAR2 DEFAULT NULL
8512: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8513: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8514: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
8515: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
8516: --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.
8517: ,p_rollup_required_flag IN VARCHAR2 DEFAULT 'Y'
8518: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug 4200168 */
8519: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8539: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;

8535: l_delete_assmt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8536: l_wp_version_flag VARCHAR2(1);
8537: l_ta_display_flag VARCHAR2(1);
8538:
8539: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;
8540: l_start_date_tbl SYSTEM.pa_date_tbl_type;
8541: l_end_date_tbl SYSTEM.pa_date_tbl_type;
8542: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
8543: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;

Line 8552: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

8548: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
8549: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
8550: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
8551: l_revenue_tbl SYSTEM.pa_num_tbl_type;
8552: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

8549: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
8550: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
8551: l_revenue_tbl SYSTEM.pa_num_tbl_type;
8552: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8557: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

8550: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
8551: l_revenue_tbl SYSTEM.pa_num_tbl_type;
8552: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8557: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8558: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;

Line 8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;

8551: l_revenue_tbl SYSTEM.pa_num_tbl_type;
8552: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8557: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8558: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
8559: l_quantity_tbl SYSTEM.pa_num_tbl_type;

Line 8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

8552: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8557: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8558: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
8559: l_quantity_tbl SYSTEM.pa_num_tbl_type;
8560: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 8557: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

8553: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8554: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8555: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
8556: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8557: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
8558: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
8559: l_quantity_tbl SYSTEM.pa_num_tbl_type;
8560: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8561: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 8562: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

8558: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
8559: l_quantity_tbl SYSTEM.pa_num_tbl_type;
8560: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8561: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8562: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
8563: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
8564: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
8565: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
8566: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 8566: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;

8562: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
8563: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
8564: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
8565: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
8566: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
8567: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;
8568: l_ra_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
8569: --Bug 4951422
8570: l_task_assmt_ids_tbl SYSTEM.pa_num_tbl_type;

Line 10303: l_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

10299: l_elem_ver_id_cnt NUMBER := 0;
10300: l_ra_id_cnt NUMBER := 0;
10301: l_out_tbl_index NUMBER := 1;
10302: l_add_tbl_index NUMBER := 1;
10303: l_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
10304: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10305: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10306: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10307: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();