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,
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)
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
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,
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)
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
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,
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
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)
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
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;
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);
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
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: