DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on FND_MENUS_VL

Line 484: FROM fnd_menus_vl

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

Line 3195: l_role_id fnd_menus_vl.menu_id%TYPE;

3191: l_hz_party_type hz_parties.party_type%TYPE;
3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3193: l_party_id hz_parties.party_id%TYPE;
3194: l_party_name hz_parties.party_name%TYPE;
3195: l_role_id fnd_menus_vl.menu_id%TYPE;
3196: l_role_name fnd_menus_vl.menu_name%TYPE;
3197: l_instance_type fnd_grants.instance_type%TYPE;
3198: l_pk1_value fnd_grants.instance_pk1_value%TYPE;
3199: l_pk2_value fnd_grants.instance_pk2_value%TYPE;

Line 3196: l_role_name fnd_menus_vl.menu_name%TYPE;

3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3193: l_party_id hz_parties.party_id%TYPE;
3194: l_party_name hz_parties.party_name%TYPE;
3195: l_role_id fnd_menus_vl.menu_id%TYPE;
3196: l_role_name fnd_menus_vl.menu_name%TYPE;
3197: l_instance_type fnd_grants.instance_type%TYPE;
3198: l_pk1_value fnd_grants.instance_pk1_value%TYPE;
3199: l_pk2_value fnd_grants.instance_pk2_value%TYPE;
3200: l_invalid_flag BOOLEAN;