DBA Data[Home] [Help]

APPS.OPI_DBI_WMS_RTP_F_C dependencies on OPI_DBI_WMS_UTILITY_PKG

Line 117: else opi_dbi_wms_utility_pkg.get_uom_rate(

113: inventory_item_id,
114: primary_uom_code,
115: transaction_uom_code,
116: ( case when primary_uom_code = transaction_uom_code then 1
117: else opi_dbi_wms_utility_pkg.get_uom_rate(
118: inventory_item_id,
119: primary_uom_code,
120: transaction_uom_code
121: )

Line 170: else opi_dbi_wms_utility_pkg.get_uom_rate(

166: inventory_item_id,
167: primary_uom_code,
168: transaction_uom_code,
169: ( case when primary_uom_code = transaction_uom_code then 1
170: else opi_dbi_wms_utility_pkg.get_uom_rate(
171: inventory_item_id,
172: primary_uom_code,
173: transaction_uom_code
174: )

Line 207: if (opi_dbi_wms_utility_pkg.g_missing_uom) then

203: );
204:
205: end if;
206:
207: if (opi_dbi_wms_utility_pkg.g_missing_uom) then
208: opi_dbi_wms_utility_pkg.g_missing_uom := false;
209: errbuf := 'there are missing uom conversions';
210: raise_application_error (-20000, 'error in rates table collection: ' || errbuf);
211: end if;

Line 208: opi_dbi_wms_utility_pkg.g_missing_uom := false;

204:
205: end if;
206:
207: if (opi_dbi_wms_utility_pkg.g_missing_uom) then
208: opi_dbi_wms_utility_pkg.g_missing_uom := false;
209: errbuf := 'there are missing uom conversions';
210: raise_application_error (-20000, 'error in rates table collection: ' || errbuf);
211: end if;
212: