APPS.RRS_ELOCATION_PKG dependencies on ALL_INDEXES

Line 25: FROM sys.all_indexes

21: )
22: IS
23: CURSOR c_index(x_index_name IN VARCHAR2) IS
24: SELECT status, domidx_opstatus
25: FROM sys.all_indexes
26: WHERE owner = 'RRS' and index_name = x_index_name;
27: l_status sys.all_indexes.status%type;
28: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;
29: l_index_name varchar2(50);

Line 27: l_status sys.all_indexes.status%type;

23: CURSOR c_index(x_index_name IN VARCHAR2) IS
24: SELECT status, domidx_opstatus
25: FROM sys.all_indexes
26: WHERE owner = 'RRS' and index_name = x_index_name;
27: l_status sys.all_indexes.status%type;
28: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;
29: l_index_name varchar2(50);
30: l_commit_interval varchar2(5) := '1000';
31: x_drop_index varchar2(255);

Line 28: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;

24: SELECT status, domidx_opstatus
25: FROM sys.all_indexes
26: WHERE owner = 'RRS' and index_name = x_index_name;
27: l_status sys.all_indexes.status%type;
28: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;
29: l_index_name varchar2(50);
30: l_commit_interval varchar2(5) := '1000';
31: x_drop_index varchar2(255);
32: x_rebuild_string VARCHAR2(100);