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:
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
436: , X_project_exchange_rate IN NUMBER DEFAULT NULL
437: , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
438: , X_acct_rate_date IN DATE DEFAULT NULL
439: , X_acct_exchange_rate IN NUMBER DEFAULT NULL
440: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
441: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
442: , X_status OUT NOCOPY VARCHAR2
443: , X_num_processed OUT NOCOPY NUMBER
444: , X_num_rejected OUT NOCOPY NUMBER
437: , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
438: , X_acct_rate_date IN DATE DEFAULT NULL
439: , X_acct_exchange_rate IN NUMBER DEFAULT NULL
440: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
441: , ProjCurrCodeTab 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
441: , ProjCurrCodeTab 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
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
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
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
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
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
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
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
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 );
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
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
540: , rows IN NUMBER
541: , X_num_processed OUT NOCOPY NUMBER
542: , X_status 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
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
667: /** This api is newly added to convert / change the project functional currency attributes
668: * this is called from EI enquiry form for EI adjustments
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
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
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 ) ;