DBA Data[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('

HomeFND Navigator Home');
180: end if;

Line 179: -- htp.p('

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

HomeFND Navigator Home');
180: end if;
181:
182:
183:

Line 186: htp.p('
');

182:
183:
184:
185:
186: htp.p('');
187: htp.p('');
188:
189: htp.p(' ');
190: htp.p('');
225:
226:
227: htp.p('
');

183:
184:
185:
186: htp.p('');
187: htp.p('

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

185:
186: htp.p('');
187: htp.p('

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

220: htp.p('

');
188:
189: htp.p(' ');
190: htp.p('');
202:

Line 200: htp.p('');

196: end if;
197: for a_rec in cur_apps loop
198: htp.p('

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

199: end loop;
200: htp.p('');
201: htp.p('

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

Line 204: htp.p('
');
204: htp.p('');
207: htp.p(' ');
208: htp.p(' ');

203: htp.p('

 ');
204: htp.p('');
207: htp.p(' ');
208: htp.p('');
207: htp.p(' ');
208: htp.p('');
207: htp.p(' ');
208: htp.p('');

Line 221: htp.p('

217: htp.p('

Line 222: htp.p('

218: htp.p('

Line 223: htp.p('');

219: htp.p('

');
201: htp.p('
'||a_rec.product_name);
199: end loop;
200: htp.p('');
201: htp.p('
Object Name like:
Object Name like:
');

Line 220: htp.p('

216: end if;
217: htp.p('

');

Line 224: htp.p('
');
228: htp.p('');

Line 227: htp.p('
');

223: htp.p('');
224: htp.p('

');
228: htp.p('');
229: htp.p('');
230:
231:

Line 228: htp.p('');

224: htp.p('');
225:
226:
227: htp.p('');
228: htp.p('');
229: htp.p('');
230:
231:
232: end draw_form;

Line 229: htp.p('');

225:
226:
227: htp.p('');
228: htp.p('');
229: 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('');

Line 868: htp.p('
Product: '
869: || get_appname(n_appid)||'
Product: '

864: v_tablename := tab_rec.table_name;
865: htp.p(' 866: summary="location information">');
867:
868: htp.p('');
870: htp.p('');
872:

Line 870: htp.p('
');
870: htp.p('');
872:
873: htp.p('');
870: htp.p('');
872:
873: 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('

Product: '
869: || get_appname(n_appid)||'
Description: '
871: || tab_rec.description||'
Description: '

866: summary="location information">');
867:
868: htp.p('

Product: '
869: || get_appname(n_appid)||'
Description: '
871: || tab_rec.description||'
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)||'

Description: '
871: || tab_rec.description||'
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('
');
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('

879:
880: htp.p('

');
881: /*
882: htp.p('
Storage Details
');
883: htp.p('884: summary="dba information">');
885:
886: htp.p('');

Line 886: htp.p('
');
901: htp.p('');
903: htp.p('');
905: htp.p('
Initial Extent: '
887: || tab_rec.initial_extent||'
Initial Extent: '

882: htp.p('

Storage Details
');
883: htp.p(' 884: summary="dba information">');
885:
886: htp.p('');
888: htp.p('');
890: htp.p('');
888: htp.p('');
890: htp.p('');
892: htp.p('');
888: htp.p('');
890: htp.p('');
892: htp.p('');
894:

Line 892: htp.p('
');
890: htp.p('');
892: htp.p('');
894:
895: htp.p('');

Line 895: htp.p('
');
892: htp.p('');
894:
895: htp.p('');
897: htp.p('');
899: htp.p('');
894:
895: htp.p('');
897: htp.p('');
899: htp.p('');
901: htp.p('');
897: htp.p('');
899: htp.p('');
901: htp.p('');
903: htp.p('');
899: htp.p('');
901: htp.p('');
903: htp.p('');
905: htp.p('
Initial Extent: '
887: || tab_rec.initial_extent||'
Next Extent: '
889: || tab_rec.next_extent||'
Min Extents: '

Line 888: htp.p('
Next Extent: '

884: summary="dba information">');
885:
886: htp.p('

Initial Extent: '
887: || tab_rec.initial_extent||'
Next Extent: '
889: || tab_rec.next_extent||'
Min Extents: '
891: || tab_rec.min_extents||'
Max Extents: '

Line 890: htp.p('
Min Extents: '

886: htp.p('

Initial Extent: '
887: || tab_rec.initial_extent||'
Next Extent: '
889: || tab_rec.next_extent||'
Min Extents: '
891: || tab_rec.min_extents||'
Max Extents: '
893: || tab_rec.max_extents||'
Max Extents: '

888: htp.p('

Next Extent: '
889: || tab_rec.next_extent||'
Min Extents: '
891: || tab_rec.min_extents||'
Max Extents: '
893: || tab_rec.max_extents||'
% Increase: '
896: || tab_rec.pct_increase||'
% Increase: '

891: || tab_rec.min_extents||'

Max Extents: '
893: || tab_rec.max_extents||'
% Increase: '
896: || tab_rec.pct_increase||'
Init Trans: '
898: || tab_rec.ini_trans||'
Max Trans: '

Line 897: htp.p('
Init Trans: '

893: || tab_rec.max_extents||'

% Increase: '
896: || tab_rec.pct_increase||'
Init Trans: '
898: || tab_rec.ini_trans||'
Max Trans: '
900: || tab_rec.max_trans||'
% Free: '

Line 899: htp.p('
Max Trans: '

895: htp.p('

% Increase: '
896: || tab_rec.pct_increase||'
Init Trans: '
898: || tab_rec.ini_trans||'
Max Trans: '
900: || tab_rec.max_trans||'
% Free: '
902: ||tab_rec.pct_free||'
% Used: '

Line 901: htp.p('
% Free: '

897: htp.p('

Init Trans: '
898: || tab_rec.ini_trans||'
Max Trans: '
900: || tab_rec.max_trans||'
% Free: '
902: ||tab_rec.pct_free||'
% Used: '
904: || tab_rec.pct_used||'
');

Line 903: htp.p('
% Used: '

899: htp.p('

Max Trans: '
900: || tab_rec.max_trans||'
% Free: '
902: ||tab_rec.pct_free||'
% Used: '
904: || tab_rec.pct_used||'
');
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('
    1. '

      Line 920: htp.p('
    2. '

      3. 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('
      1. '
        921: || uiutil.el_image('COL')
        922: ||key_col.column_name
        923: ||'
        2. ');
        924: end loop;

        Line 925: htp.p('
      ');

      921: || uiutil.el_image('COL')
      922: ||key_col.column_name
      923: ||'

      3. ');
      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:

    Line 936: htp.p('
    Table

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

    Line 947: htp.p('
    ');

    943: end if;
    944:
    945:
    946:
    947: htp.p('

    ');
    948: htp.p('');
    951: htp.p('');
    948: htp.p('');
    951: htp.p('    ');
    948: htp.p('    ');
    951: htp.p('    ');
    954: htp.p('    ');
    951: htp.p('    ');
    954: 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('

    ');
    964:
    965: v_first2 := TRUE;
    966: 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('
    Table
    '
    949: ||v_tablename
    950: ||'    		'

    Line 948: htp.p('
    		'

    944:
    945:
    946:
    947: htp.p('

    '
    949: ||v_tablename
    950: ||'    		'
    952: ||uiutil.el_image('FK')

    Line 951: htp.p('
    		'

    947: htp.p('

    '
    949: ||v_tablename
    950: ||'    		'
    952: ||uiutil.el_image('FK')
    953: || '    		');
    955: uiutil.a_href_gen(c_type => 'TABLE'

    Line 954: htp.p('
    		');

    950: ||'

    		'
    952: ||uiutil.el_image('FK')
    953: || '    		');
    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('
    		');
    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('

    		');
    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('
    990: summary="Foreign keys from/to this table">
    991:
    992:

    Line 989: htp.p('
    Table

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

    Line 998: htp.p('
    ');

    994:


    995:     ');
    996: end if;
    997:
    998: htp.p('    ');
    999: htp.p('    ');
    996: end if;
    997:
    998: htp.p('    ');
    999: 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('

    ');
    1012: htp.p('    ');
    1009: htp.p('    ');
    1012: htp.p('    ');

    Line 1012: htp.p('
    ');
    1009: htp.p('    ');
    1012: htp.p('    ');
    1014:
    1015: v_first2 := TRUE;
    1016: htp.p('    ');

    1009: htp.p('

    ');
    1012: htp.p('    ');
    1014:
    1015: v_first2 := TRUE;
    1016: htp.p('    ');
    1014:
    1015: v_first2 := TRUE;
    1016: 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('
    Table
    Foreign TableForeign Key Column
    ');
    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
    ');
    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('
    		'
    1010: ||uiutil.el_image('FK')
    1011: ||'    		');

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

    		'
    1010: ||uiutil.el_image('FK')
    1011: ||'    		');
    1013: htp.p(v_tablename||'    		');

    1008: htp.p('

    		'
    1010: ||uiutil.el_image('FK')
    1011: ||'    		');
    1013: htp.p(v_tablename||'    		');

    Line 1013: htp.p(v_tablename||'
    		'
    1010: ||uiutil.el_image('FK')
    1011: ||'    		');
    1013: htp.p(v_tablename||'    		');
    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||'    		');
    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('
    ');

    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('
    1. '
      1060: ||uiutil.el_image('COL')

      Line 1059: htp.p('
    2. '

      3. 1055: IF v_first Then
      1056: htp.p('

        ');
        1057: v_first := FALSE;
        1058: end if;
        1059: htp.p('
      1. '
        1060: ||uiutil.el_image('COL')
        1061: ||ind_col_rec.column_name
        1062: ||'
        2. ');
        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('');

Line 1080: htp.p('
Name

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('');
1084: htp.p('');

Line 1082: htp.p('
');

1078:
1079: htp.p('

Columns
');
1080: htp.p('
Name Datatype
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('');
1084: htp.p('');
1085: htp.p('');
1086: htp.p('');

Line 1083: htp.p('
');

1079: htp.p('

Columns
');
1080: htp.p('
Name DatatypeLengthPrcn Name
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('');
1084: htp.p('');
1085: htp.p('');
1086: htp.p('');
1087: htp.p('');

Line 1084: htp.p('
');

1080: htp.p('

Name DatatypeLengthPrcnNull Datatype
1081: summary="Column details for this table">');
1082: htp.p('');
1083: htp.p('');
1084: htp.p('');
1085: htp.p('');
1086: htp.p('');
1087: htp.p('');
1088: htp.p('');

Line 1085: htp.p('
');

1081: summary="Column details for this table">');
1082: htp.p('

');
1083: htp.p('');
1084: htp.p('');
1085: htp.p('');
1086: htp.p('');
1087: htp.p('');
1088: htp.p('');
1089: v_first := FALSE;

Line 1086: htp.p('
');

1082: htp.p('

');
1083: htp.p('');
1084: htp.p('');
1085: htp.p('');
1086: htp.p('');
1087: htp.p('');
1088: htp.p('');
1089: v_first := FALSE;
1090: end if;

Line 1087: htp.p('
');

1083: htp.p('

');
1084: htp.p('');
1085: htp.p('');
1086: htp.p('');
1087: htp.p('');
1088: htp.p('');
1089: v_first := FALSE;
1090: end if;
1091:

Line 1088: htp.p('
');

1084: htp.p('

');
1085: htp.p('');
1086: htp.p('');
1087: htp.p('');
1088: htp.p('');
1089: v_first := FALSE;
1090: end if;
1091:
1092: htp.prn('');
1089: v_first := FALSE;
1090: end if;
1091:
1092: htp.prn('');
1095: htp.prn('');
1095: htp.prn('');

Line 1094: htp.p('');

1090: end if;
1091:
1092: htp.prn('

');
1095: htp.prn('');
1098: htp.prn('');
1095: htp.prn('');
1098: htp.prn('');
1095: htp.prn('');
1098: htp.prn('');

Line 1097: htp.p('');

1093: htp.prn(col_rec.column_name);
1094: htp.p('');
1095: htp.prn('

');
1098: htp.prn('');
1101: htp.prn('');
1095: htp.prn('');
1098: htp.prn('');
1101: htp.prn('');
1098: htp.prn('');
1101: htp.prn('');

Line 1100: htp.p('');

1096: htp.prn(col_rec.data_type);
1097: htp.p('');
1098: htp.prn('

');
1101: htp.prn('');
1104: htp.prn('');
1098: htp.prn('');
1101: htp.prn('');
1104: htp.prn('');
1101: htp.prn('');
1104: htp.prn('');

1099: htp.prn(col_rec.data_length);
1100: htp.p('');
1101: htp.prn('

');
1104: htp.prn('');
1101: htp.prn('');
1104: htp.prn('');

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

1101: htp.prn('

');
1104: htp.prn('');
1109: end loop;

Line 1106: htp.prn('
');
1104: htp.prn('');
1109: end loop;
1110: if v_first then

Line 1107: htp.prn(col_rec.description);

1103: htp.p('');
1104: htp.prn('

');
1109: end loop;
1110: if v_first then
1111: null;

Line 1108: htp.p('');

1104: htp.prn('

');
1109: end loop;
1110: if v_first then
1111: null;
1112: else

Line 1113: htp.p('
Name DatatypeLengthPrcnNullDescription
Length
Name Datatype LengthPrcnNullDescription
Prcn
Name DatatypeLength PrcnNullDescription
Null Name DatatypeLengthPrcn NullDescription
Description
DatatypeLengthPrcnNull Description
');

Line 1092: htp.prn('
');

1088: htp.p('

Description
');
1093: htp.prn(col_rec.column_name);
1094: htp.p('		');
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('		');
1096: htp.prn(col_rec.data_type);
1097: htp.p('
');
1093: htp.prn(col_rec.column_name);
1094: htp.p('		');
1096: htp.prn(col_rec.data_type);
1097: htp.p('		');

Line 1095: htp.prn('
');

1091:
1092: htp.prn('

');
1093: htp.prn(col_rec.column_name);
1094: htp.p('		 ');
1096: htp.prn(col_rec.data_type);
1097: htp.p('		');
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('		');
1096: htp.prn(col_rec.data_type);
1097: htp.p('		');
1099: htp.prn(col_rec.data_length);
1100: htp.p('		');
1096: htp.prn(col_rec.data_type);
1097: htp.p('		');
1099: htp.prn(col_rec.data_length);
1100: htp.p('		');

Line 1098: htp.prn('
');

1094: htp.p('

');
1096: htp.prn(col_rec.data_type);
1097: htp.p('		 ');
1099: htp.prn(col_rec.data_length);
1100: htp.p('		');
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('		');
1099: htp.prn(col_rec.data_length);
1100: htp.p('		');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		');
1099: htp.prn(col_rec.data_length);
1100: htp.p('		');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		');

Line 1101: htp.prn('
');

1097: htp.p('

');
1099: htp.prn(col_rec.data_length);
1100: htp.p('		 ');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		');
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('		');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		');
1105: htp.prn(col_rec.nullable);
1106: htp.prn('		');

Line 1103: htp.p('
');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		');
1105: htp.prn(col_rec.nullable);
1106: htp.prn('		');
1107: htp.prn(col_rec.description);

Line 1104: htp.prn('
');

1100: htp.p('

');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		 ');
1105: htp.prn(col_rec.nullable);
1106: htp.prn('		');
1107: htp.prn(col_rec.description);
1108: htp.p('
');
1102: htp.prn(col_rec.data_precision);
1103: htp.p('		');
1105: htp.prn(col_rec.nullable);
1106: htp.prn('		');
1107: htp.prn(col_rec.description);
1108: htp.p('
');

1102: htp.prn(col_rec.data_precision);
1103: htp.p('

');
1105: htp.prn(col_rec.nullable);
1106: htp.prn('		');
1107: htp.prn(col_rec.description);
1108: htp.p('
');
1105: htp.prn(col_rec.nullable);
1106: htp.prn('		');
1107: htp.prn(col_rec.description);
1108: htp.p('
');
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
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('');

Line 1173: htp.p('
Product: '
1174: || get_appname(n_appid)||'
Product: '

1169: v_tablename := tab_rec.view_name;
1170: htp.p(' 1171: summary="location information">');
1172:
1173: htp.p('');
1175: htp.p('');
1177: htp.p('');
1175: htp.p('');
1177: htp.p('');
1175: htp.p('');
1177: 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('

Product: '
1174: || get_appname(n_appid)||'
Description: '
1176: || tab_rec.description||'
Implementation/DBA Data: ');

Line 1175: htp.p('
Description: '

1171: summary="location information">');
1172:
1173: htp.p('

Product: '
1174: || get_appname(n_appid)||'
Description: '
1176: || tab_rec.description||'
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)||'
Description: '
1176: || tab_rec.description||'
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('
');
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('');

Line 1204: htp.p('
Name

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('');
1208:

Line 1206: htp.p('
');

1202:
1203: htp.p('

Columns
');
1204: htp.p('
Name
1205: summary="Column details for this table">');
1206: htp.p('');
1207: htp.p('');
1208:
1209: v_first := FALSE;
1210: end if;

Line 1207: htp.p('
');

1203: htp.p('

Columns
');
1204: htp.p('
Name Name
1205: summary="Column details for this table">');
1206: htp.p('');
1207: htp.p('');
1208:
1209: v_first := FALSE;
1210: end if;
1211:

Line 1212: htp.prn('
');
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('

');
1215: htp.p('');
1216: end loop;
1217:

Line 1214: htp.p('');

1210: end if;
1211:
1212: htp.prn('

');
1215: htp.p('');
1216: end loop;
1217:
1218: --

Line 1215: htp.p('');

1211:
1212: htp.prn('

');
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('
Name
');

1208:
1209: v_first := FALSE;
1210: end if;
1211:
1212: htp.prn('

');
1213: htp.prn(col_rec.column_name);
1214: htp.p('
');
1213: htp.prn(col_rec.column_name);
1214: htp.p('
');
1213: htp.prn(col_rec.column_name);
1214: htp.p('
');
1213: htp.prn(col_rec.column_name);
1214: 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('');

Line 1303: htp.p('
Product: '
1304: || get_appname(n_appid)||'
Product: '

1299:
1300: htp.p(' 1301: summary="location information">');
1302:
1303: htp.p('');
1305:
1306: htp.p('');

Line 1306: htp.p('
');
1305:
1306: htp.p('');
1308:
1309: htp.p('');

Line 1309: htp.p('
');
1308:
1309: htp.p('');
1311:
1312: htp.p('');
1311:
1312: htp.p('');
1316:

Line 1317: htp.p('
');
1316:
1317: htp.p('');
1321:

Line 1322: htp.p('
');
1321:
1322: htp.p('');
1326: htp.p('
Product: '
1304: || get_appname(n_appid)||'
User Name: '
1307: || c_rec.long_name||'
User Name: '

1302:
1303: htp.p('

Product: '
1304: || get_appname(n_appid)||'
User Name: '
1307: || c_rec.long_name||'
Description: '
1310: || c_rec.description||'
Description: '

1305:
1306: htp.p('

User Name: '
1307: || c_rec.long_name||'
Description: '
1310: || c_rec.description||'
Enabled: '
1313: || get_lookup_meaning(c_lookup_type => 'YES_NO'

Line 1312: htp.p('
Enabled: '

1308:
1309: htp.p('

Description: '
1310: || c_rec.description||'
Enabled: '
1313: || get_lookup_meaning(c_lookup_type => 'YES_NO'
1314: , c_lookup_code =>c_rec.enabled_flag)
1315: ||'
Execution Method: '

1313: || get_lookup_meaning(c_lookup_type => 'YES_NO'
1314: , c_lookup_code =>c_rec.enabled_flag)
1315: ||'

Execution Method: '
1318: || get_lookup_meaning(c_lookup_type => 'CP_EXECUTION_METHOD_CODE'
1319: , c_lookup_code =>c_rec.execution_method_code)
1320: ||'
Argument Method: '

1318: || get_lookup_meaning(c_lookup_type => 'CP_EXECUTION_METHOD_CODE'
1319: , c_lookup_code =>c_rec.execution_method_code)
1320: ||'

Argument Method: '
1323: || get_lookup_meaning(c_lookup_type => 'CP_ARGUMENT_METHOD_CODE'
1324: , c_lookup_code =>c_rec.argument_method_code)
1325: ||'
');

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('');
1346:
1347: 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('');

Line 1335: htp.p('
User Name: '
1336: || e_rec.user_executable_name||'
User Name: '

1331: htp.p('

Executable: '||e_rec.name ||'

');
1332: htp.p(' 1333: summary="location information">');
1334:
1335: htp.p('');
1337:
1338: htp.p('');

Line 1338: htp.p('
');
1337:
1338: htp.p('');
1340:
1341: htp.p('');

Line 1341: htp.p('
');
1340:
1341: htp.p('');
1343:
1344: htp.p('');

Line 1344: htp.p('
');
1343:
1344: htp.p('');
1346:
1347: htp.p('
User Name: '
1336: || e_rec.user_executable_name||'
Description: '
1339: || e_rec.description||'
Description: '

1334:
1335: htp.p('

User Name: '
1336: || e_rec.user_executable_name||'
Description: '
1339: || e_rec.description||'
Execution Filename: '
1342: || e_rec.execution_file_name||'
Execution Filename: '

1337:
1338: htp.p('

Description: '
1339: || e_rec.description||'
Execution Filename: '
1342: || e_rec.execution_file_name||'
Subroutine Name: '
1345: || e_rec.subroutine_name||'
Subroutine Name: '

1340:
1341: htp.p('

Execution Filename: '
1342: || e_rec.execution_file_name||'
Subroutine Name: '
1345: || e_rec.subroutine_name||'
');
1348:

Line 1347: htp.p('
');

1343:
1344: htp.p('

Subroutine Name: '
1345: || e_rec.subroutine_name||'
');
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('');

Line 1357: htp.p('
Name

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('');
1361: htp.p('');

Line 1359: htp.p('
');

1355:
1356: htp.p('

Request Set Arguments
');
1357: htp.p('
Name Descriptive Flex
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('');
1361: htp.p('');
1362: htp.p('');
1363: htp.p('');

Line 1360: htp.p('
');

1356: htp.p('

Request Set Arguments
');
1357: htp.p('
Name Descriptive FlexDisplayInsert Name
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('');
1361: htp.p('');
1362: htp.p('');
1363: htp.p('');
1364: htp.p('');

Line 1361: htp.p('
');

1357: htp.p('

Name Descriptive FlexDisplayInsertUpdate Descriptive Flex
1358: summary="Concurrent program arguments">');
1359: htp.p('');
1360: htp.p('');
1361: htp.p('');
1362: htp.p('');
1363: htp.p('');
1364: htp.p('');
1365: htp.p('');

Line 1362: htp.p('
');

1358: summary="Concurrent program arguments">');
1359: htp.p('

');
1360: htp.p('');
1361: htp.p('');
1362: htp.p('');
1363: htp.p('');
1364: htp.p('');
1365: htp.p('');
1366: htp.p('');

Line 1363: htp.p('
');

1359: htp.p('

');
1360: htp.p('');
1361: htp.p('');
1362: htp.p('');
1363: htp.p('');
1364: htp.p('');
1365: htp.p('');
1366: htp.p('');
1367: htp.p('');

Line 1364: htp.p('
');

1360: htp.p('

');
1361: htp.p('');
1362: htp.p('');
1363: htp.p('');
1364: htp.p('');
1365: htp.p('');
1366: htp.p('');
1367: htp.p('');
1368: v_first := FALSE;

Line 1365: htp.p('
');

1361: htp.p('

');
1362: htp.p('');
1363: htp.p('');
1364: htp.p('');
1365: htp.p('');
1366: htp.p('');
1367: htp.p('');
1368: v_first := FALSE;
1369: end if;

Line 1366: htp.p('
');

1362: htp.p('

');
1363: htp.p('');
1364: htp.p('');
1365: htp.p('');
1366: htp.p('');
1367: htp.p('');
1368: v_first := FALSE;
1369: end if;
1370:

Line 1367: htp.p('
');

1363: htp.p('

');
1364: htp.p('');
1365: htp.p('');
1366: htp.p('');
1367: htp.p('');
1368: v_first := FALSE;
1369: end if;
1370:
1371: htp.prn('');
1368: v_first := FALSE;
1369: end if;
1370:
1371: htp.prn('');
1374: htp.prn('');
1374: htp.prn('');

Line 1373: htp.p('');

1369: end if;
1370:
1371: htp.prn('

');
1374: htp.prn('');
1377: htp.prn('');
1374: htp.prn('');
1377: htp.prn('');
1374: htp.prn('');
1377: htp.prn('');

Line 1376: htp.p('');

1372: htp.prn(a_rec.application_column_name);
1373: htp.p('');
1374: htp.prn('

');
1377: htp.prn('');
1380: htp.prn('');
1374: htp.prn('');
1377: htp.prn('');
1380: htp.prn('');
1377: htp.prn('');
1380: htp.prn('');

Line 1379: htp.p('');

1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('');
1377: htp.prn('

');
1380: htp.prn('');
1383: htp.prn('');
1377: htp.prn('');
1380: htp.prn('');
1383: htp.prn('');
1380: htp.prn('');
1383: htp.prn('');

1378: htp.prn(a_rec.display_flag);
1379: htp.p('');
1380: htp.prn('

');
1383: htp.prn('');
1380: htp.prn('');
1383: htp.prn('');
1383: htp.prn('');
1383: htp.prn('');
1383: htp.prn('');

Line 1388: htp.prn(a_rec.default_value);

1384: htp.prn(a_rec.update_flag);
1385: htp.prn('

');
1392: end loop;

Line 1389: htp.prn('
');
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('

');
1392: end loop;
1393: if v_first then
1394: null;

Line 1391: htp.p('');

1387: htp.prn('

');
1392: end loop;
1393: if v_first then
1394: null;
1395: else

Line 1396: htp.p('
Name Descriptive FlexDisplayInsertUpdateDefault Type Display
Name Descriptive Flex DisplayInsertUpdateDefault TypeDefault Value Insert
Name Descriptive FlexDisplay InsertUpdateDefault TypeDefault ValueShared Name Update Name Descriptive FlexDisplayInsert UpdateDefault TypeDefault ValueShared Name Default Type Descriptive FlexDisplayInsertUpdate Default TypeDefault ValueShared Name Default Value DisplayInsertUpdateDefault Type Default ValueShared Name Shared Name InsertUpdateDefault TypeDefault Value Shared Name
');

Line 1371: htp.prn('
');

1367: htp.p('

Shared Name
');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p('		');
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('		');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('
');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p('		');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('		');

Line 1374: htp.prn('
');

1370:
1371: htp.prn('

');
1372: htp.prn(a_rec.application_column_name);
1373: htp.p('		 ');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('		');
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('		');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('		');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('		');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('		');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('		');

Line 1377: htp.prn('
');

1373: htp.p('

');
1375: htp.prn(a_rec.descriptive_flexfield_name);
1376: htp.p('		 ');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('		');
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('		');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('		');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('		');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('		');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('		');

Line 1380: htp.prn('
');

1376: htp.p('

');
1378: htp.prn(a_rec.display_flag);
1379: htp.p('		 ');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('		');
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('		');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('		');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn('		');

Line 1382: htp.p('
');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('		');
1384: htp.prn(a_rec.update_flag);
1385: htp.prn('		');
1386: htp.prn(a_rec.default_type);

Line 1383: htp.prn('
');

1379: htp.p('

');
1381: htp.prn(a_rec.insert_flag);
1382: htp.p('		 ');
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('		');
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('

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

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

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('
');
1388: htp.prn(a_rec.default_value);
1389: htp.prn('		');
1390: htp.prn(a_rec.shared_parameter_name);
1391: htp.p('
');
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
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('');

Line 1445: htp.p('
Product: '
1446: || get_appname(n_appid)||'
Product: '

1441:
1442: htp.p(' 1443: summary="location information">');
1444:
1445: htp.p('');
1447:
1448: htp.p('');

Line 1448: htp.p('
');
1447:
1448: htp.p('');
1450:
1451: htp.p('');

Line 1451: htp.p('
');
1450:
1451: htp.p('');
1453: htp.p('
Product: '
1446: || get_appname(n_appid)||'
Meaning: '
1449: || c_rec.meaning||'
Meaning: '

1444:
1445: htp.p('

Product: '
1446: || get_appname(n_appid)||'
Meaning: '
1449: || c_rec.meaning||'
Description: '
1452: || c_rec.description||'
Description: '

1447:
1448: htp.p('

Meaning: '
1449: || c_rec.meaning||'
Description: '
1452: || c_rec.description||'
');
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('');

Line 1461: htp.p('
Code

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('');
1465: htp.p('');

Line 1463: htp.p('
');

1459:
1460: htp.p('

Quick Codes
');
1461: htp.p('
CodeMeaning
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('');
1465: htp.p('');
1466: htp.p('');
1467: v_first := FALSE;

Line 1464: htp.p('
');

1460: htp.p('

Quick Codes
');
1461: htp.p('
CodeMeaningDescription
Code
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('');
1465: htp.p('');
1466: htp.p('');
1467: v_first := FALSE;
1468: end if;

Line 1465: htp.p('
');

1461: htp.p('

CodeMeaningDescription
Meaning
1462: summary="Quick Code details">');
1463: htp.p('');
1464: htp.p('');
1465: htp.p('');
1466: htp.p('');
1467: v_first := FALSE;
1468: end if;
1469:

Line 1466: htp.p('
');

1462: summary="Quick Code details">');
1463: htp.p('

');
1464: htp.p('');
1465: htp.p('');
1466: htp.p('');
1467: v_first := FALSE;
1468: end if;
1469:
1470: htp.prn('');
1467: v_first := FALSE;
1468: end if;
1469:
1470: htp.prn('');
1473: htp.prn('');
1473: htp.prn('');

Line 1472: htp.p('');

1468: end if;
1469:
1470: htp.prn('

');
1473: htp.prn('');
1476: htp.prn('');
1473: htp.prn('');
1476: htp.prn('');
1473: htp.prn('');
1476: htp.prn('');

Line 1475: htp.p('');

1471: htp.prn(v_rec.lookup_code);
1472: htp.p('');
1473: htp.prn('

');
1476: htp.prn('');
1479: end loop;

Line 1476: htp.prn('
');
1473: htp.prn('');
1476: htp.prn('');
1479: end loop;
1480: if v_first then

Line 1477: htp.prn(v_rec.description);

1473: htp.prn('

');
1476: htp.prn('');
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('

');
1479: end loop;
1480: if v_first then
1481: null;
1482: else

Line 1483: htp.p('
Code MeaningDescription
Description
CodeMeaning Description
');

Line 1470: htp.prn('
');

1466: htp.p('

Description
');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p('		');
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('		');
1474: htp.prn(v_rec.meaning);
1475: htp.p('
');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p('		');
1474: htp.prn(v_rec.meaning);
1475: htp.p('		');

Line 1473: htp.prn('
');

1469:
1470: htp.prn('

');
1471: htp.prn(v_rec.lookup_code);
1472: htp.p('		 ');
1474: htp.prn(v_rec.meaning);
1475: htp.p('		');
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('		');
1474: htp.prn(v_rec.meaning);
1475: htp.p('		');
1477: htp.prn(v_rec.description);
1478: htp.p('
');
1474: htp.prn(v_rec.meaning);
1475: htp.p('		');
1477: htp.prn(v_rec.description);
1478: htp.p('
');

1472: htp.p('

');
1474: htp.prn(v_rec.meaning);
1475: htp.p('		 ');
1477: htp.prn(v_rec.description);
1478: htp.p('
');
1474: htp.prn(v_rec.meaning);
1475: htp.p('		');
1477: htp.prn(v_rec.description);
1478: htp.p('
');
1477: htp.prn(v_rec.description);
1478: 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('');

Line 1519: htp.p('
');
1523: htp.p('');
1525: htp.p('');
1527: htp.p('
Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||'
Product: '

1515:
1516: htp.p(' 1517: summary="Workflow Event information">');
1518:
1519: htp.p('');
1521: htp.p('');
1523: htp.p('');
1521: htp.p('');
1523: htp.p('');
1525: htp.p('');
1521: htp.p('');
1523: htp.p('');
1525: htp.p('');
1527: htp.p('
Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||'
Type: '
1522: || e_rec.type||'
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||'
Type: '
1522: || e_rec.type||'
Status: '
1524: || e_rec.status||'
Generate Function: '

Line 1523: htp.p('
Status: '

1519: htp.p('

Product: '
1520: || e_rec.owner_tag||' - '||e_rec.owner_name||'
Type: '
1522: || e_rec.type||'
Status: '
1524: || e_rec.status||'
Generate Function: '
1526: || e_rec.generate_function||'
');

Line 1525: htp.p('
Generate Function: '

1521: htp.p('

Type: '
1522: || e_rec.type||'
Status: '
1524: || e_rec.status||'
Generate Function: '
1526: || e_rec.generate_function||'
');
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('');

Line 1536: htp.p('
Source Type

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('');
1540: htp.p('');

Line 1538: htp.p('
');

1534:
1535: htp.p('

Subscriptions:
');
1536: htp.p('
Source TypeRule Function
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('');
1540: htp.p('');
1541: htp.p('');
1542: htp.p('');

Line 1539: htp.p('
');

1535: htp.p('

Subscriptions:
');
1536: htp.p('
Source TypeRule FunctionWF Process TypeWF Process Name Source Type
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('');
1540: htp.p('');
1541: htp.p('');
1542: htp.p('');
1543: htp.p('');

Line 1540: htp.p('
');

1536: htp.p('

Source TypeRule FunctionWF Process TypeWF Process NameDescription
Rule Function
1537: summary="Subscription details">');
1538: htp.p('');
1539: htp.p('');
1540: htp.p('');
1541: htp.p('');
1542: htp.p('');
1543: htp.p('');
1544: v_first := FALSE;

Line 1541: htp.p('
');

1537: summary="Subscription details">');
1538: htp.p('

');
1539: htp.p('');
1540: htp.p('');
1541: htp.p('');
1542: htp.p('');
1543: htp.p('');
1544: v_first := FALSE;
1545: end if;

Line 1542: htp.p('
');

1538: htp.p('

');
1539: htp.p('');
1540: htp.p('');
1541: htp.p('');
1542: htp.p('');
1543: htp.p('');
1544: v_first := FALSE;
1545: end if;
1546:

Line 1543: htp.p('
');

1539: htp.p('

');
1540: htp.p('');
1541: htp.p('');
1542: htp.p('');
1543: htp.p('');
1544: v_first := FALSE;
1545: end if;
1546:
1547: htp.prn('');
1544: v_first := FALSE;
1545: end if;
1546:
1547: htp.prn('');
1550: htp.prn('');
1550: htp.prn('');

Line 1549: htp.p('');

1545: end if;
1546:
1547: htp.prn('

');
1550: htp.prn('');
1553:

Line 1550: htp.prn('
');
1550: htp.prn('');
1553:
1554: htp.prn('');
1550: htp.prn('');
1553:
1554: htp.prn('');

1548: htp.prn(s_rec.source_type);
1549: htp.p('');
1550: htp.prn('

');
1553:
1554: htp.prn('');

Line 1554: htp.prn('
');
1553:
1554: htp.prn('');
1557: htp.prn('');
1553:
1554: htp.prn('');
1557: htp.prn('');

Line 1556: htp.p('');

1552: htp.p('');
1553:
1554: htp.prn('

');
1557: htp.prn('');
1560:

Line 1557: htp.prn('
');
1557: htp.prn('');
1560:
1561: htp.prn('');
1557: htp.prn('');
1560:
1561: htp.prn('');

1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('');
1557: htp.prn('

');
1560:
1561: htp.prn('');

Line 1561: htp.prn('
');
1560:
1561: htp.prn('');
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('

');
1564: end loop;
1565: if v_first then
1566: null;

Line 1563: htp.p('');

1559: htp.p('');
1560:
1561: htp.prn('

');
1564: end loop;
1565: if v_first then
1566: null;
1567: else

Line 1568: htp.p('
Source Type Rule FunctionWF Process TypeWF Process NameDescription
WF Process Type
Source TypeRule Function WF Process TypeWF Process NameDescription
WF Process Name
Source TypeRule FunctionWF Process Type WF Process NameDescription
Description
Source TypeRule FunctionWF Process TypeWF Process Name Description
');

Line 1547: htp.prn('
');

1543: htp.p('

Description
');
1548: htp.prn(s_rec.source_type);
1549: htp.p('		');
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('		');
1551: htp.prn(s_rec.rule_function);
1552: htp.p('
');
1548: htp.prn(s_rec.source_type);
1549: htp.p('		');
1551: htp.prn(s_rec.rule_function);
1552: htp.p('		 ');

1546:
1547: htp.prn('

');
1548: htp.prn(s_rec.source_type);
1549: htp.p('		 ');
1551: htp.prn(s_rec.rule_function);
1552: htp.p('		');

Line 1551: htp.prn(s_rec.rule_function);

1547: htp.prn('

');
1548: htp.prn(s_rec.source_type);
1549: htp.p('		');
1551: htp.prn(s_rec.rule_function);
1552: htp.p('		');
1555: htp.prn(s_rec.wf_process_type);

Line 1552: htp.p('
');
1551: htp.prn(s_rec.rule_function);
1552: htp.p('		');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('		 ');

1550: htp.prn('

');
1551: htp.prn(s_rec.rule_function);
1552: htp.p('		 ');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('		');
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('

');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('		');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('		');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('		');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('		 ');

1553:
1554: htp.prn('

');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('		 ');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('		');

Line 1558: htp.prn(s_rec.wf_process_name);

1554: htp.prn('

');
1555: htp.prn(s_rec.wf_process_type);
1556: htp.p('		');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('		');
1562: htp.prn(s_rec.description);

Line 1559: htp.p('
');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('		');
1562: htp.prn(s_rec.description);
1563: htp.p('
');

1557: htp.prn('

');
1558: htp.prn(s_rec.wf_process_name);
1559: htp.p('		 ');
1562: htp.prn(s_rec.description);
1563: htp.p('
');
1562: htp.prn(s_rec.description);
1563: htp.p('
');
1562: htp.prn(s_rec.description);
1563: 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('');
1601:
1602: htp.p('');
1601:
1602: htp.p('');
1604:
1605: htp.p('');
1604:
1605: htp.p('');
1608:
1609:

Line 1614: htp.p('
');
1616: end if;
1617:
1618: htp.p('
Product: '
1599: || get_appname(c_rec.application_id)
1600: ||'
File Type: '

Line 1602: htp.p('
File Type: '

1598: htp.p('

Product: '
1599: || get_appname(c_rec.application_id)
1600: ||'
File Type: '
1603: || c_rec.file_type||'
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||'
Size: '
1606: || uiutil.byte_format(c_rec.file_length)
1607: ||'
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||'
');

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('FND Design Data [Home] [Help]
1826:

');
1827:
1828: if c_type = 'TABLE' then

Line 1825: htp.p('FND Design Data [Home] [Help]

1821: is
1822: begin
1823: uiutil.cabo1(c_title=>'FND Design Data');
1824: htp.p('');
1825: htp.p('FND Design Data [Home] [Help]
1826:

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