1 PACKAGE PA_TRANSACTIONS AUTHID CURRENT_USER AS
2 /* $Header: PAXTRANS.pls 120.14.12020000.2 2013/03/31 06:25:24 arbandyo ship $ */
3 /*#
4 * This extension is used to create related transactions.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Related Transactions Extension
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_LABOR_COST
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15 /* Adding new global variable for the bug fix: 3258043
16 * if the transaction import process calls the insItems procedure with
17 * gl_accounted_flag = 'Y' then DONOT overide the gl period and date info
18 */
19 GL_ACCOUNTED_FLAG VARCHAR2(1) := 'N';
20
21 /*----------------------------------------------------------------------------
22 The following two PL/SQL tables are used by the triggers on
23 PA_TRANSACTION_INTERFACE in order to workaround the "mutating table"
24 restriction for triggers. These triggers are part of the Transaction
25 Import utility. For more information on exactly how TI uses these
26 PL/SQL tables and how the workaround functions, refer to the following
27 document:
28 $pa/designs/transaction/trx_import/mutating_table_trigger_workaround.doc
29 ------------------------------------------------------------------------------*/
30 TrxSrcTab pa_utils.Char30TabTyp;
31 BatchNameTab pa_utils.Char10TabTyp;
32
33
34 /*----------------------------------------------------------------------------
35 The following PL/SQL tables are used by several programs including
36 Transaction Import and the Transfer prodedure of the PA Adjustments
37 package. These PL/SQL tables are loaded with VALIDATED expenditure items
38 and then inserted into PA_EXPENDITURE_ITEMS using the
39 pa_transactions.InsItems procedure. This method allows the programs to
40 store validated items one at a time until all items are validated. The
41 items can then either be inserted into PA_EXPENDITURE_ITEMS with one call
42 to pa_transactions.InsItems or can be rolled back using the
43 pa_transactions.FlushEiTabs procedure without having to execute any DDL
44 statements.
45 ------------------------------------------------------------------------------*/
46
47 EiIdTab pa_utils.IdTabTyp;
48 EIdTab pa_utils.IdTabTyp;
49 ProjIdTab pa_utils.IdTabtyp;
50 TskIdTab pa_utils.IdTabTyp;
51 EiDateTab pa_utils.DateTabTyp;
52 ETypTab pa_utils.Char30TabTyp;
53 NlRscTab pa_utils.Char20TabTyp;
54 NlRscOrgTab pa_utils.IdTabTyp;
55 BillFlagTab pa_utils.Char1TabTyp;
56 BillHoldTab pa_utils.Char1TabTyp;
57 QtyTab pa_utils.AmtTabTyp;
58 RawCostTab pa_utils.AmtTabTyp;
59 RawRateTab pa_utils.AmtTabTyp;
60 OvrOrgTab pa_utils.IdTabTyp;
61 AdjEiTab pa_utils.IdTabTyp;
62 TrxRefTab pa_utils.Char50TabTyp; -- Bug 12371923 changed the type from Char30TabTyp to Char50TabTyp
63 EiTrxSrcTab pa_utils.Char30TabTyp;
64 AttCatTab pa_utils.Char30TabTyp;
65 Att1Tab pa_utils.Char150TabTyp;
66 Att2Tab pa_utils.Char150TabTyp;
67 Att3Tab pa_utils.Char150TabTyp;
68 Att4Tab pa_utils.Char150TabTyp;
69 Att5Tab pa_utils.Char150TabTyp;
70 Att6Tab pa_utils.Char150TabTyp;
71 Att7Tab pa_utils.Char150TabTyp;
72 Att8Tab pa_utils.Char150TabTyp;
73 Att9Tab pa_utils.Char150TabTyp;
74 Att10Tab pa_utils.Char150TabTyp;
75 SrcEiTab pa_utils.IdTabTyp;
76 EiCommentTab pa_utils.Char240TabTyp;
77 TfrEiTab pa_utils.IdTabTyp;
78 JobIdTab pa_utils.IdTabTyp;
79 OrgIdTab pa_utils.IdTabTyp;
80 LCMTab pa_utils.Char20TabTyp ;
81 DrccidIdTab pa_utils.IdTabTyp ;
82 CrccidIdTab pa_utils.IdTabTyp ;
83 Cdlsr1Tab pa_utils.Char30TabTyp ;
84 Cdlsr2Tab pa_utils.Char30TabTyp ;
85 Cdlsr3Tab pa_utils.Char30TabTyp ;
86 GldateTab pa_utils.DateTabTyp ;
87 BCostTab pa_utils.AmtTabTyp;
88 BCostRateTab pa_utils.AmtTabTyp;
89 EtypeClassTab pa_utils.Char30TabTyp ;
90 BurdenDestId pa_utils.IdTabTyp;
91 BurdenCompSetId pa_utils.IdTabTyp;
92 ReceiptCurrAmt pa_utils.NewAmtTabTyp;
93 ReceiptCurrCode pa_utils.Char15TabTyp;
94 ReceiptExRate pa_utils.NewAmtTabTyp;
95 DenomCurrCode pa_utils.Char15TabTyp;
96 DenomRawCost pa_utils.NewAmtTabTyp;
97 DenomBurdenCost pa_utils.NewAmtTabTyp;
98 AcctCurrCode pa_utils.Char15TabTyp;
99 AcctRateDate pa_utils.DateTabTyp;
100 AcctRateType pa_utils.Char30TabTyp;
101 AcctExRate pa_utils.NewAmtTabTyp;
102 AcctRawCost pa_utils.NewAmtTabTyp;
103 AcctBurdenCost pa_utils.NewAmtTabTyp;
104 AcctRoundLmt pa_utils.NewAmtTabTyp;
105 ProjCurrCode pa_utils.Char15TabTyp;
106 ProjRateType pa_utils.Char30TabTyp;
107 ProjRateDate pa_utils.DateTabTyp;
108 ProjExRate pa_utils.NewAmtTabTyp;
109
110 -- IC Changes
111 CrossChargeTypeTab pa_utils.Char10TabTyp;
112 CrossChargeCodeTab pa_utils.Char1TAbTyp;
113 PrvdrOrganizationTab pa_utils.IdTabTyp;
114 RecvOrganizationTab pa_utils.IdTabTyp;
115 RecvOperUnitTab pa_utils.IdTabTyp;
116 IcProcessedCodeTab pa_utils.Char1TAbTyp;
117 BorrowLentCodeTab pa_utils.Char1TabTyp;
118 DenomTpCurrCodeTab pa_utils.Char15TabTyp;
119 DenomTransferPriceTab pa_utils.NewAmtTabTyp;
120 AcctTpRateTypeTab pa_utils.Char30TabTyp;
121 AcctTpRateDateTab pa_utils.DateTabTyp;
122 AcctTpExchangeRateTab pa_utils.NewAmtTabTyp;
123 AcctTransferPriceTab pa_utils.NewAmtTabTyp;
124 ProjacctTransferPriceTab pa_utils.NewAmtTabTyp;
125 CcMarkupBaseCodeTab pa_utils.Char1TAbTyp;
126 TpBaseAmountTab pa_utils.NewAmtTabTyp;
127 TpIndCompiledSetIdTab pa_utils.IdTabTyp;
128 TpBillRateTab pa_utils.NewAmtTabTyp;
129 TpBillMarkupPercentageTab pa_utils.AmtTabTyp;
130 TpSchLinePercentageTab pa_utils.AmtTabTyp;
131 TpRulePercentageTab pa_utils.AmtTabTyp;
132 -- END IC Changes
133
134 -- Begin CBGA changes for new jobs model in 11i
135 CostJobIdTab pa_utils.IdTabTyp;
136 ProvProjBillJobIdTab pa_utils.IdTabTyp;
137 TPJobIdTab pa_utils.IdTabTyp;
138 -- End CBGA changes for new jobs model in 11i
139
140 -- Begin EPP changes
141 PaDateTab pa_utils.DateTabTyp ;
142 PaPeriodNameTab pa_utils.Char15TabTyp;
143 RecvrPaDateTab pa_utils.DateTabTyp ;
144 RecvrPaPeriodNameTab pa_utils.Char15TabTyp;
145 GlPeriodNameTab pa_utils.Char15TabTyp;
146 RecvrGlDateTab pa_utils.DateTabTyp ;
147 RecvrGlPeriodNameTab pa_utils.Char15TabTyp;
148 -- End EPP changes
149
150 -- start of project currency and EI attributes
151 AssgnIDTab pa_utils.IdTabTyp;
152 WorkTypeTab pa_utils.IdTabTyp;
153 ProjFuncCurrencyTab pa_utils.Char15TabTyp;
154 ProjFuncCostRateDateTab pa_utils.DateTabTyp ;
155 ProjFunccostRateTypeTab pa_utils.Char30TabTyp;
156 ProjfuncCostExgRateTab pa_utils.NewAmtTabTyp;
157 ProjRawCostTab pa_utils.NewAmtTabTyp;
158 ProjBurdendCostTab pa_utils.NewAmtTabTyp;
159 TpAmtTypeCode pa_utils.Char30TabTyp;
160 -- End of project currency and EI attributes
161
162 -- Begin PA-J Period End Accrual Changes
163 AccrualDateTab pa_utils.DateTabTyp ;
164 RecvrAccrualDateTab pa_utils.DateTabTyp ;
165 -- End PA-J Period End Accrual Changes
166
167 -- AP Discounts
168 Cdlsr4Tab pa_utils.Char30TabTyp ;
169
170 --begin PA.M contingent worker and PJM attribute chnages
171 Wip_Resource_IdTab pa_utils.IdTabTyp;
172 Inventory_Item_IdTab pa_utils.IdTabTyp;
173 Unit_Of_MeasureTab pa_utils.Char30TabTyp;
174 Po_Line_IdTab pa_utils.IdTabTyp;
175 Po_Price_TypeTab pa_utils.Char30TabTyp;
176 Adjustment_TypeTab pa_utils.Char150TabTyp;
177 --end PA.M contingent worker and PJM attribute chnages
178
179 SrcEtypeClassTab pa_utils.Char30TabTyp; -- 4057874
180
181 -- REL12 AP lines changes
182 DocumentHeaderIdTab pa_utils.IdTabTyp;
183 DocumentDistributionIdTab pa_utils.IdTabTyp ;
184 DocumentLineNumberTab pa_utils.IdTabTyp ;
185 DocumentPaymentIdTab pa_utils.IdTabTyp ;
186 VendorIdTab pa_utils.NewAmtTabTyp ; -- Bug 12591580 Changed from IdTabTyp to NewAmtTabTyp
187 DocumentTypeTab pa_utils.Char30TabTyp ;
188 DocumentDistributionTypeTab pa_utils.Char30TabTyp ;
189 SiAssetsAddFlagTab pa_utils.char1TabTyp;
190 scxfercodetab pa_utils.Char1TabTyp ;
191 Cdlsr5Tab pa_utils.IdTabTyp ;
192 Agreement_idTab pa_utils.IdTabTyp; --FSIO Changes
193 --
194 -- 10253400: Payroll integration enhancement for 12.2.. start
195 Location_IdTab pa_utils.IdTabTyp;
196 Pay_Element_IdTab pa_utils.IdTabTyp;
197 Rate_Source_CodeTab pa_utils.Char30TabTyp ;
198 Costing_Method_Tab pa_utils.Char150TabTyp;
199 -- 10253400: Payroll integration enhancement for 12.2.. end
200
201 /* Start changes for Bug#12606242 */
202
203 Payroll_Accrual_Flag pa_utils.char1TabTyp;
204 Rbc_Element_Type_Id pa_utils.IdTabTyp;
205 Interface_Run_Id pa_utils.IdTabTyp;
206
207 /* End changes for Bug#12606242 */
208
209 cbs_element_idtab PA_PLSQL_DATATYPES.Num15TabTyp; -- Added for CBS Enhancement Bug 16220146
210
211 -- ========================================================================
212 -- PROCEDURE LoadEi
213 -- ========================================================================
214
215 PROCEDURE LoadEi( X_expenditure_item_id IN NUMBER
216 , X_expenditure_id IN NUMBER
217 , X_expenditure_item_date IN DATE
218 , X_project_id IN NUMBER
219 , X_task_id IN NUMBER
220 , X_expenditure_type IN VARCHAR2
221 , X_non_labor_resource IN VARCHAR2
222 , X_nl_resource_org_id IN NUMBER
223 , X_quantity IN NUMBER
224 , X_raw_cost IN NUMBER
225 , X_raw_cost_rate IN NUMBER
226 , X_override_to_org_id IN NUMBER
227 , X_billable_flag IN VARCHAR2
228 , X_bill_hold_flag IN VARCHAR2
229 , X_orig_transaction_ref IN VARCHAR2
230 , X_transferred_from_ei IN NUMBER
231 , X_adj_expend_item_id IN NUMBER
232 , X_attribute_category IN VARCHAR2
233 , X_attribute1 IN VARCHAR2
234 , X_attribute2 IN VARCHAR2
235 , X_attribute3 IN VARCHAR2
236 , X_attribute4 IN VARCHAR2
237 , X_attribute5 IN VARCHAR2
238 , X_attribute6 IN VARCHAR2
239 , X_attribute7 IN VARCHAR2
240 , X_attribute8 IN VARCHAR2
241 , X_attribute9 IN VARCHAR2
242 , X_attribute10 IN VARCHAR2
243 , X_ei_comment IN VARCHAR2
244 , X_transaction_source IN VARCHAR2
245 , X_source_exp_item_id IN NUMBER
246 , i IN BINARY_INTEGER
247 , X_job_id IN NUMBER default null
248 , X_org_id IN NUMBER default null
249 , X_labor_cost_multiplier_name IN VARCHAR2
250 , X_drccid IN NUMBER
251 , X_crccid IN NUMBER
252 , X_cdlsr1 IN VARCHAR2
253 , X_cdlsr2 IN VARCHAR2
254 , X_cdlsr3 IN VARCHAR2
255 , X_gldate IN DATE
256 , X_bcost IN NUMBER
257 , X_bcostrate IN NUMBER
258 , X_etypeclass IN VARCHAR2
259 , X_burden_sum_dest_run_id IN NUMBER default null
260 , X_burden_compile_set_id IN NUMBER default null
261 , X_receipt_currency_amount IN NUMBER default null
262 , X_receipt_currency_code IN VARCHAR2 default NULL
263 , X_receipt_exchange_rate IN NUMBER default NULL
264 , X_denom_currency_code IN VARCHAR2 default NULL
265 , X_denom_raw_cost IN NUMBER default NULL
266 , X_denom_burdened_cost IN NUMBER default NULL
267 , X_acct_currency_code IN VARCHAR2 default NULL
268 , X_acct_rate_date IN DATE default NULL
269 , X_acct_rate_type IN VARCHAR2 default NULL
270 , X_acct_exchange_rate IN NUMBER default NULL
271 , X_acct_raw_cost IN NUMBER default NULL
272 , X_acct_burdened_cost IN NUMBER default NULL
273 , X_acct_exchange_rounding_limit IN NUMBER default NULL
274 , X_project_currency_code IN VARCHAR2 default NULL
275 , X_project_rate_date IN DATE default NULL
276 , X_project_rate_type IN VARCHAR2 default NULL
277 , X_project_exchange_rate IN NUMBER default NULL
278 , X_Cross_Charge_Type IN Varchar2 default 'NO'
279 , X_Cross_Charge_Code IN Varchar2 default 'P'
280 , X_Prvdr_organization_id IN Number default NULL
281 , X_Recv_organization_id IN Number default NULL
282 , X_Recv_Operating_Unit IN Number default NULL
283 , X_Borrow_Lent_Dist_Code IN Varchar2 default 'X'
284 , X_Ic_Processed_Code IN Varchar2 default 'X'
285 , X_Denom_Tp_Currency_Code IN Varchar2 default NULL
286 , X_Denom_Transfer_Price IN Number default NULL
287 , X_Acct_Tp_Rate_Type IN Varchar2 default NULL
288 , X_Acct_Tp_Rate_Date IN DATE default NULL
289 , X_Acct_Tp_Exchange_Rate IN Number default NULL
290 , X_ACCT_TRANSFER_PRICE IN Number default NULL
291 , X_PROJACCT_TRANSFER_PRICE IN Number default NULL
292 , X_CC_MARKUP_BASE_CODE IN Varchar2 default NULL
293 , X_TP_BASE_AMOUNT IN Number default NULL
294 , X_Tp_Ind_Compiled_Set_Id IN Number default NULL
295 , X_Tp_Bill_Rate IN Number default NULL
296 , X_Tp_Bill_Markup_Percentage IN Number default NULL
297 , X_Tp_Schedule_Line_Percentage IN Number default NULL
298 , X_Tp_Rule_Percentage IN Number default NULL
299 , X_Cost_Job_Id IN NUMBER default null
300 , X_Prov_Proj_Bill_Job_Id IN NUMBER default null
301 , X_TP_Job_Id IN NUMBER default null
302 , P_PaDate IN DATE default null
303 , P_PaPeriodName IN Varchar2 default null
304 , P_RecvrPaDate IN DATE default null
305 , P_RecvrPaPeriodName IN Varchar2 default null
306 , P_GlPeriodName IN Varchar2 default null
307 , P_RecvrGlDate IN DATE default null
308 , P_RecvrGlPeriodName IN Varchar2 default null
309 , p_assignment_id IN NUMBER default null
310 , p_work_type_id IN NUMBER default null
311 , p_projfunc_currency_code IN varchar2 default null
312 , p_projfunc_cost_rate_date IN date default null
313 , p_projfunc_cost_rate_type IN varchar2 default null
314 , p_projfunc_cost_exchange_rate IN number default null
315 , p_project_raw_cost IN number default null
316 , p_project_burdened_cost IN number default null
317 , p_tp_amt_type_code IN varchar2 default null
318 , p_cdlsr4 IN varchar2 default null
319 , p_accrual_Date IN DATE default null
320 , p_recvr_accrual_date IN DATE default null
321 , p_Wip_Resource_Id IN number default null /* cwk */
322 , p_Inventory_Item_Id IN number default null
323 , p_Unit_Of_Measure IN varchar2 default null
324 , p_Po_Line_Id IN number default null
325 , p_Po_Price_Type IN varchar2 default null
326 , p_adjustment_type IN varchar2 default null
327 , p_src_system_linkage_function IN varchar2 default null /* 4057874 */
328 /* REL12-AP Lines uptake */
329 , p_document_header_id IN number default NULL
330 , p_document_distribution_id IN number default NULL
331 , p_document_line_number IN number default NULL
332 , p_document_payment_id IN number default NULL
333 , p_vendor_id IN number default NULL
334 , p_document_type IN varchar2 default NULL
335 , p_document_distribution_type IN varchar2 default NULL
336 , p_si_assets_addition_flag IN varchar2 default NULL
337 , p_sc_xfer_code IN varchar2 default NULL
338 , p_cdlsr5 IN number default null
339 -- , p_agreement_id IN NUMBER DEFAULT NULL --FSIO Changes
340 -- 10253400: Payroll integration enhancement for 12.2..start
341 , p_location_id IN NUMBER DEFAULT NULL
342 , p_pay_element_type_id IN NUMBER DEFAULT NULL
343 , p_rate_source_code IN VARCHAR2 DEFAULT NULL
344 , p_costing_method IN VARCHAR2 DEFAULT NULL
345 -- 10253400: Payroll integration enhancement for 12.2.. end
346 , p_cbs_element_id IN NUMBER DEFAULT NULL -- Added for CBS Enhancement Bug 16220146
347 );
348
349
350 -- ========================================================================
351 -- PROCEDURE FlushEiTabs
352 -- ========================================================================
353
354 PROCEDURE FlushEiTabs;
355
356
357 -- ========================================================================
358 -- PROCEDURE InsItemComment
359 -- ========================================================================
360
361 PROCEDURE InsItemComment( X_ei_id IN NUMBER
362 , X_ei_comment IN VARCHAR2
363 , X_user IN NUMBER
364 , X_login IN NUMBER
365 , X_status OUT NOCOPY NUMBER );
366
367
368 -- ========================================================================
369 -- PROCEDURE InsItems
370 -- ========================================================================
371
372 PROCEDURE InsItems( X_user IN NUMBER
373 , X_login IN NUMBER
374 , X_module IN VARCHAR2
375 , X_calling_process IN VARCHAR2
376 , Rows IN BINARY_INTEGER
377 , X_status OUT NOCOPY NUMBER
378 , X_gl_flag IN VARCHAR2 );
379
380
381 -- ========================================================================
382 -- PROCEDURE InsertExp
383 -- ========================================================================
384 -- Added new multi-Currency parameters to PA_EXPENDITURES
385 --
386
387 PROCEDURE InsertExp( X_expenditure_id IN NUMBER
388 , X_expend_status IN VARCHAR2
389 , X_expend_ending IN DATE
390 , X_expend_class IN VARCHAR2
391 , X_inc_by_person IN NUMBER
392 , X_inc_by_org IN NUMBER
393 , X_expend_group IN VARCHAR2
394 , X_entered_by_id IN NUMBER
395 , X_created_by_id IN NUMBER
396 , X_attribute_category IN VARCHAR2 DEFAULT NULL
397 , X_attribute1 IN VARCHAR2 DEFAULT NULL
398 , X_attribute2 IN VARCHAR2 DEFAULT NULL
399 , X_attribute3 IN VARCHAR2 DEFAULT NULL
400 , X_attribute4 IN VARCHAR2 DEFAULT NULL
401 , X_attribute5 IN VARCHAR2 DEFAULT NULL
402 , X_attribute6 IN VARCHAR2 DEFAULT NULL
403 , X_attribute7 IN VARCHAR2 DEFAULT NULL
404 , X_attribute8 IN VARCHAR2 DEFAULT NULL
405 , X_attribute9 IN VARCHAR2 DEFAULT NULL
406 , X_attribute10 IN VARCHAR2 DEFAULT NULL
407 , X_description IN VARCHAR2 DEFAULT NULL
408 , X_control_total IN NUMBER DEFAULT NULL
409 , X_denom_currency_code IN VARCHAR2 DEFAULT NULL
410 , X_acct_currency_code IN VARCHAR2 DEFAULT NULL
411 , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
412 , X_acct_rate_date IN DATE DEFAULT NULL
413 , X_acct_exchange_rate IN NUMBER DEFAULT NULL
414 -- Trx_import enhancement:
415 -- New parameters used to populate PA_EXPENDITURES_ALL
416 -- table's new columns
417 , X_orig_exp_txn_reference1 IN VARCHAR2 DEFAULT NULL
418 , X_orig_user_exp_txn_reference IN VARCHAR2 DEFAULT NULL
419 , X_vendor_id IN NUMBER DEFAULT NULL
420 , X_orig_exp_txn_reference2 IN VARCHAR2 DEFAULT NULL
421 , X_orig_exp_txn_reference3 IN VARCHAR2 DEFAULT NULL
422 , X_person_type IN VARCHAR2 DEFAULT NULL /* cwk */
423 , P_Org_Id IN NUMBER Default NULL -- 12i MOAC changes
424 );
425
426 -- ========================================================================
427 -- PROCEDURE InsertExpGroup
428 -- ========================================================================
429
430 PROCEDURE InsertExpGroup(
431 X_expenditure_group IN VARCHAR2
432 , X_exp_group_status_code IN VARCHAR2
433 , X_ending_date IN DATE
434 , X_system_linkage IN VARCHAR2
435 , X_created_by IN NUMBER
436 , X_transaction_source IN VARCHAR2
437 , P_Accrual_Flag IN VARCHAR2 default null
438 , P_Org_Id IN NUMBER default Null); -- 12i MOAC changes
439
440
441 -- ========================================================================
442 -- PROCEDURE CreateRelatedItem
443 -- ========================================================================
444 -- Changed the parameter name from raw_cost to denom_raw_cost and
445 -- raw_cost_rate to denom_cost_rate
446 --
447 /*#
448 * Use this procedure to create related transactions within the logic of the Add Transactions procedure.
449 * @param X_source_exp_item_id The identifier of the source transaction
450 * @rep:paraminfo {@rep:required}
451 * @param X_project_id The identifier of the project to charge the related transaction to
452 * @param X_task_id The identifier of the task
453 * @param X_expenditure_type The expenditure type of the related transaction
454 * @rep:paraminfo {@rep:required}
455 * @param X_denom_raw_cost The raw cost amount of the related transaction in transaction currency
456 * @rep:paraminfo {@rep:required}
457 * @param X_denom_raw_cost_rate The raw cost rate of the related transaction
458 * @rep:paraminfo {@rep:required}
459 * @param X_override_to_org_id The identifier of the organization that overrides the expenditure organization used by the source transaction
460 * @rep:paraminfo {@rep:required}
461 * @param X_userid The identifier of the user that entered the source transaction
462 * @rep:paraminfo {@rep:required}
463 * @param X_attribute_category Descriptive flexfield category
464 * @rep:paraminfo {@rep:required}
465 * @param X_attribute1 Descriptive flexfield segment
466 * @rep:paraminfo {@rep:required}
467 * @param X_attribute2 Descriptive flexfield segment
468 * @rep:paraminfo {@rep:required}
469 * @param X_attribute3 Descriptive flexfield segment
470 * @rep:paraminfo {@rep:required}
471 * @param X_attribute4 Descriptive flexfield segment
472 * @rep:paraminfo {@rep:required}
473 * @param X_attribute5 Descriptive flexfield segment
474 * @rep:paraminfo {@rep:required}
475 * @param X_attribute6 Descriptive flexfield segment
476 * @rep:paraminfo {@rep:required}
477 * @param X_attribute7 Descriptive flexfield segment
478 * @rep:paraminfo {@rep:required}
479 * @param X_attribute8 Descriptive flexfield segment
480 * @rep:paraminfo {@rep:required}
481 * @param X_attribute9 Descriptive flexfield segment
482 * @rep:paraminfo {@rep:required}
483 * @param X_attribute10 Descriptive flexfield segment
484 * @rep:paraminfo {@rep:required}
485 * @param X_comment Expenditure item comment
486 * @rep:paraminfo {@rep:required}
487 * @param X_status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
488 * @rep:paraminfo {@rep:required}
489 * @param X_outcome Outcome of the procedure
490 * @rep:paraminfo {@rep:required}
491 * @param X_work_type_name Name of the work type assigned to the transaction
492 * @rep:scope public
493 * @rep:lifecycle active
494 * @rep:displayname Create Related Transactions
495 * @rep:compatibility S
496 */
497 PROCEDURE CreateRelatedItem(
498 X_source_exp_item_id IN NUMBER
499 , X_project_id IN NUMBER DEFAULT NULL
500 , X_task_id IN NUMBER DEFAULT NULL
501 , X_Award_id IN NUMBER DEFAULT NULL
502 , X_expenditure_type IN VARCHAR2
503 , X_denom_raw_cost IN NUMBER
504 , X_denom_raw_cost_rate IN NUMBER
505 , X_override_to_org_id IN NUMBER
506 , X_userid IN NUMBER
507 , X_attribute_category IN VARCHAR2
508 , X_attribute1 IN VARCHAR2
509 , X_attribute2 IN VARCHAR2
510 , X_attribute3 IN VARCHAR2
511 , X_attribute4 IN VARCHAR2
512 , X_attribute5 IN VARCHAR2
513 , X_attribute6 IN VARCHAR2
514 , X_attribute7 IN VARCHAR2
515 , X_attribute8 IN VARCHAR2
516 , X_attribute9 IN VARCHAR2
517 , X_attribute10 IN VARCHAR2
518 , X_comment IN VARCHAR2
519 , X_status OUT NOCOPY NUMBER
520 , X_outcome OUT NOCOPY VARCHAR2
521 , X_work_type_name IN VARCHAR2 DEFAULT NULL/*bug2482593*/
522 );
523
524
525 -- ========================================================================
526 -- PROCEDURE UpdateRelatedItem
527 -- ========================================================================
528 -- Changed the parameter name from raw_cost to denom_raw_cost and
529 -- raw_cost_rate to denom_cost_rate
530 --
531 --
532 /*#
533 * Use this procedure to update the raw cost amount of existing related transactions within the logic of your labor
534 * transaction extension when related transactions are marked for cost recalculation.
535 * @param X_expenditure_item_id The identifier of the related expenditure item
536 * @rep:paraminfo {@rep:required}
537 * @param X_denom_raw_cost The new raw cost of the related transaction in the transaction currency
538 * @rep:paraminfo {@rep:required}
539 * @param X_denom_raw_cost_rate The new raw cost rate of the related transaction in the transaction currency
540 * @rep:paraminfo {@rep:required}
541 * @param X_status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
542 * @rep:paraminfo {@rep:required}
543 * @param X_work_type_name Name of the work type assigned to the transaction
544 * @rep:scope public
545 * @rep:lifecycle active
546 * @rep:displayname Update Related Transactions
547 * @rep:compatibility S
548 */
549 PROCEDURE UpdateRelatedItem( X_expenditure_item_id IN NUMBER
550 , X_denom_raw_cost IN NUMBER
551 , X_denom_raw_cost_rate IN NUMBER
552 , X_status OUT NOCOPY NUMBER
553 , X_work_type_name IN VARCHAR2 DEFAULT NULL/*bug2482593*/
554 );
555
556
557 -- Added as a fix for the bug # 1358018
558 -- ========================================================================
559 -- PROCEDURE UpdateSystemLinkFunc
560 -- ========================================================================
561
562 PROCEDURE UpdateSystemLinkFunc( X_expend_item_id IN NUMBER
563 , X_sys_link_func IN VARCHAR2);
564
565 -- ========================================================================
566 -- PA-K Changes: Added this procedure
567 -- PROCEDURE InsertExpGroupNew
568 -- ========================================================================
569
570 PROCEDURE InsertExpGroupNew(
571 X_expenditure_group IN VARCHAR2
572 , X_exp_group_status_code IN VARCHAR2
573 , X_ending_date IN DATE
574 , X_system_linkage IN VARCHAR2
575 , X_created_by IN NUMBER
576 , X_transaction_source IN VARCHAR2
577 , P_Accrual_Flag IN VARCHAR2 default null
578 , P_Org_Id IN NUMBER default null); -- 12i MOAC changes
579
580 END PA_TRANSACTIONS;
[Home] [Help]