108: where object_id = n_object_id;
109: begin
110: for o_rec in cur_object(n_object_id) loop
111: uiutil.a_href_gen(c_type => o_rec.object_type
112: , c_link => 'etrm_pnav.show_object?c_name='
113: ||o_rec.object_name
114: ||'&c_owner='
115: ||o_rec.owner
116: ||'&c_type='
719:
720:
721: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
722: is select d_obj# object_id
723: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
724: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
725: from sys.dependency$
726: where p_obj# = n_object_id
727: order by etrm_pnav.get_object_name(d_obj#);
720:
721: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
722: is select d_obj# object_id
723: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
724: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
725: from sys.dependency$
726: where p_obj# = n_object_id
727: order by etrm_pnav.get_object_name(d_obj#);
728: --
723: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
724: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
725: from sys.dependency$
726: where p_obj# = n_object_id
727: order by etrm_pnav.get_object_name(d_obj#);
728: --
729: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
730: is select p_obj# object_id
731: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
727: order by etrm_pnav.get_object_name(d_obj#);
728: --
729: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
730: is select p_obj# object_id
731: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
732: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
733: from sys.dependency$
734: where d_obj# = n_object_id
735: order by etrm_pnav.get_object_name(p_obj#);
728: --
729: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
730: is select p_obj# object_id
731: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
732: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
733: from sys.dependency$
734: where d_obj# = n_object_id
735: order by etrm_pnav.get_object_name(p_obj#);
736:
731: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
732: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
733: from sys.dependency$
734: where d_obj# = n_object_id
735: order by etrm_pnav.get_object_name(p_obj#);
736:
737: v_first boolean;
738: v_owner dba_objects.owner%type;
739:
744:
');');
750: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
772: end loop;
773:
774:
775: IF v_first Then
776: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
777: else
778: htp.p('
784: v_owner := 'foRce_mE_to_diff';
785:
786: for a_rec in cur_depend(n_object_id) loop
787: IF v_first Then
788: htp.p(''||etrm_pnav.get_object_name(n_object_id)
789: || ' is referenced by following:
');
790: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
811: end loop;
812:
813:
814: IF v_first Then
815: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
816: else
817: htp.p('
1009: and d.object_type = 'VIEW'
1010: order by 2, 1;
1011:
1012: cursor cur_depend(n_object_id in dba_objects.object_id%type) is
1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1010: order by 2, 1;
1011:
1012: cursor cur_depend(n_object_id in dba_objects.object_id%type) is
1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1011:
1012: cursor cur_depend(n_object_id in dba_objects.object_id%type) is
1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1012: cursor cur_depend(n_object_id in dba_objects.object_id%type) is
1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1021: , etrm_pnav.get_object_name(d_obj#, 'TYPE'))
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1021: , etrm_pnav.get_object_name(d_obj#, 'TYPE'))
1022: , etrm_pnav.get_object_name(d_obj#, 'USER')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1021: , etrm_pnav.get_object_name(d_obj#, 'TYPE'))
1022: , etrm_pnav.get_object_name(d_obj#, 'USER')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:
1025:
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1021: , etrm_pnav.get_object_name(d_obj#, 'TYPE'))
1022: , etrm_pnav.get_object_name(d_obj#, 'USER')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:
1025:
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1021: , etrm_pnav.get_object_name(d_obj#, 'TYPE'))
1022: , etrm_pnav.get_object_name(d_obj#, 'USER')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:
1025:
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:
1025:
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1024:
1025:
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1025:
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1035: , etrm_pnav.get_object_name(p_obj#, 'TYPE'))
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1035: , etrm_pnav.get_object_name(p_obj#, 'TYPE'))
1036: , etrm_pnav.get_object_name(p_obj#, 'USER')
1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');
1038:
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1035: , etrm_pnav.get_object_name(p_obj#, 'TYPE'))
1036: , etrm_pnav.get_object_name(p_obj#, 'USER')
1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');
1038:
1039: cursor cur_appname
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1035: , etrm_pnav.get_object_name(p_obj#, 'TYPE'))
1036: , etrm_pnav.get_object_name(p_obj#, 'USER')
1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');
1038:
1039: cursor cur_appname
1040: is
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1035: , etrm_pnav.get_object_name(p_obj#, 'TYPE'))
1036: , etrm_pnav.get_object_name(p_obj#, 'USER')
1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');
1038:
1039: cursor cur_appname
1040: is
1041: select a.application_id