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_DEPENDENCY

Line 31: from bis_obj_dependency

27: where (object_type, OBJECT_NAME)
28: in( select distinct
29: depend_object_type,
30: depend_OBJECT_NAME
31: from bis_obj_dependency
32: where enabled_flag='Y'
33: start with object_type='PAGE'
34: and object_name = p_object_name
35: connect by prior DEPEND_OBJECT_NAME = object_name

Line 54: from bis_obj_dependency dep

50: (select distinct
51: dep.object_owner,
52: dep.object_type,
53: dep.OBJECT_NAME
54: from bis_obj_dependency dep
55: where dep.enabled_flag= 'Y'
56: and dep.object_type = 'PAGE'
57: and exists (
58: select 1

Line 80: l_depend_object_type bis_obj_dependency.depend_OBJECT_TYPE%type;

76:
77: PROCEDURE smartPrunImpl(
78: p_object_name varchar2)
79: IS
80: l_depend_object_type bis_obj_dependency.depend_OBJECT_TYPE%type;
81: l_depend_object_name bis_obj_dependency.depend_OBJECT_NAME%type;
82:
83: CURSOR C_DISIMPLGRP ( P_PGNAME bis_obj_dependency.object_name%type )
84: IS

Line 81: l_depend_object_name bis_obj_dependency.depend_OBJECT_NAME%type;

77: PROCEDURE smartPrunImpl(
78: p_object_name varchar2)
79: IS
80: l_depend_object_type bis_obj_dependency.depend_OBJECT_TYPE%type;
81: l_depend_object_name bis_obj_dependency.depend_OBJECT_NAME%type;
82:
83: CURSOR C_DISIMPLGRP ( P_PGNAME bis_obj_dependency.object_name%type )
84: IS
85: select distinct

Line 83: CURSOR C_DISIMPLGRP ( P_PGNAME bis_obj_dependency.object_name%type )

79: IS
80: l_depend_object_type bis_obj_dependency.depend_OBJECT_TYPE%type;
81: l_depend_object_name bis_obj_dependency.depend_OBJECT_NAME%type;
82:
83: CURSOR C_DISIMPLGRP ( P_PGNAME bis_obj_dependency.object_name%type )
84: IS
85: select distinct
86: depend_object_type,
87: depend_OBJECT_NAME

Line 88: from bis_obj_dependency

84: IS
85: select distinct
86: depend_object_type,
87: depend_OBJECT_NAME
88: from bis_obj_dependency
89: where enabled_flag='Y'
90: start with object_type='PAGE' and object_name = P_PGNAME
91: connect by prior DEPEND_OBJECT_NAME = object_name
92: AND PRIOR depend_object_type = object_type;

Line 193: from bis_obj_dependency

189: select 'Y'
190: from dual
191: where not exists
192: (select 'Y'
193: from bis_obj_dependency
194: where depend_object_name=p_object_name
195: and depend_object_type=p_object_type);
196: begin
197: l_dummy:='N';

Line 272: from bis_obj_dependency

268: ( select object_name,
269: object_type,
270: depend_object_name,
271: depend_object_type
272: from bis_obj_dependency
273: where enabled_flag='Y') dep
274: where dep.depend_object_type<>'REPORT'--bug 4609286
275: start with dep.object_type = 'REPORT'
276: and dep.object_name=p_report_name

Line 327: bis_obj_dependency

323: depend_object_type,
324: depend_object_owner,
325: enabled_flag
326: from
327: bis_obj_dependency
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,

Line 394: from bis_obj_dependency dep

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
395: where dep.enabled_flag = :2
396: start with dep.object_type = :3
397: and exists (select 1
398: from bis_obj_properties prop

Line 455: SELECT object_name FROM bis_obj_dependency

451: FUNCTION get_page_name_by_func (
452: p_func_name IN VARCHAR2) RETURN VARCHAR2
453: IS
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';

Line 461: v_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617

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
463: IF (p_func_name IS NULL OR p_func_name = '') THEN
464: RETURN NULL;
465: END IF;

Line 501: bis_obj_dependency

497: depend_object_type,
498: depend_object_owner,
499: enabled_flag
500: from
501: bis_obj_dependency
502: where enabled_flag='Y' ) obj
503: start with obj.object_type ='PAGE'
504: and obj.object_name = p_page_name
505: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name

Line 621: v_page_name bis_obj_dependency.object_name%type; --Enhancement 4106617

617: FUNCTION getfndformfuncpageimplflag (
618: p_func_name IN VARCHAR2
619: ) RETURN VARCHAR2 IS
620: v_is_valid_page_func VARCHAR2(5);
621: v_page_name bis_obj_dependency.object_name%type; --Enhancement 4106617
622: v_portlet_name bis_obj_dependency.depend_object_name%type; --Enhancement 4106617
623: v_ret_code VARCHAR2(10);
624:
625: CURSOR c_enabled_dep_portlets (p_page_obj_name VARCHAR2) IS

Line 622: v_portlet_name bis_obj_dependency.depend_object_name%type; --Enhancement 4106617

618: p_func_name IN VARCHAR2
619: ) RETURN VARCHAR2 IS
620: v_is_valid_page_func VARCHAR2(5);
621: v_page_name bis_obj_dependency.object_name%type; --Enhancement 4106617
622: v_portlet_name bis_obj_dependency.depend_object_name%type; --Enhancement 4106617
623: v_ret_code VARCHAR2(10);
624:
625: CURSOR c_enabled_dep_portlets (p_page_obj_name VARCHAR2) IS
626: SElECT depend_object_name

Line 627: FROM bis_obj_dependency objdep

623: v_ret_code VARCHAR2(10);
624:
625: CURSOR c_enabled_dep_portlets (p_page_obj_name VARCHAR2) IS
626: SElECT depend_object_name
627: FROM bis_obj_dependency objdep
628: WHERE objdep.object_name = p_page_obj_name
629: AND objdep.object_type = 'PAGE'
630: AND objdep.depend_object_type = 'PORTLET'
631: AND objdep.ENABLED_FLAG = 'Y';

Line 688: FROM bis_obj_dependency objdep

684: select 'Y'
685: from dual
686: where exists
687: (SElECT depend_object_name
688: FROM bis_obj_dependency objdep
689: WHERE objdep.object_name = p_report_name
690: AND objdep.object_type = 'REPORT'
691: AND objdep.ENABLED_FLAG = 'Y');
692: