APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on BIS_OBJ_INDEXES

Line 303: 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_log_name and OBJECT_TYPE='MVLOG' and INDEX_NAME=l_index_name;

299: exit when c_mv_log_index%NOTFOUND;
300:
301: if l_ddl is not null or l_ddl <> '' then
302: l_count := l_count+1;
303: 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_log_name and OBJECT_TYPE='MVLOG' and INDEX_NAME=l_index_name;
304: IF SQL%NOTFOUND THEN
305: 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)
306: values(p_mv_log_name, 'MVLOG', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);
307: END IF;

Line 305: 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)

301: if l_ddl is not null or l_ddl <> '' then
302: l_count := l_count+1;
303: 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_log_name and OBJECT_TYPE='MVLOG' and INDEX_NAME=l_index_name;
304: IF SQL%NOTFOUND THEN
305: 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)
306: values(p_mv_log_name, 'MVLOG', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);
307: END IF;
308: COMMIT;
309: WRITELOG('Captured Index '|| l_index_name || ' on MVLog ' || form_triplet(p_mv_log_name, P_mv_log_schema, 'MVLog') );

Line 404: DELETE bis_obj_indexes where OBJECT_NAME=l_mv_log_name and OBJECT_TYPE='MVLOG';

400: 'NOLOG') ;
401: WRITELOG('Wipe out MV log definition in RSG because patch dropped mv log after it had been recreated by RSG. Set status to ''NOLOG''');
402: -- aguwalan: bug#4898446
403: l_mv_log_name := get_mview_log_name(p_base_object_name, P_base_object_schema);
404: DELETE bis_obj_indexes where OBJECT_NAME=l_mv_log_name and OBJECT_TYPE='MVLOG';
405: WRITELOG('Also wiped out definition of Indexes(if any) on the MV log.');
406: else ---other status 'DROPPED','CAPTURED'
407:
408: ----We need to identify if the mv log is dropped by RSG or patch

Line 427: DELETE bis_obj_indexes where OBJECT_NAME=l_mv_log_name and OBJECT_TYPE='MVLOG';

423: 'NOLOG') ;
424: WRITELOG('Wipe out MV log definition in RSG because patch dropped mv log after last failed run. Set status to ''NOLOG''');
425: -- aguwalan: bug#4898446
426: l_mv_log_name := get_mview_log_name(p_base_object_name, P_base_object_schema);
427: DELETE bis_obj_indexes where OBJECT_NAME=l_mv_log_name and OBJECT_TYPE='MVLOG';
428: WRITELOG('Also wiped out definition of Indexes(if any) on MV log.');
429: else
430: --though mv patch being applied but not sure if the MV log is dropped by patch
431: ---report warning and keep MV log definition in RSG

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

535: l_index_ddl VARCHAR2(32767);
536: temp_index_ddl VARCHAR2(32767);
537: l_count NUMBER;
538: BEGIN
539: l_stmt := 'select INDEX_NAME, INDEX_SQL from BIS_OBJ_INDEXES where OBJECT_NAME='''
540: ||p_mv_log_name||
541: ''' and OBJECT_TYPE=''MVLOG'' and INDEX_SQL is not null';
542: l_count := 0;
543: open c_mv_log_index for l_stmt;