170: -- Bug 7457064
171: TYPE hash_map_tbl_typ IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
172: l_temp VARCHAR2(15);
173: l_index NUMBER;
174: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
175: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
176: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
177: l_pot_avail_tmp_hash_tbl hash_map_tbl_typ;
178: l_avail_tmp_hash_tbl hash_map_tbl_typ;
171: TYPE hash_map_tbl_typ IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
172: l_temp VARCHAR2(15);
173: l_index NUMBER;
174: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
175: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
176: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
177: l_pot_avail_tmp_hash_tbl hash_map_tbl_typ;
178: l_avail_tmp_hash_tbl hash_map_tbl_typ;
179:
172: l_temp VARCHAR2(15);
173: l_index NUMBER;
174: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
175: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
176: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
177: l_pot_avail_tmp_hash_tbl hash_map_tbl_typ;
178: l_avail_tmp_hash_tbl hash_map_tbl_typ;
179:
180: BEGIN