APPS.EGO_ITEM_PVT dependencies on FND_GRANTS

Line 3457: l_instance_type fnd_grants.instance_type%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;
3461: l_create_grant_flag BOOLEAN;

Line 3458: l_pk1_value fnd_grants.instance_pk1_value%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;
3461: l_create_grant_flag BOOLEAN;
3462: l_user_id NUMBER;

Line 3459: l_pk2_value fnd_grants.instance_pk2_value%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;
3461: l_create_grant_flag BOOLEAN;
3462: l_user_id NUMBER;
3463: BEGIN

Line 3596: FROM fnd_grants

3592: SELECT instance_type, instance_set_id, instance_pk1_value,
3593: instance_pk2_value, start_date, end_date
3594: INTO l_instance_type, l_instance_set_id, l_pk1_value,
3595: l_pk2_value, l_start_date, l_end_date
3596: FROM fnd_grants
3597: WHERE grant_guid = x_grant_guid
3598: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
3599: code_debug(l_api_name||' grant validation check done ' );
3600: EXCEPTION