APPS.BIS_COLL_RS_HISTORY dependencies on BIS_RS_STAGE_RUN_HISTORY_PKG

Line 217: BIS_RS_STAGE_RUN_HISTORY_PKG.Insert_Row

213:
214: --put stages data into history table
215: for c_stages_rec in c_stages loop
216:
217: BIS_RS_STAGE_RUN_HISTORY_PKG.Insert_Row
218: ( p_Request_set_id => c_stages_rec.Request_set_id
219: ,p_Set_app_id => c_stages_rec.Set_app_id
220: ,p_Stage_id => c_stages_rec.Stage_id
221: , p_Request_id => c_stages_rec.Request_id

Line 354: and (BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row (p_Request_id => l_rs_history_stage

350: , p_Completion_date => sysdate
351: , p_Last_update_date => sysdate
352: , p_Last_updated_by => g_current_user_id
353: , p_completion_text => g_completion_status))
354: and (BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row (p_Request_id => l_rs_history_stage
355: , p_Set_request_id =>l_root_request_id
356: , p_Completion_date => sysdate
357: , p_Status_code => 'C'
358: , p_phase_code => 'C'

Line 416: BIS_RS_STAGE_RUN_HISTORY_PKG.Delete_Row(rs_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);
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;

Line 964: if(BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row

960: end if;
961: end loop;
962:
963: for check_in_stages_rec in check_in_stages(p_root_req_id) loop
964: if(BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row
965: (p_Request_id => check_in_stages_rec.request_id ,
966: p_Set_request_id => p_root_req_id,
967: p_Last_update_date => sysdate,
968: p_Last_updated_by => g_current_user_id,

Line 1083: if (BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row(p_Request_id => c_stages_rec.request_id

1079: for c_stages_dates_rec in c_stages_dates(c_stages_rec.request_id) loop
1080: l_stage_start_date := c_stages_dates_rec.stage_start_date;
1081: l_stage_end_date := c_stages_dates_rec.stage_com_date;
1082: end loop;
1083: if (BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row(p_Request_id => c_stages_rec.request_id
1084: , p_Set_request_id => p_root_req_id
1085: , p_start_date => l_stage_start_date
1086: , p_Completion_date => l_stage_end_date
1087: , p_Last_update_date => sysdate