APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on DBA_INDEXES

Line 429: from dba_indexes din

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

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

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

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

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

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

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

Line 1166: FROM DBA_INDEXES aidx

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