APPS.QA_SKIPLOT_RCV_GRP dependencies on QA_SKIPLOT_RCV_RESULTS

Line 511: update qa_skiplot_rcv_results

507: -- with shipment line id
508: --
509:
510: if p_interface_txn_id is not null then
511: update qa_skiplot_rcv_results
512: set shipment_line_id = p_shipment_line_id,
513: valid_flag = 2
514: where interface_txn_id = p_interface_txn_id
515: returning insp_lot_id into lotID;

Line 729: FROM qa_skiplot_rcv_results qa, rcv_transactions rt

725: l_msg_data VARCHAR2(2400);
726:
727: CURSOR C1 IS
728: SELECT count(qa.inspection_status)
729: FROM qa_skiplot_rcv_results qa, rcv_transactions rt
730: WHERE rt.interface_transaction_id = qa.interface_txn_id
731: AND rt.shipment_line_id = qa.shipment_line_id
732: AND qa.inspection_status = 'SKIPPED'
733: AND rt.transaction_id = p_transaction_id;

Line 768: -- do a lookup in qa_skiplot_rcv_results and check

764: x_return_status := fnd_api.g_ret_sts_success;
765: x_skip_status := fnd_api.g_false;
766:
767: --
768: -- do a lookup in qa_skiplot_rcv_results and check
769: -- if the lot pertaining to the rcv_transaction_id
770: -- was skipped.
771: --
772: OPEN C1;