83: )
84: RETURN po_headers_all%ROWTYPE;
85:
86: FUNCTION get_pol_row_from_num(
87: p_line_num po_lines_all.line_num%TYPE,
88: p_header_id po_lines_all.po_header_id%TYPE,
89: p_item_description po_lines_all.item_description%TYPE,
90: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91: p_item_id po_lines_all.item_id%TYPE
84: RETURN po_headers_all%ROWTYPE;
85:
86: FUNCTION get_pol_row_from_num(
87: p_line_num po_lines_all.line_num%TYPE,
88: p_header_id po_lines_all.po_header_id%TYPE,
89: p_item_description po_lines_all.item_description%TYPE,
90: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91: p_item_id po_lines_all.item_id%TYPE
92: )
85:
86: FUNCTION get_pol_row_from_num(
87: p_line_num po_lines_all.line_num%TYPE,
88: p_header_id po_lines_all.po_header_id%TYPE,
89: p_item_description po_lines_all.item_description%TYPE,
90: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91: p_item_id po_lines_all.item_id%TYPE
92: )
93: RETURN po_lines_all%ROWTYPE;
86: FUNCTION get_pol_row_from_num(
87: p_line_num po_lines_all.line_num%TYPE,
88: p_header_id po_lines_all.po_header_id%TYPE,
89: p_item_description po_lines_all.item_description%TYPE,
90: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91: p_item_id po_lines_all.item_id%TYPE
92: )
93: RETURN po_lines_all%ROWTYPE;
94: -- Bug 7645326 Added item_id in the above Function
87: p_line_num po_lines_all.line_num%TYPE,
88: p_header_id po_lines_all.po_header_id%TYPE,
89: p_item_description po_lines_all.item_description%TYPE,
90: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91: p_item_id po_lines_all.item_id%TYPE
92: )
93: RETURN po_lines_all%ROWTYPE;
94: -- Bug 7645326 Added item_id in the above Function
95:
89: p_item_description po_lines_all.item_description%TYPE,
90: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91: p_item_id po_lines_all.item_id%TYPE
92: )
93: RETURN po_lines_all%ROWTYPE;
94: -- Bug 7645326 Added item_id in the above Function
95:
96: FUNCTION get_pol_row_from_id(
97: p_line_id IN po_lines_all.po_line_id%TYPE
93: RETURN po_lines_all%ROWTYPE;
94: -- Bug 7645326 Added item_id in the above Function
95:
96: FUNCTION get_pol_row_from_id(
97: p_line_id IN po_lines_all.po_line_id%TYPE
98: )
99: RETURN po_lines_all%ROWTYPE;
100:
101: FUNCTION get_pll_row_from_num(
95:
96: FUNCTION get_pol_row_from_id(
97: p_line_id IN po_lines_all.po_line_id%TYPE
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