214: END IF;
215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: Wf_Core.Context('wf_lookup_types_pub',
219: 'fetch_lookup_types',
220: p_item_type,
221: p_lookup_type);
222:
263: */
264: IF (l_type_display_name IS NULL) THEN
265:
266: l_type_display_name := p_type_internal_name||' '||
267: ' -- '||UPPER(wf_core.translate ('WFITD_UNDEFINED'))||'';
268:
269: END IF;
270:
271: ELSE
304: */
305: IF (l_code_display_name IS NULL) THEN
306:
307: l_code_display_name := p_code_internal_name||' '||
308: ' -- '||UPPER(wf_core.translate ('WFITD_UNDEFINED'))||'';
309:
310: END IF;
311:
312: ELSE
324: p_code_display_name := l_code_display_name;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: Wf_Core.Context('wf_lookup_types_pub',
329: 'fetch_lookup_display',
330: p_type_internal_name,
331: p_code_internal_name);
332:
359: /*
360: ** Create the the attributes title. Indent it to the level specified
361: */
362: wf_item_definition_util_pub.draw_summary_section_title(
363: wf_core.translate('WFITD_LOOKUP_TYPES'),
364: p_indent_level);
365:
366: /*
367: ** Print out all lookup type display names in the pl*sql table
442: END LOOP;
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: Wf_Core.Context('wf_lookup_types_pub', 'draw_lookup_type_list');
447: wf_item_definition.Error;
448:
449: END draw_lookup_type_list;
450:
471: /*
472: ** Create the the lookups title. Indent it to the level specified
473: */
474: wf_item_definition_util_pub.draw_summary_section_title(
475: wf_core.translate('WFITD_LOOKUP_CODES'),
476: p_indent_level);
477:
478: /*
479: ** Print out all lookup display names in the pl*sql table
498: END LOOP;
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: Wf_Core.Context('wf_lookup_types_vl_pub', 'draw_lookup_list');
503: wf_item_definition.Error;
504:
505: END draw_lookup_list;
506:
530: /*
531: ** Draw the section title for the lookup type detail section
532: */
533: wf_item_definition_util_pub.draw_detail_section_title (
534: wf_core.translate('WFITD_LOOKUP_TYPE_DETAILS'),
535: 0);
536:
537: /*
538: ** Print out all item attribute display names in the pl*sql table
554: wf_item_definition_util_pub.create_details_hotlink_target (
555: 'LOOKUP_TYPE',
556: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,
557: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,
558: wf_core.translate('WFITD_LOOKUP_TYPE_NAME'),
559: 0);
560:
561: /*
562: ** Create the internal name row in the table. Also lay down the
562: ** Create the internal name row in the table. Also lay down the
563: ** destination for the anchor based on the row id.
564: */
565: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
566: wf_core.translate('WFITD_INTERNAL_NAME'),
567: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type);
568:
569: /*
570: ** Create the description row in the table
569: /*
570: ** Create the description row in the table
571: */
572: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
573: wf_core.translate('DESCRIPTION'),
574: p_wf_lookup_types_tbl(l_lookup_type_record_num).description);
575:
576: /*
577: ** Call function to print the customization/protection levels
659: /*
660: ** Draw the section title for the Lookup Type detail section
661: */
662: wf_item_definition_util_pub.draw_detail_section_title (
663: wf_core.translate('WFITD_LOOKUP_TYPE_DETAILS'),
664: 0);
665:
666: END IF;
667:
682: END LOOP;
683:
684: EXCEPTION
685: WHEN OTHERS THEN
686: Wf_Core.Context('wf_lookup_types_pub', 'draw_lookup_type_details');
687: wf_item_definition.Error;
688:
689: END draw_lookup_type_details;
690:
709: /*
710: ** Draw the section title for the lookup detail section
711: */
712: wf_item_definition_util_pub.draw_detail_section_title (
713: wf_core.translate('WFITD_LOOKUP_DETAILS'),
714: 0);
715:
716: /*
717: ** Print out all meesage attribute display names in the pl*sql table
734: 'LOOKUP',
735: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
736: p_wf_lookups_tbl(l_record_num).lookup_code,
737: p_wf_lookups_tbl(l_record_num).meaning,
738: wf_core.translate('WFITD_LOOKUP_CODE_NAME'),
739: 0);
740:
741: /*
742: ** Create the internal name row in the table.
741: /*
742: ** Create the internal name row in the table.
743: */
744: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
745: wf_core.translate('WFITD_INTERNAL_NAME'),
746: p_wf_lookups_tbl(l_record_num).lookup_code);
747:
748: /*
749: ** Create the lookup type display name row in the table.
748: /*
749: ** Create the lookup type display name row in the table.
750: */
751: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
752: wf_core.translate('WFITD_LOOKUP_TYPE_NAME'),
753: p_wf_lookups_tbl(l_record_num).lookup_type_display_name);
754:
755: /*
756: ** Create the description row in the table
755: /*
756: ** Create the description row in the table
757: */
758: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
759: wf_core.translate('DESCRIPTION'),
760: p_wf_lookups_tbl(l_record_num).description);
761:
762: /*
763: ** Table is created so close it out
777: END LOOP;
778:
779: EXCEPTION
780: WHEN OTHERS THEN
781: Wf_Core.Context('wf_lookup_types_vl_pub', 'draw_lookup_details');
782: wf_item_definition.Error;
783:
784: END draw_lookup_details;
785: