223: -- M van der geest, added 18-OKT-2001
224: l_icx_lang VARCHAR2(30);
225:
226: -- bug 4097669, start 1
227: l_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
228: l_purchase_basis po_line_types_b.purchase_basis%TYPE;
229: l_matching_basis po_line_types_b.matching_basis%TYPE;
230: -- bug 4097669, end 1
231:
224: l_icx_lang VARCHAR2(30);
225:
226: -- bug 4097669, start 1
227: l_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
228: l_purchase_basis po_line_types_b.purchase_basis%TYPE;
229: l_matching_basis po_line_types_b.matching_basis%TYPE;
230: -- bug 4097669, end 1
231:
232: BEGIN
225:
226: -- bug 4097669, start 1
227: l_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
228: l_purchase_basis po_line_types_b.purchase_basis%TYPE;
229: l_matching_basis po_line_types_b.matching_basis%TYPE;
230: -- bug 4097669, end 1
231:
232: BEGIN
233: /* Insert */
261: matching_basis
262: INTO l_order_type_lookup_code,
263: l_purchase_basis,
264: l_matching_basis
265: FROM po_line_types_b
266: WHERE line_type_id = l_line_type_id;
267: -- bug 4097669, end 2
268: EXCEPTION
269: WHEN NO_DATA_FOUND THEN