APPS.QA_INSPECTION_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

        select 1
        from qa_insp_collections_temp
        where collection_id = p_collection_id;

Line: 19

        select 1
        from qa_insp_plans_temp
        where collection_id = p_collection_id
        and plan_id = p_coll_plan_id;

Line: 27

	--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;

Line: 39

		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);

Line: 52

        delete from qa_insp_collections_temp
        where collection_id = p_collection_id;

Line: 55

        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);

Line: 64

		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);

Line: 83

        select collection_id,
        sampling_flag,
        skiplot_flag,
        lot_size,
        transaction_uom
        from qa_insp_collections_temp;

Line: 100

        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;

Line: 113

    x_last_updated_by number;

Line: 114

    x_last_update_login number;

Line: 121

            x_created_by, x_last_updated_by, x_last_update_login;

Line: 128

qa_skiplot_utility.insert_error_log (
p_module_name => 'QA_INSPECTION_PKG.launch_shipment_action',
p_comments => 'sampling_flag  =  y' );

Line: 141

                p_last_updated_by => x_last_updated_by,
                p_last_update_login => x_last_update_login);

Line: 145

qa_skiplot_utility.insert_error_log (
p_module_name => 'QA_INSPECTION_PKG.launch_shipment_action',
p_comments => 'skiplot_flag  =  y' );

Line: 159

                p_last_updated_by => x_last_updated_by,
                p_last_update_login => x_last_update_login);

Line: 187

        select sampling_flag
        from qa_insp_collections_temp
        where collection_id = x_coll_id;

Line: 209

        select skiplot_flag
        from qa_insp_collections_temp
        where collection_id = x_coll_id;