The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_mtlt
(
x_return_status OUT NOCOPY VARCHAR2
,p_mtlt_tbl IN g_mtlt_tbl_type
,p_mtlt_tbl_size IN INTEGER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_mtlt';
SELECT Sysdate INTO l_today FROM dual;
INSERT INTO mtl_transaction_lots_temp
(
transaction_temp_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,request_id
,program_application_id
,program_id
,program_update_date
,transaction_quantity
,primary_quantity
,lot_number
,lot_expiration_date
,error_code
,serial_transaction_temp_id
,group_header_id
,put_away_rule_id
,pick_rule_id
)
VALUES
(
p_mtlt_tbl(l_counter).transaction_temp_id
,l_today
,l_user_id
,l_today
,l_user_id
,l_login_id
,p_mtlt_tbl(l_counter).request_id
,p_mtlt_tbl(l_counter).program_application_id
,p_mtlt_tbl(l_counter).program_id
,p_mtlt_tbl(l_counter).program_update_date
,p_mtlt_tbl(l_counter).transaction_quantity
,p_mtlt_tbl(l_counter).primary_quantity
,p_mtlt_tbl(l_counter).lot_number
,p_mtlt_tbl(l_counter).lot_expiration_date
,p_mtlt_tbl(l_counter).error_code
,p_mtlt_tbl(l_counter).serial_transaction_temp_id
,p_mtlt_tbl(l_counter).group_header_id
,p_mtlt_tbl(l_counter).put_away_rule_id
,p_mtlt_tbl(l_counter).pick_rule_id
);
END insert_mtlt;
PROCEDURE insert_msnt
(
x_return_status OUT NOCOPY VARCHAR2
,p_msnt_tbl IN g_msnt_tbl_type
,p_msnt_tbl_size IN INTEGER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Insert_MSNT';
SELECT Sysdate INTO l_today FROM dual;
INSERT INTO mtl_serial_numbers_temp
(
transaction_temp_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,request_id
,program_application_id
,program_id
,program_update_date
,vendor_serial_number
,vendor_lot_number
,fm_serial_number
,to_serial_number
,serial_prefix
,error_code
,group_header_id
,parent_serial_number
,end_item_unit_number
)
VALUES
(
p_msnt_tbl(l_counter).transaction_temp_id
,l_today
,l_user_id
,l_today
,l_user_id
,l_login_id
,p_msnt_tbl(l_counter).request_id
,p_msnt_tbl(l_counter).program_application_id
,p_msnt_tbl(l_counter).program_id
,p_msnt_tbl(l_counter).program_update_date
,p_msnt_tbl(l_counter).vendor_serial_number
,p_msnt_tbl(l_counter).vendor_lot_number
,p_msnt_tbl(l_counter).fm_serial_number
,p_msnt_tbl(l_counter).to_serial_number
,p_msnt_tbl(l_counter).serial_prefix
,p_msnt_tbl(l_counter).error_code
,p_msnt_tbl(l_counter).group_header_id
,p_msnt_tbl(l_counter).parent_serial_number
,p_msnt_tbl(l_counter).end_item_unit_number
);
END insert_msnt;
SELECT distinct concatenated_segments INTO l_item_name
FROM mtl_system_items_kfv
WHERE inventory_item_id = p_item_id;