215: null,
216: null,
217: 'P',
218: p_sys_date,
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)),
216: null,
217: 'P',
218: p_sys_date,
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)),
218: p_sys_date,
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),
456: null,
457: null,
458: 'P',
459: p_sys_date,
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)),
457: null,
458: 'P',
459: p_sys_date,
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)),
459: p_sys_date,
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),
543: x_count OUT NOCOPY NUMBER
544: ) IS
545: PRAGMA AUTONOMOUS_TRANSACTION;
546:
547: l_request_id NUMBER := fnd_global.conc_request_id ;
548: l_rows_inserted NUMBER; --Bug 5726575
549:
550: /* ----------------------------- Update baselined budget_version_id ----------------------------------- */
551:
682: null,
683: null,
684: 'P', -- Bug 2163845
685: sysdate,
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)),
683: null,
684: 'P', -- Bug 2163845
685: sysdate,
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)),
685: sysdate,
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),
867: x_packet_id,
868: 'E', -- DEFAULT 'R'
869: 'N', --x_over DEFAULT 'N'
870: 'Y', --x_partial DEFAULT 'N'
871: fnd_global.user_id, -- x_user_id,
872: fnd_global.resp_id,
873: 'Y',
874: x_return_code,
875: x_e_code,
868: 'E', -- DEFAULT 'R'
869: 'N', --x_over DEFAULT 'N'
870: 'Y', --x_partial DEFAULT 'N'
871: fnd_global.user_id, -- x_user_id,
872: fnd_global.resp_id,
873: 'Y',
874: x_return_code,
875: x_e_code,
876: x_e_mesg) then