DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on PA_UTILS

Line 7: ExpItemsIdTab pa_utils.IdTabTyp ;

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:

Line 12: ExpAdjItemTab 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;

Line 99: PROCEDURE RecalcRev(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 100: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 107: PROCEDURE RecalcCostRev(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 108: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 116: PROCEDURE RecalcRawCost(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 117: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 125: PROCEDURE RecalcIndCost(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 126: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 133: PROCEDURE RecalcCapCost(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 134: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 151: PROCEDURE Hold(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 152: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 161: PROCEDURE Reclass(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 162: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 202: PROCEDURE Transfer(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 424: ItemsIdTab IN pa_utils.IdTabTyp

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

Line 425: , AdjustsIdTab IN pa_utils.IdTabTyp

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

Line 440: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 441: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 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

Line 455: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp

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

Line 484: PROCEDURE ChangeFuncAttributes(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 492: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 493: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 498: , ProjfuncCurrCodeTab 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

Line 501: PROCEDURE ChangeProjAttributes(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 509: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 510: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

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 );

Line 518: PROCEDURE ReprocessCrossCharge(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 533: PROCEDURE MarkNoCCProcess (ItemsIdTab IN pa_utils.IdTabTyp

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

Line 544: PROCEDURE ChangeTPAttributes(ItemsIdTab IN pa_utils.IdTabTyp

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

Line 554: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 671: (ItemsIdTab IN pa_utils.IdTabTyp

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

Line 679: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp

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

Line 680: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

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 ) ;