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.ETRM_RPT dependencies on DBA_OBJECTS

Line 28: FUNCTION get_object_name(n_object_id in dba_objects.object_id%type

24: return vreturn_value;
25: end get_appid;
26:
27:
28: FUNCTION get_object_name(n_object_id in dba_objects.object_id%type
29: , c_mode in varchar2 := 'BOTH')
30: return varchar2
31: is
32:

Line 33: cursor cur_raw(n_object_id in dba_objects.object_id%type) is

29: , c_mode in varchar2 := 'BOTH')
30: return varchar2
31: is
32:
33: cursor cur_raw(n_object_id in dba_objects.object_id%type) is
34: select name
35: from sys.obj$
36: where obj# = n_object_id;
37:

Line 38: cursor cur_cons(n_object_id in dba_objects.object_id%type) is

34: select name
35: from sys.obj$
36: where obj# = n_object_id;
37:
38: cursor cur_cons(n_object_id in dba_objects.object_id%type) is
39: select name
40: from sys.con$
41: where con# = n_object_id;
42:

Line 47: cursor cur_object(n_object_id in dba_objects.object_id%type) is

43:
44:
45:
46:
47: cursor cur_object(n_object_id in dba_objects.object_id%type) is
48: select object_name
49: , object_type
50: , owner
51: from dba_objects

Line 51: from dba_objects

47: cursor cur_object(n_object_id in dba_objects.object_id%type) is
48: select object_name
49: , object_type
50: , owner
51: from dba_objects
52: where object_id = n_object_id;
53:
54: v_return_value varchar2(512);
55:

Line 101: PROCEDURE a_href_gen(n_object_id in dba_objects.object_id%type)

97: return vreturn_value;
98: end get_tablename;
99:
100:
101: PROCEDURE a_href_gen(n_object_id in dba_objects.object_id%type)
102: is
103: cursor cur_object(n_object_id in dba_objects.object_id%type) is
104: select object_name
105: , object_type

Line 103: cursor cur_object(n_object_id in dba_objects.object_id%type) is

99:
100:
101: PROCEDURE a_href_gen(n_object_id in dba_objects.object_id%type)
102: is
103: cursor cur_object(n_object_id in dba_objects.object_id%type) is
104: select object_name
105: , object_type
106: , owner
107: from dba_objects

Line 107: from dba_objects

103: cursor cur_object(n_object_id in dba_objects.object_id%type) is
104: select object_name
105: , object_type
106: , owner
107: from dba_objects
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

Line 124: function dba_object_info(c_name in dba_objects.object_name%type

120: end a_href_gen;
121:
122:
123:
124: function dba_object_info(c_name in dba_objects.object_name%type
125: , c_owner in dba_objects.owner%type
126: , c_type in dba_objects.object_type%type)
127: return dba_objects.object_id%type is
128:

Line 125: , c_owner in dba_objects.owner%type

121:
122:
123:
124: function dba_object_info(c_name in dba_objects.object_name%type
125: , c_owner in dba_objects.owner%type
126: , c_type in dba_objects.object_type%type)
127: return dba_objects.object_id%type is
128:
129: cursor cur_object(c_name in dba_objects.object_name%type

Line 126: , c_type in dba_objects.object_type%type)

122:
123:
124: function dba_object_info(c_name in dba_objects.object_name%type
125: , c_owner in dba_objects.owner%type
126: , c_type in dba_objects.object_type%type)
127: return dba_objects.object_id%type is
128:
129: cursor cur_object(c_name in dba_objects.object_name%type
130: , c_owner in dba_objects.owner%type

Line 127: return dba_objects.object_id%type is

123:
124: function dba_object_info(c_name in dba_objects.object_name%type
125: , c_owner in dba_objects.owner%type
126: , c_type in dba_objects.object_type%type)
127: return dba_objects.object_id%type is
128:
129: cursor cur_object(c_name in dba_objects.object_name%type
130: , c_owner in dba_objects.owner%type
131: , c_type in dba_objects.object_type%type) is

Line 129: cursor cur_object(c_name in dba_objects.object_name%type

125: , c_owner in dba_objects.owner%type
126: , c_type in dba_objects.object_type%type)
127: return dba_objects.object_id%type is
128:
129: cursor cur_object(c_name in dba_objects.object_name%type
130: , c_owner in dba_objects.owner%type
131: , c_type in dba_objects.object_type%type) is
132: select OWNER
133: , OBJECT_NAME

Line 130: , c_owner in dba_objects.owner%type

126: , c_type in dba_objects.object_type%type)
127: return dba_objects.object_id%type is
128:
129: cursor cur_object(c_name in dba_objects.object_name%type
130: , c_owner in dba_objects.owner%type
131: , c_type in dba_objects.object_type%type) is
132: select OWNER
133: , OBJECT_NAME
134: , SUBOBJECT_NAME

Line 131: , c_type in dba_objects.object_type%type) is

