APPS.BIS_COLL_RS_HISTORY dependencies on BIS_RS_STAGE_RUN_HISTORY

Line 81: bis_rs_stage_run_history stg

77: req.CONCURRENT_PROGRAM_ID program_id,
78: req.argument1 obj_owner,
79: req.argument2 obj_name
80: from fnd_concurrent_requests req,
81: bis_rs_stage_run_history stg
82: where stg.set_request_id = l_root_request_id
83: and stg.request_id = req.parent_request_id ;
84:
85: c_program_rec c_programs%rowtype;

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 941: select request_id from BIS_RS_STAGE_RUN_HISTORY

937:
938: check_in_progs_rec check_in_progs%rowtype;
939:
940: cursor check_in_stages(root_req_id number) is
941: select request_id from BIS_RS_STAGE_RUN_HISTORY
942: where SET_REQUEST_ID = root_req_id and
943: status_code = 'G' ;
944: check_in_stages_rec check_in_stages%rowtype;
945:

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 1047: select status_code from BIS_RS_STAGE_RUN_HISTORY

1043: where set_request_id =p_root_req_id
1044: and (status_code ='E' or status_code ='G')
1045: --added for Bug 4173989
1046: union
1047: select status_code from BIS_RS_STAGE_RUN_HISTORY
1048: where set_request_id = p_root_req_id
1049: and (status_code ='E' or status_code ='G') ;
1050:
1051: cursor c_get_rs_start_time is

Line 1053: from bis_rs_stage_run_history stg

1049: and (status_code ='E' or status_code ='G') ;
1050:
1051: cursor c_get_rs_start_time is
1052: select min(stg.start_date) start_date
1053: from bis_rs_stage_run_history stg
1054: where SET_REQUEST_ID = p_root_req_id;
1055:
1056: rs_start_date date;
1057:

Line 1060: from bis_rs_stage_run_history stg

1056: rs_start_date date;
1057:
1058: cursor c_stages is
1059: select request_id
1060: from bis_rs_stage_run_history stg
1061: where SET_REQUEST_ID = p_root_req_id;
1062:
1063: cursor c_stages_dates(stage_req_id number) is
1064: select min(START_DATE) stage_start_date, max(COMPLETION_DATE) stage_com_date

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