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
62: )
63: RETURN rcv_shipment_lines%ROWTYPE;
64:
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
62: )
63: RETURN rcv_shipment_lines%ROWTYPE;
64:
65: FUNCTION get_rsl_row_from_id(
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
62: )
63: RETURN rcv_shipment_lines%ROWTYPE;
64:
65: FUNCTION get_rsl_row_from_id(
66: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
67: )
62: )
63: RETURN rcv_shipment_lines%ROWTYPE;
64:
65: FUNCTION get_rsl_row_from_id(
66: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
67: )
68: RETURN rcv_shipment_lines%ROWTYPE;
69:
70: PROCEDURE update_rsl_row(
64:
65: FUNCTION get_rsl_row_from_id(
66: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
67: )
68: RETURN rcv_shipment_lines%ROWTYPE;
69:
70: PROCEDURE update_rsl_row(
71: p_rsl_row IN rcv_shipment_lines%ROWTYPE
72: );
67: )
68: RETURN rcv_shipment_lines%ROWTYPE;
69:
70: PROCEDURE update_rsl_row(
71: p_rsl_row IN rcv_shipment_lines%ROWTYPE
72: );
73:
74: FUNCTION get_poh_row_from_num(
75: p_po_num po_headers_all.segment1%TYPE,