127: return dba_objects.object_id%type is
128:
129: cursor cur_object(c_name in dba_objects.object_name%type
130: , c_owner in dba_objects.owner%type
131: , c_type in dba_objects.object_type%type) is
132: select OWNER
133: , OBJECT_NAME
134: , SUBOBJECT_NAME
135: , OBJECT_ID

Line 145: from dba_objects

141: , STATUS
142: , TEMPORARY
143: , GENERATED
144: , SECONDARY
145: from dba_objects
146: where object_name = c_name
147: and object_type = c_type
148: and owner = owner;
149:

Line 150: cursor cur_table(c_name in dba_objects.object_name%type)

146: where object_name = c_name
147: and object_type = c_type
148: and owner = owner;
149:
150: cursor cur_table(c_name in dba_objects.object_name%type)
151: is
152: select a.application_short_name
153: , a.application_id
154: , t.table_id

Line 162: cursor cur_view(c_name in dba_objects.object_name%type)

158: and t.application_id = a.application_id
159: order by a.application_short_name;
160:
161:
162: cursor cur_view(c_name in dba_objects.object_name%type)
163: is
164: select a.application_short_name
165: , a.application_id
166: , t.view_id

Line 173: v_return_val dba_objects.object_id%type := 0;

169: where view_name = c_name
170: and t.application_id = a.application_id
171: order by a.application_short_name;
172:
173: v_return_val dba_objects.object_id%type := 0;
174: v_first BOOLEAN;
175:
176: begin
177: for o_rec in cur_object(c_name, c_owner, c_type) loop

Line 188: , c_owner in dba_objects.owner%type)

184: procedure ls_table(c_name dba_tables.table_name%type
185: , c_owner dba_tab_columns.owner%type) is
186:
187: CURSOR cur_table_dets(c_name in dba_tables.table_name%type
188: , c_owner in dba_objects.owner%type)
189: -- List table details
190: IS select tab.table_name
191: , tab.tablespace_name
192: , tab.pct_free

Line 200: , c_owner in dba_objects.owner%type)

196: order by tab.table_name;
197: --
198:
199: CURSOR cur_comment(c_name in dba_tables.table_name%type
200: , c_owner in dba_objects.owner%type)
201: is select comments
202: from dba_tab_comments
203: where owner = c_owner
204: and table_name = c_name

Line 209: , c_owner in dba_objects.owner%type)

205: and (table_type = 'TABLE'
206: OR table_type = 'VIEW');
207:
208: cursor cur_index(cv_tab_name in dba_indexes.table_name%type
209: , c_owner in dba_objects.owner%type)
210: -- List Indexes
211: is select ind.index_name
212: , ind.uniqueness
213: , ind.tablespace_name

Line 223: , c_owner in dba_objects.owner%type)

219: and ind.table_owner = c_owner
220: order by ind.uniqueness desc, ind.index_name;
221: --
222: cursor cur_index_col(cv_index_name in dba_ind_columns.index_name%type
223: , c_owner in dba_objects.owner%type)
224: -- List index columns
225: is select ic.column_name
226: , ic.column_length
227: from dba_ind_columns ic

Line 233: , c_owner in dba_objects.owner%type)

