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.
[Home] [Help]
APPS.ETRM_FNDNAV dependencies on HTP
Line 147: htp.p(''||v_version||' FND Design Data ');
143: for v_rec in cur_version loop
144: v_version := v_rec.release_name;
145: end loop;
146:
147: htp.p(''||v_version||' FND Design Data ');
148:
149: end quick_list;
150:
151: procedure draw_form(n_appid in number := NULL
Line 176: htp.p(' Browse the FND Tables in an Applications database
');
172:
173: if (n_appid is null
174: and c_name = '%'
175: and c_type = '%') then
176: htp.p('
Browse the FND Tables in an Applications database
');
177: else
178: null;
179: -- htp.p(' FND Navigator Home ');
180: end if;
Line 179: -- htp.p(' FND Navigator Home ');
175: and c_type = '%') then
176: htp.p('
Browse the FND Tables in an Applications database
');
177: else
178: null;
179: -- htp.p(' FND Navigator Home ');
180: end if;
181:
182:
183:
Line 186: htp.p(' ');
230:
231:
232: end draw_form;
233:
Line 324: htp.p('');
320:
321:
322: if (v_counter >0) then
323:
324: htp.p('');
325: uiutil.a_href_gen(c_type => 'APP'
326: , c_link => 'etrm_fndnav.ls_object?c_name='
327: ||replace(c_name, '%', '*')
328: ||'&n_appid='||n_appid
Line 331: htp.p('');
327: ||replace(c_name, '%', '*')
328: ||'&n_appid='||n_appid
329: ||'&c_type=' ||replace(nvl(c_type, '*'), '%', '*')
330: , c_display => get_appname(n_appid));
331: htp.p('');
332: -- else
333: -- htp.p('
'||uiutil.el_image('APP')
334: -- ||get_appname(n_appid)
335: -- ||' ');
Line 333: -- htp.p(''||uiutil.el_image('APP')
329: ||'&c_type=' ||replace(nvl(c_type, '*'), '%', '*')
330: , c_display => get_appname(n_appid));
331: htp.p('');
332: -- else
333: -- htp.p(''||uiutil.el_image('APP')
334: -- ||get_appname(n_appid)
335: -- ||'');
336: -- htp.p('
No documented items ');
337: end if;
Line 336: -- htp.p('No documented items ');
332: -- else
333: -- htp.p('
'||uiutil.el_image('APP')
334: -- ||get_appname(n_appid)
335: -- ||' ');
336: -- htp.p('No documented items ');
337: end if;
338:
339: if vtable_count > 0 then
340: htp.p('');
Line 340: htp.p('');
336: -- htp.p('
No documented items ');
337: end if;
338:
339: if vtable_count > 0 then
340: htp.p('');
341: uiutil.a_href_gen(c_type => 'TABLE'
342: , c_link => 'etrm_fndnav.ls_object?c_name='
343: ||replace(c_name, '%', '*')
344: ||'&n_appid='
Line 348: htp.p(' ');
344: ||'&n_appid='
345: ||n_appid
346: ||'&c_type=TABLE'
347: , c_display => vtable_count||' Tables');
348: htp.p('');
349: end if;
350:
351: if vview_count > 0 then
352: htp.p('
');
Line 352: htp.p('');
348: htp.p('
');
349: end if;
350:
351: if vview_count > 0 then
352: htp.p('');
353: uiutil.a_href_gen(c_type => 'VIEW'
354: , c_link => 'etrm_fndnav.ls_object?c_name='
355: ||replace(c_name, '%', '*')
356: ||'&n_appid='
Line 360: htp.p('');
356: ||'&n_appid='
357: ||n_appid
358: ||'&c_type=VIEW'
359: , c_display => vview_count||' Views');
360: htp.p('');
361: end if;
362:
363: if vconcurrent_count > 0 then
364: htp.p('
');
Line 364: htp.p('');
360: htp.p('
');
361: end if;
362:
363: if vconcurrent_count > 0 then
364: htp.p('');
365: uiutil.a_href_gen(c_type => 'CONCURRENT'
366: , c_link => 'etrm_fndnav.ls_object?c_name='
367: ||replace(c_name, '%', '*')
368: ||'&n_appid='
Line 372: htp.p('');
368: ||'&n_appid='
369: ||n_appid
370: ||'&c_type=CONCURRENT'
371: , c_display => vconcurrent_count||' Concurrent Programs');
372: htp.p('');
373: end if;
374:
375: if vlookup_count > 0 then
376: htp.p('
');
Line 376: htp.p('');
372: htp.p('
');
373: end if;
374:
375: if vlookup_count > 0 then
376: htp.p('');
377: uiutil.a_href_gen(c_type => 'LOOKUP'
378: , c_link => 'etrm_fndnav.ls_object?c_name='
379: ||replace(c_name, '%', '*')
380: ||'&n_appid='
Line 384: htp.p('');
380: ||'&n_appid='
381: ||n_appid
382: ||'&c_type=LOOKUP'
383: , c_display => vlookup_count||' Lookup Types');
384: htp.p('');
385: end if;
386:
387: if vfile_count > 0 then
388: htp.p('
');
Line 388: htp.p('');
384: htp.p('
');
385: end if;
386:
387: if vfile_count > 0 then
388: htp.p('');
389: uiutil.a_href_gen(c_type => 'FILE'
390: , c_link => 'etrm_fndnav.ls_object?c_name='
391: ||replace(c_name, '%', '*')
392: ||'&n_appid='
Line 396: htp.p('');
392: ||'&n_appid='
393: ||n_appid
394: ||'&c_type=FILE'
395: , c_display => vfile_count||' Diagrams & Reports');
396: htp.p('');
397: end if;
398:
399: if vevent_count > 0 then
400: htp.p('
');
Line 400: htp.p('');
396: htp.p('
');
397: end if;
398:
399: if vevent_count > 0 then
400: htp.p('');
401: uiutil.a_href_gen(c_type => 'EVENT'
402: , c_link => 'etrm_fndnav.ls_object?c_name='
403: ||replace(c_name, '%', '*')
404: ||'&n_appid='
Line 408: htp.p('');
404: ||'&n_appid='
405: ||n_appid
406: ||'&c_type=EVENT'
407: , c_display => vevent_count||' Workflow Events');
408: htp.p('');
409: end if;
410:
411: if v_counter > 0 then
412: htp.p('
'||v_counter ||' objects ');
Line 412: htp.p(''||v_counter ||' objects ');
408: htp.p('');
409: end if;
410:
411: if v_counter > 0 then
412: htp.p(''||v_counter ||' objects ');
413: end if;
414:
415: end ls_app_itemcount;
416:
Line 448: htp.p('');
444: uiutil.cabo3;
445:
446: v_name := replace(c_name, '*', '%'); -- http drops trailing %
447: v_type := replace(c_type, '*', '%');
448: htp.p('');
449: htp.p('
'
450: ||uiutil.el_image('ROOT')
451: ||' ');
452:
Line 449: htp.p(''
445:
446: v_name := replace(c_name, '*', '%'); -- http drops trailing %
447: v_type := replace(c_type, '*', '%');
448: htp.p('
');
449: htp.p(''
450: ||uiutil.el_image('ROOT')
451: ||'');
452:
453: if n_appid is NULL then
Line 466: htp.p(' ');
462: , c_type => v_type);
463: end if;
464:
465:
466: htp.p('');
467:
468: uiutil.cabo4;
469: quick_list;
470: uiutil.cabo5;
Line 566: htp.p('');
562: draw_tabs;
563: uiutil.cabo3;
564:
565: v_name := replace(c_name, '*', '%'); -- http drops trailing %
566: htp.p('');
567: htp.p('
'
568: ||uiutil.el_image('ROOT')
569: ||' ');
570: -- htp.p(uiutil.el_image('APP')
Line 567: htp.p(''
563: uiutil.cabo3;
564:
565: v_name := replace(c_name, '*', '%'); -- http drops trailing %
566: htp.p('
');
567: htp.p(''
568: ||uiutil.el_image('ROOT')
569: ||'');
570: -- htp.p(uiutil.el_image('APP')
571: -- ||''
Line 570: -- htp.p(uiutil.el_image('APP')
566: htp.p('
');
567: htp.p(''
568: ||uiutil.el_image('ROOT')
569: ||' ');
570: -- htp.p(uiutil.el_image('APP')
571: -- ||''
572: -- ||get_appname(n_appid)
573: -- ||' ');
574:
Line 579: htp.p('');
575: uiutil.a_href_gen(c_type => 'APP'
576: , c_link => 'etrm_fndnav.ls_object?n_appid='||n_appid
577: || '&c_name=*&c_type=*'
578: , c_display => get_appname(n_appid));
579: htp.p('');
580:
581:
582: if c_type = 'TABLE' then
583: for a_rec in cur_tables(v_name, n_appid) loop
Line 584: htp.p('');
580:
581:
582: if c_type = 'TABLE' then
583: for a_rec in cur_tables(v_name, n_appid) loop
584: htp.p('');
585: uiutil.a_javascript_gen(c_type => 'TABLE'
586: , c_link => 'etrm_fndnav.show_object?n_appid='
587: || n_appid
588: ||'&n_tabid='
Line 592: htp.p('');
588: ||'&n_tabid='
589: ||a_rec.id
590: ||'&c_type=TABLE'
591: , c_display => a_rec.name);
592: htp.p('');
593: v_counter := v_counter + 1;
594: end loop;
595: elsif c_type = 'VIEW' then
596: for a_rec in cur_views(v_name, n_appid) loop
Line 597: htp.p('');
593: v_counter := v_counter + 1;
594: end loop;
595: elsif c_type = 'VIEW' then
596: for a_rec in cur_views(v_name, n_appid) loop
597: htp.p('');
598: uiutil.a_javascript_gen(c_type => 'VIEW'
599: , c_link => 'etrm_fndnav.show_object?n_appid='
600: || n_appid
601: ||'&n_tabid='
Line 605: htp.p('');
601: ||'&n_tabid='
602: ||a_rec.id
603: ||'&c_type=VIEW'
604: , c_display => a_rec.name);
605: htp.p('');
606: v_counter := v_counter + 1;
607: end loop;
608: elsif c_type = 'CONCURRENT' then
609: for a_rec in cur_concurrent(v_name, n_appid) loop
Line 610: htp.p('');
606: v_counter := v_counter + 1;
607: end loop;
608: elsif c_type = 'CONCURRENT' then
609: for a_rec in cur_concurrent(v_name, n_appid) loop
610: htp.p('');
611: uiutil.a_javascript_gen(c_type => 'CONCURRENT'
612: , c_link => 'etrm_fndnav.show_object?n_appid='
613: || n_appid
614: ||'&n_tabid='
Line 618: htp.p('');
614: ||'&n_tabid='
615: ||a_rec.id
616: ||'&c_type=CONCURRENT'
617: , c_display => a_rec.name);
618: htp.p('');
619: v_counter := v_counter + 1;
620: end loop;
621: elsif c_type = 'LOOKUP' then
622: for a_rec in cur_lookup(v_name, n_appid) loop
Line 623: htp.p('');
619: v_counter := v_counter + 1;
620: end loop;
621: elsif c_type = 'LOOKUP' then
622: for a_rec in cur_lookup(v_name, n_appid) loop
623: htp.p('');
624: uiutil.a_javascript_gen(c_type => 'LOOKUP'
625: , c_link => 'etrm_fndnav.show_object?n_appid='
626: || n_appid
627: ||'&n_tabid='
Line 631: htp.p('');
627: ||'&n_tabid='
628: ||a_rec.id
629: ||'&c_type=LOOKUP'
630: , c_display => a_rec.name);
631: htp.p('');
632: v_counter := v_counter + 1;
633: end loop;
634:
635: elsif c_type = 'FILE' then
Line 637: htp.p('');
633: end loop;
634:
635: elsif c_type = 'FILE' then
636: for a_rec in cur_files(v_name, n_appid) loop
637: htp.p('');
638: uiutil.a_javascript_gen(c_type => 'FILE'
639: , c_link => 'etrm_fndnav.show_object?n_appid='
640: || n_appid
641: ||'&n_tabid='
Line 645: htp.p('');
641: ||'&n_tabid='
642: ||a_rec.id
643: ||'&c_type=FILE'
644: , c_display => a_rec.name);
645: htp.p('');
646: v_counter := v_counter + 1;
647: end loop;
648:
649: elsif c_type = 'EVENT' then
Line 651: htp.p('');
647: end loop;
648:
649: elsif c_type = 'EVENT' then
650: for a_rec in cur_event(v_name, n_appid) loop
651: htp.p('');
652: uiutil.a_javascript_gen(c_type => 'EVENT'
653: , c_link => 'etrm_fndnav.show_object?n_appid='
654: || n_appid
655: ||'&n_tabid='
Line 659: htp.p('');
655: ||'&n_tabid='
656: ||a_rec.id
657: ||'&c_type=EVENT'
658: , c_display => a_rec.name);
659: htp.p('');
660: v_counter := v_counter + 1;
661: end loop;
662:
663: elsif c_type in ('%', '*') then
Line 665: htp.p('');
661: end loop;
662:
663: elsif c_type in ('%', '*') then
664: for a_rec in cur_tables_and_views(v_name, n_appid) loop
665: htp.p('');
666: uiutil.a_javascript_gen(c_type => rtrim(a_rec.o_type)
667: , c_link => 'etrm_fndnav.show_object?n_appid='
668: || n_appid
669: ||'&n_tabid='
Line 674: htp.p('');
670: ||a_rec.id
671: ||'&c_type='
672: ||rtrim(a_rec.o_type)
673: , c_display => a_rec.name);
674: htp.p('');
675: v_counter := v_counter + 1;
676: end loop;
677: else
678: htp.p('
Application does not support objects of given type ');
Line 678: htp.p('Application does not support objects of given type ');
674: htp.p('');
675: v_counter := v_counter + 1;
676: end loop;
677: else
678: htp.p('Application does not support objects of given type ');
679: end if;
680:
681:
682: htp.p('
'||v_counter ||' objects ');
Line 682: htp.p(''||v_counter ||' objects ');
678: htp.p('
Application does not support objects of given type ');
679: end if;
680:
681:
682: htp.p(''||v_counter ||' objects ');
683: htp.p(' ');
684:
685: uiutil.cabo4;
686: quick_list;
Line 683: htp.p(' ');
679: end if;
680:
681:
682: htp.p('
'||v_counter ||' objects ');
683: htp.p('');
684:
685: uiutil.cabo4;
686: quick_list;
687: uiutil.cabo5;
Line 689: htp.p('
');
685: uiutil.cabo4;
686: quick_list;
687: uiutil.cabo5;
688: -- draw_form(n_appid => n_appid, c_name=> c_name, c_type => c_type);
689: htp.p('
');
690: uiutil.cabo6;
691: end ls_product;
692:
693:
Line 863: htp.p('Table: '||tab_rec.table_name ||' ');
859: --
860:
861: v_first := TRUE;
862: FOR tab_rec IN cur_table_dets(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
863: htp.p('Table: '||tab_rec.table_name ||' ');
864: v_tablename := tab_rec.table_name;
865: htp.p('
866: summary="location information">');
867:
Line 865: htp.p('
861: v_first := TRUE;
862: FOR tab_rec IN cur_table_dets(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
863: htp.p('
Table: '||tab_rec.table_name ||' ');
864: v_tablename := tab_rec.table_name;
865: htp.p('
866: summary="location information">');
867:
868: htp.p('Product: '
869: || get_appname(n_appid)||' ');
Line 868: htp.p('Product: '
864: v_tablename := tab_rec.table_name;
865: htp.p('
866: summary="location information">');
867:
868: htp.p('Product: '
869: || get_appname(n_appid)||' ');
870: htp.p('Description: '
871: || tab_rec.description||' ');
872:
Line 870: htp.p('Description: '
866: summary="location information">');
867:
868: htp.p('
Product: '
869: || get_appname(n_appid)||' ');
870: htp.p('Description: '
871: || tab_rec.description||' ');
872:
873: htp.p('Implementation/DBA Data: ');
874: etrm_pnav.prn_object_type(c_name => tab_rec.table_name
Line 873: htp.p('Implementation/DBA Data: ');
869: || get_appname(n_appid)||'
');
870: htp.p('Description: '
871: || tab_rec.description||' ');
872:
873: htp.p('Implementation/DBA Data: ');
874: etrm_pnav.prn_object_type(c_name => tab_rec.table_name
875: , c_owner => '%'
876: , c_type => 'TABLE'
877: , c_status => '%');
Line 878: htp.p(' ');
874: etrm_pnav.prn_object_type(c_name => tab_rec.table_name
875: , c_owner => '%'
876: , c_type => 'TABLE'
877: , c_status => '%');
878: htp.p('
');
879:
880: htp.p('
');
881: /*
882: htp.p('Storage Details ');
Line 880: htp.p('
');
876: , c_type => 'TABLE'
877: , c_status => '%');
878: htp.p('');
879:
880: htp.p('
');
881: /*
882: htp.p('Storage Details ');
883: htp.p('
884: summary="dba information">');
Line 882: htp.p('Storage Details ');
878: htp.p('');
879:
880: htp.p('
');
881: /*
882: htp.p('Storage Details ');
883: htp.p('
884: summary="dba information">');
885:
886: htp.p('Initial Extent: '
Line 883: htp.p(' ');
881: /*
882: htp.p('Storage Details ');
883: htp.p('
884: summary="dba information">');
885:
886: htp.p('Initial Extent: '
887: || tab_rec.initial_extent||' ');
Line 886: htp.p('Initial Extent: '
882: htp.p('
Storage Details ');
883: htp.p('
884: summary="dba information">');
885:
886: htp.p('Initial Extent: '
887: || tab_rec.initial_extent||' ');
888: htp.p('Next Extent: '
889: || tab_rec.next_extent||' ');
890: htp.p('Min Extents: '
Line 888: htp.p('Next Extent: '
884: summary="dba information">');
885:
886: htp.p('
Initial Extent: '
887: || tab_rec.initial_extent||' ');
888: htp.p('Next Extent: '
889: || tab_rec.next_extent||' ');
890: htp.p('Min Extents: '
891: || tab_rec.min_extents||' ');
892: htp.p('Max Extents: '
Line 890: htp.p('Min Extents: '
886: htp.p('
Initial Extent: '
887: || tab_rec.initial_extent||' ');
888: htp.p('Next Extent: '
889: || tab_rec.next_extent||' ');
890: htp.p('Min Extents: '
891: || tab_rec.min_extents||' ');
892: htp.p('Max Extents: '
893: || tab_rec.max_extents||' ');
894:
Line 892: htp.p('Max Extents: '
888: htp.p('
Next Extent: '
889: || tab_rec.next_extent||' ');
890: htp.p('Min Extents: '
891: || tab_rec.min_extents||' ');
892: htp.p('Max Extents: '
893: || tab_rec.max_extents||' ');
894:
895: htp.p('% Increase: '
896: || tab_rec.pct_increase||' ');
Line 895: htp.p('% Increase: '
891: || tab_rec.min_extents||'
');
892: htp.p('Max Extents: '
893: || tab_rec.max_extents||' ');
894:
895: htp.p('% Increase: '
896: || tab_rec.pct_increase||' ');
897: htp.p('Init Trans: '
898: || tab_rec.ini_trans||' ');
899: htp.p('Max Trans: '
Line 897: htp.p('Init Trans: '
893: || tab_rec.max_extents||'
');
894:
895: htp.p('% Increase: '
896: || tab_rec.pct_increase||' ');
897: htp.p('Init Trans: '
898: || tab_rec.ini_trans||' ');
899: htp.p('Max Trans: '
900: || tab_rec.max_trans||' ');
901: htp.p('% Free: '
Line 899: htp.p('Max Trans: '
895: htp.p('
% Increase: '
896: || tab_rec.pct_increase||' ');
897: htp.p('Init Trans: '
898: || tab_rec.ini_trans||' ');
899: htp.p('Max Trans: '
900: || tab_rec.max_trans||' ');
901: htp.p('% Free: '
902: ||tab_rec.pct_free||' ');
903: htp.p('% Used: '
Line 901: htp.p('% Free: '
897: htp.p('
Init Trans: '
898: || tab_rec.ini_trans||' ');
899: htp.p('Max Trans: '
900: || tab_rec.max_trans||' ');
901: htp.p('% Free: '
902: ||tab_rec.pct_free||' ');
903: htp.p('% Used: '
904: || tab_rec.pct_used||' ');
905: htp.p('
');
Line 903: htp.p('% Used: '
899: htp.p('
Max Trans: '
900: || tab_rec.max_trans||' ');
901: htp.p('% Free: '
902: ||tab_rec.pct_free||' ');
903: htp.p('% Used: '
904: || tab_rec.pct_used||' ');
905: htp.p('
');
906: */
907:
Line 905: htp.p('
');
901: htp.p('
% Free: '
902: ||tab_rec.pct_free||' ');
903: htp.p('% Used: '
904: || tab_rec.pct_used||' ');
905: htp.p('
');
906: */
907:
908:
909:
Line 915: htp.p('Primary Key: '|| key_rec.primary_key_name || ' ');
911: --
912:
913:
914: for key_rec in cur_primary_key(n_appid => n_appid, n_tabid => n_tabid) loop
915: htp.p('Primary Key: '|| key_rec.primary_key_name || ' ');
916: htp.p('
');
917: for key_col in cur_pk_columns(n_appid => n_appid
918: , n_tabid => n_tabid
919: , n_keyid => key_rec.primary_key_id) loop
Line 916: htp.p('');
912:
913:
914: for key_rec in cur_primary_key(n_appid => n_appid, n_tabid => n_tabid) loop
915: htp.p('
Primary Key: '|| key_rec.primary_key_name || ' ');
916: htp.p('');
917: for key_col in cur_pk_columns(n_appid => n_appid
918: , n_tabid => n_tabid
919: , n_keyid => key_rec.primary_key_id) loop
920: htp.p(''
Line 920: htp.p(' '
916: htp.p('
');
917: for key_col in cur_pk_columns(n_appid => n_appid
918: , n_tabid => n_tabid
919: , n_keyid => key_rec.primary_key_id) loop
920: htp.p(''
921: || uiutil.el_image('COL')
922: ||key_col.column_name
923: ||' ');
924: end loop;
Line 925: htp.p(' ');
921: || uiutil.el_image('COL')
922: ||key_col.column_name
923: ||'');
924: end loop;
925: htp.p('');
926: end loop;
927:
928: v_first := TRUE;
929:
Line 935: htp.p('Foreign Keys ');
931: for key_rec in cur_foreign_key(n_appid => n_appid
932: , n_tabid => n_tabid) loop
933: if v_first = TRUE then
934: v_first := FALSE;
935: htp.p('Foreign Keys ');
936: htp.p('
937: summary="Foreign keys from/to this table">
938:
939: Table
Line 936: htp.p('
932: , n_tabid => n_tabid) loop
933: if v_first = TRUE then
934: v_first := FALSE;
935: htp.p('
Foreign Keys ');
936: htp.p('
937: summary="Foreign keys from/to this table">
938:
939: Table
940:
Line 947: htp.p('');
943: end if;
944:
945:
946:
947: htp.p('');
948: htp.p(''
949: ||v_tablename
950: ||' ');
951: htp.p(''
Line 948: htp.p(''
944:
945:
946:
947: htp.p('
');
948: htp.p(' '
949: ||v_tablename
950: ||' ');
951: htp.p(''
952: ||uiutil.el_image('FK')
Line 951: htp.p(''
947: htp.p('
');
948: htp.p(''
949: ||v_tablename
950: ||' ');
951: htp.p(' '
952: ||uiutil.el_image('FK')
953: || ' ');
954: htp.p('');
955: uiutil.a_href_gen(c_type => 'TABLE'
Line 954: htp.p('');
950: ||'
');
951: htp.p(''
952: ||uiutil.el_image('FK')
953: || ' ');
954: htp.p(' ');
955: uiutil.a_href_gen(c_type => 'TABLE'
956: , c_link => 'etrm_fndnav.show_object?n_appid='
957: ||key_rec.primary_key_application_id
958: ||'&n_tabid='
Line 963: htp.p(' ');
959: ||key_rec.primary_key_table_id
960: ||'&c_type=TABLE'
961: , c_display => get_tablename(n_appid => key_rec.primary_key_application_id
962: , n_tabid => key_rec.primary_key_table_id));
963: htp.p('
');
964:
965: v_first2 := TRUE;
966: htp.p('');
967: for key_col in cur_fk_columns(n_appid => n_appid
Line 966: htp.p('');
962: , n_tabid => key_rec.primary_key_table_id));
963: htp.p('
');
964:
965: v_first2 := TRUE;
966: htp.p(' ');
967: for key_col in cur_fk_columns(n_appid => n_appid
968: , n_tabid => n_tabid
969: , n_keyid => key_rec.foreign_key_id) loop
970: if v_first2 = TRUE
Line 973: htp.p('
');
969: , n_keyid => key_rec.foreign_key_id) loop
970: if v_first2 = TRUE
971: then v_first2 := FALSE;
972: else
973: htp.p('
');
974: end if;
975: htp.p(get_tablename(n_appid, n_tabid)
976: ||'.'
977: ||key_col.column_name
Line 975: htp.p(get_tablename(n_appid, n_tabid)
971: then v_first2 := FALSE;
972: else
973: htp.p('
');
974: end if;
975: htp.p(get_tablename(n_appid, n_tabid)
976: ||'.'
977: ||key_col.column_name
978: ||' ');
979: end loop;
Line 980: htp.p(' ');
976: ||'.'
977: ||key_col.column_name
978: ||' ');
979: end loop;
980: htp.p('
');
981: end loop;
982: --
983:
984: for key_rec in cur_fk_refs(n_appid => n_appid
Line 988: htp.p('Foreign Keys ');
984: for key_rec in cur_fk_refs(n_appid => n_appid
985: , n_tabid => n_tabid) loop
986: if v_first = TRUE then
987: v_first := FALSE;
988: htp.p('Foreign Keys ');
989: htp.p('
990: summary="Foreign keys from/to this table">
991:
992: Table
Line 989: htp.p('
985: , n_tabid => n_tabid) loop
986: if v_first = TRUE then
987: v_first := FALSE;
988: htp.p('
Foreign Keys ');
989: htp.p('
990: summary="Foreign keys from/to this table">
991:
992: Table
993:
Line 998: htp.p('');
994:
Foreign Table
995: Foreign Key Column ');
996: end if;
997:
998: htp.p('');
999: htp.p('');
1000: uiutil.a_href_gen(c_type => 'TABLE'
1001: , c_link => 'etrm_fndnav.show_object?n_appid='
1002: ||key_rec.application_id
Line 999: htp.p('');
995:
Foreign Key Column ');
996: end if;
997:
998: htp.p('');
999: htp.p(' ');
1000: uiutil.a_href_gen(c_type => 'TABLE'
1001: , c_link => 'etrm_fndnav.show_object?n_appid='
1002: ||key_rec.application_id
1003: ||'&n_tabid='
Line 1008: htp.p(' ');
1004: ||key_rec.table_id
1005: ||'&c_type=TABLE'
1006: , c_display => get_tablename(n_appid => key_rec.application_id
1007: , n_tabid => key_rec.table_id));
1008: htp.p('');
1009: htp.p('
'
1010: ||uiutil.el_image('FK')
1011: ||' ');
1012: htp.p('');
Line 1009: htp.p(''
1005: ||'&c_type=TABLE'
1006: , c_display => get_tablename(n_appid => key_rec.application_id
1007: , n_tabid => key_rec.table_id));
1008: htp.p('
');
1009: htp.p(' '
1010: ||uiutil.el_image('FK')
1011: ||' ');
1012: htp.p('');
1013: htp.p(v_tablename||' ');
Line 1012: htp.p('');
1008: htp.p('
');
1009: htp.p(''
1010: ||uiutil.el_image('FK')
1011: ||' ');
1012: htp.p(' ');
1013: htp.p(v_tablename||' ');
1014:
1015: v_first2 := TRUE;
1016: htp.p('');
Line 1013: htp.p(v_tablename||' ');
1009: htp.p('
'
1010: ||uiutil.el_image('FK')
1011: ||' ');
1012: htp.p('');
1013: htp.p(v_tablename||' ');
1014:
1015: v_first2 := TRUE;
1016: htp.p('');
1017: for key_col in cur_fk_columns(n_appid => key_rec.application_id
Line 1016: htp.p('');
1012: htp.p('
');
1013: htp.p(v_tablename||' ');
1014:
1015: v_first2 := TRUE;
1016: htp.p(' ');
1017: for key_col in cur_fk_columns(n_appid => key_rec.application_id
1018: , n_tabid => key_rec.table_id
1019: , n_keyid => key_rec.foreign_key_id) loop
1020: if v_first2 = TRUE
Line 1023: htp.p('
');
1019: , n_keyid => key_rec.foreign_key_id) loop
1020: if v_first2 = TRUE
1021: then v_first2 := FALSE;
1022: else
1023: htp.p('
');
1024: end if;
1025:
1026: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)
1027: ||'.'
Line 1026: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)
1022: else
1023: htp.p('
');
1024: end if;
1025:
1026: htp.p(get_tablename(key_rec.application_id, key_rec.table_id)
1027: ||'.'
1028: ||key_col.column_name
1029: ||' ');
1030: end loop;
Line 1031: htp.p(' ');
1027: ||'.'
1028: ||key_col.column_name
1029: ||' ');
1030: end loop;
1031: htp.p('
');
1032:
1033: end loop;
1034:
1035: if v_first
Line 1038: htp.p('
');
1034:
1035: if v_first
1036: then null;
1037: else
1038: htp.p('
');
1039: end if;
1040:
1041: --
1042:
Line 1046: htp.p(''
1042:
1043: /*
1044:
1045: for ind_rec in cur_index(n_appid, n_tabid) loop
1046: htp.p(''
1047: ||ind_rec.uniqueness
1048: ||' Index: '
1049: ||ind_rec.index_name
1050: ||'');
Line 1056: htp.p('');
1052: v_first := TRUE;
1053:
1054: for ind_col_rec in cur_index_col(n_appid, n_tabid, ind_rec.index_id) loop
1055: IF v_first Then
1056: htp.p('');
1057: v_first := FALSE;
1058: end if;
1059: htp.p('
'
1060: ||uiutil.el_image('COL')
Line 1059: htp.p(' '
1055: IF v_first Then
1056: htp.p('
');
1057: v_first := FALSE;
1058: end if;
1059: htp.p(''
1060: ||uiutil.el_image('COL')
1061: ||ind_col_rec.column_name
1062: ||' ');
1063: end loop;
Line 1066: htp.p(' '||ind_rec.index_name|| ' has no columns
');
1062: ||'');
1063: end loop;
1064:
1065: IF v_first Then
1066: htp.p('
'||ind_rec.index_name|| ' has no columns
');
1067: else
1068: htp.p('');
1069: v_first := TRUE;
1070: end if;
Line 1068: htp.p('');
1064:
1065: IF v_first Then
1066: htp.p('
'||ind_rec.index_name|| ' has no columns
');
1067: else
1068: htp.p('');
1069: v_first := TRUE;
1070: end if;
1071:
1072: end loop;
Line 1079: htp.p(' Columns ');
1075: v_first := TRUE;
1076: for col_rec in cur_columns(n_tabid, n_appid) loop
1077: IF v_first Then
1078:
1079: htp.p(' Columns ');
1080: htp.p('
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('Name ');
Line 1080: htp.p('
1076: for col_rec in cur_columns(n_tabid, n_appid) loop
1077: IF v_first Then
1078:
1079: htp.p('
Columns ');
1080: htp.p('
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('Name ');
1084: htp.p(' Datatype ');
Line 1082: htp.p('');
1078:
1079: htp.p('
Columns ');
1080: htp.p('
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('Name ');
1084: htp.p(' Datatype ');
1085: htp.p('Length ');
1086: htp.p('Prcn ');
Line 1083: htp.p('Name ');
1079: htp.p('
Columns ');
1080: htp.p('
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p(' Name ');
1084: htp.p(' Datatype ');
1085: htp.p('Length ');
1086: htp.p('Prcn ');
1087: htp.p('Null ');
Line 1084: htp.p(' Datatype ');
1080: htp.p('
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('Name ');
1084: htp.p(' Datatype ');
1085: htp.p('Length ');
1086: htp.p('Prcn ');
1087: htp.p('Null ');
1088: htp.p('Description ');
Line 1085: htp.p('Length ');
1081: summary="Column details for this table">');
1082: htp.p('
');
1083: htp.p('Name ');
1084: htp.p(' Datatype ');
1085: htp.p(' Length ');
1086: htp.p('Prcn ');
1087: htp.p('Null ');
1088: htp.p('Description ');
1089: v_first := FALSE;
Line 1086: htp.p('Prcn ');
1082: htp.p('
');
1083: htp.p('Name ');
1084: htp.p(' Datatype ');
1085: htp.p('Length ');
1086: htp.p(' Prcn ');
1087: htp.p('Null ');
1088: htp.p('Description ');
1089: v_first := FALSE;
1090: end if;
Line 1087: htp.p('Null ');
1083: htp.p('
Name ');
1084: htp.p(' Datatype ');
1085: htp.p('Length ');
1086: htp.p('Prcn ');
1087: htp.p(' Null ');
1088: htp.p('Description ');
1089: v_first := FALSE;
1090: end if;
1091:
Line 1088: htp.p('Description ');
1084: htp.p('
Datatype ');
1085: htp.p('Length ');
1086: htp.p('Prcn ');
1087: htp.p('Null ');
1088: htp.p(' Description ');
1089: v_first := FALSE;
1090: end if;
1091:
1092: htp.prn(' ');
Line 1092: htp.prn(' ');
1088: htp.p('
Description ');
1089: v_first := FALSE;
1090: end if;
1091:
1092: htp.prn(' ');
1093: htp.prn(col_rec.column_name);
1094: htp.p(' ');
1095: htp.prn('');
1096: htp.prn(col_rec.data_type);
Line 1093: htp.prn(col_rec.column_name);
1089: v_first := FALSE;
1090: end if;
1091:
1092: htp.prn('
');
1093: htp.prn(col_rec.column_name);
1094: htp.p(' ');
1095: htp.prn('');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
Line 1094: htp.p('');
1090: end if;
1091:
1092: htp.prn('
');
1093: htp.prn(col_rec.column_name);
1094: htp.p(' ');
1095: htp.prn('');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
1098: htp.prn('');
Line 1095: htp.prn('');
1091:
1092: htp.prn('
');
1093: htp.prn(col_rec.column_name);
1094: htp.p(' ');
1095: htp.prn(' ');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
1098: htp.prn('');
1099: htp.prn(col_rec.data_length);
Line 1096: htp.prn(col_rec.data_type);
1092: htp.prn('
');
1093: htp.prn(col_rec.column_name);
1094: htp.p(' ');
1095: htp.prn('');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
1098: htp.prn('');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
Line 1097: htp.p('');
1093: htp.prn(col_rec.column_name);
1094: htp.p('');
1095: htp.prn('
');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
1098: htp.prn('');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
1101: htp.prn('');
Line 1098: htp.prn('');
1094: htp.p('
');
1095: htp.prn('');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
1098: htp.prn(' ');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
1101: htp.prn('');
1102: htp.prn(col_rec.data_precision);
Line 1099: htp.prn(col_rec.data_length);
1095: htp.prn('
');
1096: htp.prn(col_rec.data_type);
1097: htp.p(' ');
1098: htp.prn('');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
1101: htp.prn('');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
Line 1100: htp.p(' ');
1096: htp.prn(col_rec.data_type);
1097: htp.p('');
1098: htp.prn('
');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
1101: htp.prn('');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
1104: htp.prn('');
Line 1101: htp.prn('');
1097: htp.p('
');
1098: htp.prn('');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
1101: htp.prn(' ');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
1104: htp.prn('');
1105: htp.prn(col_rec.nullable);
Line 1102: htp.prn(col_rec.data_precision);
1098: htp.prn('
');
1099: htp.prn(col_rec.data_length);
1100: htp.p(' ');
1101: htp.prn('');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
1104: htp.prn('');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
Line 1103: htp.p(' ');
1099: htp.prn(col_rec.data_length);
1100: htp.p('
');
1101: htp.prn('');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
1104: htp.prn('');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
1107: htp.prn(col_rec.description);
Line 1104: htp.prn('');
1100: htp.p('
');
1101: htp.prn('');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
1104: htp.prn(' ');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
1107: htp.prn(col_rec.description);
1108: htp.p(' ');
Line 1105: htp.prn(col_rec.nullable);
1101: htp.prn('
');
1102: htp.prn(col_rec.data_precision);
1103: htp.p(' ');
1104: htp.prn('');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
1107: htp.prn(col_rec.description);
1108: htp.p(' ');
1109: end loop;
Line 1106: htp.prn('');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('
');
1104: htp.prn('');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
1107: htp.prn(col_rec.description);
1108: htp.p(' ');
1109: end loop;
1110: if v_first then
Line 1107: htp.prn(col_rec.description);
1103: htp.p('');
1104: htp.prn('
');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
1107: htp.prn(col_rec.description);
1108: htp.p(' ');
1109: end loop;
1110: if v_first then
1111: null;
Line 1108: htp.p('');
1104: htp.prn('
');
1105: htp.prn(col_rec.nullable);
1106: htp.prn(' ');
1107: htp.prn(col_rec.description);
1108: htp.p(' ');
1109: end loop;
1110: if v_first then
1111: null;
1112: else
Line 1113: htp.p('
');
1109: end loop;
1110: if v_first then
1111: null;
1112: else
1113: htp.p('
');
1114: end if;
1115: */
1116: --
1117: EXCEPTION
Line 1168: htp.p('View: '||tab_rec.view_name ||' ');
1164: --
1165:
1166: v_first := TRUE;
1167: FOR tab_rec IN cur_view_dets(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
1168: htp.p('View: '||tab_rec.view_name ||' ');
1169: v_tablename := tab_rec.view_name;
1170: htp.p('
1171: summary="location information">');
1172:
Line 1170: htp.p('
1166: v_first := TRUE;
1167: FOR tab_rec IN cur_view_dets(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
1168: htp.p('
View: '||tab_rec.view_name ||' ');
1169: v_tablename := tab_rec.view_name;
1170: htp.p('
1171: summary="location information">');
1172:
1173: htp.p('Product: '
1174: || get_appname(n_appid)||' ');
Line 1173: htp.p('Product: '
1169: v_tablename := tab_rec.view_name;
1170: htp.p('
1171: summary="location information">');
1172:
1173: htp.p('Product: '
1174: || get_appname(n_appid)||' ');
1175: htp.p('Description: '
1176: || tab_rec.description||' ');
1177: htp.p('Implementation/DBA Data: ');
Line 1175: htp.p('Description: '
1171: summary="location information">');
1172:
1173: htp.p('
Product: '
1174: || get_appname(n_appid)||' ');
1175: htp.p('Description: '
1176: || tab_rec.description||' ');
1177: htp.p('Implementation/DBA Data: ');
1178: etrm_pnav.prn_object_type(c_name => tab_rec.view_name
1179: , c_owner => '%'
Line 1177: htp.p('Implementation/DBA Data: ');
1173: htp.p('
Product: '
1174: || get_appname(n_appid)||' ');
1175: htp.p('Description: '
1176: || tab_rec.description||' ');
1177: htp.p('Implementation/DBA Data: ');
1178: etrm_pnav.prn_object_type(c_name => tab_rec.view_name
1179: , c_owner => '%'
1180: , c_type => 'VIEW'
1181: , c_status => '%');
Line 1182: htp.p(' ');
1178: etrm_pnav.prn_object_type(c_name => tab_rec.view_name
1179: , c_owner => '%'
1180: , c_type => 'VIEW'
1181: , c_status => '%');
1182: htp.p('
');
1183: htp.p('
');
1184:
1185: v_viewtext := upper(tab_rec.text);
1186: v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
Line 1183: htp.p('
');
1179: , c_owner => '%'
1180: , c_type => 'VIEW'
1181: , c_status => '%');
1182: htp.p('');
1183: htp.p('
');
1184:
1185: v_viewtext := upper(tab_rec.text);
1186: v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
1187: v_viewtext := replace(v_viewtext, ' FROM ', '
FROM ');
Line 1192: htp.p('View Text ');
1188: v_viewtext := replace(v_viewtext , ' WHERE ', '
WHERE ');
1189: v_viewtext := replace(v_viewtext , ',', '
, ');
1190: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
1191:
1192: htp.p('View Text ');
1193: htp.p('
');
1194: htp.p(v_viewtext);
1195: htp.p('
');
1196: end loop;
Line 1193: htp.p(' ');
1189: v_viewtext := replace(v_viewtext , ',', '
, ');
1190: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
1191:
1192: htp.p('
View Text ');
1193: htp.p(' ');
1194: htp.p(v_viewtext);
1195: htp.p('
');
1196: end loop;
1197: --
Line 1194: htp.p(v_viewtext);
1190: v_viewtext := replace(v_viewtext , ' AND ', '
AND ');
1191:
1192: htp.p('
View Text ');
1193: htp.p('');
1194: htp.p(v_viewtext);
1195: htp.p('
');
1196: end loop;
1197: --
1198:
Line 1195: htp.p('');
1191:
1192: htp.p('
View Text ');
1193: htp.p('');
1194: htp.p(v_viewtext);
1195: htp.p('
');
1196: end loop;
1197: --
1198:
1199: v_first := TRUE;
Line 1203: htp.p(' Columns ');
1199: v_first := TRUE;
1200: for col_rec in cur_columns(n_tabid, n_appid) loop
1201: IF v_first Then
1202:
1203: htp.p(' Columns ');
1204: htp.p('
1205: summary="Column details for this table">');
1206: htp.p('');
1207: htp.p('Name ');
Line 1204: htp.p('
1200: for col_rec in cur_columns(n_tabid, n_appid) loop
1201: IF v_first Then
1202:
1203: htp.p('
Columns ');
1204: htp.p('
1205: summary="Column details for this table">');
1206: htp.p('');
1207: htp.p('Name ');
1208:
Line 1206: htp.p('');
1202:
1203: htp.p('
Columns ');
1204: htp.p('
1205: summary="Column details for this table">');
1206: htp.p('');
1207: htp.p('Name ');
1208:
1209: v_first := FALSE;
1210: end if;
Line 1207: htp.p('Name ');
1203: htp.p('
Columns ');
1204: htp.p('
1205: summary="Column details for this table">');
1206: htp.p('');
1207: htp.p(' Name ');
1208:
1209: v_first := FALSE;
1210: end if;
1211:
Line 1212: htp.prn(' ');
1208:
1209: v_first := FALSE;
1210: end if;
1211:
1212: htp.prn(' ');
1213: htp.prn(col_rec.column_name);
1214: htp.p(' ');
1215: htp.p(' ');
1216: end loop;
Line 1213: htp.prn(col_rec.column_name);
1209: v_first := FALSE;
1210: end if;
1211:
1212: htp.prn('
');
1213: htp.prn(col_rec.column_name);
1214: htp.p(' ');
1215: htp.p(' ');
1216: end loop;
1217:
Line 1214: htp.p('');
1210: end if;
1211:
1212: htp.prn('
');
1213: htp.prn(col_rec.column_name);
1214: htp.p(' ');
1215: htp.p(' ');
1216: end loop;
1217:
1218: --
Line 1215: htp.p('');
1211:
1212: htp.prn('
');
1213: htp.prn(col_rec.column_name);
1214: htp.p(' ');
1215: htp.p(' ');
1216: end loop;
1217:
1218: --
1219: EXCEPTION
Line 1298: htp.p('Concurrent Program: '||c_rec.name ||' ');
1294:
1295:
1296:
1297: FOR c_rec IN cur_concurrent(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
1298: htp.p('Concurrent Program: '||c_rec.name ||' ');
1299:
1300: htp.p('
1301: summary="location information">');
1302:
Line 1300: htp.p('
1296:
1297: FOR c_rec IN cur_concurrent(n_appid=>n_appid, n_tabid=>n_tabid) LOOP
1298: htp.p('
Concurrent Program: '||c_rec.name ||' ');
1299:
1300: htp.p('
1301: summary="location information">');
1302:
1303: htp.p('Product: '
1304: || get_appname(n_appid)||' ');
Line 1303: htp.p('Product: '
1299:
1300: htp.p('
1301: summary="location information">');
1302:
1303: htp.p('Product: '
1304: || get_appname(n_appid)||' ');
1305:
1306: htp.p('User Name: '
1307: || c_rec.long_name||' ');
Line 1306: htp.p('User Name: '
1302:
1303: htp.p('
Product: '
1304: || get_appname(n_appid)||' ');
1305:
1306: htp.p('User Name: '
1307: || c_rec.long_name||' ');
1308:
1309: htp.p('Description: '
1310: || c_rec.description||' ');
Line 1309: htp.p('Description: '
1305:
1306: htp.p('
User Name: '
1307: || c_rec.long_name||' ');
1308:
1309: htp.p('Description: '
1310: || c_rec.description||' ');
1311:
1312: htp.p('Enabled: '
1313: || get_lookup_meaning(c_lookup_type => 'YES_NO'
Line 1312: htp.p('Enabled: '
1308:
1309: htp.p('
Description: '
1310: || c_rec.description||' ');
1311:
1312: htp.p('Enabled: '
1313: || get_lookup_meaning(c_lookup_type => 'YES_NO'
1314: , c_lookup_code =>c_rec.enabled_flag)
1315: ||' ');
1316:
Line 1317: htp.p('Execution Method: '
1313: || get_lookup_meaning(c_lookup_type => 'YES_NO'
1314: , c_lookup_code =>c_rec.enabled_flag)
1315: ||'
');
1316:
1317: htp.p('Execution Method: '
1318: || get_lookup_meaning(c_lookup_type => 'CP_EXECUTION_METHOD_CODE'
1319: , c_lookup_code =>c_rec.execution_method_code)
1320: ||' ');
1321:
Line 1322: htp.p('Argument Method: '
1318: || get_lookup_meaning(c_lookup_type => 'CP_EXECUTION_METHOD_CODE'
1319: , c_lookup_code =>c_rec.execution_method_code)
1320: ||'
');
1321:
1322: htp.p('Argument Method: '
1323: || get_lookup_meaning(c_lookup_type => 'CP_ARGUMENT_METHOD_CODE'
1324: , c_lookup_code =>c_rec.argument_method_code)
1325: ||' ');
1326: htp.p('
');
Line 1326: htp.p('
');
1322: htp.p('
Argument Method: '
1323: || get_lookup_meaning(c_lookup_type => 'CP_ARGUMENT_METHOD_CODE'
1324: , c_lookup_code =>c_rec.argument_method_code)
1325: ||' ');
1326: htp.p('
');
1327: END LOOP;
1328:
1329:
1330: for e_rec in cur_executable(n_appid=>n_appid, n_tabid=>n_tabid) loop
Line 1331: htp.p('Executable: '||e_rec.name ||' ');
1327: END LOOP;
1328:
1329:
1330: for e_rec in cur_executable(n_appid=>n_appid, n_tabid=>n_tabid) loop
1331: htp.p('Executable: '||e_rec.name ||' ');
1332: htp.p('
1333: summary="location information">');
1334:
1335: htp.p('User Name: '
Line 1332: htp.p('
1328:
1329:
1330: for e_rec in cur_executable(n_appid=>n_appid, n_tabid=>n_tabid) loop
1331: htp.p('
Executable: '||e_rec.name ||' ');
1332: htp.p('
1333: summary="location information">');
1334:
1335: htp.p('User Name: '
1336: || e_rec.user_executable_name||' ');
Line 1335: htp.p('User Name: '
1331: htp.p('
Executable: '||e_rec.name ||' ');
1332: htp.p('
1333: summary="location information">');
1334:
1335: htp.p('User Name: '
1336: || e_rec.user_executable_name||' ');
1337:
1338: htp.p('Description: '
1339: || e_rec.description||' ');
Line 1338: htp.p('Description: '
1334:
1335: htp.p('
User Name: '
1336: || e_rec.user_executable_name||' ');
1337:
1338: htp.p('Description: '
1339: || e_rec.description||' ');
1340:
1341: htp.p('Execution Filename: '
1342: || e_rec.execution_file_name||' ');
Line 1341: htp.p('Execution Filename: '
1337:
1338: htp.p('
Description: '
1339: || e_rec.description||' ');
1340:
1341: htp.p('Execution Filename: '
1342: || e_rec.execution_file_name||' ');
1343:
1344: htp.p('Subroutine Name: '
1345: || e_rec.subroutine_name||' ');
Line 1344: htp.p('Subroutine Name: '
1340:
1341: htp.p('
Execution Filename: '
1342: || e_rec.execution_file_name||' ');
1343:
1344: htp.p('Subroutine Name: '
1345: || e_rec.subroutine_name||' ');
1346:
1347: htp.p('
');
1348:
Line 1347: htp.p('
');
1343:
1344: htp.p('
Subroutine Name: '
1345: || e_rec.subroutine_name||' ');
1346:
1347: htp.p('
');
1348:
1349: end loop;
1350:
1351:
Line 1356: htp.p('Request Set Arguments ');
1352: v_first := TRUE;
1353: for a_rec in cur_args(n_progid => n_tabid, n_appid => n_appid) loop
1354: IF v_first Then
1355:
1356: htp.p('Request Set Arguments ');
1357: htp.p('
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('Name ');
Line 1357: htp.p('
1353: for a_rec in cur_args(n_progid => n_tabid, n_appid => n_appid) loop
1354: IF v_first Then
1355:
1356: htp.p('
Request Set Arguments ');
1357: htp.p('
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('Name ');
1361: htp.p(' Descriptive Flex ');
Line 1359: htp.p('');
1355:
1356: htp.p('
Request Set Arguments ');
1357: htp.p('
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('Name ');
1361: htp.p(' Descriptive Flex ');
1362: htp.p('Display ');
1363: htp.p('Insert ');
Line 1360: htp.p('Name ');
1356: htp.p('
Request Set Arguments ');
1357: htp.p('
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p(' Name ');
1361: htp.p(' Descriptive Flex ');
1362: htp.p('Display ');
1363: htp.p('Insert ');
1364: htp.p('Update ');
Line 1361: htp.p(' Descriptive Flex ');
1357: htp.p('
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('Name ');
1361: htp.p(' Descriptive Flex ');
1362: htp.p('Display ');
1363: htp.p('Insert ');
1364: htp.p('Update ');
1365: htp.p('Default Type ');
Line 1362: htp.p('Display ');
1358: summary="Concurrent program arguments">');
1359: htp.p('
');
1360: htp.p('Name ');
1361: htp.p(' Descriptive Flex ');
1362: htp.p(' Display ');
1363: htp.p('Insert ');
1364: htp.p('Update ');
1365: htp.p('Default Type ');
1366: htp.p('Default Value ');
Line 1363: htp.p('Insert ');
1359: htp.p('
');
1360: htp.p('Name ');
1361: htp.p(' Descriptive Flex ');
1362: htp.p('Display ');
1363: htp.p(' Insert ');
1364: htp.p('Update ');
1365: htp.p('Default Type ');
1366: htp.p('Default Value ');
1367: htp.p('Shared Name ');
Line 1364: htp.p('Update ');
1360: htp.p('
Name ');
1361: htp.p(' Descriptive Flex ');
1362: htp.p('Display ');
1363: htp.p('Insert ');
1364: htp.p(' Update ');
1365: htp.p('Default Type ');
1366: htp.p('Default Value ');
1367: htp.p('Shared Name ');
1368: v_first := FALSE;
Line 1365: htp.p('Default Type ');
1361: htp.p('
Descriptive Flex ');
1362: htp.p('Display ');
1363: htp.p('Insert ');
1364: htp.p('Update ');
1365: htp.p(' Default Type ');
1366: htp.p('Default Value ');
1367: htp.p('Shared Name ');
1368: v_first := FALSE;
1369: end if;
Line 1366: htp.p('Default Value ');
1362: htp.p('
Display ');
1363: htp.p('Insert ');
1364: htp.p('Update ');
1365: htp.p('Default Type ');
1366: htp.p(' Default Value ');
1367: htp.p('Shared Name ');
1368: v_first := FALSE;
1369: end if;
1370:
Line 1367: htp.p('Shared Name ');
1363: htp.p('
Insert ');
1364: htp.p('Update ');
1365: htp.p('Default Type ');
1366: htp.p('Default Value ');
1367: htp.p(' Shared Name ');
1368: v_first := FALSE;
1369: end if;
1370:
1371: htp.prn(' ');
Line 1371: htp.prn(' ');
1367: htp.p('
Shared Name ');
1368: v_first := FALSE;
1369: end if;
1370:
1371: htp.prn(' ');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p(' ');
1374: htp.prn('');
1375: htp.prn(a_rec.descriptive_flexfield_name);
Line 1372: htp.prn(a_rec.application_column_name);
1368: v_first := FALSE;
1369: end if;
1370:
1371: htp.prn('
');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p(' ');
1374: htp.prn('');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
Line 1373: htp.p('');
1369: end if;
1370:
1371: htp.prn('
');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p(' ');
1374: htp.prn('');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
1377: htp.prn('');
Line 1374: htp.prn('');
1370:
1371: htp.prn('
');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p(' ');
1374: htp.prn(' ');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
1377: htp.prn('');
1378: htp.prn(a_rec.display_flag);
Line 1375: htp.prn(a_rec.descriptive_flexfield_name);
1371: htp.prn('
');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p(' ');
1374: htp.prn('');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
1377: htp.prn('');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
Line 1376: htp.p('');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p('');
1374: htp.prn('
');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
1377: htp.prn('');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
1380: htp.prn('');
Line 1377: htp.prn('');
1373: htp.p('
');
1374: htp.prn('');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
1377: htp.prn(' ');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
1380: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
Line 1378: htp.prn(a_rec.display_flag);
1374: htp.prn('
');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p(' ');
1377: htp.prn('');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
1380: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
Line 1379: htp.p(' ');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('');
1377: htp.prn('
');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
1380: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
1383: htp.prn('');
Line 1380: htp.prn('');
1376: htp.p('
');
1377: htp.prn('');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
1380: htp.prn(' ');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
1383: htp.prn('');
1384: htp.prn(a_rec.update_flag);
Line 1381: htp.prn(a_rec.insert_flag);
1377: htp.prn('
');
1378: htp.prn(a_rec.display_flag);
1379: htp.p(' ');
1380: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
1383: htp.prn('');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
Line 1382: htp.p(' ');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('
');
1380: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
1383: htp.prn('');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
1386: htp.prn(a_rec.default_type);
Line 1383: htp.prn('');
1379: htp.p('
');
1380: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
1383: htp.prn(' ');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
Line 1384: htp.prn(a_rec.update_flag);
1380: htp.prn('
');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p(' ');
1383: htp.prn('');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
1388: htp.prn(a_rec.default_value);
Line 1385: htp.prn('');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('
');
1383: htp.prn('');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
Line 1386: htp.prn(a_rec.default_type);
1382: htp.p('
');
1383: htp.prn('');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
1390: htp.prn(a_rec.shared_parameter_name);
Line 1387: htp.prn('');
1383: htp.prn('
');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn(' ');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
1390: htp.prn(a_rec.shared_parameter_name);
1391: htp.p(' ');
Line 1388: htp.prn(a_rec.default_value);
1384: htp.prn(a_rec.update_flag);
1385: htp.prn('
');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
1390: htp.prn(a_rec.shared_parameter_name);
1391: htp.p(' ');
1392: end loop;
Line 1389: htp.prn('');
1385: htp.prn('
');
1386: htp.prn(a_rec.default_type);
1387: htp.prn(' ');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
1390: htp.prn(a_rec.shared_parameter_name);
1391: htp.p(' ');
1392: end loop;
1393: if v_first then
Line 1390: htp.prn(a_rec.shared_parameter_name);
1386: htp.prn(a_rec.default_type);
1387: htp.prn('
');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
1390: htp.prn(a_rec.shared_parameter_name);
1391: htp.p(' ');
1392: end loop;
1393: if v_first then
1394: null;
Line 1391: htp.p('');
1387: htp.prn('
');
1388: htp.prn(a_rec.default_value);
1389: htp.prn(' ');
1390: htp.prn(a_rec.shared_parameter_name);
1391: htp.p(' ');
1392: end loop;
1393: if v_first then
1394: null;
1395: else
Line 1396: htp.p('
');
1392: end loop;
1393: if v_first then
1394: null;
1395: else
1396: htp.p('
');
1397: end if;
1398:
1399:
1400:
Line 1438: htp.p('Lookup Type: '|| FND_CSS_PKG.Encode(c_lookup_type) ||' ');
1434: v_first boolean;
1435:
1436: begin
1437:
1438: htp.p('Lookup Type: '|| FND_CSS_PKG.Encode(c_lookup_type) ||' ');
1439: FOR c_rec IN cur_lookup_tl(n_appid=>n_appid, c_lookup_type => c_lookup_type) LOOP
1440:
1441:
1442: htp.p('
Line 1442: htp.p('
1438: htp.p('
Lookup Type: '|| FND_CSS_PKG.Encode(c_lookup_type) ||' ');
1439: FOR c_rec IN cur_lookup_tl(n_appid=>n_appid, c_lookup_type => c_lookup_type) LOOP
1440:
1441:
1442: htp.p('
1443: summary="location information">');
1444:
1445: htp.p('Product: '
1446: || get_appname(n_appid)||' ');
Line 1445: htp.p('Product: '
1441:
1442: htp.p('
1443: summary="location information">');
1444:
1445: htp.p('Product: '
1446: || get_appname(n_appid)||' ');
1447:
1448: htp.p('Meaning: '
1449: || c_rec.meaning||' ');
Line 1448: htp.p('Meaning: '
1444:
1445: htp.p('
Product: '
1446: || get_appname(n_appid)||' ');
1447:
1448: htp.p('Meaning: '
1449: || c_rec.meaning||' ');
1450:
1451: htp.p('Description: '
1452: || c_rec.description||' ');
Line 1451: htp.p('Description: '
1447:
1448: htp.p('
Meaning: '
1449: || c_rec.meaning||' ');
1450:
1451: htp.p('Description: '
1452: || c_rec.description||' ');
1453: htp.p('
');
1454: END LOOP;
1455: v_first := TRUE;
Line 1453: htp.p('
');
1449: || c_rec.meaning||'');
1450:
1451: htp.p('
Description: '
1452: || c_rec.description||' ');
1453: htp.p('
');
1454: END LOOP;
1455: v_first := TRUE;
1456: for v_rec in cur_lookup_values(n_appid => n_appid
1457: , c_lookup_type => c_lookup_type) loop
Line 1460: htp.p('Quick Codes ');
1456: for v_rec in cur_lookup_values(n_appid => n_appid
1457: , c_lookup_type => c_lookup_type) loop
1458: IF v_first Then
1459:
1460: htp.p('Quick Codes ');
1461: htp.p('
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('Code ');
Line 1461: htp.p('
1457: , c_lookup_type => c_lookup_type) loop
1458: IF v_first Then
1459:
1460: htp.p('
Quick Codes ');
1461: htp.p('
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('Code ');
1465: htp.p('Meaning ');
Line 1463: htp.p('');
1459:
1460: htp.p('
Quick Codes ');
1461: htp.p('
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('Code ');
1465: htp.p('Meaning ');
1466: htp.p('Description ');
1467: v_first := FALSE;
Line 1464: htp.p('Code ');
1460: htp.p('
Quick Codes ');
1461: htp.p('
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p(' Code ');
1465: htp.p('Meaning ');
1466: htp.p('Description ');
1467: v_first := FALSE;
1468: end if;
Line 1465: htp.p('Meaning ');
1461: htp.p('
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('Code ');
1465: htp.p(' Meaning ');
1466: htp.p('Description ');
1467: v_first := FALSE;
1468: end if;
1469:
Line 1466: htp.p('Description ');
1462: summary="Quick Code details">');
1463: htp.p('
');
1464: htp.p('Code ');
1465: htp.p('Meaning ');
1466: htp.p(' Description ');
1467: v_first := FALSE;
1468: end if;
1469:
1470: htp.prn(' ');
Line 1470: htp.prn(' ');
1466: htp.p('
Description ');
1467: v_first := FALSE;
1468: end if;
1469:
1470: htp.prn(' ');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p(' ');
1473: htp.prn('');
1474: htp.prn(v_rec.meaning);
Line 1471: htp.prn(v_rec.lookup_code);
1467: v_first := FALSE;
1468: end if;
1469:
1470: htp.prn('
');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p(' ');
1473: htp.prn('');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
Line 1472: htp.p('');
1468: end if;
1469:
1470: htp.prn('
');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p(' ');
1473: htp.prn('');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
1476: htp.prn('');
Line 1473: htp.prn('');
1469:
1470: htp.prn('
');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p(' ');
1473: htp.prn(' ');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
1476: htp.prn('');
1477: htp.prn(v_rec.description);
Line 1474: htp.prn(v_rec.meaning);
1470: htp.prn('
');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p(' ');
1473: htp.prn('');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
1476: htp.prn('');
1477: htp.prn(v_rec.description);
1478: htp.p(' ');
Line 1475: htp.p(' ');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p('');
1473: htp.prn('
');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
1476: htp.prn('');
1477: htp.prn(v_rec.description);
1478: htp.p(' ');
1479: end loop;
Line 1476: htp.prn('');
1472: htp.p('
');
1473: htp.prn('');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
1476: htp.prn(' ');
1477: htp.prn(v_rec.description);
1478: htp.p(' ');
1479: end loop;
1480: if v_first then
Line 1477: htp.prn(v_rec.description);
1473: htp.prn('
');
1474: htp.prn(v_rec.meaning);
1475: htp.p(' ');
1476: htp.prn('');
1477: htp.prn(v_rec.description);
1478: htp.p(' ');
1479: end loop;
1480: if v_first then
1481: null;
Line 1478: htp.p('');
1474: htp.prn(v_rec.meaning);
1475: htp.p('');
1476: htp.prn('
');
1477: htp.prn(v_rec.description);
1478: htp.p(' ');
1479: end loop;
1480: if v_first then
1481: null;
1482: else
Line 1483: htp.p('
');
1479: end loop;
1480: if v_first then
1481: null;
1482: else
1483: htp.p('
');
1484: end if;
1485:
1486: end ls_lookup;
1487:
Line 1514: htp.p('Event: '||e_rec.name ||' ');
1510: v_first boolean := true;
1511:
1512: begin
1513: for e_rec in cur_event(c_guid) loop
1514: htp.p('Event: '||e_rec.name ||' ');
1515:
1516: htp.p('
1517: summary="Workflow Event information">');
1518:
Line 1516: htp.p('
1512: begin
1513: for e_rec in cur_event(c_guid) loop
1514: htp.p('
Event: '||e_rec.name ||' ');
1515:
1516: htp.p('
1517: summary="Workflow Event information">');
1518:
1519: htp.p('Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||' ');
Line 1519: htp.p('Product: '
1515:
1516: htp.p('
1517: summary="Workflow Event information">');
1518:
1519: htp.p('Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||' ');
1521: htp.p('Type: '
1522: || e_rec.type||' ');
1523: htp.p('Status: '
Line 1521: htp.p('Type: '
1517: summary="Workflow Event information">');
1518:
1519: htp.p('
Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||' ');
1521: htp.p('Type: '
1522: || e_rec.type||' ');
1523: htp.p('Status: '
1524: || e_rec.status||' ');
1525: htp.p('Generate Function: '
Line 1523: htp.p('Status: '
1519: htp.p('
Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||' ');
1521: htp.p('Type: '
1522: || e_rec.type||' ');
1523: htp.p('Status: '
1524: || e_rec.status||' ');
1525: htp.p('Generate Function: '
1526: || e_rec.generate_function||' ');
1527: htp.p('
');
Line 1525: htp.p('Generate Function: '
1521: htp.p('
Type: '
1522: || e_rec.type||' ');
1523: htp.p('Status: '
1524: || e_rec.status||' ');
1525: htp.p('Generate Function: '
1526: || e_rec.generate_function||' ');
1527: htp.p('
');
1528:
1529: end loop;
Line 1527: htp.p('
');
1523: htp.p('
Status: '
1524: || e_rec.status||' ');
1525: htp.p('Generate Function: '
1526: || e_rec.generate_function||' ');
1527: htp.p('
');
1528:
1529: end loop;
1530:
1531:
Line 1535: htp.p('Subscriptions: ');
1531:
1532: for s_rec in cur_subscriptions(c_guid) loop
1533: IF v_first Then
1534:
1535: htp.p('Subscriptions: ');
1536: htp.p('
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('Source Type ');
Line 1536: htp.p('
1532: for s_rec in cur_subscriptions(c_guid) loop
1533: IF v_first Then
1534:
1535: htp.p('
Subscriptions: ');
1536: htp.p('
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('Source Type ');
1540: htp.p('Rule Function ');
Line 1538: htp.p('');
1534:
1535: htp.p('
Subscriptions: ');
1536: htp.p('
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('Source Type ');
1540: htp.p('Rule Function ');
1541: htp.p('WF Process Type ');
1542: htp.p('WF Process Name ');
Line 1539: htp.p('Source Type ');
1535: htp.p('
Subscriptions: ');
1536: htp.p('
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p(' Source Type ');
1540: htp.p('Rule Function ');
1541: htp.p('WF Process Type ');
1542: htp.p('WF Process Name ');
1543: htp.p('Description ');
Line 1540: htp.p('Rule Function ');
1536: htp.p('
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('Source Type ');
1540: htp.p(' Rule Function ');
1541: htp.p('WF Process Type ');
1542: htp.p('WF Process Name ');
1543: htp.p('Description ');
1544: v_first := FALSE;
Line 1541: htp.p('WF Process Type ');
1537: summary="Subscription details">');
1538: htp.p('
');
1539: htp.p('Source Type ');
1540: htp.p('Rule Function ');
1541: htp.p(' WF Process Type ');
1542: htp.p('WF Process Name ');
1543: htp.p('Description ');
1544: v_first := FALSE;
1545: end if;
Line 1542: htp.p('WF Process Name ');
1538: htp.p('
');
1539: htp.p('Source Type ');
1540: htp.p('Rule Function ');
1541: htp.p('WF Process Type ');
1542: htp.p(' WF Process Name ');
1543: htp.p('Description ');
1544: v_first := FALSE;
1545: end if;
1546:
Line 1543: htp.p('Description ');
1539: htp.p('
Source Type ');
1540: htp.p('Rule Function ');
1541: htp.p('WF Process Type ');
1542: htp.p('WF Process Name ');
1543: htp.p(' Description ');
1544: v_first := FALSE;
1545: end if;
1546:
1547: htp.prn(' ');
Line 1547: htp.prn(' ');
1543: htp.p('
Description ');
1544: v_first := FALSE;
1545: end if;
1546:
1547: htp.prn(' ');
1548: htp.prn(s_rec.source_type);
1549: htp.p(' ');
1550: htp.prn('');
1551: htp.prn(s_rec.rule_function);
Line 1548: htp.prn(s_rec.source_type);
1544: v_first := FALSE;
1545: end if;
1546:
1547: htp.prn('
');
1548: htp.prn(s_rec.source_type);
1549: htp.p(' ');
1550: htp.prn('');
1551: htp.prn(s_rec.rule_function);
1552: htp.p(' ');
Line 1549: htp.p('');
1545: end if;
1546:
1547: htp.prn('
');
1548: htp.prn(s_rec.source_type);
1549: htp.p(' ');
1550: htp.prn('');
1551: htp.prn(s_rec.rule_function);
1552: htp.p(' ');
1553:
Line 1550: htp.prn('');
1546:
1547: htp.prn('
');
1548: htp.prn(s_rec.source_type);
1549: htp.p(' ');
1550: htp.prn(' ');
1551: htp.prn(s_rec.rule_function);
1552: htp.p(' ');
1553:
1554: htp.prn('');
Line 1551: htp.prn(s_rec.rule_function);
1547: htp.prn('
');
1548: htp.prn(s_rec.source_type);
1549: htp.p(' ');
1550: htp.prn('');
1551: htp.prn(s_rec.rule_function);
1552: htp.p(' ');
1553:
1554: htp.prn('');
1555: htp.prn(s_rec.wf_process_type);
Line 1552: htp.p(' ');
1548: htp.prn(s_rec.source_type);
1549: htp.p('');
1550: htp.prn('
');
1551: htp.prn(s_rec.rule_function);
1552: htp.p(' ');
1553:
1554: htp.prn('');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p(' ');
Line 1554: htp.prn('');
1550: htp.prn('
');
1551: htp.prn(s_rec.rule_function);
1552: htp.p(' ');
1553:
1554: htp.prn(' ');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p(' ');
1557: htp.prn('');
1558: htp.prn(s_rec.wf_process_name);
Line 1555: htp.prn(s_rec.wf_process_type);
1551: htp.prn(s_rec.rule_function);
1552: htp.p('
');
1553:
1554: htp.prn('');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p(' ');
1557: htp.prn('');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p(' ');
Line 1556: htp.p('');
1552: htp.p('');
1553:
1554: htp.prn('
');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p(' ');
1557: htp.prn('');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p(' ');
1560:
Line 1557: htp.prn('');
1553:
1554: htp.prn('
');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p(' ');
1557: htp.prn(' ');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p(' ');
1560:
1561: htp.prn('');
Line 1558: htp.prn(s_rec.wf_process_name);
1554: htp.prn('
');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p(' ');
1557: htp.prn('');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p(' ');
1560:
1561: htp.prn('');
1562: htp.prn(s_rec.description);
Line 1559: htp.p(' ');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('');
1557: htp.prn('
');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p(' ');
1560:
1561: htp.prn('');
1562: htp.prn(s_rec.description);
1563: htp.p(' ');
Line 1561: htp.prn('');
1557: htp.prn('
');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p(' ');
1560:
1561: htp.prn(' ');
1562: htp.prn(s_rec.description);
1563: htp.p(' ');
1564: end loop;
1565: if v_first then
Line 1562: htp.prn(s_rec.description);
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('
');
1560:
1561: htp.prn('');
1562: htp.prn(s_rec.description);
1563: htp.p(' ');
1564: end loop;
1565: if v_first then
1566: null;
Line 1563: htp.p('');
1559: htp.p('');
1560:
1561: htp.prn('
');
1562: htp.prn(s_rec.description);
1563: htp.p(' ');
1564: end loop;
1565: if v_first then
1566: null;
1567: else
Line 1568: htp.p('
');
1564: end loop;
1565: if v_first then
1566: null;
1567: else
1568: htp.p('
');
1569: end if;
1570:
1571: end ls_event;
1572:
Line 1593: htp.p('File: '||c_rec.file_name ||' ');
1589:
1590:
1591: FOR c_rec IN cur_file(n_fileid=>n_fileid) LOOP
1592:
1593: htp.p('File: '||c_rec.file_name ||' ');
1594:
1595: htp.p('
1596: summary="location information">');
1597:
Line 1595: htp.p('
1591: FOR c_rec IN cur_file(n_fileid=>n_fileid) LOOP
1592:
1593: htp.p('
File: '||c_rec.file_name ||' ');
1594:
1595: htp.p('
1596: summary="location information">');
1597:
1598: htp.p('Product: '
1599: || get_appname(c_rec.application_id)
Line 1598: htp.p('Product: '
1594:
1595: htp.p('
1596: summary="location information">');
1597:
1598: htp.p('Product: '
1599: || get_appname(c_rec.application_id)
1600: ||' ');
1601:
1602: htp.p('File Type: '
Line 1602: htp.p('File Type: '
1598: htp.p('
Product: '
1599: || get_appname(c_rec.application_id)
1600: ||' ');
1601:
1602: htp.p('File Type: '
1603: || c_rec.file_type||' ');
1604:
1605: htp.p('Size: '
1606: || uiutil.byte_format(c_rec.file_length)
Line 1605: htp.p('Size: '
1601:
1602: htp.p('
File Type: '
1603: || c_rec.file_type||' ');
1604:
1605: htp.p('Size: '
1606: || uiutil.byte_format(c_rec.file_length)
1607: ||' ');
1608:
1609:
Line 1614: htp.p('Description: '
1610: if (c_rec.description is null
1611: or c_rec.description = c_rec.file_name)
1612: then null;
1613: else
1614: htp.p('Description: '
1615: || c_rec.description||' ');
1616: end if;
1617:
1618: htp.p('
');
Line 1618: htp.p('
');
1614: htp.p('
Description: '
1615: || c_rec.description||' ');
1616: end if;
1617:
1618: htp.p('
');
1619:
1620: END LOOP;
1621:
1622: htp.p('');
Line 1622: htp.p('');
1618: htp.p('
');
1619:
1620: END LOOP;
1621:
1622: htp.p('');
1623: htp.p('Action: ');
1624: htp.p('');
1625: uiutil.a_href_gen(c_type => 'FILE'
1626: , c_link => 'etrm_fndnav.show_file?n_file_id='
Line 1623: htp.p('Action: ');
1619:
1620: END LOOP;
1621:
1622: htp.p('
');
1623: htp.p('Action: ');
1624: htp.p('');
1625: uiutil.a_href_gen(c_type => 'FILE'
1626: , c_link => 'etrm_fndnav.show_file?n_file_id='
1627: ||n_fileid
Line 1624: htp.p('');
1620: END LOOP;
1621:
1622: htp.p('
');
1623: htp.p('Action: ');
1624: htp.p('');
1625: uiutil.a_href_gen(c_type => 'FILE'
1626: , c_link => 'etrm_fndnav.show_file?n_file_id='
1627: ||n_fileid
1628: ||'&c_mode=INLINE'
Line 1630: htp.p(' in current window');
1626: , c_link => 'etrm_fndnav.show_file?n_file_id='
1627: ||n_fileid
1628: ||'&c_mode=INLINE'
1629: , c_display => 'View file');
1630: htp.p(' in current window');
1631: htp.p('
');
1632: htp.p(' ');
1633:
1634:
Line 1631: htp.p(' ');
1627: ||n_fileid
1628: ||'&c_mode=INLINE'
1629: , c_display => 'View file');
1630: htp.p(' in current window');
1631: htp.p('');
1632: htp.p('');
1633:
1634:
1635: end ls_file;
Line 1632: htp.p('');
1628: ||'&c_mode=INLINE'
1629: , c_display => 'View file');
1630: htp.p(' in current window');
1631: htp.p('');
1632: htp.p('');
1633:
1634:
1635: end ls_file;
1636:
Line 1672: htp.p('Content-type: '||lob_rec.file_content_type);
1668:
1669: if upper(c_mode) = 'NOHEADER'
1670: then null;
1671: else
1672: htp.p('Content-type: '||lob_rec.file_content_type);
1673: htp.p('Content-Disposition: '|| v_disposition ||'; filename='||lob_rec.file_name);
1674: htp.p('Content-Transfer-Encoding: base64');
1675: htp.p('');
1676: end if;
Line 1673: htp.p('Content-Disposition: '|| v_disposition ||'; filename='||lob_rec.file_name);
1669: if upper(c_mode) = 'NOHEADER'
1670: then null;
1671: else
1672: htp.p('Content-type: '||lob_rec.file_content_type);
1673: htp.p('Content-Disposition: '|| v_disposition ||'; filename='||lob_rec.file_name);
1674: htp.p('Content-Transfer-Encoding: base64');
1675: htp.p('');
1676: end if;
1677:
Line 1674: htp.p('Content-Transfer-Encoding: base64');
1670: then null;
1671: else
1672: htp.p('Content-type: '||lob_rec.file_content_type);
1673: htp.p('Content-Disposition: '|| v_disposition ||'; filename='||lob_rec.file_name);
1674: htp.p('Content-Transfer-Encoding: base64');
1675: htp.p('');
1676: end if;
1677:
1678: chunksize := dbms_lob.getchunksize(lob_rec.file_content);
Line 1675: htp.p('');
1671: else
1672: htp.p('Content-type: '||lob_rec.file_content_type);
1673: htp.p('Content-Disposition: '|| v_disposition ||'; filename='||lob_rec.file_name);
1674: htp.p('Content-Transfer-Encoding: base64');
1675: htp.p('');
1676: end if;
1677:
1678: chunksize := dbms_lob.getchunksize(lob_rec.file_content);
1679: if (chunksize < 32767) then
Line 1689: htp.prn(utl_raw.cast_to_varchar2(buffer));
1685: if (lob_bytes_remaining < amount) then
1686: amount := lob_bytes_remaining;
1687: end if;
1688: dbms_lob.read(lob_rec.file_content, amount, position, buffer);
1689: htp.prn(utl_raw.cast_to_varchar2(buffer));
1690: position := position + amount;
1691: lob_bytes_remaining := lob_bytes_remaining - amount;
1692: end loop;
1693: dbms_lob.close(lob_rec.file_content);
Line 1733: htp.p('Products ');
1729: draw_buttons;
1730: uiutil.cabo2b;
1731: draw_tabs;
1732: uiutil.cabo3;
1733: htp.p('Products ');
1734: htp.p('
');
1735: for s_rec in cur_apps loop
1736:
1737: htp.p('');
Line 1734: htp.p('');
1730: uiutil.cabo2b;
1731: draw_tabs;
1732: uiutil.cabo3;
1733: htp.p('
Products ');
1734: htp.p('');
1735: for s_rec in cur_apps loop
1736:
1737: htp.p('');
1738: uiutil.a_href_gen(c_type => 'APP'
Line 1737: htp.p('');
1733: htp.p('
Products ');
1734: htp.p(' ');
1735: for s_rec in cur_apps loop
1736:
1737: htp.p('');
1738: uiutil.a_href_gen(c_type => 'APP'
1739: , c_link => 'etrm_fndnav.ls_object?c_name=*'
1740: ||'&n_appid='
1741: ||s_rec.application_id
Line 1744: htp.p('');
1740: ||'&n_appid='
1741: ||s_rec.application_id
1742: , c_display => s_rec.product_name);
1743:
1744: htp.p('');
1745: end loop;
1746: htp.p('
');
1747: uiutil.cabo4;
1748: quick_list;
Line 1746: htp.p(' ');
1742: , c_display => s_rec.product_name);
1743:
1744: htp.p('');
1745: end loop;
1746: htp.p('');
1747: uiutil.cabo4;
1748: quick_list;
1749: uiutil.cabo5;
1750: -- draw_form;
Line 1788: htp.p('Application does not support objects of given type ');
1784: draw_buttons;
1785: uiutil.cabo2b;
1786: draw_tabs;
1787: uiutil.cabo3;
1788: htp.p('Application does not support objects of given type ');
1789: uiutil.cabo4;
1790: quick_list;
1791: uiutil.cabo5;
1792: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_type);
Line 1824: htp.p('');
1820: -- n_tabid datatype is varchar because lookup types do not have a numeric id
1821: is
1822: begin
1823: uiutil.cabo1(c_title=>'FND Design Data');
1824: htp.p('');
1825: htp.p(' [Home] [Help]
1826:
Select Etrm Version Version 12.1.1 Version 12.2.2 Search
');
1827:
1828: if c_type = 'TABLE' then
1821: is
1822: begin
1823: uiutil.cabo1(c_title=>'FND Design Data');
1824: htp.p('
');
1825: htp.p(' [Home] [Help]
1826: Select Etrm Version Version 12.1.1 Version 12.2.2 Search
');
1827:
1828: if c_type = 'TABLE' then
1829: ls_table(n_tabid => to_number(n_tabid), n_appid => n_appid);
Line 1842: htp.p(FND_CSS_PKG.Encode(c_type) ||' objects are not currently supported');
1838: elsif c_type = 'EVENT' then
1839: ls_event(c_guid => n_tabid);
1840:
1841: else
1842: htp.p(FND_CSS_PKG.Encode(c_type) ||' objects are not currently supported');
1843: end if;
1844:
1845: htp.p('
');
1846: uiutil.prn_copyright;
Line 1845: htp.p('');
1841: else
1842: htp.p(FND_CSS_PKG.Encode(c_type) ||' objects are not currently supported');
1843: end if;
1844:
1845: htp.p('
');
1846: uiutil.prn_copyright;
1847: htp.p('');
1848: end show_object;
1849:
Line 1847: htp.p('');
1843: end if;
1844:
1845: htp.p('
');
1846: uiutil.prn_copyright;
1847: htp.p('');
1848: end show_object;
1849:
1850: function get_owner(c_name in dba_objects.object_name%type
1851: , c_type in dba_objects.object_type%type)