eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_COLL_RS_HISTORY dependencies on FND_CONCURRENT

Line 64: fnd_concurrent_requests req

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
67: and req.argument3 = stg.request_set_stage_id
68: and req.parent_request_id = rs.request_id ;

Line 80: from fnd_concurrent_requests req,

76: req.request_id Request_id ,
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:

Line 93: from fnd_concurrent_requests req,

89: req.request_id Request_id ,
90: req.parent_request_id parent_request_id,
91: req.CONCURRENT_PROGRAM_ID program_id,
92: prog.STAGE_REQUEST_ID stage_req_id
93: from fnd_concurrent_requests req,
94: BIS_RS_PROG_RUN_HISTORY prog
95: where --(req.parent_request_id is not null) and
96: req.parent_request_id = prog.request_id
97: and (instr(l_parent_request_ids,to_char(req.parent_request_id)||',') <> 0);

Line 103: from fnd_concurrent_programs

99: c_sub_programs_Rec c_sub_programs%rowtype;
100:
101: cursor c_get_program_id is
102: select CONCURRENT_PROGRAM_ID
103: from fnd_concurrent_programs
104: where concurrent_program_name ='FNDGTST'
105: and APPLICATION_ID =0;
106:
107: cursor c_obj_type(l_object_name varchar2 ) is

Line 118: fnd_concurrent_programs fnd,

114: --for MVs of type consider refresh
115: cursor c_refresh_mv is
116: select obj.prog_request_id request_id
117: from BIS_RS_PROG_RUN_HISTORY prog,
118: fnd_concurrent_programs fnd,
119: BIS_OBJ_REFRESH_HISTORY obj
120: where prog.set_request_id = l_root_request_id
121: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
122: and fnd.CONCURRENT_PROGRAM_NAME ='BIS_MV_REFRESH'

Line 121: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID

117: from BIS_RS_PROG_RUN_HISTORY prog,
118: fnd_concurrent_programs fnd,
119: BIS_OBJ_REFRESH_HISTORY obj
120: where prog.set_request_id = l_root_request_id
121: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
122: and fnd.CONCURRENT_PROGRAM_NAME ='BIS_MV_REFRESH'
123: and obj.prog_request_id = prog.request_id
124: and obj.Refresh_type = 'CONSIDER_REFRESH';
125:

Line 122: and fnd.CONCURRENT_PROGRAM_NAME ='BIS_MV_REFRESH'

118: fnd_concurrent_programs fnd,
119: BIS_OBJ_REFRESH_HISTORY obj
120: where prog.set_request_id = l_root_request_id
121: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
122: and fnd.CONCURRENT_PROGRAM_NAME ='BIS_MV_REFRESH'
123: and obj.prog_request_id = prog.request_id
124: and obj.Refresh_type = 'CONSIDER_REFRESH';
125:
126: c_refresh_mv_rec c_refresh_mv%rowtype;

Line 134: from fnd_concurrent_programs

130: from BIS_RS_PROG_RUN_HISTORY
131: where set_request_id = l_root_request_id
132: and PROG_APP_ID =191
133: and program_id = ( select CONCURRENT_PROGRAM_ID
134: from fnd_concurrent_programs
135: where CONCURRENT_PROGRAM_NAME ='BIS_MV_DUMMY_REFRESH' and APPLICATION_ID =191);
136:
137: -- get_stage
138: cursor c_get_stage(p_prog_req_id in number) is

Line 166: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

162: p_root_request_id => l_root_request_id )) then
163: --BIS_COLLECTION_UTILITIES.put_line('Request set id '||l_req_set_id||' Application ID '||l_req_app_id );
164: p_dummy_flag := 'Y';
165: else
166: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
167: BIS_COLLECTION_UTILITIES.put_line('Given request id is not valid');
168: return;
169: end if;
170: BIS_COLLECTION_UTILITIES.put_line('********Program is running as the part of the request set***********');

Line 185: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

181:
182: -- see if given parameters are valid
183: if( l_req_app_id is null OR l_req_set_id is null) then
184: BIS_COLLECTION_UTILITIES.put_line('Given request id '||Root_request_id|| ' is not valid');
185: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
186: return;
187: end if;
188:
189: -- see if program has already ran. if yes then return

Line 192: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

188:
189: -- see if program has already ran. if yes then return
190: if (if_program_already_ran(l_root_request_id)) then
191: BIS_COLLECTION_UTILITIES.put_line('History data has been already collected for ' ||l_root_request_id);
192: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
193: return;
194: end if;
195: else
196: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

Line 196: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

192: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
193: return;
194: end if;
195: else
196: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
197: BIS_COLLECTION_UTILITIES.put_line('History data will not be collected because either given request id '||Root_request_id|| ' is not valid or Request set has been terminated.');
198: return;
199: end if;
200:

Line 384: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