229: and ic.index_owner = c_owner
230: order by ic.column_position;
231: --
232: cursor cur_primary_key(cv_table_name in dba_constraints.table_name%type
233: , c_owner in dba_objects.owner%type)
234: -- List the primary key
235: is select uc.constraint_name
236: from dba_constraints uc
237: where uc.table_name = cv_table_name

Line 243: , c_owner in dba_objects.owner%type)

239: and uc.constraint_type = 'P'
240: order by uc.constraint_name;
241: --
242: cursor cur_unique_keys(cv_table_name in dba_constraints.table_name%type
243: , c_owner in dba_objects.owner%type)
244: -- List the unique key constraints
245: is select uc.constraint_name
246: from dba_constraints uc
247: where uc.table_name = cv_table_name

Line 256: , c_owner in dba_objects.owner%type)

252:
253:
254: --
255: cursor cur_list_cons_columns(cv_cons_name in dba_cons_columns.constraint_name%type
256: , c_owner in dba_objects.owner%type)
257: -- list the columns for a given constraint
258: is select cc.column_name
259: from dba_cons_columns cc
260: where cc.constraint_name = cv_cons_name

Line 718: procedure ls_dependencies(n_object_id IN dba_objects.object_id%type) is

714: end if;
715:
716: end ls_columns;
717:
718: procedure ls_dependencies(n_object_id IN dba_objects.object_id%type) is
719:
720:
721: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
722: is select d_obj# object_id

Line 721: cursor cur_depend(n_object_id IN dba_objects.object_id%type)

717:
718: procedure ls_dependencies(n_object_id IN dba_objects.object_id%type) is
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$

Line 729: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)

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
732: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
733: from sys.dependency$

Line 738: v_owner dba_objects.owner%type;

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:
740: begin
741: v_first := TRUE;
742: v_owner := 'foRce_mE_to_diff';

Line 824: procedure ls_source(c_name in dba_objects.object_name%type

820:
821: end ls_dependencies;
822:
823:
824: procedure ls_source(c_name in dba_objects.object_name%type
825: , c_type in dba_objects.object_type%type
826: , c_owner in dba_objects.owner%type) is
827:
828: cursor cur_source(c_name in dba_objects.object_name%type

Line 825: , c_type in dba_objects.object_type%type

821: end ls_dependencies;
822:
823:
824: procedure ls_source(c_name in dba_objects.object_name%type
825: , c_type in dba_objects.object_type%type
826: , c_owner in dba_objects.owner%type) is
827:
828: cursor cur_source(c_name in dba_objects.object_name%type
829: , c_type in dba_objects.object_type%type

Line 826: , c_owner in dba_objects.owner%type) is

822:
823:
824: procedure ls_source(c_name in dba_objects.object_name%type
825: , c_type in dba_objects.object_type%type
826: , c_owner in dba_objects.owner%type) is
827:
828: cursor cur_source(c_name in dba_objects.object_name%type
829: , c_type in dba_objects.object_type%type
830: , c_owner in dba_objects.owner%type)

Line 828: cursor cur_source(c_name in dba_objects.object_name%type

824: procedure ls_source(c_name in dba_objects.object_name%type
825: , c_type in dba_objects.object_type%type
826: , c_owner in dba_objects.owner%type) is
827:
828: cursor cur_source(c_name in dba_objects.object_name%type
829: , c_type in dba_objects.object_type%type
830: , c_owner in dba_objects.owner%type)
831: is select text
832: from dba_source

Line 829: , c_type in dba_objects.object_type%type

825: , c_type in dba_objects.object_type%type
826: , c_owner in dba_objects.owner%type) is
827:
828: cursor cur_source(c_name in dba_objects.object_name%type
829: , c_type in dba_objects.object_type%type
830: , c_owner in dba_objects.owner%type)
831: is select text
832: from dba_source
833: where name = c_name

Line 830: , c_owner in dba_objects.owner%type)

826: , c_owner in dba_objects.owner%type) is
827:
828: cursor cur_source(c_name in dba_objects.object_name%type
829: , c_type in dba_objects.object_type%type
830: , c_owner in dba_objects.owner%type)
831: is select text
832: from dba_source
833: where name = c_name
834: and type = c_type

