DBA Data[Home] [Help]

APPS.ORACLEMYPAGE dependencies on FND_USER

Line 66: FND_USER_RESP_GROUPS d,

62: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
63: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
64: c.DESCRIPTION,a.WEB_HTML_CALL
65: from fnd_responsibility e,
66: FND_USER_RESP_GROUPS d,
67: FND_FORM_FUNCTIONS a,
68: FND_MENU_ENTRIES_VL c,
69: ICX_PAGE_PLUGS b
70: where b.PAGE_ID = l_page_id

Line 102: FND_USER_RESP_GROUPS d,

98: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
99: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
100: c.DESCRIPTION,a.WEB_HTML_CALL
101: from fnd_responsibility e,
102: FND_USER_RESP_GROUPS d,
103: FND_FORM_FUNCTIONS a,
104: FND_MENU_ENTRIES_VL c,
105: ICX_PAGE_PLUGS b
106: where b.PAGE_ID = l_page_id

Line 313: from fnd_responsibility fr, FND_USER_RESP_GROUPS furg,

309: cursor plugInfo (p_page_id number, p_user_id number) is
310: select fff.FUNCTION_NAME, fff.TYPE, fff.WEB_HOST_NAME,
311: fff.WEB_HTML_CALL, fff.FUNCTION_ID, ipp.PLUG_ID,
312: nvl(ipp.DISPLAY_NAME,fme.PROMPT) display, ipp.DISPLAY_SEQUENCE
313: from fnd_responsibility fr, FND_USER_RESP_GROUPS furg,
314: fnd_form_functions fff, fnd_menu_entries_vl fme,
315: icx_page_plugs ipp
316: where ipp.PAGE_ID = p_page_id and fme.MENU_ID = ipp.MENU_ID
317: and fme.ENTRY_SEQUENCE = ipp.ENTRY_SEQUENCE

Line 509: FROM fnd_user

505: -- 2802333 nlbarlow APPS_SSO
506: BEGIN
507: SELECT user_id
508: INTO l_user_id
509: FROM fnd_user
510: WHERE user_name = upper(i_1);
511: EXCEPTION
512: WHEN no_data_found THEN
513: l_user_id := NULL;

Line 631: from FND_USER

627:
628: begin
629: select 'Y'
630: into l_expired
631: from FND_USER
632: where USER_NAME = UPPER(i_1)
633: and (PASSWORD_DATE is NULL or
634: (PASSWORD_LIFESPAN_ACCESSES is not NULL and
635: nvl(PASSWORD_ACCESSES_LEFT, 0) < 1) or

Line 697: FND_USER_RESP_GROUPS b,

693: fsg.security_group_key,
694: fa.application_short_name
695: from FND_SECURITY_GROUPS_VL fsg,
696: fnd_responsibility_vl a,
697: FND_USER_RESP_GROUPS b,
698: FND_APPLICATION fa
699: where b.user_id = icx_sec.g_user_id
700: and b.start_date <= sysdate
701: and (b.end_date is null or b.end_date > sysdate)

Line 726: FND_USER_RESP_GROUPS b,

722: fsg.security_group_key,
723: fa.application_short_name
724: from FND_SECURITY_GROUPS_VL fsg,
725: fnd_responsibility_vl a,
726: FND_USER_RESP_GROUPS b,
727: FND_APPLICATION fa
728: where b.user_id = icx_sec.g_user_id
729: and b.start_date <= sysdate
730: and (b.end_date is null or b.end_date > sysdate)

Line 882: FND_USER_RESP_GROUPS b

878: -- 1584711 nlbarlow remove order by
879: select count(*) INTO l_resps_count
880: from FND_SECURITY_GROUPS_VL fsg,
881: FND_RESPONSIBILITY_VL a,
882: FND_USER_RESP_GROUPS b
883: where b.user_id = l_user_id
884: and b.start_date <= sysdate
885: and (b.end_date is null or b.end_date > sysdate)
886: and b.RESPONSIBILITY_id = a.responsibility_id

Line 911: FND_USER_RESP_GROUPS b

907: end if;
908: select a.version INTO l_resp_type
909: from FND_SECURITY_GROUPS_VL fsg,
910: FND_RESPONSIBILITY_VL a,
911: FND_USER_RESP_GROUPS b
912: where b.user_id = l_user_id
913: and b.start_date <= sysdate
914: and (b.end_date is null or b.end_date > sysdate)
915: and b.RESPONSIBILITY_id = a.responsibility_id

Line 1055: from FND_USER

1051:
1052:
1053: select substr(nvl(DESCRIPTION,USER_NAME),1,70)
1054: into l_known_as
1055: from FND_USER
1056: where USER_ID = icx_sec.g_user_id;
1057:
1058: -- get active page_id
1059: select page_id into l_active_page_id

Line 1241: from FND_USER

1237: l_agent := icx_plug_utilities.getPLSQLagent;
1238:
1239: select substr(nvl(DESCRIPTION,USER_NAME),1,70)
1240: into l_known_as
1241: from FND_USER
1242: where USER_ID = icx_sec.g_user_id;
1243:
1244: -- get active page_id
1245: select page_id into l_active_page_id