[Home] [Help]
318: fetch c_consider_mv into consider_mv_req;
319: close c_consider_mv ;
320:
321: for c_refresh_mv_rec in c_refresh_mv loop
322: if( BIS_OBJ_REFRESH_HISTORY_PKG.Update_Row
323: ( p_Prog_request_id => c_refresh_mv_rec.request_id
324: ,p_new_Prog_request_id => consider_mv_req
325: ,p_Last_update_date => sysdate
326: ,p_Last_updated_by => g_current_user_id )) then
407:
408: for rs_run_rec in rs_run loop
409: --delete object data first
410: for rs_prog_run_rec in rs_prog_run(rs_run_rec.request_id) loop
411: BIS_OBJ_REFRESH_HISTORY_PKG.Delete_Row(rs_prog_run_rec.request_id);
412: end loop;
413:
414: -- then delete program data and stage data
415: BIS_RS_PROG_RUN_HISTORY_PKG.Delete_Row(rs_run_rec.request_id);
553: ,p_Object_space_usage => l_Object_space_usage
554: ,p_Tablespace_name => l_Tablespace_name
555: ,p_Free_tablespace_size => l_Free_tablespace_size);
556: */
557: BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row(p_Prog_request_id => x_request_id
558: ,p_Object_type => x_object_type
559: ,p_Object_name => x_object_name
560: ,p_Refresh_type => x_refresh_type
561: ,p_Object_row_count => l_Object_row_count
576: ,p_Object_space_usage => l_Object_space_usage
577: ,p_Tablespace_name => l_Tablespace_name
578: ,p_Free_tablespace_size => l_Free_tablespace_size
579: );
580: BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row(p_Prog_request_id => x_request_id
581: ,p_Object_type => c_objects_rec.obj_type
582: ,p_Object_name => c_objects_rec.obj_name
583: ,p_Refresh_type => c_objects_rec.obj_refresh_mode
584: ,p_Object_row_count => l_Object_row_count
1184: ,p_Object_space_usage => l_Object_space_usage
1185: ,p_Tablespace_name => l_Tablespace_name
1186: ,p_Free_tablespace_size => l_Free_tablespace_size);
1187:
1188: l_success := BIS_OBJ_REFRESH_HISTORY_PKG.UPDATE_ROW(p_Prog_request_id => get_objects_rec.prog_Request_id
1189: ,p_Object_type => get_objects_rec.object_type
1190: ,p_Object_name => get_objects_rec.object_name
1191: ,p_Object_row_count => l_Object_row_count
1192: ,p_Object_space_usage => l_Object_space_usage