DBA Data[Home] [Help]

APPS.ETRM_RPT dependencies on ETRM_PNAV

Line 112: , c_link => 'etrm_pnav.show_object?c_name='

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='

Line 723: , etrm_pnav.get_object_name(d_obj#, 'USER') owner

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#);

Line 724: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item

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

Line 727: order by etrm_pnav.get_object_name(d_obj#);

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

Line 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#);

Line 732: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item

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:

Line 735: order by etrm_pnav.get_object_name(p_obj#);

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:

Line 748: htp.p(''||etrm_pnav.get_object_name(n_object_id)

744:

[top of page]

');
745:
746: for a_rec in cur_depend2(n_object_id) loop
747: IF v_first Then
748: htp.p(''||etrm_pnav.get_object_name(n_object_id)
749: || ' references the following:

');
750: htp.p('

');
751: v_first := FALSE;
752: end if;

Line 776: 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('

');
779: v_first := TRUE;
780: end if;

Line 788: htp.p(''||etrm_pnav.get_object_name(n_object_id)

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('

');
791: v_first := FALSE;
792: end if;

Line 815: 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('

');
818: v_first := TRUE;
819: end if;

Line 1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')

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

Line 1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner

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$

Line 1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item

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

Line 1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type

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')

Line 1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema

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'))

Line 1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, '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'))
1022: , etrm_pnav.get_object_name(d_obj#, 'USER')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:

Line 1021: , etrm_pnav.get_object_name(d_obj#, '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:
1025:

Line 1022: , etrm_pnav.get_object_name(d_obj#, 'USER')

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

Line 1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');

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')

Line 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

Line 1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner

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$

Line 1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item

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

Line 1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type

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')

Line 1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema

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'))

Line 1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, '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'))
1036: , etrm_pnav.get_object_name(p_obj#, 'USER')
1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');
1038:

Line 1035: , etrm_pnav.get_object_name(p_obj#, '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:
1039: cursor cur_appname

Line 1036: , etrm_pnav.get_object_name(p_obj#, 'USER')

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

Line 1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');

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