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 190: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod

186: v_to_transaction_id NUMBER := 18;
187: v_src_transaction_id NUMBER := 33;
188: v_not_a_first_transaction BOOLEAN := true;
189: v_remarks VARCHAR2(50); -- := 'RG Funds Transfer'; File.Sql.35 by Brathod
190: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod
191: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod
192: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
193: /*Bug 4543171 bduvarag start*/
194: CURSOR currency_cur IS

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

187: v_src_transaction_id NUMBER := 33;
188: v_not_a_first_transaction BOOLEAN := true;
189: v_remarks VARCHAR2(50); -- := 'RG Funds Transfer'; File.Sql.35 by Brathod
190: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod
191: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod
192: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
193: /*Bug 4543171 bduvarag start*/
194: CURSOR currency_cur IS
195: SELECT currency_code

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

590: p_excise_credit, --null
591: p_account_id,
592: 'Register India',
593: 'Register India',
594: to_number(fnd_profile.value('USER_ID')),
595: NULL,
596: NULL,
597: NULL,
598: NULL,

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

611: p_cess_credit, --null
612: p_cess_account_id,
613: 'Register India',
614: 'Register India',
615: to_number(fnd_profile.value('USER_ID')),
616: NULL,
617: NULL,
618: NULL,
619: NULL,

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

631: p_sh_cess_credit,
632: p_sh_cess_account_id,
633: 'Register India',
634: 'Register India',
635: to_number(fnd_profile.value('USER_ID')),
636: NULL,
637: NULL,
638: NULL,
639: NULL,

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

686: fetch currency_cur into lv_currency;
687: close currency_cur;
688: /*Bug 4543171 bduvarag end*/
689: v_remarks := 'RG Funds Transfer'; -- File.Sql.35 by Brathod
690: v_user_id := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) ; -- File.Sql.35 by Brathod
691: v_login_id := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) ; -- File.Sql.35 by Brathod
692:
693: IF p_register NOT IN ('RG23A','RG23C','PLA') THEN
694: RAISE_APPLICATION_ERROR(-20120, 'Select a Register');

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

687: close currency_cur;
688: /*Bug 4543171 bduvarag end*/
689: v_remarks := 'RG Funds Transfer'; -- File.Sql.35 by Brathod
690: v_user_id := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) ; -- File.Sql.35 by Brathod
691: v_login_id := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) ; -- File.Sql.35 by Brathod
692:
693: IF p_register NOT IN ('RG23A','RG23C','PLA') THEN
694: RAISE_APPLICATION_ERROR(-20120, 'Select a Register');
695: END IF;