41: )
42: RETURN rcv_transactions%ROWTYPE;
43:
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
42: RETURN rcv_transactions%ROWTYPE;
43:
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: no_data_found_is_error IN BOOLEAN
43:
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: no_data_found_is_error IN BOOLEAN
51: )
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: no_data_found_is_error IN BOOLEAN
51: )
52: RETURN rcv_shipment_headers%ROWTYPE;
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: no_data_found_is_error IN BOOLEAN
51: )
52: RETURN rcv_shipment_headers%ROWTYPE;
53:
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: no_data_found_is_error IN BOOLEAN
51: )
52: RETURN rcv_shipment_headers%ROWTYPE;
53:
54: FUNCTION get_rsh_row_from_id(
55: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
56: )
51: )
52: RETURN rcv_shipment_headers%ROWTYPE;
53:
54: FUNCTION get_rsh_row_from_id(
55: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
56: )
57: RETURN rcv_shipment_headers%ROWTYPE;
58:
59: FUNCTION get_rsl_row_from_num(
53:
54: FUNCTION get_rsh_row_from_id(
55: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
56: )
57: RETURN rcv_shipment_headers%ROWTYPE;
58:
59: FUNCTION get_rsl_row_from_num(
60: p_line_num rcv_shipment_lines.line_num%TYPE,
61: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE