eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RG_TRANSFER_PKG dependencies on FND_PROFILE

Line 198: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod

194: v_to_transaction_id NUMBER := 18;
195: v_src_transaction_id NUMBER := 33;
196: v_not_a_first_transaction BOOLEAN := true;
197: v_remarks VARCHAR2(50); -- := 'RG Funds Transfer'; File.Sql.35 by Brathod
198: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod
199: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod
200: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
201: /*Bug 4543171 bduvarag start*/
202: CURSOR currency_cur IS

Line 199: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod

195: v_src_transaction_id NUMBER := 33;
196: v_not_a_first_transaction BOOLEAN := true;
197: v_remarks VARCHAR2(50); -- := 'RG Funds Transfer'; File.Sql.35 by Brathod
198: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod
199: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod
200: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
201: /*Bug 4543171 bduvarag start*/
202: CURSOR currency_cur IS
203: SELECT currency_code

Line 625: to_number(fnd_profile.value('USER_ID')),

621: p_excise_credit, --null
622: p_account_id,
623: 'Register India',
624: 'Register India',
625: to_number(fnd_profile.value('USER_ID')),
626: NULL,
627: NULL,
628: NULL,
629: NULL,

Line 648: to_number(fnd_profile.value('USER_ID')),

644: p_cess_credit, --null
645: p_cess_account_id,
646: 'Register India',
647: 'Register India',
648: to_number(fnd_profile.value('USER_ID')),
649: NULL,
650: NULL,
651: NULL,
652: NULL,

Line 670: to_number(fnd_profile.value('USER_ID')),

666: p_sh_cess_credit,
667: p_sh_cess_account_id,
668: 'Register India',
669: 'Register India',
670: to_number(fnd_profile.value('USER_ID')),
671: NULL,
672: NULL,
673: NULL,
674: NULL,

Line 728: v_user_id := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) ; -- File.Sql.35 by Brathod

724: fetch currency_cur into lv_currency;
725: close currency_cur;
726: /*Bug 4543171 bduvarag end*/
727: v_remarks := 'RG Funds Transfer'; -- File.Sql.35 by Brathod
728: v_user_id := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) ; -- File.Sql.35 by Brathod
729: v_login_id := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) ; -- File.Sql.35 by Brathod
730:
731: --Fetching organization code information for Added for bug # 13824043
732:

Line 729: v_login_id := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) ; -- File.Sql.35 by Brathod

725: close currency_cur;
726: /*Bug 4543171 bduvarag end*/
727: v_remarks := 'RG Funds Transfer'; -- File.Sql.35 by Brathod
728: v_user_id := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) ; -- File.Sql.35 by Brathod
729: v_login_id := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) ; -- File.Sql.35 by Brathod
730:
731: --Fetching organization code information for Added for bug # 13824043
732:
733: select organization_code into p_org_code from