97: )
98: RETURN po_lines_all%ROWTYPE;
99:
100: FUNCTION get_pll_row_from_num(
101: p_shipment_num po_line_locations_all.shipment_num%TYPE,
102: p_line_id po_line_locations_all.po_line_id%TYPE
103: )
104: RETURN po_line_locations_all%ROWTYPE;
105:
98: RETURN po_lines_all%ROWTYPE;
99:
100: FUNCTION get_pll_row_from_num(
101: p_shipment_num po_line_locations_all.shipment_num%TYPE,
102: p_line_id po_line_locations_all.po_line_id%TYPE
103: )
104: RETURN po_line_locations_all%ROWTYPE;
105:
106: FUNCTION get_pll_row_from_id(
100: FUNCTION get_pll_row_from_num(
101: p_shipment_num po_line_locations_all.shipment_num%TYPE,
102: p_line_id po_line_locations_all.po_line_id%TYPE
103: )
104: RETURN po_line_locations_all%ROWTYPE;
105:
106: FUNCTION get_pll_row_from_id(
107: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
108: )
103: )
104: RETURN po_line_locations_all%ROWTYPE;
105:
106: FUNCTION get_pll_row_from_id(
107: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
108: )
109: RETURN po_line_locations_all%ROWTYPE;
110:
111: FUNCTION get_pod_row_from_num(
105:
106: FUNCTION get_pll_row_from_id(
107: p_line_location_id IN po_line_locations_all.line_location_id%TYPE
108: )
109: RETURN po_line_locations_all%ROWTYPE;
110:
111: FUNCTION get_pod_row_from_num(
112: p_distribution_num po_distributions_all.distribution_num%TYPE,
113: p_line_location_id po_distributions_all.line_location_id%TYPE