eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ETRM_RPT dependencies on HTP

Line 283: htp.p('

Comments

');

279: v_first := TRUE;
280: for c_rec in cur_comment(c_name, c_owner) loop
281: if v_first = TRUE then
282: v_first:= FALSE;
283: htp.p('

Comments

');
284: end if;
285: htp.p(c_rec.comments);
286: end loop;
287:

Line 285: htp.p(c_rec.comments);

281: if v_first = TRUE then
282: v_first:= FALSE;
283: htp.p('

Comments

');
284: end if;
285: htp.p(c_rec.comments);
286: end loop;
287:
288:
289:

Line 292: htp.p('

Primary Key: '|| key_rec.constraint_name || '

');

288:
289:
290:
291: for key_rec in cur_primary_key(c_name, c_owner) loop
292: htp.p('

Primary Key: '|| key_rec.constraint_name || '

');
293: htp.p('

'
Line 293: htp.p('
289:
290:
291: for key_rec in cur_primary_key(c_name, c_owner) loop
292: htp.p('
Primary Key: '|| key_rec.constraint_name || '
');
293: htp.p('
1. '
  297: ||key_col.column_name
  
  Line 296: htp.p('
  '
  
  292: htp.p('
  Primary Key: '|| key_rec.constraint_name || '
  ');
  293: htp.p('
  1. '
    297: ||key_col.column_name
    298: ||'
  ');
  
  Line 300: htp.p('
');

296: htp.p('
'
297: ||key_col.column_name
298: ||'

300: htp.p('

');
301: end loop;
302: --
303: for key_rec in cur_unique_keys(c_name, c_owner) loop
304: htp.p('

Unique Key: '|| key_rec.constraint_name || '

');

Line 304: htp.p('

Unique Key: '|| key_rec.constraint_name || '

');

300: htp.p('');
301: end loop;
302: --
303: for key_rec in cur_unique_keys(c_name, c_owner) loop
304: htp.p('

Unique Key: '|| key_rec.constraint_name || '

');
305: htp.p('

'
308: ||key_col.column_name
Line 305: htp.p('
301: end loop;
302: --
303: for key_rec in cur_unique_keys(c_name, c_owner) loop
304: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');
305: htp.p('
1. '
  308: ||key_col.column_name
  309: ||'
');

307: htp.p('
'
308: ||key_col.column_name
309: ||'

311: htp.p('

');
312: end loop;
313: --
314: v_first := TRUE;
315: for ind_rec in cur_index(c_name, c_owner) loop

Line 318: htp.p('

Indexes

');

314: v_first := TRUE;
315: for ind_rec in cur_index(c_name, c_owner) loop
316: if v_first = TRUE then
317: v_first := FALSE;
318: htp.p('

Indexes

');
319: htp.p(' 320: summary="Indexes in this table">
321:
322:

Line 319: htp.p('

Index

315: for ind_rec in cur_index(c_name, c_owner) loop
316: if v_first = TRUE then
317: v_first := FALSE;
318: htp.p('

Indexes

');
319: htp.p('

320: summary="Indexes in this table">
321:
322:
323:

Line 328: htp.p('

');

324:

325: ');
326: end if;
327:
328: htp.p('');
329: htp.p('');
332:

Line 329: htp.p('

');
326: end if;
327:
328: htp.p('');
329: htp.p('');
332:
333:

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

326: end if;
327:
328: htp.p('
');
329: htp.p('');
332:
333:
334: htp.p('');

327:
328: htp.p('
');
329: htp.p('');
332:
333:
334: htp.p('');
332:
333:
334: htp.p('');
337:
338:

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

331: htp.p('');
332:
333:
334: htp.p('
');
337:
338:
339: htp.p('');

332:
333:
334: htp.p('
');
337:
338:
339: htp.p('');
337:
338:
339: htp.p('');
342:
343:

Line 340: htp.p(ind_rec.tablespace_name);

336: htp.p('');
337:
338:
339: htp.p('
');
342:
343:
344:

Line 341: htp.p('');

337:
338:
339: htp.p('
');
342:
343:
344:
345: htp.p('');
342:
343:
344:
345: htp.p('');

Line 354: htp.p(ind_col_rec.column_name);

350: v_first2 := FALSE;
351: else
352: htp.p('
');
353: end if;
354: htp.p(ind_col_rec.column_name);
355: end loop;
356: htp.p('');
357: end loop;
358:

Line 356: htp.p('');

352: htp.p('
');
353: end if;
354: htp.p(ind_col_rec.column_name);
355: end loop;
356: htp.p('');
357: end loop;
358:
359: IF v_first Then
360: null;

Line 362: htp.p('

Index	Type
Tablespace	Column
'); 330: htp.p(ind_rec.index_name); 331: htp.p('	'); 325:	Column
'); 330: htp.p(ind_rec.index_name); 331: htp.p('
'); 330: htp.p(ind_rec.index_name); 331: htp.p('	'); Line 331: htp.p('
'); 330: htp.p(ind_rec.index_name); 331: htp.p('	'); 335: htp.p(ind_rec.uniqueness); Line 334: htp.p('	'); 330: htp.p(ind_rec.index_name); 331: htp.p('	'); 335: htp.p(ind_rec.uniqueness); 336: htp.p('	'); 335: htp.p(ind_rec.uniqueness); 336: htp.p('	'); Line 336: htp.p('	'); 335: htp.p(ind_rec.uniqueness); 336: htp.p('	'); 340: htp.p(ind_rec.tablespace_name); Line 339: htp.p('	'); 335: htp.p(ind_rec.uniqueness); 336: htp.p('	'); 340: htp.p(ind_rec.tablespace_name); 341: htp.p('	'); 340: htp.p(ind_rec.tablespace_name); 341: htp.p('	'); 340: htp.p(ind_rec.tablespace_name); 341: htp.p('	'); Line 345: htp.p('	'); 341: htp.p('	'); 346: 347: v_first2 := TRUE; 348: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop 349: IF v_first2 Then Line 352: htp.p(' '); 348: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop 349: IF v_first2 Then 350: v_first2 := FALSE; 351: else 352: htp.p(' '); 353: end if; 354: htp.p(ind_col_rec.column_name); 355: end loop; 356: htp.p('

');

358:
359: IF v_first Then
360: null;
361: else
362: htp.p('');
363: end if;
364:
365:
366: --

Line 485: htp.p('
Table: '||tab_rec.table_name ||'
');

481: --
482:
483: v_first := TRUE;
484: FOR tab_rec IN cur_table_dets(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
485: htp.p('
Table: '||tab_rec.table_name ||'
');
486: v_tablename := tab_rec.table_name;
487: htp.p(' 488: summary="location information">');
489:
Line 487: htp.p('

483: v_first := TRUE;
484: FOR tab_rec IN cur_table_dets(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
485: htp.p('
Table: '||tab_rec.table_name ||'
');
486: v_tablename := tab_rec.table_name;
487: htp.p('

488: summary="location information">');
489:
490: htp.p('');
Line 490: htp.p('
');
492:
493:
494:
495: htp.p('

Description: '
491: || tab_rec.description||'

Description: '

486: v_tablename := tab_rec.table_name;
487: htp.p(' 488: summary="location information">');
489:
490: htp.p('');
492:
493:
494:

Line 495: htp.p('

Description: '
491: || tab_rec.description||'
');

491: || tab_rec.description||'

');
496:
497: end loop;
498: --
499:

Line 502: htp.p('
Primary Key: '|| key_rec.primary_key_name || '
');

498: --
499:
500:
501: for key_rec in cur_primary_key(n_appid => n_appid, n_tabid => n_tabid) loop
502: htp.p('
Primary Key: '|| key_rec.primary_key_name || '
');
503: htp.p('
');
504: for key_col in cur_pk_columns(n_appid => n_appid
505: , n_tabid => n_tabid
506: , n_keyid => key_rec.primary_key_id) loop

Line 503: htp.p('
');

499:
500:
501: for key_rec in cur_primary_key(n_appid => n_appid, n_tabid => n_tabid) loop
502: htp.p('
Primary Key: '|| key_rec.primary_key_name || '
');
503: htp.p('
');
504: for key_col in cur_pk_columns(n_appid => n_appid
505: , n_tabid => n_tabid
506: , n_keyid => key_rec.primary_key_id) loop
507: htp.p('
'

Line 507: htp.p('
'

503: htp.p('
');
504: for key_col in cur_pk_columns(n_appid => n_appid
505: , n_tabid => n_tabid
506: , n_keyid => key_rec.primary_key_id) loop
507: htp.p('
'
508: ||key_col.column_name
509: ||'
');
510: end loop;
511: htp.p('
');

Line 511: htp.p('
');

507: htp.p('
'
508: ||key_col.column_name
509: ||'
');
510: end loop;
511: htp.p('
');
512: end loop;
513:
514: v_first := TRUE;
515:

Line 521: htp.p('
Foreign Keys from this table:
');

517: for key_rec in cur_foreign_key(n_appid => n_appid
518: , n_tabid => n_tabid) loop
519: if v_first = TRUE then
520: v_first := FALSE;
521: htp.p('
Foreign Keys from this table:
');
522: htp.p(' 523: summary="Foreign keys from/to this table">
524:
525:
Line 522: htp.p('
Foreign Key Column
518: , n_tabid => n_tabid) loop
519: if v_first = TRUE then
520: v_first := FALSE;
521: htp.p('
Foreign Keys from this table:
');
522: htp.p('

523: summary="Foreign keys from/to this table">
524:
525:
526: ');
Line 532: htp.p('
');
528: end if;
529:
530:
531:
532: htp.p('
');
533: v_first2 := TRUE;
534: htp.p('');
533: v_first2 := TRUE;
534: htp.p('');

544: ||'.'
545: ||key_col.column_name
546: ||'');
547: end loop;
548: htp.p('');
549:
550: htp.p('
');
549:
550: htp.p('');
554:

Line 551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id

547: end loop;
548: htp.p('');
549:
550: htp.p('
');
554:
555: end loop;

Line 553: htp.p('');

549:
550: htp.p('
');
554:
555: end loop;
556: --
557: if v_first

Line 560: htp.p('

Foreign Key Column Foreign Table

');
535: for key_col in cur_fk_columns(n_appid => n_appid
536: , n_tabid => n_tabid

Line 534: htp.p('
');

530:
531:
532: htp.p('
');
535: for key_col in cur_fk_columns(n_appid => n_appid
536: , n_tabid => n_tabid
537: , n_keyid => key_rec.foreign_key_id) loop
538: if v_first2 = TRUE

Line 541: htp.p('
');

537: , n_keyid => key_rec.foreign_key_id) loop
538: if v_first2 = TRUE
539: then v_first2 := FALSE;
540: else
541: htp.p('
');
542: end if;
543: htp.p(get_tablename(n_appid, n_tabid)
544: ||'.'
545: ||key_col.column_name

Line 543: htp.p(get_tablename(n_appid, n_tabid)

539: then v_first2 := FALSE;
540: else
541: htp.p('
');
542: end if;
543: htp.p(get_tablename(n_appid, n_tabid)
544: ||'.'
545: ||key_col.column_name
546: ||'');
547: end loop;

Line 548: htp.p('
');
551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id
552: , n_tabid => key_rec.primary_key_table_id));

Line 550: htp.p('
');

546: ||'');
547: end loop;
548: htp.p('
');
551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id
552: , n_tabid => key_rec.primary_key_table_id));
553: htp.p('
');
551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id
552: , n_tabid => key_rec.primary_key_table_id));
553: htp.p('
');
551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id
552: , n_tabid => key_rec.primary_key_table_id));
553: htp.p('
');

556: --
557: if v_first
558: then null;
559: else
560: htp.p('');
561: end if;
562:
563: v_first := TRUE;
564: for key_rec in cur_fk_refs(n_appid => n_appid

Line 568: htp.p('
Foreign Keys to this table:
');

564: for key_rec in cur_fk_refs(n_appid => n_appid
565: , n_tabid => n_tabid) loop
566: if v_first = TRUE then
567: v_first := FALSE;
568: htp.p('
Foreign Keys to this table:
');
569: htp.p(' 570: summary="Foreign keys from/to this table">
571:
572:
Line 569: htp.p('
Foreign Key Column
565: , n_tabid => n_tabid) loop
566: if v_first = TRUE then
567: v_first := FALSE;
568: htp.p('
Foreign Keys to this table:
');
569: htp.p('

570: summary="Foreign keys from/to this table">
571:
572:
573: ');
Line 577: htp.p('
');
573:
');
574:
575: end if;
576:
577: htp.p('');
578: v_first2 := TRUE;
579: htp.p('');
578: v_first2 := TRUE;
579: htp.p('');

590: ||'.'
591: ||key_col.column_name
592: ||'');
593: end loop;
594: htp.p('');
595: htp.p('
');
597:
598: end loop;

Line 595: htp.p('
');
595: htp.p('');
597:
598: end loop;
599:

Line 596: htp.p(v_tablename||'');

592: ||'');
593: end loop;
594: htp.p('');
595: htp.p('
');
597:
598: end loop;
599:
600: if v_first
Line 603: htp.p('

Foreign Key Column Foreign Table

Foreign Table

');
580: for key_col in cur_fk_columns(n_appid => key_rec.application_id
581: , n_tabid => key_rec.table_id

Line 579: htp.p('
');

575: end if;
576:
577: htp.p('
');
580: for key_col in cur_fk_columns(n_appid => key_rec.application_id
581: , n_tabid => key_rec.table_id
582: , n_keyid => key_rec.foreign_key_id) loop
583: if v_first2 = TRUE

Line 586: htp.p('
');

582: , n_keyid => key_rec.foreign_key_id) loop
583: if v_first2 = TRUE
584: then v_first2 := FALSE;
585: else
586: htp.p('
');
587: end if;
588:
589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)
590: ||'.'

Line 589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)

585: else
586: htp.p('
');
587: end if;
588:
589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)
590: ||'.'
591: ||key_col.column_name
592: ||'');
593: end loop;

Line 594: htp.p('
');
596: htp.p(v_tablename||'
');

591: ||key_col.column_name
592: ||'');
593: end loop;
594: htp.p('
');
596: htp.p(v_tablename||'
');
596: htp.p(v_tablename||'

');

599:
600: if v_first
601: then null;
602: else
603: htp.p('');
604: end if;
605:
606: --
607:

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

647:
648: for col_rec in cur_columns(c_name, c_owner) loop
649: IF v_first Then
650:
651: htp.p('
Columns
');
652: htp.p(' 653: summary="Column details for this table">');
654: htp.p('');
655: htp.p('');
Line 652: htp.p('
Name
648: for col_rec in cur_columns(c_name, c_owner) loop
649: IF v_first Then
650:
651: htp.p('
Columns
');
652: htp.p('

653: summary="Column details for this table">');
654: htp.p('');
655: htp.p('');
656: htp.p('');
Line 654: htp.p('
');
650:
651: htp.p('
Columns
');
652: htp.p('

Name Datatype

653: summary="Column details for this table">');
654: htp.p('');
655: htp.p('');
656: htp.p('');
657: htp.p('');
658: -- htp.p('');
Line 655: htp.p('
');
651: htp.p('
Columns
');
652: htp.p('

Name Datatype Length Prcn Name
653: summary="Column details for this table">');
654: htp.p('');
655: htp.p('');
656: htp.p('');
657: htp.p('');
658: -- htp.p('');
659: htp.p('');
Line 656: htp.p('
');
652: htp.p('
Name Datatype Length Prcn Mandatory Datatype
653: summary="Column details for this table">');
654: htp.p('');
655: htp.p('');
656: htp.p('');
657: htp.p('');
658: -- htp.p('');
659: htp.p('');
660: htp.p('');
Line 657: htp.p('
');
653: summary="Column details for this table">');
654: htp.p('
');
655: htp.p('');
656: htp.p('');
657: htp.p('');
658: -- htp.p('');
659: htp.p('');
660: htp.p('');
661: v_first := FALSE;
Line 658: -- htp.p('
');
654: htp.p('
');
655: htp.p('');
656: htp.p('');
657: htp.p('');
658: -- htp.p('');
659: htp.p('');
660: htp.p('');
661: v_first := FALSE;
662: end if;
Line 659: htp.p('
');
655: htp.p('
');
656: htp.p('');
657: htp.p('');
658: -- htp.p('');
659: htp.p('');
660: htp.p('');
661: v_first := FALSE;
662: end if;
663:
Line 660: htp.p('
');
656: htp.p('
');
657: htp.p('');
658: -- htp.p('');
659: htp.p('');
660: htp.p('');
661: v_first := FALSE;
662: end if;
663:
664: htp.prn('');
661: v_first := FALSE;
662: end if;
663:
664: htp.prn('');
667: htp.prn('');
667: htp.prn('');

Line 666: htp.p('');

662: end if;
663:
664: htp.prn('
');
667: htp.prn('');
670: htp.prn('');
667: htp.prn('');
670: htp.prn('');
667: htp.prn('');
670: htp.prn('');

665: htp.prn(col_rec.column_name);
666: htp.p('');
667: htp.prn('
');
670: htp.prn('');
667: htp.prn('');
670: htp.prn('');
670: htp.prn('');

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

678: then htp.prn('('||col_rec.data_precision||')');
679: elsif col_rec.data_length is null
680: then htp.prn('
');
681: else
682: htp.prn('('||col_rec.data_length||')');
683: end if;
684: htp.p('');
685: -- htp.prn('
');

680: then htp.prn('
');
681: else
682: htp.prn('('||col_rec.data_length||')');
683: end if;
684: htp.p('');
685: -- htp.prn('
');
688: htp.prn('');
685: -- htp.prn('');
688: htp.prn('');
685: -- htp.prn('');
688: htp.prn('');

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

683: end if;
684: htp.p('');
685: -- htp.prn('
');
688: htp.prn('');
691: htp.prn('');
685: -- htp.prn('');
688: htp.prn('');
691: htp.prn('');
688: htp.prn('');
691: htp.prn('');

686: -- htp.prn(col_rec.data_precision);
687: -- htp.p('');
688: htp.prn('
');
691: htp.prn('');
688: htp.prn('');
691: htp.prn('');
707:
708: end loop;

Line 706: htp.p('');

702: end loop;
703: if v_first2 then
704: htp.prn('
');
705: end if;
706: htp.p('');
707:
708: end loop;
709: IF v_first Then
710: htp.p(FND_CSS_PKG.Encode(c_name) || ' has no columns
');

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

706: htp.p('');
707:
708: end loop;
709: IF v_first Then
710: htp.p(FND_CSS_PKG.Encode(c_name) || ' has no columns
');
711: else
712: htp.p('
Name Datatype Length Prcn Mandatory Comments

Length
Name Datatype Length Prcn Mandatory Comments

Prcn
Name Datatype Length Prcn Mandatory Comments

Mandatory Name Datatype Length Prcn Mandatory Comments

Comments

Datatype Length Prcn Mandatory Comments
');

Line 664: htp.prn('
');

660: htp.p('
Comments

');
665: htp.prn(col_rec.column_name);
666: htp.p(' ');
668: htp.prn(col_rec.data_type);

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

661: v_first := FALSE;
662: end if;
663:
664: htp.prn('
');
665: htp.prn(col_rec.column_name);
666: htp.p(' ');
668: htp.prn(col_rec.data_type);
669: htp.p('
');
665: htp.prn(col_rec.column_name);
666: htp.p(' ');
668: htp.prn(col_rec.data_type);
669: htp.p(' ');

Line 667: htp.prn('
');

663:
664: htp.prn('
');
665: htp.prn(col_rec.column_name);
666: htp.p(' ');
668: htp.prn(col_rec.data_type);
669: htp.p(' ');
671: if col_rec.data_type = 'DATE'

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

664: htp.prn('
');
665: htp.prn(col_rec.column_name);
666: htp.p(' ');
668: htp.prn(col_rec.data_type);
669: htp.p(' ');
671: if col_rec.data_type = 'DATE'
672: then htp.prn('
');

Line 669: htp.p('
');
668: htp.prn(col_rec.data_type);
669: htp.p(' ');
671: if col_rec.data_type = 'DATE'
672: then htp.prn('
');
673: elsif (col_rec.data_type = 'NUMBER'

Line 670: htp.prn('
');

666: htp.p('
');
668: htp.prn(col_rec.data_type);
669: htp.p(' ');
671: if col_rec.data_type = 'DATE'
672: then htp.prn('
');
673: elsif (col_rec.data_type = 'NUMBER'
674: AND col_rec.data_precision = '
')

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

668: htp.prn(col_rec.data_type);
669: htp.p('
');
671: if col_rec.data_type = 'DATE'
672: then htp.prn('
');
673: elsif (col_rec.data_type = 'NUMBER'
674: AND col_rec.data_precision = '
')
675: then htp.prn('
');
676: elsif (col_rec.data_type = 'NUMBER'

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

671: if col_rec.data_type = 'DATE'
672: then htp.prn('
');
673: elsif (col_rec.data_type = 'NUMBER'
674: AND col_rec.data_precision = '
')
675: then htp.prn('
');
676: elsif (col_rec.data_type = 'NUMBER'
677: AND col_rec.data_precision != '
')
678: then htp.prn('('||col_rec.data_precision||')');
679: elsif col_rec.data_length is null

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

674: AND col_rec.data_precision = '
')
675: then htp.prn('
');
676: elsif (col_rec.data_type = 'NUMBER'
677: AND col_rec.data_precision != '
')
678: then htp.prn('('||col_rec.data_precision||')');
679: elsif col_rec.data_length is null
680: then htp.prn('
');
681: else
682: htp.prn('('||col_rec.data_length||')');

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

676: elsif (col_rec.data_type = 'NUMBER'
677: AND col_rec.data_precision != '
')
678: then htp.prn('('||col_rec.data_precision||')');
679: elsif col_rec.data_length is null
680: then htp.prn('
');
681: else
682: htp.prn('('||col_rec.data_length||')');
683: end if;
684: htp.p('
');
686: -- htp.prn(col_rec.data_precision);

Line 684: htp.p('
');
686: -- htp.prn(col_rec.data_precision);
687: -- htp.p(' ');

Line 685: -- htp.prn('
');

681: else
682: htp.prn('('||col_rec.data_length||')');
683: end if;
684: htp.p('
');
686: -- htp.prn(col_rec.data_precision);
687: -- htp.p(' ');
689: htp.prn(col_rec.nullable);

Line 686: -- htp.prn(col_rec.data_precision);

682: htp.prn('('||col_rec.data_length||')');
683: end if;
684: htp.p('
');
686: -- htp.prn(col_rec.data_precision);
687: -- htp.p(' ');
689: htp.prn(col_rec.nullable);
690: htp.p(' ');
686: -- htp.prn(col_rec.data_precision);
687: -- htp.p(' ');
689: htp.prn(col_rec.nullable);
690: htp.p(' ');

Line 688: htp.prn('
');

684: htp.p('
');
686: -- htp.prn(col_rec.data_precision);
687: -- htp.p(' ');
689: htp.prn(col_rec.nullable);
690: htp.p(' ');
692: v_first2 := TRUE;

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

685: -- htp.prn('
');
686: -- htp.prn(col_rec.data_precision);
687: -- htp.p(' ');
689: htp.prn(col_rec.nullable);
690: htp.p(' ');
692: v_first2 := TRUE;
693: for t_rec in cur_col_comments(c_tname => c_name

Line 690: htp.p('
');
689: htp.prn(col_rec.nullable);
690: htp.p(' ');
692: v_first2 := TRUE;
693: for t_rec in cur_col_comments(c_tname => c_name
694: , c_cname => col_rec.column_name

Line 691: htp.prn('
');

687: -- htp.p('
');
689: htp.prn(col_rec.nullable);
690: htp.p(' ');
692: v_first2 := TRUE;
693: for t_rec in cur_col_comments(c_tname => c_name
694: , c_cname => col_rec.column_name
695: , c_owner => c_owner) loop

Line 698: htp.prn('
');

694: , c_cname => col_rec.column_name
695: , c_owner => c_owner) loop
696: v_first2 := FALSE;
697: if t_rec.comments like '%- Retrofitted%' then
698: htp.prn('
');
699: else
700: htp.prn(t_rec.comments);
701: end if;
702: end loop;

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

696: v_first2 := FALSE;
697: if t_rec.comments like '%- Retrofitted%' then
698: htp.prn('
');
699: else
700: htp.prn(t_rec.comments);
701: end if;
702: end loop;
703: if v_first2 then
704: htp.prn('
');

Line 704: htp.prn('
');

700: htp.prn(t_rec.comments);
701: end if;
702: end loop;
703: if v_first2 then
704: htp.prn('
');
705: end if;
706: htp.p('
');
713:
714: end if;

Line 712: htp.p('');

708: end loop;
709: IF v_first Then
710: htp.p(FND_CSS_PKG.Encode(c_name) || ' has no columns
');
711: else
712: htp.p('');
713:
714: end if;
715:
716: end ls_columns;

Line 743: htp.p('

739:
740: begin
741: v_first := TRUE;
742: v_owner := 'foRce_mE_to_diff';
743: htp.p('
744:
[top of page]
');
745:
746: for a_rec in cur_depend2(n_object_id) loop
747: IF v_first Then

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

744:
[top of page]
');
745:
746: for a_rec in cur_depend2(n_object_id) loop
747: IF v_first Then
748: htp.p(''||etrm_pnav.get_object_name(n_object_id)
749: || ' references the following:
');
750: htp.p('
');
751: v_first := FALSE;
752: end if;

Line 750: htp.p('
');

746: for a_rec in cur_depend2(n_object_id) loop
747: IF v_first Then
748: htp.p(''||etrm_pnav.get_object_name(n_object_id)
749: || ' references the following:
');
750: htp.p('
');
751: v_first := FALSE;
752: end if;
753:
754: if a_rec.owner = v_owner then

Line 758: htp.p('
');

754: if a_rec.owner = v_owner then
755: null;
756: else
757: v_owner := a_rec.owner;
758: htp.p('
');
759: if a_rec.owner is not null then
760: htp.p(''||a_rec.owner||'');
761: end if;
762: htp.p('
');

Line 760: htp.p(''||a_rec.owner||'');

756: else
757: v_owner := a_rec.owner;
758: htp.p('
');
759: if a_rec.owner is not null then
760: htp.p(''||a_rec.owner||'');
761: end if;
762: htp.p('
');
763: end if;
764:

Line 762: htp.p('');

758: htp.p('
');
759: if a_rec.owner is not null then
760: htp.p(''||a_rec.owner||'');
761: end if;
762: htp.p('
');
763: end if;
764:
765:
766: htp.p('
');

Line 766: htp.p('
');

762: htp.p('');
763: end if;
764:
765:
766: htp.p('
');
767: htp.p(get_object_name(a_rec.object_id, 'TYPE')
768: || ' - ' ||get_object_name(a_rec.object_id, 'ITEM')||'');
769:
770:

Line 767: htp.p(get_object_name(a_rec.object_id, 'TYPE')

763: end if;
764:
765:
766: htp.p('
');
767: htp.p(get_object_name(a_rec.object_id, 'TYPE')
768: || ' - ' ||get_object_name(a_rec.object_id, 'ITEM')||'');
769:
770:
771: htp.p('
');

Line 771: htp.p('');

767: htp.p(get_object_name(a_rec.object_id, 'TYPE')
768: || ' - ' ||get_object_name(a_rec.object_id, 'ITEM')||'');
769:
770:
771: htp.p('');
772: end loop;
773:
774:
775: IF v_first Then

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

772: end loop;
773:
774:
775: IF v_first Then
776: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
777: else
778: htp.p('
');
779: v_first := TRUE;
780: end if;

Line 778: htp.p('
');

774:
775: IF v_first Then
776: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
777: else
778: htp.p('');
779: v_first := TRUE;
780: end if;
781:
782:

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

784: v_owner := 'foRce_mE_to_diff';
785:
786: for a_rec in cur_depend(n_object_id) loop
787: IF v_first Then
788: htp.p(''||etrm_pnav.get_object_name(n_object_id)
789: || ' is referenced by following:
');
790: htp.p('
');
791: v_first := FALSE;
792: end if;

Line 790: htp.p('
');

786: for a_rec in cur_depend(n_object_id) loop
787: IF v_first Then
788: htp.p(''||etrm_pnav.get_object_name(n_object_id)
789: || ' is referenced by following:
');
790: htp.p('
');
791: v_first := FALSE;
792: end if;
793:
794: if a_rec.owner = v_owner then

Line 798: htp.p('
');

794: if a_rec.owner = v_owner then
795: null;
796: else
797: v_owner := a_rec.owner;
798: htp.p('
');
799: if a_rec.owner is not null then
800: htp.p(''||a_rec.owner||'');
801: end if;
802: htp.p('
');

Line 800: htp.p(''||a_rec.owner||'');

796: else
797: v_owner := a_rec.owner;
798: htp.p('
');
799: if a_rec.owner is not null then
800: htp.p(''||a_rec.owner||'');
801: end if;
802: htp.p('
');
803: end if;
804:

Line 802: htp.p('');

798: htp.p('
');
799: if a_rec.owner is not null then
800: htp.p(''||a_rec.owner||'');
801: end if;
802: htp.p('
');
803: end if;
804:
805: htp.p('
');
806: htp.p(get_object_name(a_rec.object_id, 'TYPE') || ' - '

Line 805: htp.p('
');

801: end if;
802: htp.p('');
803: end if;
804:
805: htp.p('
');
806: htp.p(get_object_name(a_rec.object_id, 'TYPE') || ' - '
807: ||get_object_name(a_rec.object_id, 'ITEM')||'');
808:
809:

Line 806: htp.p(get_object_name(a_rec.object_id, 'TYPE') || ' - '

802: htp.p('');
803: end if;
804:
805: htp.p('
');
806: htp.p(get_object_name(a_rec.object_id, 'TYPE') || ' - '
807: ||get_object_name(a_rec.object_id, 'ITEM')||'');
808:
809:
810: htp.p('
');

Line 810: htp.p('');

806: htp.p(get_object_name(a_rec.object_id, 'TYPE') || ' - '
807: ||get_object_name(a_rec.object_id, 'ITEM')||'');
808:
809:
810: htp.p('');
811: end loop;
812:
813:
814: IF v_first Then

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

811: end loop;
812:
813:
814: IF v_first Then
815: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
816: else
817: htp.p('
');
818: v_first := TRUE;
819: end if;

Line 817: htp.p('
');

813:
814: IF v_first Then
815: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
816: else
817: htp.p('');
818: v_first := TRUE;
819: end if;
820:
821: end ls_dependencies;

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

844: v_viewtext varchar2(32000);
845: begin
846: if c_type = 'VIEW' then
847: for t_rec in cur_vw_source(c_name, c_owner) loop
848: htp.p('
View Text - Preformatted
');
849: htp.p('
'); 850: htp.p(t_rec.text); 851: htp.p('
');
852:

Line 849: htp.p('
');
845: begin 846: if c_type = 'VIEW' then 847: for t_rec in cur_vw_source(c_name, c_owner) loop 848: htp.p('
View Text - Preformatted
'); 849: htp.p(''); 850: htp.p(t_rec.text); 851: htp.p(' '); 852: 853: v_viewtext := upper(t_rec.text); Line 850: htp.p(t_rec.text); 846: if c_type = 'VIEW' then 847: for t_rec in cur_vw_source(c_name, c_owner) loop 848: htp.p(' View Text - Preformatted '); 849: htp.p(''); 850: htp.p(t_rec.text); 851: htp.p(' '); 852: 853: v_viewtext := upper(t_rec.text); 854: v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
Line 851: htp.p('');

847: for t_rec in cur_vw_source(c_name, c_owner) loop
848: htp.p('
View Text - Preformatted
');
849: htp.p('
'); 850: htp.p(t_rec.text); 851: htp.p('
');
852:
853: v_viewtext := upper(t_rec.text);
854: v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
855: v_viewtext := replace(v_viewtext , 'UNION ', 'UNION ');

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

857: v_viewtext := replace(v_viewtext , ' WHERE ', '
WHERE ');
858: v_viewtext := replace(v_viewtext , ',', '
, ');
859: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
860:
861: htp.p('
View Text - HTML Formatted
');
862: htp.p('
');
863: htp.p(v_viewtext);
864: htp.p('
');
865:

Line 862: htp.p('
');

858: v_viewtext := replace(v_viewtext , ',', '
, ');
859: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
860:
861: htp.p('
View Text - HTML Formatted
');
862: htp.p('
');
863: htp.p(v_viewtext);
864: htp.p('
');
865:
866: end loop;

Line 863: htp.p(v_viewtext);

859: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
860:
861: htp.p('
View Text - HTML Formatted
');
862: htp.p('
');
863: htp.p(v_viewtext);
864: htp.p('
');
865:
866: end loop;
867:

Line 864: htp.p('
');

860:
861: htp.p('
View Text - HTML Formatted
');
862: htp.p('
');
863: htp.p(v_viewtext);
864: htp.p('
');
865:
866: end loop;
867:
868: else

Line 869: htp.p('
');
865: 866: end loop; 867: 868: else 869: htp.p('
'); 870: for t_rec in cur_source(c_name, c_type, c_owner) loop 871: uiutil.txt_p(t_rec.text); 872: end loop; 873: htp.p('
');
Line 873: htp.p('');

869: htp.p('
'); 870: for t_rec in cur_source(c_name, c_type, c_owner) loop 871: uiutil.txt_p(t_rec.text); 872: end loop; 873: htp.p('
');
874: end if;
875:
876: end ls_source;
877:

Line 945: htp.p(etrm_static.legal_text);

941: begin
942:
943: uiutil.file_header(c_filename => c_owner||'.html');
944: uiutil.cabo1;
945: htp.p(etrm_static.legal_text);
946: htp.p('');
947: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_owner) || ' Tables and Views
');
948:
949: htp.p('
');

Line 946: htp.p('');

942:
943: uiutil.file_header(c_filename => c_owner||'.html');
944: uiutil.cabo1;
945: htp.p(etrm_static.legal_text);
946: htp.p('');
947: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_owner) || ' Tables and Views
');
948:
949: htp.p('
');
950: for i_rec in cur_items(c_owner) loop

Line 947: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_owner) || ' Tables and Views
');

943: uiutil.file_header(c_filename => c_owner||'.html');
944: uiutil.cabo1;
945: htp.p(etrm_static.legal_text);
946: htp.p('');
947: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_owner) || ' Tables and Views
');
948:
949: htp.p('
');
950: for i_rec in cur_items(c_owner) loop
951:

Line 949: htp.p('
');

945: htp.p(etrm_static.legal_text);
946: htp.p('');
947: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_owner) || ' Tables and Views
');
948:
949: htp.p('
');
950: for i_rec in cur_items(c_owner) loop
951:
952: htp.p('
');
953:

Line 952: htp.p('
');

948:
949: htp.p('
');
950: for i_rec in cur_items(c_owner) loop
951:
952: htp.p('
');
953:
954: htp.p(i_rec.object_type||' - '
955: ||''
956: ||i_rec.owner||'.'||i_rec.object_name||'');

Line 954: htp.p(i_rec.object_type||' - '

950: for i_rec in cur_items(c_owner) loop
951:
952: htp.p('
');
953:
954: htp.p(i_rec.object_type||' - '
955: ||''
956: ||i_rec.owner||'.'||i_rec.object_name||'');
957:
958:

Line 960: htp.p('
');

956: ||i_rec.owner||'.'||i_rec.object_name||'');
957:
958:
959:
960: htp.p('
');
961: end loop;
962: htp.p('
');
963:
964: for i_rec in cur_items(c_owner) loop

Line 962: htp.p('
');

958:
959:
960: htp.p('');
961: end loop;
962: htp.p('
');
963:
964: for i_rec in cur_items(c_owner) loop
965: htp.p('');
966:

Line 965: htp.p('');

961: end loop;
962: htp.p('
');
963:
964: for i_rec in cur_items(c_owner) loop
965: htp.p('');
966:
967: if i_rec.object_type = 'TABLE' then
968: ls_fnd_table(n_appid => i_rec.application_id, n_tabid => i_rec.table_id);
969: elsif i_rec.object_type = 'VIEW' then

Line 970: htp.p('
View: '||i_rec.object_name||'
');

966:
967: if i_rec.object_type = 'TABLE' then
968: ls_fnd_table(n_appid => i_rec.application_id, n_tabid => i_rec.table_id);
969: elsif i_rec.object_type = 'VIEW' then
970: htp.p('
View: '||i_rec.object_name||'
');
971: end if;
972: v_owner := i_rec.owner;
973: cr_file(c_name => i_rec.object_name
974: , c_owner => v_owner

Line 977: htp.p('
[top of page]
');

973: cr_file(c_name => i_rec.object_name
974: , c_owner => v_owner
975: , c_type => i_rec.object_type
976: , c_rpt_type => c_rpt_type);
977: htp.p('
[top of page]
');
978: end loop;
979: uiutil.prn_copyright;
980: end cr_file;
981:

Line 1096: htp.p(etrm_static.legal_text);

1092: begin
1093:
1094: uiutil.file_header(c_filename => c_product||'.html');
1095: uiutil.cabo1;
1096: htp.p(etrm_static.legal_text);
1097: htp.p('');
1098: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_product) || ' External Dependencies
');
1099: htp.p(etrm_static.product_dependency_text);
1100:

Line 1097: htp.p('');

1093:
1094: uiutil.file_header(c_filename => c_product||'.html');
1095: uiutil.cabo1;
1096: htp.p(etrm_static.legal_text);
1097: htp.p('');
1098: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_product) || ' External Dependencies
');
1099: htp.p(etrm_static.product_dependency_text);
1100:
1101: v_item_appid := get_appid(c_product);

Line 1098: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_product) || ' External Dependencies
');

1094: uiutil.file_header(c_filename => c_product||'.html');
1095: uiutil.cabo1;
1096: htp.p(etrm_static.legal_text);
1097: htp.p('');
1098: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_product) || ' External Dependencies
');
1099: htp.p(etrm_static.product_dependency_text);
1100:
1101: v_item_appid := get_appid(c_product);
1102: for a_rec in cur_appid loop

Line 1099: htp.p(etrm_static.product_dependency_text);

1095: uiutil.cabo1;
1096: htp.p(etrm_static.legal_text);
1097: htp.p('');
1098: htp.p('
eTRM - '||FND_CSS_PKG.Encode(c_product) || ' External Dependencies
');
1099: htp.p(etrm_static.product_dependency_text);
1100:
1101: v_item_appid := get_appid(c_product);
1102: for a_rec in cur_appid loop
1103: dep_table(a_rec.application_id).uses := FALSE;

Line 1161: htp.p('
1157: v_first := TRUE;
1158: for ap_rec in cur_appname loop
1159: if v_first then
1160: v_first := FALSE;
1161: htp.p('

1162: summary="Product Dependencies">
1163:
1164:
1165: ');
Line 1174: then htp.p('
');
Line 1178: htp.p('');

1174: then htp.p('
');
1179:
1180: v_product := '
'; -- print product name once only.
1181: elsif (dep_table(ap_rec.application_id).uses = FALSE
1182: AND dep_table(ap_rec.application_id).used_by = TRUE)
Line 1183: then htp.p('
');
Line 1187: htp.p('');

1183: then htp.p('
');
1188: v_product := '
'; -- print product name once only.
1189: else
1190: htp.p('');
1188: v_product := '
'; -- print product name once only.
1189: else
1190: htp.p('');

Line 1194: htp.p('');

1190: htp.p('
');
1195: v_product := '
'; -- print product name once only.
1196: end if;
1197:
1198: end loop;
Line 1201: htp.p('
No external dependencies were found for this product.
');

1197:
1198: end loop;
1199:
1200: if v_first then
1201: htp.p('
No external dependencies were found for this product.
');
1202: else
1203: htp.p('

Product Dependency Product

'

1170: AND (dep_table(ap_rec.application_id).used_by = FALSE))
1171: then null;
1172: elsif (dep_table(ap_rec.application_id).uses = TRUE
1173: AND dep_table(ap_rec.application_id).used_by = FALSE)
1174: then htp.p('
'
1175: ||v_product||' uses '
1176: ||''
1177: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1178: htp.p('

'
1175: ||v_product||' uses '
1176: ||''
1177: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1178: htp.p('

'

1179:
1180: v_product := '
'; -- print product name once only.
1181: elsif (dep_table(ap_rec.application_id).uses = FALSE
1182: AND dep_table(ap_rec.application_id).used_by = TRUE)
1183: then htp.p('
'
1184: ||v_product||' used by '
1185: ||''
1186: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1187: htp.p('

'
1184: ||v_product||' used by '
1185: ||''
1186: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1187: htp.p('

'
1191: ||v_product||' used by/uses '

Line 1190: htp.p('
'

1186: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1187: htp.p('

'
1191: ||v_product||' used by/uses '
1192: ||''
1193: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1194: htp.p('
'
1191: ||v_product||' used by/uses '
1192: ||''
1193: ||ap_rec.application_short_name||' - '||ap_rec.application_name||'');
1194: htp.p('

');
1204:
1205: for ap_rec in cur_appname loop

Line 1203: htp.p('');

1199:
1200: if v_first then
1201: htp.p('
No external dependencies were found for this product.
');
1202: else
1203: htp.p('');
1204:
1205: for ap_rec in cur_appname loop
1206:
1207: if dep_table(ap_rec.application_id).rowcount = 0

Line 1210: htp.p('');

1206:
1207: if dep_table(ap_rec.application_id).rowcount = 0
1208: then null;
1209: else
1210: htp.p('');
1211: htp.p('
'||ap_rec.application_short_name||' - '
1212: ||ap_rec.application_name||'
');
1213:
1214: htp.p('
Line 1211: htp.p('
'||ap_rec.application_short_name||' - '

1207: if dep_table(ap_rec.application_id).rowcount = 0
1208: then null;
1209: else
1210: htp.p('');
1211: htp.p('
'||ap_rec.application_short_name||' - '
1212: ||ap_rec.application_name||'
');
1213:
1214: htp.p('

1215: summary="'|| ap_rec.application_short_name||' Product Dependencies">
Line 1214: htp.p('

1210: htp.p('');
1211: htp.p('
'||ap_rec.application_short_name||' - '
1212: ||ap_rec.application_name||'
');
1213:
1214: htp.p('

1215: summary="'|| ap_rec.application_short_name||' Product Dependencies">
1216:
1217:
1218: ');
Line 1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) || ' '

1236:
1237: htp.p('
');
1244: end loop;
Line 1243: htp.p('');

1239: htp.p('
');
1244: end loop;
1245: htp.p('

'||c_product || ' Item Dependency '||ap_rec.application_short_name

Line 1226: htp.p('
');

1222: v_loop_end := dep_table(ap_rec.application_id).id_base + dep_table(ap_rec.application_id).rowcount;
1223:
1224: v_item_name := 'forCe_Me_to_diff';
1225: for loop_index in v_loop_start .. v_loop_end loop
1226: htp.p('
');
1227:
1228: if v_item_name = dep_item_table(loop_index).product_item
1229: then htp.prn('
');
1230: else

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

1225: for loop_index in v_loop_start .. v_loop_end loop
1226: htp.p('
');
1227:
1228: if v_item_name = dep_item_table(loop_index).product_item
1229: then htp.prn('
');
1230: else
1231: htp.prn(initcap(dep_item_table(loop_index).product_item_type) || ' '
1232: || dep_item_table(loop_index).product_item_schema ||'.'
1233: || ''||dep_item_table(loop_index).product_item || '');

Line 1231: htp.prn(initcap(dep_item_table(loop_index).product_item_type) || ' '

1227:
1228: if v_item_name = dep_item_table(loop_index).product_item
1229: then htp.prn('
');
1230: else
1231: htp.prn(initcap(dep_item_table(loop_index).product_item_type) || ' '
1232: || dep_item_table(loop_index).product_item_schema ||'.'
1233: || ''||dep_item_table(loop_index).product_item || '');
1234: v_item_name := dep_item_table(loop_index).product_item;
1235: end if;

Line 1237: htp.p('
');

1233: || ''||dep_item_table(loop_index).product_item || '');
1234: v_item_name := dep_item_table(loop_index).product_item;
1235: end if;
1236:
1237: htp.p('
');
1238: htp.p(dep_item_table(loop_index).dep_type);
1239: htp.p(' ');
1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) || ' '
1241: || dep_item_table(loop_index).dep_item_schema ||'.'

Line 1238: htp.p(dep_item_table(loop_index).dep_type);

1234: v_item_name := dep_item_table(loop_index).product_item;
1235: end if;
1236:
1237: htp.p('
');
1238: htp.p(dep_item_table(loop_index).dep_type);
1239: htp.p(' ');
1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) || ' '
1241: || dep_item_table(loop_index).dep_item_schema ||'.'
1242: || ''||dep_item_table(loop_index).dep_item||'');

Line 1239: htp.p('
');

1235: end if;
1236:
1237: htp.p('
');
1238: htp.p(dep_item_table(loop_index).dep_type);
1239: htp.p(' ');
1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) || ' '
1241: || dep_item_table(loop_index).dep_item_schema ||'.'
1242: || ''||dep_item_table(loop_index).dep_item||'');
1243: htp.p('

');
1238: htp.p(dep_item_table(loop_index).dep_type);
1239: htp.p(' ');
1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) || ' '
1241: || dep_item_table(loop_index).dep_item_schema ||'.'
1242: || ''||dep_item_table(loop_index).dep_item||'');
1243: htp.p('

');
1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) || ' '
1241: || dep_item_table(loop_index).dep_item_schema ||'.'
1242: || ''||dep_item_table(loop_index).dep_item||'');
1243: htp.p('

');
1246: htp.p('
'||dep_table(ap_rec.application_id).rowcount || ' dependencies
');
1247: htp.p('
[top of page]
');

Line 1245: htp.p('');

1241: || dep_item_table(loop_index).dep_item_schema ||'.'
1242: || ''||dep_item_table(loop_index).dep_item||'');
1243: htp.p('');
1244: end loop;
1245: htp.p('');
1246: htp.p('
'||dep_table(ap_rec.application_id).rowcount || ' dependencies
');
1247: htp.p('
[top of page]
');
1248: end if;
1249: end loop;

Line 1246: htp.p('
'||dep_table(ap_rec.application_id).rowcount || ' dependencies
');

1242: || ''||dep_item_table(loop_index).dep_item||'');
1243: htp.p('');
1244: end loop;
1245: htp.p('');
1246: htp.p('
'||dep_table(ap_rec.application_id).rowcount || ' dependencies
');
1247: htp.p('
[top of page]
');
1248: end if;
1249: end loop;
1250: end if;

Line 1247: htp.p('
[top of page]
');

1243: htp.p('');
1244: end loop;
1245: htp.p('');
1246: htp.p('
'||dep_table(ap_rec.application_id).rowcount || ' dependencies
');
1247: htp.p('
[top of page]
');
1248: end if;
1249: end loop;
1250: end if;
1251:

Foreign Key Column	Foreign Table
'); 535: for key_col in cur_fk_columns(n_appid => n_appid 536: , n_tabid => n_tabid Line 534: htp.p('	'); 530: 531: 532: htp.p('
'); 535: for key_col in cur_fk_columns(n_appid => n_appid 536: , n_tabid => n_tabid 537: , n_keyid => key_rec.foreign_key_id) loop 538: if v_first2 = TRUE Line 541: htp.p(' '); 537: , n_keyid => key_rec.foreign_key_id) loop 538: if v_first2 = TRUE 539: then v_first2 := FALSE; 540: else 541: htp.p(' '); 542: end if; 543: htp.p(get_tablename(n_appid, n_tabid) 544: \|\|'.' 545: \|\|key_col.column_name Line 543: htp.p(get_tablename(n_appid, n_tabid) 539: then v_first2 := FALSE; 540: else 541: htp.p(' '); 542: end if; 543: htp.p(get_tablename(n_appid, n_tabid) 544: \|\|'.' 545: \|\|key_col.column_name 546: \|\|''); 547: end loop; Line 548: htp.p('	'); 551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id 552: , n_tabid => key_rec.primary_key_table_id)); Line 550: htp.p('	'); 546: \|\|''); 547: end loop; 548: htp.p('	'); 551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id 552: , n_tabid => key_rec.primary_key_table_id)); 553: htp.p('
'); 551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id 552: , n_tabid => key_rec.primary_key_table_id)); 553: htp.p('
'); 551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id 552: , n_tabid => key_rec.primary_key_table_id)); 553: htp.p('

Foreign Key Column	Foreign Table
Foreign Table
'); 580: for key_col in cur_fk_columns(n_appid => key_rec.application_id 581: , n_tabid => key_rec.table_id Line 579: htp.p('	'); 575: end if; 576: 577: htp.p('
'); 580: for key_col in cur_fk_columns(n_appid => key_rec.application_id 581: , n_tabid => key_rec.table_id 582: , n_keyid => key_rec.foreign_key_id) loop 583: if v_first2 = TRUE Line 586: htp.p(' '); 582: , n_keyid => key_rec.foreign_key_id) loop 583: if v_first2 = TRUE 584: then v_first2 := FALSE; 585: else 586: htp.p(' '); 587: end if; 588: 589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id) 590: \|\|'.' Line 589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id) 585: else 586: htp.p(' '); 587: end if; 588: 589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id) 590: \|\|'.' 591: \|\|key_col.column_name 592: \|\|''); 593: end loop; Line 594: htp.p('	'); 596: htp.p(v_tablename\|\|'
'); 591: \|\|key_col.column_name 592: \|\|''); 593: end loop; 594: htp.p('	'); 596: htp.p(v_tablename\|\|'
'); 596: htp.p(v_tablename\|\|'

Name	Datatype	Length	Prcn	Mandatory	Comments
Length
Name	Datatype	Length	Prcn	Mandatory	Comments
Prcn
Name	Datatype	Length	Prcn	Mandatory	Comments
Mandatory	Name	Datatype	Length	Prcn	Mandatory	Comments
Comments
Datatype	Length	Prcn	Mandatory	Comments
'); Line 664: htp.prn('
'); 660: htp.p('	Comments
'); 665: htp.prn(col_rec.column_name); 666: htp.p('	'); 668: htp.prn(col_rec.data_type); Line 665: htp.prn(col_rec.column_name); 661: v_first := FALSE; 662: end if; 663: 664: htp.prn('
'); 665: htp.prn(col_rec.column_name); 666: htp.p('	'); 668: htp.prn(col_rec.data_type); 669: htp.p('
'); 665: htp.prn(col_rec.column_name); 666: htp.p('	'); 668: htp.prn(col_rec.data_type); 669: htp.p('	'); Line 667: htp.prn('	'); 663: 664: htp.prn('
'); 665: htp.prn(col_rec.column_name); 666: htp.p('	'); 668: htp.prn(col_rec.data_type); 669: htp.p('	'); 671: if col_rec.data_type = 'DATE' Line 668: htp.prn(col_rec.data_type); 664: htp.prn('
'); 665: htp.prn(col_rec.column_name); 666: htp.p('	'); 668: htp.prn(col_rec.data_type); 669: htp.p('	'); 671: if col_rec.data_type = 'DATE' 672: then htp.prn(' '); Line 669: htp.p('	'); 668: htp.prn(col_rec.data_type); 669: htp.p('	'); 671: if col_rec.data_type = 'DATE' 672: then htp.prn(' '); 673: elsif (col_rec.data_type = 'NUMBER' Line 670: htp.prn('	'); 666: htp.p('	'); 668: htp.prn(col_rec.data_type); 669: htp.p('	'); 671: if col_rec.data_type = 'DATE' 672: then htp.prn(' '); 673: elsif (col_rec.data_type = 'NUMBER' 674: AND col_rec.data_precision = ' ') Line 672: then htp.prn(' '); 668: htp.prn(col_rec.data_type); 669: htp.p('	'); 671: if col_rec.data_type = 'DATE' 672: then htp.prn(' '); 673: elsif (col_rec.data_type = 'NUMBER' 674: AND col_rec.data_precision = ' ') 675: then htp.prn(' '); 676: elsif (col_rec.data_type = 'NUMBER' Line 675: then htp.prn(' '); 671: if col_rec.data_type = 'DATE' 672: then htp.prn(' '); 673: elsif (col_rec.data_type = 'NUMBER' 674: AND col_rec.data_precision = ' ') 675: then htp.prn(' '); 676: elsif (col_rec.data_type = 'NUMBER' 677: AND col_rec.data_precision != ' ') 678: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 679: elsif col_rec.data_length is null Line 678: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 674: AND col_rec.data_precision = ' ') 675: then htp.prn(' '); 676: elsif (col_rec.data_type = 'NUMBER' 677: AND col_rec.data_precision != ' ') 678: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 679: elsif col_rec.data_length is null 680: then htp.prn(' '); 681: else 682: htp.prn('('\|\|col_rec.data_length\|\|')'); Line 680: then htp.prn(' '); 676: elsif (col_rec.data_type = 'NUMBER' 677: AND col_rec.data_precision != ' ') 678: then htp.prn('('\|\|col_rec.data_precision\|\|')'); 679: elsif col_rec.data_length is null 680: then htp.prn(' '); 681: else 682: htp.prn('('\|\|col_rec.data_length\|\|')'); 683: end if; 684: htp.p('	'); 686: -- htp.prn(col_rec.data_precision); Line 684: htp.p('	'); 686: -- htp.prn(col_rec.data_precision); 687: -- htp.p('	'); Line 685: -- htp.prn('	'); 681: else 682: htp.prn('('\|\|col_rec.data_length\|\|')'); 683: end if; 684: htp.p('	'); 686: -- htp.prn(col_rec.data_precision); 687: -- htp.p('	'); 689: htp.prn(col_rec.nullable); Line 686: -- htp.prn(col_rec.data_precision); 682: htp.prn('('\|\|col_rec.data_length\|\|')'); 683: end if; 684: htp.p('	'); 686: -- htp.prn(col_rec.data_precision); 687: -- htp.p('	'); 689: htp.prn(col_rec.nullable); 690: htp.p('	'); 686: -- htp.prn(col_rec.data_precision); 687: -- htp.p('	'); 689: htp.prn(col_rec.nullable); 690: htp.p('	'); Line 688: htp.prn('	'); 684: htp.p('	'); 686: -- htp.prn(col_rec.data_precision); 687: -- htp.p('	'); 689: htp.prn(col_rec.nullable); 690: htp.p('	'); 692: v_first2 := TRUE; Line 689: htp.prn(col_rec.nullable); 685: -- htp.prn('	'); 686: -- htp.prn(col_rec.data_precision); 687: -- htp.p('	'); 689: htp.prn(col_rec.nullable); 690: htp.p('	'); 692: v_first2 := TRUE; 693: for t_rec in cur_col_comments(c_tname => c_name Line 690: htp.p('	'); 689: htp.prn(col_rec.nullable); 690: htp.p('	'); 692: v_first2 := TRUE; 693: for t_rec in cur_col_comments(c_tname => c_name 694: , c_cname => col_rec.column_name Line 691: htp.prn('	'); 687: -- htp.p('	'); 689: htp.prn(col_rec.nullable); 690: htp.p('	'); 692: v_first2 := TRUE; 693: for t_rec in cur_col_comments(c_tname => c_name 694: , c_cname => col_rec.column_name 695: , c_owner => c_owner) loop Line 698: htp.prn(' '); 694: , c_cname => col_rec.column_name 695: , c_owner => c_owner) loop 696: v_first2 := FALSE; 697: if t_rec.comments like '%- Retrofitted%' then 698: htp.prn(' '); 699: else 700: htp.prn(t_rec.comments); 701: end if; 702: end loop; Line 700: htp.prn(t_rec.comments); 696: v_first2 := FALSE; 697: if t_rec.comments like '%- Retrofitted%' then 698: htp.prn(' '); 699: else 700: htp.prn(t_rec.comments); 701: end if; 702: end loop; 703: if v_first2 then 704: htp.prn(' '); Line 704: htp.prn(' '); 700: htp.prn(t_rec.comments); 701: end if; 702: end loop; 703: if v_first2 then 704: htp.prn(' '); 705: end if; 706: htp.p('

Product	Dependency	Product
' 1170: AND (dep_table(ap_rec.application_id).used_by = FALSE)) 1171: then null; 1172: elsif (dep_table(ap_rec.application_id).uses = TRUE 1173: AND dep_table(ap_rec.application_id).used_by = FALSE) 1174: then htp.p('
' 1175: \|\|v_product\|\|'	uses	' 1176: \|\|'' 1177: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1178: htp.p('
' 1175: \|\|v_product\|\|'	uses	' 1176: \|\|'' 1177: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1178: htp.p('
' 1179: 1180: v_product := ' '; -- print product name once only. 1181: elsif (dep_table(ap_rec.application_id).uses = FALSE 1182: AND dep_table(ap_rec.application_id).used_by = TRUE) 1183: then htp.p('
' 1184: \|\|v_product\|\|'	used by	' 1185: \|\|'' 1186: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1187: htp.p('
' 1184: \|\|v_product\|\|'	used by	' 1185: \|\|'' 1186: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1187: htp.p('
' 1191: \|\|v_product\|\|'	used by/uses	' Line 1190: htp.p('
' 1186: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1187: htp.p('
' 1191: \|\|v_product\|\|'	used by/uses	' 1192: \|\|'' 1193: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1194: htp.p('
' 1191: \|\|v_product\|\|'	used by/uses	' 1192: \|\|'' 1193: \|\|ap_rec.application_short_name\|\|' - '\|\|ap_rec.application_name\|\|''); 1194: htp.p('

'\|\|c_product \|\| ' Item	Dependency	'\|\|ap_rec.application_short_name Line 1226: htp.p('
'); 1222: v_loop_end := dep_table(ap_rec.application_id).id_base + dep_table(ap_rec.application_id).rowcount; 1223: 1224: v_item_name := 'forCe_Me_to_diff'; 1225: for loop_index in v_loop_start .. v_loop_end loop 1226: htp.p('
'); 1227: 1228: if v_item_name = dep_item_table(loop_index).product_item 1229: then htp.prn(' '); 1230: else Line 1229: then htp.prn(' '); 1225: for loop_index in v_loop_start .. v_loop_end loop 1226: htp.p('
'); 1227: 1228: if v_item_name = dep_item_table(loop_index).product_item 1229: then htp.prn(' '); 1230: else 1231: htp.prn(initcap(dep_item_table(loop_index).product_item_type) \|\| ' ' 1232: \|\| dep_item_table(loop_index).product_item_schema \|\|'.' 1233: \|\| ''\|\|dep_item_table(loop_index).product_item \|\| ''); Line 1231: htp.prn(initcap(dep_item_table(loop_index).product_item_type) \|\| ' ' 1227: 1228: if v_item_name = dep_item_table(loop_index).product_item 1229: then htp.prn(' '); 1230: else 1231: htp.prn(initcap(dep_item_table(loop_index).product_item_type) \|\| ' ' 1232: \|\| dep_item_table(loop_index).product_item_schema \|\|'.' 1233: \|\| ''\|\|dep_item_table(loop_index).product_item \|\| ''); 1234: v_item_name := dep_item_table(loop_index).product_item; 1235: end if; Line 1237: htp.p('	'); 1233: \|\| ''\|\|dep_item_table(loop_index).product_item \|\| ''); 1234: v_item_name := dep_item_table(loop_index).product_item; 1235: end if; 1236: 1237: htp.p('	'); 1238: htp.p(dep_item_table(loop_index).dep_type); 1239: htp.p('	'); 1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) \|\| ' ' 1241: \|\| dep_item_table(loop_index).dep_item_schema \|\|'.' Line 1238: htp.p(dep_item_table(loop_index).dep_type); 1234: v_item_name := dep_item_table(loop_index).product_item; 1235: end if; 1236: 1237: htp.p('	'); 1238: htp.p(dep_item_table(loop_index).dep_type); 1239: htp.p('	'); 1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) \|\| ' ' 1241: \|\| dep_item_table(loop_index).dep_item_schema \|\|'.' 1242: \|\| ''\|\|dep_item_table(loop_index).dep_item\|\|''); Line 1239: htp.p('	'); 1235: end if; 1236: 1237: htp.p('	'); 1238: htp.p(dep_item_table(loop_index).dep_type); 1239: htp.p('	'); 1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) \|\| ' ' 1241: \|\| dep_item_table(loop_index).dep_item_schema \|\|'.' 1242: \|\| ''\|\|dep_item_table(loop_index).dep_item\|\|''); 1243: htp.p('
'); 1238: htp.p(dep_item_table(loop_index).dep_type); 1239: htp.p('	'); 1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) \|\| ' ' 1241: \|\| dep_item_table(loop_index).dep_item_schema \|\|'.' 1242: \|\| ''\|\|dep_item_table(loop_index).dep_item\|\|''); 1243: htp.p('
'); 1240: htp.p(initcap(dep_item_table(loop_index).dep_item_type) \|\| ' ' 1241: \|\| dep_item_table(loop_index).dep_item_schema \|\|'.' 1242: \|\| ''\|\|dep_item_table(loop_index).dep_item\|\|''); 1243: htp.p('

APPS.ETRM_RPT dependencies on HTP

Line 283: htp.p('

Comments

Comments

Line 285: htp.p(c_rec.comments);

Comments

Line 292: htp.p('

Primary Key: '|| key_rec.constraint_name || '

Primary Key: '|| key_rec.constraint_name || '

Line 293: htp.p('');

Primary Key: '|| key_rec.constraint_name || '

Line 296: htp.p(' '

Primary Key: '|| key_rec.constraint_name || '

Line 300: htp.p('

Unique Key: '|| key_rec.constraint_name || '

Line 304: htp.p('

Unique Key: '|| key_rec.constraint_name || '

Unique Key: '|| key_rec.constraint_name || '

Line 305: htp.p('');

Unique Key: '|| key_rec.constraint_name || '

Line 307: htp.p(' '

Unique Key: '|| key_rec.constraint_name || '

Line 311: htp.p('

Line 318: htp.p('

Indexes

Indexes

Line 319: htp.p('

Indexes

Line 328: htp.p('

Line 329: htp.p('

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

Line 331: htp.p('

Line 334: htp.p('

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

Line 336: htp.p('

Line 339: htp.p('

Line 340: htp.p(ind_rec.tablespace_name);

Line 341: htp.p('');

Line 345: htp.p('

Line 352: htp.p(' ');

Line 354: htp.p(ind_col_rec.column_name);

Line 356: htp.p('');

Line 362: htp.p('

Line 485: htp.p('

Table: '||tab_rec.table_name ||'

Table: '||tab_rec.table_name ||'

Line 487: htp.p('

Table: '||tab_rec.table_name ||'

Line 490: htp.p('

Line 495: htp.p('

Line 502: htp.p('

Primary Key: '|| key_rec.primary_key_name || '

Primary Key: '|| key_rec.primary_key_name || '

Line 503: htp.p('');

Primary Key: '|| key_rec.primary_key_name || '

Line 507: htp.p(''

Line 511: htp.p('

Line 521: htp.p('

Foreign Keys from this table:

Foreign Keys from this table:

Line 522: htp.p('

Foreign Keys from this table:

Line 532: htp.p('

Line 534: htp.p('

Line 541: htp.p(' ');

Line 543: htp.p(get_tablename(n_appid, n_tabid)

Line 548: htp.p('

Line 550: htp.p('

Line 551: htp.p(get_tablename(n_appid => key_rec.primary_key_application_id

Line 553: htp.p('');

Line 560: htp.p('

Line 568: htp.p('

Foreign Keys to this table:

Foreign Keys to this table:

Line 569: htp.p('

Foreign Keys to this table:

Line 577: htp.p('

Line 579: htp.p('

Line 586: htp.p(' ');

Line 589: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)

Line 293: htp.p('
');

Line 296: htp.p('
'

Line 305: htp.p('
');

Line 307: htp.p('
'

Line 352: htp.p('
');

Line 503: htp.p('
');

Line 507: htp.p('
'

Line 541: htp.p('
');

Line 586: htp.p('
');

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

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

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

Line 698: htp.prn('
');

Line 704: htp.prn('
');

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

Line 750: htp.p('
');

Line 758: htp.p('
');

Line 766: htp.p('
');

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

Line 790: htp.p('
');

Line 798: htp.p('
');

Line 805: htp.p('
');

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

Line 849: htp.p('
`');`

`View Text - Preformatted`