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_CREATE_REQUESTSET dependencies on BIS_BIA_RSG_STAGE_OBJECTS

Line 290: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_STAGE_OBJECTS','TABLE');

286: ---clean up global temp table whenever a request set is to be created
287: ---bug 4724296
288: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_IMPL_FLAG_TEMP','TABLE');
289: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_IMPL_FLAG_TEMP';
290: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_STAGE_OBJECTS','TABLE');
291: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_STAGE_OBJECTS';
292:
293: exception
294: when others then

Line 291: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_STAGE_OBJECTS';

287: ---bug 4724296
288: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_IMPL_FLAG_TEMP','TABLE');
289: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_IMPL_FLAG_TEMP';
290: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_STAGE_OBJECTS','TABLE');
291: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_STAGE_OBJECTS';
292:
293: exception
294: when others then
295:

Line 491: l_sql_stmt := 'insert into BIS_BIA_RSG_STAGE_OBJECTS(set_name,set_app,stage_name,object_type,object_name)

487: l_stage:=null;
488: for l_obj_rec in c_objects_per_page loop
489: ---added for bug 4532066
490: if get_impl_flag_temp(p_set_name,p_set_app,p_object_type,p_object_name,l_obj_rec.object_type,l_obj_rec.object_name)='Y' then
491: l_sql_stmt := 'insert into BIS_BIA_RSG_STAGE_OBJECTS(set_name,set_app,stage_name,object_type,object_name)
492: values (:1,:2,:3,:4,:5)';
493: EXECUTE IMMEDIATE l_sql_stmt USING p_set_name,p_set_app,l_stage,l_obj_rec.object_type ,l_obj_rec.object_name;
494: end if;
495: end loop;

Line 2792: ---BIS_BIA_RSG_STAGE_OBJECTS

2788: l_min_stage number;
2789:
2790:
2791: ----For fixing bug 3647514. Store objects in set into global temp table
2792: ---BIS_BIA_RSG_STAGE_OBJECTS
2793: ----join to BIS_BIA_RSG_STAGE_OBJECTS when retrieve objects to analyze
2794: ---This cursor should also fetch those MVs that are refreshed by
2795: ----RSG generic MV refresh program
2796: cursor c_stage_objects(p_set_id number,p_set_app_id number,p_stage_id number,p_set_name varchar2,p_set_app varchar2) is

Line 2793: ----join to BIS_BIA_RSG_STAGE_OBJECTS when retrieve objects to analyze

2789:
2790:
2791: ----For fixing bug 3647514. Store objects in set into global temp table
2792: ---BIS_BIA_RSG_STAGE_OBJECTS
2793: ----join to BIS_BIA_RSG_STAGE_OBJECTS when retrieve objects to analyze
2794: ---This cursor should also fetch those MVs that are refreshed by
2795: ----RSG generic MV refresh program
2796: cursor c_stage_objects(p_set_id number,p_set_app_id number,p_stage_id number,p_set_name varchar2,p_set_app varchar2) is
2797: select distinct

Line 2804: BIS_BIA_RSG_STAGE_OBJECTS d

2800: from
2801: fnd_request_set_programs a,
2802: fnd_concurrent_programs b,
2803: bis_obj_prog_linkages c,
2804: BIS_BIA_RSG_STAGE_OBJECTS d
2805: where a.set_application_id=p_set_app_id
2806: and a.request_set_id=p_set_id
2807: and a.request_set_stage_id=p_stage_id
2808: and a.program_application_id=b.application_id