APPS.RCV_FTE_CALL_PVT SQL Statements

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

Line: 38

        rcv_fte_txn_lines_pvt.insert_row(
            p_shipment_header_id,
            p_shipment_line_id,
            l_txn_id,
            p_action,
            'Y');

Line: 65

        SELECT transaction_id
        INTO l_txn_id
        FROM rcv_transactions
        WHERE shipment_header_id = p_shipment_header_id
        AND transaction_type = l_rcv_txn
        AND interface_transaction_id = p_interface_id
        AND rownum = 1;

Line: 75

        SELECT parent.transaction_type
        INTO l_txn_type
        FROM rcv_transactions parent, rcv_transactions child
        WHERE child.transaction_id = l_txn_id
        AND parent.transaction_id = child.parent_transaction_id;

Line: 90

        SELECT count(rsl.shipment_line_id)
        INTO l_valid_lines
        FROM rcv_shipment_lines rsl,
             rcv_shipment_headers rsh,
             po_headers_all poh,
             po_lines_all pol,
             po_line_types_b plb
        WHERE
            rsh.shipment_header_id = p_shipment_header_id
        AND (rsl.shipment_line_id = p_shipment_line_id OR p_shipment_line_id IS NULL)
        AND rsl.shipment_header_id = rsh.shipment_header_id
        AND rsl.po_header_id = poh.po_header_id
        AND rsl.po_line_id = pol.po_line_id
        AND poh.type_lookup_code IN ('STANDARD', 'BLANKET')
        AND poh.shipping_control IS NOT NULL
        AND pol.line_type_id = plb.line_type_id
        AND plb.order_type_lookup_code = 'QUANTITY';

Line: 119

        SELECT asn_type
        INTO l_is_asn
        FROM rcv_shipment_headers
        WHERE shipment_header_id = p_shipment_header_id;

Line: 126

            SELECT count(*)
            INTO l_has_receipt
            FROM rcv_fte_transaction_lines
            WHERE action = 'RECEIPT'
            AND reported_flag = 'Y'
            AND header_id = p_shipment_header_id;

Line: 143

        SELECT count(*)
        INTO l_has_receipt
        FROM rcv_fte_transaction_lines
        WHERE action = 'RECEIPT_ADD'
        AND header_id = p_shipment_header_id;

Line: 161

    rcv_fte_txn_lines_pvt.insert_row(
        p_shipment_header_id,
        p_shipment_line_id,
        l_txn_id,
        l_action);

Line: 169

        po_delrec_pvt.create_update_delrec(
            1.0,
            l_return_status,
            l_msg_count,
            l_msg_data,
            l_action,
            'RCV',
            l_action,
            p_shipment_header_id,
            p_shipment_line_id,
            null);

Line: 184

            rcv_fte_txn_lines_pvt.update_record_to_reported(
                p_shipment_header_id,
                p_shipment_line_id,
                l_action);

Line: 189

            rcv_fte_txn_lines_pvt.update_record_to_failed(
                p_shipment_header_id,
                p_shipment_line_id,
                l_action);

Line: 207

        SELECT a.header_id, a.action
        FROM rcv_fte_transaction_lines a, rcv_fte_transaction_lines b
        WHERE a.reported_flag  IN ('N','U')
        AND a.header_id = b.header_id
        AND b.reported_flag = 'N'
        GROUP BY a.header_id, a.action;

Line: 217

        po_delrec_pvt.create_update_delrec(
            1.0,
            l_return_status,
            l_msg_count,
            l_msg_data,
            call.action,
            'RCV',
            call.action,
            call.header_id,
            null,
            null);

Line: 233

            rcv_fte_txn_lines_pvt.update_record_to_reported(
                call.header_id,
                null,
                call.action);

Line: 238

            rcv_fte_txn_lines_pvt.update_record_to_unreported(
                call.header_id,
                null,
                call.action);