DBA Data[Home] [Help]

APPS.IGC_CC_PO_INTERFACE_PKG dependencies on PO_LINE_TYPES_B

Line 227: l_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

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:

Line 228: l_purchase_basis po_line_types_b.purchase_basis%TYPE;

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

Line 229: l_matching_basis po_line_types_b.matching_basis%TYPE;

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 */

Line 265: FROM po_line_types_b

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