APPS.BIS_BIA_RSG_INDEX_MGMT dependencies on BIS_OBJ_INDEXES

Line 128: l_index_name bis_obj_indexes.index_name%type;

124: l_length number;
125: l_stmt varchar2(32767);
126: TYPE curType IS REF CURSOR ;
127: c_all_index_details curType;
128: l_index_name bis_obj_indexes.index_name%type;
129: l_schema all_indexes.owner%type;
130: l_ddl clob;
131: begin
132: -- added to remove GSCC warning File.Sql.35

Line 158: update bis_obj_indexes set INDEX_SQL = l_ddl, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.User_id, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID where OBJECT_NAME=p_mv_name and OBJECT_TYPE='MV' and INDEX_NAME=l_index_name;

154: fetch c_all_index_details into l_index_name, l_schema, l_ddl;
155: exit when c_all_index_details%NOTFOUND;
156:
157: if l_ddl is not null or l_ddl <> '' then
158: update bis_obj_indexes set INDEX_SQL = l_ddl, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.User_id, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID where OBJECT_NAME=p_mv_name and OBJECT_TYPE='MV' and INDEX_NAME=l_index_name;
159: IF SQL%NOTFOUND THEN
160: INSERT INTO bis_obj_indexes( OBJECT_NAME, OBJECT_TYPE, INDEX_NAME, INDEX_SQL, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
161: values(p_mv_name, 'MV', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);
162: END IF;

Line 160: INSERT INTO bis_obj_indexes( OBJECT_NAME, OBJECT_TYPE, INDEX_NAME, INDEX_SQL, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

156:
157: if l_ddl is not null or l_ddl <> '' then
158: update bis_obj_indexes set INDEX_SQL = l_ddl, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.User_id, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID where OBJECT_NAME=p_mv_name and OBJECT_TYPE='MV' and INDEX_NAME=l_index_name;
159: IF SQL%NOTFOUND THEN
160: INSERT INTO bis_obj_indexes( OBJECT_NAME, OBJECT_TYPE, INDEX_NAME, INDEX_SQL, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
161: values(p_mv_name, 'MV', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);
162: END IF;
163: COMMIT;
164: drop_mv_index(l_index_name, p_mv_schema);

Line 235: l_stmt := 'select INDEX_NAME, INDEX_SQL from BIS_OBJ_INDEXES where OBJECT_NAME='''

231: setTimer(l_time);
232: WRITELOG('Recreating MV Index for ' || form_triplet(l_mv_name, l_mv_schema, null));
233:
234: -- bug 4312072
235: l_stmt := 'select INDEX_NAME, INDEX_SQL from BIS_OBJ_INDEXES where OBJECT_NAME='''
236: ||l_mv_name||
237: ''' and OBJECT_TYPE=''MV'' and INDEX_SQL is not null';
238:
239: open c_index_sql for l_stmt;