DBA Data[Home] [Help]

APPS.ORACLEPLUGS dependencies on ICX_SEC

Line 151: if(icx_sec.validateSession)

147: l_prompts icx_util.g_prompts_table;
148:
149: begin
150:
151: if(icx_sec.validateSession)
152: then
153: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_RENAME', l_title, l_prompts);
154:
155: htp.p('');

Line 240: where USER_ID = icx_sec.g_user_id;

236:
237: select COLOR_SCHEME
238: into l_color_scheme
239: from ICX_PAGE_COLOR_SCHEME
240: where USER_ID = icx_sec.g_user_id;
241:
242: htp.p('');
243:
244: htp.p('');

Line 274: where USER_ID = icx_sec.g_user_id

270:
271: select nvl(REFRESH_RATE,0)
272: into l_selected
273: from ICX_PAGES
274: where USER_ID = icx_sec.g_user_id
275: and PAGE_ID = p_page_id;
276:
277: htp.p('

'||p_text||'
'||p_refresh||'');
278: htp.formSelectOpen('O');

Line 345: where b.user_id = icx_sec.g_user_id

341: from fnd_form_functions d,
342: fnd_menu_entries_vl c,
343: fnd_responsibility_vl a,
344: FND_USER_RESP_GROUPS b
345: where b.user_id = icx_sec.g_user_id
346: and b.start_date <= sysdate
347: and (b.end_date is null or b.end_date > sysdate)
348: and b.RESPONSIBILITY_application_id = a.application_id
349: and b.responsibility_id = a.responsibility_id

Line 374: where b.user_id = icx_sec.g_user_id

370: from fnd_form_functions d,
371: fnd_menu_entries_vl c,
372: fnd_responsibility_vl a,
373: FND_USER_RESP_GROUPS b
374: where b.user_id = icx_sec.g_user_id
375: and b.start_date <= sysdate
376: and (b.end_date is null or b.end_date > sysdate)
377: and b.RESPONSIBILITY_application_id = a.application_id
378: and b.responsibility_id = a.responsibility_id

Line 403: and d.user_id = icx_sec.g_user_id

399: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
400: and c.FUNCTION_ID = a.FUNCTION_ID
401: and a.type in ('WWL','WWLG')
402: and b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
403: and d.user_id = icx_sec.g_user_id
404: and d.start_date <= sysdate
405: and (d.end_date is null or d.end_date > sysdate)
406: and b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
407: and e.start_date <= sysdate

Line 438: and d.user_id = icx_sec.g_user_id

434: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
435: and c.FUNCTION_ID = a.FUNCTION_ID
436: and a.type in ('WWR','WWRG')
437: and b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
438: and d.user_id = icx_sec.g_user_id
439: and d.start_date <= sysdate
440: and (d.end_date is null or d.end_date > sysdate)
441: and b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
442: and e.start_date <= sysdate

Line 450: l_session_id := icx_sec.getsessioncookie;

446: begin
447:
448: if p_session_id is null
449: then
450: l_session_id := icx_sec.getsessioncookie;
451: else
452: l_session_id := p_session_id;
453: end if;
454:

Line 455: if icx_sec.validateSessionPrivate(l_session_id)

451: else
452: l_session_id := p_session_id;
453: end if;
454:
455: if icx_sec.validateSessionPrivate(l_session_id)
456: then
457:
458: if p_page_id is null
459: then

Line 463: where USER_ID = icx_sec.g_user_id;

459: then
460: select PAGE_ID
461: into l_page_id
462: from ICX_PAGES
463: where USER_ID = icx_sec.g_user_id;
464: else
465: l_page_id := p_page_id;
466: end if;
467:

Line 707: p_language_code => icx_sec.g_language_code,

703:
704: htp.p('');
705:
706: icx_plug_utilities.toolbar(p_text => l_title,
707: p_language_code => icx_sec.g_language_code,
708: p_disp_help => 'Y',
709: p_disp_mainmenu => 'N',
710: p_disp_menu => 'N');
711:

Line 1037: if icx_sec.validateSession

1033: where PAGE_ID = l_page_id;
1034:
1035: begin
1036:
1037: if icx_sec.validateSession
1038: then
1039: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1040: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
1041: l_page_id := icx_call.decrypt2(Z);

Line 1039: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

1035: begin
1036:
1037: if icx_sec.validateSession
1038: then
1039: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1040: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
1041: l_page_id := icx_call.decrypt2(Z);
1042:
1043: l_length := length(X);

Line 1040: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);

1036:
1037: if icx_sec.validateSession
1038: then
1039: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1040: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
1041: l_page_id := icx_call.decrypt2(Z);
1042:
1043: l_length := length(X);
1044: l_index := 0;