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