APPS.ICX_SEC dependencies on DUAL

Line 59: -- from sys.dual;

55: --begin
56:
57: --select icx_sessions_s.nextval
58: -- into l_session_id
59: -- from sys.dual;
60:
61: -- l_random_num := Random1('X');
62: -- l_session_id := l_session_id||l_random_num;
63: -- l_new_session_id := l_session_id;

Line 380: select fnd_message.get into c_error_msg1 from dual;

376: if c_validate_only = 'N'
377: then
378:
379: --Start Bug 3161306
380: select fnd_message.get into c_error_msg1 from dual;
381: if c_error_msg1 like 'Oracle error%'
382: then
383: htp.p(c_error_msg1);
384: htp.nl;

Line 844: -- from sys.dual;

840:
841: begin
842: -- select icx_transactions_s.nextval
843: -- into l_transaction_id
844: -- from sys.dual;
845: -- icx_transactions_s.nextval moved directly into insert statment for performance bug# 2494109 --mputman
846:
847: insert into icx_transactions (
848: TRANSACTION_ID,

Line 2014: select substr(c_error_msg,12,512) into c_display_error from dual;

2010: END IF; -- portal profile defined
2011: --let normal failure occur.
2012: n_error_num := SQLCODE;
2013: c_error_msg := SQLERRM;
2014: select substr(c_error_msg,12,512) into c_display_error from dual;
2015: icx_util.add_error(c_display_error);
2016: icx_admin_sig.error_screen(c_display_error);
2017:
2018: -- fnd_message.set_name('ICX','ICX_DATA_INCORRECT');

Line 2491: from sys.dual;

2487: NULL;
2488: /*
2489: select icx_audit_s.nextval
2490: into c_audit_id
2491: from sys.dual;
2492:
2493: n_session_id := getsessioncookie;
2494: c_message := icx_sec.validateSession(n_session_id,c_web_user_id,c_language);
2495:

Line 4382: from sys.dual;

4378: begin
4379:
4380: select fnd_logins_s.nextval
4381: into l_login_id
4382: from sys.dual;
4383:
4384:
4385: return(l_login_id);
4386: end;