APPS.POS_CANCEL_ASN dependencies on RCV_TRANSACTIONS_INTERFACE

Line 302: from rcv_transactions_interface rti,

298:
299:
300: CURSOR C_asn_attach (l_header_intf_id NUMBER) IS
301: select distinct rti.asn_attach_id
302: from rcv_transactions_interface rti,
303: fnd_attached_documents fad
304: where rti.header_interface_id = l_header_intf_id
305: and rti.asn_attach_id is not null
306: and to_char(rti.asn_attach_id) = fad.PK1_value

Line 343: from RCV_TRANSACTIONS_INTERFACE

339: CLOSE C_asn_attach;
340:
341: /* Delete ASN line from interface table. */
342: delete
343: from RCV_TRANSACTIONS_INTERFACE
344: where header_interface_id = x_header_interface_id;
345:
346: end if;
347:

Line 410: from RCV_TRANSACTIONS_INTERFACE rti,

406:
407: /* Get total number of lines pending cancellation */
408: select count(*)
409: into x_pending_cancel
410: from RCV_TRANSACTIONS_INTERFACE rti,
411: RCV_SHIPMENT_HEADERS rsh
412: where rti.transaction_type = 'CANCEL'
413: and rti.shipment_header_id = rsh.shipment_header_id
414: and rsh.shipment_num = p_shipment_num

Line 535: from rcv_transactions_interface

531: l_rti_error := 'N';
532:
533: select count(*)
534: into l_rti_line_count
535: from rcv_transactions_interface
536: where HEADER_INTERFACE_ID = p_header_id;
537:
538: select 'Y' into l_rti_error
539: from dual

Line 541: (select 1 from rcv_transactions_interface

537:
538: select 'Y' into l_rti_error
539: from dual
540: where exists
541: (select 1 from rcv_transactions_interface
542: where HEADER_INTERFACE_ID = p_header_id
543: and (processing_status_code = 'ERROR' or
544: transaction_status_code = 'ERROR'));
545:

Line 633: from RCV_TRANSACTIONS_INTERFACE rti,

629:
630: /* Get total number of lines pending cancellation */
631: select count(*)
632: into l_pending_cancel
633: from RCV_TRANSACTIONS_INTERFACE rti,
634: RCV_SHIPMENT_HEADERS rsh
635: where rti.transaction_type = 'CANCEL'
636: and rti.shipment_header_id = rsh.shipment_header_id
637: and rsh.shipment_num = p_shipment_num

Line 859: from RCV_TRANSACTIONS_INTERFACE rti,

855:
856: /* Get total number of lines pending cancellation */
857: select count(*)
858: into l_pending_cancel
859: from RCV_TRANSACTIONS_INTERFACE rti,
860: RCV_SHIPMENT_HEADERS rsh
861: where rti.transaction_type = 'CANCEL'
862: and rti.shipment_header_id = rsh.shipment_header_id
863: and rsh.shipment_num = p_shipment_num

Line 934: from RCV_TRANSACTIONS_INTERFACE

930: Where shipment_line_id = p_shipment_line_id;
931:
932: CURSOR c_transaction_type IS
933: select nvl(transaction_type, '')
934: from RCV_TRANSACTIONS_INTERFACE
935: where shipment_line_id = p_shipment_line_id;
936:
937: BEGIN
938: