DBA Data[Home] [Help]

APPS.BIS_COLL_RS_HISTORY dependencies on BIS_RS_RUN_HISTORY_PKG

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