161: TYPE char1_tab IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
162: TYPE number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
163: TYPE relRecTabTyp IS TABLE OF relRecTyp INDEX BY BINARY_INTEGER;
164:
165: TYPE query_type_table_type IS TABLE OF wms_saved_queries.query_type%TYPE INDEX BY BINARY_INTEGER;
166: TYPE field_name_table_type IS TABLE OF wms_saved_queries.field_name%TYPE INDEX BY BINARY_INTEGER;
167: TYPE field_value_table_type IS TABLE OF wms_saved_queries.field_value%TYPE INDEX BY BINARY_INTEGER;
168: TYPE organization_id_table_type IS TABLE OF wms_saved_queries.organization_id%TYPE INDEX BY BINARY_INTEGER;
169:
162: TYPE number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
163: TYPE relRecTabTyp IS TABLE OF relRecTyp INDEX BY BINARY_INTEGER;
164:
165: TYPE query_type_table_type IS TABLE OF wms_saved_queries.query_type%TYPE INDEX BY BINARY_INTEGER;
166: TYPE field_name_table_type IS TABLE OF wms_saved_queries.field_name%TYPE INDEX BY BINARY_INTEGER;
167: TYPE field_value_table_type IS TABLE OF wms_saved_queries.field_value%TYPE INDEX BY BINARY_INTEGER;
168: TYPE organization_id_table_type IS TABLE OF wms_saved_queries.organization_id%TYPE INDEX BY BINARY_INTEGER;
169:
170: -- PUBLIC VARIABLES
163: TYPE relRecTabTyp IS TABLE OF relRecTyp INDEX BY BINARY_INTEGER;
164:
165: TYPE query_type_table_type IS TABLE OF wms_saved_queries.query_type%TYPE INDEX BY BINARY_INTEGER;
166: TYPE field_name_table_type IS TABLE OF wms_saved_queries.field_name%TYPE INDEX BY BINARY_INTEGER;
167: TYPE field_value_table_type IS TABLE OF wms_saved_queries.field_value%TYPE INDEX BY BINARY_INTEGER;
168: TYPE organization_id_table_type IS TABLE OF wms_saved_queries.organization_id%TYPE INDEX BY BINARY_INTEGER;
169:
170: -- PUBLIC VARIABLES
171: --
164:
165: TYPE query_type_table_type IS TABLE OF wms_saved_queries.query_type%TYPE INDEX BY BINARY_INTEGER;
166: TYPE field_name_table_type IS TABLE OF wms_saved_queries.field_name%TYPE INDEX BY BINARY_INTEGER;
167: TYPE field_value_table_type IS TABLE OF wms_saved_queries.field_value%TYPE INDEX BY BINARY_INTEGER;
168: TYPE organization_id_table_type IS TABLE OF wms_saved_queries.organization_id%TYPE INDEX BY BINARY_INTEGER;
169:
170: -- PUBLIC VARIABLES
171: --
172: release_table relRecTabTyp;