DBA Data[Home] [Help]

APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

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

24: PROCEDURE INSERT_MTL_ITEM_SUBINV( p_organization_id IN number
25: , p_user_id IN number
26: , p_last_run_date IN date)
27: IS
28: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
29: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
32: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

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

25: , p_user_id IN number
26: , p_last_run_date IN date)
27: IS
28: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
29: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
32: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;
33: TYPE user_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

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

196: PROCEDURE DELETE_MTL_ITEM_SUBINV( p_organization_id IN number
197: , p_user_id IN number
198: , p_last_run_date IN date)
199: IS
200: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
201: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
202: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
203: l_inventory_items_tbl inventory_item_tbl_typ;
204: l_organizations_tbl organization_tbl_typ;

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

197: , p_user_id IN number
198: , p_last_run_date IN date)
199: IS
200: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
201: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
202: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
203: l_inventory_items_tbl inventory_item_tbl_typ;
204: l_organizations_tbl organization_tbl_typ;
205: l_sec_inventory_tbl secondary_inventory_typ;