78: if p_maintenance_object_id is not null then
79: l_maintenance_object_id := p_maintenance_object_id;
80:
81: select instance_number, inventory_item_id into l_instance_number, l_asset_group_id
82: from csi_item_instances where instance_id = l_maintenance_object_id;
83: else
84: if (p_asset_number is not null and p_asset_group is not null) then
85: select instance_number, instance_id into l_instance_number, l_maintenance_object_id
86: from csi_item_instances where serial_number = p_asset_number
82: from csi_item_instances where instance_id = l_maintenance_object_id;
83: else
84: if (p_asset_number is not null and p_asset_group is not null) then
85: select instance_number, instance_id into l_instance_number, l_maintenance_object_id
86: from csi_item_instances where serial_number = p_asset_number
87: and inventory_item_id = p_asset_group;
88: l_asset_group_id := p_asset_group;
89: else
90: l_instance_number:=null;
144: l_stmt_number := 30 ;
145: begin
146: select cii.instance_description
147: into l_asset_description
148: from csi_item_instances cii
149: where cii.instance_id = l_maintenance_object_id;
150:
151: exception
152: when No_Data_Found then