APPS.AS_UTILITY_PVT dependencies on DBA_INDEXES

Line 23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type

19: pg_file_name VARCHAR2(100) := NULL;
20: pg_path_name VARCHAR2(100) := NULL;
21: pg_fp utl_file.file_type;
22:
23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type
24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type

Line 24: ,index_owner dba_indexes.owner%Type

20: pg_path_name VARCHAR2(100) := NULL;
21: pg_fp utl_file.file_type;
22:
23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type
24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type

Line 25: ,tbl_name dba_indexes.table_name%Type

21: pg_fp utl_file.file_type;
22:
23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type
24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type

Line 26: ,tbl_owner dba_indexes.table_owner%Type

22:
23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type
24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type
30: ,pct_free dba_indexes.pct_free%Type

Line 27: ,ts dba_indexes.tablespace_name%Type

23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type
24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type
30: ,pct_free dba_indexes.pct_free%Type
31: ,freelists dba_indexes.freelists%Type

Line 28: ,ini_trans dba_indexes.ini_trans%Type

24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type
30: ,pct_free dba_indexes.pct_free%Type
31: ,freelists dba_indexes.freelists%Type
32: ,int_ext number, next_ext number, min_ext number

Line 29: ,max_trans dba_indexes.max_trans%Type

25: ,tbl_name dba_indexes.table_name%Type
26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type
30: ,pct_free dba_indexes.pct_free%Type
31: ,freelists dba_indexes.freelists%Type
32: ,int_ext number, next_ext number, min_ext number
33: ,max_ext number, pct number, degree number

Line 30: ,pct_free dba_indexes.pct_free%Type

26: ,tbl_owner dba_indexes.table_owner%Type
27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type
30: ,pct_free dba_indexes.pct_free%Type
31: ,freelists dba_indexes.freelists%Type
32: ,int_ext number, next_ext number, min_ext number
33: ,max_ext number, pct number, degree number
34: ,indSql as_conc_request_messages.index_text%Type

Line 31: ,freelists dba_indexes.freelists%Type

27: ,ts dba_indexes.tablespace_name%Type
28: ,ini_trans dba_indexes.ini_trans%Type
29: ,max_trans dba_indexes.max_trans%Type
30: ,pct_free dba_indexes.pct_free%Type
31: ,freelists dba_indexes.freelists%Type
32: ,int_ext number, next_ext number, min_ext number
33: ,max_ext number, pct number, degree number
34: ,indSql as_conc_request_messages.index_text%Type
35: ,processed boolean := false);

Line 876: FROM dba_ind_columns col, dba_indexes ind

872: ceil(ind.initial_extent/1048576) intext, ceil(nvl(ind.next_extent/1048576,1)) nextext,
873: ind.min_extents minext, ind.max_extents maxext, nvl(ind.pct_increase,0) pct,
874: nvl(ind.ini_trans,1) ini_trans, nvl(ind.max_trans,255) max_trans,
875: nvl(ind.pct_free,20) pct_free, nvl(ind.freelists,1) freelists, ind.tablespace_name ts, ind.degree
876: FROM dba_ind_columns col, dba_indexes ind
877: WHERE ind.table_owner = p_tbl_owner
878: AND ind.table_name = p_tbl_name
879: AND ind.index_type = 'NORMAL'
880: AND col.index_owner = ind.owner

Line 892: FROM dba_ind_expressions exp, dba_indexes ind

888: ceil(ind.initial_extent/1048576) intext, ceil(nvl(ind.next_extent/1048576,1)) nextext,
889: ind.min_extents minext, ind.max_extents maxext, nvl(ind.pct_increase,0) pct,
890: nvl(ind.ini_trans,1) ini_trans, nvl(ind.max_trans,255) max_trans,
891: nvl(ind.pct_free,20) pct_free, nvl(ind.freelists,1) freelists, ind.tablespace_name ts, ind.degree
892: FROM dba_ind_expressions exp, dba_indexes ind
893: WHERE ind.table_owner = p_tbl_owner
894: AND ind.table_name = p_tbl_name
895: AND ind.index_type = 'FUNCTION-BASED NORMAL'
896: AND exp.index_owner = ind.owner

Line 948: AND NOT EXISTS (SELECT 'e' FROM dba_indexes i

944: SELECT index_name indname, index_owner owner, index_text indSql
945: FROM as_conc_request_messages o
946: WHERE table_name = p_tbl_name
947: AND table_owner = p_tbl_owner
948: AND NOT EXISTS (SELECT 'e' FROM dba_indexes i
949: WHERE i.index_name = o.index_name
950: AND i.owner = o.index_owner);
951:
952: CURSOR drop_index (p_tbl_name varchar2, p_tbl_owner varchar2) IS

Line 957: AND EXISTS (SELECT 'e' FROM dba_indexes i

953: SELECT index_name indname, index_owner owner, index_text indSql
954: FROM as_conc_request_messages o
955: WHERE table_name = p_tbl_name
956: AND table_owner = p_tbl_owner
957: AND EXISTS (SELECT 'e' FROM dba_indexes i
958: WHERE i.index_name = o.index_name
959: AND i.owner = o.index_owner);
960:
961: l_indRec indexRec;