DBA Data[Home] [Help]

APPS.POS_CANCEL_ASN dependencies on RCV_HEADERS_INTERFACE

Line 203: from RCV_HEADERS_INTERFACE

199: l_rsl_line_count NUMBER := 0;
200:
201: CURSOR c_ASN_status IS
202: select processing_status_code, transaction_type
203: from RCV_HEADERS_INTERFACE
204: where shipment_num = p_shipment_num
205: and vendor_id = p_vendor_id
206: and vendor_site_id = p_vendor_site_id;
207:

Line 288: from rcv_headers_interface

284: x_header_interface_id NUMBER;
285:
286: CURSOR C_header_interface IS
287: select header_interface_id
288: from rcv_headers_interface
289: where shipment_num = p_shipment_num
290: and vendor_id = p_vendor_id
291: and vendor_site_id = p_vendor_site_id;
292:

Line 353: from RCV_HEADERS_INTERFACE

349: CLOSE C_header_interface;
350:
351: -- Delete records in header interface table.
352: delete
353: from RCV_HEADERS_INTERFACE
354: where shipment_num = p_shipment_num
355: and vendor_id = p_vendor_id
356: and vendor_site_id = p_vendor_site_id;
357:

Line 461: from RCV_HEADERS_INTERFACE

457:
458:
459: CURSOR c_ASN_status IS
460: select processing_status_code, transaction_type
461: from RCV_HEADERS_INTERFACE
462: where shipment_num = p_shipment_num
463: and header_interface_id = p_header_id
464: and vendor_id = p_vendor_id
465: and vendor_site_id = p_vendor_site_id;

Line 712: from RCV_HEADERS_INTERFACE

708: l_rsl_line_count NUMBER := 0;
709:
710: CURSOR c_ASN_status IS
711: select processing_status_code, transaction_type
712: from RCV_HEADERS_INTERFACE
713: where shipment_num = p_shipment_num
714: and vendor_id = p_vendor_id
715: and vendor_site_id = p_vendor_site_id;
716: