APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on DBA_INDEXES

Line 428: from dba_indexes din

424: x_Return_Status OUT NOCOPY VARCHAR2 ) IS
425:
426: CURSOR index_name_c (p_table_name VARCHAR2, p_owner VARCHAR2) IS
427: select din.index_name, din.owner
428: from dba_indexes din
429: where din.table_name = p_table_name
430: and din.table_owner = p_owner
431: and exists (
432: select 1

Line 447: TYPE l_index_name_type IS TABLE OF dba_indexes.index_name%TYPE;

443: and index_owner = p_owner
444: and column_position <> 1
445: order by column_position;
446:
447: TYPE l_index_name_type IS TABLE OF dba_indexes.index_name%TYPE;
448: TYPE l_owner_type IS TABLE OF dba_indexes.owner%TYPE;
449: TYPE l_column_name_type IS TABLE OF dba_ind_columns.column_name%TYPE;
450: TYPE l_column_position_type IS TABLE OF dba_ind_columns.column_position%TYPE;
451:

Line 448: TYPE l_owner_type IS TABLE OF dba_indexes.owner%TYPE;

444: and column_position <> 1
445: order by column_position;
446:
447: TYPE l_index_name_type IS TABLE OF dba_indexes.index_name%TYPE;
448: TYPE l_owner_type IS TABLE OF dba_indexes.owner%TYPE;
449: TYPE l_column_name_type IS TABLE OF dba_ind_columns.column_name%TYPE;
450: TYPE l_column_position_type IS TABLE OF dba_ind_columns.column_position%TYPE;
451:
452: l_index_name l_index_name_type;

Line 1160: ** 1. ALL_INDEXES (instead of SYS.DBA_INDEXES)

1156: l_industry VARCHAR2(30);
1157: l_jtf_schema VARCHAR2(30);
1158:
1159: /* JDOCHERT: 5/28/02: Modified to use:
1160: ** 1. ALL_INDEXES (instead of SYS.DBA_INDEXES)
1161: ** 2. aidx.table_owner (instead of aidx.owner)
1162: ** 3. return aidx.owner in SELECT */
1163: Cursor getIndexList(p_jtf_schema varchar2) IS
1164: SELECT aidx.owner, aidx.INDEX_NAME

Line 1165: FROM DBA_INDEXES aidx

1161: ** 2. aidx.table_owner (instead of aidx.owner)
1162: ** 3. return aidx.owner in SELECT */
1163: Cursor getIndexList(p_jtf_schema varchar2) IS
1164: SELECT aidx.owner, aidx.INDEX_NAME
1165: FROM DBA_INDEXES aidx
1166: WHERE aidx.table_name = p_table_name
1167: AND aidx.table_owner = p_jtf_schema
1168: AND aidx.index_name not in ('JTF_TAE_TN1002_CASE_N1W', 'JTF_TAE_TN1003_CASE_N1W', 'JTF_TAE_TN1004_CASE_N1W');
1169: