APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on ALL_INDEXES

Line 936: Cursor c_all_indexes(cl_table_name varchar2, cl_owner varchar2) IS

932: group by p.dea_attr_products_id, p.attr_relation_product
933: )
934: where NON_NULL_TAE_COL_MAPS = cp_non_null_tae_col_maps;
935:
936: Cursor c_all_indexes(cl_table_name varchar2, cl_owner varchar2) IS
937: select index_name
938: from all_indexes
939: where table_name = cl_table_name
940: and table_owner = cl_owner;

Line 938: from all_indexes

934: where NON_NULL_TAE_COL_MAPS = cp_non_null_tae_col_maps;
935:
936: Cursor c_all_indexes(cl_table_name varchar2, cl_owner varchar2) IS
937: select index_name
938: from all_indexes
939: where table_name = cl_table_name
940: and table_owner = cl_owner;
941:
942:

Line 1040: FOR c1 IN c_all_indexes(p_table_name, l_ora_username) LOOP

1036: -- debug message
1037: jty_log(FND_LOG.LEVEL_STATEMENT,
1038: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',
1039: 'Existing Indexes');
1040: FOR c1 IN c_all_indexes(p_table_name, l_ora_username) LOOP
1041: jty_log(FND_LOG.LEVEL_STATEMENT,
1042: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',
1043: 'Index Name : ' || c1.index_name);
1044: END LOOP;