');
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;
|