219: FND_GLOBAL.USER_ID,
220: FND_GLOBAL.USER_ID,
221: p_sys_date,
222: FND_GLOBAL.LOGIN_ID,
223: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),1,adl.raw_cost,0)),
224: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),-1,-1*adl.raw_cost,0)),
225: gei.encumbrance_type,
226: nvl(gei.override_to_organization_id,ge.incurred_by_organization_id),
227: trunc(gei.encumbrance_item_date),
220: FND_GLOBAL.USER_ID,
221: p_sys_date,
222: FND_GLOBAL.LOGIN_ID,
223: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),1,adl.raw_cost,0)),
224: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),-1,-1*adl.raw_cost,0)),
225: gei.encumbrance_type,
226: nvl(gei.override_to_organization_id,ge.incurred_by_organization_id),
227: trunc(gei.encumbrance_item_date),
228: 'ENC',
460: FND_GLOBAL.USER_ID,
461: FND_GLOBAL.USER_ID,
462: p_sys_date,
463: FND_GLOBAL.LOGIN_ID,
464: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),1,adl.raw_cost,0)),
465: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),-1,-1*adl.raw_cost,0)),
466: gei.encumbrance_type,
467: nvl(gei.override_to_organization_id,ge.incurred_by_organization_id),
468: trunc(gei.encumbrance_item_date),
461: FND_GLOBAL.USER_ID,
462: p_sys_date,
463: FND_GLOBAL.LOGIN_ID,
464: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),1,adl.raw_cost,0)),
465: pa_currency.round_currency_amt(decode(sign(adl.raw_cost),-1,-1*adl.raw_cost,0)),
466: gei.encumbrance_type,
467: nvl(gei.override_to_organization_id,ge.incurred_by_organization_id),
468: trunc(gei.encumbrance_item_date),
469: 'ENC',
686: FND_GLOBAL.USER_ID,
687: FND_GLOBAL.USER_ID,
688: sysdate,
689: FND_GLOBAL.LOGIN_ID,
690: pa_currency.round_currency_amt(decode(sign(gei.amount),1,gei.amount,0)),
691: pa_currency.round_currency_amt(decode(sign(gei.amount),-1,-1*gei.amount,0)),
692: gei.encumbrance_type,
693: nvl(gei.override_to_organization_id,ge.incurred_by_organization_id),
694: trunc(gei.encumbrance_item_date),
687: FND_GLOBAL.USER_ID,
688: sysdate,
689: FND_GLOBAL.LOGIN_ID,
690: pa_currency.round_currency_amt(decode(sign(gei.amount),1,gei.amount,0)),
691: pa_currency.round_currency_amt(decode(sign(gei.amount),-1,-1*gei.amount,0)),
692: gei.encumbrance_type,
693: nvl(gei.override_to_organization_id,ge.incurred_by_organization_id),
694: trunc(gei.encumbrance_item_date),
695: 'ENC',
835: END IF;
836:
837:
838: -- Bug 1980810 : Added to set currency related global variables
839: -- Call to pa_currency.round_currency_amt function will use
840: -- global variables and thus improves performance
841: -- For Actuals this call is done in Funds check process (gmsfcfcb.pls) itself.
842: -- For Manual enc. as we are using PA rounding call, we are setting it here.
843:
840: -- global variables and thus improves performance
841: -- For Actuals this call is done in Funds check process (gmsfcfcb.pls) itself.
842: -- For Manual enc. as we are using PA rounding call, we are setting it here.
843:
844: pa_currency.set_currency_info;
845:
846:
847: select set_of_books_id
848: into l_sob_id