380: --update request_set table for completion status and date data.
381: update_rs_stage_dates(l_root_request_id);
382: errbuf := sqlerrm;
383: retcode := sqlcode;
384: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
385: end rsg_history_report;
386:
387: /*
388: Enh#3473874

Line 461: from fnd_concurrent_requests req, fnd_concurrent_programs prog

457: actual_start_date,
458: actual_completion_date,
459: completion_text,
460: concurrent_program_name
461: from fnd_concurrent_requests req, fnd_concurrent_programs prog
462: where request_id = x_request_id and req.concurrent_program_id = prog.concurrent_program_id
463: and req.program_application_id = prog.application_id;
464:
465: req_details_rec request_details%rowtype;

Line 478: fnd_concurrent_programs fnd,

474: select linkage.OBJECT_TYPE obj_type,
475: linkage.object_name obj_name,
476: linkage.refresh_mode obj_refresh_mode
477: from BIS_RS_PROG_RUN_HISTORY prog,
478: fnd_concurrent_programs fnd,
479: bis_obj_prog_linkages linkage
480: where prog.request_id = x_request_id
481: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
482: and prog.prog_app_id = fnd.application_id

Line 481: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID

477: from BIS_RS_PROG_RUN_HISTORY prog,
478: fnd_concurrent_programs fnd,
479: bis_obj_prog_linkages linkage
480: where prog.request_id = x_request_id
481: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
482: and prog.prog_app_id = fnd.application_id
483: and linkage.CONC_PROGRAM_NAME = fnd.CONCURRENT_PROGRAM_NAME
484: and linkage.CONC_APP_ID = fnd.application_id
485: and linkage.ENABLED_FLAG = 'Y'

Line 483: and linkage.CONC_PROGRAM_NAME = fnd.CONCURRENT_PROGRAM_NAME

479: bis_obj_prog_linkages linkage
480: where prog.request_id = x_request_id
481: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
482: and prog.prog_app_id = fnd.application_id
483: and linkage.CONC_PROGRAM_NAME = fnd.CONCURRENT_PROGRAM_NAME
484: and linkage.CONC_APP_ID = fnd.application_id
485: and linkage.ENABLED_FLAG = 'Y'
486: and fnd.CONCURRENT_PROGRAM_NAME not in ('BIS_MV_REFRESH','BIS_RSG_PREP','BIS_RSG_FINAL',
487: 'BIS_BIA_RSG_VALIDATION','BIS_BIA_RSG_MLOG_CAD',

Line 486: and fnd.CONCURRENT_PROGRAM_NAME not in ('BIS_MV_REFRESH','BIS_RSG_PREP','BIS_RSG_FINAL',

482: and prog.prog_app_id = fnd.application_id
483: and linkage.CONC_PROGRAM_NAME = fnd.CONCURRENT_PROGRAM_NAME
484: and linkage.CONC_APP_ID = fnd.application_id
485: and linkage.ENABLED_FLAG = 'Y'
486: and fnd.CONCURRENT_PROGRAM_NAME not in ('BIS_MV_REFRESH','BIS_RSG_PREP','BIS_RSG_FINAL',
487: 'BIS_BIA_RSG_VALIDATION','BIS_BIA_RSG_MLOG_CAD',
488: 'BIS_MV_DUMMY_REFRESH','BIS_LAST_REFRESH_DATE_CONC',
489: 'BIS_BIA_RSG_LOG_MGMNT','FNDGTST','BSC_DELETE_DATA_IND',
490: 'BSC_REFRESH_DIM_IND','BSC_REFRESH_SUMMARY_IND','BIS_BIA_STATS_TABLE');

Line 753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;

749: IS
750: l_refresh_mode varchar2(30);
751: l_force_full_refresh varchar2(30);
752: l_request_set_id number;
753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;
754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is

Line 754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;

750: l_refresh_mode varchar2(30);
751: l_force_full_refresh varchar2(30);
752: l_request_set_id number;
753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;
754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is
758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests

Line 755: l_completion_text fnd_concurrent_requests.completion_text%type;

751: l_force_full_refresh varchar2(30);
752: l_request_set_id number;
753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;
754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is
758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests
759: where request_id = p_root_req_id;

Line 758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests

754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is
758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests
759: where request_id = p_root_req_id;
760:
761: BEGIN
762: l_refresh_mode :=

Line 888: fnd_concurrent_requests req

884: req.argument2,
885: req.status_code,
886: req.phase_code
887: from
888: fnd_concurrent_requests req
889: where
890: req.request_id = p_req_id
891: and req.argument4 is null;
892:

Line 900: l_status_code fnd_concurrent_requests.status_code%type;

896: where application_id = p_request_set_appl_id and request_set_id = p_request_set_id;
897:
898: get_rs_details_rec get_rs_details%rowtype;
899:
900: l_status_code fnd_concurrent_requests.status_code%type;
901: l_phase_code fnd_concurrent_requests.phase_code%type;
902:
903: BEGIN
904:

Line 901: l_phase_code fnd_concurrent_requests.phase_code%type;

897:
898: get_rs_details_rec get_rs_details%rowtype;
899:
900: l_status_code fnd_concurrent_requests.status_code%type;
901: l_phase_code fnd_concurrent_requests.phase_code%type;
902:
903: BEGIN
904:
905: open is_req_valid(p_root_request_id);

Line 1005: fnd_concurrent_requests

1001: phase_code,
1002: status_code,
1003: completion_text
1004: from
1005: fnd_concurrent_requests
1006: where
1007: request_id =req_no and
1008: phase_code ='C' and
1009: status_code ='X';