[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* This procedure inserts a record in the eam_asset_operation_txn table after validation
-- Parameters :
-- IN :
-- p_txn_date date on which the transaction is being performed
-- p_txn_type transaction type which can either be checkin or checkout
-- p_instance_id Asset Number identification number
-- p_comments comments entered by the user during the transaction
-- p_qa_collection_id quality collection id to identify the results entered during the transaction
-- p_operable_flag operable status of the asset(1 or 2)
-- p_employee_id employee who actually is performing the transaction
-- p_eam_ops_quality_tbl plsql table of quality collection results entered during the transaction
-- p_meter_reading_rec_tbl plsql table of meter reading entries made during the transaction
-- p_counter_properties_tbl plsql table of counter properties entered during the transaction
--
--
-- out : x_return_status return status
-- x_msg_count count of error messages
-- x_msg_data error message data
-- Version : Current version: 1.0
-- Initial version: 1.0
--
-- Notes
--
-- End of comments
*/
PROCEDURE process_checkinout_txn
(
p_api_version IN number :=1.0,
p_init_msg_list IN varchar2 :=fnd_api.g_false,
p_commit IN varchar2 :=fnd_api.g_false,
p_validation_level IN number :=fnd_api.g_valid_level_full,
p_txn_date IN date :=sysdate,
p_txn_type IN number,
p_instance_id IN number,
p_comments IN varchar2 := NULL,
p_qa_collection_id IN number := NULL,
p_operable_flag IN number,
p_employee_id IN number,
p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
p_meter_reading_rec_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
p_attribute_category IN varchar2 := NULL,
p_attribute1 IN varchar2 := NULL,
p_attribute2 IN varchar2 := NULL,
p_attribute3 IN varchar2 := NULL,
p_attribute4 IN varchar2 := NULL,
p_attribute5 IN varchar2 := NULL,
p_attribute6 IN varchar2 := NULL,
p_attribute7 IN varchar2 := NULL,
p_attribute8 IN varchar2 := NULL,
p_attribute9 IN varchar2 := NULL,
p_attribute10 IN varchar2 := NULL,
p_attribute11 IN varchar2 := NULL,
p_attribute12 IN varchar2 := NULL,
p_attribute13 IN varchar2 := NULL,
p_attribute14 IN varchar2 := NULL,
p_attribute15 IN varchar2 := NULL,
x_return_status OUT NOCOPY varchar2,
x_msg_count OUT NOCOPY number,
x_msg_data OUT NOCOPY varchar2
)
IS
l_api_name constant varchar2(30) :='EAM_ASSET_OPERATION_TXN_PUB';
EAM_ASSET_OPERATION_TXN_PVT.insert_txn(
p_txn_date => p_txn_date,
p_txn_type => p_txn_type,
p_instance_id => p_instance_id,
p_comments => p_comments,
p_qa_collection_id => p_qa_collection_id,
p_operable_flag => p_operable_flag,
p_employee_id => p_employee_id,
p_eam_ops_quality_tbl => p_eam_ops_quality_tbl,
p_meter_reading_rec_tbl => p_meter_reading_rec_tbl,
p_counter_properties_tbl => p_counter_properties_tbl,
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
INSERT into temp_isetup_api(msg,sr_no)
VALUES (info,g_sr_no);