APPS.EGO_ITEM_PVT dependencies on FND_GRANTS

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

Line 3198: l_pk1_value fnd_grants.instance_pk1_value%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;
3201: l_create_grant_flag BOOLEAN;
3202: l_user_id NUMBER;

Line 3199: l_pk2_value fnd_grants.instance_pk2_value%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;
3201: l_create_grant_flag BOOLEAN;
3202: l_user_id NUMBER;
3203: BEGIN

Line 3336: FROM fnd_grants

3332: SELECT instance_type, instance_set_id, instance_pk1_value,
3333: instance_pk2_value, start_date, end_date
3334: INTO l_instance_type, l_instance_set_id, l_pk1_value,
3335: l_pk2_value, l_start_date, l_end_date
3336: FROM fnd_grants
3337: WHERE grant_guid = x_grant_guid
3338: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
3339: code_debug(l_api_name||' grant validation check done ' );
3340: EXCEPTION