57: )
58: RETURN rcv_shipment_headers%ROWTYPE;
59:
60: FUNCTION get_rsl_row_from_num(
61: p_line_num rcv_shipment_lines.line_num%TYPE,
62: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
63: )
64: RETURN rcv_shipment_lines%ROWTYPE;
65:
58: RETURN rcv_shipment_headers%ROWTYPE;
59:
60: FUNCTION get_rsl_row_from_num(
61: p_line_num rcv_shipment_lines.line_num%TYPE,
62: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
63: )
64: RETURN rcv_shipment_lines%ROWTYPE;
65:
66: FUNCTION get_rsl_row_from_id(
60: FUNCTION get_rsl_row_from_num(
61: p_line_num rcv_shipment_lines.line_num%TYPE,
62: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
63: )
64: RETURN rcv_shipment_lines%ROWTYPE;
65:
66: FUNCTION get_rsl_row_from_id(
67: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
68: )
63: )
64: RETURN rcv_shipment_lines%ROWTYPE;
65:
66: FUNCTION get_rsl_row_from_id(
67: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
68: )
69: RETURN rcv_shipment_lines%ROWTYPE;
70:
71: PROCEDURE update_rsl_row(
65:
66: FUNCTION get_rsl_row_from_id(
67: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
68: )
69: RETURN rcv_shipment_lines%ROWTYPE;
70:
71: PROCEDURE update_rsl_row(
72: p_rsl_row IN rcv_shipment_lines%ROWTYPE
73: );
68: )
69: RETURN rcv_shipment_lines%ROWTYPE;
70:
71: PROCEDURE update_rsl_row(
72: p_rsl_row IN rcv_shipment_lines%ROWTYPE
73: );
74:
75: FUNCTION get_poh_row_from_num(
76: p_po_num po_headers_all.segment1%TYPE,