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