Line 837: cursor cur_vw_source(c_name in dba_objects.object_name%type

833: where name = c_name
834: and type = c_type
835: and owner = c_owner;
836:
837: cursor cur_vw_source(c_name in dba_objects.object_name%type
838: , c_owner in dba_objects.owner%type)
839: is select text
840: from dba_views
841: where view_name = c_name

Line 838: , c_owner in dba_objects.owner%type)

834: and type = c_type
835: and owner = c_owner;
836:
837: cursor cur_vw_source(c_name in dba_objects.object_name%type
838: , c_owner in dba_objects.owner%type)
839: is select text
840: from dba_views
841: where view_name = c_name
842: and owner = c_owner;

Line 883: procedure cr_file(c_name in dba_objects.object_name%type

879: -----------------------------------------------------------------------------
880: -- Public Procedures
881: -----------------------------------------------------------------------------
882:
883: procedure cr_file(c_name in dba_objects.object_name%type
884: , c_owner in dba_objects.owner%type
885: , c_type in dba_objects.object_type%type
886: , c_rpt_type in varchar2 := 'FULL')
887:

Line 884: , c_owner in dba_objects.owner%type

880: -- Public Procedures
881: -----------------------------------------------------------------------------
882:
883: procedure cr_file(c_name in dba_objects.object_name%type
884: , c_owner in dba_objects.owner%type
885: , c_type in dba_objects.object_type%type
886: , c_rpt_type in varchar2 := 'FULL')
887:
888: is

Line 885: , c_type in dba_objects.object_type%type

881: -----------------------------------------------------------------------------
882:
883: procedure cr_file(c_name in dba_objects.object_name%type
884: , c_owner in dba_objects.owner%type
885: , c_type in dba_objects.object_type%type
886: , c_rpt_type in varchar2 := 'FULL')
887:
888: is
889:

Line 890: v_object_id dba_objects.object_id%type;

886: , c_rpt_type in varchar2 := 'FULL')
887:
888: is
889:
890: v_object_id dba_objects.object_id%type;
891:
892: begin
893:
894: v_object_id := dba_object_info(c_name

Line 905: procedure cr_file(c_owner in dba_objects.owner%type

901: ls_dependencies(v_object_id);
902:
903: end cr_file;
904:
905: procedure cr_file(c_owner in dba_objects.owner%type
906: , c_rpt_type in varchar2 := 'FULL')
907: is
908:
909: cursor cur_items(c_owner in dba_objects.owner%type)

Line 909: cursor cur_items(c_owner in dba_objects.owner%type)

905: procedure cr_file(c_owner in dba_objects.owner%type
906: , c_rpt_type in varchar2 := 'FULL')
907: is
908:
909: cursor cur_items(c_owner in dba_objects.owner%type)
910: is
911:
912: select d.object_name
913: , d.object_type

Line 917: from dba_objects d

913: , d.object_type
914: , d.owner
915: , a.application_id
916: , t.table_id
917: from dba_objects d
918: , fnd_tables t
919: , fnd_application a
920: where a.application_short_name = c_owner
921: and a.application_id = t.application_id

Line 930: from dba_objects d

926: , d.object_type
927: , d.owner
928: , a.application_id
929: , t.view_id table_id
930: from dba_objects d
931: , fnd_views t
932: , fnd_application a
933: where a.application_short_name = c_owner
934: and a.application_id = t.application_id

Line 939: v_owner dba_objects.owner%type;

935: and t.view_name = d.object_name
936: and d.object_type = 'VIEW'
937: order by 2, 1;
938:
939: v_owner dba_objects.owner%type;
940:
941: begin
942:
943: uiutil.file_header(c_filename => c_owner||'.html');

Line 984: cursor cur_items(c_owner in dba_objects.owner%type)

980: end cr_file;
981:
982:
983: procedure product_dependencies(c_product in varchar2) is
984: cursor cur_items(c_owner in dba_objects.owner%type)
985: is
986:
987: select d.object_name
988: , d.object_type

Line 991: from dba_objects d

987: select d.object_name
988: , d.object_type
989: , d.object_id
990: , d.owner
991: from dba_objects d
992: , fnd_tables t
993: , fnd_application a
994: where a.application_short_name = c_owner
995: and a.application_id = t.application_id

Line 1003: from dba_objects d

999: select d.object_name
1000: , d.object_type
1001: , d.object_id
1002: , d.owner
1003: from dba_objects d
1004: , fnd_views t
1005: , fnd_application a
1006: where a.application_short_name = c_owner
1007: and a.application_id = t.application_id

Line 1012: cursor cur_depend(n_object_id in dba_objects.object_id%type) is

1008: and t.view_name = d.object_name
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

Line 1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is

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

Line 1063: v_item_name dba_objects.object_name%type;

1059: v_depend_appid fnd_application.application_id%type;
1060: v_item_rowid number(16);
1061: v_loop_start number(16);
1062: v_loop_end number(16);
1063: v_item_name dba_objects.object_name%type;
1064: v_product varchar2(256);
1065: v_first boolean;
1066:
1067:

Line 1078: record (product_item dba_objects.object_name%type

1074: type dep_table_t is table of dep_type index by binary_integer;
1075: dep_table dep_table_t;
1076:
1077: type dep_item_type is
1078: record (product_item dba_objects.object_name%type
1079: , product_item_type dba_objects.object_type%type
1080: , product_item_schema dba_objects.owner%type
1081: , dep_type varchar2(8)
1082: , dep_item dba_objects.object_name%type

Line 1079: , product_item_type dba_objects.object_type%type

1075: dep_table dep_table_t;
1076:
1077: type dep_item_type is
1078: record (product_item dba_objects.object_name%type
1079: , product_item_type dba_objects.object_type%type
1080: , product_item_schema dba_objects.owner%type
1081: , dep_type varchar2(8)
1082: , dep_item dba_objects.object_name%type
1083: , dep_item_type dba_objects.object_type%type

Line 1080: , product_item_schema dba_objects.owner%type

1076:
1077: type dep_item_type is
1078: record (product_item dba_objects.object_name%type
1079: , product_item_type dba_objects.object_type%type
1080: , product_item_schema dba_objects.owner%type
1081: , dep_type varchar2(8)
1082: , dep_item dba_objects.object_name%type
1083: , dep_item_type dba_objects.object_type%type
1084: , dep_item_schema dba_objects.owner%type);

Line 1082: , dep_item dba_objects.object_name%type

1078: record (product_item dba_objects.object_name%type
1079: , product_item_type dba_objects.object_type%type
1080: , product_item_schema dba_objects.owner%type
1081: , dep_type varchar2(8)
1082: , dep_item dba_objects.object_name%type
1083: , dep_item_type dba_objects.object_type%type
1084: , dep_item_schema dba_objects.owner%type);
1085:
1086: type dep_item_table_t is table of dep_item_type index by binary_integer;

Line 1083: , dep_item_type dba_objects.object_type%type

1079: , product_item_type dba_objects.object_type%type
1080: , product_item_schema dba_objects.owner%type
1081: , dep_type varchar2(8)
1082: , dep_item dba_objects.object_name%type
1083: , dep_item_type dba_objects.object_type%type
1084: , dep_item_schema dba_objects.owner%type);
1085:
1086: type dep_item_table_t is table of dep_item_type index by binary_integer;
1087: dep_item_table dep_item_table_t;

Line 1084: , dep_item_schema dba_objects.owner%type);

1080: , product_item_schema dba_objects.owner%type
1081: , dep_type varchar2(8)
1082: , dep_item dba_objects.object_name%type
1083: , dep_item_type dba_objects.object_type%type
1084: , dep_item_schema dba_objects.owner%type);
1085:
1086: type dep_item_table_t is table of dep_item_type index by binary_integer;
1087: dep_item_table dep_item_table_t;
1088: