DBA Data[Home] [Help]

APPS.BIS_COLL_RS_HISTORY dependencies on BIS_RS_PROG_RUN_HISTORY_PKG

Line 345: if((BIS_RS_PROG_RUN_HISTORY_PKG.Update_Row( p_Set_request_id => l_root_request_id

341: OPEN c_get_stage(FND_GLOBAL.conc_request_id);
342: FETCH c_get_stage into l_rs_history_stage;
343: CLOSE c_get_stage;
344:
345: if((BIS_RS_PROG_RUN_HISTORY_PKG.Update_Row( p_Set_request_id => l_root_request_id
346: , p_Stage_request_id => l_rs_history_stage
347: , p_Request_id => FND_GLOBAL.conc_request_id
348: , p_Status_code => 'C'
349: , p_Phase_code => 'C'

Line 415: BIS_RS_PROG_RUN_HISTORY_PKG.Delete_Row(rs_run_rec.request_id);

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

Line 508: BIS_RS_PROG_RUN_HISTORY_PKG.Insert_Row

504: fetch request_id_exists into request_id;
505: if (x_request_id is not null) then
506: l_root_request_id := x_set_request_id;
507: if (request_id_exists%NOTFOUND) then
508: BIS_RS_PROG_RUN_HISTORY_PKG.Insert_Row
509: ( p_Set_request_id => l_root_request_id
510: , p_Stage_request_id => x_stage_req_id
511: , p_Request_id => x_request_id
512: , p_Program_id => req_details_rec.concurrent_program_id

Line 526: if (BIS_RS_PROG_RUN_HISTORY_PKG.update_row

522: , p_completion_text => req_details_rec.completion_text
523: );
524: else
525: --if request already exists then update status code , completion date and stage id.
526: if (BIS_RS_PROG_RUN_HISTORY_PKG.update_row
527: ( p_Set_request_id => l_root_request_id
528: , p_Stage_request_id => x_stage_req_id
529: , p_Request_id => x_request_id
530: , p_Status_code => req_details_rec.Status_code

Line 948: if(BIS_RS_PROG_RUN_HISTORY_PKG.Update_Row

944: check_in_stages_rec check_in_stages%rowtype;
945:
946: BEGIN
947: for check_in_progs_rec in check_in_progs(p_root_req_id) loop
948: if(BIS_RS_PROG_RUN_HISTORY_PKG.Update_Row
949: ( p_Set_request_id => p_root_req_id,
950: p_Stage_request_id => check_in_progs_rec.STAGE_REQUEST_ID,
951: p_Request_id => check_in_progs_rec.request_id,
952: p_Last_update_date => sysdate,