APPS.OTA_TAV_API_BUSINESS_RULES dependencies on MTL_SYSTEM_ITEMS_B

Line 2020: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;

2016: p_organization_id in number
2017: )IS
2018: l_proc varchar2(72) := g_package||'check_OE_lines_exist';
2019: l_exists varchar2(1);
2020: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2021: l_old_organization_id mtl_system_items_b.organization_id%type;
2022: --
2023: -- cursor to check is inventory id is valid.
2024: --

Line 2021: l_old_organization_id mtl_system_items_b.organization_id%type;

2017: )IS
2018: l_proc varchar2(72) := g_package||'check_OE_lines_exist';
2019: l_exists varchar2(1);
2020: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2021: l_old_organization_id mtl_system_items_b.organization_id%type;
2022: --
2023: -- cursor to check is inventory id is valid.
2024: --
2025: cursor csr_order_line is

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

2104: -- ----------------------------------------------------------------------------
2105: --
2106: -- PUBLIC
2107: -- Description:
2108: -- If The inventory id is not a valid inventory id in MTL_SYSTEM_ITEMS_B table
2109: -- then user has to provide the correct one.
2110: --
2111: --
2112: --

Line 2121: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;

2117: p_organization_id in number
2118: )IS
2119: l_proc varchar2(72) := g_package||'check_Inventory_item_id';
2120: l_exists varchar2(1);
2121: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2122: l_old_organization_id mtl_system_items_b.organization_id%type;
2123: L_NUM number ;
2124: --
2125: -- cursor to check is inventory id is valid.

Line 2122: l_old_organization_id mtl_system_items_b.organization_id%type;

2118: )IS
2119: l_proc varchar2(72) := g_package||'check_Inventory_item_id';
2120: l_exists varchar2(1);
2121: l_old_inventory_item_id mtl_system_items_b.inventory_item_id%type;
2122: l_old_organization_id mtl_system_items_b.organization_id%type;
2123: L_NUM number ;
2124: --
2125: -- cursor to check is inventory id is valid.
2126: --

Line 2129: from mtl_system_items_b

2125: -- cursor to check is inventory id is valid.
2126: --
2127: cursor csr_inventory is
2128: select null
2129: from mtl_system_items_b
2130: where inventory_item_id = p_inventory_item_id and
2131: organization_id = p_organization_id;
2132:
2133: cursor csr_old_inventory is