APPS.EGO_ITEM_PVT dependencies on FND_OBJECT_INSTANCE_SETS

Line 421: FROM fnd_object_instance_sets

417: IF x_instance_set_id IS NOT NULL THEN
418: BEGIN
419: SELECT instance_set_id
420: INTO x_instance_set_id
421: FROM fnd_object_instance_sets
422: WHERE instance_set_id = x_instance_set_id
423: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
424: RETURN TRUE;
425: EXCEPTION

Line 434: FROM fnd_object_instance_sets_vl

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

Line 3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;

3188: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3189: l_approval_status mtl_system_items_b.approval_status%TYPE;
3190: l_item_number mtl_system_items_b_kfv.concatenated_segments%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;