APPS.RA_CUSTOMER_TEXT_PKG dependencies on ALL_INDEXES

Line 59: select STATUS , DOMIDX_OPSTATUS , PARAMETERS from all_indexes where index_name = 'HZ_CUST_ACCT_SITES_ALL_T1'

55: p_idx_cust_contacts IN VARCHAR2) IS
56:
57: cursor cust_index (p_schema IN VARCHAR2)is
58: /* Bug Fix: 4095863 */
59: select STATUS , DOMIDX_OPSTATUS , PARAMETERS from all_indexes where index_name = 'HZ_CUST_ACCT_SITES_ALL_T1'
60: and owner = p_schema;
61:
62: x_dummy BOOLEAN;
63: x_status varchar2(30);

Line 73: x_parameters all_indexes.parameters%TYPE;

69: l_count NUMBER := 0;
70: L_DATASTORE varchar2(30);
71: /* Bug Fix: 4095863 */
72: l_param_str varchar2(255);
73: x_parameters all_indexes.parameters%TYPE;
74: l_pos NUMBER := 0;
75: X_DROP_INDEX varchar2(255);
76: X_INDEX_STRING varchar2(255);
77: v_return_value BOOLEAN;