[Home] [Help]
PACKAGE BODY: APPS.PA_TXN_INTERFACE_ITEMS_PKG
Source
1 Package Body Pa_Txn_Interface_Items_Pkg as
2 /* $Header: PAXRTXNB.pls 120.6.12020000.2 2013/03/31 04:04:47 arbandyo ship $ */
3
4 Procedure Insert_Row (
5 X_rowid IN OUT NOCOPY VARCHAR2,
6 X_txn_interface_id IN OUT NOCOPY NUMBER,
7 X_last_update_date IN DATE,
8 X_last_updated_by IN NUMBER,
9 X_creation_date IN DATE,
10 X_created_by IN NUMBER,
11 X_transaction_source IN VARCHAR2,
12 X_user_txn_source IN VARCHAR2,
13 X_batch_name IN VARCHAR2,
14 X_expenditure_end_date IN DATE,
15 X_person_business_group_name IN VARCHAR2 Default Null,
16 X_employee_number IN VARCHAR2,
17 X_organization_name IN VARCHAR2,
18 X_expenditure_item_date IN DATE,
19 X_project_number IN VARCHAR2,
20 X_task_number IN VARCHAR2,
21 X_expenditure_type IN VARCHAR2,
22 X_system_linkage IN VARCHAR2,
23 X_non_labor_resource IN VARCHAR2,
24 X_non_labor_res_org IN VARCHAR2,
25 X_quantity IN NUMBER,
26 X_raw_cost IN NUMBER,
27 X_raw_cost_rate IN NUMBER,
28 X_burden_cost IN NUMBER,
29 X_burden_cost_rate IN NUMBER,
30 X_expenditure_comment IN VARCHAR2,
31 X_gl_date IN DATE,
32 X_txn_status_code IN VARCHAR2,
33 X_txn_rejection_code IN VARCHAR2,
34 X_org_txn_reference IN VARCHAR2,
35 X_unmatched_txn_flag IN VARCHAR2,
36 X_expenditure_id IN NUMBER,
37 X_attribute_category IN VARCHAR2,
38 X_attribute1 IN VARCHAR2,
39 X_attribute2 IN VARCHAR2,
40 X_attribute3 IN VARCHAR2,
41 X_attribute4 IN VARCHAR2,
42 X_attribute5 IN VARCHAR2,
43 X_attribute6 IN VARCHAR2,
44 X_attribute7 IN VARCHAR2,
45 X_attribute8 IN VARCHAR2,
46 X_attribute9 IN VARCHAR2,
47 X_attribute10 IN VARCHAR2,
48 X_dr_ccid IN NUMBER,
49 X_cr_ccid IN NUMBER,
50 X_cdl_sys_ref1 IN VARCHAR2,
51 X_cdl_sys_ref2 IN VARCHAR2,
52 X_cdl_sys_ref3 IN VARCHAR2,
53 X_xface_id IN NUMBER,
54 X_receipt_currency_amount IN NUMBER,
55 X_receipt_currency_code IN VARCHAR2,
56 X_receipt_exchange_rate IN NUMBER,
57 X_denom_currency_code IN VARCHAR2,
58 X_denom_raw_cost IN NUMBER,
59 X_denom_burdened_cost IN NUMBER,
60 X_acct_rate_date IN DATE,
61 X_acct_rate_type IN VARCHAR2,
62 X_acct_exchange_rate IN NUMBER,
63 X_acct_raw_cost IN NUMBER,
64 X_acct_burdened_cost IN NUMBER,
65 X_acct_exchange_rounding_limit IN NUMBER,
66 X_project_currency_code IN VARCHAR2,
67 X_project_rate_date IN DATE,
68 X_project_rate_type IN VARCHAR2,
69 X_project_exchange_rate IN NUMBER,
70 -- Trx_import enhancement: These new parameters are
71 -- used to populate PA_TRANSACTION_INTERFACE table's
72 -- new columns
73 X_orig_exp_txn_reference1 IN VARCHAR2,
74 X_orig_exp_txn_reference2 IN VARCHAR2,
75 X_orig_exp_txn_reference3 IN VARCHAR2,
76 X_orig_user_exp_txn_reference IN VARCHAR2,
77 X_vendor_number IN VARCHAR2,
78 X_override_to_oname IN VARCHAR2,
79 -- SST Changes: New columns added into the table for
80 -- SST changes
81 x_reversed_orig_txn_reference IN VARCHAR2 DEFAULT NULL,
82 x_billable_flag IN VARCHAR2 DEFAULT NULL,
83 -- PA-I Changes
84 X_Projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
85 X_Projfunc_cost_rate_date IN DATE DEFAULT NULL,
86 X_Projfunc_cost_rate_type IN VARCHAR2 DEFAULT NULL,
87 X_Projfunc_cost_exchange_rate IN NUMBER DEFAULT NULL,
88 X_project_raw_cost IN NUMBER DEFAULT NULL,
89 X_project_burdened_cost IN NUMBER DEFAULT NULL,
90 X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
91 X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
92 -- AP Discounts
93 x_cdl_sys_ref4 IN VARCHAR2 DEFAULT NULL,
94 -- PA-J changes
95 x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96 -- Pa-K Changes
100 P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
97 P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98 P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99 P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
101 P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102 P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103 P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104 P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105 P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106 P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107 -- Begin PA.M/CWK changes
108 P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109 P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110 P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111 P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112 P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113 P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114 -- End PA.M/CWK changes
115 P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116 P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117 P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118 -- 12i MOAC changes
119 P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120 --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121 --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122 , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123 ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124 ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125 ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126 ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127 -- Start: Added for CBS Enhancement Bug 16220146
128 ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
129 ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
130 -- End: Added for CBS Enhancement Bug 16220146
131 )
132
133 IS
134
135 cursor return_rowid is
136 select rowid
137 from pa_transaction_interface_all
138 where txn_interface_id = X_txn_interface_id;
139
140 cursor get_itemid is
141 select pa_txn_interface_s.nextval
142 from dual;
143
144 Begin
145
146 If (X_Txn_Interface_Id Is Null) Then
147
148 Open Get_ItemId;
149 Fetch Get_ItemId Into X_Txn_Interface_Id;
150 Close Get_ItemId;
151
152 End If;
153
154 Insert INTO Pa_Transaction_Interface (
155 TRANSACTION_SOURCE ,
156 BATCH_NAME ,
157 EXPENDITURE_ENDING_DATE ,
158 EMPLOYEE_NUMBER ,
159 ORGANIZATION_NAME ,
160 EXPENDITURE_ITEM_DATE ,
161 PROJECT_NUMBER ,
162 TASK_NUMBER ,
163 EXPENDITURE_TYPE ,
164 NON_LABOR_RESOURCE ,
165 NON_LABOR_RESOURCE_ORG_NAME ,
166 QUANTITY ,
167 RAW_COST ,
168 EXPENDITURE_COMMENT ,
169 TRANSACTION_STATUS_CODE ,
170 TRANSACTION_REJECTION_CODE ,
171 ORIG_TRANSACTION_REFERENCE ,
172 ATTRIBUTE_CATEGORY ,
173 ATTRIBUTE1 ,
174 ATTRIBUTE2 ,
175 ATTRIBUTE3 ,
176 ATTRIBUTE4 ,
177 ATTRIBUTE5 ,
178 ATTRIBUTE6 ,
179 ATTRIBUTE7 ,
180 ATTRIBUTE8 ,
181 ATTRIBUTE9 ,
182 ATTRIBUTE10 ,
183 RAW_COST_RATE ,
184 UNMATCHED_NEGATIVE_TXN_FLAG ,
185 DR_CODE_COMBINATION_ID ,
186 CR_CODE_COMBINATION_ID ,
187 CDL_SYSTEM_REFERENCE1 ,
188 CDL_SYSTEM_REFERENCE2 ,
189 CDL_SYSTEM_REFERENCE3 ,
190 GL_DATE ,
191 BURDENED_COST ,
192 BURDENED_COST_RATE ,
193 SYSTEM_LINKAGE ,
194 TXN_INTERFACE_ID ,
195 USER_TRANSACTION_SOURCE,
196 INTERFACE_ID,
197 receipt_currency_amount,
198 receipt_currency_code,
199 receipt_exchange_rate,
200 denom_currency_code,
201 denom_raw_cost,
202 denom_burdened_cost,
203 acct_rate_date,
204 acct_rate_type,
205 acct_exchange_rate,
206 acct_raw_cost,
207 acct_burdened_cost,
208 acct_exchange_rounding_limit,
209 project_currency_code,
210 project_rate_date,
211 project_rate_type,
212 project_exchange_rate,
213 orig_exp_txn_reference1,
214 orig_exp_txn_reference2,
215 orig_exp_txn_reference3,
216 orig_user_exp_txn_reference,
217 vendor_number,
218 override_to_organization_name,
219 -- SST Changes
220 reversed_orig_txn_reference,
221 billable_flag,
222 expenditure_id,
223 person_business_group_name,
224 -- PA-I Changes
225 projfunc_currency_code,
226 projfunc_cost_rate_type,
227 projfunc_cost_rate_date,
228 projfunc_cost_exchange_rate,
229 project_raw_cost,
230 project_burdened_cost,
231 assignment_name,
232 work_type_name,
233 cdl_system_reference4,
234 -- PA-J Changes
235 accrual_flag,
236 -- PA-K Changes
237 Project_Id,
238 Task_Id,
239 Person_Business_Group_Id,
240 Person_Id,
241 Organization_Id,
242 Non_Labor_Resource_Org_Id,
243 Override_To_Organization_Id,
244 Assignment_Id,
245 Work_Type_Id,
246 Vendor_Id,
247 -- CWK changes PA.M
248 PO_Number,
249 PO_Header_Id,
250 PO_Line_Num,
251 PO_Line_Id,
252 PO_Price_Type,
253 Person_Type,
254 Inventory_Item_Id,
255 WIP_Resource_Id,
256 Unit_Of_Measure,
257 -- 12i MOAC changes
258 Org_Id,
259 Created_By, /*Bug 5870008 */
260 -- Agreement_id, --FSIO Changes
261 -- Agreement_number,
262 JOB_ID
263 ,JOB_NAME
264 ,LOCATION_ID
265 ,LOCATION_CODE
266 ,PAY_ELEMENT_TYPE_ID
267 -- Start: Added for CBS Enhancement Bug 16220146
268 ,Cbs_Element_Id
269 ,Cbs_Element_Name
270 -- End: Added for CBS Enhancement Bug 16220146
271 )
272 values (
273 X_transaction_source ,
274 X_batch_name ,
275 X_expenditure_end_date ,
276 X_employee_number ,
277 X_organization_name ,
278 X_expenditure_item_date ,
279 X_project_number ,
280 X_task_number ,
281 X_expenditure_type ,
282 X_non_labor_resource ,
283 X_non_labor_res_org ,
284 X_quantity ,
285 X_raw_cost ,
286 X_expenditure_comment ,
287 X_txn_status_code ,
288 X_txn_rejection_code ,
289 X_org_txn_reference ,
290 X_attribute_category ,
291 X_attribute1 ,
292 X_attribute2 ,
293 X_attribute3 ,
294 X_attribute4 ,
295 X_attribute5 ,
296 X_attribute6 ,
297 X_attribute7 ,
298 X_attribute8 ,
299 X_attribute9 ,
300 X_attribute10 ,
301 X_raw_cost_rate ,
302 X_unmatched_txn_flag ,
303 X_dr_ccid ,
304 X_cr_ccid ,
305 X_cdl_sys_ref1 ,
306 X_cdl_sys_ref2 ,
307 X_cdl_sys_ref3 ,
308 X_gl_date ,
309 X_burden_cost,
310 X_burden_cost_rate,
311 X_system_linkage ,
312 X_txn_interface_id,
313 X_user_txn_source,
314 X_xface_id,
315 X_receipt_currency_amount,
316 X_receipt_currency_code,
317 X_receipt_exchange_rate,
318 X_denom_currency_code,
319 X_denom_raw_cost,
320 X_denom_burdened_cost,
321 X_acct_rate_date,
322 X_acct_rate_type,
323 X_acct_exchange_rate,
324 X_acct_raw_cost,
325 X_acct_burdened_cost,
326 X_acct_exchange_rounding_limit,
327 X_project_currency_code,
328 X_project_rate_date,
329 X_project_rate_type,
330 X_project_exchange_rate,
331 X_orig_exp_txn_reference1,
332 X_orig_exp_txn_reference2,
333 X_orig_exp_txn_reference3,
334 X_orig_user_exp_txn_reference,
335 X_vendor_number,
336 X_override_to_oname,
337 -- SST Changes
338 X_reversed_orig_txn_reference,
339 X_billable_flag,
340 X_expenditure_id,
341 X_person_business_group_name,
342 -- PA-I Changes
343 X_projfunc_currency_code,
344 X_projfunc_cost_rate_type,
345 X_projfunc_cost_rate_date,
346 X_projfunc_cost_exchange_rate,
347 X_project_raw_cost,
348 X_project_burdened_cost,
349 X_assignment_name,
350 X_work_type_name,
351 X_cdl_sys_ref4,
352 -- PA-J Changes
353 X_accrual_flag,
354 -- PA-K Changes
355 P_Project_Id,
356 P_Task_Id,
357 P_Person_Business_Group_Id,
358 P_Person_Id,
359 P_Organization_Id,
360 P_Non_Labor_Res_Org_Id,
361 P_Override_To_Org_Id,
362 P_Assignment_Id,
363 P_Work_Type_Id,
364 P_Vendor_Id,
365 -- Begin PA.M/CWK changes
366 P_PO_Number,
367 P_PO_Header_Id,
368 P_PO_Line_Num,
369 P_PO_Line_Id,
370 P_PO_Price_Type,
371 P_Person_Type,
372 -- End PA.M/CWK changes
373 P_Inventory_Item_Id,
374 P_WIP_Resource_Id,
375 P_Unit_Of_Measure,
376 -- 12i MOAC changes
377 P_Org_Id,
378 X_created_by, /*Bug-5870008*/
379 -- P_Agreement_id, --FSIO Chnages
380 -- P_Agreement_number
381 P_JOB_ID
382 ,P_JOB_NAME
383 ,P_LOCATION_ID
384 ,P_LOCATION_CODE
385 ,P_PAY_ELEMENT_TYPE_ID
386 -- Start: Added for CBS Enhancement Bug 16220146
387 ,P_Cbs_Element_id
388 ,P_Cbs_Element_Name
392 open return_rowid;
389 -- End: Added for CBS Enhancement Bug 16220146
390 );
391
393 fetch return_rowid into X_rowid;
394
395 if (return_rowid%notfound) then
396
397 raise NO_DATA_FOUND; -- should we return something else?
398
399 end if;
400 close return_rowid;
401
402 End Insert_Row;
403
404 Procedure Update_Row (
405 x_rowid IN VARCHAR2,
406 X_txn_interface_id IN NUMBER,
407 X_last_update_date IN DATE,
408 X_last_updated_by IN NUMBER,
409 X_creation_date IN DATE,
410 X_created_by IN NUMBER,
411 X_transaction_source IN VARCHAR2,
412 X_user_txn_source IN VARCHAR2,
413 X_batch_name IN VARCHAR2,
414 X_expenditure_end_date IN DATE,
415 X_person_business_group_name IN VARCHAR2 Default Null,
416 X_employee_number IN VARCHAR2,
417 X_organization_name IN VARCHAR2,
418 X_expenditure_item_date IN DATE,
419 X_project_number IN VARCHAR2,
420 X_task_number IN VARCHAR2,
421 X_expenditure_type IN VARCHAR2,
422 X_system_linkage IN VARCHAR2,
423 X_non_labor_resource IN VARCHAR2,
424 X_non_labor_res_org IN VARCHAR2,
425 X_quantity IN NUMBER,
426 X_raw_cost IN NUMBER,
427 X_raw_cost_rate IN NUMBER,
428 X_burden_cost IN NUMBER,
429 X_burden_cost_rate IN NUMBER,
430 X_expenditure_comment IN VARCHAR2,
431 X_gl_date IN DATE,
432 X_txn_status_code IN VARCHAR2,
433 X_txn_rejection_code IN VARCHAR2,
434 X_org_txn_reference IN VARCHAR2,
435 X_unmatched_txn_flag IN VARCHAR2,
436 X_expenditure_id IN NUMBER,
437 X_attribute_category IN VARCHAR2,
438 X_attribute1 IN VARCHAR2,
439 X_attribute2 IN VARCHAR2,
440 X_attribute3 IN VARCHAR2,
441 X_attribute4 IN VARCHAR2,
442 X_attribute5 IN VARCHAR2,
443 X_attribute6 IN VARCHAR2,
444 X_attribute7 IN VARCHAR2,
445 X_attribute8 IN VARCHAR2,
446 X_attribute9 IN VARCHAR2,
447 X_attribute10 IN VARCHAR2,
448 X_dr_ccid IN NUMBER,
449 X_cr_ccid IN NUMBER,
450 X_cdl_sys_ref1 IN VARCHAR2,
451 X_cdl_sys_ref2 IN VARCHAR2,
452 X_cdl_sys_ref3 IN VARCHAR2,
453 x_receipt_currency_amount IN NUMBER,
454 x_receipt_currency_code IN VARCHAR2,
455 x_receipt_exchange_rate IN NUMBER,
456 x_denom_currency_code IN VARCHAR2,
457 x_denom_raw_cost IN NUMBER,
458 x_denom_burdened_cost IN NUMBER,
459 x_acct_rate_date IN DATE,
460 x_acct_rate_type IN VARCHAR2,
461 x_acct_exchange_rate IN NUMBER,
462 x_acct_raw_cost IN NUMBER,
463 x_acct_burdened_cost IN NUMBER,
464 x_acct_exchange_rounding_limit IN NUMBER,
465 x_project_currency_code IN VARCHAR2,
466 x_project_rate_date IN DATE,
467 x_project_rate_type IN VARCHAR2,
468 x_project_exchange_rate IN NUMBER,
469 -- Trx_import enhancement: These parameters are needed
470 -- to populate PA_TRANSACTION_INTERFACE table's new
471 -- columns
472 X_orig_exp_txn_reference1 IN VARCHAR2,
473 X_orig_exp_txn_reference2 IN VARCHAR2,
474 X_orig_exp_txn_reference3 IN VARCHAR2,
475 X_orig_user_exp_txn_reference IN VARCHAR2,
476 X_vendor_number IN VARCHAR2,
477 X_override_to_oname IN VARCHAR2,
478 -- SST Changes
479 X_Reversed_Orig_Txn_Reference IN VARCHAR2 DEFAULT NULL,
480 X_Billable_Flag IN VARCHAR2 DEFAULT NULL,
481 -- PA-I Changes
482 X_ProjFunc_Currency_Code IN VARCHAR2 DEFAULT NULL,
483 X_ProjFunc_Cost_Rate_Date IN DATE DEFAULT NULL,
484 X_ProjFunc_Cost_Rate_Type IN VARCHAR2 DEFAULT NULL,
485 X_ProjFunc_Cost_Exchange_Rate IN NUMBER DEFAULT NULL,
486 X_Project_Raw_Cost IN NUMBER DEFAULT NULL,
487 X_Project_Burdened_Cost IN NUMBER DEFAULT NULL,
488 X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
489 X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
490 -- AP Discounts
491 X_Cdl_Sys_Ref4 IN VARCHAR2 DEFAULT NULL,
492 -- PA-J changes
493 X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
494 -- PA-K Changes
495 P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
496 P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497 P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498 P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499 P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500 P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501 P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502 P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503 P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504 P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505 -- Begin PA.M/CWK changes
506 P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507 P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508 P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509 P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510 P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511 P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512 -- End PA.M/CWK changes
513 P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514 P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515 P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516 -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517 -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518 P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519 ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520 ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521 ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522 ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523 -- Start: Added for CBS Enhancement Bug 16220146
524 ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
525 ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
526 -- End: Added for CBS Enhancement Bug 16220146
527 )
528 IS
529
530 Begin
531
532 Update Pa_Transaction_Interface
533 Set Transaction_Source = X_transaction_source ,
534 Batch_Name = X_batch_name ,
535 Expenditure_Ending_Date = X_expenditure_end_date ,
536 Employee_Number = X_employee_number ,
537 Organization_Name = X_organization_name ,
538 Expenditure_Item_Date = X_expenditure_item_date ,
539 Project_Number = X_project_number ,
540 Task_Number = X_task_number ,
541 Expenditure_Type = X_expenditure_type ,
542 Non_Labor_Resource = X_non_labor_resource ,
543 Non_Labor_Resource_Org_Name = X_non_labor_res_org ,
544 Quantity = X_quantity ,
545 Raw_Cost = X_raw_cost ,
546 Expenditure_Comment = X_expenditure_comment ,
547 Transaction_Status_Code = X_txn_status_code ,
548 Transaction_Rejection_Code = X_txn_rejection_code ,
549 Orig_Transaction_Reference = X_org_txn_reference ,
550 Attribute_Category = X_attribute_category ,
551 Attribute1 = X_attribute1 ,
552 Attribute2 = X_attribute2 ,
553 Attribute3 = X_attribute3 ,
554 Attribute4 = X_attribute4 ,
558 Attribute8 = X_attribute8 ,
555 Attribute5 = X_attribute5 ,
556 Attribute6 = X_attribute6 ,
557 Attribute7 = X_attribute7 ,
559 Attribute9 = X_attribute9 ,
560 Attribute10 = X_attribute10 ,
561 Raw_Cost_Rate = X_raw_cost_rate ,
562 Unmatched_Negative_Txn_Flag = X_unmatched_txn_flag ,
563 Dr_Code_Combination_Id = X_dr_ccid ,
564 Cr_Code_Combination_Id = X_cr_ccid ,
565 Cdl_System_Reference1 = X_cdl_sys_ref1 ,
566 Cdl_System_Reference2 = X_cdl_sys_ref2 ,
567 Cdl_System_Reference3 = X_cdl_sys_ref3 ,
568 Gl_Date = X_gl_date ,
569 Burdened_Cost = X_burden_cost ,
570 Burdened_Cost_Rate = X_burden_cost_rate ,
571 System_Linkage = X_system_linkage ,
572 User_Transaction_Source = X_user_txn_source ,
573 Receipt_Currency_Amount = X_receipt_currency_amount,
574 Receipt_Currency_Code = X_receipt_currency_code,
575 Receipt_Exchange_Rate = X_receipt_exchange_rate,
576 Denom_Currency_Code = X_denom_currency_code,
577 Denom_Raw_Cost = X_denom_raw_cost,
578 Denom_Burdened_Cost = X_denom_burdened_cost,
579 Acct_Rate_Date = X_acct_rate_date,
580 Acct_Rate_Type = X_acct_rate_type,
581 Acct_Exchange_Rate = X_acct_exchange_rate,
582 Acct_Raw_Cost = X_acct_raw_cost,
583 Acct_Burdened_Cost = X_acct_burdened_cost,
584 Acct_Exchange_Rounding_Limit = X_acct_exchange_rounding_limit,
585 Project_Currency_Code = X_project_currency_code,
586 Project_Rate_Date = X_project_rate_date,
587 Project_Rate_Type = X_project_rate_type,
588 Project_Exchange_Rate = X_project_exchange_rate,
589 Orig_Exp_Txn_Reference1 = X_orig_exp_txn_reference1,
590 Orig_Exp_Txn_Reference2 = X_orig_exp_txn_reference2,
591 Orig_Exp_Txn_Reference3 = X_orig_exp_txn_reference3,
592 Orig_User_Exp_Txn_Reference = X_orig_user_exp_txn_reference,
593 Vendor_Number = X_vendor_number,
594 Override_To_Organization_Name = X_override_to_oname,
595 -- SST Changes
596 Reversed_Orig_Txn_Reference = X_reversed_orig_txn_reference,
597 Billable_Flag = X_billable_flag,
598 Person_Business_Group_Name = X_person_business_group_name,
599 -- PA-I Changes
600 ProjFunc_Currency_Code = X_projfunc_currency_code,
601 ProjFunc_Cost_Rate_Type = X_projfunc_cost_rate_type,
602 ProjFunc_Cost_Rate_Date = X_projfunc_cost_rate_date,
603 ProjFunc_Cost_Exchange_Rate = X_projfunc_cost_exchange_rate,
604 Project_Raw_Cost = X_project_raw_cost,
605 Project_Burdened_Cost = X_project_burdened_cost,
606 Assignment_Name = X_assignment_name,
607 Work_Type_Name = X_work_type_name ,
608 Cdl_System_Reference4 = X_cdl_sys_ref4,
609 -- PA-J Changes
610 Accrual_Flag = X_accrual_flag,
611 -- PA-K Changes
612 Project_Id = P_Project_Id,
613 Task_Id = P_Task_Id,
614 Person_Business_Group_Id = P_Person_Business_Group_Id,
615 Person_Id = P_Person_Id,
616 Organization_Id = P_Organization_Id,
617 Non_Labor_Resource_Org_Id = P_Non_Labor_Res_Org_Id,
618 Override_To_Organization_Id = P_Override_To_Org_Id,
619 Assignment_Id = P_Assignment_Id,
620 Work_Type_Id = P_Work_Type_Id,
621 Vendor_Id = P_Vendor_Id,
622 -- Begin PA.M/CWK changes
623 PO_Number = P_PO_Number,
624 PO_Header_Id = P_PO_Header_Id,
625 PO_Line_Num = P_PO_Line_Num,
626 PO_Line_Id = P_PO_Line_Id,
627 PO_Price_Type = P_PO_Price_Type,
628 Person_Type = P_Person_Type,
629 -- End PA.M/CWK changes
630 Inventory_Item_Id = P_Inventory_Item_Id,
631 WIP_Resource_Id = P_WIP_Resource_Id,
632 Unit_Of_Measure = P_Unit_Of_Measure,
633 Last_Updated_By = X_last_updated_by, /*Bug -5870008*/
634 -- Agreement_id = P_Agreement_id, --FSIO Changes
635 -- Agreement_number = P_Agreement_number
636 JOB_ID = P_JOB_ID
637 ,JOB_NAME = P_JOB_NAME
638 ,LOCATION_ID = P_LOCATION_ID
639 ,LOCATION_CODE = P_LOCATION_CODE
640 ,PAY_ELEMENT_TYPE_ID = P_PAY_ELEMENT_TYPE_ID
641 -- Start: Added for CBS Enhancement Bug 16220146
642 ,Cbs_Element_Id = P_Cbs_Element_id
643 ,Cbs_Element_Name = P_Cbs_Element_Name
644 -- End: Added for CBS Enhancement Bug 16220146
645 Where
646 Txn_Interface_Id = X_Txn_Interface_Id;
647
648 End Update_Row;
649
650 Procedure Delete_Row (X_RowId IN Varchar2)
651
652 Is
653
654 Begin
655
656 Delete From Pa_Transaction_Interface_All
657 Where RowId = X_RowId ;
658
659 End Delete_Row;
660
661 Procedure Lock_Row (X_RowId IN Varchar2)
662
663 Is
664
665 Begin
666
667 Null;
668
669 End Lock_Row;
670
671 Procedure Bulk_Insert (
672 P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
673 P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
677 P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
674 P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
675 P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
676 P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
678 P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
679 P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
680 P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
681 P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
682 P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
683 P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
684 P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
685 P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
686 P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
687 P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
688 P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
689 P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
690 P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
691 P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
692 P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
693 P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
694 P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
695 P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
696 P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
697 P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
698 P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
699 P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
700 P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
701 P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
702 P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
703 P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
704 P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
705 P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
706 P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
707 P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
708 P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
709 P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
710 P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
711 P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
712 P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
713 P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
714 P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
715 P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
716 P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
717 P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
718 P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
719 P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
720 P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
721 P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
722 P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
723 P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
724 P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
725 P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
726 P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
727 P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
728 P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
729 P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
730 P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
731 P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
732 P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
733 P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
734 P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
735 P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
736 P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
737 P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
738 P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
739 P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
740 P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
741 P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
742 P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
743 P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
744 P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
745 P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
746 P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
747 P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
748 P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
749 P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
750 P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
751 P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
752 P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
753 P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
754 P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
755 P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
756 P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
757 P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
758 P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
759 P_Accrual_flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_flag_Typ,
760 P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
761 P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
762 P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
763 P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
764 -- Begin PA.M/CWK changes
765 P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
766 P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
767 P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
768 P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
769 P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
770 P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
771 -- End PA.M/CWK changes
772 P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
773 P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
774 P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ,
775 -- 12i MOAC changes
776 P_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.OU_Id_Typ
777 ,P_JOB_ID_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_ID_TYP
778 ,P_JOB_NAME_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_NAME_TYP
779 ,P_LOCATION_ID_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_ID_TYP
780 ,P_LOCATION_CODE_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_CODE_TYP
781 ,P_PAY_ELEMENT_TYPE_ID_TBL IN Pa_Txn_Interface_Items_Pkg.PAY_ELEMENT_TYPE_ID_TYP
782 -- Start: Added for CBS Enhancement Bug 16220146
783 ,P_Cbs_Element_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Id_Typ
784 ,P_Cbs_Element_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Name_Typ
785 -- End: Added for CBS Enhancement Bug 16220146
786 )
787
788 Is
789
790 Begin
791
792 ForAll i in P_Txn_Interface_Id_Tbl.First .. P_Txn_Interface_Id_Tbl.Last
793 Insert Into Pa_Transaction_Interface(
794 Transaction_Source ,
795 Batch_Name ,
796 Expenditure_Ending_Date ,
797 Employee_Number ,
798 Organization_Name ,
799 Expenditure_Item_Date ,
800 Project_Number ,
801 Task_Number ,
802 Expenditure_Type ,
803 Non_Labor_Resource ,
804 Non_Labor_Resource_Org_Name ,
805 Quantity ,
806 Raw_Cost ,
810 Orig_Transaction_Reference ,
807 Expenditure_Comment ,
808 Transaction_Status_Code ,
809 Transaction_Rejection_Code ,
811 Attribute_Category ,
812 Attribute1 ,
813 Attribute2 ,
814 Attribute3 ,
815 Attribute4 ,
816 Attribute5 ,
817 Attribute6 ,
818 Attribute7 ,
819 Attribute8 ,
820 Attribute9 ,
821 Attribute10 ,
822 Raw_Cost_Rate ,
823 Unmatched_Negative_Txn_Flag ,
824 Dr_Code_Combination_Id ,
825 Cr_Code_Combination_Id ,
826 Cdl_System_Reference1 ,
827 Cdl_System_Reference2 ,
828 Cdl_System_Reference3 ,
829 Gl_Date ,
830 Burdened_Cost ,
831 Burdened_Cost_Rate ,
832 System_Linkage ,
833 Txn_Interface_Id ,
834 User_Transaction_Source,
835 Interface_Id,
836 Receipt_Currency_Amount,
837 Receipt_Currency_Code,
838 Receipt_Exchange_Rate,
839 Denom_Currency_Code,
840 Denom_Raw_Cost,
841 Denom_Burdened_Cost,
842 Acct_Rate_Date,
843 Acct_Rate_Type,
844 Acct_Exchange_Rate,
845 Acct_Raw_Cost,
846 Acct_Burdened_Cost,
847 Acct_Exchange_Rounding_Limit,
848 Project_Currency_Code,
849 Project_Rate_Date,
850 Project_Rate_Type,
851 Project_Exchange_Rate,
852 Orig_Exp_Txn_Reference1,
853 Orig_Exp_Txn_Reference2,
854 Orig_Exp_Txn_Reference3,
855 Orig_User_Exp_Txn_Reference,
856 Vendor_Number,
857 Override_To_Organization_Name,
858 Reversed_Orig_Txn_Reference,
859 Billable_Flag,
860 Expenditure_Id,
861 Person_Business_Group_Name,
862 ProjFunc_Currency_Code,
863 ProjFunc_Cost_Rate_Type,
864 ProjFunc_Cost_Rate_Date,
865 ProjFunc_Cost_Exchange_Rate,
866 Project_Raw_Cost,
867 Project_Burdened_Cost,
868 Assignment_Name,
869 Work_Type_Name,
870 Cdl_System_Reference4,
871 Accrual_Flag,
872 Project_Id,
873 Task_Id,
874 Person_Business_Group_Id,
875 Person_Id,
876 Organization_Id,
877 Non_Labor_Resource_Org_Id,
878 Override_To_Organization_Id,
879 Assignment_Id,
880 Work_Type_Id,
881 Vendor_Id,
882 Last_Update_Date,
883 Last_Updated_By,
884 Creation_Date,
885 Created_By,
886 -- Begin PA.M/CWK changes
887 PO_Number,
888 PO_Header_Id,
889 PO_Line_Num,
890 PO_Line_Id,
891 PO_Price_Type,
892 Person_Type,
893 -- End PA.M/CWK changes
894 Inventory_Item_Id,
895 WIP_Resource_Id,
896 Unit_Of_Measure,
897 -- 12i MOAC changes
898 Org_Id
899 --Payroll Integration
900 ,JOB_ID
901 ,JOB_NAME
902 ,LOCATION_ID
903 ,LOCATION_CODE
904 ,PAY_ELEMENT_TYPE_ID
905 -- Start: Added for CBS Enhancement Bug 16220146
906 ,Cbs_Element_Id
907 ,Cbs_Element_Name
908 -- End: Added for CBS Enhancement Bug 16220146
909 )
910 VALUES (
911 P_Transaction_Source_Tbl(i) ,
912 P_Batch_Name_Tbl(i) ,
913 P_Expenditure_End_Date_Tbl(i) ,
914 P_Employee_Number_Tbl(i) ,
915 P_Organization_Name_Tbl(i) ,
916 P_Expenditure_Item_Date_Tbl(i) ,
917 P_Project_Number_Tbl(i) ,
918 P_Task_Number_Tbl(i) ,
919 P_Expenditure_Type_Tbl(i) ,
920 P_Non_Labor_Resource_Tbl(i) ,
921 P_Non_Labor_Res_Org_Name_Tbl(i) ,
922 P_Quantity_Tbl(i),
923 P_Raw_Cost_Tbl(i) ,
924 P_Expenditure_Comment_Tbl(i) ,
925 P_Transaction_Status_Code_Tbl(i) ,
926 P_Trans_Rejection_Code_Tbl(i) ,
927 P_Orig_Trans_Reference_Tbl(i) ,
928 P_Attribute_Category_Tbl(i) ,
929 P_Attribute1_Tbl(i) ,
930 P_Attribute2_Tbl(i) ,
931 P_Attribute3_Tbl(i) ,
932 P_Attribute4_Tbl(i) ,
933 P_Attribute5_Tbl(i) ,
934 P_Attribute6_Tbl(i) ,
935 P_Attribute7_Tbl(i) ,
936 P_Attribute8_Tbl(i) ,
937 P_Attribute9_Tbl(i) ,
938 P_Attribute10_Tbl(i) ,
939 P_Raw_Cost_Rate_Tbl(i) ,
940 P_Unmatched_Neg_Txn_Flag_Tbl(i) ,
941 P_Dr_Code_Combination_Id_Tbl(i) ,
942 P_Cr_Code_Combination_Id_Tbl(i) ,
943 P_Cdl_System_Reference1_Tbl(i) ,
944 P_Cdl_System_Reference2_Tbl(i) ,
945 P_Cdl_System_Reference3_Tbl(i) ,
946 P_Gl_Date_Tbl(i) ,
947 P_Burden_Cost_Tbl(i) ,
948 P_Burden_Cost_Rate_Tbl(i) ,
949 P_System_Linkage_Tbl(i) ,
950 P_Txn_Interface_Id_Tbl(i) ,
951 P_User_Transaction_Source_Tbl(i),
952 P_Interface_Id_Tbl(i),
953 P_Receipt_Currency_Amount_Tbl(i),
954 P_Receipt_Currency_Code_Tbl(i),
955 P_Receipt_Exchange_Rate_Tbl(i),
956 P_Denom_Currency_Code_Tbl(i),
957 P_Denom_Raw_Cost_Tbl(i),
958 P_Denom_Burdened_Cost_Tbl(i),
959 P_Acct_Rate_Date_Tbl(i),
960 P_Acct_Rate_Type_Tbl(i),
961 P_Acct_Exchange_Rate_Tbl(i),
962 P_Acct_Raw_Cost_Tbl(i),
963 P_Acct_Burdened_Cost_Tbl(i),
964 P_Acct_Exch_Rounding_Limit_Tbl(i),
965 P_Project_Currency_Code_Tbl(i),
966 P_Project_Rate_Date_Tbl(i),
967 P_Project_Rate_Type_Tbl(i),
968 P_Project_Exchange_Rate_Tbl(i),
969 P_Orig_Exp_Txn_Reference1_Tbl(i),
970 P_Orig_Exp_Txn_Reference2_Tbl(i),
971 P_Orig_Exp_Txn_Reference3_Tbl(i),
972 P_Orig_User_Exp_Txn_Ref_Tbl(i),
973 P_Vendor_Number_Tbl(i),
974 P_Override_To_Org_Name_Tbl(i),
975 P_Reversed_Orig_Txn_Ref_Tbl(i),
976 P_Billable_Flag_Tbl(i),
977 P_Expenditure_Id_Tbl(i),
978 P_Person_Bus_Grp_Name_Tbl(i),
979 P_ProjFunc_Currency_Code_Tbl(i),
980 P_ProjFunc_Cost_Rate_Type_Tbl(i),
981 P_ProjFunc_Cost_Rate_Date_Tbl(i),
982 P_ProjFunc_Cost_Exch_Rate_Tbl(i),
983 P_Project_Raw_Cost_Tbl(i),
984 P_Project_Burdened_Cost_Tbl(i),
985 P_Assignment_Name_Tbl(i),
986 P_Work_Type_Name_Tbl(i),
987 P_Cdl_System_Reference4_Tbl(i),
988 P_Accrual_Flag_Tbl(i),
989 P_Project_Id_Tbl(i),
990 P_Task_Id_Tbl(i),
994 P_Non_Labor_Res_Org_Id_Tbl(i),
991 P_Person_Bus_Grp_Id_Tbl(i),
992 P_Person_Id_Tbl(i),
993 P_Organization_Id_Tbl(i),
995 P_Override_To_Org_Id_Tbl(i),
996 P_Assignment_Id_Tbl(i),
997 P_Work_Type_Id_Tbl(i),
998 P_Vendor_Id_Tbl(i),
999 P_Last_Update_Date_Tbl(i),
1000 P_Last_Updated_By_Tbl(i),
1001 P_Creation_Date_Tbl(i),
1002 P_Created_By_Tbl(i),
1003 -- Begin PA.M/CWK changes
1004 P_PO_Number_Tbl(i),
1005 P_PO_Header_Id_Tbl(i),
1006 P_PO_Line_Num_Tbl(i),
1007 P_PO_Line_Id_Tbl(i),
1008 P_PO_Price_Type_Tbl(i),
1009 P_Person_Type_Tbl(i),
1010 -- End PA.M/CWK changes
1011 P_Inventory_Item_Id_Tbl(i),
1012 P_WIP_Resource_Id_Tbl(i),
1013 P_Unit_Of_Measure_Tbl(i),
1014 -- 12i MOAC changes
1015 P_Org_Id_Tbl(i)
1016 --Payroll Integration
1017 ,P_JOB_ID_TBL(i)
1018 ,P_JOB_NAME_TBL(i)
1019 ,P_LOCATION_ID_TBL(i)
1020 ,P_LOCATION_CODE_TBL(i)
1021 ,P_PAY_ELEMENT_TYPE_ID_TBL(i)
1022 -- Start: Added for CBS Enhancement Bug 16220146
1023 ,P_Cbs_Element_Id_Tbl(i)
1024 ,P_Cbs_Element_Name_Tbl(i)
1025 -- End: Added for CBS Enhancement Bug 16220146
1026 );
1027
1028 Exception
1029 When Others then
1030 Raise;
1031
1032 End Bulk_Insert;
1033
1034
1035 Procedure Bulk_Update (
1036 P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
1037 P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
1038 P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
1039 P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
1040 P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
1041 P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
1042 P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
1043 P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
1044 P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
1045 P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
1046 P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
1047 P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
1048 P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
1049 P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
1050 P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
1051 P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
1055 P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
1052 P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
1053 P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
1054 P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
1056 P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
1057 P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
1058 P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
1059 P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
1060 P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
1061 P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
1062 P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
1063 P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
1064 P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
1065 P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
1066 P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
1067 P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
1068 P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
1069 P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
1070 P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
1071 P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
1072 P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
1073 P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
1074 P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
1075 P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
1076 P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
1077 P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
1078 P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
1079 P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
1080 P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
1081 P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
1082 P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
1083 P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
1084 P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
1085 P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
1086 P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
1087 P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
1088 P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
1089 P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
1090 P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
1091 P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
1092 P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
1093 P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
1094 P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
1095 P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
1096 P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
1097 P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
1098 P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
1102 P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
1099 P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
1100 P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
1101 P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
1103 P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
1104 P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
1105 P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
1106 P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
1107 P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
1108 P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
1109 P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
1110 P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
1111 P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
1112 P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
1113 P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
1114 P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
1115 P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
1116 P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
1117 P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
1118 P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
1119 P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
1120 P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
1121 P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
1122 P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
1123 P_Accrual_flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_flag_Typ,
1124 P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
1125 P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
1126 P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
1127 P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
1128 -- Begin PA.M/CWK changes
1129 P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
1130 P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
1131 P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
1132 P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
1133 P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
1134 P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
1135 -- End PA.M/CWK changes
1136 P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
1137 P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
1138 P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ
1139 --Payroll Integration changes
1140 ,P_JOB_ID_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_ID_TYP
1141 ,P_JOB_NAME_TBL IN Pa_Txn_Interface_Items_Pkg.JOB_NAME_TYP
1142 ,P_LOCATION_ID_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_ID_TYP
1143 ,P_LOCATION_CODE_TBL IN Pa_Txn_Interface_Items_Pkg.LOCATION_CODE_TYP
1144 ,P_PAY_ELEMENT_TYPE_ID_TBL IN Pa_Txn_Interface_Items_Pkg.PAY_ELEMENT_TYPE_ID_TYP
1145 -- Start: Added for CBS Enhancement Bug 16220146
1146 ,P_Cbs_Element_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Id_Typ
1147 ,P_Cbs_Element_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Cbs_Element_Name_Typ
1148 -- End: Added for CBS Enhancement Bug 16220146
1149 )
1150
1151 Is
1152
1153 Begin
1154
1155 ForAll i in P_Txn_Interface_Id_Tbl.First .. P_Txn_Interface_Id_Tbl.Last
1156 Update Pa_Transaction_Interface
1157 Set Transaction_Source = P_Transaction_Source_Tbl(i) ,
1158 Batch_Name = P_Batch_Name_Tbl(i) ,
1159 Expenditure_Ending_Date = P_Expenditure_End_Date_Tbl(i) ,
1160 Employee_Number = P_Employee_Number_Tbl(i) ,
1161 Organization_Name = P_Organization_Name_Tbl(i) ,
1162 Expenditure_Item_Date = P_Expenditure_Item_Date_Tbl(i) ,
1163 Project_Number = P_Project_Number_Tbl(i) ,
1164 Task_Number = P_Task_Number_Tbl(i) ,
1165 Expenditure_Type = P_Expenditure_Type_Tbl(i) ,
1166 Non_Labor_Resource = P_Non_Labor_Resource_Tbl(i) ,
1167 Non_Labor_Resource_Org_Name = P_Non_Labor_Res_Org_Name_Tbl(i) ,
1168 Quantity = P_Quantity_Tbl(i) ,
1169 Raw_Cost = P_Raw_Cost_Tbl(i) ,
1170 Expenditure_Comment = P_Expenditure_Comment_Tbl(i) ,
1171 Transaction_Status_Code = P_Transaction_Status_Code_Tbl(i) ,
1172 Transaction_Rejection_Code = P_Trans_Rejection_Code_Tbl(i) ,
1173 Orig_Transaction_Reference = P_Orig_Trans_Reference_Tbl(i) ,
1174 Attribute_Category = P_Attribute_Category_Tbl(i) ,
1175 Attribute1 = P_Attribute1_Tbl(i) ,
1176 Attribute2 = P_Attribute2_Tbl(i) ,
1177 Attribute3 = P_Attribute3_Tbl(i) ,
1178 Attribute4 = P_Attribute4_Tbl(i) ,
1179 Attribute5 = P_Attribute5_Tbl(i) ,
1180 Attribute6 = P_Attribute6_Tbl(i) ,
1181 Attribute7 = P_Attribute7_Tbl(i) ,
1182 Attribute8 = P_Attribute8_Tbl(i) ,
1183 Attribute9 = P_Attribute9_Tbl(i) ,
1184 Attribute10 = P_Attribute10_Tbl(i) ,
1185 Raw_Cost_Rate = P_Raw_Cost_Rate_Tbl(i) ,
1186 Unmatched_Negative_Txn_Flag = P_Unmatched_Neg_Txn_Flag_Tbl(i) ,
1187 Dr_Code_Combination_Id = P_Dr_Code_Combination_Id_Tbl(i) ,
1188 Cr_Code_Combination_Id = P_Cr_Code_Combination_Id_Tbl(i) ,
1189 Cdl_System_Reference1 = P_Cdl_System_Reference1_Tbl(i) ,
1190 Cdl_System_Reference2 = P_Cdl_System_Reference2_Tbl(i) ,
1191 Cdl_System_Reference3 = P_Cdl_System_Reference3_Tbl(i) ,
1192 Gl_Date = P_Gl_Date_Tbl(i) ,
1193 Burdened_Cost = P_Burden_Cost_Tbl(i) ,
1194 Burdened_Cost_Rate = P_Burden_Cost_Rate_Tbl(i) ,
1195 System_Linkage = P_System_Linkage_Tbl(i) ,
1196 User_Transaction_Source = P_User_Transaction_Source_Tbl(i) ,
1197 Receipt_Currency_Amount = P_Receipt_Currency_Amount_Tbl(i),
1198 Receipt_Currency_Code = P_Receipt_Currency_Code_Tbl(i),
1199 Receipt_Exchange_Rate = P_Receipt_Exchange_Rate_Tbl(i),
1200 Denom_Currency_Code = P_Denom_Currency_Code_Tbl(i),
1201 Denom_Raw_Cost = P_Denom_Raw_Cost_Tbl(i),
1202 Denom_Burdened_Cost = P_Denom_Burdened_Cost_Tbl(i),
1203 Acct_Rate_Date = P_Acct_Rate_Date_Tbl(i),
1204 Acct_Rate_Type = P_Acct_Rate_Type_Tbl(i),
1205 Acct_Exchange_Rate = P_Acct_Exchange_Rate_Tbl(i),
1206 Acct_Raw_Cost = P_Acct_Raw_Cost_Tbl(i),
1207 Acct_Burdened_Cost = P_Acct_Burdened_Cost_Tbl(i),
1208 Acct_Exchange_Rounding_Limit = P_Acct_Exch_Rounding_Limit_Tbl(i),
1209 Project_Currency_Code = P_Project_Currency_Code_Tbl(i),
1210 Project_Rate_Date = P_Project_Rate_Date_Tbl(i),
1211 Project_Rate_Type = P_Project_Rate_Type_Tbl(i),
1212 Project_Exchange_Rate = P_Project_Exchange_Rate_Tbl(i),
1213 Orig_Exp_Txn_Reference1 = P_Orig_Exp_Txn_Reference1_Tbl(i),
1214 Orig_Exp_Txn_Reference2 = P_Orig_Exp_Txn_Reference2_Tbl(i),
1215 Orig_Exp_Txn_Reference3 = P_Orig_Exp_Txn_Reference3_Tbl(i),
1216 Orig_User_Exp_Txn_Reference = P_Orig_User_Exp_Txn_Ref_Tbl(i),
1217 Vendor_Number = P_Vendor_Number_Tbl(i),
1218 Override_To_Organization_Name = P_Override_To_Org_Name_Tbl(i),
1219 Reversed_Orig_Txn_Reference = P_Reversed_Orig_Txn_Ref_Tbl(i),
1220 Billable_Flag = P_Billable_Flag_Tbl(i),
1221 Person_Business_Group_Name = P_Person_Bus_Grp_Name_Tbl(i),
1222 ProjFunc_Currency_Code = P_ProjFunc_Currency_Code_Tbl(i),
1223 ProjFunc_Cost_Rate_Type = P_ProjFunc_Cost_Rate_Type_Tbl(i),
1224 ProjFunc_Cost_Rate_Date = P_ProjFunc_Cost_Rate_Date_Tbl(i),
1225 ProjFunc_Cost_Exchange_Rate = P_ProjFunc_Cost_Exch_Rate_Tbl(i),
1226 Project_Raw_Cost = P_Project_Raw_Cost_Tbl(i),
1227 Project_Burdened_Cost = P_Project_Burdened_Cost_Tbl(i),
1228 Assignment_Name = P_Assignment_Name_Tbl(i),
1229 Work_Type_Name = P_Work_Type_Name_Tbl(i) ,
1230 Cdl_System_Reference4 = P_Cdl_System_Reference4_Tbl(i),
1231 Accrual_Flag = P_Accrual_Flag_Tbl(i),
1232 Project_Id = P_Project_Id_Tbl(i),
1233 Task_Id = P_Task_Id_Tbl(i),
1234 Person_Business_Group_Id = P_Person_Bus_Grp_Id_Tbl(i),
1235 Person_Id = P_Person_Id_Tbl(i),
1236 Organization_Id = P_Organization_Id_Tbl(i),
1237 Assignment_Id = P_Assignment_Id_Tbl(i),
1238 Work_Type_Id = P_Work_Type_Id_Tbl(i),
1239 Vendor_Id = P_Vendor_Id_Tbl(i),
1240 Last_Update_Date = P_Last_Update_Date_Tbl(i),
1241 Last_Updated_By = P_Last_Updated_By_Tbl(i),
1242 -- Begin PA.M/CWK changes
1243 PO_Number = P_PO_Number_Tbl(i),
1244 PO_Header_Id = P_PO_Header_Id_Tbl(i),
1245 PO_Line_Num = P_PO_Line_Num_Tbl(i),
1246 PO_Line_Id = P_PO_Line_Id_Tbl(i),
1247 PO_Price_Type = P_PO_Price_Type_Tbl(i),
1248 Person_Type = P_Person_Type_Tbl(i),
1249 -- End PA.M/CWK changes
1250 Inventory_Item_Id = P_Inventory_Item_Id_Tbl(i),
1251 WIP_Resource_Id = P_WIP_Resource_Id_Tbl(i),
1252 Unit_Of_Measure = P_Unit_Of_Measure_Tbl(i)
1253 --Payroll Integration
1254 ,JOB_ID = P_JOB_ID_TBL(i)
1255 ,JOB_NAME = P_JOB_NAME_TBL(i)
1256 ,LOCATION_ID = P_LOCATION_ID_TBL(i)
1257 ,LOCATION_CODE = P_LOCATION_CODE_TBL(i)
1258 ,PAY_ELEMENT_TYPE_ID = P_PAY_ELEMENT_TYPE_ID_TBL(i)
1259 -- Start: Added for CBS Enhancement Bug 16220146
1260 ,Cbs_Element_id = P_Cbs_Element_Id_Tbl(i)
1261 ,Cbs_Element_Name = P_Cbs_Element_Name_Tbl(i)
1262 -- End: Added for CBS Enhancement Bug 16220146
1263 Where
1264 Txn_Interface_Id = P_Txn_Interface_Id_Tbl(i);
1265
1266 Exception
1267 When Others then
1268 Raise;
1269
1270 End Bulk_Update;
1271
1272 END Pa_Txn_Interface_Items_Pkg ;