DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on PA_MULTI_CURRENCY

Line 3856: pa_multi_currency_txn.get_currency_attributes (

3852: l_projfunc_cost_exchg_rate := EiRec.projfunc_cost_exchange_rate;
3853:
3854: ELSE
3855:
3856: pa_multi_currency_txn.get_currency_attributes (
3857: P_TASK_ID => X_dest_task_id,
3858: P_EI_DATE => Eirec.expenditure_item_date,
3859: P_CALLING_MODULE => 'TRANSFER',
3860: -- P_DENOM_CURR_CODE => EiRec.denom_currency_code,

Line 5594: pa_multi_currency.init ;

5590: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
5591: END IF;
5592:
5593: IF p_org_id IS NOT NULL THEN
5594: pa_multi_currency.init ;
5595: END IF;
5596:
5597:
5598: /* *** Opens a cursor for processing ********************************************************* */

Line 6433: pa_multi_currency.init;

6429: IF v_exp_org_id <> l_old_org_id THEN
6430: PA_MOAC_UTILS.SET_POLICY_CONTEXT('S',v_exp_org_id);
6431: l_old_org_id := v_exp_org_id;
6432: END IF;
6433: pa_multi_currency.init;
6434: END IF;
6435: /* R12 Changes End */
6436:
6437: v_allow_adjustments := 'N';

Line 7917: -- pa_multi_currency.init ;

7913: l_dummy1 NUMBER ;
7914: l_dummy2 NUMBER ;
7915: l_dummy3 NUMBER ;
7916:
7917: -- pa_multi_currency.init ;
7918:
7919: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER
7920: , X_user IN NUMBER
7921: , X_login IN NUMBER

Line 7950: pa_multi_currency.G_accounting_currency_code,

7946: , acct_rate_type = X_acct_rate_type
7947: , acct_rate_date = X_acct_rate_date
7948: , acct_exchange_rate = X_acct_exchange_rate
7949: , project_rate_type = DECODE(X_project_currency_code,
7950: pa_multi_currency.G_accounting_currency_code,
7951: X_acct_rate_type,project_rate_type )
7952: , project_rate_date = DECODE(X_project_currency_code,
7953: pa_multi_currency.G_accounting_currency_code,
7954: X_acct_rate_date, project_rate_date )

Line 7953: pa_multi_currency.G_accounting_currency_code,

7949: , project_rate_type = DECODE(X_project_currency_code,
7950: pa_multi_currency.G_accounting_currency_code,
7951: X_acct_rate_type,project_rate_type )
7952: , project_rate_date = DECODE(X_project_currency_code,
7953: pa_multi_currency.G_accounting_currency_code,
7954: X_acct_rate_date, project_rate_date )
7955: , project_exchange_rate = DECODE(X_project_currency_code,
7956: pa_multi_currency.G_accounting_currency_code,
7957: X_acct_exchange_rate,project_exchange_rate )

Line 7956: pa_multi_currency.G_accounting_currency_code,

7952: , project_rate_date = DECODE(X_project_currency_code,
7953: pa_multi_currency.G_accounting_currency_code,
7954: X_acct_rate_date, project_rate_date )
7955: , project_exchange_rate = DECODE(X_project_currency_code,
7956: pa_multi_currency.G_accounting_currency_code,
7957: X_acct_exchange_rate,project_exchange_rate )
7958: , acct_raw_cost = NULL
7959: , acct_burdened_cost = NULL
7960: , project_raw_cost = DECODE(X_project_currency_code,

Line 7961: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )

7957: X_acct_exchange_rate,project_exchange_rate )
7958: , acct_raw_cost = NULL
7959: , acct_burdened_cost = NULL
7960: , project_raw_cost = DECODE(X_project_currency_code,
7961: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
7962: , project_burdened_cost = DECODE(X_project_currency_code,
7963: pa_multi_currency.G_accounting_currency_code, NULL,project_burdened_cost )
7964: , last_updated_by = X_user
7965: , last_update_date = sysdate

Line 7963: pa_multi_currency.G_accounting_currency_code, NULL,project_burdened_cost )

7959: , acct_burdened_cost = NULL
7960: , project_raw_cost = DECODE(X_project_currency_code,
7961: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
7962: , project_burdened_cost = DECODE(X_project_currency_code,
7963: pa_multi_currency.G_accounting_currency_code, NULL,project_burdened_cost )
7964: , last_updated_by = X_user
7965: , last_update_date = sysdate
7966: , last_update_login = X_login
7967: , projfunc_cost_rate_type = DECODE(p_projfunc_currency_code,

Line 7968: pa_multi_currency.G_accounting_currency_code,

7964: , last_updated_by = X_user
7965: , last_update_date = sysdate
7966: , last_update_login = X_login
7967: , projfunc_cost_rate_type = DECODE(p_projfunc_currency_code,
7968: pa_multi_currency.G_accounting_currency_code,
7969: X_acct_rate_type,projfunc_cost_rate_type )
7970: , projfunc_cost_rate_date = DECODE(p_projfunc_currency_code,
7971: pa_multi_currency.G_accounting_currency_code,
7972: X_acct_rate_date, projfunc_cost_rate_date )

Line 7971: pa_multi_currency.G_accounting_currency_code,

7967: , projfunc_cost_rate_type = DECODE(p_projfunc_currency_code,
7968: pa_multi_currency.G_accounting_currency_code,
7969: X_acct_rate_type,projfunc_cost_rate_type )
7970: , projfunc_cost_rate_date = DECODE(p_projfunc_currency_code,
7971: pa_multi_currency.G_accounting_currency_code,
7972: X_acct_rate_date, projfunc_cost_rate_date )
7973: , projfunc_cost_exchange_rate = DECODE(p_projfunc_currency_code,
7974: pa_multi_currency.G_accounting_currency_code,
7975: X_acct_exchange_rate,projfunc_cost_exchange_rate )

Line 7974: pa_multi_currency.G_accounting_currency_code,

7970: , projfunc_cost_rate_date = DECODE(p_projfunc_currency_code,
7971: pa_multi_currency.G_accounting_currency_code,
7972: X_acct_rate_date, projfunc_cost_rate_date )
7973: , projfunc_cost_exchange_rate = DECODE(p_projfunc_currency_code,
7974: pa_multi_currency.G_accounting_currency_code,
7975: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7976: , raw_cost = DECODE(p_projfunc_currency_code,
7977: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7978: , burden_cost = DECODE(p_projfunc_currency_code,

Line 7977: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )

7973: , projfunc_cost_exchange_rate = DECODE(p_projfunc_currency_code,
7974: pa_multi_currency.G_accounting_currency_code,
7975: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7976: , raw_cost = DECODE(p_projfunc_currency_code,
7977: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7978: , burden_cost = DECODE(p_projfunc_currency_code,
7979: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
7980:
7981: WHERE

Line 7979: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )

7975: X_acct_exchange_rate,projfunc_cost_exchange_rate )
7976: , raw_cost = DECODE(p_projfunc_currency_code,
7977: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
7978: , burden_cost = DECODE(p_projfunc_currency_code,
7979: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
7980:
7981: WHERE
7982: expenditure_item_id = eachRec.expenditure_item_id;
7983:

Line 8023: pa_multi_currency.init ;

8019: IF P_DEBUG_MODE THEN
8020: print_message('get_denom_curr_code: ' || 'DenomCurrCodeTab(i)['||DenomCurrCodeTab(i)||']ProjCurrCodeTab(i)['||ProjCurrCodeTab(i)||
8021: ']ProjfuncCurrCodeTab(i)['||ProjFuncCurrCodeTab(i) || ']' );
8022: END IF;
8023: pa_multi_currency.init ;
8024: IF X_adjust_level = 'S' THEN
8025:
8026: IF P_DEBUG_MODE THEN
8027: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');

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

8023: pa_multi_currency.init ;
8024: IF X_adjust_level = 'S' THEN
8025:
8026: IF P_DEBUG_MODE THEN
8027: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');
8028: END IF;
8029: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8030: , pa_multi_currency.G_accounting_currency_code
8031: , l_acct_rate_date

Line 8029: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)

8025:
8026: IF P_DEBUG_MODE THEN
8027: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');
8028: END IF;
8029: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8030: , pa_multi_currency.G_accounting_currency_code
8031: , l_acct_rate_date
8032: , l_acct_rate_type
8033: , null

Line 8030: , pa_multi_currency.G_accounting_currency_code

8026: IF P_DEBUG_MODE THEN
8027: print_message('get_denom_curr_code: ' || 'calling pa_multi currency api');
8028: END IF;
8029: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8030: , pa_multi_currency.G_accounting_currency_code
8031: , l_acct_rate_date
8032: , l_acct_rate_type
8033: , null
8034: , 'Y'

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

8040: , l_status ) ;
8041:
8042: IF P_DEBUG_MODE THEN
8043: print_message('get_denom_curr_code: ' || 'l_acct_rate_date['||l_acct_rate_date||']l_acct_rate_type['||l_acct_rate_type
8044: ||']G_accounting_currency_code['||pa_multi_currency.G_accounting_currency_code
8045: ||']l_acct_exchange_rate['||l_acct_exchange_rate||']' );
8046: END IF;
8047: END IF ;
8048:

Line 8077: pa_multi_currency.G_accounting_currency_code,

8073: , acct_rate_type = X_acct_rate_type
8074: , acct_rate_date = X_acct_rate_date
8075: , acct_exchange_rate = l_acct_exchange_rate
8076: , project_rate_type = DECODE(ProjCurrCodeTab(i),
8077: pa_multi_currency.G_accounting_currency_code,
8078: X_acct_rate_type, project_rate_type )
8079: , project_rate_date = DECODE(ProjCurrCodeTab(i),
8080: pa_multi_currency.G_accounting_currency_code,
8081: X_acct_rate_date, project_rate_date )

Line 8080: pa_multi_currency.G_accounting_currency_code,

8076: , project_rate_type = DECODE(ProjCurrCodeTab(i),
8077: pa_multi_currency.G_accounting_currency_code,
8078: X_acct_rate_type, project_rate_type )
8079: , project_rate_date = DECODE(ProjCurrCodeTab(i),
8080: pa_multi_currency.G_accounting_currency_code,
8081: X_acct_rate_date, project_rate_date )
8082: , project_exchange_rate = DECODE(ProjCurrCodeTab(i),
8083: pa_multi_currency.G_accounting_currency_code,
8084: X_acct_exchange_rate , project_exchange_rate )

Line 8083: pa_multi_currency.G_accounting_currency_code,

8079: , project_rate_date = DECODE(ProjCurrCodeTab(i),
8080: pa_multi_currency.G_accounting_currency_code,
8081: X_acct_rate_date, project_rate_date )
8082: , project_exchange_rate = DECODE(ProjCurrCodeTab(i),
8083: pa_multi_currency.G_accounting_currency_code,
8084: X_acct_exchange_rate , project_exchange_rate )
8085: , acct_raw_cost = NULL
8086: , acct_burdened_cost = NULL
8087: , project_raw_cost = DECODE(ProjCurrCodeTab(i),

Line 8088: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )

8084: X_acct_exchange_rate , project_exchange_rate )
8085: , acct_raw_cost = NULL
8086: , acct_burdened_cost = NULL
8087: , project_raw_cost = DECODE(ProjCurrCodeTab(i),
8088: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
8089: , project_burdened_cost = DECODE(ProjCurrCodeTab(i),
8090: pa_multi_currency.G_accounting_currency_code, NULL, project_burdened_cost )
8091: , ei.last_update_date = sysdate
8092: , ei.last_updated_by = X_user

Line 8090: pa_multi_currency.G_accounting_currency_code, NULL, project_burdened_cost )

8086: , acct_burdened_cost = NULL
8087: , project_raw_cost = DECODE(ProjCurrCodeTab(i),
8088: pa_multi_currency.G_accounting_currency_code, NULL, project_raw_cost )
8089: , project_burdened_cost = DECODE(ProjCurrCodeTab(i),
8090: pa_multi_currency.G_accounting_currency_code, NULL, project_burdened_cost )
8091: , ei.last_update_date = sysdate
8092: , ei.last_updated_by = X_user
8093: , ei.last_update_login = X_login
8094: , projfunc_cost_rate_type = DECODE(ProjFuncCurrCodeTab(i),

Line 8095: pa_multi_currency.G_accounting_currency_code,

8091: , ei.last_update_date = sysdate
8092: , ei.last_updated_by = X_user
8093: , ei.last_update_login = X_login
8094: , projfunc_cost_rate_type = DECODE(ProjFuncCurrCodeTab(i),
8095: pa_multi_currency.G_accounting_currency_code,
8096: X_acct_rate_type,projfunc_cost_rate_type )
8097: , projfunc_cost_rate_date = DECODE(ProjFuncCurrCodeTab(i),
8098: pa_multi_currency.G_accounting_currency_code,
8099: X_acct_rate_date, projfunc_cost_rate_date )

Line 8098: pa_multi_currency.G_accounting_currency_code,

8094: , projfunc_cost_rate_type = DECODE(ProjFuncCurrCodeTab(i),
8095: pa_multi_currency.G_accounting_currency_code,
8096: X_acct_rate_type,projfunc_cost_rate_type )
8097: , projfunc_cost_rate_date = DECODE(ProjFuncCurrCodeTab(i),
8098: pa_multi_currency.G_accounting_currency_code,
8099: X_acct_rate_date, projfunc_cost_rate_date )
8100: , projfunc_cost_exchange_rate = DECODE(ProjFuncCurrCodeTab(i),
8101: pa_multi_currency.G_accounting_currency_code,
8102: X_acct_exchange_rate,projfunc_cost_exchange_rate )

Line 8101: pa_multi_currency.G_accounting_currency_code,

8097: , projfunc_cost_rate_date = DECODE(ProjFuncCurrCodeTab(i),
8098: pa_multi_currency.G_accounting_currency_code,
8099: X_acct_rate_date, projfunc_cost_rate_date )
8100: , projfunc_cost_exchange_rate = DECODE(ProjFuncCurrCodeTab(i),
8101: pa_multi_currency.G_accounting_currency_code,
8102: X_acct_exchange_rate,projfunc_cost_exchange_rate )
8103: , raw_cost = DECODE(ProjFuncCurrCodeTab(i),
8104: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
8105: , burden_cost = DECODE(ProjFuncCurrCodeTab(i),

Line 8104: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )

8100: , projfunc_cost_exchange_rate = DECODE(ProjFuncCurrCodeTab(i),
8101: pa_multi_currency.G_accounting_currency_code,
8102: X_acct_exchange_rate,projfunc_cost_exchange_rate )
8103: , raw_cost = DECODE(ProjFuncCurrCodeTab(i),
8104: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
8105: , burden_cost = DECODE(ProjFuncCurrCodeTab(i),
8106: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
8107: WHERE
8108: ei.expenditure_item_id = ItemsIdTab(i);

Line 8106: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )

8102: X_acct_exchange_rate,projfunc_cost_exchange_rate )
8103: , raw_cost = DECODE(ProjFuncCurrCodeTab(i),
8104: pa_multi_currency.G_accounting_currency_code, NULL, raw_cost )
8105: , burden_cost = DECODE(ProjFuncCurrCodeTab(i),
8106: pa_multi_currency.G_accounting_currency_code, NULL,burden_cost )
8107: WHERE
8108: ei.expenditure_item_id = ItemsIdTab(i);
8109:
8110: item_count := item_count + 1;

Line 8214: pa_multi_currency.G_accounting_currency_code,

8210: , projfunc_cost_exchange_rate =X_projfunc_cost_exchg_rate
8211: , raw_cost = NULL
8212: , burden_cost = NULL
8213: , acct_rate_type = DECODE(X_projfunc_currency_code,
8214: pa_multi_currency.G_accounting_currency_code,
8215: X_projfunc_cost_rate_type, acct_rate_type )
8216: , acct_rate_date = DECODE(X_projfunc_currency_code,
8217: pa_multi_currency.G_accounting_currency_code,
8218: X_projfunc_cost_rate_date , acct_rate_date )

Line 8217: pa_multi_currency.G_accounting_currency_code,

8213: , acct_rate_type = DECODE(X_projfunc_currency_code,
8214: pa_multi_currency.G_accounting_currency_code,
8215: X_projfunc_cost_rate_type, acct_rate_type )
8216: , acct_rate_date = DECODE(X_projfunc_currency_code,
8217: pa_multi_currency.G_accounting_currency_code,
8218: X_projfunc_cost_rate_date , acct_rate_date )
8219: , acct_exchange_rate = DECODE(X_projfunc_currency_code,
8220: pa_multi_currency.G_accounting_currency_code,
8221: X_projfunc_cost_exchg_rate , acct_exchange_rate )

Line 8220: pa_multi_currency.G_accounting_currency_code,

8216: , acct_rate_date = DECODE(X_projfunc_currency_code,
8217: pa_multi_currency.G_accounting_currency_code,
8218: X_projfunc_cost_rate_date , acct_rate_date )
8219: , acct_exchange_rate = DECODE(X_projfunc_currency_code,
8220: pa_multi_currency.G_accounting_currency_code,
8221: X_projfunc_cost_exchg_rate , acct_exchange_rate )
8222: , acct_raw_cost = DECODE(X_projfunc_currency_code,
8223: pa_multi_currency.G_accounting_currency_code,
8224: NULL, acct_raw_cost )

Line 8223: pa_multi_currency.G_accounting_currency_code,

8219: , acct_exchange_rate = DECODE(X_projfunc_currency_code,
8220: pa_multi_currency.G_accounting_currency_code,
8221: X_projfunc_cost_exchg_rate , acct_exchange_rate )
8222: , acct_raw_cost = DECODE(X_projfunc_currency_code,
8223: pa_multi_currency.G_accounting_currency_code,
8224: NULL, acct_raw_cost )
8225: , acct_burdened_cost = DECODE(X_projfunc_currency_code,
8226: pa_multi_currency.G_accounting_currency_code,
8227: NULL,acct_burdened_cost )

Line 8226: pa_multi_currency.G_accounting_currency_code,

8222: , acct_raw_cost = DECODE(X_projfunc_currency_code,
8223: pa_multi_currency.G_accounting_currency_code,
8224: NULL, acct_raw_cost )
8225: , acct_burdened_cost = DECODE(X_projfunc_currency_code,
8226: pa_multi_currency.G_accounting_currency_code,
8227: NULL,acct_burdened_cost )
8228: /** added for project currency changes **/
8229: , project_rate_type = DECODE(x_projfunc_currency_code,project_currency_code,
8230: x_projfunc_cost_rate_type, project_rate_type )

Line 8281: pa_multi_currency.init ;

8277: ']p_ProjFuncCurrCodeTab(i)['||p_ProjFuncCurrCodeTab(i)||']l_projfunc_cost_rate_date['
8278: ||l_projfunc_cost_rate_date||']l_projfunc_cost_rate_type['||l_projfunc_cost_rate_type||']' );
8279: END IF;
8280:
8281: pa_multi_currency.init ;
8282: IF p_adjust_level = 'S' THEN
8283: IF P_DEBUG_MODE THEN
8284: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');
8285: END IF;

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

8280:
8281: pa_multi_currency.init ;
8282: IF p_adjust_level = 'S' THEN
8283: IF P_DEBUG_MODE THEN
8284: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');
8285: END IF;
8286: pa_multi_currency.convert_amount( p_DenomCurrCodeTab(i)
8287: ,p_ProjFuncCurrCodeTab(i)
8288: , l_projfunc_cost_rate_date

Line 8286: pa_multi_currency.convert_amount( p_DenomCurrCodeTab(i)

8282: IF p_adjust_level = 'S' THEN
8283: IF P_DEBUG_MODE THEN
8284: print_message('get_denom_curr_code: ' || 'calling pa_multi_currency api');
8285: END IF;
8286: pa_multi_currency.convert_amount( p_DenomCurrCodeTab(i)
8287: ,p_ProjFuncCurrCodeTab(i)
8288: , l_projfunc_cost_rate_date
8289: , l_projfunc_cost_rate_type
8290: , null

Line 8334: pa_multi_currency.G_accounting_currency_code,

8330: , projfunc_cost_exchange_rate = l_projfunc_cost_exchg_rate
8331: , raw_cost = NULL
8332: , burden_cost = NULL
8333: , acct_rate_type = DECODE(p_ProjFuncCurrCodeTab(i),
8334: pa_multi_currency.G_accounting_currency_code,
8335: p_projfunc_cost_rate_type, acct_rate_type )
8336: , acct_rate_date = DECODE(p_ProjFuncCurrCodeTab(i),
8337: pa_multi_currency.G_accounting_currency_code,
8338: p_projfunc_cost_rate_date , acct_rate_date )

Line 8337: pa_multi_currency.G_accounting_currency_code,

8333: , acct_rate_type = DECODE(p_ProjFuncCurrCodeTab(i),
8334: pa_multi_currency.G_accounting_currency_code,
8335: p_projfunc_cost_rate_type, acct_rate_type )
8336: , acct_rate_date = DECODE(p_ProjFuncCurrCodeTab(i),
8337: pa_multi_currency.G_accounting_currency_code,
8338: p_projfunc_cost_rate_date , acct_rate_date )
8339: , acct_exchange_rate = DECODE(p_ProjFuncCurrCodeTab(i),
8340: pa_multi_currency.G_accounting_currency_code,
8341: l_projfunc_cost_exchg_rate , acct_exchange_rate )

Line 8340: pa_multi_currency.G_accounting_currency_code,

8336: , acct_rate_date = DECODE(p_ProjFuncCurrCodeTab(i),
8337: pa_multi_currency.G_accounting_currency_code,
8338: p_projfunc_cost_rate_date , acct_rate_date )
8339: , acct_exchange_rate = DECODE(p_ProjFuncCurrCodeTab(i),
8340: pa_multi_currency.G_accounting_currency_code,
8341: l_projfunc_cost_exchg_rate , acct_exchange_rate )
8342: , acct_raw_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8343: pa_multi_currency.G_accounting_currency_code,
8344: NULL, acct_raw_cost )

Line 8343: pa_multi_currency.G_accounting_currency_code,

8339: , acct_exchange_rate = DECODE(p_ProjFuncCurrCodeTab(i),
8340: pa_multi_currency.G_accounting_currency_code,
8341: l_projfunc_cost_exchg_rate , acct_exchange_rate )
8342: , acct_raw_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8343: pa_multi_currency.G_accounting_currency_code,
8344: NULL, acct_raw_cost )
8345: , acct_burdened_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8346: pa_multi_currency.G_accounting_currency_code,
8347: NULL,acct_burdened_cost )

Line 8346: pa_multi_currency.G_accounting_currency_code,

8342: , acct_raw_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8343: pa_multi_currency.G_accounting_currency_code,
8344: NULL, acct_raw_cost )
8345: , acct_burdened_cost = DECODE(p_ProjFuncCurrCodeTab(i),
8346: pa_multi_currency.G_accounting_currency_code,
8347: NULL,acct_burdened_cost )
8348: /** added for project currency changes **/
8349: , project_rate_type = DECODE(p_ProjFuncCurrCodeTab(i), project_currency_code,
8350: p_projfunc_cost_rate_type, project_rate_type )

Line 8441: -- pa_multi_currency.init ;

8437: l_dummy1 NUMBER ;
8438: l_dummy2 NUMBER ;
8439: l_dummy3 NUMBER ;
8440:
8441: -- pa_multi_currency.init ;
8442:
8443: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER
8444: , X_user IN NUMBER
8445: , X_login IN NUMBER

Line 8473: pa_multi_currency.G_accounting_currency_code,

8469: , project_rate_type = X_project_rate_type
8470: , project_rate_date = X_project_rate_date
8471: , project_exchange_rate = X_project_exchange_rate
8472: , acct_rate_type = DECODE(X_project_currency_code,
8473: pa_multi_currency.G_accounting_currency_code,
8474: X_project_rate_type, acct_rate_type )
8475: , acct_rate_date = DECODE(X_project_currency_code,
8476: pa_multi_currency.G_accounting_currency_code,
8477: X_project_rate_date, acct_rate_date )

Line 8476: pa_multi_currency.G_accounting_currency_code,

8472: , acct_rate_type = DECODE(X_project_currency_code,
8473: pa_multi_currency.G_accounting_currency_code,
8474: X_project_rate_type, acct_rate_type )
8475: , acct_rate_date = DECODE(X_project_currency_code,
8476: pa_multi_currency.G_accounting_currency_code,
8477: X_project_rate_date, acct_rate_date )
8478: , acct_exchange_rate = DECODE(X_project_currency_code,
8479: pa_multi_currency.G_accounting_currency_code,
8480: X_project_exchange_rate , acct_exchange_rate )

Line 8479: pa_multi_currency.G_accounting_currency_code,

8475: , acct_rate_date = DECODE(X_project_currency_code,
8476: pa_multi_currency.G_accounting_currency_code,
8477: X_project_rate_date, acct_rate_date )
8478: , acct_exchange_rate = DECODE(X_project_currency_code,
8479: pa_multi_currency.G_accounting_currency_code,
8480: X_project_exchange_rate , acct_exchange_rate )
8481: , project_raw_cost = NULL
8482: , project_burdened_cost = NULL
8483: , acct_raw_cost = DECODE(X_project_currency_code,

Line 8484: pa_multi_currency.G_accounting_currency_code,

8480: X_project_exchange_rate , acct_exchange_rate )
8481: , project_raw_cost = NULL
8482: , project_burdened_cost = NULL
8483: , acct_raw_cost = DECODE(X_project_currency_code,
8484: pa_multi_currency.G_accounting_currency_code,
8485: NULL, acct_raw_cost )
8486: , acct_burdened_cost = DECODE(X_project_currency_code,
8487: pa_multi_currency.G_accounting_currency_code,
8488: NULL,acct_burdened_cost )

Line 8487: pa_multi_currency.G_accounting_currency_code,

8483: , acct_raw_cost = DECODE(X_project_currency_code,
8484: pa_multi_currency.G_accounting_currency_code,
8485: NULL, acct_raw_cost )
8486: , acct_burdened_cost = DECODE(X_project_currency_code,
8487: pa_multi_currency.G_accounting_currency_code,
8488: NULL,acct_burdened_cost )
8489: , last_updated_by = X_user
8490: , last_update_date = sysdate
8491: , last_update_login = X_login

Line 8525: pa_multi_currency.init ;

8521:
8522: BEGIN
8523: FOR i IN 1..rows LOOP
8524:
8525: pa_multi_currency.init ;
8526: IF X_adjust_level = 'S' THEN
8527: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8528: ,ProjCurrCodeTab(i)
8529: , l_project_rate_date

Line 8527: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)

8523: FOR i IN 1..rows LOOP
8524:
8525: pa_multi_currency.init ;
8526: IF X_adjust_level = 'S' THEN
8527: pa_multi_currency.convert_amount( DenomCurrCodeTab(i)
8528: ,ProjCurrCodeTab(i)
8529: , l_project_rate_date
8530: , l_project_rate_type
8531: , null

Line 8568: pa_multi_currency.G_accounting_currency_code,

8564: , project_rate_type = X_project_rate_type
8565: , project_rate_date = X_project_rate_date
8566: , project_exchange_rate = l_project_exchange_rate
8567: , acct_rate_type = DECODE(ProjCurrCodeTab(i),
8568: pa_multi_currency.G_accounting_currency_code,
8569: X_project_rate_type, acct_rate_type )
8570: , acct_rate_date = DECODE(ProjCurrCodeTab(i),
8571: pa_multi_currency.G_accounting_currency_code,
8572: X_project_rate_date , acct_rate_date )

Line 8571: pa_multi_currency.G_accounting_currency_code,

8567: , acct_rate_type = DECODE(ProjCurrCodeTab(i),
8568: pa_multi_currency.G_accounting_currency_code,
8569: X_project_rate_type, acct_rate_type )
8570: , acct_rate_date = DECODE(ProjCurrCodeTab(i),
8571: pa_multi_currency.G_accounting_currency_code,
8572: X_project_rate_date , acct_rate_date )
8573: , acct_exchange_rate = DECODE(ProjCurrCodeTab(i),
8574: pa_multi_currency.G_accounting_currency_code,
8575: X_project_exchange_rate , acct_exchange_rate )

Line 8574: pa_multi_currency.G_accounting_currency_code,

8570: , acct_rate_date = DECODE(ProjCurrCodeTab(i),
8571: pa_multi_currency.G_accounting_currency_code,
8572: X_project_rate_date , acct_rate_date )
8573: , acct_exchange_rate = DECODE(ProjCurrCodeTab(i),
8574: pa_multi_currency.G_accounting_currency_code,
8575: X_project_exchange_rate , acct_exchange_rate )
8576: , project_raw_cost = NULL
8577: , project_burdened_cost = NULL
8578: , acct_raw_cost = DECODE(ProjCurrCodeTab(i),

Line 8579: pa_multi_currency.G_accounting_currency_code,

8575: X_project_exchange_rate , acct_exchange_rate )
8576: , project_raw_cost = NULL
8577: , project_burdened_cost = NULL
8578: , acct_raw_cost = DECODE(ProjCurrCodeTab(i),
8579: pa_multi_currency.G_accounting_currency_code,
8580: NULL, acct_raw_cost )
8581: , acct_burdened_cost = DECODE(ProjCurrCodeTab(i),
8582: pa_multi_currency.G_accounting_currency_code,
8583: NULL,acct_burdened_cost )

Line 8582: pa_multi_currency.G_accounting_currency_code,

8578: , acct_raw_cost = DECODE(ProjCurrCodeTab(i),
8579: pa_multi_currency.G_accounting_currency_code,
8580: NULL, acct_raw_cost )
8581: , acct_burdened_cost = DECODE(ProjCurrCodeTab(i),
8582: pa_multi_currency.G_accounting_currency_code,
8583: NULL,acct_burdened_cost )
8584: , ei.last_update_date = sysdate
8585: , ei.last_updated_by = X_user
8586: , ei.last_update_login = X_login

Line 9277: pa_multi_currency.init ;

9273:
9274:
9275: BEGIN
9276: FOR i IN 1..rows LOOP
9277: pa_multi_currency.init ;
9278: IF X_adjust_level = 'S' THEN
9279: l_cc_code_old := CrossChargeCodeTab(i);
9280:
9281: if l_cc_code_old = 'B' then

Line 9292: pa_multi_currency.convert_amount( DenomTpCurrCodeTab(i)

9288: IF P_DEBUG_MODE THEN
9289: print_message('get_denom_curr_code: ' || 'X rate is['||to_char(X_acct_tp_exchange_rate)||']l rate ['||to_char(l_acct_exchange_rate)||']' );
9290: END IF;
9291:
9292: pa_multi_currency.convert_amount( DenomTpCurrCodeTab(i)
9293: , pa_multi_currency.G_accounting_currency_code
9294: , l_acct_rate_date
9295: , l_acct_rate_type
9296: , null

Line 9293: , pa_multi_currency.G_accounting_currency_code

9289: print_message('get_denom_curr_code: ' || 'X rate is['||to_char(X_acct_tp_exchange_rate)||']l rate ['||to_char(l_acct_exchange_rate)||']' );
9290: END IF;
9291:
9292: pa_multi_currency.convert_amount( DenomTpCurrCodeTab(i)
9293: , pa_multi_currency.G_accounting_currency_code
9294: , l_acct_rate_date
9295: , l_acct_rate_type
9296: , null
9297: , 'Y'