APPS.BIS_COLL_RS_HISTORY dependencies on BIS_OBJ_REFRESH_HISTORY

Line 119: BIS_OBJ_REFRESH_HISTORY obj

115: cursor c_refresh_mv is
116: select obj.prog_request_id request_id
117: from BIS_RS_PROG_RUN_HISTORY prog,
118: fnd_concurrent_programs fnd,
119: BIS_OBJ_REFRESH_HISTORY obj
120: where prog.set_request_id = l_root_request_id
121: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
122: and fnd.CONCURRENT_PROGRAM_NAME ='BIS_MV_REFRESH'
123: and obj.prog_request_id = prog.request_id

Line 322: if( BIS_OBJ_REFRESH_HISTORY_PKG.Update_Row

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

Line 411: BIS_OBJ_REFRESH_HISTORY_PKG.Delete_Row(rs_prog_run_rec.request_id);

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);

Line 557: BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row(p_Prog_request_id => x_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

Line 580: BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row(p_Prog_request_id => x_request_id

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

Line 1164: * inserting object data. Hence this api to populate this information in BIS_OBJ_REFRESH_HISTORY

1160: END update_report_date;
1161:
1162: /*
1163: * Bug#5195936 - For performance reasons, free tablespace & Row Count is no longer calculated while
1164: * inserting object data. Hence this api to populate this information in BIS_OBJ_REFRESH_HISTORY
1165: */
1166: PROCEDURE capture_object_info(p_root_request_id IN NUMBER) IS
1167: CURSOR get_objects IS
1168: SELECT object_name, object_type, prog_Request_id

Line 1169: FROM BIS_RS_PROG_RUN_HISTORY prog, BIS_OBJ_REFRESH_HISTORY obj

1165: */
1166: PROCEDURE capture_object_info(p_root_request_id IN NUMBER) IS
1167: CURSOR get_objects IS
1168: SELECT object_name, object_type, prog_Request_id
1169: FROM BIS_RS_PROG_RUN_HISTORY prog, BIS_OBJ_REFRESH_HISTORY obj
1170: WHERE set_request_id = p_root_request_id AND obj.prog_request_id = prog.request_id;
1171:
1172: --for objects data
1173: l_Object_row_count NUMBER;

Line 1188: l_success := BIS_OBJ_REFRESH_HISTORY_PKG.UPDATE_ROW(p_Prog_request_id => get_objects_rec.prog_Request_id

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