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,
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 ********************************************************* */
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';
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
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 )
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 )
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,
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
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,
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 )
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 )
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,
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
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:
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');
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
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
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'
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:
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 )
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 )
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),
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
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),
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 )
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 )
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),
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);
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;
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 )
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 )
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 )
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 )
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 )
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;
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
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
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 )
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 )
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 )
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 )
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 )
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
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 )
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 )
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,
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 )
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
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
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
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 )
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 )
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),
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 )
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
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
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
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'