APPS.ORACLECONFIGURE dependencies on ICX_SESSIONS

Line 63: update icx_sessions

59: x_last_update_date => sysdate,
60: x_last_updated_by => icx_sec.g_user_id,
61: x_last_update_login => icx_sec.g_user_id);
62:
63: update icx_sessions
64: set page_id = l_page_id
65: where session_id = icx_sec.g_session_id;
66:
67: if (p_page_type = 'MAIN') then

Line 195: update icx_sessions

191: x_last_update_login => icx_sec.g_user_id);
192:
193: copyPagePrivate(l_from_main_region_id, l_to_main_region_id, l_to_page_id);
194:
195: update icx_sessions
196: set page_id = l_to_page_id
197: where session_id = icx_sec.g_session_id;
198:
199: end if;

Line 320: from icx_sessions

316:
317: begin
318: select page_id
319: into l_current_page_id -- id for the page user has active on OracleMyPage
320: from icx_sessions
321: where session_id = icx_sec.g_session_id;
322: exception
323: when no_data_found then
324: htp.p(SQLERRM);

Line 376: update icx_sessions

372: when no_data_found then
373: htp.p(SQLERRM);
374: end;
375:
376: update icx_sessions
377: set page_id = l_main_page_id
378: where session_id = icx_sec.g_session_id;
379: end if;
380:

Line 421: from icx_sessions

417: else
418: begin
419: select page_id
420: into l_page_id
421: from icx_sessions
422: where session_id = icx_sec.g_session_id;
423: exception
424: when no_data_found then
425: htp.p(SQLERRM);

Line 686: update icx_sessions

682: cattributes => 'NAME="functionwindowfocus"');
683: htp.formHidden('X','FALSE');
684: htp.formClose;
685:
686: update icx_sessions
687: set page_id = p_page_id
688: where session_id = icx_sec.g_session_id;
689: commit;
690: end if;