1 PACKAGE PA_TRANSACTIONS AS
2 /* $Header: PAXTRANS.pls 120.5.12000000.2 2007/04/10 12:05:05 srachako 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.Char30TabTyp;
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.IdTabTyp ;
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
193 -- ========================================================================
194 -- PROCEDURE LoadEi
195 -- ========================================================================
196
197 PROCEDURE LoadEi( X_expenditure_item_id IN NUMBER
198 , X_expenditure_id IN NUMBER
199 , X_expenditure_item_date IN DATE
200 , X_project_id IN NUMBER
201 , X_task_id IN NUMBER
202 , X_expenditure_type IN VARCHAR2
203 , X_non_labor_resource IN VARCHAR2
204 , X_nl_resource_org_id IN NUMBER
205 , X_quantity IN NUMBER
206 , X_raw_cost IN NUMBER
207 , X_raw_cost_rate IN NUMBER
208 , X_override_to_org_id IN NUMBER
209 , X_billable_flag IN VARCHAR2
210 , X_bill_hold_flag IN VARCHAR2
211 , X_orig_transaction_ref IN VARCHAR2
212 , X_transferred_from_ei IN NUMBER
213 , X_adj_expend_item_id IN NUMBER
214 , X_attribute_category IN VARCHAR2
215 , X_attribute1 IN VARCHAR2
216 , X_attribute2 IN VARCHAR2
217 , X_attribute3 IN VARCHAR2
218 , X_attribute4 IN VARCHAR2
219 , X_attribute5 IN VARCHAR2
220 , X_attribute6 IN VARCHAR2
221 , X_attribute7 IN VARCHAR2
222 , X_attribute8 IN VARCHAR2
223 , X_attribute9 IN VARCHAR2
224 , X_attribute10 IN VARCHAR2
225 , X_ei_comment IN VARCHAR2
226 , X_transaction_source IN VARCHAR2
227 , X_source_exp_item_id IN NUMBER
228 , i IN BINARY_INTEGER
229 , X_job_id IN NUMBER default null
230 , X_org_id IN NUMBER default null
231 , X_labor_cost_multiplier_name IN VARCHAR2
232 , X_drccid IN NUMBER
233 , X_crccid IN NUMBER
234 , X_cdlsr1 IN VARCHAR2
235 , X_cdlsr2 IN VARCHAR2
236 , X_cdlsr3 IN VARCHAR2
237 , X_gldate IN DATE
238 , X_bcost IN NUMBER
239 , X_bcostrate IN NUMBER
240 , X_etypeclass IN VARCHAR2
241 , X_burden_sum_dest_run_id IN NUMBER default null
242 , X_burden_compile_set_id IN NUMBER default null
243 , X_receipt_currency_amount IN NUMBER default null
244 , X_receipt_currency_code IN VARCHAR2 default NULL
245 , X_receipt_exchange_rate IN NUMBER default NULL
246 , X_denom_currency_code IN VARCHAR2 default NULL
247 , X_denom_raw_cost IN NUMBER default NULL
248 , X_denom_burdened_cost IN NUMBER default NULL
249 , X_acct_currency_code IN VARCHAR2 default NULL
250 , X_acct_rate_date IN DATE default NULL
251 , X_acct_rate_type IN VARCHAR2 default NULL
252 , X_acct_exchange_rate IN NUMBER default NULL
253 , X_acct_raw_cost IN NUMBER default NULL
254 , X_acct_burdened_cost IN NUMBER default NULL
255 , X_acct_exchange_rounding_limit IN NUMBER default NULL
256 , X_project_currency_code IN VARCHAR2 default NULL
257 , X_project_rate_date IN DATE default NULL
258 , X_project_rate_type IN VARCHAR2 default NULL
259 , X_project_exchange_rate IN NUMBER default NULL
260 , X_Cross_Charge_Type IN Varchar2 default 'NO'
261 , X_Cross_Charge_Code IN Varchar2 default 'P'
262 , X_Prvdr_organization_id IN Number default NULL
263 , X_Recv_organization_id IN Number default NULL
264 , X_Recv_Operating_Unit IN Number default NULL
265 , X_Borrow_Lent_Dist_Code IN Varchar2 default 'X'
266 , X_Ic_Processed_Code IN Varchar2 default 'X'
267 , X_Denom_Tp_Currency_Code IN Varchar2 default NULL
268 , X_Denom_Transfer_Price IN Number default NULL
269 , X_Acct_Tp_Rate_Type IN Varchar2 default NULL
270 , X_Acct_Tp_Rate_Date IN DATE default NULL
271 , X_Acct_Tp_Exchange_Rate IN Number default NULL
272 , X_ACCT_TRANSFER_PRICE IN Number default NULL
273 , X_PROJACCT_TRANSFER_PRICE IN Number default NULL
274 , X_CC_MARKUP_BASE_CODE IN Varchar2 default NULL
275 , X_TP_BASE_AMOUNT IN Number default NULL
276 , X_Tp_Ind_Compiled_Set_Id IN Number default NULL
277 , X_Tp_Bill_Rate IN Number default NULL
278 , X_Tp_Bill_Markup_Percentage IN Number default NULL
279 , X_Tp_Schedule_Line_Percentage IN Number default NULL
280 , X_Tp_Rule_Percentage IN Number default NULL
284 , P_PaDate IN DATE default null
281 , X_Cost_Job_Id IN NUMBER default null
282 , X_Prov_Proj_Bill_Job_Id IN NUMBER default null
283 , X_TP_Job_Id IN NUMBER default null
285 , P_PaPeriodName IN Varchar2 default null
286 , P_RecvrPaDate IN DATE default null
287 , P_RecvrPaPeriodName IN Varchar2 default null
288 , P_GlPeriodName IN Varchar2 default null
289 , P_RecvrGlDate IN DATE default null
290 , P_RecvrGlPeriodName IN Varchar2 default null
291 , p_assignment_id IN NUMBER default null
292 , p_work_type_id IN NUMBER default null
293 , p_projfunc_currency_code IN varchar2 default null
294 , p_projfunc_cost_rate_date IN date default null
295 , p_projfunc_cost_rate_type IN varchar2 default null
296 , p_projfunc_cost_exchange_rate IN number default null
297 , p_project_raw_cost IN number default null
298 , p_project_burdened_cost IN number default null
299 , p_tp_amt_type_code IN varchar2 default null
300 , p_cdlsr4 IN varchar2 default null
301 , p_accrual_Date IN DATE default null
302 , p_recvr_accrual_date IN DATE default null
303 , p_Wip_Resource_Id IN number default null /* cwk */
304 , p_Inventory_Item_Id IN number default null
305 , p_Unit_Of_Measure IN varchar2 default null
306 , p_Po_Line_Id IN number default null
307 , p_Po_Price_Type IN varchar2 default null
308 , p_adjustment_type IN varchar2 default null
309 , p_src_system_linkage_function IN varchar2 default null /* 4057874 */
310 /* REL12-AP Lines uptake */
311 , p_document_header_id IN number default NULL
312 , p_document_distribution_id IN number default NULL
313 , p_document_line_number IN number default NULL
314 , p_document_payment_id IN number default NULL
315 , p_vendor_id IN number default NULL
316 , p_document_type IN varchar2 default NULL
317 , p_document_distribution_type IN varchar2 default NULL
318 , p_si_assets_addition_flag IN varchar2 default NULL
319 , p_sc_xfer_code IN varchar2 default NULL
320 , p_cdlsr5 IN number default null
321 );
322
323
324 -- ========================================================================
325 -- PROCEDURE FlushEiTabs
326 -- ========================================================================
327
328 PROCEDURE FlushEiTabs;
329
330
331 -- ========================================================================
332 -- PROCEDURE InsItemComment
333 -- ========================================================================
334
335 PROCEDURE InsItemComment( X_ei_id IN NUMBER
336 , X_ei_comment IN VARCHAR2
337 , X_user IN NUMBER
338 , X_login IN NUMBER
339 , X_status OUT NOCOPY NUMBER );
340
341
342 -- ========================================================================
343 -- PROCEDURE InsItems
344 -- ========================================================================
345
346 PROCEDURE InsItems( X_user IN NUMBER
347 , X_login IN NUMBER
348 , X_module IN VARCHAR2
349 , X_calling_process IN VARCHAR2
350 , Rows IN BINARY_INTEGER
351 , X_status OUT NOCOPY NUMBER
352 , X_gl_flag IN VARCHAR2 );
353
354
355 -- ========================================================================
356 -- PROCEDURE InsertExp
357 -- ========================================================================
358 -- Added new multi-Currency parameters to PA_EXPENDITURES
359 --
360
361 PROCEDURE InsertExp( X_expenditure_id IN NUMBER
362 , X_expend_status IN VARCHAR2
363 , X_expend_ending IN DATE
364 , X_expend_class IN VARCHAR2
365 , X_inc_by_person IN NUMBER
366 , X_inc_by_org IN NUMBER
367 , X_expend_group IN VARCHAR2
368 , X_entered_by_id IN NUMBER
369 , X_created_by_id IN NUMBER
370 , X_attribute_category IN VARCHAR2 DEFAULT NULL
371 , X_attribute1 IN VARCHAR2 DEFAULT NULL
372 , X_attribute2 IN VARCHAR2 DEFAULT NULL
373 , X_attribute3 IN VARCHAR2 DEFAULT NULL
374 , X_attribute4 IN VARCHAR2 DEFAULT NULL
375 , X_attribute5 IN VARCHAR2 DEFAULT NULL
379 , X_attribute9 IN VARCHAR2 DEFAULT NULL
376 , X_attribute6 IN VARCHAR2 DEFAULT NULL
377 , X_attribute7 IN VARCHAR2 DEFAULT NULL
378 , X_attribute8 IN VARCHAR2 DEFAULT NULL
380 , X_attribute10 IN VARCHAR2 DEFAULT NULL
381 , X_description IN VARCHAR2 DEFAULT NULL
382 , X_control_total IN NUMBER DEFAULT NULL
383 , X_denom_currency_code IN VARCHAR2 DEFAULT NULL
384 , X_acct_currency_code IN VARCHAR2 DEFAULT NULL
385 , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
386 , X_acct_rate_date IN DATE DEFAULT NULL
387 , X_acct_exchange_rate IN NUMBER DEFAULT NULL
388 -- Trx_import enhancement:
389 -- New parameters used to populate PA_EXPENDITURES_ALL
390 -- table's new columns
391 , X_orig_exp_txn_reference1 IN VARCHAR2 DEFAULT NULL
392 , X_orig_user_exp_txn_reference IN VARCHAR2 DEFAULT NULL
393 , X_vendor_id IN NUMBER DEFAULT NULL
394 , X_orig_exp_txn_reference2 IN VARCHAR2 DEFAULT NULL
395 , X_orig_exp_txn_reference3 IN VARCHAR2 DEFAULT NULL
396 , X_person_type IN VARCHAR2 DEFAULT NULL /* cwk */
397 , P_Org_Id IN NUMBER Default NULL -- 12i MOAC changes
398 );
399
400 -- ========================================================================
401 -- PROCEDURE InsertExpGroup
402 -- ========================================================================
403
404 PROCEDURE InsertExpGroup(
405 X_expenditure_group IN VARCHAR2
406 , X_exp_group_status_code IN VARCHAR2
407 , X_ending_date IN DATE
408 , X_system_linkage IN VARCHAR2
409 , X_created_by IN NUMBER
410 , X_transaction_source IN VARCHAR2
411 , P_Accrual_Flag IN VARCHAR2 default null
412 , P_Org_Id IN NUMBER default Null); -- 12i MOAC changes
413
414
415 -- ========================================================================
416 -- PROCEDURE CreateRelatedItem
417 -- ========================================================================
418 -- Changed the parameter name from raw_cost to denom_raw_cost and
419 -- raw_cost_rate to denom_cost_rate
420 --
421 /*#
422 * Use this procedure to create related transactions within the logic of the Add Transactions procedure.
423 * @param X_source_exp_item_id The identifier of the source transaction
424 * @rep:paraminfo {@rep:required}
425 * @param X_project_id The identifier of the project to charge the related transaction to
426 * @param X_task_id The identifier of the task
427 * @param X_expenditure_type The expenditure type of the related transaction
428 * @rep:paraminfo {@rep:required}
429 * @param X_denom_raw_cost The raw cost amount of the related transaction in transaction currency
430 * @rep:paraminfo {@rep:required}
431 * @param X_denom_raw_cost_rate The raw cost rate of the related transaction
432 * @rep:paraminfo {@rep:required}
433 * @param X_override_to_org_id The identifier of the organization that overrides the expenditure organization used by the source transaction
434 * @rep:paraminfo {@rep:required}
435 * @param X_userid The identifier of the user that entered the source transaction
436 * @rep:paraminfo {@rep:required}
437 * @param X_attribute_category Descriptive flexfield category
438 * @rep:paraminfo {@rep:required}
439 * @param X_attribute1 Descriptive flexfield segment
440 * @rep:paraminfo {@rep:required}
441 * @param X_attribute2 Descriptive flexfield segment
442 * @rep:paraminfo {@rep:required}
443 * @param X_attribute3 Descriptive flexfield segment
444 * @rep:paraminfo {@rep:required}
445 * @param X_attribute4 Descriptive flexfield segment
446 * @rep:paraminfo {@rep:required}
447 * @param X_attribute5 Descriptive flexfield segment
448 * @rep:paraminfo {@rep:required}
449 * @param X_attribute6 Descriptive flexfield segment
450 * @rep:paraminfo {@rep:required}
451 * @param X_attribute7 Descriptive flexfield segment
452 * @rep:paraminfo {@rep:required}
453 * @param X_attribute8 Descriptive flexfield segment
454 * @rep:paraminfo {@rep:required}
455 * @param X_attribute9 Descriptive flexfield segment
456 * @rep:paraminfo {@rep:required}
457 * @param X_attribute10 Descriptive flexfield segment
458 * @rep:paraminfo {@rep:required}
459 * @param X_comment Expenditure item comment
460 * @rep:paraminfo {@rep:required}
461 * @param X_status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
462 * @rep:paraminfo {@rep:required}
463 * @param X_outcome Outcome of the procedure
464 * @rep:paraminfo {@rep:required}
465 * @param X_work_type_name Name of the work type assigned to the transaction
466 * @rep:scope public
467 * @rep:lifecycle active
468 * @rep:displayname Create Related Transactions
469 * @rep:compatibility S
470 */
471 PROCEDURE CreateRelatedItem(
472 X_source_exp_item_id IN NUMBER
473 , X_project_id IN NUMBER DEFAULT NULL
474 , X_task_id IN NUMBER DEFAULT NULL
475 , X_Award_id IN NUMBER DEFAULT NULL
476 , X_expenditure_type IN VARCHAR2
477 , X_denom_raw_cost IN NUMBER
478 , X_denom_raw_cost_rate IN NUMBER
479 , X_override_to_org_id IN NUMBER
480 , X_userid IN NUMBER
481 , X_attribute_category IN VARCHAR2
482 , X_attribute1 IN VARCHAR2
483 , X_attribute2 IN VARCHAR2
484 , X_attribute3 IN VARCHAR2
485 , X_attribute4 IN VARCHAR2
486 , X_attribute5 IN VARCHAR2
487 , X_attribute6 IN VARCHAR2
488 , X_attribute7 IN VARCHAR2
489 , X_attribute8 IN VARCHAR2
490 , X_attribute9 IN VARCHAR2
491 , X_attribute10 IN VARCHAR2
492 , X_comment IN VARCHAR2
493 , X_status OUT NOCOPY NUMBER
494 , X_outcome OUT NOCOPY VARCHAR2
495 , X_work_type_name IN VARCHAR2 DEFAULT NULL/*bug2482593*/
496 );
497
498
499 -- ========================================================================
500 -- PROCEDURE UpdateRelatedItem
501 -- ========================================================================
502 -- Changed the parameter name from raw_cost to denom_raw_cost and
503 -- raw_cost_rate to denom_cost_rate
504 --
505 --
506 /*#
507 * Use this procedure to update the raw cost amount of existing related transactions within the logic of your labor
508 * transaction extension when related transactions are marked for cost recalculation.
509 * @param X_expenditure_item_id The identifier of the related expenditure item
510 * @rep:paraminfo {@rep:required}
511 * @param X_denom_raw_cost The new raw cost of the related transaction in the transaction currency
512 * @rep:paraminfo {@rep:required}
513 * @param X_denom_raw_cost_rate The new raw cost rate of the related transaction in the transaction currency
514 * @rep:paraminfo {@rep:required}
515 * @param X_status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
516 * @rep:paraminfo {@rep:required}
517 * @param X_work_type_name Name of the work type assigned to the transaction
518 * @rep:scope public
519 * @rep:lifecycle active
520 * @rep:displayname Update Related Transactions
521 * @rep:compatibility S
522 */
523 PROCEDURE UpdateRelatedItem( X_expenditure_item_id IN NUMBER
524 , X_denom_raw_cost IN NUMBER
525 , X_denom_raw_cost_rate IN NUMBER
526 , X_status OUT NOCOPY NUMBER
527 , X_work_type_name IN VARCHAR2 DEFAULT NULL/*bug2482593*/
528 );
529
530
531 -- Added as a fix for the bug # 1358018
532 -- ========================================================================
533 -- PROCEDURE UpdateSystemLinkFunc
534 -- ========================================================================
535
536 PROCEDURE UpdateSystemLinkFunc( X_expend_item_id IN NUMBER
537 , X_sys_link_func IN VARCHAR2);
538
539 -- ========================================================================
540 -- PA-K Changes: Added this procedure
541 -- PROCEDURE InsertExpGroupNew
542 -- ========================================================================
543
544 PROCEDURE InsertExpGroupNew(
545 X_expenditure_group IN VARCHAR2
546 , X_exp_group_status_code IN VARCHAR2
547 , X_ending_date IN DATE
548 , X_system_linkage IN VARCHAR2
549 , X_created_by IN NUMBER
550 , X_transaction_source IN VARCHAR2
551 , P_Accrual_Flag IN VARCHAR2 default null
552 , P_Org_Id IN NUMBER default null); -- 12i MOAC changes
553
554 END PA_TRANSACTIONS;
[Home] [Help]