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