DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on PA_CURRENCY

Line 458: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

454: sysdate,
455: FND_GLOBAL.LOGIN_ID,
456: -- Added below NVL clause as the base_amount stores correct amount in multi currency scenario
457: -- Bug 1980810 PA Rounding function added
458: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
459: aid.invoice_id,
460: nvl(aid.base_amount,aid.amount),
461: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N'))),
462: 1, pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

Line 467: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

463: aid.invoice_id,
464: nvl(aid.base_amount,aid.amount),
465: 'N', 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) ,
466: 0)), -- Bug 2386531
467: pa_currency.round_currency_amt(decode(sign(pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,
468: aid.invoice_id,
469: nvl(aid.base_amount,aid.amount),
470: 'N', 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') )),
471: -1,abs( pa_cmt_utils.get_apdist_amt( aid.invoice_distribution_id,

Line 790: pa_currency.round_currency_amt(decode(sign(gei.amount),1,gei.amount,0)),

786: gei.encumbrance_item_id,
787: adl.adl_line_num, --Bug 5726575 1,
788: 'E',
789: -- Bug 1980810 PA Rounding function added
790: pa_currency.round_currency_amt(decode(sign(gei.amount),1,gei.amount,0)),
791: pa_currency.round_currency_amt(decode(sign(gei.amount),-1,-1*gei.amount,0)),
792: x_budget_version_id,
793: gms_bc_packets_s.nextval,
794: adl.burdenable_raw_cost,

Line 791: pa_currency.round_currency_amt(decode(sign(gei.amount),-1,-1*gei.amount,0)),

787: adl.adl_line_num, --Bug 5726575 1,
788: 'E',
789: -- Bug 1980810 PA Rounding function added
790: pa_currency.round_currency_amt(decode(sign(gei.amount),1,gei.amount,0)),
791: pa_currency.round_currency_amt(decode(sign(gei.amount),-1,-1*gei.amount,0)),
792: x_budget_version_id,
793: gms_bc_packets_s.nextval,
794: adl.burdenable_raw_cost,
795: ge.incurred_by_person_id, -- Bug 2069132 ( RLMI Change)

Line 926: pa_currency.round_currency_amt(sign(nvl(entered_dr,0)) * abs(nvl(gbc.BURDENABLE_RAW_COST ,0) * nvl(cm.compiled_multiplier,0))),

922: gbc.BUDGET_VERSION_ID,
923: gbc.RESOURCE_LIST_MEMBER_ID,
924: gbc.ACCOUNT_TYPE,
925: -- Bug 1980810 PA Rounding function added
926: pa_currency.round_currency_amt(sign(nvl(entered_dr,0)) * abs(nvl(gbc.BURDENABLE_RAW_COST ,0) * nvl(cm.compiled_multiplier,0))),
927: pa_currency.round_currency_amt(sign(nvl(entered_cr,0)) * abs(nvl(gbc.BURDENABLE_RAW_COST ,0) * nvl(cm.compiled_multiplier,0))),
928: gbc.TOLERANCE_AMOUNT,
929: gbc.TOLERANCE_PERCENTAGE,
930: gbc.OVERRIDE_AMOUNT,

Line 927: pa_currency.round_currency_amt(sign(nvl(entered_cr,0)) * abs(nvl(gbc.BURDENABLE_RAW_COST ,0) * nvl(cm.compiled_multiplier,0))),

923: gbc.RESOURCE_LIST_MEMBER_ID,
924: gbc.ACCOUNT_TYPE,
925: -- Bug 1980810 PA Rounding function added
926: pa_currency.round_currency_amt(sign(nvl(entered_dr,0)) * abs(nvl(gbc.BURDENABLE_RAW_COST ,0) * nvl(cm.compiled_multiplier,0))),
927: pa_currency.round_currency_amt(sign(nvl(entered_cr,0)) * abs(nvl(gbc.BURDENABLE_RAW_COST ,0) * nvl(cm.compiled_multiplier,0))),
928: gbc.TOLERANCE_AMOUNT,
929: gbc.TOLERANCE_PERCENTAGE,
930: gbc.OVERRIDE_AMOUNT,
931: gbc.EFFECT_ON_FUNDS_CODE ,

Line 1063: pa_currency.round_currency_amt(decode(nvl(entered_dr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),

1059: gbc.BUDGET_VERSION_ID,
1060: gbc.RESOURCE_LIST_MEMBER_ID,
1061: gbc.ACCOUNT_TYPE,
1062: -- Bug 1980810 PA Rounding function added
1063: pa_currency.round_currency_amt(decode(nvl(entered_dr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1064: pa_currency.round_currency_amt(decode(nvl(entered_cr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1065: gbc.TOLERANCE_AMOUNT,
1066: gbc.TOLERANCE_PERCENTAGE,
1067: gbc.OVERRIDE_AMOUNT,

Line 1064: pa_currency.round_currency_amt(decode(nvl(entered_cr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),

1060: gbc.RESOURCE_LIST_MEMBER_ID,
1061: gbc.ACCOUNT_TYPE,
1062: -- Bug 1980810 PA Rounding function added
1063: pa_currency.round_currency_amt(decode(nvl(entered_dr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1064: pa_currency.round_currency_amt(decode(nvl(entered_cr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1065: gbc.TOLERANCE_AMOUNT,
1066: gbc.TOLERANCE_PERCENTAGE,
1067: gbc.OVERRIDE_AMOUNT,
1068: gbc.EFFECT_ON_FUNDS_CODE ,

Line 1211: pa_currency.round_currency_amt(decode(nvl(entered_dr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),

1207: gbc.BUDGET_VERSION_ID,
1208: gbc.RESOURCE_LIST_MEMBER_ID,
1209: gbc.ACCOUNT_TYPE,
1210: -- Bug 1980810 PA Rounding function added
1211: pa_currency.round_currency_amt(decode(nvl(entered_dr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1212: pa_currency.round_currency_amt(decode(nvl(entered_cr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1213: gbc.TOLERANCE_AMOUNT,
1214: gbc.TOLERANCE_PERCENTAGE,
1215: gbc.OVERRIDE_AMOUNT,

Line 1212: pa_currency.round_currency_amt(decode(nvl(entered_cr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),

1208: gbc.RESOURCE_LIST_MEMBER_ID,
1209: gbc.ACCOUNT_TYPE,
1210: -- Bug 1980810 PA Rounding function added
1211: pa_currency.round_currency_amt(decode(nvl(entered_dr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1212: pa_currency.round_currency_amt(decode(nvl(entered_cr,0),0,0,(abs(nvl(gbc.BURDENABLE_RAW_COST ,0)) * nvl(cm.compiled_multiplier,0)))),
1213: gbc.TOLERANCE_AMOUNT,
1214: gbc.TOLERANCE_PERCENTAGE,
1215: gbc.OVERRIDE_AMOUNT,
1216: gbc.EFFECT_ON_FUNDS_CODE ,

Line 1935: -- Call to pa_currency.round_currency_amt function will use

1931: BEGIN
1932:
1933:
1934: -- Bug 1980810 : Added to set currency related global variables
1935: -- Call to pa_currency.round_currency_amt function will use
1936: -- global variables and thus improves performance
1937:
1938: pa_currency.set_currency_info;
1939:

Line 1938: pa_currency.set_currency_info;

1934: -- Bug 1980810 : Added to set currency related global variables
1935: -- Call to pa_currency.round_currency_amt function will use
1936: -- global variables and thus improves performance
1937:
1938: pa_currency.set_currency_info;
1939:
1940:
1941: x_e_stage := '100';
1942: -- TO SELECT SET OF BOOKS ID