DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on FND_MENUS

Line 474: FROM fnd_menus

470: IF x_menu_id IS NOT NULL THEN
471: BEGIN
472: SELECT menu_id, menu_name
473: INTO x_menu_id, x_menu_name
474: FROM fnd_menus
475: WHERE menu_id = x_menu_id
476: AND type = p_menu_type;
477: RETURN TRUE;
478: EXCEPTION

Line 488: FROM fnd_menus_vl

484: ELSIF p_user_menu_name IS NOT NULL THEN
485: BEGIN
486: SELECT menu_id, menu_name
487: INTO x_menu_id, x_menu_name
488: FROM fnd_menus_vl
489: WHERE user_menu_name = p_user_menu_name
490: AND type = p_menu_type;
491: RETURN TRUE;
492: EXCEPTION

Line 3455: l_role_id fnd_menus_vl.menu_id%TYPE;

3451: l_hz_party_type hz_parties.party_type%TYPE;
3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3453: l_party_id hz_parties.party_id%TYPE;
3454: l_party_name hz_parties.party_name%TYPE;
3455: l_role_id fnd_menus_vl.menu_id%TYPE;
3456: l_role_name fnd_menus_vl.menu_name%TYPE;
3457: l_instance_type fnd_grants.instance_type%TYPE;
3458: l_pk1_value fnd_grants.instance_pk1_value%TYPE;
3459: l_pk2_value fnd_grants.instance_pk2_value%TYPE;

Line 3456: l_role_name fnd_menus_vl.menu_name%TYPE;

3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3453: l_party_id hz_parties.party_id%TYPE;
3454: l_party_name hz_parties.party_name%TYPE;
3455: l_role_id fnd_menus_vl.menu_id%TYPE;
3456: l_role_name fnd_menus_vl.menu_name%TYPE;
3457: l_instance_type fnd_grants.instance_type%TYPE;
3458: l_pk1_value fnd_grants.instance_pk1_value%TYPE;
3459: l_pk2_value fnd_grants.instance_pk2_value%TYPE;
3460: l_invalid_flag BOOLEAN;