DBA Data[Home] [Help]

APPS.OPI_DBI_REP_UOM_PKG dependencies on INV_CONVERT

Line 98: l_to_quantity := inv_convert.inv_um_convert(l_eff_item_id, p_precision,

94: close base_uom_code;
95:
96: if ( l_from_class = l_to_class) then /* intraclass */
97:
98: l_to_quantity := inv_convert.inv_um_convert(l_eff_item_id, p_precision,
99: p_from_quantity, p_from_code, p_to_code, null, null);
100: else /* interclass */
101: if (l_eff_item_id <> 0) then
102: l_to_quantity := inv_convert.inv_um_convert(l_eff_item_id, p_precision,

Line 102: l_to_quantity := inv_convert.inv_um_convert(l_eff_item_id, p_precision,

98: l_to_quantity := inv_convert.inv_um_convert(l_eff_item_id, p_precision,
99: p_from_quantity, p_from_code, p_to_code, null, null);
100: else /* interclass */
101: if (l_eff_item_id <> 0) then
102: l_to_quantity := inv_convert.inv_um_convert(l_eff_item_id, p_precision,
103: p_from_quantity, p_from_code, p_to_code, null, null);
104: end if;
105:
106: if (l_to_quantity = -99999) then

Line 113: l_from_intra_rate := inv_convert.inv_um_convert(l_eff_item_id, p_precision, 1,

109: 1. use inv_conv api to get rate between from_uom and from_base_uom.
110: 2. use opi_dbi_uom_class_std_conv table to get rate between from_base_uom and to_base_uom.
111: 3. use inv_conv api to get rate between to_base_uom and to_uom. */
112:
113: l_from_intra_rate := inv_convert.inv_um_convert(l_eff_item_id, p_precision, 1,
114: p_from_code, l_from_base_code, null, null);
115: if ( l_from_intra_rate = -99999 ) then
116: RETURN (-99998);
117: end if;

Line 137: l_to_intra_rate := inv_convert.inv_um_convert(l_eff_item_id, p_precision, 1,

133: end if;
134:
135: close inter_conversions;
136:
137: l_to_intra_rate := inv_convert.inv_um_convert(l_eff_item_id, p_precision, 1,
138: l_to_base_code, p_to_code, null, null);
139:
140: if ( l_to_intra_rate = -99999 ) then
141: RETURN (-99996);