1 Package Pa_Txn_Interface_Items_Pkg as
2 /* $Header: PAXRTXNS.pls 120.2 2005/08/03 12:32:33 aaggarwa noship $ */
3
4 -- PA.K changes
5 TYPE Txn_Interface_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
6 INDEX BY BINARY_INTEGER;
7 TYPE Transaction_Source_Typ IS TABLE OF Pa_Transaction_Interface_All.Transaction_Source%TYPE
8 INDEX BY BINARY_INTEGER;
9 TYPE User_Transaction_Source_Typ IS TABLE OF Pa_Transaction_Interface_All.User_Transaction_Source%TYPE
10 INDEX BY BINARY_INTEGER;
11 TYPE Batch_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Batch_Name%TYPE
12 INDEX BY BINARY_INTEGER;
13 TYPE Expenditure_End_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
14 INDEX BY BINARY_INTEGER;
15 TYPE Person_Business_Group_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Person_Business_Group_Name%TYPE
16 INDEX BY BINARY_INTEGER;
17 TYPE Person_Business_Group_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE
18 INDEX BY BINARY_INTEGER;
19 TYPE Employee_Number_Typ IS TABLE OF Pa_Transaction_Interface_All.Employee_Number%TYPE
20 INDEX BY BINARY_INTEGER;
21 TYPE Person_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Person_Id%TYPE
22 INDEX BY BINARY_INTEGER;
23 TYPE Organization_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Organization_Name%TYPE
24 INDEX BY BINARY_INTEGER;
25 TYPE Organization_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Organization_Id%TYPE
26 INDEX BY BINARY_INTEGER;
27 TYPE Expenditure_Item_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Expenditure_Item_Date%TYPE
28 INDEX BY BINARY_INTEGER;
29 TYPE Project_Number_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Number%TYPE
30 INDEX BY BINARY_INTEGER;
31 TYPE Project_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Id%TYPE
32 INDEX BY BINARY_INTEGER;
33 TYPE Task_Number_Typ IS TABLE OF Pa_Transaction_Interface_All.Task_Number%TYPE
34 INDEX BY BINARY_INTEGER;
35 TYPE Task_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Task_Id%TYPE
36 INDEX BY BINARY_INTEGER;
37 TYPE Expenditure_Type_Typ IS TABLE OF Pa_Transaction_Interface_All.Expenditure_Type%TYPE
38 INDEX BY BINARY_INTEGER;
39 TYPE System_Linkage_Typ IS TABLE OF Pa_Transaction_Interface_All.System_Linkage%TYPE
40 INDEX BY BINARY_INTEGER;
41 TYPE Non_Labor_Resource_Typ IS TABLE OF Pa_Transaction_Interface_All.Non_Labor_Resource%TYPE
42 INDEX BY BINARY_INTEGER;
43 TYPE Non_Labor_Res_Org_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Name%TYPE
44 INDEX BY BINARY_INTEGER;
45 TYPE Non_Labor_Res_Org_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE
46 INDEX BY BINARY_INTEGER;
47 TYPE Quantity_Typ IS TABLE OF Pa_Transaction_Interface_All.Quantity%TYPE
48 INDEX BY BINARY_INTEGER;
49 TYPE Raw_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Raw_Cost%TYPE
50 INDEX BY BINARY_INTEGER;
51 TYPE Raw_Cost_Rate_Typ IS TABLE OF Pa_Transaction_Interface_All.Raw_Cost_Rate%TYPE
52 INDEX BY BINARY_INTEGER;
53 TYPE Burden_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Burdened_Cost%TYPE
54 INDEX BY BINARY_INTEGER;
55 TYPE Burden_Cost_Rate_Typ IS TABLE OF Pa_Transaction_Interface_All.Burdened_Cost_Rate%TYPE
56 INDEX BY BINARY_INTEGER;
57 TYPE Expenditure_Comment_Typ IS TABLE OF Pa_Transaction_Interface_All.Expenditure_Comment%TYPE
58 INDEX BY BINARY_INTEGER;
59 TYPE Gl_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Gl_Date%TYPE
60 INDEX BY BINARY_INTEGER;
61 TYPE Transaction_Status_Code_Typ IS TABLE OF Pa_Transaction_Interface_All.Transaction_Status_Code%TYPE
62 INDEX BY BINARY_INTEGER;
63 TYPE Transaction_Rejection_Code_Typ IS TABLE OF Pa_Transaction_Interface_All.Transaction_Rejection_Code%TYPE
64 INDEX BY BINARY_INTEGER;
65 TYPE Orig_Transaction_Reference_Typ IS TABLE OF Pa_Transaction_Interface_All.Orig_Transaction_Reference%TYPE
66 INDEX BY BINARY_INTEGER;
67 TYPE Unmatched_Neg_Txn_Flag_Typ IS TABLE OF Pa_Transaction_Interface_All.Unmatched_Negative_Txn_Flag%TYPE
68 INDEX BY BINARY_INTEGER;
69 TYPE Expenditure_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Expenditure_Id%TYPE
70 INDEX BY BINARY_INTEGER;
71 TYPE Attribute_Category_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute_Category%TYPE
72 INDEX BY BINARY_INTEGER;
73 TYPE Attribute1_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute1%TYPE
74 INDEX BY BINARY_INTEGER;
75 TYPE Attribute2_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute2%TYPE
76 INDEX BY BINARY_INTEGER;
77 TYPE Attribute3_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute3%TYPE
78 INDEX BY BINARY_INTEGER;
79 TYPE Attribute4_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute4%TYPE
80 INDEX BY BINARY_INTEGER;
81 TYPE Attribute5_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute5%TYPE
82 INDEX BY BINARY_INTEGER;
83 TYPE Attribute6_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute6%TYPE
84 INDEX BY BINARY_INTEGER;
85 TYPE Attribute7_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute7%TYPE
86 INDEX BY BINARY_INTEGER;
87 TYPE Attribute8_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute8%TYPE
88 INDEX BY BINARY_INTEGER;
89 TYPE Attribute9_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute9%TYPE
90 INDEX BY BINARY_INTEGER;
91 TYPE Attribute10_Typ IS TABLE OF Pa_Transaction_Interface_All.Attribute10%TYPE
92 INDEX BY BINARY_INTEGER;
93 TYPE Dr_Code_Combination_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Dr_Code_Combination_Id%TYPE
94 INDEX BY BINARY_INTEGER;
95 TYPE Cr_Code_Combination_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Cr_Code_Combination_Id%TYPE
96 INDEX BY BINARY_INTEGER;
97 TYPE Cdl_System_Reference1_Typ IS TABLE OF Pa_Transaction_Interface_All.Cdl_System_Reference1%TYPE
98 INDEX BY BINARY_INTEGER;
99 TYPE Cdl_System_Reference2_Typ IS TABLE OF Pa_Transaction_Interface_All.Cdl_System_Reference2%TYPE
100 INDEX BY BINARY_INTEGER;
101 TYPE Cdl_System_Reference3_Typ IS TABLE OF Pa_Transaction_Interface_All.Cdl_System_Reference3%TYPE
102 INDEX BY BINARY_INTEGER;
103 TYPE Interface_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Interface_Id%TYPE
104 INDEX BY BINARY_INTEGER;
105 TYPE Receipt_Currency_Amount_Typ IS TABLE OF Pa_Transaction_Interface_All.Receipt_Currency_Amount%TYPE
106 INDEX BY BINARY_INTEGER;
107 TYPE Receipt_Currency_Code_Typ IS TABLE OF Pa_Transaction_Interface_All.Receipt_Currency_Code%TYPE
108 INDEX BY BINARY_INTEGER;
109 TYPE Receipt_Exchange_Rate_Typ IS TABLE OF Pa_Transaction_Interface_All.Receipt_Exchange_Rate%TYPE
110 INDEX BY BINARY_INTEGER;
111 TYPE Denom_Currency_Code_Typ IS TABLE OF Pa_Transaction_Interface_All.Denom_Currency_Code%TYPE
112 INDEX BY BINARY_INTEGER;
113 TYPE Denom_Raw_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Denom_Raw_Cost%TYPE
114 INDEX BY BINARY_INTEGER;
115 TYPE Denom_Burdened_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Denom_Burdened_Cost%TYPE
116 INDEX BY BINARY_INTEGER;
117 TYPE Acct_Rate_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Acct_Rate_Date%TYPE
118 INDEX BY BINARY_INTEGER;
119 TYPE Acct_Rate_Type_Typ IS TABLE OF Pa_Transaction_Interface_All.Acct_Rate_Type%TYPE
120 INDEX BY BINARY_INTEGER;
121 TYPE Acct_Exchange_Rate_Typ IS TABLE OF Pa_Transaction_Interface_All.Acct_Exchange_Rate%TYPE
122 INDEX BY BINARY_INTEGER;
123 TYPE Acct_Raw_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Acct_Raw_Cost%TYPE
124 INDEX BY BINARY_INTEGER;
125 TYPE Acct_Burdened_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Acct_Burdened_Cost%TYPE
126 INDEX BY BINARY_INTEGER;
127 TYPE Acct_Exch_Rounding_Limit_Typ IS TABLE OF Pa_Transaction_Interface_All.Acct_Exchange_Rounding_Limit%TYPE
128 INDEX BY BINARY_INTEGER;
129 TYPE Project_Currency_Code_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Currency_Code%TYPE
130 INDEX BY BINARY_INTEGER;
131 TYPE Project_Rate_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Rate_Date%TYPE
132 INDEX BY BINARY_INTEGER;
133 TYPE Project_Rate_Type_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Rate_Type%TYPE
134 INDEX BY BINARY_INTEGER;
135 TYPE Project_Exchange_Rate_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Exchange_Rate%TYPE
136 INDEX BY BINARY_INTEGER;
137 TYPE Orig_Exp_Txn_Reference1_Typ IS TABLE OF Pa_Transaction_Interface_All.Orig_Exp_Txn_Reference1%TYPE
138 INDEX BY BINARY_INTEGER;
139 TYPE Orig_Exp_Txn_Reference2_Typ IS TABLE OF Pa_Transaction_Interface_All.Orig_Exp_Txn_Reference2%TYPE
140 INDEX BY BINARY_INTEGER;
141 TYPE Orig_Exp_Txn_Reference3_Typ IS TABLE OF Pa_Transaction_Interface_All.Orig_Exp_Txn_Reference2%TYPE
142 INDEX BY BINARY_INTEGER;
143 TYPE Orig_User_Exp_Txn_Ref_Typ IS TABLE OF Pa_Transaction_Interface_All.Orig_User_Exp_Txn_Reference%TYPE
144 INDEX BY BINARY_INTEGER;
145 TYPE Vendor_Number_Typ IS TABLE OF Pa_Transaction_Interface_All.Vendor_Number%TYPE
146 INDEX BY BINARY_INTEGER;
147 TYPE Vendor_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Vendor_Id%TYPE
148 INDEX BY BINARY_INTEGER;
149 TYPE Override_To_Org_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Override_To_Organization_Name%TYPE
150 INDEX BY BINARY_INTEGER;
151 TYPE Override_To_Org_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE
152 INDEX BY BINARY_INTEGER;
153 TYPE Reversed_Orig_Txn_Ref_Typ IS TABLE OF Pa_Transaction_Interface_All.Reversed_Orig_Txn_Reference%TYPE
154 INDEX BY BINARY_INTEGER;
155 TYPE Billable_Flag_Typ IS TABLE OF Pa_Transaction_Interface_All.Billable_Flag%TYPE
156 INDEX BY BINARY_INTEGER;
157 TYPE ProjFunc_Currency_Code_Typ IS TABLE OF Pa_Transaction_Interface_All.ProjFunc_Currency_Code%TYPE
158 INDEX BY BINARY_INTEGER;
159 TYPE ProjFunc_Cost_Rate_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.ProjFunc_Cost_Rate_Date%TYPE
160 INDEX BY BINARY_INTEGER;
161 TYPE ProjFunc_Cost_Rate_Type_Typ IS TABLE OF Pa_Transaction_Interface_All.ProjFunc_Cost_Rate_Type%TYPE
162 INDEX BY BINARY_INTEGER;
163 TYPE ProjFunc_Cost_Exch_Rate_Typ IS TABLE OF Pa_Transaction_Interface_All.ProjFunc_Cost_Exchange_Rate%TYPE
164 INDEX BY BINARY_INTEGER;
165 TYPE Project_Raw_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Raw_Cost%TYPE
166 INDEX BY BINARY_INTEGER;
167 TYPE Project_Burdened_Cost_Typ IS TABLE OF Pa_Transaction_Interface_All.Project_Burdened_Cost%TYPE
168 INDEX BY BINARY_INTEGER;
169 TYPE Assignment_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Assignment_Name%TYPE
170 INDEX BY BINARY_INTEGER;
171 TYPE Assignment_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Assignment_Id%TYPE
172 INDEX BY BINARY_INTEGER;
173 TYPE Work_Type_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Work_Type_Name%TYPE
174 INDEX BY BINARY_INTEGER;
175 TYPE Work_Type_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Work_Type_Id%TYPE
176 INDEX BY BINARY_INTEGER;
177 TYPE Cdl_System_Reference4_Typ IS TABLE OF Pa_Transaction_Interface_All.Cdl_System_Reference4%TYPE
178 INDEX BY BINARY_INTEGER;
179 TYPE Accrual_flag_Typ IS TABLE OF Pa_Transaction_Interface_All.Accrual_Flag%TYPE
180 INDEX BY BINARY_INTEGER;
181 TYPE Last_Update_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Last_Update_Date%TYPE
182 INDEX BY BINARY_INTEGER;
183 TYPE Last_Updated_By_Typ IS TABLE OF Pa_Transaction_Interface_All.Last_Updated_By%TYPE
184 INDEX BY BINARY_INTEGER;
185 TYPE Creation_Date_Typ IS TABLE OF Pa_Transaction_Interface_All.Creation_Date%TYPE
186 INDEX BY BINARY_INTEGER;
187 TYPE Created_By_Typ IS TABLE OF Pa_Transaction_Interface_All.Created_By%TYPE
188 INDEX BY BINARY_INTEGER;
189 -- Begin PA.M/CWK changes
190 TYPE PO_Number_Typ IS TABLE OF Pa_Transaction_Interface_All.PO_Number%TYPE
191 INDEX BY BINARY_INTEGER;
192 TYPE PO_Header_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.PO_Header_Id%TYPE
193 INDEX BY BINARY_INTEGER;
194 TYPE PO_Line_Num_Typ IS TABLE OF Pa_Transaction_Interface_All.PO_Line_Num%TYPE
195 INDEX BY BINARY_INTEGER;
196 TYPE PO_Line_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.PO_Line_Id%TYPE
197 INDEX BY BINARY_INTEGER;
198 TYPE PO_Price_Type_Typ IS TABLE OF Pa_Transaction_Interface_All.PO_Price_Type%TYPE
199 INDEX BY BINARY_INTEGER;
200 TYPE Person_Type_Typ IS TABLE OF Pa_Transaction_Interface_All.Person_Type%TYPE
201 INDEX BY BINARY_INTEGER;
202 -- End PA.M/CWK changes
203 TYPE Inventory_Item_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE
204 INDEX BY BINARY_INTEGER;
205 TYPE WIP_Resource_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE
206 INDEX BY BINARY_INTEGER;
207 TYPE Unit_Of_Measure_Typ IS TABLE OF Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE
208 INDEX BY BINARY_INTEGER;
209 -- 12i MOAC changes
210 Type OU_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Org_Id%TYPE
211 INDEX BY BINARY_INTEGER;
212
213 Procedure Insert_Row (
214 x_rowid IN OUT NOCOPY VARCHAR2,
215 x_txn_interface_id IN OUT NOCOPY NUMBER,
216 x_last_update_date IN DATE,
217 x_last_updated_by IN NUMBER,
218 x_creation_date IN DATE,
219 x_created_by IN NUMBER,
220 x_transaction_source IN VARCHAR2,
221 x_user_txn_source IN VARCHAR2,
222 x_batch_name IN VARCHAR2,
223 x_expenditure_end_date IN DATE ,
224 x_person_business_group_name IN VARCHAR2 default NULL,
225 x_employee_number IN VARCHAR2,
226 x_organization_name IN VARCHAR2,
227 x_expenditure_item_date IN DATE,
228 x_project_number IN VARCHAR2,
229 x_task_number IN VARCHAR2,
230 x_expenditure_type IN VARCHAR2,
231 x_system_linkage IN VARCHAR2,
232 x_non_labor_resource IN VARCHAR2,
233 x_non_labor_res_org IN VARCHAR2,
237 x_burden_cost IN NUMBER,
234 x_quantity IN NUMBER,
235 x_raw_cost IN NUMBER,
236 x_raw_cost_rate IN NUMBER,
238 x_burden_cost_rate IN NUMBER,
239 x_expenditure_comment IN VARCHAR2,
240 x_gl_date IN DATE,
241 x_txn_status_code IN VARCHAR2,
242 x_txn_rejection_code IN VARCHAR2,
243 x_org_txn_reference IN VARCHAR2,
244 x_unmatched_txn_flag IN VARCHAR2,
245 x_expenditure_id IN NUMBER,
246 x_attribute_category IN VARCHAR2,
247 x_attribute1 IN VARCHAR2,
248 x_attribute2 IN VARCHAR2,
249 x_attribute3 IN VARCHAR2,
250 x_attribute4 IN VARCHAR2,
251 x_attribute5 IN VARCHAR2,
252 x_attribute6 IN VARCHAR2,
253 x_attribute7 IN VARCHAR2,
254 x_attribute8 IN VARCHAR2,
255 x_attribute9 IN VARCHAR2,
256 x_attribute10 IN VARCHAR2,
257 x_dr_ccid IN NUMBER,
258 x_cr_ccid IN NUMBER,
259 x_cdl_sys_ref1 IN VARCHAR2,
260 x_cdl_sys_ref2 IN VARCHAR2,
261 x_cdl_sys_ref3 IN VARCHAR2,
262 x_xface_id IN NUMBER,
263 x_receipt_currency_amount IN NUMBER,
264 x_receipt_currency_code IN VARCHAR2,
265 x_receipt_exchange_rate IN NUMBER,
266 x_denom_currency_code IN VARCHAR2,
267 x_denom_raw_cost IN NUMBER,
268 x_denom_burdened_cost IN NUMBER,
269 x_acct_rate_date IN DATE,
270 x_acct_rate_type IN VARCHAR2,
271 x_acct_exchange_rate IN NUMBER,
272 x_acct_raw_cost IN NUMBER,
273 x_acct_burdened_cost IN NUMBER,
274 x_acct_exchange_rounding_limit IN NUMBER,
275 x_project_currency_code IN VARCHAR2,
276 x_project_rate_date IN DATE,
277 x_project_rate_type IN VARCHAR2,
278 x_project_exchange_rate IN NUMBER,
279 x_orig_exp_txn_reference1 IN VARCHAR2,
280 x_orig_exp_txn_reference2 IN VARCHAR2,
281 x_orig_exp_txn_reference3 IN VARCHAR2,
282 x_orig_user_exp_txn_reference IN VARCHAR2,
283 x_vendor_number IN VARCHAR2,
284 x_override_to_oname IN VARCHAR2,
285 -- SST Changes
286 x_reversed_orig_txn_reference IN VARCHAR2 DEFAULT NULL,
287 x_billable_flag IN VARCHAR2 DEFAULT NULL,
288 -- PA-I Changes
289 X_Projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
290 X_Projfunc_cost_rate_date IN DATE DEFAULT NULL,
291 X_Projfunc_cost_rate_type IN VARCHAR2 DEFAULT NULL,
292 X_Projfunc_cost_exchange_rate IN NUMBER DEFAULT NULL,
293 X_project_raw_cost IN NUMBER DEFAULT NULL,
294 X_project_burdened_cost IN NUMBER DEFAULT NULL,
295 X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
296 X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
297 -- AP Discounts
298 x_cdl_sys_ref4 IN VARCHAR2 DEFAULT NULL,
299 -- PA-J changes
300 x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
301 -- Pa-K Changes
302 P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
303 P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
304 P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
305 P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
306 P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
307 P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
308 P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
309 P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
310 P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
311 P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
312 -- PA.M/CWK changes
313 P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
314 P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
315 P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
316 P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
317 P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
318 P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
319 -- End PA.M/CWK changes
320 P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
324 P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL);
321 P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
322 P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
323 -- 12i MOAC changes
325
326 Procedure Update_Row (
327 X_RowId IN VARCHAR2,
328 X_Txn_Interface_Id IN NUMBER,
329 X_Last_Update_Date IN DATE,
330 X_Last_Updated_By IN NUMBER,
331 X_Creation_Date IN DATE,
332 X_Created_By IN NUMBER,
333 X_Transaction_Source IN VARCHAR2,
334 X_User_Txn_Source IN VARCHAR2,
335 X_Batch_Name IN VARCHAR2,
336 X_Expenditure_End_Date IN DATE,
337 X_Person_Business_Group_Name IN VARCHAR2 default NULL,
338 X_Employee_Number IN VARCHAR2,
339 X_Organization_Name IN VARCHAR2,
340 X_Expenditure_Item_Date IN DATE,
341 X_Project_Number IN VARCHAR2,
342 X_Task_Number IN VARCHAR2,
343 X_Expenditure_Type IN VARCHAR2,
344 X_System_Linkage IN VARCHAR2,
345 X_Non_Labor_Resource IN VARCHAR2,
346 X_Non_Labor_Res_Org IN VARCHAR2,
347 X_Quantity IN NUMBER,
348 X_Raw_Cost IN NUMBER,
349 X_Raw_Cost_Rate IN NUMBER,
350 X_Burden_Cost IN NUMBER,
351 X_Burden_Cost_Rate IN NUMBER,
352 X_Expenditure_Comment IN VARCHAR2,
353 X_Gl_Date IN DATE,
354 X_Txn_Status_Code IN VARCHAR2,
355 X_Txn_Rejection_Code IN VARCHAR2,
356 X_Org_Txn_Reference IN VARCHAR2,
357 X_Unmatched_Txn_Flag IN VARCHAR2,
358 X_Expenditure_Id IN NUMBER,
359 X_Attribute_Category IN VARCHAR2,
360 X_Attribute1 IN VARCHAR2,
361 X_Attribute2 IN VARCHAR2,
362 X_Attribute3 IN VARCHAR2,
363 X_Attribute4 IN VARCHAR2,
364 X_Attribute5 IN VARCHAR2,
365 X_Attribute6 IN VARCHAR2,
366 X_Attribute7 IN VARCHAR2,
367 X_Attribute8 IN VARCHAR2,
368 X_Attribute9 IN VARCHAR2,
369 X_Attribute10 IN VARCHAR2,
370 X_Dr_Ccid IN NUMBER,
371 X_Cr_Ccid IN NUMBER,
372 X_Cdl_Sys_Ref1 IN VARCHAR2,
373 X_Cdl_Sys_Ref2 IN VARCHAR2,
374 X_Cdl_Sys_Ref3 IN VARCHAR2,
375 X_Receipt_Currency_Amount IN NUMBER,
376 X_Receipt_Currency_Code IN VARCHAR2,
377 X_Receipt_Exchange_Rate IN NUMBER,
378 X_Denom_Currency_Code IN VARCHAR2,
379 X_Denom_Raw_Cost IN NUMBER,
380 X_Denom_Burdened_Cost IN NUMBER,
381 X_Acct_Rate_Date IN DATE,
382 X_Acct_Rate_Type IN VARCHAR2,
383 X_Acct_Exchange_Rate IN NUMBER,
384 X_Acct_Raw_Cost IN NUMBER,
385 X_Acct_Burdened_Cost IN NUMBER,
386 X_Acct_Exchange_Rounding_Limit IN NUMBER,
387 X_Project_Currency_Code IN VARCHAR2,
388 X_Project_Rate_Date IN DATE,
389 X_Project_Rate_Type IN VARCHAR2,
390 X_Project_Exchange_Rate IN NUMBER,
391 X_Orig_Exp_Txn_Reference1 IN VARCHAR2,
392 X_Orig_Exp_Txn_Reference2 IN VARCHAR2,
393 X_Orig_Exp_Txn_Reference3 IN VARCHAR2,
394 X_Orig_User_Exp_Txn_Reference IN VARCHAR2,
395 X_Vendor_Number IN VARCHAR2,
396 X_Override_To_Oname IN VARCHAR2,
397 -- SST Changes
398 X_Reversed_Orig_Txn_Reference IN VARCHAR2 DEFAULT NULL,
399 X_Billable_Flag IN VARCHAR2 DEFAULT NULL,
400 -- PA-I Changes
401 X_ProjFunc_Currency_Code IN VARCHAR2 DEFAULT NULL,
402 X_ProjFunc_Cost_Rate_Date IN DATE DEFAULT NULL,
403 X_ProjFunc_Cost_Rate_Type IN VARCHAR2 DEFAULT NULL,
404 X_ProjFunc_Cost_Exchange_Rate IN NUMBER DEFAULT NULL,
405 X_Project_Raw_Cost IN NUMBER DEFAULT NULL,
406 X_Project_Burdened_Cost IN NUMBER DEFAULT NULL,
407 X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
408 X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
409 -- AP Discounts
410 X_Cdl_Sys_Ref4 IN VARCHAR2 DEFAULT NULL,
411 -- PA-J changes
412 X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
413 -- PA-K Changes
414 P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
415 P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
416 P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
417 P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
418 P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
419 P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
420 P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
421 P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
425 P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
422 P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
423 P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
424 -- PA.M/CWK changes
426 P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
427 P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
428 P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
429 P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
430 P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
431 -- PA.M/CWK changes
432 P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
433 P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
434 P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL );
435
436 Procedure Delete_Row (X_RowId IN VARCHAR2);
437
438 Procedure Lock_Row (X_RowId IN VARCHAR2);
439
440 Procedure Bulk_Insert (
441 P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
442 P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
443 P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
444 P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
445 P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
446 P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
447 P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
448 P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
449 P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
450 P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
451 P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
452 P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
453 P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
454 P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
455 P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
456 P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
457 P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
458 P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
459 P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
460 P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
461 P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
462 P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
463 P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
464 P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
465 P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
466 P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
467 P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
468 P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
469 P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
470 P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
471 P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
472 P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
473 P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
474 P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
475 P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
476 P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
477 P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
478 P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
479 P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
480 P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
481 P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
482 P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
483 P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
484 P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
485 P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
486 P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
487 P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
488 P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
489 P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
490 P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
491 P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
492 P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
493 P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
494 P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
495 P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
496 P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
497 P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
501 P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
498 P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
499 P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
500 P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
502 P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
503 P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
504 P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
505 P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
506 P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
507 P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
508 P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
509 P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
510 P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
511 P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
512 P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
513 P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
514 P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
515 P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
516 P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
517 P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
518 P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
519 P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
520 P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
521 P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
522 P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
523 P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
524 P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
525 P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
526 P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
527 P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
528 P_Accrual_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_Flag_Typ,
529 P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
530 P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
531 P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
532 P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
533 -- Begin PA.M/CWK changes
534 P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
535 P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
536 P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
537 P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
538 P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
539 P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
540 -- End PA.M/CWK changes
541 P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
542 P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
543 P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ,
544 -- 12i MOAC changes
545 P_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.OU_Id_Typ );
546
547 Procedure Bulk_Update (
548 P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
549 P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
550 P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
551 P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
552 P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
553 P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
554 P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
555 P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
556 P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
557 P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
558 P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
559 P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
560 P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
561 P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
562 P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
563 P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
564 P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
565 P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
566 P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
567 P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
568 P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
569 P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
570 P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
571 P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
572 P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
573 P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
574 P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
575 P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
576 P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
577 P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
578 P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
579 P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
580 P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
581 P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
582 P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
583 P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
584 P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
585 P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
586 P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
587 P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
588 P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
589 P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
590 P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
591 P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
592 P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
593 P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
594 P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
595 P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
596 P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
597 P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
598 P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
599 P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
600 P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
601 P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
602 P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
603 P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
604 P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
605 P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
606 P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
607 P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
608 P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
609 P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
610 P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
611 P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
612 P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
613 P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
614 P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
615 P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
616 P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
617 P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
618 P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
619 P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
620 P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
621 P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
622 P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
623 P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
624 P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
625 P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
626 P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
627 P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
628 P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
629 P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
630 P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
631 P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
632 P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
633 P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
634 P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
635 P_Accrual_flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_flag_Typ,
636 P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
637 P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
638 P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
639 P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
640 -- Begin PA.M/CWK changes
641 P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
642 P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
643 P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
644 P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
645 P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
646 P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
647 -- End PA.M/CWK changes
648 P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
649 P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
650 P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ );
651
652 END Pa_Txn_Interface_Items_Pkg;