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