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_PNAV dependencies on HTP

Line 84: -- htp.p('
');

80: uiutil.render_tab(c_url => 'etrm_pnav.ls_apps'
81: , c_title => 'DBA'
82: , c_position => 'RIGHT'
83: , c_state => 'SELECTED');
84: -- htp.p('
');
85: end draw_tabs;
86:
87: procedure quick_list is
88:

Line 101: htp.p('

'||v_version||' DBA Data

');

97: for v_rec in cur_version loop
98: v_version := v_rec.release_name;
99: end loop;
100:
101: htp.p('

'||v_version||' DBA Data

');
102:
103: end quick_list;
104:
105: procedure draw_form(c_name in dba_objects.object_name%type := '%'

Line 116: htp.p('
Browse the online data dictionary of an Applications database
');

112: if (c_name = '%'
113: and c_owner = '%'
114: and c_type = '%'
115: and c_status = '%') then
116: htp.p('

Browse the online data dictionary of an Applications database

');
117: else
118: null;
119: -- htp.p('

Home DBA Navigator Home');
120: end if;

Line 119: -- htp.p('
DBA Navigator Home');

115: and c_status = '%') then
116: htp.p('

Browse the online data dictionary of an Applications database

');
117: else
118: null;
119: -- htp.p('

DBA Navigator Home');
120: end if;
121:
122: htp.p('

');
123: htp.p('');

Line 122: htp.p('');

118: null;
119: -- htp.p('

Home DBA Navigator Home');
120: end if;
121:
122: htp.p('');
123: htp.p('

');
124:
125: htp.p(' ');
126: htp.p('');

196: end if;
197: htp.p('

Object Name like:

');

119: -- htp.p('

Home DBA Navigator Home');
120: end if;
121:
122: htp.p('');
123: htp.p('');
124:
125: htp.p(' ');
126: htp.p(' ');
121:
122: htp.p('');
123: htp.p('

Object Name like: Object Name like:
');
124:
125: htp.p(' ');
126: htp.p('');
129:
Line 126: htp.p('
');
201:
202: htp.p('

Object Name like:

');
123: htp.p('');
124:
125: htp.p(' ');
126: htp.p('');
129:
130: htp.p(' ');

Line 130: htp.p('
');

126: htp.p('
');
129:
130: htp.p(' ');
131: htp.p('');
129:
130: htp.p(' ');
131: htp.p('');
129:
130: htp.p(' ');
131: htp.p('');

Line 179: htp.p('
175: htp.p('

Line 180: htp.p('
176: htp.p('
');

Line 181: htp.p('');

177: htp.p('
');
183:
184: htp.p(' ');
185: htp.p('');
183:
184: htp.p(' ');
185: htp.p(' ');

180: htp.p('
');
183:
184: htp.p(' ');
185: htp.p('');
188:

Line 185: htp.p('
');
185: htp.p('');
188:
189: htp.p(' ');

Line 189: htp.p('
');

185: htp.p('
');
188:
189: htp.p(' ');
190: htp.p('');
188:
189: htp.p(' ');
190: htp.p('');
188:
189: htp.p(' ');
190: htp.p('');
201:

Line 198: htp.p('
194: else
195: htp.p('
Object Name like:
Object Type:
Object Type:
Object Type:
Object Type:
Object Type: ');

Line 178: htp.p('
174: htp.p('
Owner like:
Owner like: UNDEFINED');
179: htp.p('
Owner like: Owner like:
Owner like:
Owner like:
Status:
Status:
Status:
Status:
Status: ');

Line 197: htp.p('
193: then null;
194: else
195: htp.p('
');

Line 199: htp.p('');

195: htp.p('
');
203: htp.p('');

Line 200: htp.p('

');
203: htp.p('');
204: htp.p('

');

Line 202: htp.p('');

198: htp.p('

Line 203: htp.p('');

199: htp.p('');
200: htp.p('');
201:
202: htp.p('');
203: htp.p('');
204: htp.p('');
205:
206: --htp.p('c_name='||c_name||' c_owner='||c_owner||' c_type='||c_type);
207: end draw_form;

Line 204: htp.p('');

200: htp.p('');
201:
202: htp.p('');
203: htp.p('');
204: htp.p('');
205:
206: --htp.p('c_name='||c_name||' c_owner='||c_owner||' c_type='||c_type);
207: end draw_form;
208:

Line 206: --htp.p('c_name='||c_name||' c_owner='||c_owner||' c_type='||c_type);

202: htp.p('');
203: htp.p('');
204: htp.p('');
205:
206: --htp.p('c_name='||c_name||' c_owner='||c_owner||' c_type='||c_type);
207: end draw_form;
208:
209:
210: FUNCTION get_object_name(n_object_id in dba_objects.object_id%type

Line 318: -- htp.p('

Objects

');

314: etrm_pnav.draw_buttons;
315: uiutil.cabo2b;
316: etrm_pnav.draw_tabs;
317: uiutil.cabo3;
318: -- htp.p('

Objects

');
319:
320: v_owner := 'foRce_mE_to_diff';
321: v_name := replace(c_name, '*', '%'); -- http drops trailing %
322: v_name := replace(v_name, '%23', '#');

Line 325: htp.p('
');

321: v_name := replace(c_name, '*', '%'); -- http drops trailing %
322: v_name := replace(v_name, '%23', '#');
323: v_httpname := replace(c_name, '%', '*');
324: v_httpname := replace(v_httpname, '#', '%23');
325: htp.p('



'||v_counter ||' objects
'||v_counter ||' objects

');
366:
367: uiutil.cabo4;
368: etrm_pnav.quick_list;

Line 365: htp.p('');

361: htp.p('');
362: v_counter := v_counter + a_rec.object_count;
363: end loop;
364: htp.p('

'||v_counter ||' objects

');
365: htp.p('');
366:
367: uiutil.cabo4;
368: etrm_pnav.quick_list;
369: uiutil.cabo5;

Line 406: htp.p('

'||c_type||'

');

402: etrm_pnav.draw_buttons;
403: uiutil.cabo2b;
404: etrm_pnav.draw_tabs;
405: uiutil.cabo3;
406: htp.p('

'||c_type||'

');
407: v_owner := 'foRce_mE_to_diff';
408: v_name := replace(c_name, '*', '%'); -- http drops trailing %
409: v_name := replace(v_name, '%23', '#');
410: v_httpname := replace(c_name, '%', '*');

Line 414: htp.p('
');

410: v_httpname := replace(c_name, '%', '*');
411: v_httpname := replace(v_httpname, '#', '%23');
412:
413:
414: htp.p('



'||v_counter ||' objects
'||v_counter ||' objects

');
450:
451: uiutil.cabo4;
452: etrm_pnav.quick_list;

Line 449: htp.p('');

445: htp.p('');
446: v_counter := v_counter + 1;
447: end loop;
448: htp.p('

'||v_counter ||' objects

');
449: htp.p('');
450:
451: uiutil.cabo4;
452: etrm_pnav.quick_list;
453: uiutil.cabo5;

Line 513: htp.p('

Object Details

');

509: v_first BOOLEAN;
510:
511: begin
512: for o_rec in cur_object(c_name, c_owner, c_type) loop
513: htp.p('

Object Details

');
514:
515: htp.p(' 516: summary="dba_objects information">');
517: htp.prn(' ');

Line 515: htp.p('

Object Name:

511: begin
512: for o_rec in cur_object(c_name, c_owner, c_type) loop
513: htp.p('

Object Details

');
514:
515: htp.p('

516: summary="dba_objects information">');
517: htp.prn(' ');
518: htp.p('');
519:

Line 517: htp.prn('

');

513: htp.p('

Object Details

');
514:
515: htp.p('

Object Name:
Object Name:	'\|\|o_rec.object_name\|\|'

516: summary="dba_objects information">');
517: htp.prn(' ');
518: htp.p('');
519:
520: htp.prn(' ');
521: htp.p('');

Line 518: htp.p('

');

514:
515: htp.p('

Object Name:	'\|\|o_rec.object_name\|\|'
Object Type:	'\|\|o_rec.object_type\|\|'
'\|\|o_rec.object_name\|\|'

516: summary="dba_objects information">');
517: htp.prn(' ');
518: htp.p('');
519:
520: htp.prn(' ');
521: htp.p('');
522:

Line 520: htp.prn('

');

516: summary="dba_objects information">');
517: htp.prn('

');
518: htp.p('');
519:
520: htp.prn(' ');
521: htp.p('');
522:
523: htp.prn(' ');
524: htp.p('');

Line 521: htp.p('

');

517: htp.prn('

');
518: htp.p('');
519:
520: htp.prn(' ');
521: htp.p('');
522:
523: htp.prn(' ');
524: htp.p('');
525:

Line 523: htp.prn('

');

519:
520: htp.prn('

');
521: htp.p('');
522:
523: htp.prn(' ');
524: htp.p('');
525:
526: v_first := TRUE;
527: if o_rec.object_type = 'TABLE' then

Line 524: htp.p('

');

520: htp.prn('

');
521: htp.p('');
522:
523: htp.prn(' ');
524: htp.p('');
525:
526: v_first := TRUE;
527: if o_rec.object_type = 'TABLE' then
528:

Line 532: htp.prn('

');

560: end loop;
561:
562: end if;
563: if v_first = FALSE then
564: htp.p('

');
565: end if;
566:
567: htp.prn(' ');
568: htp.p('');

Line 567: htp.prn('

');

563: if v_first = FALSE then
564: htp.p('

');
565: end if;
566:
567: htp.prn(' ');
568: htp.p('');
569: /*
570: htp.prn(' ');
571: htp.p('');

Line 568: htp.p('

');

564: htp.p('

');
565: end if;
566:
567: htp.prn(' ');
568: htp.p('');
569: /*
570: htp.prn(' ');
571: htp.p('');
572:

Line 570: htp.prn('

');

566:
567: htp.prn('

');
568: htp.p('');
569: /*
570: htp.prn(' ');
571: htp.p('');
572:
573: htp.prn(' ');
574: htp.p('');

Line 571: htp.p('

');

567: htp.prn('

');
568: htp.p('');
569: /*
570: htp.prn(' ');
571: htp.p('');
572:
573: htp.prn(' ');
574: htp.p('');
575:

Line 573: htp.prn('

');

569: /*
570: htp.prn('

');
571: htp.p('');
572:
573: htp.prn(' ');
574: htp.p('');
575:
576: htp.prn(' ');
577: htp.p('');

Line 574: htp.p('

');

570: htp.prn('

');
571: htp.p('');
572:
573: htp.prn(' ');
574: htp.p('');
575:
576: htp.prn(' ');
577: htp.p('');
578:

Line 576: htp.prn('

');

572:
573: htp.prn('

');
574: htp.p('');
575:
576: htp.prn(' ');
577: htp.p('');
578:
579: htp.prn(' ');
580: htp.p('');

Line 577: htp.p('

');

573: htp.prn('

');
574: htp.p('');
575:
576: htp.prn(' ');
577: htp.p('');
578:
579: htp.prn(' ');
580: htp.p('');
581:

Line 579: htp.prn('

');

575:
576: htp.prn('

');
577: htp.p('');
578:
579: htp.prn(' ');
580: htp.p('');
581:
582: htp.prn(' ');
583: htp.p('');

Line 580: htp.p('

');

576: htp.prn('

');
577: htp.p('');
578:
579: htp.prn(' ');
580: htp.p('');
581:
582: htp.prn(' ');
583: htp.p('');
584: */

Line 582: htp.prn('

');

578:
579: htp.prn('

');
580: htp.p('');
581:
582: htp.prn(' ');
583: htp.p('');
584: */
585: htp.prn(' ');
586:

Line 583: htp.p('

');

579: htp.prn('

');
580: htp.p('');
581:
582: htp.prn(' ');
583: htp.p('');
584: */
585: htp.prn(' ');
586:
587: if o_rec.status = 'INVALID' then

Line 585: htp.prn('

');

581:
582: htp.prn('

');
583: htp.p('');
584: */
585: htp.prn(' ');
586:
587: if o_rec.status = 'INVALID' then
588: htp.p(' ');
586:
587: if o_rec.status = 'INVALID' then
588: htp.p('');

594: ||'&c_type='
595: ||c_type
596: ||'&c_detail_type=exception'
597: , c_display => o_rec.status);
598: htp.p('
');
599: else
600: htp.p('');
601: end if;
602: /*

Line 600: htp.p('
');

596: ||'&c_detail_type=exception'
597: , c_display => o_rec.status);
598: htp.p('
');
599: else
600: htp.p('');
601: end if;
602: /*
603: htp.prn(' ');
604: htp.p('');

Line 603: htp.prn('
');

599: else
600: htp.p('
');
601: end if;
602: /*
603: htp.prn(' ');
604: htp.p('');
605:
606: htp.prn(' ');
607: htp.p('');

Line 604: htp.p('
');

600: htp.p('
');
601: end if;
602: /*
603: htp.prn(' ');
604: htp.p('');
605:
606: htp.prn(' ');
607: htp.p('');
608:

Line 606: htp.prn('
');

602: /*
603: htp.prn('
');
604: htp.p('');
605:
606: htp.prn(' ');
607: htp.p('');
608:
609: htp.prn(' ');
610: htp.p('');

Line 607: htp.p('
');

603: htp.prn('
');
604: htp.p('');
605:
606: htp.prn(' ');
607: htp.p('');
608:
609: htp.prn(' ');
610: htp.p('');
611: */

Line 609: htp.prn('
');

605:
606: htp.prn('
');
607: htp.p('');
608:
609: htp.prn(' ');
610: htp.p('');
611: */
612: htp.p('

Object Type:
Object Name:	'\|\|o_rec.object_name\|\|'
Object Type:	'\|\|o_rec.object_type\|\|'
Object Name:	'\|\|o_rec.object_name\|\|'
Object Type:	'\|\|o_rec.object_type\|\|'
Owner:	'\|\|o_rec.owner\|\|'
'\|\|o_rec.object_type\|\|'
Object Name:	'\|\|o_rec.object_name\|\|'
Object Type:	'\|\|o_rec.object_type\|\|'
Owner:	'\|\|o_rec.owner\|\|'
Owner:
Object Type:	'\|\|o_rec.object_type\|\|'
Owner:	'\|\|o_rec.owner\|\|'
'\|\|o_rec.owner\|\|'
Object Type:	'\|\|o_rec.object_type\|\|'
Owner:	'\|\|o_rec.owner\|\|'
FND Design Data:	'); 528: 529: for t_rec in cur_table(o_rec.object_name) loop 530: if v_first = TRUE 531: then v_first := FALSE; 532: htp.prn('
FND Design Data:	'); 533: else 534: htp.p(' '); 535: end if; 536: uiutil.a_href_gen(c_type => 'TABLE' Line 534: htp.p(' '); 530: if v_first = TRUE 531: then v_first := FALSE; 532: htp.prn('
FND Design Data:	'); 533: else 534: htp.p(' '); 535: end if; 536: uiutil.a_href_gen(c_type => 'TABLE' 537: , c_link => 'etrm_fndnav.show_object?n_tabid=' 538: \|\|t_rec.table_id Line 549: htp.prn('
FND Design Data:	'); 545: 546: for t_rec in cur_view(o_rec.object_name) loop 547: if v_first = TRUE 548: then v_first := FALSE; 549: htp.prn('
FND Design Data:	'); 550: else 551: htp.p(' '); 552: end if; 553: uiutil.a_href_gen(c_type => 'VIEW' Line 551: htp.p(' '); 547: if v_first = TRUE 548: then v_first := FALSE; 549: htp.prn('
FND Design Data:	'); 550: else 551: htp.p(' '); 552: end if; 553: uiutil.a_href_gen(c_type => 'VIEW' 554: , c_link => 'etrm_fndnav.show_object?n_tabid=' 555: \|\|t_rec.view_id Line 564: htp.p('
Subobject Name:	'\|\|o_rec.subobject_name\|\|'
Subobject Name:
Subobject Name:	'\|\|o_rec.subobject_name\|\|'
Object ID:	'\|\|o_rec.object_id\|\|'
'\|\|o_rec.subobject_name\|\|'
Subobject Name:	'\|\|o_rec.subobject_name\|\|'
Object ID:	'\|\|o_rec.object_id\|\|'
Object ID:
Subobject Name:	'\|\|o_rec.subobject_name\|\|'
Object ID:	'\|\|o_rec.object_id\|\|'
Data Object ID:	'\|\|o_rec.data_object_id\|\|'
'\|\|o_rec.object_id\|\|'
Subobject Name:	'\|\|o_rec.subobject_name\|\|'
Object ID:	'\|\|o_rec.object_id\|\|'
Data Object ID:	'\|\|o_rec.data_object_id\|\|'
Data Object ID:
Object ID:	'\|\|o_rec.object_id\|\|'
Data Object ID:	'\|\|o_rec.data_object_id\|\|'
Created:	'\|\|o_rec.created\|\|'
'\|\|o_rec.data_object_id\|\|'
Object ID:	'\|\|o_rec.object_id\|\|'
Data Object ID:	'\|\|o_rec.data_object_id\|\|'
Created:	'\|\|o_rec.created\|\|'
Created:
Data Object ID:	'\|\|o_rec.data_object_id\|\|'
Created:	'\|\|o_rec.created\|\|'
Last DDL Time:	'\|\|o_rec.last_ddl_time\|\|'
'\|\|o_rec.created\|\|'
Data Object ID:	'\|\|o_rec.data_object_id\|\|'
Created:	'\|\|o_rec.created\|\|'
Last DDL Time:	'\|\|o_rec.last_ddl_time\|\|'
Last DDL Time:
Created:	'\|\|o_rec.created\|\|'
Last DDL Time:	'\|\|o_rec.last_ddl_time\|\|'
Timestamp:	'\|\|o_rec.timestamp\|\|'
'\|\|o_rec.last_ddl_time\|\|'
Created:	'\|\|o_rec.created\|\|'
Last DDL Time:	'\|\|o_rec.last_ddl_time\|\|'
Timestamp:	'\|\|o_rec.timestamp\|\|'
Timestamp:
Last DDL Time:	'\|\|o_rec.last_ddl_time\|\|'
Timestamp:	'\|\|o_rec.timestamp\|\|'
Status:	'\|\|o_rec.timestamp\|\|'
Last DDL Time:	'\|\|o_rec.last_ddl_time\|\|'
Timestamp:	'\|\|o_rec.timestamp\|\|'
Status:
Status:
Timestamp:	'\|\|o_rec.timestamp\|\|'
Status:	'); 589: uiutil.a_href_gen(c_type => 'EXCEPTION' Line 588: htp.p('	'); 584: */ 585: htp.prn('
Status:	'); 589: uiutil.a_href_gen(c_type => 'EXCEPTION' 590: , c_link => 'etrm_pnav.show_details?c_name=' 591: \|\|c_name 592: \|\|'&c_owner=' Line 598: htp.p('
'\|\|o_rec.status\|\|'
'\|\|o_rec.status\|\|'
'\|\|o_rec.status\|\|'
Temporary:	'\|\|o_rec.temporary\|\|'
Temporary:	'\|\|o_rec.status\|\|'
Temporary:	'\|\|o_rec.temporary\|\|'
Generated:	'\|\|o_rec.generated\|\|'
'\|\|o_rec.temporary\|\|'
'\|\|o_rec.status\|\|'
Temporary:	'\|\|o_rec.temporary\|\|'
Generated:	'\|\|o_rec.generated\|\|'
Generated:
Temporary:	'\|\|o_rec.temporary\|\|'
Generated:	'\|\|o_rec.generated\|\|'
Secondary:	'\|\|o_rec.secondary\|\|'
'\|\|o_rec.generated\|\|'
Temporary:	'\|\|o_rec.temporary\|\|'
Generated:	'\|\|o_rec.generated\|\|'
Secondary:	'\|\|o_rec.secondary\|\|'
Secondary:
Generated:	'\|\|o_rec.generated\|\|'
Secondary:	'\|\|o_rec.secondary\|\|'

');
613: v_return_val := o_rec.object_id;

Line 610: htp.p(''||o_rec.secondary||'');

606: htp.prn(' Generated: ');
607: htp.p(''||o_rec.generated||'');
608:
609: htp.prn(' Secondary: ');
610: htp.p(''||o_rec.secondary||'');
611: */
612: htp.p('');
613: v_return_val := o_rec.object_id;
614: end loop;

Line 612: htp.p('');

608:
609: htp.prn(' Secondary: ');
610: htp.p(''||o_rec.secondary||'');
611: */
612: htp.p('');
613: v_return_val := o_rec.object_id;
614: end loop;
615: return v_return_val;
616: end dba_object_info;

Line 660: htp.p('
Foreign Keys
');

656: v_first := TRUE;
657: for key_rec in cur_fk(n_object_id) loop
658: if v_first = TRUE then
659: v_first := FALSE;
660: htp.p('
Foreign Keys
');
661: htp.p(' 662: summary="Foreign keys from/to this table">
663:
664:
Line 661: htp.p('

657: for key_rec in cur_fk(n_object_id) loop
658: if v_first = TRUE then
659: v_first := FALSE;
660: htp.p('
Foreign Keys
');
661: htp.p('

662: summary="Foreign keys from/to this table">
663:
664:
665:
Line 671: htp.p('

668: ');
669:
670: end if;
671: htp.p('');
675:

Line 673: htp.p(v_table_name);

669:
670: end if;
671: htp.p('
');
675:
676: htp.p('');
675:
676: htp.p('');
675:
676: htp.p('');
680: htp.p('');
680: htp.p('');

685: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
686: ||'&c_type=TABLE'
687: , c_display => key_rec.table_name);
688:
689: htp.p('');
690:
691: v_first2 := TRUE;
692: htp.p('
');
690:
691: v_first2 := TRUE;
692: htp.p('');
705:

Line 702: htp.p(''||key_col.column_name||'');

698: else
699: htp.p('
');
700: end if;
701: htp.p(v_table_name);
702: htp.p(''||key_col.column_name||'');
703: end loop;
704: htp.p('');
705:
706: end loop;

Line 704: htp.p('');

700: end if;
701: htp.p(v_table_name);
702: htp.p(''||key_col.column_name||'');
703: end loop;
704: htp.p('');
705:
706: end loop;
707:
708: for key_rec in cur_fk2(n_object_id) loop

Line 711: htp.p('
Foreign Keys
');

707:
708: for key_rec in cur_fk2(n_object_id) loop
709: if v_first = TRUE then
710: v_first := FALSE;
711: htp.p('
Foreign Keys
');
712: htp.p('

Table ');

667:
Foreign Table Foreign Key Column

');
672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');
673: htp.p(v_table_name);
674: htp.p(' ');
672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');
673: htp.p(v_table_name);
674: htp.p(' '
677: ||'');
672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');
673: htp.p(v_table_name);
674: htp.p(' '
677: ||''

672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');
673: htp.p(v_table_name);
674: htp.p('
'
677: ||' ');

Line 680: htp.p('
');

676: htp.p('
'
677: ||' ');
681: uiutil.a_href_gen(c_type => 'TABLE'
682: , c_link => 'etrm_pnav.show_object?c_name='
683: || etrm_pnav.get_object_name(key_rec.object_id, 'RAW')
684: ||'&c_owner='

Line 689: htp.p('
');
693: for key_col in cur_list_cons_columns(

Line 692: htp.p('
');

688:
689: htp.p('
');
693: for key_col in cur_list_cons_columns(
694: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
695: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
696: if v_first2 = TRUE

Line 699: htp.p('
');

695: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
696: if v_first2 = TRUE
697: then v_first2 := FALSE;
698: else
699: htp.p('
');
700: end if;
701: htp.p(v_table_name);
702: htp.p(''||key_col.column_name||'');
703: end loop;

Line 701: htp.p(v_table_name);

697: then v_first2 := FALSE;
698: else
699: htp.p('
');
700: end if;
701: htp.p(v_table_name);
702: htp.p(''||key_col.column_name||'');
703: end loop;
704: htp.p('
713: summary="Foreign keys from/to this table">
714:
715:

Line 712: htp.p('
708: for key_rec in cur_fk2(n_object_id) loop
709: if v_first = TRUE then
710: v_first := FALSE;
711: htp.p('
Foreign Keys
');
712: htp.p('

713: summary="Foreign keys from/to this table">
714:
715:
716:

Line 724: htp.p('
');

730: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
731: ||'&c_type=TABLE'
732: , c_display => key_rec.table_name);
733:
734: htp.p('');
735: htp.p('
');

Line 735: htp.p('
');
735: htp.p('');
739: htp.p('');
739: htp.p('');
742: htp.p('');
743:

Line 740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));

736: ||'');
739: htp.p('
');
742: htp.p('');
743:
744: v_first2 := TRUE;

Line 741: htp.p('');

737: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
738: || '">');
739: htp.p('
');
742: htp.p('');
743:
744: v_first2 := TRUE;
745: htp.p('');

738: || '">');
739: htp.p('
');
742: htp.p('');
743:
744: v_first2 := TRUE;
745: htp.p('');
742: htp.p('');
743:
744: v_first2 := TRUE;
745: htp.p('');
758:

Line 755: htp.p(''||key_col.column_name||'');

751: else
752: htp.p('
');
753: end if;
754: htp.p(v_table_name);
755: htp.p(''||key_col.column_name||'');
756: end loop;
757: htp.p('');
758:
759: end loop;

Line 757: htp.p('');

753: end if;
754: htp.p(v_table_name);
755: htp.p(''||key_col.column_name||'');
756: end loop;
757: htp.p('');
758:
759: end loop;
760:
761: if v_first

Line 764: htp.p('

Table ');

720: end if;
721:
722:
723:
724: htp.p('
');
725: v_table_name := key_rec.table_name;
726: uiutil.a_href_gen(c_type => 'TABLE'
727: , c_link => 'etrm_pnav.show_object?c_name='
728: || etrm_pnav.get_object_name(key_rec.object_id, 'ITEM')

Line 734: htp.p('
'
736: ||' '

731: ||'&c_type=TABLE'
732: , c_display => key_rec.table_name);
733:
734: htp.p('
'
736: ||' ');

Line 739: htp.p('
');

735: htp.p('
'
736: ||' ');
740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));
741: htp.p(' ');
740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));
741: htp.p(' ');
740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));
741: htp.p(' ');

Line 742: htp.p('
');
740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));
741: htp.p(' ');
746: for key_col in cur_list_cons_columns(

Line 745: htp.p('
');

741: htp.p('
');
746: for key_col in cur_list_cons_columns(
747: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
748: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
749: if v_first2 = TRUE

Line 752: htp.p('
');

748: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
749: if v_first2 = TRUE
750: then v_first2 := FALSE;
751: else
752: htp.p('
');
753: end if;
754: htp.p(v_table_name);
755: htp.p(''||key_col.column_name||'');
756: end loop;

Line 754: htp.p(v_table_name);

750: then v_first2 := FALSE;
751: else
752: htp.p('
');
753: end if;
754: htp.p(v_table_name);
755: htp.p(''||key_col.column_name||'');
756: end loop;
757: htp.p('
');

760:
761: if v_first
762: then null;
763: else
764: htp.p('');
765: end if;
766: end ls_table;
767:
768:

Line 886: htp.p('
Temporary Table Details
');

882: v_first := TRUE;
883: FOR tab_rec IN cur_table_dets(c_name, c_owner) LOOP
884:
885: if tab_rec.temporary = 'Y' then
886: htp.p('
Temporary Table Details
');
887: htp.p('
'||c_owner||'.'||c_name||' is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data
888: in the table is temporary. It has a data duration of '||tab_rec.duration||'.
889: Data is removed at the end of this period.
');
890: end if;

Line 887: htp.p('
'||c_owner||'.'||c_name||' is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data

883: FOR tab_rec IN cur_table_dets(c_name, c_owner) LOOP
884:
885: if tab_rec.temporary = 'Y' then
886: htp.p('
Temporary Table Details
');
887: htp.p('
'||c_owner||'.'||c_name||' is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data
888: in the table is temporary. It has a data duration of '||tab_rec.duration||'.
889: Data is removed at the end of this period.
');
890: end if;
891:

Line 893: htp.p('
Storage Details
');

889: Data is removed at the end of this period.
');
890: end if;
891:
892:
893: htp.p('
Storage Details
');
894: htp.p(' 895: summary="dba_tables information">');
896:
897: htp.p('
Tablespace: '

Line 894: htp.p('
890: end if;
891:
892:
893: htp.p('
Storage Details
');
894: htp.p('

895: summary="dba_tables information">');
896:
897: htp.p('');
Line 897: htp.p('
');
899: htp.p('');
901: htp.p('');
903: htp.p('

Tablespace: '
898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'

Tablespace: '

893: htp.p('
Storage Details
');
894: htp.p(' 895: summary="dba_tables information">');
896:
897: htp.p('');
899: htp.p('');
901: htp.p('');
899: htp.p('');
901: htp.p('');
903: htp.p('

Tablespace: '
898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'
PCT Free: '
900: ||tab_rec.pct_free||'
PCT Used: '

Line 899: htp.p('
PCT Free: '

895: summary="dba_tables information">');
896:
897: htp.p('
Tablespace: '
898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'
PCT Free: '
900: ||tab_rec.pct_free||'
PCT Used: '
902: || tab_rec.pct_used||'
');

Line 901: htp.p('
PCT Used: '

897: htp.p('
Tablespace: '
898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'
PCT Free: '
900: ||tab_rec.pct_free||'

PCT Used: '
902: || tab_rec.pct_used||'
');
904: end loop;
905: --

Line 903: htp.p('
');

899: htp.p('PCT Free: '
900: ||tab_rec.pct_free||'');
901: htp.p('PCT Used: '
902: || tab_rec.pct_used||'');
903: htp.p('');
904: end loop;
905: --
906:
907:

Line 910: htp.p('
Primary Key: '|| key_rec.constraint_name || '
');

906:
907:
908:
909: for key_rec in cur_primary_key(c_name, c_owner) loop
910: htp.p('
Primary Key: '|| key_rec.constraint_name || '
');
911: htp.p('
');
912: v_pk_name := key_rec.constraint_name;
913: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
914: htp.p('
'

Line 911: htp.p('
');

907:
908:
909: for key_rec in cur_primary_key(c_name, c_owner) loop
910: htp.p('
Primary Key: '|| key_rec.constraint_name || '
');
911: htp.p('
');
912: v_pk_name := key_rec.constraint_name;
913: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
914: htp.p('
'
915: || uiutil.el_image('COL')

Line 914: htp.p('
'

910: htp.p('
Primary Key: '|| key_rec.constraint_name || '
');
911: htp.p('
');
912: v_pk_name := key_rec.constraint_name;
913: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
914: htp.p('
'
915: || uiutil.el_image('COL')
916: ||key_col.column_name
917: ||'
');
918: end loop;

Line 919: htp.p('
');

915: || uiutil.el_image('COL')
916: ||key_col.column_name
917: ||'
');
918: end loop;
919: htp.p('
');
920: end loop;
921: --
922: for key_rec in cur_unique_keys(c_name, c_owner) loop
923: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');

Line 923: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');

919: htp.p('
');
920: end loop;
921: --
922: for key_rec in cur_unique_keys(c_name, c_owner) loop
923: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');
924: htp.p('
');
925: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
926: htp.p('
'
927: || uiutil.el_image('COL')

Line 924: htp.p('
');

920: end loop;
921: --
922: for key_rec in cur_unique_keys(c_name, c_owner) loop
923: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');
924: htp.p('
');
925: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
926: htp.p('
'
927: || uiutil.el_image('COL')
928: ||key_col.column_name

Line 926: htp.p('
'

922: for key_rec in cur_unique_keys(c_name, c_owner) loop
923: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');
924: htp.p('
');
925: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
926: htp.p('
'
927: || uiutil.el_image('COL')
928: ||key_col.column_name
929: ||'
');
930: end loop;

Line 931: htp.p('
');

927: || uiutil.el_image('COL')
928: ||key_col.column_name
929: ||'
');
930: end loop;
931: htp.p('
');
932: end loop;
933: --
934: v_first := TRUE;
935: for ind_rec in cur_index(c_name, c_owner) loop

Line 938: htp.p('
Indexes
');

934: v_first := TRUE;
935: for ind_rec in cur_index(c_name, c_owner) loop
936: if v_first = TRUE then
937: v_first := FALSE;
938: htp.p('
Indexes
');
939: htp.p(' 940: summary="Indexes in this table">
941:
942:
Line 939: htp.p('
Index
935: for ind_rec in cur_index(c_name, c_owner) loop
936: if v_first = TRUE then
937: v_first := FALSE;
938: htp.p('
Indexes
');
939: htp.p('

940: summary="Indexes in this table">
941:
942:
943:
Line 949: htp.p('
');
945:

946: ');
947: end if;
948:
949: htp.p('');
950: htp.p('');
953:
Line 950: htp.p('
');
947: end if;
948:
949: htp.p('');
950: htp.p('');
953:
954: htp.p('');
950: htp.p('');
953:
954: htp.p('');

948:
949: htp.p('
');
950: htp.p('');
953:
954: htp.p('');
Line 954: htp.p('
');
953:
954: htp.p('');
957:
958: htp.p('');
953:
954: htp.p('');
957:
958: htp.p('');

952: htp.p('');
953:
954: htp.p('
');
957:
958: htp.p('');
Line 958: htp.p('
');
957:
958: htp.p('');
961:
962:

Line 959: htp.p(ind_rec.uniqueness);

955: htp.p(ind_rec.index_type);
956: htp.p('');
957:
958: htp.p('
');
961:
962:
963: htp.p('');

956: htp.p('');
957:
958: htp.p('
');
961:
962:
963: htp.p('');
961:
962:
963: htp.p('');
966:
967:

Line 964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);

960: htp.p('');
961:
962:
963: htp.p('
');
966:
967:
968:

Line 965: htp.p('');

961:
962:
963: htp.p('
');
966:
967:
968:
969: htp.p('');
966:
967:
968:
969: htp.p('');
992: end loop;

Line 991: htp.p('');

987: end if;
988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);
989: end loop;
990: end if;
991: htp.p('');
992: end loop;
993:
994: IF v_first Then
995: null;

Line 997: htp.p('

Index Type
Tablespace Column

');
951: htp.p(ind_rec.index_name);
952: htp.p(' ');

946:
Column
');
951: htp.p(ind_rec.index_name);
952: htp.p(' ');

Line 951: htp.p(ind_rec.index_name);

947: end if;
948:
949: htp.p('
');
951: htp.p(ind_rec.index_name);
952: htp.p(' ');
955: htp.p(ind_rec.index_type);

Line 952: htp.p('
');
951: htp.p(ind_rec.index_name);
952: htp.p(' ');
955: htp.p(ind_rec.index_type);
956: htp.p(' ');

950: htp.p('
');
951: htp.p(ind_rec.index_name);
952: htp.p(' ');
955: htp.p(ind_rec.index_type);
956: htp.p(' ');

Line 955: htp.p(ind_rec.index_type);

951: htp.p(ind_rec.index_name);
952: htp.p('
');
955: htp.p(ind_rec.index_type);
956: htp.p(' ');
959: htp.p(ind_rec.uniqueness);

Line 956: htp.p('
');
955: htp.p(ind_rec.index_type);
956: htp.p(' ');
959: htp.p(ind_rec.uniqueness);
960: htp.p(' ');

954: htp.p('
');
955: htp.p(ind_rec.index_type);
956: htp.p(' ');
959: htp.p(ind_rec.uniqueness);
960: htp.p(' ');
959: htp.p(ind_rec.uniqueness);
960: htp.p(' ');

Line 960: htp.p('
');
959: htp.p(ind_rec.uniqueness);
960: htp.p(' ');
964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);

Line 963: htp.p('
');

959: htp.p(ind_rec.uniqueness);
960: htp.p('
');
964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);
965: htp.p(' ');
964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);
965: htp.p(' ');
964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);
965: htp.p(' ');

Line 969: htp.p('
');

965: htp.p('
');
970:
971: v_first2 := TRUE;
972: if ind_rec.index_type like 'FUNCTION-BASED%' then
973: for ind_col_rec in cur_function_index(ind_rec.index_name, ind_rec.owner) loop

Line 977: htp.p('
');

973: for ind_col_rec in cur_function_index(ind_rec.index_name, ind_rec.owner) loop
974: IF v_first2 Then
975: v_first2 := FALSE;
976: else
977: htp.p('
');
978: end if;
979: htp.p(uiutil.el_image('COL')||ind_col_rec.column_expression);
980: end loop;
981: else

Line 979: htp.p(uiutil.el_image('COL')||ind_col_rec.column_expression);

975: v_first2 := FALSE;
976: else
977: htp.p('
');
978: end if;
979: htp.p(uiutil.el_image('COL')||ind_col_rec.column_expression);
980: end loop;
981: else
982: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop
983: IF v_first2 Then

Line 986: htp.p('
');

982: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop
983: IF v_first2 Then
984: v_first2 := FALSE;
985: else
986: htp.p('
');
987: end if;
988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);
989: end loop;
990: end if;

Line 988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);

984: v_first2 := FALSE;
985: else
986: htp.p('
');
987: end if;
988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);
989: end loop;
990: end if;
991: htp.p('
');

993:
994: IF v_first Then
995: null;
996: else
997: htp.p('');
998: end if;
999:
1000:
1001: --

Line 1043: htp.p('
Columns
');

1039: v_first := TRUE;
1040: for col_rec in cur_columns(c_name, c_owner) loop
1041: IF v_first Then
1042:
1043: htp.p('
Columns
');
1044: htp.p(' 1045: summary="Column details for this table">');
1046: htp.p('');
1047: htp.p('');
Line 1044: htp.p('
Name
1040: for col_rec in cur_columns(c_name, c_owner) loop
1041: IF v_first Then
1042:
1043: htp.p('
Columns
');
1044: htp.p('

1045: summary="Column details for this table">');
1046: htp.p('');
1047: htp.p('');
1048: htp.p('');
Line 1046: htp.p('
');
1042:
1043: htp.p('
Columns
');
1044: htp.p('

Name Datatype

1045: summary="Column details for this table">');
1046: htp.p('');
1047: htp.p('');
1048: htp.p('');
1049: htp.p('');
1050: htp.p('');
Line 1047: htp.p('
');
1043: htp.p('
Columns
');
1044: htp.p('

Name Datatype Length Mandatory Name
1045: summary="Column details for this table">');
1046: htp.p('');
1047: htp.p('');
1048: htp.p('');
1049: htp.p('');
1050: htp.p('');
1051: htp.p('');
Line 1048: htp.p('
');
1044: htp.p('
Name Datatype Length Mandatory Comments

Datatype
1045: summary="Column details for this table">');
1046: htp.p('');
1047: htp.p('');
1048: htp.p('');
1049: htp.p('');
1050: htp.p('');
1051: htp.p('');
1052: v_first := FALSE;
Line 1049: htp.p('
');
1045: summary="Column details for this table">');
1046: htp.p('
');
1047: htp.p('');
1048: htp.p('');
1049: htp.p('');
1050: htp.p('');
1051: htp.p('');
1052: v_first := FALSE;
1053: end if;
Line 1050: htp.p('
');
1046: htp.p('
');
1047: htp.p('');
1048: htp.p('');
1049: htp.p('');
1050: htp.p('');
1051: htp.p('');
1052: v_first := FALSE;
1053: end if;
1054:
Line 1051: htp.p('
');
1047: htp.p('
');
1048: htp.p('');
1049: htp.p('');
1050: htp.p('');
1051: htp.p('');
1052: v_first := FALSE;
1053: end if;
1054:
1055: htp.prn('');
1052: v_first := FALSE;
1053: end if;
1054:
1055: htp.prn('');
1058: htp.prn('');
1058: htp.prn('');

Line 1057: htp.p('');

1053: end if;
1054:
1055: htp.prn('
');
1058: htp.prn('');
1061: htp.prn('');
1058: htp.prn('');
1061: htp.prn('');
1058: htp.prn('');
1061: htp.prn('');

1056: htp.prn(col_rec.column_name);
1057: htp.p('');
1058: htp.prn('
');
1061: htp.prn('');
1058: htp.prn('');
1061: htp.prn('');
1061: htp.prn('');

Line 1073: htp.prn('('||col_rec.data_length||')');

1069: then htp.prn('('||col_rec.data_precision||')');
1070: elsif col_rec.data_length is null
1071: then htp.prn('
');
1072: else
1073: htp.prn('('||col_rec.data_length||')');
1074: end if;
1075: htp.p('');
1076:
1077: htp.prn('
');

1071: then htp.prn('
');
1072: else
1073: htp.prn('('||col_rec.data_length||')');
1074: end if;
1075: htp.p('');
1076:
1077: htp.prn('
');

Line 1077: htp.prn('
');
1076:
1077: htp.prn('');
1080: htp.prn('');
1076:
1077: htp.prn('');
1080: htp.prn('');

1075: htp.p('');
1076:
1077: htp.prn('
');
1080: htp.prn('');
1080: htp.prn('');
1096:
1097:

Line 1095: htp.p('');

1091: end loop;
1092: if v_first2 then
1093: htp.prn('
');
1094: end if;
1095: htp.p('');
1096:
1097:
1098: end loop;
1099: IF v_first Then

Line 1100: htp.p(FND_CSS_PKG.Encode(c_name)|| ' has no columns
');

1096:
1097:
1098: end loop;
1099: IF v_first Then
1100: htp.p(FND_CSS_PKG.Encode(c_name)|| ' has no columns
');
1101: else
1102: htp.p('
Name Datatype Length Mandatory Comments

Length
Name Datatype Length Mandatory Comments

Mandatory
Name Datatype Length Mandatory Comments

Comments

Name Datatype Length Mandatory Comments
');

Line 1055: htp.prn('
');

1051: htp.p('
Comments

');
1056: htp.prn(col_rec.column_name);
1057: htp.p(' ');
1059: htp.prn(col_rec.data_type);

Line 1056: htp.prn(col_rec.column_name);

1052: v_first := FALSE;
1053: end if;
1054:
1055: htp.prn('
');
1056: htp.prn(col_rec.column_name);
1057: htp.p(' ');
1059: htp.prn(col_rec.data_type);
1060: htp.p('
');
1056: htp.prn(col_rec.column_name);
1057: htp.p(' ');
1059: htp.prn(col_rec.data_type);
1060: htp.p(' ');

Line 1058: htp.prn('
');

1054:
1055: htp.prn('
');
1056: htp.prn(col_rec.column_name);
1057: htp.p(' ');
1059: htp.prn(col_rec.data_type);
1060: htp.p(' ');
1062: if col_rec.data_type = 'DATE'

Line 1059: htp.prn(col_rec.data_type);

1055: htp.prn('
');
1056: htp.prn(col_rec.column_name);
1057: htp.p(' ');
1059: htp.prn(col_rec.data_type);
1060: htp.p(' ');
1062: if col_rec.data_type = 'DATE'
1063: then htp.prn('
');

Line 1060: htp.p('
');
1059: htp.prn(col_rec.data_type);
1060: htp.p(' ');
1062: if col_rec.data_type = 'DATE'
1063: then htp.prn('
');
1064: elsif (col_rec.data_type = 'NUMBER'

Line 1061: htp.prn('
');

1057: htp.p('
');
1059: htp.prn(col_rec.data_type);
1060: htp.p(' ');
1062: if col_rec.data_type = 'DATE'
1063: then htp.prn('
');
1064: elsif (col_rec.data_type = 'NUMBER'
1065: AND col_rec.data_precision = '
')

Line 1063: then htp.prn('
');

1059: htp.prn(col_rec.data_type);
1060: htp.p('
');
1062: if col_rec.data_type = 'DATE'
1063: then htp.prn('
');
1064: elsif (col_rec.data_type = 'NUMBER'
1065: AND col_rec.data_precision = '
')
1066: then htp.prn('
');
1067: elsif (col_rec.data_type = 'NUMBER'

Line 1066: then htp.prn('
');

1062: if col_rec.data_type = 'DATE'
1063: then htp.prn('
');
1064: elsif (col_rec.data_type = 'NUMBER'
1065: AND col_rec.data_precision = '
')
1066: then htp.prn('
');
1067: elsif (col_rec.data_type = 'NUMBER'
1068: AND col_rec.data_precision != '
')
1069: then htp.prn('('||col_rec.data_precision||')');
1070: elsif col_rec.data_length is null

Line 1069: then htp.prn('('||col_rec.data_precision||')');

1065: AND col_rec.data_precision = '
')
1066: then htp.prn('
');
1067: elsif (col_rec.data_type = 'NUMBER'
1068: AND col_rec.data_precision != '
')
1069: then htp.prn('('||col_rec.data_precision||')');
1070: elsif col_rec.data_length is null
1071: then htp.prn('
');
1072: else
1073: htp.prn('('||col_rec.data_length||')');

Line 1071: then htp.prn('
');

1067: elsif (col_rec.data_type = 'NUMBER'
1068: AND col_rec.data_precision != '
')
1069: then htp.prn('('||col_rec.data_precision||')');
1070: elsif col_rec.data_length is null
1071: then htp.prn('
');
1072: else
1073: htp.prn('('||col_rec.data_length||')');
1074: end if;
1075: htp.p('
');

Line 1075: htp.p('
');
1078: htp.prn(col_rec.nullable);
1079: htp.p(' ');

1073: htp.prn('('||col_rec.data_length||')');
1074: end if;
1075: htp.p('
');
1078: htp.prn(col_rec.nullable);
1079: htp.p(' ');
1081: v_first2 := TRUE;

Line 1078: htp.prn(col_rec.nullable);

1074: end if;
1075: htp.p('
');
1078: htp.prn(col_rec.nullable);
1079: htp.p(' ');
1081: v_first2 := TRUE;
1082: for t_rec in cur_col_comments(c_tname => c_name

Line 1079: htp.p('
');
1078: htp.prn(col_rec.nullable);
1079: htp.p(' ');
1081: v_first2 := TRUE;
1082: for t_rec in cur_col_comments(c_tname => c_name
1083: , c_cname => col_rec.column_name

Line 1080: htp.prn('
');

1076:
1077: htp.prn('
');
1078: htp.prn(col_rec.nullable);
1079: htp.p(' ');
1081: v_first2 := TRUE;
1082: for t_rec in cur_col_comments(c_tname => c_name
1083: , c_cname => col_rec.column_name
1084: , c_owner => c_owner) loop

Line 1087: htp.prn('
');

1083: , c_cname => col_rec.column_name
1084: , c_owner => c_owner) loop
1085: v_first2 := FALSE;
1086: if t_rec.comments like '%- Retrofitted%' then
1087: htp.prn('
');
1088: else
1089: htp.prn(t_rec.comments);
1090: end if;
1091: end loop;

Line 1089: htp.prn(t_rec.comments);

1085: v_first2 := FALSE;
1086: if t_rec.comments like '%- Retrofitted%' then
1087: htp.prn('
');
1088: else
1089: htp.prn(t_rec.comments);
1090: end if;
1091: end loop;
1092: if v_first2 then
1093: htp.prn('
');

Line 1093: htp.prn('
');

1089: htp.prn(t_rec.comments);
1090: end if;
1091: end loop;
1092: if v_first2 then
1093: htp.prn('
');
1094: end if;
1095: htp.p('
');
1103:
1104: -- sql to select from this table

Line 1102: htp.p('');

1098: end loop;
1099: IF v_first Then
1100: htp.p(FND_CSS_PKG.Encode(c_name)|| ' has no columns
');
1101: else
1102: htp.p('');
1103:
1104: -- sql to select from this table
1105: if c_query_text = 'Y' then
1106: htp.p('
Query Text
');

Line 1106: htp.p('
Query Text
');

1102: htp.p('');
1103:
1104: -- sql to select from this table
1105: if c_query_text = 'Y' then
1106: htp.p('
Query Text
');
1107: htp.p('
Cut, paste (and edit) the following text to query this object:
');
1108: v_first := TRUE;
1109: for col_rec in cur_columns(c_name, c_owner) loop
1110: IF v_first Then

Line 1107: htp.p('
Cut, paste (and edit) the following text to query this object:
');

1103:
1104: -- sql to select from this table
1105: if c_query_text = 'Y' then
1106: htp.p('
Query Text
');
1107: htp.p('
Cut, paste (and edit) the following text to query this object:
');
1108: v_first := TRUE;
1109: for col_rec in cur_columns(c_name, c_owner) loop
1110: IF v_first Then
1111: htp.p('
'); Line 1111: htp.p(''); 1107: htp.p(' Cut, paste (and edit) the following text to query this object: '); 1108: v_first := TRUE; 1109: for col_rec in cur_columns(c_name, c_owner) loop 1110: IF v_first Then 1111: htp.p(''); 1112: htp.p('SELECT '||col_rec.column_name); 1113: v_first := FALSE; 1114: else 1115: htp.p(', '||col_rec.column_name); Line 1112: htp.p('SELECT '||col_rec.column_name); 1108: v_first := TRUE; 1109: for col_rec in cur_columns(c_name, c_owner) loop 1110: IF v_first Then 1111: htp.p(' '); 1112: htp.p('SELECT '||col_rec.column_name); 1113: v_first := FALSE; 1114: else 1115: htp.p(', '||col_rec.column_name); 1116: end if; Line 1115: htp.p(', '||col_rec.column_name); 1111: htp.p(' '); 1112: htp.p('SELECT '||col_rec.column_name); 1113: v_first := FALSE; 1114: else 1115: htp.p(', '||col_rec.column_name); 1116: end if; 1117: end loop; 1118: htp.p('FROM '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||';'); 1119: htp.p(' '); Line 1118: htp.p('FROM '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||';'); 1114: else 1115: htp.p(', '||col_rec.column_name); 1116: end if; 1117: end loop; 1118: htp.p('FROM '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||';'); 1119: htp.p(' '); 1120: end if; 1121: end if; 1122: Line 1119: htp.p(' '); 1115: htp.p(', '||col_rec.column_name); 1116: end if; 1117: end loop; 1118: htp.p('FROM '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||';'); 1119: htp.p('
');
1120: end if;
1121: end if;
1122:
1123: end ls_columns;

Line 1162: htp.p(

1158:
1159: begin
1160:
1161: for t_rec in cur_mview(c_name=>c_name, c_owner =>c_owner) loop
1162: htp.p(
1163: '
M-View Details

1164: 1165: summary="dba_types information">
1166:
1290: then null;
1291: else
1292: htp.p('@'||t_rec.db_link);
1293: end if;
1294: htp.p('
1295:
Container: '

Line 1192: htp.p('
MV Log Dependencies:
');

1188:
1189: for d_rec in cur_dtree(c_name=>c_name, c_owner =>c_owner) loop
1190: if vfirst then
1191: vfirst := FALSE;
1192: htp.p('
MV Log Dependencies:
');
1193: htp.p('
'); 1194: end if; 1195: htp.p(d_rec.tree_entry); 1196: end loop; Line 1193: htp.p(''); 1189: for d_rec in cur_dtree(c_name=>c_name, c_owner =>c_owner) loop 1190: if vfirst then 1191: vfirst := FALSE; 1192: htp.p(' MV Log Dependencies: '); 1193: htp.p(''); 1194: end if; 1195: htp.p(d_rec.tree_entry); 1196: end loop; 1197: if vfirst then null; Line 1195: htp.p(d_rec.tree_entry); 1191: vfirst := FALSE; 1192: htp.p(' MV Log Dependencies: '); 1193: htp.p(''); 1194: end if; 1195: htp.p(d_rec.tree_entry); 1196: end loop; 1197: if vfirst then null; 1198: else htp.p(' '); 1199: end if; Line 1198: else htp.p(' '); 1194: end if; 1195: htp.p(d_rec.tree_entry); 1196: end loop; 1197: if vfirst then null; 1198: else htp.p('
');
1199: end if;
1200:
1201: end ls_mview;
1202:

Line 1219: htp.p(

1215:
1216: begin
1217:
1218: for t_rec in cur_trigger(c_name=>c_name, c_owner =>c_owner) loop
1219: htp.p(
1220: '
Trigger Details

1221: 1222: summary="dba_types information">
1223:
1226: ||'&c_owner='|| t_rec.table_owner
1227: ||'&c_type='|| t_rec.base_object_type
1228: , c_display => t_rec.table_owner||'.'||t_rec.table_name);
1229:
1230: htp.p('
1231:
Base Object: ');

Line 1230: htp.p('

');
1232: end loop;
1233: end ls_trigger;
1234:

Line 1251: htp.p(

1247:
1248: begin
1249:
1250: for t_rec in cur_index(c_name=>c_name, c_owner =>c_owner) loop
1251: htp.p(
1252: '
Index Details

1253: 1254: summary="dba_types information">
1255:
1258: ||'&c_owner='|| t_rec.table_owner
1259: ||'&c_type='|| t_rec.table_type
1260: , c_display => t_rec.table_owner||'.'||t_rec.table_name);
1261:
1262: htp.p('
1263:
Base Object: ');

Line 1262: htp.p('

');
1264: end loop;
1265: end ls_index;
1266:

Line 1283: htp.p(

1279:
1280: begin
1281:
1282: for t_rec in cur_synonym(c_name=>c_name, c_owner =>c_owner) loop
1283: htp.p(
1284: '
Synonym Details

1285: 1286: summary="dba_synonyms information">
1287:
1295:
Base Object: '

Line 1292: htp.p('@'||t_rec.db_link);

1288: ||t_rec.table_owner||'.'||t_rec.table_name);
1289: if t_rec.db_link is null
1290: then null;
1291: else
1292: htp.p('@'||t_rec.db_link);
1293: end if;
1294: htp.p('
');
1296: end loop;

Line 1294: htp.p('

');
1296: end loop;
1297: end ls_synonym;
1298:

Line 1319: htp.p(

1315:
1316: begin
1317:
1318: for t_rec in cur_queue(c_name=>c_name, c_owner =>c_owner) loop
1319: htp.p(
1320: '
Queue Details

1321: 1322: summary="dba_queues information">
1323:
1523: ');
1524: end loop;
1525: htp.p('
Queue Table: '

Line 1445: htp.p(

1441:
1442: begin
1443:
1444: for t_rec in cur_type(c_name=>c_name, c_owner =>c_owner) loop
1445: htp.p(
1446: '
Type Details

1447: 1448: summary="dba_types information">
1449:
Type Code: '

Line 1459: htp.p(

1455:
');
1456:
1457: if t_rec.typecode = 'COLLECTION' then
1458: for c_rec in cur_collection(c_name=>c_name, c_owner =>c_owner) loop
1459: htp.p(
1460: '
Collection Details

1461: 1462: summary="dba_coll_types information">
1463:
Line 1478: htp.p('

1474: htp.p(nvl(c_rec.elem_type_name, '
'));
1475: end if;
1476:
1477:
1478: htp.p('
1479:
Collection Type: '

Line 1474: htp.p(nvl(c_rec.elem_type_name, '
'));

1470: ||'&c_owner='||c_rec.ELEM_TYPE_OWNER
1471: ||'&c_type=TYPE'
1472: , c_display => c_rec.elem_type_name);
1473: else
1474: htp.p(nvl(c_rec.elem_type_name, '
'));
1475: end if;
1476:
1477:
1478: htp.p('

');
1480: end loop;
1481: end if;
1482:

Line 1486: htp.p('

1482:
1483:
1484:
1485: if t_rec.attributes > 0 then
1486: htp.p('
1487:
Attributes

1488: 1489: summary="Attributes for this type">
1490:
Line 1498: htp.p('

1494:

1495: ');
1496:
1497: for a_rec in cur_attribute(c_name=>c_name, c_owner =>c_owner) loop
1498: htp.p('
1499:
1501: ');
1512: htp.p('');
1507: , c_display => a_rec.attr_type_name);
1508: else
1509: htp.p(nvl(a_rec.attr_type_name, '
'));
1510: end if;
1511: htp.p('');
1512: htp.p('
');
1512: htp.p('');
1512: htp.p('
1521:

1516: else
1517: htp.p('
');
1518: end if;
1519:
1520: htp.p('
1521:

1523: ');
1524: end loop;

Line 1525: htp.p('
Prcn

'
1500: ||a_rec.attr_name||' ');
1502: if a_rec.ATTR_TYPE_OWNER is not null then

Line 1509: htp.p(nvl(a_rec.attr_type_name, '
'));

1505: ||'&c_owner='||a_rec.ATTR_TYPE_OWNER
1506: ||'&c_type=TYPE'
1507: , c_display => a_rec.attr_type_name);
1508: else
1509: htp.p(nvl(a_rec.attr_type_name, '
'));
1510: end if;
1511: htp.p('
');
1513:

Line 1511: htp.p('
');
1513:
1514: if a_rec.length is not null then
1515: htp.p('('||a_rec.length||')');

Line 1512: htp.p('
');

1508: else
1509: htp.p(nvl(a_rec.attr_type_name, '
'));
1510: end if;
1511: htp.p('
');
1513:
1514: if a_rec.length is not null then
1515: htp.p('('||a_rec.length||')');
1516: else

Line 1515: htp.p('('||a_rec.length||')');

1511: htp.p('
');
1513:
1514: if a_rec.length is not null then
1515: htp.p('('||a_rec.length||')');
1516: else
1517: htp.p('
');
1518: end if;
1519:

Line 1517: htp.p('
');

1513:
1514: if a_rec.length is not null then
1515: htp.p('('||a_rec.length||')');
1516: else
1517: htp.p('
');
1518: end if;
1519:
1520: htp.p('
'

Line 1520: htp.p('
'
1522: ||nvl(to_char(a_rec.precision), '
')||'
');

1521:
'
1522: ||nvl(to_char(a_rec.precision), '
')||'

');
1526: end if;
1527:
1528: if t_rec.methods > 0 then
1529: htp.p('

Line 1529: htp.p('

1525: htp.p('');
1526: end if;
1527:
1528: if t_rec.methods > 0 then
1529: htp.p('
1530:
Methods

1531: 1532: summary="Attributes for this type">
1533:
Line 1540: htp.p('

1536:

1537: ');
1538:
1539: for a_rec in cur_method(c_name=>c_name, c_owner =>c_owner) loop
1540: htp.p('
1541:
1543: ');
1556:
1557:
Line 1555: htp.p('');

1551: end loop;
1552: else
1553: htp.p('
');
1554: end if;
1555: htp.p('');
1556:
1557:
1558: htp.p('
');
1556:
1557:
1558: htp.p('
1572: ');

Line 1571: htp.p('

1567: else
1568: htp.p('
');
1569: end if;
1570:
1571: htp.p('
1572: ');
1573: end loop;
1574: htp.p('
Result

'
1542: ||a_rec.method_name||' ');
1544:

Line 1550: htp.p(''||p_rec.param_name || '('||p_rec.param_type_name||')
');

1546: for p_rec in cur_mparam(c_name => c_name
1547: , c_owner => c_owner
1548: , c_method => a_rec.method_name
1549: , n_methno => a_rec.method_no) loop
1550: htp.p(''||p_rec.param_name || '('||p_rec.param_type_name||')
');
1551: end loop;
1552: else
1553: htp.p('
');
1554: end if;

Line 1553: htp.p('
');

1549: , n_methno => a_rec.method_no) loop
1550: htp.p(''||p_rec.param_name || '('||p_rec.param_type_name||')
');
1551: end loop;
1552: else
1553: htp.p('
');
1554: end if;
1555: htp.p('
');
1559:

Line 1558: htp.p('
');

1554: end if;
1555: htp.p('
');
1559:
1560: if a_rec.results > 0 then
1561: for p_rec in cur_mresult(c_name => c_name
1562: , c_owner => c_owner

Line 1565: htp.p(p_rec.result_type_name||'
');

1561: for p_rec in cur_mresult(c_name => c_name
1562: , c_owner => c_owner
1563: , c_method => a_rec.method_name
1564: , n_methno => a_rec.method_no) loop
1565: htp.p(p_rec.result_type_name||'
');
1566: end loop;
1567: else
1568: htp.p('
');
1569: end if;

Line 1568: htp.p('
');

1564: , n_methno => a_rec.method_no) loop
1565: htp.p(p_rec.result_type_name||'
');
1566: end loop;
1567: else
1568: htp.p('
');
1569: end if;
1570:
1571: htp.p('
');
1575: end if;

Line 1574: htp.p('');

1570:
1571: htp.p('
1572: ');
1573: end loop;
1574: htp.p('');
1575: end if;
1576:
1577:
1578: end loop;

Line 1606: htp.p('

1602:
1603: begin
1604: v_first := TRUE;
1605: v_owner := 'foRce_mE_to_diff';
1606: htp.p('
1607:
[top of page]
');
1608:
1609: for a_rec in cur_depend2(n_object_id) loop
1610: IF v_first Then

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

1607:
[top of page]
');
1608:
1609: for a_rec in cur_depend2(n_object_id) loop
1610: IF v_first Then
1611: htp.p(''||etrm_pnav.get_object_name(n_object_id)
1612: || ' references the following:
');
1613: htp.p('
');
1614: v_first := FALSE;
1615: end if;

Line 1613: htp.p('
');

1609: for a_rec in cur_depend2(n_object_id) loop
1610: IF v_first Then
1611: htp.p(''||etrm_pnav.get_object_name(n_object_id)
1612: || ' references the following:
');
1613: htp.p('
');
1614: v_first := FALSE;
1615: end if;
1616:
1617: if a_rec.owner = v_owner then

Line 1621: htp.p('
');

1617: if a_rec.owner = v_owner then
1618: null;
1619: else
1620: v_owner := a_rec.owner;
1621: htp.p('
');
1622: if a_rec.owner is not null then
1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1624: end if;
1625: htp.p('
');

Line 1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');

1619: else
1620: v_owner := a_rec.owner;
1621: htp.p('
');
1622: if a_rec.owner is not null then
1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1624: end if;
1625: htp.p('
');
1626: end if;
1627:

Line 1625: htp.p('');

1621: htp.p('
');
1622: if a_rec.owner is not null then
1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1624: end if;
1625: htp.p('
');
1626: end if;
1627:
1628:
1629: htp.p('
');

Line 1629: htp.p('
');

1625: htp.p('');
1626: end if;
1627:
1628:
1629: htp.p('
');
1630: a_href_gen(a_rec.object_id);
1631: if get_object_name(a_rec.object_id, 'TYPE') in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE')
1632: then htp.prn(' - ');
1633: uiutil.a_href_gen(c_type => 'NONE'

Line 1632: then htp.prn(' - ');

1628:
1629: htp.p('
');
1630: a_href_gen(a_rec.object_id);
1631: if get_object_name(a_rec.object_id, 'TYPE') in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE')
1632: then htp.prn(' - ');
1633: uiutil.a_href_gen(c_type => 'NONE'
1634: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='
1635: || n_object_id
1636: || '&c_name='

Line 1642: htp.p('
');

1638: , c_display => ' show dependent code');
1639: end if;
1640:
1641:
1642: htp.p('');
1643: end loop;
1644:
1645:
1646: IF v_first Then

Line 1647: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');

1643: end loop;
1644:
1645:
1646: IF v_first Then
1647: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
1648: else
1649: htp.p('
');
1650: v_first := TRUE;
1651: end if;

Line 1649: htp.p('
');

1645:
1646: IF v_first Then
1647: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
1648: else
1649: htp.p('');
1650: v_first := TRUE;
1651: end if;
1652:
1653:

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

1655: v_owner := 'foRce_mE_to_diff';
1656:
1657: for a_rec in cur_depend(n_object_id) loop
1658: IF v_first Then
1659: htp.p(''||etrm_pnav.get_object_name(n_object_id)
1660: || ' is referenced by following:
');
1661: htp.p('
');
1662: v_first := FALSE;
1663: end if;

Line 1661: htp.p('
');

1657: for a_rec in cur_depend(n_object_id) loop
1658: IF v_first Then
1659: htp.p(''||etrm_pnav.get_object_name(n_object_id)
1660: || ' is referenced by following:
');
1661: htp.p('
');
1662: v_first := FALSE;
1663: end if;
1664:
1665: if a_rec.owner = v_owner then

Line 1669: htp.p('
');

1665: if a_rec.owner = v_owner then
1666: null;
1667: else
1668: v_owner := a_rec.owner;
1669: htp.p('
');
1670: if a_rec.owner is not null then
1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1672: end if;
1673: htp.p('
');

Line 1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');

1667: else
1668: v_owner := a_rec.owner;
1669: htp.p('
');
1670: if a_rec.owner is not null then
1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1672: end if;
1673: htp.p('
');
1674: end if;
1675:

Line 1673: htp.p('');

1669: htp.p('
');
1670: if a_rec.owner is not null then
1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1672: end if;
1673: htp.p('
');
1674: end if;
1675:
1676: htp.p('
');
1677: a_href_gen(a_rec.object_id);

Line 1676: htp.p('
');

1672: end if;
1673: htp.p('');
1674: end if;
1675:
1676: htp.p('
');
1677: a_href_gen(a_rec.object_id);
1678: if get_object_name(a_rec.object_id, 'TYPE') in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE')
1679: then htp.prn(' - ');
1680: uiutil.a_href_gen(c_type => 'NONE'

Line 1679: then htp.prn(' - ');

1675:
1676: htp.p('
');
1677: a_href_gen(a_rec.object_id);
1678: if get_object_name(a_rec.object_id, 'TYPE') in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE')
1679: then htp.prn(' - ');
1680: uiutil.a_href_gen(c_type => 'NONE'
1681: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='
1682: || a_rec.object_id
1683: || '&c_name='

Line 1688: htp.p('
');

1684: || get_object_name(n_object_id, 'ITEM')
1685: , c_display => ' show dependent code');
1686: end if;
1687:
1688: htp.p('');
1689: end loop;
1690:
1691:
1692: IF v_first Then

Line 1693: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');

1689: end loop;
1690:
1691:
1692: IF v_first Then
1693: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
1694: else
1695: htp.p('
');
1696: v_first := TRUE;
1697: end if;

Line 1695: htp.p('
');

1691:
1692: IF v_first Then
1693: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
1694: else
1695: htp.p('');
1696: v_first := TRUE;
1697: end if;
1698:
1699: end ls_dependencies;

Line 1749: htp.p('
View Text - Preformatted
');

1745: begin
1746:
1747: if c_type = 'VIEW' then
1748: for t_rec in cur_vw_source(c_name, c_owner) loop
1749: htp.p('
View Text - Preformatted
');
1750: htp.p('
'); 1751: htp.p(t_rec.text); 1752: htp.p('
');
1753:

Line 1750: htp.p('
');
1746: 1747: if c_type = 'VIEW' then 1748: for t_rec in cur_vw_source(c_name, c_owner) loop 1749: htp.p('
View Text - Preformatted
'); 1750: htp.p(''); 1751: htp.p(t_rec.text); 1752: htp.p(' '); 1753: 1754: v_viewtext := upper(t_rec.text); Line 1751: htp.p(t_rec.text); 1747: if c_type = 'VIEW' then 1748: for t_rec in cur_vw_source(c_name, c_owner) loop 1749: htp.p(' View Text - Preformatted '); 1750: htp.p(''); 1751: htp.p(t_rec.text); 1752: htp.p(' '); 1753: 1754: v_viewtext := upper(t_rec.text); 1755: v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
Line 1752: htp.p('');

1748: for t_rec in cur_vw_source(c_name, c_owner) loop
1749: htp.p('
View Text - Preformatted
');
1750: htp.p('
'); 1751: htp.p(t_rec.text); 1752: htp.p('
');
1753:
1754: v_viewtext := upper(t_rec.text);
1755: v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
1756: v_viewtext := replace(v_viewtext , 'UNION ', 'UNION ');

Line 1762: htp.p('
View Text - HTML Formatted
');

1758: v_viewtext := replace(v_viewtext , ' WHERE ', '
WHERE ');
1759: v_viewtext := replace(v_viewtext , ',', '
, ');
1760: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
1761:
1762: htp.p('
View Text - HTML Formatted
');
1763: htp.p('
');
1764: htp.p(v_viewtext);
1765: htp.p('
');
1766: end loop;

Line 1763: htp.p('
');

1759: v_viewtext := replace(v_viewtext , ',', '
, ');
1760: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
1761:
1762: htp.p('
View Text - HTML Formatted
');
1763: htp.p('
');
1764: htp.p(v_viewtext);
1765: htp.p('
');
1766: end loop;
1767: elsif c_type = 'MATERIALIZED VIEW' then

Line 1764: htp.p(v_viewtext);

1760: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
1761:
1762: htp.p('
View Text - HTML Formatted
');
1763: htp.p('
');
1764: htp.p(v_viewtext);
1765: htp.p('
');
1766: end loop;
1767: elsif c_type = 'MATERIALIZED VIEW' then
1768: for t_rec in cur_mview(c_name, c_owner) loop

Line 1765: htp.p('
');

1761:
1762: htp.p('
View Text - HTML Formatted
');
1763: htp.p('
');
1764: htp.p(v_viewtext);
1765: htp.p('
');
1766: end loop;
1767: elsif c_type = 'MATERIALIZED VIEW' then
1768: for t_rec in cur_mview(c_name, c_owner) loop
1769: htp.p('
'); Line 1769: htp.p(''); 1765: htp.p(' '); 1766: end loop; 1767: elsif c_type = 'MATERIALIZED VIEW' then 1768: for t_rec in cur_mview(c_name, c_owner) loop 1769: htp.p(''); 1770: htp.p(t_rec.query); 1771: htp.p(' '); 1772: end loop; 1773: elsif c_type = 'TRIGGER' then Line 1770: htp.p(t_rec.query); 1766: end loop; 1767: elsif c_type = 'MATERIALIZED VIEW' then 1768: for t_rec in cur_mview(c_name, c_owner) loop 1769: htp.p(' '); 1770: htp.p(t_rec.query); 1771: htp.p(' '); 1772: end loop; 1773: elsif c_type = 'TRIGGER' then 1774: for t_rec in cur_trigger(c_name, c_owner) loop Line 1771: htp.p('
'); 1767: elsif c_type = 'MATERIALIZED VIEW' then 1768: for t_rec in cur_mview(c_name, c_owner) loop 1769: htp.p(' '); 1770: htp.p(t_rec.query); 1771: htp.p(' '); 1772: end loop; 1773: elsif c_type = 'TRIGGER' then 1774: for t_rec in cur_trigger(c_name, c_owner) loop 1775: htp.p('Description '); Line 1775: htp.p(' Description ');
1771: htp.p('');
1772: end loop;
1773: elsif c_type = 'TRIGGER' then
1774: for t_rec in cur_trigger(c_name, c_owner) loop
1775: htp.p('
Description
');
1776: htp.p('
'||t_rec.description||'
');
1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');

Line 1776: htp.p('
'||t_rec.description||'
');

1772: end loop;
1773: elsif c_type = 'TRIGGER' then
1774: for t_rec in cur_trigger(c_name, c_owner) loop
1775: htp.p('
Description
');
1776: htp.p('
'||t_rec.description||'
');
1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');

Line 1777: htp.p('
Type
');

1773: elsif c_type = 'TRIGGER' then
1774: for t_rec in cur_trigger(c_name, c_owner) loop
1775: htp.p('
Description
');
1776: htp.p('
'||t_rec.description||'
');
1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');

Line 1778: htp.p('
'||t_rec.trigger_type||'
');

1774: for t_rec in cur_trigger(c_name, c_owner) loop
1775: htp.p('
Description
');
1776: htp.p('
'||t_rec.description||'
');
1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');

Line 1779: htp.p('
Event
');

1775: htp.p('
Description
');
1776: htp.p('
'||t_rec.description||'
');
1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');

Line 1780: htp.p('
'||t_rec.triggering_event||'
');

1776: htp.p('
'||t_rec.description||'
');
1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');

Line 1781: htp.p('
Column
');

1777: htp.p('
Type
');
1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');

Line 1782: htp.p('
'||t_rec.column_name||'
');

1778: htp.p('
'||t_rec.trigger_type||'
');
1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');
1786: htp.p('
'||t_rec.referencing_names||'
');

Line 1783: htp.p('
When
');

1779: htp.p('
Event
');
1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');
1786: htp.p('
'||t_rec.referencing_names||'
');
1787: htp.p('
Body
');

Line 1784: htp.p('
'||t_rec.when_clause||'
');

1780: htp.p('
'||t_rec.triggering_event||'
');
1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');
1786: htp.p('
'||t_rec.referencing_names||'
');
1787: htp.p('
Body
');
1788: htp.p('
'||t_rec.trigger_body||'
');

Line 1785: htp.p('
Referencing
');

1781: htp.p('
Column
');
1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');
1786: htp.p('
'||t_rec.referencing_names||'
');
1787: htp.p('
Body
');
1788: htp.p('
'||t_rec.trigger_body||'
');
1789: end loop;

Line 1786: htp.p('
'||t_rec.referencing_names||'
');

1782: htp.p('
'||t_rec.column_name||'
');
1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');
1786: htp.p('
'||t_rec.referencing_names||'
');
1787: htp.p('
Body
');
1788: htp.p('
'||t_rec.trigger_body||'
');
1789: end loop;
1790: else

Line 1787: htp.p('
Body
');

1783: htp.p('
When
');
1784: htp.p('
'||t_rec.when_clause||'
');
1785: htp.p('
Referencing
');
1786: htp.p('
'||t_rec.referencing_names||'
');
1787: htp.p('
Body
');
1788: htp.p('
'||t_rec.trigger_body||'
');
1789: end loop;
1790: else
1791: htp.p('
'); Line 1788: htp.p(''||t_rec.trigger_body||' '); 1784: htp.p(' '||t_rec.when_clause||' '); 1785: htp.p('Referencing '); 1786: htp.p(''||t_rec.referencing_names||' '); 1787: htp.p('Body '); 1788: htp.p(''||t_rec.trigger_body||' '); 1789: end loop; 1790: else 1791: htp.p(''); 1792: for t_rec in cur_source(c_name, c_type, c_owner) loop Line 1791: htp.p(''); 1787: htp.p(' Body '); 1788: htp.p(''||t_rec.trigger_body||' '); 1789: end loop; 1790: else 1791: htp.p(''); 1792: for t_rec in cur_source(c_name, c_type, c_owner) loop 1793: uiutil.txt_p(t_rec.line||' '||t_rec.text); 1794: end loop; 1795: htp.p(' '); Line 1795: htp.p(' '); 1791: htp.p(' '); 1792: for t_rec in cur_source(c_name, c_type, c_owner) loop 1793: uiutil.txt_p(t_rec.line||' '||t_rec.text); 1794: end loop; 1795: htp.p(' '); 1796: end if; 1797: 1798: end ls_source; 1799: Line 1821: htp.p('Content-type: application/octet-stream'); 1817: where view_name = c_name 1818: and owner = c_owner; 1819: 1820: begin 1821: htp.p('Content-type: application/octet-stream'); 1822: htp.p('Content-Disposition: attachement; filename='||c_name||'.sql'); 1823: htp.p('Content-Transfer-Encoding: base64'); 1824: -- htp.p('Content-Disposition: inline; filename='||c_name||'.txt'); 1825: htp.p(''); Line 1822: htp.p('Content-Disposition: attachement; filename='||c_name||'.sql'); 1818: and owner = c_owner; 1819: 1820: begin 1821: htp.p('Content-type: application/octet-stream'); 1822: htp.p('Content-Disposition: attachement; filename='||c_name||'.sql'); 1823: htp.p('Content-Transfer-Encoding: base64'); 1824: -- htp.p('Content-Disposition: inline; filename='||c_name||'.txt'); 1825: htp.p(''); 1826: Line 1823: htp.p('Content-Transfer-Encoding: base64'); 1819: 1820: begin 1821: htp.p('Content-type: application/octet-stream'); 1822: htp.p('Content-Disposition: attachement; filename='||c_name||'.sql'); 1823: htp.p('Content-Transfer-Encoding: base64'); 1824: -- htp.p('Content-Disposition: inline; filename='||c_name||'.txt'); 1825: htp.p(''); 1826: 1827: if c_type = 'VIEW' then Line 1824: -- htp.p('Content-Disposition: inline; filename='||c_name||'.txt'); 1820: begin 1821: htp.p('Content-type: application/octet-stream'); 1822: htp.p('Content-Disposition: attachement; filename='||c_name||'.sql'); 1823: htp.p('Content-Transfer-Encoding: base64'); 1824: -- htp.p('Content-Disposition: inline; filename='||c_name||'.txt'); 1825: htp.p(''); 1826: 1827: if c_type = 'VIEW' then 1828: for t_rec in cur_vw_source(c_name, c_owner) loop Line 1825: htp.p(''); 1821: htp.p('Content-type: application/octet-stream'); 1822: htp.p('Content-Disposition: attachement; filename='||c_name||'.sql'); 1823: htp.p('Content-Transfer-Encoding: base64'); 1824: -- htp.p('Content-Disposition: inline; filename='||c_name||'.txt'); 1825: htp.p(''); 1826: 1827: if c_type = 'VIEW' then 1828: for t_rec in cur_vw_source(c_name, c_owner) loop 1829: htp.prn(t_rec.text); Line 1829: htp.prn(t_rec.text); 1825: htp.p(''); 1826: 1827: if c_type = 'VIEW' then 1828: for t_rec in cur_vw_source(c_name, c_owner) loop 1829: htp.prn(t_rec.text); 1830: end loop; 1831: else 1832: for t_rec in cur_source(c_name, c_type, c_owner) loop 1833: htp.prn(t_rec.text); Line 1833: htp.prn(t_rec.text); 1829: htp.prn(t_rec.text); 1830: end loop; 1831: else 1832: for t_rec in cur_source(c_name, c_type, c_owner) loop 1833: htp.prn(t_rec.text); 1834: end loop; 1835: end if; 1836: 1837: htp.p(''); Line 1837: htp.p(''); 1833: htp.prn(t_rec.text); 1834: end loop; 1835: end if; 1836: 1837: htp.p(''); 1838: htp.prn(chr(4)); 1839: end download_source; 1840: 1841: procedure ls_errors(c_name IN dba_objects.object_name%type Line 1838: htp.prn(chr(4)); 1834: end loop; 1835: end if; 1836: 1837: htp.p(''); 1838: htp.prn(chr(4)); 1839: end download_source; 1840: 1841: procedure ls_errors(c_name IN dba_objects.object_name%type 1842: , c_type IN dba_objects.object_type%type Line 1866: htp.p(' Error Text '); 1862: v_first := TRUE; 1863: 1864: for e_rec in cur_errors(c_name, c_type, c_owner) loop 1865: IF v_first Then 1866: htp.p(' Error Text '); 1867: htp.p(' 1868: summary="Errors recorded in dba_errors">'); 1869: htp.p(''); 1870: htp.p(''); Line 1867: htp.p(' Line 1863: 1864: for e_rec in cur_errors(c_name, c_type, c_owner) loop 1865: IF v_first Then 1866: htp.p(' Error Text '); 1867: htp.p(' 1868: summary="Errors recorded in dba_errors">'); 1869: htp.p(''); 1870: htp.p(''); 1871: htp.p(''); Line 1869: htp.p(' '); 1865: IF v_first Then 1866: htp.p(' Error Text '); 1867: htp.p(' Line Pos''n 1868: summary="Errors recorded in dba_errors">'); 1869: htp.p(''); 1870: htp.p(''); 1871: htp.p(''); 1872: htp.p(''); 1873: v_first := FALSE; Line 1870: htp.p(' '); 1866: htp.p(' Error Text '); 1867: htp.p(' Line Pos''n Text Line 1868: summary="Errors recorded in dba_errors">'); 1869: htp.p(''); 1870: htp.p(''); 1871: htp.p(''); 1872: htp.p(''); 1873: v_first := FALSE; 1874: end if; Line 1871: htp.p(' '); 1867: htp.p(' Line Pos''n Text Pos''n 1868: summary="Errors recorded in dba_errors">'); 1869: htp.p(''); 1870: htp.p(''); 1871: htp.p(''); 1872: htp.p(''); 1873: v_first := FALSE; 1874: end if; 1875: Line 1872: htp.p(' '); 1868: summary="Errors recorded in dba_errors">'); 1869: htp.p(' '); 1870: htp.p(''); 1871: htp.p(''); 1872: htp.p(''); 1873: v_first := FALSE; 1874: end if; 1875: 1876: htp.prn(''); 1873: v_first := FALSE; 1874: end if; 1875: 1876: htp.prn(''); 1879: htp.prn(''); 1879: htp.prn(''); Line 1878: htp.p(''); 1874: end if; 1875: 1876: htp.prn(''); 1879: htp.prn(''); 1882: htp.prn(''); 1879: htp.prn(''); 1882: htp.prn(''); 1879: htp.prn(''); 1882: htp.prn(''); Line 1881: htp.p(''); 1877: htp.prn(e_rec.line); 1878: htp.p(''); 1879: htp.prn(''); 1882: htp.prn(''); 1885: Line 1882: htp.prn(' '); 1879: htp.prn(''); 1882: htp.prn(''); 1885: 1886: htp.p(''); Line 1883: htp.prn(e_rec.text); 1879: htp.prn(''); 1882: htp.prn(''); 1885: 1886: htp.p(''); 1887: end loop; Line 1884: htp.p(''); 1880: htp.prn(e_rec.position); 1881: htp.p(''); 1882: htp.prn(''); 1885: 1886: htp.p(''); 1887: end loop; 1888: IF v_first Then Line 1886: htp.p(''); 1882: htp.prn(' '); 1885: 1886: htp.p(''); 1887: end loop; 1888: IF v_first Then 1889: htp.p(c_name|| ' no errors'); 1890: else Line 1889: htp.p(c_name|| ' no errors'); 1885: 1886: htp.p(''); 1887: end loop; 1888: IF v_first Then 1889: htp.p(c_name|| ' no errors '); 1890: else 1891: htp.p(' Line Pos''n Text Text Line Pos''n Text '); Line 1876: htp.prn(' '); 1872: htp.p(' Text '); 1877: htp.prn(e_rec.line); 1878: htp.p(' '); 1880: htp.prn(e_rec.position); Line 1877: htp.prn(e_rec.line); 1873: v_first := FALSE; 1874: end if; 1875: 1876: htp.prn(' '); 1877: htp.prn(e_rec.line); 1878: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); 1877: htp.prn(e_rec.line); 1878: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); Line 1879: htp.prn(' '); 1875: 1876: htp.prn(' '); 1877: htp.prn(e_rec.line); 1878: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); 1883: htp.prn(e_rec.text); Line 1880: htp.prn(e_rec.position); 1876: htp.prn(' '); 1877: htp.prn(e_rec.line); 1878: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); 1883: htp.prn(e_rec.text); 1884: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); 1883: htp.prn(e_rec.text); 1884: htp.p(' '); 1878: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); 1883: htp.prn(e_rec.text); 1884: htp.p(' '); 1880: htp.prn(e_rec.position); 1881: htp.p(' '); 1883: htp.prn(e_rec.text); 1884: htp.p(' '); 1883: htp.prn(e_rec.text); 1884: htp.p(' '); 1883: htp.prn(e_rec.text); 1884: htp.p(' '); 1892: v_first := TRUE; 1893: end if; Line 1891: htp.p(''); 1887: end loop; 1888: IF v_first Then 1889: htp.p(c_name|| ' no errors '); 1890: else 1891: htp.p(''); 1892: v_first := TRUE; 1893: end if; 1894: 1895: end ls_errors; Line 1911: htp.p(' DBA Objects '); 1907: uiutil.cabo2b; 1908: etrm_pnav.draw_tabs; 1909: uiutil.cabo3; 1910: 1911: htp.p(' DBA Objects '); 1912: htp.p(''); 1913: 1914: htp.p(''); 1915: uiutil.a_href_gen(c_type => 'APP' Line 1912: htp.p(''); 1908: etrm_pnav.draw_tabs; 1909: uiutil.cabo3; 1910: 1911: htp.p(' DBA Objects '); 1912: htp.p(''); 1913: 1914: htp.p(''); 1915: uiutil.a_href_gen(c_type => 'APP' 1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS' Line 1914: htp.p(''); 1910: 1911: htp.p(' DBA Objects '); 1912: htp.p(''); 1913: 1914: htp.p(''); 1915: uiutil.a_href_gen(c_type => 'APP' 1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS' 1917: , c_display => 'Applications Product Prefixes'); 1918: htp.p(' '); Line 1918: htp.p(' '); 1914: htp.p(' '); 1915: uiutil.a_href_gen(c_type => 'APP' 1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS' 1917: , c_display => 'Applications Product Prefixes'); 1918: htp.p(' '); 1919: htp.p(''); 1920: uiutil.a_href_gen(c_type => 'APP' 1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER' 1922: , c_display => 'Database Schemas'); Line 1919: htp.p(''); 1915: uiutil.a_href_gen(c_type => 'APP' 1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS' 1917: , c_display => 'Applications Product Prefixes'); 1918: htp.p(' '); 1919: htp.p(''); 1920: uiutil.a_href_gen(c_type => 'APP' 1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER' 1922: , c_display => 'Database Schemas'); 1923: htp.p(' '); Line 1923: htp.p(' '); 1919: htp.p(' '); 1920: uiutil.a_href_gen(c_type => 'APP' 1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER' 1922: , c_display => 'Database Schemas'); 1923: htp.p(' '); 1924: 1925: htp.p(' '); 1926: 1927: uiutil.cabo4; Line 1925: htp.p(''); 1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER' 1922: , c_display => 'Database Schemas'); 1923: htp.p(''); 1924: 1925: htp.p(''); 1926: 1927: uiutil.cabo4; 1928: etrm_pnav.quick_list; 1929: uiutil.cabo5; Line 1994: htp.p(''); 1990: etrm_pnav.draw_tabs; 1991: uiutil.cabo3; 1992: if vapps_installation then 1993: 1994: htp.p(' '); 1995: htp.p(' 1996: Applications Product Prefixes '); 1997: open fnd_cv for sql_stmt; 1998: loop Line 1995: htp.p(' 1991: uiutil.cabo3; 1992: if vapps_installation then 1993: 1994: htp.p(' '); 1995: htp.p(' 1996: Applications Product Prefixes '); 1997: open fnd_cv for sql_stmt; 1998: loop 1999: fetch fnd_cv into fnd_name, fnd_title; Line 2002: htp.p(''); 1998: loop 1999: fetch fnd_cv into fnd_name, fnd_title; 2000: exit when fnd_cv%NOTFOUND; 2001: vsearch_name := fnd_name ||'\_*'; 2002: htp.p(' '); 2003: uiutil.a_href_gen(c_type => 'APP' 2004: , c_link => 'etrm_pnav.ls_object?c_name=' 2005: || vsearch_name 2006: , c_display => fnd_name||' - '||fnd_title); Line 2008: htp.p(' '); 2004: , c_link => 'etrm_pnav.ls_object?c_name=' 2005: || vsearch_name 2006: , c_display => fnd_name||' - '||fnd_title); 2007: 2008: htp.p(''); 2009: end loop; 2010: if fnd_cv%ISOPEN then close fnd_cv; end if; 2011: 2012: htp.p(' '); Line 2012: htp.p(' '); 2008: htp.p(''); 2009: end loop; 2010: if fnd_cv%ISOPEN then close fnd_cv; end if; 2011: 2012: htp.p(''); 2013: else 2014: 2015: htp.p(' '); 2016: htp.p(' Line 2015: htp.p(''); 2011: 2012: htp.p(' '); 2013: else 2014: 2015: htp.p(''); 2016: htp.p(' 2017: Database Schemas '); 2018: for s_rec in cur_schema loop 2019: Line 2016: htp.p(' 2012: htp.p(' '); 2013: else 2014: 2015: htp.p(''); 2016: htp.p(' 2017: Database Schemas '); 2018: for s_rec in cur_schema loop 2019: 2020: htp.p(''); Line 2020: htp.p(''); 2016: htp.p(' 2017: Database Schemas '); 2018: for s_rec in cur_schema loop 2019: 2020: htp.p(''); 2021: uiutil.a_href_gen(c_type => 'APP' 2022: , c_link => 'etrm_pnav.ls_object?c_name=*' 2023: ||'&c_owner=' 2024: ||s_rec.username Line 2027: htp.p(' '); 2023: ||'&c_owner=' 2024: ||s_rec.username 2025: , c_display => s_rec.username); 2026: 2027: htp.p(''); 2028: end loop; 2029: htp.p(' '); 2030: end if; 2031: uiutil.cabo4; Line 2029: htp.p(''); 2025: , c_display => s_rec.username); 2026: 2027: htp.p(''); 2028: end loop; 2029: htp.p(''); 2030: end if; 2031: uiutil.cabo4; 2032: etrm_pnav.quick_list; 2033: uiutil.cabo5; Line 2102: htp.p(''); 2098: 2099: v_object_id dba_objects.object_id%type; 2100: begin 2101: uiutil.cabo1(c_title=> FND_CSS_PKG.Encode(c_type) ||' - '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)); 2102: htp.p(''); 2103: htp.p(''); 2104: htp.p(' [Home] [Help] 2105: [Dependency Information] 2106: '); Line 2103: htp.p(''); 2099: v_object_id dba_objects.object_id%type; 2100: begin 2101: uiutil.cabo1(c_title=> FND_CSS_PKG.Encode(c_type) ||' - '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)); 2102: htp.p(''); 2103: htp.p(''); 2104: htp.p(' [Home] [Help] 2105: [Dependency Information] 2106: '); 2107: Line 2104: htp.p('[Home] [Help] 2100: begin 2101: uiutil.cabo1(c_title=> FND_CSS_PKG.Encode(c_type) ||' - '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)); 2102: htp.p(''); 2103: htp.p(''); 2104: htp.p(' [Home] [Help] 2105: [Dependency Information] 2106: '); 2107: 2108: Line 2109: htp.p(' '||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); 2105: [Dependency Information] 2106: '); 2107: 2108: 2109: htp.p(''||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); 2110: v_object_id := dba_object_info(c_name, c_owner, c_type); 2111: 2112: 2113: Line 2116: htp.p(''); 2112: 2113: 2114: if c_type in ('PACKAGE', 'PACKAGE BODY') 2115: then 2116: htp.p(' '); 2117: 2118: htp.p(' 2115: then 2116: htp.p(' '); 2117: 2118: htp.p(' 2123: ||'&c_detail_type=source">[Package]'); 2124: htp.p(' 2129: ||'&c_detail_type=source">[Package Body]'); 2130: htp.p('[SQL Statements]'); 2133: htp.p(' '); 2134: Line 2133: htp.p(' '); 2129: ||'&c_detail_type=source">[Package Body]'); 2130: htp.p('[SQL Statements]'); 2133: htp.p(' '); 2134: 2135: 2136: elsif c_type in ('PROCEDURE', 'FUNCTION', 'TYPE BODY', 'JAVA SOURCE') 2137: then Line 2138: htp.p(''); 2134: 2135: 2136: elsif c_type in ('PROCEDURE', 'FUNCTION', 'TYPE BODY', 'JAVA SOURCE') 2137: then 2138: htp.p(' '); 2139: htp.p(' 2137: then 2138: htp.p(' '); 2139: htp.p('[Source]'); 2145: htp.p(' '); 2146: elsif (c_type = 'TABLE') 2147: then 2148: ls_table(c_name, c_owner); 2149: etrm_pnav.ls_table(v_object_id); Line 2153: htp.p(' 2177: ||'&c_owner=' 2178: ||utl_url.escape(c_owner) 2179: ||'&c_type=' Line 2199: htp.p(' Dependencies '); 2195: then 2196: ls_type(c_name, c_owner); 2197: end if; 2198: 2199: htp.p(' Dependencies '); 2200: 2201: 2202: etrm_pnav.ls_dependencies(v_object_id); 2203: Line 2206: htp.p(' '); 2202: etrm_pnav.ls_dependencies(v_object_id); 2203: 2204: 2205: 2206: htp.p(' '); 2207: uiutil.prn_copyright; 2208: htp.p(''); 2209: end show_object; 2210: Line 2208: htp.p(''); 2204: 2205: 2206: htp.p(' '); 2207: uiutil.prn_copyright; 2208: htp.p(''); 2209: end show_object; 2210: 2211: procedure show_details(c_name in dba_objects.object_name%type 2212: , c_owner in dba_objects.owner%type Line 2220: htp.p('[Home] [Help] 2216: if c_detail_type = 'download' 2217: then download_source(c_name, c_type, c_owner); 2218: else 2219: uiutil.cabo1(c_title=> c_type ||' - '||c_owner||'.'||c_name); 2220: htp.p('[Home] [Help] 2221: '); 2222: 2223: htp.p(''); 2224: htp.p(''||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); Line 2223: htp.p(''); 2219: uiutil.cabo1(c_title=> c_type ||' - '||c_owner||'.'||c_name); 2220: htp.p('[Home] [Help] 2221: '); 2222: 2223: htp.p(''); 2224: htp.p(''||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); 2225: 2226: if c_detail_type = 'source' 2227: then htp.p('Source '); Line 2224: htp.p(' '||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); 2220: htp.p('[Home] [Help] 2221: '); 2222: 2223: htp.p(''); 2224: htp.p(''||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); 2225: 2226: if c_detail_type = 'source' 2227: then htp.p('Source '); 2228: ls_source(replace(c_name, '%23', '#'), c_type, c_owner); Line 2227: then htp.p(' Source '); 2223: htp.p(''); 2224: htp.p(' '||FND_CSS_PKG.Encode(c_type)||': '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name)||' '); 2225: 2226: if c_detail_type = 'source' 2227: then htp.p('Source '); 2228: ls_source(replace(c_name, '%23', '#'), c_type, c_owner); 2229: elsif c_detail_type = 'exception' 2230: then htp.p('Exceptions '); 2231: ls_errors(c_name, c_type, c_owner); Line 2230: then htp.p(' Exceptions '); 2226: if c_detail_type = 'source' 2227: then htp.p(' Source '); 2228: ls_source(replace(c_name, '%23', '#'), c_type, c_owner); 2229: elsif c_detail_type = 'exception' 2230: then htp.p('Exceptions '); 2231: ls_errors(c_name, c_type, c_owner); 2232: else 2233: htp.p('No further details are available '); 2234: end if; Line 2233: htp.p('No further details are available '); 2229: elsif c_detail_type = 'exception' 2230: then htp.p(' Exceptions '); 2231: ls_errors(c_name, c_type, c_owner); 2232: else 2233: htp.p('No further details are available '); 2234: end if; 2235: 2236: uiutil.prn_copyright; 2237: htp.p(''); Line 2237: htp.p(''); 2233: htp.p(' No further details are available '); 2234: end if; 2235: 2236: uiutil.prn_copyright; 2237: htp.p(''); 2238: end if; 2239: end show_details; 2240: 2241: procedure show_dependent_code(n_object_id in dba_objects.object_id%type Line 2268: htp.p('[Home] [Help] 2264: 2265: begin 2266: v_string := '%'||upper(c_name)||'%'; 2267: uiutil.cabo1(c_title=> c_name || ' dependencies'); 2268: htp.p('[Home] [Help] 2269: '); 2270: 2271: htp.p(''||get_object_name(n_object_id)||' dependencies on '||FND_CSS_PKG.Encode(c_name)||' '); 2272: for t_rec in cur_find_line(n_object_id, v_string) loop Line 2271: htp.p(' '||get_object_name(n_object_id)||' dependencies on '||FND_CSS_PKG.Encode(c_name)||' '); 2267: uiutil.cabo1(c_title=> c_name || ' dependencies'); 2268: htp.p('[Home] [Help] 2269: '); 2270: 2271: htp.p(''||get_object_name(n_object_id)||' dependencies on '||FND_CSS_PKG.Encode(c_name)||' '); 2272: for t_rec in cur_find_line(n_object_id, v_string) loop 2273: v_first := FALSE; 2274: v_line := t_rec.line; 2275: uiutil.txt_prn1('Line '||t_rec.line||': '||t_rec.source||' '); Line 2276: htp.p(''); 2272: for t_rec in cur_find_line(n_object_id, v_string) loop 2273: v_first := FALSE; 2274: v_line := t_rec.line; 2275: uiutil.txt_prn1(' Line '||t_rec.line||': '||t_rec.source||' '); 2276: htp.p(''); 2277: for l_rec in cur_print_line(n_object_id, v_line) loop 2278: if l_rec.line = v_line then 2279: uiutil.txt_prn1(''||l_rec.line||': '||l_rec.source||''); 2280: else Line 2284: htp.p(' '); 2280: else 2281: uiutil.txt_prn1(l_rec.line||': '||l_rec.source); 2282: end if; 2283: end loop; 2284: htp.p(' '); 2285: end loop; 2286: if v_first = TRUE then 2287: htp.p('These dependencies are not visible in source code. They may be indirect dependencies 2288: or the source code may be encrypted '); Line 2287: htp.p('These dependencies are not visible in source code. They may be indirect dependencies 2283: end loop; 2284: htp.p(' '); 2285: end loop; 2286: if v_first = TRUE then 2287: htp.p('These dependencies are not visible in source code. They may be indirect dependencies 2288: or the source code may be encrypted '); 2289: end if; 2290: end show_dependent_code; 2291: Line 2322: htp.p('[Home] [Help] 2318: v_select_stmt line_table; 2319: v_stmt_count binary_integer; 2320: begin 2321: uiutil.cabo1(c_title=> ' SQL Statements'); 2322: htp.p('[Home] [Help] 2323: '); 2324: htp.p(''||get_object_name(n_object_id)||' SQL Statements '); 2325: htp.p('The following lines contain the word ''select'', ''insert'', ''update'' or ''delete'': '); 2326: Line 2324: htp.p(' '||get_object_name(n_object_id)||' SQL Statements '); 2320: begin 2321: uiutil.cabo1(c_title=> ' SQL Statements'); 2322: htp.p('[Home] [Help] 2323: '); 2324: htp.p(''||get_object_name(n_object_id)||' SQL Statements '); 2325: htp.p('The following lines contain the word ''select'', ''insert'', ''update'' or ''delete'': '); 2326: 2327: 2328: for t_rec in cur_find_line(n_object_id) loop Line 2325: htp.p('The following lines contain the word ''select'', ''insert'', ''update'' or ''delete'': '); 2321: uiutil.cabo1(c_title=> ' SQL Statements'); 2322: htp.p('[Home] [Help] 2323: '); 2324: htp.p(''||get_object_name(n_object_id)||' SQL Statements '); 2325: htp.p('The following lines contain the word ''select'', ''insert'', ''update'' or ''delete'': '); 2326: 2327: 2328: for t_rec in cur_find_line(n_object_id) loop 2329: v_source(t_rec.line) := t_rec.source; Line 2374: htp.p(' Line: '||v_select_stmt(i).select_line||' '); 2370: 2371: 2372: for i in 1 .. v_stmt_count loop 2373: if v_select_stmt(i).status = 'VALID' then 2374: htp.p(' Line: '||v_select_stmt(i).select_line||' '); 2375: htp.p(''); 2376: for j in v_select_stmt(i).select_line .. v_select_stmt(i).term_line loop 2377: htp.prn(v_source(j)); 2378: end loop; Line 2375: htp.p(''); 2371: 2372: for i in 1 .. v_stmt_count loop 2373: if v_select_stmt(i).status = 'VALID' then 2374: htp.p(' Line: '||v_select_stmt(i).select_line||' '); 2375: htp.p(''); 2376: for j in v_select_stmt(i).select_line .. v_select_stmt(i).term_line loop 2377: htp.prn(v_source(j)); 2378: end loop; 2379: htp.p(' '); Line 2377: htp.prn(v_source(j)); 2373: if v_select_stmt(i).status = 'VALID' then 2374: htp.p(' Line: '||v_select_stmt(i).select_line||' '); 2375: htp.p(''); 2376: for j in v_select_stmt(i).select_line .. v_select_stmt(i).term_line loop 2377: htp.prn(v_source(j)); 2378: end loop; 2379: htp.p(' '); 2380: end if; 2381: end loop; Line 2379: htp.p(' '); 2375: htp.p(' '); 2376: for j in v_select_stmt(i).select_line .. v_select_stmt(i).term_line loop 2377: htp.prn(v_source(j)); 2378: end loop; 2379: htp.p(' '); 2380: end if; 2381: end loop; 2382: 2383: Line 2385: htp.p('No SQL Statements are visable in the source code. 2381: end loop; 2382: 2383: 2384: if v_stmt_count = 0 then 2385: htp.p(' No SQL Statements are visable in the source code. 2386: The package body may be wrapped (encrypted) '); 2387: end if; 2388: end show_sql; 2389: Line 2426: htp.p(' '); 2422: , replace(c_status, '*', '%')) loop 2423: if v_first = TRUE 2424: then v_first := FALSE; 2425: else 2426: htp.p(' '); 2427: end if; 2428: 2429: uiutil.a_javascript_gen(c_type => c_type 2430: , c_link => 'etrm_pnav.show_object?c_name=' Line 2441: htp.p('Not implemented in this database'); 2437: 2438: end loop; 2439: 2440: if v_first = TRUE then 2441: htp.p('Not implemented in this database'); 2442: end if; 2443: 2444: 2445: end prn_object_type;

Object Name:	'\|\|o_rec.object_name\|\|'
Object Type:	'\|\|o_rec.object_type\|\|'
'\|\|o_rec.object_name\|\|'

Index	Type
Tablespace	Column
'); 951: htp.p(ind_rec.index_name); 952: htp.p('	'); 946:	Column
'); 951: htp.p(ind_rec.index_name); 952: htp.p('	'); Line 951: htp.p(ind_rec.index_name); 947: end if; 948: 949: htp.p('
'); 951: htp.p(ind_rec.index_name); 952: htp.p('	'); 955: htp.p(ind_rec.index_type); Line 952: htp.p('
'); 951: htp.p(ind_rec.index_name); 952: htp.p('	'); 955: htp.p(ind_rec.index_type); 956: htp.p('	'); 950: htp.p('	'); 951: htp.p(ind_rec.index_name); 952: htp.p('	'); 955: htp.p(ind_rec.index_type); 956: htp.p('	'); Line 955: htp.p(ind_rec.index_type); 951: htp.p(ind_rec.index_name); 952: htp.p('	'); 955: htp.p(ind_rec.index_type); 956: htp.p('	'); 959: htp.p(ind_rec.uniqueness); Line 956: htp.p('	'); 955: htp.p(ind_rec.index_type); 956: htp.p('	'); 959: htp.p(ind_rec.uniqueness); 960: htp.p('	'); 954: htp.p('	'); 955: htp.p(ind_rec.index_type); 956: htp.p('	'); 959: htp.p(ind_rec.uniqueness); 960: htp.p('	'); 959: htp.p(ind_rec.uniqueness); 960: htp.p('	'); Line 960: htp.p('	'); 959: htp.p(ind_rec.uniqueness); 960: htp.p('	'); 964: htp.p(uiutil.el_image('TS')\|\|ind_rec.tablespace_name); Line 963: htp.p('	'); 959: htp.p(ind_rec.uniqueness); 960: htp.p('	'); 964: htp.p(uiutil.el_image('TS')\|\|ind_rec.tablespace_name); 965: htp.p('	'); 964: htp.p(uiutil.el_image('TS')\|\|ind_rec.tablespace_name); 965: htp.p('	'); 964: htp.p(uiutil.el_image('TS')\|\|ind_rec.tablespace_name); 965: htp.p('	'); Line 969: htp.p('	'); 965: htp.p('	'); 970: 971: v_first2 := TRUE; 972: if ind_rec.index_type like 'FUNCTION-BASED%' then 973: for ind_col_rec in cur_function_index(ind_rec.index_name, ind_rec.owner) loop Line 977: htp.p(' '); 973: for ind_col_rec in cur_function_index(ind_rec.index_name, ind_rec.owner) loop 974: IF v_first2 Then 975: v_first2 := FALSE; 976: else 977: htp.p(' '); 978: end if; 979: htp.p(uiutil.el_image('COL')\|\|ind_col_rec.column_expression); 980: end loop; 981: else Line 979: htp.p(uiutil.el_image('COL')\|\|ind_col_rec.column_expression); 975: v_first2 := FALSE; 976: else 977: htp.p(' '); 978: end if; 979: htp.p(uiutil.el_image('COL')\|\|ind_col_rec.column_expression); 980: end loop; 981: else 982: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop 983: IF v_first2 Then Line 986: htp.p(' '); 982: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop 983: IF v_first2 Then 984: v_first2 := FALSE; 985: else 986: htp.p(' '); 987: end if; 988: htp.p(uiutil.el_image('COL')\|\|ind_col_rec.column_name); 989: end loop; 990: end if; Line 988: htp.p(uiutil.el_image('COL')\|\|ind_col_rec.column_name); 984: v_first2 := FALSE; 985: else 986: htp.p(' '); 987: end if; 988: htp.p(uiutil.el_image('COL')\|\|ind_col_rec.column_name); 989: end loop; 990: end if; 991: htp.p('

Name	Datatype	Length	Mandatory	Comments
Length
Name	Datatype	Length	Mandatory	Comments
Mandatory
Name	Datatype	Length	Mandatory	Comments
Comments
Name	Datatype	Length	Mandatory	Comments
'); Line 1055: htp.prn('
'); 1051: htp.p('	Comments
'); 1056: htp.prn(col_rec.column_name); 1057: htp.p('	'); 1059: htp.prn(col_rec.data_type); Line 1056: htp.prn(col_rec.column_name); 1052: v_first := FALSE; 1053: end if; 1054: 1055: htp.prn('
'); 1056: htp.prn(col_rec.column_name); 1057: htp.p('	'); 1059: htp.prn(col_rec.data_type); 1060: htp.p('
'); 1056: htp.prn(col_rec.column_name); 1057: htp.p('	'); 1059: htp.prn(col_rec.data_type); 1060: htp.p('	'); Line 1058: htp.prn('	'); 1054: 1055: htp.prn('
'); 1056: htp.prn(col_rec.column_name); 1057: htp.p('	'); 1059: htp.prn(col_rec.data_type); 1060: htp.p('	'); 1062: if col_rec.data_type = 'DATE' Line 1059: htp.prn(col_rec.data_type); 1055: htp.prn('
'); 1056: htp.prn(col_rec.column_name); 1057: htp.p('	'); 1059: htp.prn(col_rec.data_type); 1060: htp.p('	'); 1062: if col_rec.data_type = 'DATE' 1063: then htp.prn(' '); Line 1060: htp.p('	'); 1059: htp.prn(col_rec.data_type); 1060: htp.p('	'); 1062: if col_rec.data_type = 'DATE' 1063: then htp.prn(' '); 1064: elsif (col_rec.data_type = 'NUMBER' Line 1061: htp.prn('	'); 1057: htp.p('	'); 1059: htp.prn(col_rec.data_type); 1060: htp.p('	'); 1062: if col_rec.data_type = 'DATE' 1063: then htp.prn(' '); 1064: elsif (col_rec.data_type = 'NUMBER' 1065: AND col_rec.data_precision = ' ') Line 1063: then htp.prn(' '); 1059: htp.prn(col_rec.data_type); 1060: htp.p('	'); 1062: if col_rec.data_type = 'DATE' 1063: then htp.prn(' '); 1064: elsif (col_rec.data_type = 'NUMBER' 1065: AND col_rec.data_precision = ' ') 1066: then htp.prn(' '); 1067: elsif (col_rec.data_type = 'NUMBER' Line 1066: then htp.prn(' '); 1062: if col_rec.data_type = 'DATE' 1063: then htp.prn(' '); 1064: elsif (col_rec.data_type = 'NUMBER' 1065: AND col_rec.data_precision = ' ') 1066: then htp.prn(' '); 1067: elsif (col_rec.data_type = 'NUMBER' 1068: AND col_rec.data_precision != ' ') 1069: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 1070: elsif col_rec.data_length is null Line 1069: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 1065: AND col_rec.data_precision = ' ') 1066: then htp.prn(' '); 1067: elsif (col_rec.data_type = 'NUMBER' 1068: AND col_rec.data_precision != ' ') 1069: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 1070: elsif col_rec.data_length is null 1071: then htp.prn(' '); 1072: else 1073: htp.prn('('\|\|col_rec.data_length\|\|')'); Line 1071: then htp.prn(' '); 1067: elsif (col_rec.data_type = 'NUMBER' 1068: AND col_rec.data_precision != ' ') 1069: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 1070: elsif col_rec.data_length is null 1071: then htp.prn(' '); 1072: else 1073: htp.prn('('\|\|col_rec.data_length\|\|')'); 1074: end if; 1075: htp.p('	'); Line 1075: htp.p('	'); 1078: htp.prn(col_rec.nullable); 1079: htp.p('	'); 1073: htp.prn('('\|\|col_rec.data_length\|\|')'); 1074: end if; 1075: htp.p('	'); 1078: htp.prn(col_rec.nullable); 1079: htp.p('	'); 1081: v_first2 := TRUE; Line 1078: htp.prn(col_rec.nullable); 1074: end if; 1075: htp.p('	'); 1078: htp.prn(col_rec.nullable); 1079: htp.p('	'); 1081: v_first2 := TRUE; 1082: for t_rec in cur_col_comments(c_tname => c_name Line 1079: htp.p('	'); 1078: htp.prn(col_rec.nullable); 1079: htp.p('	'); 1081: v_first2 := TRUE; 1082: for t_rec in cur_col_comments(c_tname => c_name 1083: , c_cname => col_rec.column_name Line 1080: htp.prn('	'); 1076: 1077: htp.prn('	'); 1078: htp.prn(col_rec.nullable); 1079: htp.p('	'); 1081: v_first2 := TRUE; 1082: for t_rec in cur_col_comments(c_tname => c_name 1083: , c_cname => col_rec.column_name 1084: , c_owner => c_owner) loop Line 1087: htp.prn(' '); 1083: , c_cname => col_rec.column_name 1084: , c_owner => c_owner) loop 1085: v_first2 := FALSE; 1086: if t_rec.comments like '%- Retrofitted%' then 1087: htp.prn(' '); 1088: else 1089: htp.prn(t_rec.comments); 1090: end if; 1091: end loop; Line 1089: htp.prn(t_rec.comments); 1085: v_first2 := FALSE; 1086: if t_rec.comments like '%- Retrofitted%' then 1087: htp.prn(' '); 1088: else 1089: htp.prn(t_rec.comments); 1090: end if; 1091: end loop; 1092: if v_first2 then 1093: htp.prn(' '); Line 1093: htp.prn(' '); 1089: htp.prn(t_rec.comments); 1090: end if; 1091: end loop; 1092: if v_first2 then 1093: htp.prn(' '); 1094: end if; 1095: htp.p('

Line	Pos''n	Text
Text
Line	Pos''n	Text
'); Line 1876: htp.prn('
'); 1872: htp.p('	Text
'); 1877: htp.prn(e_rec.line); 1878: htp.p('	'); 1880: htp.prn(e_rec.position); Line 1877: htp.prn(e_rec.line); 1873: v_first := FALSE; 1874: end if; 1875: 1876: htp.prn('
'); 1877: htp.prn(e_rec.line); 1878: htp.p('	'); 1880: htp.prn(e_rec.position); 1881: htp.p('
'); 1877: htp.prn(e_rec.line); 1878: htp.p('	'); 1880: htp.prn(e_rec.position); 1881: htp.p('	'); Line 1879: htp.prn('	'); 1875: 1876: htp.prn('
'); 1877: htp.prn(e_rec.line); 1878: htp.p('	'); 1880: htp.prn(e_rec.position); 1881: htp.p('	'); 1883: htp.prn(e_rec.text); Line 1880: htp.prn(e_rec.position); 1876: htp.prn('
'); 1877: htp.prn(e_rec.line); 1878: htp.p('	'); 1880: htp.prn(e_rec.position); 1881: htp.p('	'); 1883: htp.prn(e_rec.text); 1884: htp.p('	'); 1880: htp.prn(e_rec.position); 1881: htp.p('	'); 1883: htp.prn(e_rec.text); 1884: htp.p('	'); 1878: htp.p('	'); 1880: htp.prn(e_rec.position); 1881: htp.p('	'); 1883: htp.prn(e_rec.text); 1884: htp.p('
'); 1880: htp.prn(e_rec.position); 1881: htp.p('	'); 1883: htp.prn(e_rec.text); 1884: htp.p('
'); 1883: htp.prn(e_rec.text); 1884: htp.p('
'); 1883: htp.prn(e_rec.text); 1884: htp.p('

APPS.ETRM_PNAV dependencies on HTP

Line 84: -- htp.p(' ');

Line 101: htp.p('

'||v_version||' DBA Data

'||v_version||' DBA Data

Line 116: htp.p('Browse the online data dictionary of an Applications database');

Line 119: -- htp.p('DBA Navigator Home');

Line 122: htp.p('');

Line 126: htp.p('

Line 130: htp.p('

Line 178: htp.p(' UNDEFINED');

Line 179: htp.p(' VIEW');

Line 180: htp.p(' XML SCHEMA');

Line 181: htp.p('');

Line 185: htp.p('

Line 189: htp.p('

Line 197: htp.p(' VALID');

Line 198: htp.p(' INVALID');

Line 199: htp.p('');

Line 200: htp.p('

Line 202: htp.p('');

Line 203: htp.p('');

Line 204: htp.p('');

Line 206: --htp.p('c_name='||c_name||' c_owner='||c_owner||' c_type='||c_type);

Line 318: -- htp.p('

Objects

Objects

Line 325: htp.p('');

Line 326: htp.p('');

Line 336: htp.p('');

Line 345: htp.p('

Line 347: htp.p('');

Line 361: htp.p('

Line 364: htp.p(''||v_counter ||' objects');

Line 365: htp.p('');

Line 406: htp.p('

'||c_type||'

'||c_type||'

Line 414: htp.p('');

Line 415: htp.p('');

Line 425: htp.p('');

Line 434: htp.p('

Line 436: htp.p('');

Line 445: htp.p('

Line 448: htp.p(''||v_counter ||' objects');

Line 449: htp.p('');

Line 513: htp.p('

Object Details

Object Details

Line 515: htp.p('

Object Details

Line 517: htp.prn('

Object Details

Line 518: htp.p('

Line 520: htp.prn('

Line 521: htp.p('

Line 523: htp.prn('

Line 524: htp.p('

Line 532: htp.prn('

Line 534: htp.p(' ');

Line 549: htp.prn('

Line 551: htp.p(' ');

Line 564: htp.p('

Line 567: htp.prn('

Line 568: htp.p('

Line 570: htp.prn('

Line 571: htp.p('

Line 573: htp.prn('

Line 574: htp.p('

Line 576: htp.prn('

Line 577: htp.p('

Line 579: htp.prn('

Line 580: htp.p('

Line 582: htp.prn('

Line 583: htp.p('

Line 585: htp.prn('

Line 588: htp.p('

Line 598: htp.p('

Line 600: htp.p('

Line 603: htp.prn('

Line 84: -- htp.p('
');

Line 116: htp.p('
Browse the online data dictionary of an Applications database
');

Line 119: -- htp.p('
DBA Navigator Home');

Line 178: htp.p('

Line 179: htp.p('

Line 180: htp.p('

Line 197: htp.p('

Line 198: htp.p('

Line 325: htp.p('
');

Line 326: htp.p('
');

Line 336: htp.p('
');

Line 347: htp.p('
');

Line 364: htp.p('
'||v_counter ||' objects
');

Line 414: htp.p('
');

Line 415: htp.p('
');

Line 425: htp.p('
');

Line 436: htp.p('
');

Line 448: htp.p('
'||v_counter ||' objects
');

Line 534: htp.p('
');

Line 551: htp.p('
');

Line 699: htp.p('
');

Line 752: htp.p('
');

Line 887: htp.p('
'||c_owner||'.'||c_name||' is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data

Line 911: htp.p('
');

Line 914: htp.p('
'

Line 924: htp.p('
');

Line 926: htp.p('
'