APPS.QA_SKIPLOT_RCV_GRP SQL Statements

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

Line: 59

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
            p_error_message => 'no error ',
            p_comments => 'availability=' || x_qa_availability);

Line: 71

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
            p_error_message => 'FND_API.G_EXC_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 88

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
            p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 109

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
            p_error_message => 'OTHERS exception',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 156

        select project_id, task_id
        from po_distributions_all
        where po_distribution_id = x_distribution_id;

Line: 161

        select project_id, task_id
        from po_distributions_all
        where line_location_id = x_line_location_id;

Line: 377

                qa_skiplot_eval_engine.insert_rcv_results (
                p_interface_txn_id => p_interface_txn_id,
                p_manufacturer_id => p_manufacturer_id,
                p_receipt_qty => p_receipt_qty,
                p_criteriaID => criteriaID,
                p_insp_status => insp_status,
                p_receipt_date => sysdate,
                p_lotID => lotID,
                p_source_inspected => p_source_inspected,
                p_process_id => processID,
                p_lpn_id => p_lpn_id);

Line: 405

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
            p_error_message => 'FND_API.G_EXC_ERROR',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 422

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
            p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 436

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
            p_error_message => 'OTHERS exception ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 511

            update qa_skiplot_rcv_results
            set shipment_line_id = p_shipment_line_id,
            valid_flag = 2
            where interface_txn_id = p_interface_txn_id
            returning insp_lot_id into lotID;

Line: 519

            update qa_skiplot_lot_plans
            set shipment_line_id = p_shipment_line_id
            where insp_lot_id = lotID;

Line: 529

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
            p_error_message => 'FND_API.G_EXC_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 544

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
            p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 563

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
            p_error_message => 'OTHERS exception ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 596

        SELECT   count(qr.occurrence)
        FROM     qa_results qr
        WHERE    qr.collection_id = p_collection_id
                 AND qr.occurrence NOT IN (SELECT qprr.child_occurrence
                                           FROM qa_pc_results_relationship qprr);

Line: 649

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
            p_error_message => 'FND_API.G_EXC_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 664

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
            p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 683

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
            p_error_message => 'OTHERS exception ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 728

      SELECT count(qa.inspection_status)
        FROM qa_skiplot_rcv_results qa, rcv_transactions rt
       WHERE rt.interface_transaction_id = qa.interface_txn_id
         AND rt.shipment_line_id = qa.shipment_line_id
         AND qa.inspection_status = 'SKIPPED'
        AND rt.transaction_id = p_transaction_id;

Line: 784

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
            p_error_message => 'FND_API.G_EXC_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 799

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
            p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));

Line: 818

            qa_skiplot_utility.insert_error_log (
            p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
            p_error_message => 'OTHERS exception ',
            p_comments => SUBSTR (SQLERRM , 1 , 240));