1 Package Pa_Txn_Interface_Items_Pkg AUTHID CURRENT_USER as
2 /* $Header: PAXRTXNS.pls 120.5.12020000.2 2013/03/31 04:04:46 arbandyo ship $ */
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;
146 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
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 -- Bug 10167052 .. Projects - Payroll Integration ...
214 Type JOB_ID_TYP IS TABLE OF Pa_Transaction_Interface_All.JOB_ID%TYPE
215 INDEX BY BINARY_INTEGER;
216
217 Type JOB_NAME_TYP IS TABLE OF Pa_Transaction_Interface_All.JOB_NAME%TYPE
218 INDEX BY BINARY_INTEGER;
219
220 Type LOCATION_ID_TYP IS TABLE OF Pa_Transaction_Interface_All.LOCATION_ID%TYPE
221 INDEX BY BINARY_INTEGER;
222
223 Type LOCATION_CODE_TYP IS TABLE OF Pa_Transaction_Interface_All.LOCATION_CODE%TYPE
224 INDEX BY BINARY_INTEGER;
225
226 Type PAY_ELEMENT_TYPE_ID_TYP IS TABLE OF Pa_Transaction_Interface_All.PAY_ELEMENT_TYPE_ID%TYPE
227 INDEX BY BINARY_INTEGER;
228
229 -- Start: Added for CBS Enhancement Bug 16220146
230 Type Cbs_Element_Id_Typ IS TABLE OF Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE
231 INDEX BY BINARY_INTEGER;
232
233 Type Cbs_Element_Name_Typ IS TABLE OF Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE
234 INDEX BY BINARY_INTEGER;
235 -- End: Added for CBS Enhancement Bug 16220146
236
237 Procedure Insert_Row (
238 x_rowid IN OUT NOCOPY VARCHAR2,
239 x_txn_interface_id IN OUT NOCOPY NUMBER,
240 x_last_update_date IN DATE,
241 x_last_updated_by IN NUMBER,
242 x_creation_date IN DATE,
243 x_created_by IN NUMBER,
244 x_transaction_source IN VARCHAR2,
245 x_user_txn_source IN VARCHAR2,
246 x_batch_name IN VARCHAR2,
247 x_expenditure_end_date IN DATE ,
248 x_person_business_group_name IN VARCHAR2 default NULL,
249 x_employee_number IN VARCHAR2,
250 x_organization_name IN VARCHAR2,
251 x_expenditure_item_date IN DATE,
252 x_project_number IN VARCHAR2,
253 x_task_number IN VARCHAR2,
254 x_expenditure_type IN VARCHAR2,
255 x_system_linkage IN VARCHAR2,
256 x_non_labor_resource IN VARCHAR2,
257 x_non_labor_res_org IN VARCHAR2,
258 x_quantity IN NUMBER,
259 x_raw_cost IN NUMBER,
260 x_raw_cost_rate IN NUMBER,
261 x_burden_cost IN NUMBER,
262 x_burden_cost_rate IN NUMBER,
263 x_expenditure_comment IN VARCHAR2,
264 x_gl_date IN DATE,
265 x_txn_status_code IN VARCHAR2,
266 x_txn_rejection_code IN VARCHAR2,
267 x_org_txn_reference IN VARCHAR2,
268 x_unmatched_txn_flag IN VARCHAR2,
269 x_expenditure_id IN NUMBER,
270 x_attribute_category IN VARCHAR2,
271 x_attribute1 IN VARCHAR2,
272 x_attribute2 IN VARCHAR2,
273 x_attribute3 IN VARCHAR2,
274 x_attribute4 IN VARCHAR2,
275 x_attribute5 IN VARCHAR2,
276 x_attribute6 IN VARCHAR2,
277 x_attribute7 IN VARCHAR2,
278 x_attribute8 IN VARCHAR2,
279 x_attribute9 IN VARCHAR2,
280 x_attribute10 IN VARCHAR2,
281 x_dr_ccid IN NUMBER,
282 x_cr_ccid IN NUMBER,
283 x_cdl_sys_ref1 IN VARCHAR2,
284 x_cdl_sys_ref2 IN VARCHAR2,
285 x_cdl_sys_ref3 IN VARCHAR2,
286 x_xface_id IN NUMBER,
287 x_receipt_currency_amount IN NUMBER,
288 x_receipt_currency_code IN VARCHAR2,
289 x_receipt_exchange_rate IN NUMBER,
290 x_denom_currency_code IN VARCHAR2,
291 x_denom_raw_cost IN NUMBER,
292 x_denom_burdened_cost IN NUMBER,
293 x_acct_rate_date IN DATE,
294 x_acct_rate_type IN VARCHAR2,
295 x_acct_exchange_rate IN NUMBER,
296 x_acct_raw_cost IN NUMBER,
297 x_acct_burdened_cost IN NUMBER,
298 x_acct_exchange_rounding_limit IN NUMBER,
299 x_project_currency_code IN VARCHAR2,
300 x_project_rate_date IN DATE,
301 x_project_rate_type IN VARCHAR2,
302 x_project_exchange_rate IN NUMBER,
303 x_orig_exp_txn_reference1 IN VARCHAR2,
304 x_orig_exp_txn_reference2 IN VARCHAR2,
305 x_orig_exp_txn_reference3 IN VARCHAR2,
306 x_orig_user_exp_txn_reference IN VARCHAR2,
307 x_vendor_number IN VARCHAR2,
308 x_override_to_oname IN VARCHAR2,
309 -- SST Changes
310 x_reversed_orig_txn_reference IN VARCHAR2 DEFAULT NULL,
311 x_billable_flag IN VARCHAR2 DEFAULT NULL,
312 -- PA-I Changes
313 X_Projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
314 X_Projfunc_cost_rate_date IN DATE DEFAULT NULL,
315 X_Projfunc_cost_rate_type IN VARCHAR2 DEFAULT NULL,
316 X_Projfunc_cost_exchange_rate IN NUMBER DEFAULT NULL,
317 X_project_raw_cost IN NUMBER DEFAULT NULL,
318 X_project_burdened_cost IN NUMBER DEFAULT NULL,
319 X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
320 X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
321 -- AP Discounts
322 x_cdl_sys_ref4 IN VARCHAR2 DEFAULT NULL,
323 -- PA-J changes
324 x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
325 -- Pa-K Changes
326 P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
327 P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
328 P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
329 P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
330 P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
331 P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
332 P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
333 P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
334 P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
335 P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
336 -- PA.M/CWK changes
337 P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
338 P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
339 P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
340 P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
341 P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
342 P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
343 -- End PA.M/CWK changes
344 P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
345 P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
346 P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
347 -- 12i MOAC changes
348 P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL,
349 -- P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
350 -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
351 P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
352 ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
353 ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
354 ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
355 ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
356 -- Start: Added for CBS Enhancement Bug 16220146
357 ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
358 ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
359 -- End: Added for CBS Enhancement Bug 16220146
360 );
361
362
363 Procedure Update_Row (
364 X_RowId IN VARCHAR2,
365 X_Txn_Interface_Id IN NUMBER,
366 X_Last_Update_Date IN DATE,
367 X_Last_Updated_By IN NUMBER,
368 X_Creation_Date IN DATE,
369 X_Created_By IN NUMBER,
370 X_Transaction_Source IN VARCHAR2,
371 X_User_Txn_Source IN VARCHAR2,
372 X_Batch_Name IN VARCHAR2,
373 X_Expenditure_End_Date IN DATE,
374 X_Person_Business_Group_Name IN VARCHAR2 default NULL,
375 X_Employee_Number IN VARCHAR2,
376 X_Organization_Name IN VARCHAR2,
377 X_Expenditure_Item_Date IN DATE,
378 X_Project_Number IN VARCHAR2,
379 X_Task_Number IN VARCHAR2,
380 X_Expenditure_Type IN VARCHAR2,
381 X_System_Linkage IN VARCHAR2,
382 X_Non_Labor_Resource IN VARCHAR2,
383 X_Non_Labor_Res_Org IN VARCHAR2,
384 X_Quantity IN NUMBER,
385 X_Raw_Cost IN NUMBER,
386 X_Raw_Cost_Rate IN NUMBER,
387 X_Burden_Cost IN NUMBER,
388 X_Burden_Cost_Rate IN NUMBER,
389 X_Expenditure_Comment IN VARCHAR2,
390 X_Gl_Date IN DATE,
391 X_Txn_Status_Code IN VARCHAR2,
392 X_Txn_Rejection_Code IN VARCHAR2,
393 X_Org_Txn_Reference IN VARCHAR2,
394 X_Unmatched_Txn_Flag IN VARCHAR2,
395 X_Expenditure_Id IN NUMBER,
396 X_Attribute_Category IN VARCHAR2,
397 X_Attribute1 IN VARCHAR2,
398 X_Attribute2 IN VARCHAR2,
399 X_Attribute3 IN VARCHAR2,
400 X_Attribute4 IN VARCHAR2,
401 X_Attribute5 IN VARCHAR2,
402 X_Attribute6 IN VARCHAR2,
403 X_Attribute7 IN VARCHAR2,
404 X_Attribute8 IN VARCHAR2,
405 X_Attribute9 IN VARCHAR2,
406 X_Attribute10 IN VARCHAR2,
407 X_Dr_Ccid IN NUMBER,
408 X_Cr_Ccid IN NUMBER,
409 X_Cdl_Sys_Ref1 IN VARCHAR2,
410 X_Cdl_Sys_Ref2 IN VARCHAR2,
411 X_Cdl_Sys_Ref3 IN VARCHAR2,
412 X_Receipt_Currency_Amount IN NUMBER,
413 X_Receipt_Currency_Code IN VARCHAR2,
414 X_Receipt_Exchange_Rate IN NUMBER,
415 X_Denom_Currency_Code IN VARCHAR2,
416 X_Denom_Raw_Cost IN NUMBER,
417 X_Denom_Burdened_Cost IN NUMBER,
418 X_Acct_Rate_Date IN DATE,
419 X_Acct_Rate_Type IN VARCHAR2,
420 X_Acct_Exchange_Rate IN NUMBER,
421 X_Acct_Raw_Cost IN NUMBER,
422 X_Acct_Burdened_Cost IN NUMBER,
423 X_Acct_Exchange_Rounding_Limit IN NUMBER,
424 X_Project_Currency_Code IN VARCHAR2,
425 X_Project_Rate_Date IN DATE,
426 X_Project_Rate_Type IN VARCHAR2,
427 X_Project_Exchange_Rate IN NUMBER,
428 X_Orig_Exp_Txn_Reference1 IN VARCHAR2,
429 X_Orig_Exp_Txn_Reference2 IN VARCHAR2,
430 X_Orig_Exp_Txn_Reference3 IN VARCHAR2,
431 X_Orig_User_Exp_Txn_Reference IN VARCHAR2,
432 X_Vendor_Number IN VARCHAR2,
433 X_Override_To_Oname IN VARCHAR2,
434 -- SST Changes
435 X_Reversed_Orig_Txn_Reference IN VARCHAR2 DEFAULT NULL,
436 X_Billable_Flag IN VARCHAR2 DEFAULT NULL,
437 -- PA-I Changes
438 X_ProjFunc_Currency_Code IN VARCHAR2 DEFAULT NULL,
439 X_ProjFunc_Cost_Rate_Date IN DATE DEFAULT NULL,
440 X_ProjFunc_Cost_Rate_Type IN VARCHAR2 DEFAULT NULL,
441 X_ProjFunc_Cost_Exchange_Rate IN NUMBER DEFAULT NULL,
442 X_Project_Raw_Cost IN NUMBER DEFAULT NULL,
443 X_Project_Burdened_Cost IN NUMBER DEFAULT NULL,
444 X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
445 X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
446 -- AP Discounts
447 X_Cdl_Sys_Ref4 IN VARCHAR2 DEFAULT NULL,
448 -- PA-J changes
449 X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
450 -- PA-K Changes
451 P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
452 P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
453 P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
454 P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
455 P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
456 P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
457 P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
458 P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
459 P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
460 P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
461 -- PA.M/CWK changes
462 P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
463 P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
464 P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
465 P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
466 P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
467 P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
468 -- PA.M/CWK changes
469 P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
470 P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
471 P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
472 --P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
473 --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
474 P_JOB_ID IN PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
475 ,P_JOB_NAME IN PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
476 ,P_LOCATION_ID IN PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
477 ,P_LOCATION_CODE IN PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
478 ,P_PAY_ELEMENT_TYPE_ID IN PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
479 -- Start: Added for CBS Enhancement Bug 16220146
480 ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
481 ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
482 -- End: Added for CBS Enhancement Bug 16220146
483 );
484
485 Procedure Delete_Row (X_RowId IN VARCHAR2);
486
487 Procedure Lock_Row (X_RowId IN VARCHAR2);
488
489 Procedure Bulk_Insert (
490 P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
491 P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
492 P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
493 P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
494 P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
495 P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
496 P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
497 P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
498 P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
499 P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
500 P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
501 P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
502 P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
503 P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
504 P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
505 P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
506 P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
507 P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
508 P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
509 P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
510 P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
511 P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
512 P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
513 P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
514 P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
515 P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
516 P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
517 P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
518 P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
519 P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
520 P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
521 P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
522 P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
523 P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
524 P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
525 P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
526 P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
527 P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
528 P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
529 P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
530 P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
531 P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
532 P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
533 P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
534 P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
535 P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
536 P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
537 P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
538 P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
539 P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
540 P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
541 P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
542 P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
543 P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
544 P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
545 P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
546 P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
547 P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
548 P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
549 P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
550 P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
551 P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
552 P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
553 P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
554 P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
555 P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
556 P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
557 P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
558 P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
559 P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
560 P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
561 P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
562 P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
563 P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
564 P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
565 P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
566 P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
567 P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
568 P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
569 P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
570 P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
571 P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
572 P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
573 P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
577 P_Accrual_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_Flag_Typ,
574 P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
575 P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
576 P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
578 P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
579 P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
580 P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
581 P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
582 -- Begin PA.M/CWK changes
583 P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
584 P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
585 P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
586 P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
587 P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
588 P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
589 -- End PA.M/CWK changes
590 P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
591 P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
592 P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ,
593 -- 12i MOAC changes
594 P_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.OU_Id_Typ
595 --Payroll Integration changes
596 ,P_JOB_ID_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_ID_TYP
597 ,P_JOB_NAME_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_NAME_TYP
598 ,P_LOCATION_ID_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_ID_TYP
599 ,P_LOCATION_CODE_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_CODE_TYP
600 ,P_PAY_ELEMENT_TYPE_ID_TBL IN Pa_Txn_Interface_Items_Pkg.PAY_ELEMENT_TYPE_ID_TYP
601 -- Start: Added for CBS Enhancement Bug 16220146
602 ,P_Cbs_Element_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Id_Typ
603 ,P_Cbs_Element_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Name_Typ
604 -- End: Added for CBS Enhancement Bug 16220146
605 );
606
607 Procedure Bulk_Update (
608 P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
609 P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
610 P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
611 P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
612 P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
613 P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
614 P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
615 P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
616 P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
617 P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
618 P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
619 P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
620 P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
621 P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
622 P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
623 P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
624 P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
625 P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
626 P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
627 P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
628 P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
629 P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
630 P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
631 P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
632 P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
633 P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
634 P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
635 P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
636 P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
637 P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
638 P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
639 P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
640 P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
641 P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
642 P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
643 P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
644 P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
645 P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
646 P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
647 P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
648 P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
649 P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
650 P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
651 P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
652 P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
653 P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
654 P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
655 P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
656 P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
657 P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
658 P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
659 P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
660 P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
661 P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
662 P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
663 P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
664 P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
665 P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
666 P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
667 P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
668 P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
669 P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
670 P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
671 P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
672 P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
673 P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
674 P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
675 P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
676 P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
677 P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
678 P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
679 P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
680 P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
681 P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
682 P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
683 P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
684 P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
685 P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
686 P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
687 P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
688 P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
689 P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
690 P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
691 P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
692 P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
693 P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
694 P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
695 P_Accrual_flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_flag_Typ,
696 P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
697 P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
698 P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
699 P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
700 -- Begin PA.M/CWK changes
701 P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
702 P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
703 P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
704 P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
705 P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
706 P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
707 -- End PA.M/CWK changes
708 P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
709 P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
710 P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ
711 --Payroll Integration changes
712 ,P_JOB_ID_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_ID_TYP
713 ,P_JOB_NAME_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_NAME_TYP
714 ,P_LOCATION_ID_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_ID_TYP
715 ,P_LOCATION_CODE_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_CODE_TYP
716 ,P_PAY_ELEMENT_TYPE_ID_TBL IN Pa_Txn_Interface_Items_Pkg.PAY_ELEMENT_TYPE_ID_TYP
717 -- Start: Added for CBS Enhancement Bug 16220146
718 ,P_Cbs_Element_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Id_Typ
719 ,P_Cbs_Element_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Name_Typ
720 -- End: Added for CBS Enhancement Bug 16220146
721 );
722
723 END Pa_Txn_Interface_Items_Pkg;
[Home] [Help]