The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from qa_insp_collections_temp
where collection_id = p_collection_id;
select 1
from qa_insp_plans_temp
where collection_id = p_collection_id
and plan_id = p_coll_plan_id;
--if they do exist then dont insert again.
--
-- Bug 5926256
-- Commented the below code
-- skolluku Wed Apr 18 03:15:08 PDT 2007
--
/*
open qict_cur;
insert into qa_insp_collections_temp
(collection_id, lot_size, transaction_uom,lot_result)
values
(p_collection_id, p_lot_size, p_uom_name, null);
delete from qa_insp_collections_temp
where collection_id = p_collection_id;
insert into qa_insp_collections_temp
(collection_id, lot_size, transaction_uom,lot_result)
values
(p_collection_id, p_lot_size, p_uom_name, null);
insert into qa_insp_plans_temp
(collection_id, plan_id, sampling_plan_id, sample_size,
c_number, rejection_number, aql, plan_insp_result)
values
(p_collection_id, p_coll_plan_id, -1, null,
null, null, null, null);
select collection_id,
sampling_flag,
skiplot_flag,
lot_size,
transaction_uom
from qa_insp_collections_temp;
select transaction_id,
transaction_date,
created_by,
last_updated_by,
last_update_login
from qa_results
where collection_id = x_coll_id and
transaction_id is not null and
rownum =1;
x_last_updated_by number;
x_last_update_login number;
x_created_by, x_last_updated_by, x_last_update_login;
qa_skiplot_utility.insert_error_log (
p_module_name => 'QA_INSPECTION_PKG.launch_shipment_action',
p_comments => 'sampling_flag = y' );
p_last_updated_by => x_last_updated_by,
p_last_update_login => x_last_update_login);
qa_skiplot_utility.insert_error_log (
p_module_name => 'QA_INSPECTION_PKG.launch_shipment_action',
p_comments => 'skiplot_flag = y' );
p_last_updated_by => x_last_updated_by,
p_last_update_login => x_last_update_login);
select sampling_flag
from qa_insp_collections_temp
where collection_id = x_coll_id;
select skiplot_flag
from qa_insp_collections_temp
where collection_id = x_coll_id;