APPS.ORACLEMYPAGE dependencies on ICX_SESSIONS

Line 291: update icx_sessions

287: begin
288: l_session_id := to_number(p_session_id);
289: l_page_id := to_number(p_page_id);
290:
291: update icx_sessions
292: set page_id = p_page_id
293: where session_id = p_session_id;
294: commit;
295: exception

Line 580: update ICX_SESSIONS

576: icx_sec.g_session_id:=l_session_id;--MPUTMAN ADDED 2456610
577: if home_url is not null
578: then
579: l_url := home_url;
580: update ICX_SESSIONS
581: set HOME_URL = l_url
582: where SESSION_ID = l_session_id;
583: end if;
584: else

Line 1046: update ICX_SESSIONS

1042: l_agent := icx_plug_utilities.getPLSQLagent;
1043:
1044: if home_url is not null then
1045: l_home_url := home_url;
1046: update ICX_SESSIONS
1047: set HOME_URL = l_home_url
1048: where SESSION_ID = l_session_id;
1049: commit;
1050: end if;

Line 1060: from icx_sessions

1056: where USER_ID = icx_sec.g_user_id;
1057:
1058: -- get active page_id
1059: select page_id into l_active_page_id
1060: from icx_sessions
1061: where session_id = l_session_id;
1062:
1063: fnd_message.set_name('ICX','ICX_LOGIN_WELCOME');
1064: fnd_message.set_token('USER',l_known_as);

Line 1246: from icx_sessions

1242: where USER_ID = icx_sec.g_user_id;
1243:
1244: -- get active page_id
1245: select page_id into l_active_page_id
1246: from icx_sessions
1247: where session_id = icx_sec.g_session_id;
1248:
1249: fnd_message.set_name('ICX','ICX_LOGIN_WELCOME');
1250: fnd_message.set_token('USER',l_known_as);