APPS.PO_LINE_TYPES_SV dependencies on PO_LINE_TYPES_B

Line 141: FROM po_line_types_b lt --

137: lt.unit_price,
138: nvl(lt.outside_operation_flag,'N'),
139: lt.receiving_flag,
140: lt.receive_close_tolerance
141: FROM po_line_types_b lt --
142: WHERE lt.line_type_id = p_line_type_id; --
143:
144: BEGIN
145:

Line 232: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;

228: , x_receiving_flag OUT NOCOPY VARCHAR2
229: , x_receive_close_tolerance OUT NOCOPY NUMBER
230: )
231: IS
232: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
233:
234: BEGIN
235:
236: PO_LINE_TYPES_SV.get_line_type_def

Line 288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;

284: , x_matching_basis OUT NOCOPY VARCHAR2
285: , x_outside_operation_flag OUT NOCOPY VARCHAR2
286: )
287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

Line 289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

285: , x_outside_operation_flag OUT NOCOPY VARCHAR2
286: )
287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:

Line 290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

286: )
287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN

Line 291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN
295:

Line 292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN
295:
296: PO_LINE_TYPES_SV.get_line_type_def

Line 328: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --

324: X_Outside_Operations_Flag IN OUT NOCOPY VARCHAR2,
325: X_Receiving_Flag IN OUT NOCOPY VARCHAR2,
326: X_Receive_close_tolerance IN OUT NOCOPY NUMBER)
327: IS
328: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --
329:
330: BEGIN
331:
332: -- Call to overloaded 'get_line_type_def' procedure.