DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on PA_MULTI_CURRENCY

Line 3762: pa_multi_currency_txn.get_currency_attributes (

3758: l_projfunc_cost_exchg_rate := EiRec.projfunc_cost_exchange_rate;
3759:
3760: ELSE
3761:
3762: pa_multi_currency_txn.get_currency_attributes (
3763: P_TASK_ID => X_dest_task_id,
3764: P_EI_DATE => Eirec.expenditure_item_date,
3765: P_CALLING_MODULE => 'TRANSFER',
3766: -- P_DENOM_CURR_CODE => EiRec.denom_currency_code,

Line 5469: pa_multi_currency.init ;

5465: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
5466: END IF;
5467:
5468: IF p_org_id IS NOT NULL THEN
5469: pa_multi_currency.init ;
5470: END IF;
5471:
5472:
5473: /* *** Opens a cursor for processing ********************************************************* */

Line 6269: pa_multi_currency.init;

6265: IF v_exp_org_id <> l_old_org_id THEN
6266: PA_MOAC_UTILS.SET_POLICY_CONTEXT('S',v_exp_org_id);
6267: l_old_org_id := v_exp_org_id;
6268: END IF;
6269: pa_multi_currency.init;
6270: END IF;
6271: /* R12 Changes End */
6272:
6273: v_allow_adjustments := 'N';

Line 7698: -- pa_multi_currency.init ;

7694: l_dummy1 NUMBER ;
7695: l_dummy2 NUMBER ;
7696: l_dummy3 NUMBER ;
7697:
7698: -- pa_multi_currency.init ;
7699:
7700: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER
7701: , X_user IN NUMBER
7702: , X_login IN NUMBER

Line 7730: pa_multi_currency.G_accounting_currency_code,

7726: , acct_rate_type = X_acct_rate_type
7727: , acct_rate_date = X_acct_rate_date
7728: , acct_exchange_rate = X_acct_exchange_rate
7729: , project_rate_type = DECODE(X_project_currency_code,
7730: pa_multi_currency.G_accounting_currency_code,
7731: X_acct_rate_type,project_rate_type )
7732: , project_rate_date = DECODE(X_project_currency_code,
7733: pa_multi_currency.G_accounting_currency_code,
7734: X_acct_rate_date, project_rate_date )

Line 7733: pa_multi_currency.G_accounting_currency_code,

7729: , project_rate_type = DECODE(X_project_currency_code,
7730: pa_multi_currency.G_accounting_currency_code,
7731: X_acct_rate_type,project_rate_type )
7732: , project_rate_date = DECODE(X_project_currency_code,
7733: pa_multi_currency.G_accounting_currency_code,
7734: X_acct_rate_date, project_rate_date )
7735: , project_exchange_rate = DECODE(X_project_currency_code,
7736: pa_multi_currency.G_accounting_currency_code,
7737: X_acct_exchange_rate,project_exchange_rate )

Line 7736: pa_multi_currency.G_accounting_currency_code,

7732: , project_rate_date = DECODE(X_project_currency_code,
7733: pa_multi_currency.G_accounting_currency_code,
7734: X_acct_rate_date, project_rate_date )
7735: , project_exchange_rate = DECODE(X_project_currency_code,
7736: pa_multi_currency.G_accounting_currency_code,
7737: X_acct_exchange_rate,project_exchange_rate )
7738: , acct_raw_cost = NULL
7739: , acct_burdened_cost = NULL
7740: , project_raw_cost = DECODE(X_project_currency_code,

Line 7741: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )

7737: X_acct_exchange_rate,project_exchange_rate )
7738: , acct_raw_cost = NULL
7739: , acct_burdened_cost = NULL
7740: , project_raw_cost = DECODE(X_project_currency_code,
7741: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
7742: , project_burdened_cost = DECODE(X_project_currency_code,
7743: pa_multi_currency.G_accounting_currency_code, NULL,project_burdened_cost )
7744: , last_updated_by = X_user
7745: , last_update_date = sysdate

Line 7743: pa_multi_currency.G_accounting_currency_code, NULL,project_burdened_cost )

7739: , acct_burdened_cost = NULL
7740: , project_raw_cost = DECODE(X_project_currency_code,
7741: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
7742: , project_burdened_cost = DECODE(X_project_currency_code,
7743: pa_multi_currency.G_accounting_currency_code, NULL,project_burdened_cost )
7744: , last_updated_by = X_user
7745: , last_update_date = sysdate
7746: , last_update_login = X_login
7747: , projfunc_cost_rate_type = DECODE(p_projfunc_currency_code,

Line 7748: pa_multi_currency.G_accounting_currency_code,

7744: , last_updated_by = X_user
7745: , last_update_date = sysdate
7746: , last_update_login = X_login
7747: , projfunc_cost_rate_type = DECODE(p_projfunc_currency_code,
7748: pa_multi_currency.G_accounting_currency_code,
7749: X_acct_rate_type,projfunc_cost_rate_type )
7750: , projfunc_cost_rate_date = DECODE(p_projfunc_currency_code,
7751: pa_multi_currency.G_accounting_currency_code,
7752: X_acct_rate_date, projfunc_cost_rate_date )

Line 7751: pa_multi_currency.G_accounting_currency_code,

7747: , projfunc_cost_rate_type = DECODE(p_projfunc_currency_code,
7748: pa_multi_currency.G_accounting_currency_code,
7749: X_acct_rate_type,projfunc_cost_rate_type )
7750: , projfunc_cost_rate_date = DECODE(p_projfunc_currency_code,
7751: pa_multi_currency.G_accounting_currency_code,
7752: X_acct_rate_date, projfunc_cost_rate_date )
7753: , projfunc_cost_exchange_rate = DECODE(p_projfunc_currency_code,
7754: pa_multi_currency.G_accounting_currency_code,
7755: X_acct_exchange_rate,projfunc_cost_exchange_rate )

Line 7754: pa_multi_currency.G_accounting_currency_code,

7750: , projfunc_cost_rate_date = DECODE(p_projfunc_currency_code,
7751: pa_multi_currency.G_accounting_currency_code,
7752: X_acct_rate_date, projfunc_cost_rate_date )
7753: , projfunc_cost_exchange_rate = DECODE(p_projfunc_currency_code,
7754: pa_multi_currency.G_accounting_currency_code,
7755: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7756: , raw_cost = DECODE(p_projfunc_currency_code,
7757: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7758: , burden_cost = DECODE(p_projfunc_currency_code,

Line 7757: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )

7753: , projfunc_cost_exchange_rate = DECODE(p_projfunc_currency_code,
7754: pa_multi_currency.G_accounting_currency_code,
7755: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7756: , raw_cost = DECODE(p_projfunc_currency_code,
7757: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7758: , burden_cost = DECODE(p_projfunc_currency_code,
7759: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
7760:
7761: WHERE

Line 7759: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )

7755: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7756: , raw_cost = DECODE(p_projfunc_currency_code,
7757: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7758: , burden_cost = DECODE(p_projfunc_currency_code,
7759: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
7760:
7761: WHERE
7762: expenditure_item_id = eachRec.expenditure_item_id;
7763:

Line 7803: pa_multi_currency.init ;

7799: IF P_DEBUG_MODE THEN
7800: print_message('get_denom_curr_code: ' || 'DenomCurrCodeTab(i)['||DenomCurrCodeTab(i)||']ProjCurrCodeTab(i)['||ProjCurrCodeTab(i)||
7801: ']ProjfuncCurrCodeTab(i)['||ProjFuncCurrCodeTab(i) || ']' );
7802: END IF;
7803: pa_multi_currency.init ;
7804: IF X_adjust_level = 'S' THEN
7805:
7806: IF P_DEBUG_MODE THEN
7807: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');

Line 7807: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');

7803: pa_multi_currency.init ;
7804: IF X_adjust_level = 'S' THEN
7805:
7806: IF P_DEBUG_MODE THEN
7807: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');
7808: END IF;
7809: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
7810: , pa_multi_currency.G_accounting_currency_code
7811: , l_acct_rate_date

Line 7809: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)

7805:
7806: IF P_DEBUG_MODE THEN
7807: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');
7808: END IF;
7809: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
7810: , pa_multi_currency.G_accounting_currency_code
7811: , l_acct_rate_date
7812: , l_acct_rate_type
7813: , null

Line 7810: , pa_multi_currency.G_accounting_currency_code

7806: IF P_DEBUG_MODE THEN
7807: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');
7808: END IF;
7809: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
7810: , pa_multi_currency.G_accounting_currency_code
7811: , l_acct_rate_date
7812: , l_acct_rate_type
7813: , null
7814: , 'Y'

Line 7824: ||']G_accounting_currency_code['||pa_multi_currency.G_accounting_currency_code

7820: , l_status ) ;
7821:
7822: IF P_DEBUG_MODE THEN
7823: print_message('get_denom_curr_code: ' || 'l_acct_rate_date['||l_acct_rate_date||']l_acct_rate_type['||l_acct_rate_type
7824: ||']G_accounting_currency_code['||pa_multi_currency.G_accounting_currency_code
7825: ||']l_acct_exchange_rate['||l_acct_exchange_rate||']' );
7826: END IF;
7827: END IF ;
7828:

Line 7856: pa_multi_currency.G_accounting_currency_code,

7852: , acct_rate_type = X_acct_rate_type
7853: , acct_rate_date = X_acct_rate_date
7854: , acct_exchange_rate = l_acct_exchange_rate
7855: , project_rate_type = DECODE(ProjCurrCodeTab(i),
7856: pa_multi_currency.G_accounting_currency_code,
7857: X_acct_rate_type, project_rate_type )
7858: , project_rate_date = DECODE(ProjCurrCodeTab(i),
7859: pa_multi_currency.G_accounting_currency_code,
7860: X_acct_rate_date, project_rate_date )

Line 7859: pa_multi_currency.G_accounting_currency_code,

7855: , project_rate_type = DECODE(ProjCurrCodeTab(i),
7856: pa_multi_currency.G_accounting_currency_code,
7857: X_acct_rate_type, project_rate_type )
7858: , project_rate_date = DECODE(ProjCurrCodeTab(i),
7859: pa_multi_currency.G_accounting_currency_code,
7860: X_acct_rate_date, project_rate_date )
7861: , project_exchange_rate = DECODE(ProjCurrCodeTab(i),
7862: pa_multi_currency.G_accounting_currency_code,
7863: X_acct_exchange_rate , project_exchange_rate )

Line 7862: pa_multi_currency.G_accounting_currency_code,

7858: , project_rate_date = DECODE(ProjCurrCodeTab(i),
7859: pa_multi_currency.G_accounting_currency_code,
7860: X_acct_rate_date, project_rate_date )
7861: , project_exchange_rate = DECODE(ProjCurrCodeTab(i),
7862: pa_multi_currency.G_accounting_currency_code,
7863: X_acct_exchange_rate , project_exchange_rate )
7864: , acct_raw_cost = NULL
7865: , acct_burdened_cost = NULL
7866: , project_raw_cost = DECODE(ProjCurrCodeTab(i),

Line 7867: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )

7863: X_acct_exchange_rate , project_exchange_rate )
7864: , acct_raw_cost = NULL
7865: , acct_burdened_cost = NULL
7866: , project_raw_cost = DECODE(ProjCurrCodeTab(i),
7867: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
7868: , project_burdened_cost = DECODE(ProjCurrCodeTab(i),
7869: pa_multi_currency.G_accounting_currency_code, NULL, project_burdened_cost )
7870: , ei.last_update_date = sysdate
7871: , ei.last_updated_by = X_user

Line 7869: pa_multi_currency.G_accounting_currency_code, NULL, project_burdened_cost )

7865: , acct_burdened_cost = NULL
7866: , project_raw_cost = DECODE(ProjCurrCodeTab(i),
7867: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
7868: , project_burdened_cost = DECODE(ProjCurrCodeTab(i),
7869: pa_multi_currency.G_accounting_currency_code, NULL, project_burdened_cost )
7870: , ei.last_update_date = sysdate
7871: , ei.last_updated_by = X_user
7872: , ei.last_update_login = X_login
7873: , projfunc_cost_rate_type = DECODE(ProjFuncCurrCodeTab(i),

Line 7874: pa_multi_currency.G_accounting_currency_code,

7870: , ei.last_update_date = sysdate
7871: , ei.last_updated_by = X_user
7872: , ei.last_update_login = X_login
7873: , projfunc_cost_rate_type = DECODE(ProjFuncCurrCodeTab(i),
7874: pa_multi_currency.G_accounting_currency_code,
7875: X_acct_rate_type,projfunc_cost_rate_type )
7876: , projfunc_cost_rate_date = DECODE(ProjFuncCurrCodeTab(i),
7877: pa_multi_currency.G_accounting_currency_code,
7878: X_acct_rate_date, projfunc_cost_rate_date )

Line 7877: pa_multi_currency.G_accounting_currency_code,

7873: , projfunc_cost_rate_type = DECODE(ProjFuncCurrCodeTab(i),
7874: pa_multi_currency.G_accounting_currency_code,
7875: X_acct_rate_type,projfunc_cost_rate_type )
7876: , projfunc_cost_rate_date = DECODE(ProjFuncCurrCodeTab(i),
7877: pa_multi_currency.G_accounting_currency_code,
7878: X_acct_rate_date, projfunc_cost_rate_date )
7879: , projfunc_cost_exchange_rate = DECODE(ProjFuncCurrCodeTab(i),
7880: pa_multi_currency.G_accounting_currency_code,
7881: X_acct_exchange_rate,projfunc_cost_exchange_rate )

Line 7880: pa_multi_currency.G_accounting_currency_code,

7876: , projfunc_cost_rate_date = DECODE(ProjFuncCurrCodeTab(i),
7877: pa_multi_currency.G_accounting_currency_code,
7878: X_acct_rate_date, projfunc_cost_rate_date )
7879: , projfunc_cost_exchange_rate = DECODE(ProjFuncCurrCodeTab(i),
7880: pa_multi_currency.G_accounting_currency_code,
7881: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7882: , raw_cost = DECODE(ProjFuncCurrCodeTab(i),
7883: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7884: , burden_cost = DECODE(ProjFuncCurrCodeTab(i),

Line 7883: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )

7879: , projfunc_cost_exchange_rate = DECODE(ProjFuncCurrCodeTab(i),
7880: pa_multi_currency.G_accounting_currency_code,
7881: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7882: , raw_cost = DECODE(ProjFuncCurrCodeTab(i),
7883: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7884: , burden_cost = DECODE(ProjFuncCurrCodeTab(i),
7885: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
7886: WHERE
7887: ei.expenditure_item_id = ItemsIdTab(i);

Line 7885: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )

7881: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7882: , raw_cost = DECODE(ProjFuncCurrCodeTab(i),
7883: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7884: , burden_cost = DECODE(ProjFuncCurrCodeTab(i),
7885: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
7886: WHERE
7887: ei.expenditure_item_id = ItemsIdTab(i);
7888:
7889: item_count := item_count + 1;

Line 7992: pa_multi_currency.G_accounting_currency_code,

7988: , projfunc_cost_exchange_rate =X_projfunc_cost_exchg_rate
7989: , raw_cost = NULL
7990: , burden_cost = NULL
7991: , acct_rate_type = DECODE(X_projfunc_currency_code,
7992: pa_multi_currency.G_accounting_currency_code,
7993: X_projfunc_cost_rate_type, acct_rate_type )
7994: , acct_rate_date = DECODE(X_projfunc_currency_code,
7995: pa_multi_currency.G_accounting_currency_code,
7996: X_projfunc_cost_rate_date , acct_rate_date )

Line 7995: pa_multi_currency.G_accounting_currency_code,

7991: , acct_rate_type = DECODE(X_projfunc_currency_code,
7992: pa_multi_currency.G_accounting_currency_code,
7993: X_projfunc_cost_rate_type, acct_rate_type )
7994: , acct_rate_date = DECODE(X_projfunc_currency_code,
7995: pa_multi_currency.G_accounting_currency_code,
7996: X_projfunc_cost_rate_date , acct_rate_date )
7997: , acct_exchange_rate = DECODE(X_projfunc_currency_code,
7998: pa_multi_currency.G_accounting_currency_code,
7999: X_projfunc_cost_exchg_rate , acct_exchange_rate )

Line 7998: pa_multi_currency.G_accounting_currency_code,

7994: , acct_rate_date = DECODE(X_projfunc_currency_code,
7995: pa_multi_currency.G_accounting_currency_code,
7996: X_projfunc_cost_rate_date , acct_rate_date )
7997: , acct_exchange_rate = DECODE(X_projfunc_currency_code,
7998: pa_multi_currency.G_accounting_currency_code,
7999: X_projfunc_cost_exchg_rate , acct_exchange_rate )
8000: , acct_raw_cost = DECODE(X_projfunc_currency_code,
8001: pa_multi_currency.G_accounting_currency_code,
8002: NULL, acct_raw_cost )

Line 8001: pa_multi_currency.G_accounting_currency_code,

7997: , acct_exchange_rate = DECODE(X_projfunc_currency_code,
7998: pa_multi_currency.G_accounting_currency_code,
7999: X_projfunc_cost_exchg_rate , acct_exchange_rate )
8000: , acct_raw_cost = DECODE(X_projfunc_currency_code,
8001: pa_multi_currency.G_accounting_currency_code,
8002: NULL, acct_raw_cost )
8003: , acct_burdened_cost = DECODE(X_projfunc_currency_code,
8004: pa_multi_currency.G_accounting_currency_code,
8005: NULL,acct_burdened_cost )

Line 8004: pa_multi_currency.G_accounting_currency_code,

8000: , acct_raw_cost = DECODE(X_projfunc_currency_code,
8001: pa_multi_currency.G_accounting_currency_code,
8002: NULL, acct_raw_cost )
8003: , acct_burdened_cost = DECODE(X_projfunc_currency_code,
8004: pa_multi_currency.G_accounting_currency_code,
8005: NULL,acct_burdened_cost )
8006: /** added for project currency changes **/
8007: , project_rate_type = DECODE(x_projfunc_currency_code,project_currency_code,
8008: x_projfunc_cost_rate_type, project_rate_type )

Line 8059: pa_multi_currency.init ;

8055: ']p_ProjFuncCurrCodeTab(i)['||p_ProjFuncCurrCodeTab(i)||']l_projfunc_cost_rate_date['
8056: ||l_projfunc_cost_rate_date||']l_projfunc_cost_rate_type['||l_projfunc_cost_rate_type||']' );
8057: END IF;
8058:
8059: pa_multi_currency.init ;
8060: IF p_adjust_level = 'S' THEN
8061: IF P_DEBUG_MODE THEN
8062: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');
8063: END IF;

Line 8062: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');

8058:
8059: pa_multi_currency.init ;
8060: IF p_adjust_level = 'S' THEN
8061: IF P_DEBUG_MODE THEN
8062: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');
8063: END IF;
8064: pa_multi_currency.convert_amount( p_DenomCurrCodeTab(i)
8065: ,p_ProjFuncCurrCodeTab(i)
8066: , l_projfunc_cost_rate_date

Line 8064: pa_multi_currency.convert_amount( p_DenomCurrCodeTab(i)

8060: IF p_adjust_level = 'S' THEN
8061: IF P_DEBUG_MODE THEN
8062: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');
8063: END IF;
8064: pa_multi_currency.convert_amount( p_DenomCurrCodeTab(i)
8065: ,p_ProjFuncCurrCodeTab(i)
8066: , l_projfunc_cost_rate_date
8067: , l_projfunc_cost_rate_type
8068: , null

Line 8111: pa_multi_currency.G_accounting_currency_code,

8107: , projfunc_cost_exchange_rate = l_projfunc_cost_exchg_rate
8108: , raw_cost = NULL
8109: , burden_cost = NULL
8110: , acct_rate_type = DECODE(p_ProjFuncCurrCodeTab(i),
8111: pa_multi_currency.G_accounting_currency_code,
8112: p_projfunc_cost_rate_type, acct_rate_type )
8113: , acct_rate_date = DECODE(p_ProjFuncCurrCodeTab(i),
8114: pa_multi_currency.G_accounting_currency_code,
8115: p_projfunc_cost_rate_date , acct_rate_date )

Line 8114: pa_multi_currency.G_accounting_currency_code,

8110: , acct_rate_type = DECODE(p_ProjFuncCurrCodeTab(i),
8111: pa_multi_currency.G_accounting_currency_code,
8112: p_projfunc_cost_rate_type, acct_rate_type )
8113: , acct_rate_date = DECODE(p_ProjFuncCurrCodeTab(i),
8114: pa_multi_currency.G_accounting_currency_code,
8115: p_projfunc_cost_rate_date , acct_rate_date )
8116: , acct_exchange_rate = DECODE(p_ProjFuncCurrCodeTab(i),
8117: pa_multi_currency.G_accounting_currency_code,
8118: l_projfunc_cost_exchg_rate , acct_exchange_rate )

Line 8117: pa_multi_currency.G_accounting_currency_code,

8113: , acct_rate_date = DECODE(p_ProjFuncCurrCodeTab(i),
8114: pa_multi_currency.G_accounting_currency_code,
8115: p_projfunc_cost_rate_date , acct_rate_date )
8116: , acct_exchange_rate = DECODE(p_ProjFuncCurrCodeTab(i),
8117: pa_multi_currency.G_accounting_currency_code,
8118: l_projfunc_cost_exchg_rate , acct_exchange_rate )
8119: , acct_raw_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8120: pa_multi_currency.G_accounting_currency_code,
8121: NULL, acct_raw_cost )

Line 8120: pa_multi_currency.G_accounting_currency_code,

8116: , acct_exchange_rate = DECODE(p_ProjFuncCurrCodeTab(i),
8117: pa_multi_currency.G_accounting_currency_code,
8118: l_projfunc_cost_exchg_rate , acct_exchange_rate )
8119: , acct_raw_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8120: pa_multi_currency.G_accounting_currency_code,
8121: NULL, acct_raw_cost )
8122: , acct_burdened_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8123: pa_multi_currency.G_accounting_currency_code,
8124: NULL,acct_burdened_cost )

Line 8123: pa_multi_currency.G_accounting_currency_code,

8119: , acct_raw_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8120: pa_multi_currency.G_accounting_currency_code,
8121: NULL, acct_raw_cost )
8122: , acct_burdened_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8123: pa_multi_currency.G_accounting_currency_code,
8124: NULL,acct_burdened_cost )
8125: /** added for project currency changes **/
8126: , project_rate_type = DECODE(p_ProjFuncCurrCodeTab(i), project_currency_code,
8127: p_projfunc_cost_rate_type, project_rate_type )

Line 8218: -- pa_multi_currency.init ;

8214: l_dummy1 NUMBER ;
8215: l_dummy2 NUMBER ;
8216: l_dummy3 NUMBER ;
8217:
8218: -- pa_multi_currency.init ;
8219:
8220: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER
8221: , X_user IN NUMBER
8222: , X_login IN NUMBER

Line 8249: pa_multi_currency.G_accounting_currency_code,

8245: , project_rate_type = X_project_rate_type
8246: , project_rate_date = X_project_rate_date
8247: , project_exchange_rate = X_project_exchange_rate
8248: , acct_rate_type = DECODE(X_project_currency_code,
8249: pa_multi_currency.G_accounting_currency_code,
8250: X_project_rate_type, acct_rate_type )
8251: , acct_rate_date = DECODE(X_project_currency_code,
8252: pa_multi_currency.G_accounting_currency_code,
8253: X_project_rate_date, acct_rate_date )

Line 8252: pa_multi_currency.G_accounting_currency_code,

8248: , acct_rate_type = DECODE(X_project_currency_code,
8249: pa_multi_currency.G_accounting_currency_code,
8250: X_project_rate_type, acct_rate_type )
8251: , acct_rate_date = DECODE(X_project_currency_code,
8252: pa_multi_currency.G_accounting_currency_code,
8253: X_project_rate_date, acct_rate_date )
8254: , acct_exchange_rate = DECODE(X_project_currency_code,
8255: pa_multi_currency.G_accounting_currency_code,
8256: X_project_exchange_rate , acct_exchange_rate )

Line 8255: pa_multi_currency.G_accounting_currency_code,

8251: , acct_rate_date = DECODE(X_project_currency_code,
8252: pa_multi_currency.G_accounting_currency_code,
8253: X_project_rate_date, acct_rate_date )
8254: , acct_exchange_rate = DECODE(X_project_currency_code,
8255: pa_multi_currency.G_accounting_currency_code,
8256: X_project_exchange_rate , acct_exchange_rate )
8257: , project_raw_cost = NULL
8258: , project_burdened_cost = NULL
8259: , acct_raw_cost = DECODE(X_project_currency_code,

Line 8260: pa_multi_currency.G_accounting_currency_code,

8256: X_project_exchange_rate , acct_exchange_rate )
8257: , project_raw_cost = NULL
8258: , project_burdened_cost = NULL
8259: , acct_raw_cost = DECODE(X_project_currency_code,
8260: pa_multi_currency.G_accounting_currency_code,
8261: NULL, acct_raw_cost )
8262: , acct_burdened_cost = DECODE(X_project_currency_code,
8263: pa_multi_currency.G_accounting_currency_code,
8264: NULL,acct_burdened_cost )

Line 8263: pa_multi_currency.G_accounting_currency_code,

8259: , acct_raw_cost = DECODE(X_project_currency_code,
8260: pa_multi_currency.G_accounting_currency_code,
8261: NULL, acct_raw_cost )
8262: , acct_burdened_cost = DECODE(X_project_currency_code,
8263: pa_multi_currency.G_accounting_currency_code,
8264: NULL,acct_burdened_cost )
8265: , last_updated_by = X_user
8266: , last_update_date = sysdate
8267: , last_update_login = X_login

Line 8301: pa_multi_currency.init ;

8297:
8298: BEGIN
8299: FOR i IN 1..rows LOOP
8300:
8301: pa_multi_currency.init ;
8302: IF X_adjust_level = 'S' THEN
8303: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8304: ,ProjCurrCodeTab(i)
8305: , l_project_rate_date

Line 8303: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)

8299: FOR i IN 1..rows LOOP
8300:
8301: pa_multi_currency.init ;
8302: IF X_adjust_level = 'S' THEN
8303: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8304: ,ProjCurrCodeTab(i)
8305: , l_project_rate_date
8306: , l_project_rate_type
8307: , null

Line 8343: pa_multi_currency.G_accounting_currency_code,

8339: , project_rate_type = X_project_rate_type
8340: , project_rate_date = X_project_rate_date
8341: , project_exchange_rate = l_project_exchange_rate
8342: , acct_rate_type = DECODE(ProjCurrCodeTab(i),
8343: pa_multi_currency.G_accounting_currency_code,
8344: X_project_rate_type, acct_rate_type )
8345: , acct_rate_date = DECODE(ProjCurrCodeTab(i),
8346: pa_multi_currency.G_accounting_currency_code,
8347: X_project_rate_date , acct_rate_date )

Line 8346: pa_multi_currency.G_accounting_currency_code,

8342: , acct_rate_type = DECODE(ProjCurrCodeTab(i),
8343: pa_multi_currency.G_accounting_currency_code,
8344: X_project_rate_type, acct_rate_type )
8345: , acct_rate_date = DECODE(ProjCurrCodeTab(i),
8346: pa_multi_currency.G_accounting_currency_code,
8347: X_project_rate_date , acct_rate_date )
8348: , acct_exchange_rate = DECODE(ProjCurrCodeTab(i),
8349: pa_multi_currency.G_accounting_currency_code,
8350: X_project_exchange_rate , acct_exchange_rate )

Line 8349: pa_multi_currency.G_accounting_currency_code,

8345: , acct_rate_date = DECODE(ProjCurrCodeTab(i),
8346: pa_multi_currency.G_accounting_currency_code,
8347: X_project_rate_date , acct_rate_date )
8348: , acct_exchange_rate = DECODE(ProjCurrCodeTab(i),
8349: pa_multi_currency.G_accounting_currency_code,
8350: X_project_exchange_rate , acct_exchange_rate )
8351: , project_raw_cost = NULL
8352: , project_burdened_cost = NULL
8353: , acct_raw_cost = DECODE(ProjCurrCodeTab(i),

Line 8354: pa_multi_currency.G_accounting_currency_code,

8350: X_project_exchange_rate , acct_exchange_rate )
8351: , project_raw_cost = NULL
8352: , project_burdened_cost = NULL
8353: , acct_raw_cost = DECODE(ProjCurrCodeTab(i),
8354: pa_multi_currency.G_accounting_currency_code,
8355: NULL, acct_raw_cost )
8356: , acct_burdened_cost = DECODE(ProjCurrCodeTab(i),
8357: pa_multi_currency.G_accounting_currency_code,
8358: NULL,acct_burdened_cost )

Line 8357: pa_multi_currency.G_accounting_currency_code,

8353: , acct_raw_cost = DECODE(ProjCurrCodeTab(i),
8354: pa_multi_currency.G_accounting_currency_code,
8355: NULL, acct_raw_cost )
8356: , acct_burdened_cost = DECODE(ProjCurrCodeTab(i),
8357: pa_multi_currency.G_accounting_currency_code,
8358: NULL,acct_burdened_cost )
8359: , ei.last_update_date = sysdate
8360: , ei.last_updated_by = X_user
8361: , ei.last_update_login = X_login

Line 8994: pa_multi_currency.init ;

8990:
8991:
8992: BEGIN
8993: FOR i IN 1..rows LOOP
8994: pa_multi_currency.init ;
8995: IF X_adjust_level = 'S' THEN
8996: l_cc_code_old := CrossChargeCodeTab(i);
8997:
8998: if l_cc_code_old = 'B' then

Line 9009: pa_multi_currency.convert_amount( DenomTpCurrCodeTab(i)

9005: IF P_DEBUG_MODE THEN
9006: print_message('get_denom_curr_code: ' || 'X rate is['||to_char(X_acct_tp_exchange_rate)||']l rate ['||to_char(l_acct_exchange_rate)||']' );
9007: END IF;
9008:
9009: pa_multi_currency.convert_amount( DenomTpCurrCodeTab(i)
9010: , pa_multi_currency.G_accounting_currency_code
9011: , l_acct_rate_date
9012: , l_acct_rate_type
9013: , null

Line 9010: , pa_multi_currency.G_accounting_currency_code

9006: print_message('get_denom_curr_code: ' || 'X rate is['||to_char(X_acct_tp_exchange_rate)||']l rate ['||to_char(l_acct_exchange_rate)||']' );
9007: END IF;
9008:
9009: pa_multi_currency.convert_amount( DenomTpCurrCodeTab(i)
9010: , pa_multi_currency.G_accounting_currency_code
9011: , l_acct_rate_date
9012: , l_acct_rate_type
9013: , null
9014: , 'Y'