162: -- Bug 7457064
163: TYPE hash_map_tbl_typ IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
164: l_temp VARCHAR2(15);
165: l_index NUMBER;
166: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
167: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
168: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
169: l_pot_avail_tmp_hash_tbl hash_map_tbl_typ;
170: l_avail_tmp_hash_tbl hash_map_tbl_typ;
163: TYPE hash_map_tbl_typ IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
164: l_temp VARCHAR2(15);
165: l_index NUMBER;
166: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
167: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
168: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
169: l_pot_avail_tmp_hash_tbl hash_map_tbl_typ;
170: l_avail_tmp_hash_tbl hash_map_tbl_typ;
171:
164: l_temp VARCHAR2(15);
165: l_index NUMBER;
166: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
167: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
168: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;
169: l_pot_avail_tmp_hash_tbl hash_map_tbl_typ;
170: l_avail_tmp_hash_tbl hash_map_tbl_typ;
171:
172: BEGIN