DBA Data[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on PA_PLSQL_DATATYPES

Line 166: l_resource_id_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 167: l_pot_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;

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:

Line 168: l_avail_tmp_tbl PA_PLSQL_DATATYPES.NumTabTyp;

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