DBA Data[Home] [Help]

APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 34: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

30: PROCEDURE INSERT_MTL_ITEM_SUBINV( p_organization_id IN number
31: , p_user_id IN number
32: , p_last_run_date IN date)
33: IS
34: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
38: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

Line 35: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE

31: , p_user_id IN number
32: , p_last_run_date IN date)
33: IS
34: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
38: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;
39: TYPE user_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

Line 206: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

202: PROCEDURE DELETE_MTL_ITEM_SUBINV( p_organization_id IN number
203: , p_user_id IN number
204: , p_last_run_date IN date)
205: IS
206: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
207: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
208: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
209: l_inventory_items_tbl inventory_item_tbl_typ;
210: l_organizations_tbl organization_tbl_typ;

Line 207: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;

203: , p_user_id IN number
204: , p_last_run_date IN date)
205: IS
206: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
207: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
208: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
209: l_inventory_items_tbl inventory_item_tbl_typ;
210: l_organizations_tbl organization_tbl_typ;
211: l_sec_inventory_tbl secondary_inventory_typ;