DBA Data[Home] [Help]

APPS.PO_REQIMP_PKG dependencies on MTL_UOM_CONVERSIONS

Line 35: mtl_uom_conversions.conversion_rate%TYPE,

31: po_requisitions_interface.unit_of_measure%TYPE,
32: x_unit_of_measure IN
33: po_requisitions_interface.unit_of_measure%TYPE,
34: x_to_rate OUT NOCOPY
35: mtl_uom_conversions.conversion_rate%TYPE,
36: x_item_uom_class OUT NOCOPY
37: mtl_uom_conversions.uom_class%TYPE,
38: x_from_rate OUT NOCOPY
39: mtl_uom_conversions.conversion_rate%TYPE,

Line 37: mtl_uom_conversions.uom_class%TYPE,

33: po_requisitions_interface.unit_of_measure%TYPE,
34: x_to_rate OUT NOCOPY
35: mtl_uom_conversions.conversion_rate%TYPE,
36: x_item_uom_class OUT NOCOPY
37: mtl_uom_conversions.uom_class%TYPE,
38: x_from_rate OUT NOCOPY
39: mtl_uom_conversions.conversion_rate%TYPE,
40: x_from_class OUT NOCOPY
41: mtl_uom_conversions.uom_class%TYPE)

Line 39: mtl_uom_conversions.conversion_rate%TYPE,

35: mtl_uom_conversions.conversion_rate%TYPE,
36: x_item_uom_class OUT NOCOPY
37: mtl_uom_conversions.uom_class%TYPE,
38: x_from_rate OUT NOCOPY
39: mtl_uom_conversions.conversion_rate%TYPE,
40: x_from_class OUT NOCOPY
41: mtl_uom_conversions.uom_class%TYPE)
42: IS
43: CURSOR l_conversion_rates

Line 41: mtl_uom_conversions.uom_class%TYPE)

37: mtl_uom_conversions.uom_class%TYPE,
38: x_from_rate OUT NOCOPY
39: mtl_uom_conversions.conversion_rate%TYPE,
40: x_from_class OUT NOCOPY
41: mtl_uom_conversions.uom_class%TYPE)
42: IS
43: CURSOR l_conversion_rates
44: IS SELECT NVL(t.conversion_rate,0),
45: t.uom_class,

Line 48: FROM mtl_uom_conversions t,

44: IS SELECT NVL(t.conversion_rate,0),
45: t.uom_class,
46: NVL(f.conversion_rate,0),
47: f.uom_class
48: FROM mtl_uom_conversions t,
49: mtl_uom_conversions f
50: WHERE t.inventory_item_id IN (x_item_id,0)
51: AND t.unit_of_measure = x_unit_of_purchase
52: AND f.inventory_item_id IN (x_item_id,0)

Line 49: mtl_uom_conversions f

45: t.uom_class,
46: NVL(f.conversion_rate,0),
47: f.uom_class
48: FROM mtl_uom_conversions t,
49: mtl_uom_conversions f
50: WHERE t.inventory_item_id IN (x_item_id,0)
51: AND t.unit_of_measure = x_unit_of_purchase
52: AND f.inventory_item_id IN (x_item_id,0)
53: AND f.unit_of_measure = x_unit_of_measure

Line 80: mtl_uom_conversions.conversion_rate%TYPE,

76:
77: PROCEDURE JA_AU_CONV_PRICE
78: (
79: x_from_rate IN
80: mtl_uom_conversions.conversion_rate%TYPE,
81: x_to_rate IN
82: mtl_uom_conversions.conversion_rate%TYPE,
83: x_class_rate IN
84: mtl_uom_class_conversions.conversion_rate%TYPE,

Line 82: mtl_uom_conversions.conversion_rate%TYPE,

78: (
79: x_from_rate IN
80: mtl_uom_conversions.conversion_rate%TYPE,
81: x_to_rate IN
82: mtl_uom_conversions.conversion_rate%TYPE,
83: x_class_rate IN
84: mtl_uom_class_conversions.conversion_rate%TYPE,
85: x_unit_price IN OUT NOCOPY
86: po_requisitions_interface.unit_price%TYPE

Line 119: mtl_uom_conversions.uom_class%TYPE,

115: PROCEDURE JA_AU_GET_CLASS_RATE
116: (x_item_id IN
117: po_requisitions_interface.item_id%TYPE,
118: x_item_uom_class IN
119: mtl_uom_conversions.uom_class%TYPE,
120: x_from_class IN
121: mtl_uom_conversions.uom_class%TYPE,
122: x_class_rate OUT NOCOPY
123: mtl_uom_class_conversions.conversion_rate%TYPE)

Line 121: mtl_uom_conversions.uom_class%TYPE,

117: po_requisitions_interface.item_id%TYPE,
118: x_item_uom_class IN
119: mtl_uom_conversions.uom_class%TYPE,
120: x_from_class IN
121: mtl_uom_conversions.uom_class%TYPE,
122: x_class_rate OUT NOCOPY
123: mtl_uom_class_conversions.conversion_rate%TYPE)
124: IS
125: BEGIN

Line 154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;

150: IS
151:
152: l_quantity po_requisitions_interface.quantity%TYPE;
153: l_unit_price po_requisitions_interface.unit_price%TYPE;
154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;
157: l_from_class mtl_uom_conversions.uom_class%TYPE;
158: l_item_uom_class mtl_uom_conversions.uom_class%TYPE;

Line 155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;

151:
152: l_quantity po_requisitions_interface.quantity%TYPE;
153: l_unit_price po_requisitions_interface.unit_price%TYPE;
154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;
157: l_from_class mtl_uom_conversions.uom_class%TYPE;
158: l_item_uom_class mtl_uom_conversions.uom_class%TYPE;
159: l_dummy char(1);

Line 157: l_from_class mtl_uom_conversions.uom_class%TYPE;

153: l_unit_price po_requisitions_interface.unit_price%TYPE;
154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;
157: l_from_class mtl_uom_conversions.uom_class%TYPE;
158: l_item_uom_class mtl_uom_conversions.uom_class%TYPE;
159: l_dummy char(1);
160:
161: BEGIN

Line 158: l_item_uom_class mtl_uom_conversions.uom_class%TYPE;

154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;
157: l_from_class mtl_uom_conversions.uom_class%TYPE;
158: l_item_uom_class mtl_uom_conversions.uom_class%TYPE;
159: l_dummy char(1);
160:
161: BEGIN
162: