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_IMPL_OPT_PKG dependencies on BIS_OBJ_PROPERTIES

Line 20: update bis_obj_properties prop

16: IS
17: stmt varchar2(2000);
18: BEGIN
19:
20: update bis_obj_properties prop
21: set implementation_flag = 'Y'
22: where OBJECT_type = 'PAGE'
23: and OBJECT_NAME = p_object_name;
24:

Line 25: update bis_obj_properties

21: set implementation_flag = 'Y'
22: where OBJECT_type = 'PAGE'
23: and OBJECT_NAME = p_object_name;
24:
25: update bis_obj_properties
26: set implementation_flag = 'Y'
27: where (object_type, OBJECT_NAME)
28: in( select distinct
29: depend_object_type,

Line 46: update BIS_OBJ_PROPERTIES

42: p_object_type varchar2,
43: p_object_name varchar2)
44: IS
45: BEGIN
46: update BIS_OBJ_PROPERTIES
47: set implementation_flag = 'N'
48: where not exists (
49: -- back traverse and hit Pages that are implemented
50: (select distinct

Line 59: from BIS_OBJ_PROPERTIES tmp

55: where dep.enabled_flag= 'Y'
56: and dep.object_type = 'PAGE'
57: and exists (
58: select 1
59: from BIS_OBJ_PROPERTIES tmp
60: where tmp.OBJECT_NAME = dep.OBJECT_NAME
61: and tmp.OBJECT_TYPE = dep.object_type
62: and tmp.implementation_flag = 'Y'
63: )

Line 72: and BIS_OBJ_PROPERTIES.object_type = p_object_type

68: connect by dep.DEPEND_OBJECT_NAME = prior dep.object_name
69: AND dep.depend_object_type = PRIOR dep.object_type
70: )
71: )
72: and BIS_OBJ_PROPERTIES.object_type = p_object_type
73: and BIS_OBJ_PROPERTIES.object_NAME = p_object_name;
74: END;
75:
76:

Line 73: and BIS_OBJ_PROPERTIES.object_NAME = p_object_name;

69: AND dep.depend_object_type = PRIOR dep.object_type
70: )
71: )
72: and BIS_OBJ_PROPERTIES.object_type = p_object_type
73: and BIS_OBJ_PROPERTIES.object_NAME = p_object_name;
74: END;
75:
76:
77: PROCEDURE smartPrunImpl(

Line 109: update bis_obj_properties prop

105: p_object_name varchar2)
106: IS
107: stmt varchar2(2000);
108: BEGIN
109: update bis_obj_properties prop
110: set implementation_flag = 'N'
111: where OBJECT_type = 'PAGE'
112: and OBJECT_NAME = p_object_name;
113:

Line 136: 'update bis_obj_properties set IMPLEMENTATION_FLAG = :1

132: END IF;
133: */
134:
135: execute immediate
136: 'update bis_obj_properties set IMPLEMENTATION_FLAG = :1
137: where OBJECT_NAME = :2 AND object_type = :3'
138: using p_impl_flag, p_object_name, 'PAGE';
139: END;
140:

Line 228: update bis_obj_properties

224: ----can get rid of this API call.
225: procedure set_implflag_reports_in_set(p_set_name in varchar2,p_set_app_id in number) is
226:
227: l_sql varchar2(1000):='
228: update bis_obj_properties
229: set implementation_flag=''Y''
230: where object_type=''REPORT''
231: and object_name in (
232: select distinct object_name

Line 254: from bis_obj_properties

250:
251: procedure propagate_impl_flag_reports is
252: cursor c_impl_reports is
253: select object_name
254: from bis_obj_properties
255: where object_type='REPORT'
256: and implementation_flag='Y';
257:
258: /**

Line 261: from bis_obj_properties

257:
258: /**
259: cursor c_unimpl_reports is
260: select object_name
261: from bis_obj_properties
262: where object_type='REPORT'
263: and implementation_flag='N';
264: **/
265: cursor c_obj_under_reports (p_report_name varchar2) is

Line 290: update bis_obj_properties

286:
287: /** commented for bug 4664831
288: for l_unimpl_report_rec in c_unimpl_reports loop
289: for l_obj_under_report_rec in c_obj_under_reports(l_unimpl_report_rec.object_name) loop
290: update bis_obj_properties
291: set IMPLEMENTATION_FLAG ='N'
292: where object_type=l_obj_under_report_rec.depend_object_type
293: and object_name=l_obj_under_report_rec.depend_object_name;
294: end loop;

Line 300: update bis_obj_properties

296: **/
297:
298: for l_impl_report_rec in c_impl_reports loop
299: for l_obj_under_report_rec in c_obj_under_reports(l_impl_report_rec.object_name) loop
300: update bis_obj_properties
301: set IMPLEMENTATION_FLAG ='Y'
302: where object_type=l_obj_under_report_rec.depend_object_type
303: and object_name=l_obj_under_report_rec.depend_object_name;
304: end loop;

Line 332: bis_obj_properties properties

328: where enabled_flag='Y' ) obj
329: where object_type='PAGE'
330: START WITH depend_object_name =p_report_name AND depend_object_type ='REPORT'
331: CONNECT BY PRIOR object_name = depend_object_name AND PRIOR object_type = depend_object_type) pages,
332: bis_obj_properties properties
333: where pages.object_name=properties.object_name
334: and properties.object_type='PAGE'
335: and properties.implementation_flag='Y');
336:

Line 357: from bis_obj_properties

353: l_report_in_impl_pages varchar2(1);
354:
355: cursor c_reports_impl_null is
356: select object_name
357: from bis_obj_properties
358: where object_type='REPORT'
359: and implementation_flag is null;
360:
361: l_reports_rec c_reports_impl_null%rowtype;

Line 373: execute immediate 'update bis_obj_properties set IMPLEMENTATION_FLAG = ''Y''

369: ---the report should have impl flag set to Y automatically
370: for l_reports_rec in c_reports_impl_null loop
371: l_report_in_impl_pages:=report_in_impl_pages(l_reports_rec.object_name);
372: if l_report_in_impl_pages='Y' then
373: execute immediate 'update bis_obj_properties set IMPLEMENTATION_FLAG = ''Y''
374: where object_type=''REPORT'' and object_name=:1' using l_reports_rec.object_name;
375: end if;
376: end loop;
377:

Line 382: 'update bis_obj_properties set IMPLEMENTATION_FLAG = ''N''

378: -- Reset implementation flag. Note if implementation option flag is null, treat as N
379: ----Modified for enhancement 3999465 and 4422645
380: ----Exclude reports because we will have UI to set impl flag for reports
381: execute immediate
382: 'update bis_obj_properties set IMPLEMENTATION_FLAG = ''N''
383: WHERE (object_type not in ( ''PAGE'',''REPORT''))
384: OR implementation_flag IS NULL';
385:
386:

Line 390: 'update bis_obj_properties set IMPLEMENTATION_FLAG = :1

386:
387: ------set implementation flag to 'Y' for objects under implemented pages
388: ------Modified for enhancement 3999465 and 4422645. Exclude reports
389: execute immediate
390: 'update bis_obj_properties set IMPLEMENTATION_FLAG = :1
391: where object_type<> ''REPORT''
392: and (object_name, object_type) in (
393: select distinct dep.depend_object_name, dep.depend_object_type
394: from bis_obj_dependency dep

Line 398: from bis_obj_properties prop

394: from bis_obj_dependency dep
395: where dep.enabled_flag = :2
396: start with dep.object_type = :3
397: and exists (select 1
398: from bis_obj_properties prop
399: where prop.object_type = dep.object_type
400: and prop.object_name = dep.object_name
401: and prop.implementation_flag = :4)
402: connect by prior dep.depend_object_name = dep.object_name

Line 458: SELECT object_name FROM bis_obj_properties

454: CURSOR c_page_object_name(p_func_name VARCHAR2) IS
455: SELECT object_name FROM bis_obj_dependency
456: WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA'
457: UNION ALL
458: SELECT object_name FROM bis_obj_properties
459: WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA';
460:
461: v_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
462: BEGIN

Line 512: l_page_name bis_obj_properties.object_name%type;

508: where depend_objects.obj_type='REPORT';
509:
510: l_report_rec reports_under_page%rowtype;
511:
512: l_page_name bis_obj_properties.object_name%type;
513:
514: l_report_in_impl_pages varchar2(1);
515:
516: begin

Line 521: execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:2 and object_name=:3'

517: l_page_name:=get_page_name_by_func(p_page_function);
518: for l_report_rec in reports_under_page(l_page_name) loop
519: l_report_in_impl_pages:='N';
520: if p_impl_flag='Y' then
521: execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:2 and object_name=:3'
522: using 'Y','REPORT',l_report_rec.obj_name;
523: else ---p_impl_flag='N'
524: l_report_in_impl_pages:=report_in_impl_pages(l_report_rec.obj_name);
525: if l_report_in_impl_pages='N' then

Line 526: execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:2 and object_name=:3'

522: using 'Y','REPORT',l_report_rec.obj_name;
523: else ---p_impl_flag='N'
524: l_report_in_impl_pages:=report_in_impl_pages(l_report_rec.obj_name);
525: if l_report_in_impl_pages='N' then
526: execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:2 and object_name=:3'
527: using 'N','REPORT',l_report_rec.obj_name;
528: end if;
529: end if;
530: end loop;

Line 602: execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:1 and object_name=:2'

598: x_msg_data := 'BIS_BIA_INVALID_IMPL_FLAG';
599: RETURN;
600: END IF;
601:
602: execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:1 and object_name=:2'
603: using p_impl_flag,'REPORT' ,p_report_name;
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605: RETURN;
606: EXCEPTION

Line 635: FROM bis_obj_properties

631: AND objdep.ENABLED_FLAG = 'Y';
632:
633: CURSOR c_getimpl_flag (p_page_obj_name VARCHAR2) IS
634: SELECT Nvl (implementation_flag, 'N') implflag
635: FROM bis_obj_properties
636: WHERE object_type = 'PAGE' AND object_name = p_page_obj_name;
637: BEGIN
638: v_is_valid_page_func := is_valid_page_func(p_func_name);
639: --dbms_output.put_line('v_is_valid_page_func: '||v_is_valid_page_func);

Line 706: FROM bis_obj_properties

702: AND ENABLED_FLAG = 'Y');
703:
704: CURSOR c_getimpl_flag IS
705: SELECT object_name,implementation_flag implflag
706: FROM bis_obj_properties
707: WHERE object_type = 'REPORT' AND object_name = p_report_name;
708:
709: l_dummy varchar2(1);
710: l_prog_exist varchar2(1);

Line 712: l_object_name bis_obj_properties.object_name%type;

708:
709: l_dummy varchar2(1);
710: l_prog_exist varchar2(1);
711: l_report_in_impl_pages varchar2(1);
712: l_object_name bis_obj_properties.object_name%type;
713:
714: BEGIN
715: l_dummy:='N';
716: l_object_name:=null;

Line 742: ----at that moment the report in bis_obj_properties has implementation_flag as null

738: if v_ret_code is null then
739: if l_object_name is not null then
740: ----added for backward compatibility
741: --- For the case when a new report is added to an existing implemented page
742: ----at that moment the report in bis_obj_properties has implementation_flag as null
743: l_report_in_impl_pages:=report_in_impl_pages(p_report_name) ;
744: if l_report_in_impl_pages='Y' then
745: v_ret_code:='Y';
746: else

Line 788: FROM bis_obj_properties

784: v_page_name := get_page_name_by_func(p_func_name);
785:
786: -- for implementation flag, default null as 'N'
787: execute immediate 'select nvl(implementation_flag, :1) implflag
788: FROM bis_obj_properties
789: WHERE object_type = :2 AND object_name = :3'
790: INTO v_ret_code
791: using 'N','PAGE', v_page_name;
792:

Line 808: from bis_obj_properties where object_name=p_obj_name and object_type=p_obj_type;

804: l_impl_flag varchar2(1);
805: begin
806: select implementation_flag
807: into l_impl_flag
808: from bis_obj_properties where object_name=p_obj_name and object_type=p_obj_type;
809: return l_impl_flag;
810: exception
811: when no_data_found then
812: return 'N';

Line 824: (select 'Y' from bis_obj_properties

820: cursor l_check_impl is
821: select 'Y'
822: from dual
823: where exists
824: (select 'Y' from bis_obj_properties
825: where implementation_flag='Y'
826: and object_type in ('PAGE','REPORT')
827: ) ;
828: