APPS.EGO_ITEM_PVT dependencies on FND_OBJECT_INSTANCE_SETS

Line 425: FROM fnd_object_instance_sets

421: IF x_instance_set_id IS NOT NULL THEN
422: BEGIN
423: SELECT instance_set_id
424: INTO x_instance_set_id
425: FROM fnd_object_instance_sets
426: WHERE instance_set_id = x_instance_set_id
427: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
428: RETURN TRUE;
429: EXCEPTION

Line 438: FROM fnd_object_instance_sets_vl

434: ELSIF p_set_disp_name IS NOT NULL THEN
435: BEGIN
436: SELECT instance_set_id
437: INTO x_instance_set_id
438: FROM fnd_object_instance_sets_vl
439: WHERE display_name = p_set_disp_name
440: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
441: RETURN TRUE;
442: EXCEPTION

Line 3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;

3448: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3449: l_approval_status mtl_system_items_b.approval_status%TYPE;
3450: l_item_number mtl_system_items_b_kfv.concatenated_segments%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;