APPS.BIS_COLL_RS_HISTORY dependencies on BIS_RS_RUN_HISTORY

Line 62: from bis_rs_run_history rs,

58: req.actual_completion_date Completion_date,
59: req.Status_code Status_code,
60: req.phase_code phase_code,
61: req.completion_text Completion_text
62: from bis_rs_run_history rs,
63: fnd_request_set_stages stg,
64: fnd_concurrent_requests req
65: where rs.request_id = l_root_request_id
66: and rs.request_set_id = stg.request_set_id

Line 395: select request_id from BIS_RS_RUN_HISTORY

391: procedure purgeHistory is
392: history_days number;
393:
394: cursor rs_run is
395: select request_id from BIS_RS_RUN_HISTORY
396: where last_update_date <= (sysdate-history_days);
397:
398: cursor rs_prog_run(p_set_rq_id number) is
399: select request_id from BIS_RS_PROG_RUN_HISTORY

Line 419: BIS_RS_RUN_HISTORY_PKG.Delete_Row(sysdate-history_days);

415: BIS_RS_PROG_RUN_HISTORY_PKG.Delete_Row(rs_run_rec.request_id);
416: BIS_RS_STAGE_RUN_HISTORY_PKG.Delete_Row(rs_run_rec.request_id);
417: end loop;
418:
419: BIS_RS_RUN_HISTORY_PKG.Delete_Row(sysdate-history_days);
420: commit;
421:
422: EXCEPTION
423: when others then

Line 740: This inserts the record in the BIS_RS_RUN_HISTORY table.

736: end get_space_usage_details;
737:
738: /*
739: Enh#3473874
740: This inserts the record in the BIS_RS_RUN_HISTORY table.
741: This is called from history collection program if request set is of type gather statistics only
742: for all the case it will be called from preparation program
743: */
744:

Line 774: BIS_RS_RUN_HISTORY_PKG.Insert_Row(

770: open request_set_details;
771: fetch request_set_details into l_rs_phase_code,l_rs_status_code,l_completion_text;
772: close request_set_details;
773:
774: BIS_RS_RUN_HISTORY_PKG.Insert_Row(
775: p_Request_set_id => p_request_set_id
776: , p_Set_app_id => p_request_set_appl_id
777: , p_request_set_name=> p_request_name
778: , p_Request_id => p_root_req_id

Line 852: select 1 from BIS_RS_RUN_HISTORY

848: *********/
849:
850: FUNCTION if_program_already_ran(l_root_request_id IN NUMBER ) RETURN BOOLEAN IS
851: cursor if_program_ran is
852: select 1 from BIS_RS_RUN_HISTORY
853: where REQUEST_ID = l_root_request_id and PHASE_CODE = 'C';
854: prog_ran_rec if_program_ran%rowtype;
855:
856: l_program_already_ran boolean := false;

Line 995: select request_id from BIS_RS_RUN_HISTORY

991: */
992: PROCEDURE update_terminated_rs is
993:
994: cursor terminate_rs is
995: select request_id from BIS_RS_RUN_HISTORY
996: where phase_code ='R' ;
997: terminate_rs_rec terminate_rs%rowtype;
998:
999: cursor req_details(req_no number) is

Line 1016: if(BIS_RS_RUN_HISTORY_PKG.Update_Row( p_Request_id => terminate_rs_rec.request_id

1012:
1013: BEGIN
1014: for terminate_rs_rec in terminate_rs loop
1015: for req_details_rec in req_details(terminate_rs_rec.request_id) loop
1016: if(BIS_RS_RUN_HISTORY_PKG.Update_Row( p_Request_id => terminate_rs_rec.request_id
1017: ,p_Completion_date => req_details_rec.ACTUAL_COMPLETION_DATE
1018: ,p_Phase_code => req_details_rec.phase_code
1019: ,p_Status_code => req_details_rec.status_code
1020: ,p_Last_update_date => sysdate

Line 1070: l_status_code BIS_RS_RUN_HISTORY.status_code%type;

1066: where STAGE_REQUEST_ID =stage_req_id;
1067:
1068: is_request_err boolean :=false;
1069: is_request_warn boolean :=false;
1070: l_status_code BIS_RS_RUN_HISTORY.status_code%type;
1071: l_Completion_text varchar2(2000);
1072: l_stage_start_date Date;
1073: l_stage_end_date Date;
1074: BEGIN

Line 1123: if(BIS_RS_RUN_HISTORY_PKG.Update_Row( p_Request_id => p_root_req_id

1119: OPEN c_get_rs_start_time;
1120: FETCH c_get_rs_start_time INTO rs_start_date;
1121: CLOSE c_get_rs_start_time;
1122:
1123: if(BIS_RS_RUN_HISTORY_PKG.Update_Row( p_Request_id => p_root_req_id
1124: ,p_start_date => rs_start_date
1125: ,p_Completion_date => sysdate
1126: ,p_Phase_code => 'C'
1127: ,p_Status_code => l_status_code