117: --**********************************************************************************************
118:
119: PROCEDURE load_subinventory IS
120:
121: type t_wlji_org1 is table of wsm_subinventory_extensions.organization_id%type;
122: type t_wlji_compl_subinv is table of wsm_subinventory_extensions.secondary_inventory_name%type;
123:
124: v_wlji_org1 t_wlji_org1 := t_wlji_org1();
125: v_wlji_compl_subinv t_wlji_compl_subinv := t_wlji_compl_subinv();
118:
119: PROCEDURE load_subinventory IS
120:
121: type t_wlji_org1 is table of wsm_subinventory_extensions.organization_id%type;
122: type t_wlji_compl_subinv is table of wsm_subinventory_extensions.secondary_inventory_name%type;
123:
124: v_wlji_org1 t_wlji_org1 := t_wlji_org1();
125: v_wlji_compl_subinv t_wlji_compl_subinv := t_wlji_compl_subinv();
126:
126:
127: cursor c_wsm_subinv is
128: select organization_id,
129: secondary_inventory_name
130: from wsm_subinventory_extensions;
131:
132: str VARCHAR2(100); -- assuming that to_char(org_id)||subinventory has length < 100
133: hash_value NUMBER;
134: v_index NUMBER;