[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT instance_id INTO l_maintenance_object_id
FROM csi_item_instances
WHERE inventory_item_id = p_inventory_item_id
AND serial_number = p_serial_number;
select cii.instantiation_flag, cii.network_asset_flag
into l_eam_instantiation_flag, l_network_asset_flag
from csi_item_instances cii
where cii.instance_id = p_maintenance_object_id;
select eomd.accounting_class_code, eomd.owning_department_id
INTO l_class_code, l_owning_department_id
FROM csi_item_instances cii, eam_org_maint_defaults eomd, mtl_parameters mp
WHERE cii.instance_id = p_maintenance_object_id
and eomd.object_type = 50
and eomd.object_id = cii.instance_id
and mp.organization_id = cii.last_vld_organization_id
and eomd.organization_id = mp.maint_organization_id;
UPDATE csi_item_instances
SET instantiation_flag = 'Y'
WHERE instance_id = p_maintenance_object_id;
-- 7: Insert Log into EAM_ASSET_LOG for Activate Asset Event while Asset Creation
-- with Active Status and Operational Log Flag Checked.
SELECT mp.maint_organization_id, cii.instance_number, cii.active_start_date, cii.operational_log_flag
INTO l_maint_orgid, l_reference, l_event_date, l_operational_log_flag
FROM csi_item_instances cii, mtl_parameters mp
WHERE cii.instance_id = p_maintenance_object_id
AND cii.last_vld_organization_id = mp.organization_id ;
eam_asset_log_pvt.insert_row
(
p_event_date => l_event_date,
p_event_type => l_event_type,
p_event_id => 1,
p_organization_id => l_maint_orgid,
p_instance_id => p_maintenance_object_id,
p_reference => l_reference,
p_ref_id => p_maintenance_object_id,
p_instance_number => l_reference,
p_comments => l_comments,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
-- 8: Insert into EAM_ASSET_TEXT for text Search
eam_text_util.process_asset_update_event
(
p_event => 'INSERT'
,p_instance_id => p_maintenance_object_id
);