DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on RCV_HEADERS_INTERFACE_S

Line 750: p_ship_from_location_code IN rcv_headers_interface.ship_from_location_code%TYPE,

746: RETURN NULL;
747: END get_vendor_site_code_from_id;
748:
749: FUNCTION get_sfloc_id_from_code(
750: p_ship_from_location_code IN rcv_headers_interface.ship_from_location_code%TYPE,
751: p_vendor_site_id IN rcv_headers_interface.vendor_site_id%TYPE,
752: p_column IN VARCHAR2,
753: p_marker IN OUT NOCOPY BOOLEAN
754: )

Line 755: RETURN rcv_headers_interface.ship_from_location_id%TYPE IS

751: p_vendor_site_id IN rcv_headers_interface.vendor_site_id%TYPE,
752: p_column IN VARCHAR2,
753: p_marker IN OUT NOCOPY BOOLEAN
754: )
755: RETURN rcv_headers_interface.ship_from_location_id%TYPE IS
756: x_ship_from_location_id rcv_headers_interface.ship_from_location_id%TYPE;
757: BEGIN
758: p_marker := FALSE;
759:

Line 756: x_ship_from_location_id rcv_headers_interface.ship_from_location_id%TYPE;

752: p_column IN VARCHAR2,
753: p_marker IN OUT NOCOPY BOOLEAN
754: )
755: RETURN rcv_headers_interface.ship_from_location_id%TYPE IS
756: x_ship_from_location_id rcv_headers_interface.ship_from_location_id%TYPE;
757: BEGIN
758: p_marker := FALSE;
759:
760: IF (p_ship_from_location_code IS NULL) THEN

Line 6976: SELECT rcv_headers_interface_s.NEXTVAL

6972: IF (rti.header_interface_id IS NOT NULL) THEN
6973: RETURN;
6974: END IF;
6975:
6976: SELECT rcv_headers_interface_s.NEXTVAL
6977: INTO rti.header_interface_id
6978: FROM DUAL;
6979:
6980: IF (rti.expected_receipt_date IS NULL) THEN