DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on INV_CONVERT

Line 1: PACKAGE BODY inv_convert AS

1: PACKAGE BODY inv_convert AS
2: /* $Header: INVUMCNB.pls 120.2.12010000.2 2008/07/29 13:47:55 ptkumar ship $ */
3: -- Bug # 3144743
4: -- Put away Performance Issue
5:

Line 21: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_CONVERT';

17: g_w_from_unit varchar2(10);
18: g_w_to_unit varchar2(10);
19: g_w_item_id varchar2(10);
20:
21: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_CONVERT';
22: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: INVUMCNB.pls 120.2.12010000.2 2008/07/29 13:47:55 ptkumar ship $';
23:
24: PROCEDURE inv_um_conversion (
25: from_unit varchar2,

Line 1318: inv_convert.inv_um_conversion(from_unit => p_from_uom_code,

1314: -- Conversion rate is cached so just use the value
1315: l_conversion_rate := g_item_uom_conversion_tb(p_item_id)(p_from_uom_code)(p_to_uom_code);
1316: ELSE
1317: -- Conversion rate is not cached so query and store the value
1318: inv_convert.inv_um_conversion(from_unit => p_from_uom_code,
1319: to_unit => p_to_uom_code,
1320: item_id => p_item_id,
1321: uom_rate => l_conversion_rate);
1322: IF (l_conversion_rate > 0) THEN

Line 1348: END inv_convert;

1344: RETURN -999;
1345: END inv_um_convert;
1346:
1347:
1348: END inv_convert;