APPS.MTL_INV_VALIDATE_GRP dependencies on MTL_ITEM_UOMS_VIEW

Line 1726: -- Look IN the TABLE MTL_ITEM_UOMS_VIEW

1722: -- API name : Validate_CountUOM
1723: -- TYPE : Private
1724: -- Pre-reqs : None
1725: -- FUNCTION :
1726: -- Look IN the TABLE MTL_ITEM_UOMS_VIEW
1727: -- IF the count_uom OR count_unit_of_measure IS
1728: -- presented, IF NOT it errors out.
1729: -- Parameters:
1730: -- IN :

Line 1776: L_unit_of_measure MTL_ITEM_UOMS_VIEW.unit_of_measure%type;

1772: -- Notes : Note text
1773: -- END OF comments
1774: DECLARE
1775: --
1776: L_unit_of_measure MTL_ITEM_UOMS_VIEW.unit_of_measure%type;
1777: L_uom MTL_ITEM_UOMS_VIEW.uom_code%type;
1778: L_counter integer := 0;
1779: --
1780: CURSOR L_ItemUom_Csr(code IN VARCHAR2, name IN VARCHAR2,

Line 1777: L_uom MTL_ITEM_UOMS_VIEW.uom_code%type;

1773: -- END OF comments
1774: DECLARE
1775: --
1776: L_unit_of_measure MTL_ITEM_UOMS_VIEW.unit_of_measure%type;
1777: L_uom MTL_ITEM_UOMS_VIEW.uom_code%type;
1778: L_counter integer := 0;
1779: --
1780: CURSOR L_ItemUom_Csr(code IN VARCHAR2, name IN VARCHAR2,
1781: org IN NUMBER, itemid IN NUMBER) IS

Line 1784: FROM mtl_item_uoms_view

1780: CURSOR L_ItemUom_Csr(code IN VARCHAR2, name IN VARCHAR2,
1781: org IN NUMBER, itemid IN NUMBER) IS
1782: SELECT
1783: UOM_CODE
1784: FROM mtl_item_uoms_view
1785: WHERE
1786: organization_id = org
1787: AND inventory_item_id = itemid
1788: AND(uom_code = code OR

Line 3417: FROM mtl_item_uoms_view

3413: , NAME IN VARCHAR2
3414: , org IN NUMBER
3415: , itemid IN NUMBER) IS
3416: SELECT uom_code
3417: FROM mtl_item_uoms_view
3418: WHERE organization_id = org
3419: AND inventory_item_id = itemid
3420: AND (uom_code = code OR unit_of_measure = NAME);
3421:

Line 3425: l_secondary_unit_of_measure mtl_item_uoms_view.unit_of_measure%TYPE;

3421:
3422: --
3423: l_api_version CONSTANT NUMBER := 0.9;
3424: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_SecondaryCountUOM';
3425: l_secondary_unit_of_measure mtl_item_uoms_view.unit_of_measure%TYPE;
3426: l_secondary_uom mtl_item_uoms_view.uom_code%TYPE;
3427: BEGIN
3428: -- Standard start of API savepoint
3429: SAVEPOINT validate_secondarycountuom;

Line 3426: l_secondary_uom mtl_item_uoms_view.uom_code%TYPE;

3422: --
3423: l_api_version CONSTANT NUMBER := 0.9;
3424: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_SecondaryCountUOM';
3425: l_secondary_unit_of_measure mtl_item_uoms_view.unit_of_measure%TYPE;
3426: l_secondary_uom mtl_item_uoms_view.uom_code%TYPE;
3427: BEGIN
3428: -- Standard start of API savepoint
3429: SAVEPOINT validate_secondarycountuom;
3430: