1 PACKAGE PA_ADJUSTMENTS AS
2 /* $Header: PAXTADJS.pls 120.21.12000000.4 2007/03/22 09:01:01 pkaur ship $ */
3
4 INVALID_ITEM EXCEPTION;
5 SUBROUTINE_ERROR EXCEPTION;
6
7 ExpItemsIdTab pa_utils.IdTabTyp ;
8
9 -- Added the following table to keep track of all the EI's that are
10 -- being adjusted by Txn Import program.
11
12 ExpAdjItemTab pa_utils.IdTabTyp;
13 BackOutId NUMBER;
14
15 /* R12 Changes Start */
16 G_REQUEST_ID NUMBER(15) := NULL;
17 G_PROGRAM_ID NUMBER(15) := NULL;
18 G_PROG_APPL_ID NUMBER(15) := NULL;
19 /* R12 Changes End */
20
21 -- The following variable will decide if MRC data needs to be updated.
22 -- This flag is useful in cases where the MRC triggres are disabled(
23 -- For example during install/upgrade)
24 -- pa41fixs.sql uses this flag to upgrade MRC data.
25
26 --G_update_mrc_data Varchar2(1) := 'N'; -- MRC Elimination
27
28 PROCEDURE CheckStatus( status_indicator IN OUT NOCOPY NUMBER );
29
30
31 FUNCTION VerifyOrigItem ( X_person_id IN NUMBER
32 , X_org_id IN NUMBER
33 , X_item_date IN DATE
34 , X_task_id IN NUMBER
35 , X_exp_type IN VARCHAR2
36 , X_system_linkage_function IN VARCHAR2
37 , X_nl_org_id IN NUMBER
38 , X_nl_resource IN VARCHAR2
39 , X_quantity IN NUMBER
40 , X_denom_raw_cost IN NUMBER
41 , X_trx_source IN VARCHAR2
42 , X_denom_currency_code IN VARCHAR2
43 , X_acct_raw_cost IN NUMBER
44 -- SST Changes: Additional parameter
45 , X_reversed_orig_txn_reference IN OUT NOCOPY VARCHAR2
46 ) RETURN NUMBER;
47
48 PROCEDURE CommentChange( X_exp_item_id IN NUMBER
49 , X_new_comment IN VARCHAR2
50 , X_user IN NUMBER
51 , X_login IN NUMBER
52 , X_status OUT NOCOPY NUMBER );
53
54 PROCEDURE InsAuditRec( X_exp_item_id IN NUMBER
55 , X_adj_activity IN VARCHAR2
56 , X_module IN VARCHAR2
57 , X_user IN NUMBER
58 , X_login IN NUMBER
59 , X_status OUT NOCOPY NUMBER
60 , X_who_req_id IN NUMBER DEFAULT NULL
61 , X_who_prog_id IN NUMBER DEFAULT NULL
62 , X_who_prog_app_id IN NUMBER DEFAULT NULL
63 , X_who_prog_upd_date IN DATE DEFAULT NULL
64 /* R12 Changes Start */
65 , X_rejection_code IN VARCHAR2 DEFAULT NULL );
66 /* R12 Changes End */
67
68 PROCEDURE SetNetZero( X_exp_item_id IN NUMBER
69 , X_user IN NUMBER
70 , X_login IN NUMBER
71 , X_status OUT NOCOPY NUMBER );
72
73 PROCEDURE BackoutItem( X_exp_item_id IN NUMBER
74 , X_expenditure_id IN NUMBER
75 , X_adj_activity IN VARCHAR2
76 , X_module IN VARCHAR2
77 , X_user IN NUMBER
78 , X_login IN NUMBER
79 , X_status OUT NOCOPY NUMBER );
80
81 /* MRC Elimination
82 PROCEDURE BackoutMrcItem( X_exp_item_id IN NUMBER
83 , X_backout_id IN NUMBER
84 , X_adj_activity IN VARCHAR2
85 , X_module IN VARCHAR2
86 , X_user IN NUMBER
87 , X_login IN NUMBER
88 , X_status OUT NOCOPY NUMBER );
89 */
90
91 PROCEDURE ReverseRelatedItems( X_source_exp_item_id IN NUMBER
92 , X_expenditure_id IN NUMBER
93 , X_module IN VARCHAR2
94 , X_user IN NUMBER
95 , X_login IN NUMBER
96 , X_status OUT NOCOPY NUMBER );
97
98 PROCEDURE RecalcRev(ItemsIdTab IN pa_utils.IdTabTyp
99 , AdjustsIdTab IN pa_utils.IdTabTyp
100 , X_user IN NUMBER
101 , X_login IN NUMBER
102 , X_module IN VARCHAR2
103 , rows IN NUMBER
104 , X_status OUT NOCOPY NUMBER );
105
106 PROCEDURE RecalcCostRev(ItemsIdTab IN pa_utils.IdTabTyp
107 , AdjustsIdTab IN pa_utils.IdTabTyp
108 , X_user IN NUMBER
109 , X_login IN NUMBER
110 , X_module IN VARCHAR2
111 , rows IN NUMBER
112 , X_num_processed OUT NOCOPY NUMBER
113 , X_status OUT NOCOPY NUMBER );
114
115 PROCEDURE RecalcRawCost(ItemsIdTab IN pa_utils.IdTabTyp
116 , AdjustsIdTab IN pa_utils.IdTabTyp
117 , X_user IN NUMBER
118 , X_login IN NUMBER
119 , X_module IN VARCHAR2
120 , rows IN NUMBER
121 , X_num_processed OUT NOCOPY NUMBER
122 , X_status OUT NOCOPY NUMBER );
123
124 PROCEDURE RecalcIndCost(ItemsIdTab IN pa_utils.IdTabTyp
125 , AdjustsIdTab IN pa_utils.IdTabTyp
126 , X_user IN NUMBER
127 , X_login IN NUMBER
128 , X_module IN VARCHAR2
129 , rows IN BINARY_INTEGER
130 , X_status OUT NOCOPY NUMBER );
131
132 PROCEDURE RecalcCapCost(ItemsIdTab IN pa_utils.IdTabTyp
133 , AdjustsIdTab IN pa_utils.IdTabTyp
134 , X_user IN NUMBER
135 , X_login IN NUMBER
136 , X_module IN VARCHAR2
137 , rows IN BINARY_INTEGER
138 , X_status OUT NOCOPY NUMBER );
139
140
141 FUNCTION GetInvId (X_expenditure_item_id NUMBER ) RETURN VARCHAR2 ;
142 --pragma RESTRICT_REFERENCES ( GetInvId, WNDS, WNPS);
143
144 /* R12 Changes Start */
145 FUNCTION InvStatus( X_system_reference2 VARCHAR2,
146 X_system_linkage_function VARCHAR2 DEFAULT NULL)
147 return VARCHAR2;
148 /* R12 Changes End */
149
150 PROCEDURE Hold(ItemsIdTab IN pa_utils.IdTabTyp
151 , AdjustsIdTab IN pa_utils.IdTabTyp
152 , X_hold IN VARCHAR2
153 , X_adj_activity IN VARCHAR2
154 , X_user IN NUMBER
155 , X_login IN NUMBER
156 , X_module IN VARCHAR2
157 , rows IN BINARY_INTEGER
158 , X_status OUT NOCOPY NUMBER );
159
160 PROCEDURE Reclass(ItemsIdTab IN pa_utils.IdTabTyp
161 , AdjustsIdTab IN pa_utils.IdTabTyp
162 , X_billable IN VARCHAR2
163 , X_adj_activity IN VARCHAR2
164 , X_user IN NUMBER
165 , X_login IN NUMBER
166 , X_module IN VARCHAR2
167 , rows IN BINARY_INTEGER
168 , X_status OUT NOCOPY NUMBER );
169
170 PROCEDURE Split( X_exp_item_id IN NUMBER
171 , X_item1_qty IN NUMBER
172 , X_item1_raw_cost IN NUMBER -- proj func
173 , X_item1_burden_cost IN NUMBER -- proj func
174 , X_item1_bill_flag IN VARCHAR2
175 , X_item1_hold_flag IN VARCHAR2
176 , X_item2_qty IN NUMBER
177 , X_item2_raw_cost IN NUMBER -- proj func
178 , X_item2_burden_cost IN NUMBER -- proj func
179 , X_item1_receipt_curr_amt IN NUMBER
180 , X_item2_receipt_curr_amt IN NUMBER
181 , X_item1_denom_raw_cost IN NUMBER
182 , X_item2_denom_raw_cost IN NUMBER
183 , X_item1_denom_burdened_cost IN NUMBER
184 , X_item2_denom_burdened_cost IN NUMBER
185 , X_Item1_acct_raw_cost IN NUMBER
186 , X_item2_acct_raw_cost IN NUMBER
187 , X_item1_acct_burdened_cost IN NUMBER
188 , X_item2_acct_burdened_cost IN NUMBER
189 , X_item2_bill_flag IN VARCHAR2
190 , X_item2_hold_flag IN VARCHAR2
191 , X_user IN NUMBER
192 , X_login IN NUMBER
193 , X_module IN VARCHAR2
194 , X_status OUT NOCOPY NUMBER
195 , p_item1_project_raw_cost IN NUMBER default null -- project raw
196 , p_item1_project_burden_cost IN NUMBER default null -- project burden
197 , p_item2_project_raw_cost IN NUMBER default null -- project raw
198 , p_item2_project_burden_cost IN NUMBER default null -- project burden
199 );
200
201 PROCEDURE Transfer(ItemsIdTab IN pa_utils.IdTabTyp
202 , X_dest_prj_id IN NUMBER
203 , X_dest_task_id IN NUMBER
204 , X_project_currency_code IN VARCHAR2
205 , X_project_rate_type IN VARCHAR2
206 , X_project_rate_date IN DATE
207 , X_project_exchange_rate IN NUMBER
208 , X_user IN NUMBER
209 , X_login IN NUMBER
210 , X_module IN VARCHAR2
211 , X_adjust_level IN VARCHAR2
212 , rows IN BINARY_INTEGER
213 , X_num_processed OUT NOCOPY NUMBER
214 , X_num_rejected OUT NOCOPY NUMBER
215 , X_outcome OUT NOCOPY VARCHAR2
216 , X_msg_application OUT NOCOPY VARCHAR2
217 , X_msg_type OUT NOCOPY VARCHAR2
218 , X_msg_token1 OUT NOCOPY VARCHAR2
219 , X_msg_token2 OUT NOCOPY VARCHAR2
220 , X_msg_token3 OUT NOCOPY VARCHAR2
221 , X_msg_count OUT NOCOPY Number
222 , p_projfunc_currency_code IN VARCHAR2 default null
223 , p_projfunc_cost_rate_type IN VARCHAR2 default null
224 , p_projfunc_cost_rate_date IN DATE default null
225 , p_projfunc_cost_exchg_rate IN NUMBER default null
226 , p_assignment_id IN NUMBER default null
227 , p_work_type_id IN NUMBER default null );
228
229 -- Added New parameters acct rate attributes and denom currency for new MC -- adjustments to Adjust
230 -- Added new parameters X_cc_code, X_cc_type, X_bl_dist_code and
231 -- X_ic_proc_code as part of the new CC adjustments
232
233 PROCEDURE Adjust( X_adj_action IN VARCHAR2
234 , X_module IN VARCHAR2
235 , X_user IN NUMBER
236 , X_login IN NUMBER
237 , X_project_id IN NUMBER
238 , X_adjust_level IN VARCHAR2
239 , X_expenditure_item_id IN NUMBER DEFAULT NULL
240 , X_dest_prj_id IN NUMBER DEFAULT NULL
241 , X_dest_task_id IN NUMBER DEFAULT NULL
242 , X_project_currency_code IN VARCHAR2 DEFAULT NULL
243 , X_project_rate_type IN VARCHAR2 DEFAULT NULL
244 , X_project_rate_date IN DATE DEFAULT NULL
245 , X_project_exchange_rate IN NUMBER DEFAULT NULL
246 , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
247 , X_acct_rate_date IN DATE DEFAULT NULL
248 , X_acct_exchange_rate IN NUMBER DEFAULT NULL
249 , X_task_id IN NUMBER DEFAULT NULL
250 , X_inc_by_person_id IN NUMBER DEFAULT NULL
251 , X_inc_by_org_id IN NUMBER DEFAULT NULL
252 , X_ei_date_low IN DATE DEFAULT NULL
253 , X_ei_date_high IN DATE DEFAULT NULL
254 , X_system_linkage IN VARCHAR2 DEFAULT NULL
255 , X_expenditure_type IN VARCHAR2 DEFAULT NULL
256 , X_vendor_id IN NUMBER DEFAULT NULL
257 , X_nl_resource_org_id IN NUMBER DEFAULT NULL
258 , X_nl_resource IN VARCHAR2 DEFAULT NULL
259 , X_bill_status IN VARCHAR2 DEFAULT NULL
260 , X_hold_flag IN VARCHAR2 DEFAULT NULL
261 , X_expenditure_comment IN VARCHAR2 DEFAULT NULL
262 , X_inv_num IN NUMBER DEFAULT NULL
263 , X_inv_line_num IN NUMBER DEFAULT NULL
264 , X_cc_code IN VARCHAR2 DEFAULT NULL
265 , X_cc_type IN VARCHAR2 DEFAULT NULL
266 , X_bl_dist_code IN VARCHAR2 DEFAULT NULL
267 , X_ic_proc_code IN VARCHAR2 DEFAULT NULL
268 , X_prvdr_orgnzn_id IN NUMBER DEFAULT NULL
269 , X_recvr_orgnzn_id IN NUMBER DEFAULT NULL
270 , X_outcome OUT NOCOPY VARCHAR2
271 , X_num_processed OUT NOCOPY NUMBER
275 , X_msg_token1 OUT NOCOPY VARCHAR2
272 , X_num_rejected OUT NOCOPY NUMBER
273 , X_msg_application OUT NOCOPY VARCHAR2
274 , X_msg_type OUT NOCOPY VARCHAR2
276 , X_msg_token2 OUT NOCOPY VARCHAR2
277 , X_msg_token3 OUT NOCOPY VARCHAR2
278 , X_msg_count OUT NOCOPY Number
279 /* added for proj currency and additional EI attributes **/
280 , p_assignment_id IN NUMBER default null
281 , p_work_type_id IN NUMBER default null
282 , p_projfunc_currency_code IN varchar2 default null
283 , p_projfunc_cost_rate_date IN date default null
284 , p_projfunc_cost_rate_type IN varchar2 default null
285 , p_projfunc_cost_exchange_rate IN number default null
286 , p_project_raw_cost IN number default null
287 , p_project_burdened_cost IN number default null
288 , p_project_tp_currency_code IN varchar2 default null
289 , p_project_tp_cost_rate_date IN date default null
290 , p_project_tp_cost_rate_type IN varchar2 default null
291 , p_project_tp_cost_exchg_rate IN number default null
292 , p_project_transfer_price IN number default null
293 , p_dest_work_type_id IN NUMBER default null
294 , p_tp_amt_type_code IN varchar2 default null
295 , p_dest_tp_amt_type_code IN varchar2 default null
296 /** end of proj currency and additional EI attributes **/
297 );
298
299 -- Added new parameters acct rate attributes and denon currency to
300 -- massadjust procedure for new MC adjustments
301
302 /*
303 * IC related changes
304 * New parameters added against IC
305 */
306 PROCEDURE MassAdjust(
307 X_adj_action IN VARCHAR2
308 , X_module IN VARCHAR2
309 , X_user IN NUMBER
310 , X_login IN NUMBER
311 , X_project_id IN NUMBER
312 , X_dest_prj_id IN NUMBER DEFAULT NULL
313 , X_dest_task_id IN NUMBER DEFAULT NULL
314 , X_project_currency_code IN VARCHAR2 DEFAULT NULL
315 , X_project_rate_type IN VARCHAR2 DEFAULT NULL
316 , X_project_rate_date IN DATE DEFAULT NULL
317 , X_project_exchange_rate IN NUMBER DEFAULT NULL
318 , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
319 , X_acct_rate_date IN DATE DEFAULT NULL
320 , X_acct_exchange_rate IN NUMBER DEFAULT NULL
321 , X_task_id IN NUMBER DEFAULT NULL
322 , X_inc_by_person_id IN NUMBER DEFAULT NULL
323 , X_inc_by_org_id IN NUMBER DEFAULT NULL
324 , X_ei_date_low IN DATE DEFAULT NULL
325 , X_ei_date_high IN DATE DEFAULT NULL
326 , X_ex_end_date_low IN DATE DEFAULT NULL
327 , X_ex_end_date_high IN DATE DEFAULT NULL
328 , X_system_linkage IN VARCHAR2 DEFAULT NULL
329 , X_expenditure_type IN VARCHAR2 DEFAULT NULL
330 , X_expenditure_catg IN VARCHAR2 DEFAULT NULL
331 , X_expenditure_group IN VARCHAR2 DEFAULT NULL
332 , X_vendor_id IN NUMBER DEFAULT NULL
333 , X_job_id IN NUMBER DEFAULT NULL
334 , X_nl_resource_org_id IN NUMBER DEFAULT NULL
335 , X_nl_resource IN VARCHAR2 DEFAULT NULL
336 , X_transaction_source IN VARCHAR2 DEFAULT NULL
337 , X_cost_distributed_flag IN VARCHAR2 DEFAULT NULL
338 , X_revenue_distributed_flag IN VARCHAR2 DEFAULT NULL
339 , X_grouped_cip_flag IN VARCHAR2 DEFAULT NULL
340 , X_bill_status IN VARCHAR2 DEFAULT NULL
341 , X_hold_flag IN VARCHAR2 DEFAULT NULL
342 , X_billable_flag IN VARCHAR2 DEFAULT NULL
343 , X_capitalizable_flag IN VARCHAR2 DEFAULT NULL
344 , X_net_zero_adjust_flag IN VARCHAR2 DEFAULT NULL
345 , X_inv_num IN NUMBER DEFAULT NULL
346 , X_inv_line_num IN NUMBER DEFAULT NULL
347 , X_cc_code_to_be_determined IN VARCHAR2 DEFAULT 'N'
348 , X_cc_code_not_crosscharged IN VARCHAR2 DEFAULT 'XX'
349 , X_cc_code_intra_ou IN VARCHAR2 DEFAULT 'XX'
350 , X_cc_code_inter_ou IN VARCHAR2 DEFAULT 'XX'
351 , X_cc_code_intercompany IN VARCHAR2 DEFAULT 'XX'
352 , X_cc_type_no_processing IN VARCHAR2 DEFAULT 'Z'
353 , X_cc_type_b_and_l IN VARCHAR2 DEFAULT 'Z'
354 , X_cc_type_ic_billing IN VARCHAR2 DEFAULT 'Z'
355 , X_cc_prvdr_organization_id IN NUMBER DEFAULT NULL
356 , X_cc_prvdr_ou IN NUMBER DEFAULT NULL
357 , X_cc_recvr_organization_id IN NUMBER DEFAULT NULL
358 , X_cc_recvr_ou IN NUMBER DEFAULT NULL
359 , X_cc_bl_distributed_code IN VARCHAR2 DEFAULT NULL
360 , X_cc_ic_processed_code IN VARCHAR2 DEFAULT NULL
361 , X_expenditure_item_id IN NUMBER DEFAULT NULL
365 /* added for proj currency and additional EI attributes **/
362 , X_outcome OUT NOCOPY VARCHAR2
363 , X_num_processed OUT NOCOPY NUMBER
364 , X_num_rejected OUT NOCOPY NUMBER
366 , p_assignment_id IN NUMBER default null
367 , p_work_type_id IN NUMBER default null
368 , p_projfunc_currency_code IN varchar2 default null
369 , p_projfunc_cost_rate_date IN date default null
370 , p_projfunc_cost_rate_type IN varchar2 default null
371 , p_projfunc_cost_exchange_rate IN number default null
372 , p_project_raw_cost IN number default null
373 , p_project_burdened_cost IN number default null
374 , p_project_tp_currency_code IN varchar2 default null
375 , p_project_tp_cost_rate_date IN date default null
376 , p_project_tp_cost_rate_type IN varchar2 default null
377 , p_project_tp_cost_exchg_rate IN number default null
378 , p_project_transfer_price IN number default null
379 , p_dest_work_type_id IN NUMBER default null
380 , p_dest_tp_amt_type_code IN varchar2 default null
381 , p_dest_wt_start_date IN date default null
382 , p_dest_wt_end_date IN date default null
383 -- New parameters addes for FP 'L' additional attributes.
384 , p_grouped_rwip_flag IN varchar2 default null
385 , p_capital_event_number IN number default null
386 , p_start_gl_date IN date default null
387 , p_end_gl_date IN date default null
388 , p_start_pa_date IN date default null
389 , p_end_pa_date IN date default null
390 , p_recvr_start_gl_date IN date default null
391 , p_recvr_end_gl_date IN date default null
392 , p_recvr_start_pa_date IN date default null
393 , p_recvr_end_pa_date IN date default null
394 /* R12 Changes - Start */
395 , p_invoice_id IN NUMBER DEFAULT NULL
396 , p_invoice_line_number IN NUMBER DEFAULT NULL
397 , p_include_related_tax_lines IN VARCHAR2 DEFAULT NULL
398 , p_receipt_number IN VARCHAR2 DEFAULT NULL
399 , p_check_id IN NUMBER DEFAULT NULL /* 4914048 */
400 , p_org_id IN NUMBER DEFAULT NULL
401 , p_dest_award_id IN NUMBER DEFAULT NULL
402 , p_rev_exp_items_req_adjust IN VARCHAR2 DEFAULT NULL
403 , p_award_id IN NUMBER DEFAULT NULL /* 5194785 */
404 , p_expensed_flag IN VARCHAR2 DEFAULT NULL
405 , p_wip_resource_id IN NUMBER DEFAULT NULL
406 , p_inventory_item_id IN NUMBER DEFAULT NULL
407 /* R12 Changes - End */
408 );
409
410
411 -- Added new parameters acct rate attributes and denon currency to
412 -- massaction procedure for new MC adjustments
413
414 PROCEDURE MassAction(
415 ItemsIdTab IN pa_utils.IdTabTyp
416 , AdjustsIdTab IN pa_utils.IdTabTyp
417 , X_adj_action IN VARCHAR2
418 , X_module IN VARCHAR2
419 , X_user IN NUMBER
420 , X_login IN NUMBER
421 , X_num_rows IN NUMBER
422 , X_dest_prj_id IN NUMBER DEFAULT NULL
423 , X_dest_task_id IN NUMBER DEFAULT NULL
424 , X_project_currency_code IN VARCHAR2 DEFAULT NULL
425 , X_project_rate_type IN VARCHAR2 DEFAULT NULL
426 , X_project_rate_date IN DATE DEFAULT NULL
427 , X_project_exchange_rate IN NUMBER DEFAULT NULL
428 , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
429 , X_acct_rate_date IN DATE DEFAULT NULL
430 , X_acct_exchange_rate IN NUMBER DEFAULT NULL
431 , DenomCurrCodeTab IN pa_utils.Char15TabTyp
432 , ProjCurrCodeTab IN pa_utils.Char15TabTyp
433 , X_status OUT NOCOPY VARCHAR2
434 , X_num_processed OUT NOCOPY NUMBER
435 , X_num_rejected OUT NOCOPY NUMBER
436 , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
437 , p_projfunc_cost_rate_type IN VARCHAR2 DEFAULT NULL
438 , p_projfunc_cost_rate_date IN date DEFAULT NULL
439 , p_projfunc_cost_exchange_rate IN NUMBER DEFAULT NULL
440 , p_project_tp_cost_rate_type IN VARCHAR2 DEFAULT NULL
441 , p_project_tp_cost_rate_date IN DATE DEFAULT NULL
442 , p_project_tp_cost_exchg_rate IN NUMBER DEFAULT NULL
443 , p_assignment_id IN NUMBER DEFAULT NULL
444 , p_work_type_id IN NUMBER DEFAULT NULL
445 , p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL
446 , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp
447 , p_dest_tp_amt_type_code IN VARCHAR2 DEFAULT NULL);
448
449 /* ---------------------------------------------------------------------------
450 -- Start of Comments
451 -- API Name : ei_adjusted_in_cache
452 -- Type : Public
453 -- Pre-Reqs : None
454 -- Function : This function checks if the expenditure item that is passed
458 -- returns N.
455 -- in as parameter is already adjusted in cache( This is for
456 -- transaction import program because it stores all the data
457 -- in cache.) If it's adjusted, it returns a value of Y else
459 -- Purity : WNDS, WNPS.
460 -- Parameters :
461 -- IN : Expenditure_item_id
462 -- RETURNS : VARCHAR2
463 -- End of Comments
464 -----------------------------------------------------------------------------*/
465
466 FUNCTION ei_adjusted_in_cache(X_exp_item_id IN Number) RETURN Varchar2;
467
468 --pragma RESTRICT_REFERENCES(ei_adjusted_in_cache,WNDS,WNPS);
469
470
471 PROCEDURE ChangeFuncAttributes(ItemsIdTab IN pa_utils.IdTabTyp
472 , X_adjust_level IN VARCHAR2
473 , X_user IN NUMBER
474 , X_login IN NUMBER
475 , X_module IN VARCHAR2
476 , X_acct_rate_type IN VARCHAR2
477 , X_acct_rate_date IN DATE
478 , X_acct_exchange_rate IN NUMBER
479 , DenomCurrCodeTab IN pa_utils.Char15TabTyp
480 , ProjCurrCodeTab IN pa_utils.Char15TabTyp
481 , rows IN NUMBER
482 , X_num_processed OUT NOCOPY NUMBER
483 , X_num_rejected OUT NOCOPY NUMBER
484 , X_status OUT NOCOPY NUMBER
485 , ProjfuncCurrCodeTab IN pa_utils.Char15TabTyp );
486
487
488 PROCEDURE ChangeProjAttributes(ItemsIdTab IN pa_utils.IdTabTyp
489 , X_adjust_level IN VARCHAR2
490 , X_user IN NUMBER
491 , X_login IN NUMBER
492 , X_module IN VARCHAR2
493 , X_project_rate_type IN VARCHAR2
494 , X_project_rate_date IN DATE
495 , X_project_exchange_rate IN NUMBER
496 , DenomCurrCodeTab IN pa_utils.Char15TabTyp
497 , ProjCurrCodeTab IN pa_utils.Char15TabTyp
498 , rows IN NUMBER
499 , X_num_processed OUT NOCOPY NUMBER
500 , X_num_rejected OUT NOCOPY NUMBER
501 , X_status OUT NOCOPY NUMBER );
502
503 -- Added the following new procedures for the Cross Charge Adjustments
504
505 PROCEDURE ReprocessCrossCharge(ItemsIdTab IN pa_utils.IdTabTyp
506 , X_adjust_level IN VARCHAR2
507 , X_user IN NUMBER
508 , X_login IN NUMBER
509 , X_module IN VARCHAR2
510 , X_cc_code IN VARCHAR2
511 , X_cc_type IN VARCHAR2
512 , X_bl_dist_code IN VARCHAR2
513 , X_ic_proc_code IN VARCHAR2
514 , X_prvdr_orgnzn_id IN NUMBER
515 , X_recvr_orgnzn_id IN NUMBER
516 , rows IN NUMBER
517 , X_num_processed OUT NOCOPY NUMBER
518 , X_status OUT NOCOPY NUMBER );
519
520 PROCEDURE MarkNoCCProcess (ItemsIdTab IN pa_utils.IdTabTyp
521 , X_adjust_level IN VARCHAR2
522 , X_user IN NUMBER
523 , X_login IN NUMBER
524 , X_module IN VARCHAR2
525 , X_bl_dist_code IN VARCHAR2
526 , X_ic_proc_code IN VARCHAR2
527 , rows IN NUMBER
528 , X_num_processed OUT NOCOPY NUMBER
529 , X_status OUT NOCOPY NUMBER );
530
531 PROCEDURE ChangeTPAttributes(ItemsIdTab IN pa_utils.IdTabTyp
532 , X_adjust_level IN VARCHAR2
533 , X_user IN NUMBER
534 , X_login IN NUMBER
535 , X_module IN VARCHAR2
536 , X_acct_tp_rate_type IN VARCHAR2
537 , X_acct_tp_rate_date IN DATE
538 , X_acct_tp_exchange_rate IN NUMBER
539 , X_bl_dist_code IN VARCHAR2
540 , X_ic_proc_code IN VARCHAR2
541 , DenomCurrCodeTab IN pa_utils.Char15TabTyp
542 , rows IN NUMBER
543 , X_num_processed OUT NOCOPY NUMBER
544 , X_num_rejected OUT NOCOPY NUMBER
545 , X_status OUT NOCOPY NUMBER
546 , p_PROJECT_TP_COST_RATE_DATE IN DATE default null
547 , p_PROJECT_TP_COST_RATE_TYPE IN VARCHAR2 default null
548 , p_PROJECT_TP_COST_EXCHG_RATE IN NUMBER default null
549 );
550
551
552 /* ---------------------------------------------------------------------------
553 -- Start of Comments
554 -- API Name : allow_adjustment
555 -- Type : Public
556 -- Pre-Reqs : None
560 --
557 -- Function : This procedure is called when a user attempts to make an
558 -- adjustment in Projects to an expenditure item which was imported
559 -- from an external system.
561 -- 1) If the transaction source is seeded (except SST) then
562 -- the procedure will return pa_transaction_sources.allow_adjustment_flag.
563 --
564 -- 2) If the transaction source is SST, then it will check if the item has
565 -- already been adjusted in SST. If it has already been adjusted, then
566 -- no adjustment will be allowed.
567 --
568 -- 3) If the transaction souce is not seeded then the
569 -- allow_adjustment_extn client extension will be called. By
570 -- default, the client extn will return pa_transaction_sources.allow_adjustment_flag.
571 --
572 --
573 -- Parameters:
574 --
575 -- IN
576 -- p_transaction_source IN VARCHAR2
577 -- p_orig_transaction_reference IN VARCHAR2
578 -- p_expenditure_type_class IN VARCHAR2
579 -- p_expenditure_type IN VARCHAR2
580 -- p_expenditure_item_id IN NUMBER
581 -- p_expenditure_item_date IN DATE
582 -- p_employee_number IN VARCHAR2
583 -- p_expenditure_organization_name IN VARCHAR2
584 -- p_project_number IN VARCHAR2
585 -- p_task_number IN VARCHAR2
586 -- p_non_labor_resource IN VARCHAR2
587 -- p_non_labor_resource_org_name IN VARCHAR2
588 -- p_quantity IN NUMBER
589 -- p_raw_cost IN NUMBER
590 -- p_attribute_category IN VARCHAR2
591 -- p_attribute1 IN VARCHAR2
592 -- p_attribute2 IN VARCHAR2
593 -- p_attribute3 IN VARCHAR2
594 -- p_attribute4 IN VARCHAR2
595 -- p_attribute5 IN VARCHAR2
596 -- p_attribute6 IN VARCHAR2
597 -- p_attribute7 IN VARCHAR2
598 -- p_attribute8 IN VARCHAR2
599 -- p_attribute9 IN VARCHAR2
600 -- p_attribute10 IN VARCHAR2
601 -- p_org_id IN NUMBER
602 --OUT
603 -- x_adjustment_status_code OUT NOCOPY VARCHAR2
604 -- x_return_status OUT NOCOPY VARCHAR2
605 -- x_application_code OUT NOCOPY VARCHAR2,
606 -- x_message_code OUT NOCOPY VARCHAR2,
607 -- x_token_name1 OUT NOCOPY VARCHAR2,
608 -- x_token_val1 OUT NOCOPY VARCHAR2,
609 -- x_token_name2 OUT NOCOPY VARCHAR2,
610 -- x_token_val2 OUT NOCOPY VARCHAR2,
611 -- x_token_name3 OUT NOCOPY VARCHAR2,
612 -- x_token_val3 OUT NOCOPY VARCHAR2);
613 --
614 ------------------------------------------------------------------------------------------*/
615
616 PROCEDURE allow_adjustment(
617 p_transaction_source IN VARCHAR2,
618 p_orig_transaction_reference IN VARCHAR2,
619 p_expenditure_type_class IN VARCHAR2,
620 p_expenditure_type IN VARCHAR2,
621 p_expenditure_item_id IN NUMBER,
622 p_expenditure_item_date IN DATE,
623 p_employee_number IN VARCHAR2,
624 p_expenditure_org_name IN VARCHAR2,
625 p_project_number IN VARCHAR2,
626 p_task_number IN VARCHAR2,
627 p_non_labor_resource IN VARCHAR2,
628 p_non_labor_resource_org_name IN VARCHAR2,
629 p_quantity IN NUMBER,
630 p_raw_cost IN NUMBER,
631 p_attribute_category IN VARCHAR2,
632 p_attribute1 IN VARCHAR2,
633 p_attribute2 IN VARCHAR2,
634 p_attribute3 IN VARCHAR2,
635 p_attribute4 IN VARCHAR2,
636 p_attribute5 IN VARCHAR2,
640 p_attribute9 IN VARCHAR2,
637 p_attribute6 IN VARCHAR2,
638 p_attribute7 IN VARCHAR2,
639 p_attribute8 IN VARCHAR2,
641 p_attribute10 IN VARCHAR2,
642 p_org_id IN NUMBER,
643 x_allow_adjustment_code OUT NOCOPY VARCHAR2,
644 x_return_status OUT NOCOPY VARCHAR2,
645 x_application_code OUT NOCOPY VARCHAR2,
646 x_message_code OUT NOCOPY VARCHAR2,
647 x_token_name1 OUT NOCOPY VARCHAR2,
648 x_token_val1 OUT NOCOPY VARCHAR2,
649 x_token_name2 OUT NOCOPY VARCHAR2,
650 x_token_val2 OUT NOCOPY VARCHAR2,
651 x_token_name3 OUT NOCOPY VARCHAR2,
652 x_token_val3 OUT NOCOPY VARCHAR2);
653
654 /** This api is newly added to convert / change the project functional currency attributes
655 * this is called from EI enquiry form for EI adjustments
656 */
657 PROCEDURE ChangeProjFuncAttributes
658 (ItemsIdTab IN pa_utils.IdTabTyp
659 , p_adjust_level IN VARCHAR2
660 , p_user IN NUMBER
661 , p_login IN NUMBER
662 , p_module IN VARCHAR2
663 , p_projfunc_cost_rate_type IN VARCHAR2
664 , p_projfunc_cost_rate_date IN DATE
665 , p_projfunc_cost_exchg_rate IN NUMBER
666 , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp
667 , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
668 , p_rows IN NUMBER
669 , X_num_processed OUT NOCOPY NUMBER
670 , X_num_rejected OUT NOCOPY NUMBER
671 , X_status OUT NOCOPY NUMBER ) ;
672
673 FUNCTION is_proj_billable(p_task_id IN number) return varchar2 ;
674 --pragma RESTRICT_REFERENCES(is_proj_billable ,WNDS,WNPS);
675
676 /* Bug#2291180 : This function is added which returns denom_currency_code */
677 /* This is used during adjustments to update denom_currency_code */
678 FUNCTION get_denom_curr_code
679 (p_transaction_source IN VARCHAR2
680 , p_exp_type IN VARCHAR2
681 , p_denom_currency_code IN VARCHAR2
682 , p_acct_currency_code IN VARCHAR2
683 , p_system_linkage_function IN VARCHAR2
684 , p_calling_mode IN VARCHAR2 default 'ADJUST' /*Bugfix:2798742 */
685 , p_person_id IN NUMBER default NULL /*Bugfix:2798742 */
686 , p_ei_date IN DATE default NULL /*Bugfix:2798742 */
687 ) RETURN VARCHAR2;
688
689
690 /* R12 Changes Start
691 This function returns FALSE if Auto Offset Option is enabled
692 and the adjustment action 'p_action' results in a Charge account
693 which violates the Auto Offset Rules */
694 FUNCTION Allow_Adjust_with_Auto_Offset
695 (p_expenditure_item_id IN NUMBER,
696 p_org_id IN NUMBER,
697 p_system_linkage_function IN VARCHAR2,
698 p_transaction_source IN VARCHAR2,
699 P_action IN VARCHAR2,
700 P_project_id IN NUMBER,
701 P_task_id IN NUMBER,
702 p_expenditure_type IN VARCHAR2,
703 p_vendor_id IN NUMBER,
704 p_expenditure_organization_id IN NUMBER,
705 p_expenditure_item_date IN DATE,
706 p_emp_id IN NUMBER,
707 p_invoice_distribution_id IN NUMBER,
708 p_invoice_payment_id IN AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE, /* Bug 5006835 */
709 p_award_id IN NUMBER DEFAULT NULL,
710 p_billable_flag1 IN VARCHAR2 DEFAULT NULL,
711 p_billable_flag2 IN VARCHAR2 DEFAULT NULL,
712 x_encoded_error_message OUT NOCOPY VARCHAR2) /* Bug 4997739 */
713 RETURN BOOLEAN;
714 /* R12 changes End */
715
716 /* R12 Changes Start */
717 FUNCTION Get_Displayed_Field
718 ( p_lookup_type varchar2
719 , p_lookup_code varchar2)
720 RETURN VARCHAR2;
721
722 FUNCTION Get_PO_Info
723 ( p_key varchar2
724 , p_po_distribution_id number)
725 RETURN VARCHAR2;
726
727 FUNCTION Get_Rcv_Info
728 ( p_key varchar2
729 , p_rcv_transaction_id number)
730 RETURN VARCHAR2;
731
732 FUNCTION Get_Inv_Info
733 ( p_key varchar2
734 , p_invoice_id number)
735 RETURN VARCHAR2;
736
737 FUNCTION is_recoverability_affected
738 (p_expenditure_item_id IN NUMBER,
739 p_org_id IN NUMBER,
740 p_system_linkage_function IN VARCHAR2,
744 P_task_id IN NUMBER,
741 p_transaction_source IN VARCHAR2,
742 P_action IN VARCHAR2,
743 P_project_id IN NUMBER,
745 p_expenditure_type IN VARCHAR2,
746 p_vendor_id IN NUMBER,
747 p_expenditure_organization_id IN NUMBER,
748 p_expenditure_item_date IN DATE,
749 p_emp_id IN NUMBER,
750 p_document_header_id IN NUMBER,
751 p_document_line_number IN NUMBER,
752 p_document_distribution_id IN NUMBER,
753 p_document_type IN VARCHAR2,
754 p_award_id IN NUMBER DEFAULT NULL,
755 p_billable_flag1 IN VARCHAR2 DEFAULT NULL,
756 p_billable_flag2 IN VARCHAR2 DEFAULT NULL,
757 x_error_message_name OUT NOCOPY VARCHAR2,
758 x_encoded_error_message OUT NOCOPY VARCHAR2) /* Bug 4997739 */
759 return BOOLEAN;
760 /* R12 Changes End */
761
762 /* Bug 4901129 - Start */
763 FUNCTION is_orphaned_src_sys_reversal( p_document_distribution_id IN PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID%TYPE
764 , p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE)
765 RETURN VARCHAR2;
766 /* Bug 4901129 - End */
767
768 FUNCTION RepCurrOrSecLedgerDiffCurr(p_org_id PA_EXPENDITURE_ITEMS_ALL.ORG_ID%TYPE) RETURN BOOLEAN; /* Bug 5235354 */
769
770 /* Bug 5381260 - Start */
771 FUNCTION IsPeriodEndAccrual(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE)
772 RETURN BOOLEAN;
773 /* Bug 5381260 - End */
774
775 /* Bug 5501250 - Start */
776 FUNCTION IsRelatedToPrepayApp(
777 p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE
778 ) RETURN BOOLEAN;
779 /* Bug 5501250 - End */
780
781 FUNCTION getprojburdenflag(p_project_id IN NUMBER) RETURN VARCHAR2;/*Bug# 5874347*/
782
783 END PA_ADJUSTMENTS;