APPS.OTA_TAV_API_BUSINESS_RULES dependencies on MTL_SYSTEM_ITEMS_B

Line 2014: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;

2010: p_organization_id in number
2011: )IS
2012: l_proc varchar2(72) := g_package||'check_OE_lines_exist';
2013: l_exists varchar2(1);
2014: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2015: l_old_organization_id mtl_system_items_b.organization_id%type;
2016: --
2017: -- cursor to check is inventory id is valid.
2018: --

Line 2015: l_old_organization_id mtl_system_items_b.organization_id%type;

2011: )IS
2012: l_proc varchar2(72) := g_package||'check_OE_lines_exist';
2013: l_exists varchar2(1);
2014: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2015: l_old_organization_id mtl_system_items_b.organization_id%type;
2016: --
2017: -- cursor to check is inventory id is valid.
2018: --
2019: cursor csr_order_line is

Line 2102: -- If The inventory id is not a valid inventory id in MTL_SYSTEM_ITEMS_B table

2098: -- ----------------------------------------------------------------------------
2099: --
2100: -- PUBLIC
2101: -- Description:
2102: -- If The inventory id is not a valid inventory id in MTL_SYSTEM_ITEMS_B table
2103: -- then user has to provide the correct one.
2104: --
2105: --
2106: --

Line 2115: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;

2111: p_organization_id in number
2112: )IS
2113: l_proc varchar2(72) := g_package||'check_Inventory_item_id';
2114: l_exists varchar2(1);
2115: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2116: l_old_organization_id mtl_system_items_b.organization_id%type;
2117: L_NUM number ;
2118: --
2119: -- cursor to check is inventory id is valid.

Line 2116: l_old_organization_id mtl_system_items_b.organization_id%type;

2112: )IS
2113: l_proc varchar2(72) := g_package||'check_Inventory_item_id';
2114: l_exists varchar2(1);
2115: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2116: l_old_organization_id mtl_system_items_b.organization_id%type;
2117: L_NUM number ;
2118: --
2119: -- cursor to check is inventory id is valid.
2120: --

Line 2123: from mtl_system_items_b

2119: -- cursor to check is inventory id is valid.
2120: --
2121: cursor csr_inventory is
2122: select null
2123: from mtl_system_items_b
2124: where inventory_item_id = p_inventory_item_id and
2125: organization_id = p_organization_id;
2126:
2127: cursor csr_old_inventory is