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_IMPL_FLAG_TEMP

Line 72: from BIS_BIA_RSG_IMPL_FLAG_TEMP

68: select 'Y'
69: from dual
70: where exists
71: (select 'Y'
72: from BIS_BIA_RSG_IMPL_FLAG_TEMP
73: where set_name=p_set_name
74: and set_app=p_set_app
75: and top_object_type=p_top_object_type
76: and top_object_name=p_top_object_name

Line 288: l_temp_table_owner:=bis_create_requestset.get_object_owner('BIS_BIA_RSG_IMPL_FLAG_TEMP','TABLE');

284: commit;
285:
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:

Line 289: execute immediate 'truncate table '||l_temp_table_owner||'.BIS_BIA_RSG_IMPL_FLAG_TEMP';

285:
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

Line 351: from BIS_BIA_RSG_IMPL_FLAG_TEMP

347: p_top_object_type varchar2,
348: p_top_object_name varchar2) is
349: cursor c_unimpl_reports is
350: select object_name
351: from BIS_BIA_RSG_IMPL_FLAG_TEMP
352: where set_name=p_set_name
353: and set_app=p_set_app
354: and top_object_type=p_top_object_type
355: and top_object_name=p_top_object_name

Line 361: from BIS_BIA_RSG_IMPL_FLAG_TEMP

357: and object_impl_flag='N';
358:
359: cursor c_impl_reports is
360: select object_name
361: from BIS_BIA_RSG_IMPL_FLAG_TEMP
362: where set_name=p_set_name
363: and set_app=p_set_app
364: and top_object_type=p_top_object_type
365: and top_object_name=p_top_object_name

Line 399: update BIS_BIA_RSG_IMPL_FLAG_TEMP

395: if object_not_linked_to_reports(p_top_object_name,
396: p_top_object_type,
397: l_obj_rec.depend_object_name,
398: l_obj_rec.depend_object_type)='N' then
399: update BIS_BIA_RSG_IMPL_FLAG_TEMP
400: set object_impl_flag='N'
401: where set_name=p_set_name
402: and set_app=p_set_app
403: and top_object_type=p_top_object_type

Line 414: update BIS_BIA_RSG_IMPL_FLAG_TEMP

410:
411:
412: for l_impl_report_rec in c_impl_reports loop
413: for l_obj_rec in c_obj_under_reports(l_impl_report_rec.object_name) loop
414: update BIS_BIA_RSG_IMPL_FLAG_TEMP
415: set object_impl_flag='Y'
416: where set_name=p_set_name
417: and set_app=p_set_app
418: and top_object_type=p_top_object_type

Line 475: l_sql_stmt:='insert into BIS_BIA_RSG_IMPL_FLAG_TEMP(set_name,set_app,top_object_type,top_object_name,object_type,object_name,object_impl_flag)

471: begin
472: ---added for bug 4610116
473: for l_obj_rec in c_objects_per_page loop
474: l_impl_flag:= BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.object_name,l_obj_rec.object_type);
475: l_sql_stmt:='insert into BIS_BIA_RSG_IMPL_FLAG_TEMP(set_name,set_app,top_object_type,top_object_name,object_type,object_name,object_impl_flag)
476: values (:1,:2,:3,:4,:5,:6,:7)';
477: EXECUTE IMMEDIATE l_sql_stmt USING p_set_name,p_set_app,p_object_type,p_object_name,l_obj_rec.object_type ,l_obj_rec.object_name,l_impl_flag;
478: end loop;
479:

Line 480: ---Process BIS_BIA_RSG_IMPL_FLAG_TEMP.

476: values (:1,:2,:3,:4,:5,:6,:7)';
477: EXECUTE IMMEDIATE l_sql_stmt USING p_set_name,p_set_app,p_object_type,p_object_name,l_obj_rec.object_type ,l_obj_rec.object_name,l_impl_flag;
478: end loop;
479:
480: ---Process BIS_BIA_RSG_IMPL_FLAG_TEMP.
481: ---Reset impl flag for objects within a page
482: ---The purpose is to exclude objects under an unimplemented report from a request set
483: if p_object_type='PAGE' then
484: process_impl_temp_table(p_set_name,p_set_app,p_object_type,p_object_name);