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.10.12020000.6 2013/04/04 06:05:56 brana 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.10.12020000.6 2013/04/04 06:05:56 brana ship $';
23:
24: PROCEDURE inv_um_conversion (
25: from_unit varchar2,

Line 1258: ELSIF(NVL(inv_convert.is_uom_in_same_class(l_loc_uom, p_org_id , p_item_id , Nvl(l_fulfillment_base,'P')),'N') = 'N') THEN

1254: x_pick_qty := p_alloc_qty;
1255: x_return_status := 'W1'; --no loc level or sub level pick uom defined
1256: return;
1257: --MUOM
1258: ELSIF(NVL(inv_convert.is_uom_in_same_class(l_loc_uom, p_org_id , p_item_id , Nvl(l_fulfillment_base,'P')),'N') = 'N') THEN
1259: x_pick_uom := p_alloc_uom;
1260: x_pick_qty := p_alloc_qty;
1261: x_return_status := fnd_api.g_ret_sts_success;
1262: RETURN;

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

1615: -- Conversion rate is cached so just use the value
1616: l_conversion_rate := g_item_uom_conversion_tb(p_item_id)(p_from_uom_code)(p_to_uom_code);
1617: ELSE
1618: -- Conversion rate is not cached so query and store the value
1619: inv_convert.inv_um_conversion(from_unit => p_from_uom_code,
1620: to_unit => p_to_uom_code,
1621: item_id => p_item_id,
1622: uom_rate => l_conversion_rate);
1623: IF (l_conversion_rate > 0) THEN

Line 1933: END inv_convert;

1929:
1930: END create_uom_conversion;
1931:
1932:
1933: END inv_convert;