159: END IF;
160:
161: EXCEPTION
162: WHEN OTHERS THEN
163: Wf_Core.Context('wf_item_attributes_vl_pub',
164: 'fetch_item_attributes',
165: p_item_type,
166: p_name);
167:
198: */
199: IF (l_wf_item_attributes_vl_tbl.count < 1) THEN
200:
201: l_display_name := p_internal_name||' '||
202: ' -- '||wf_core.translate ('WFITD_UNDEFINED')||'';
203:
204: ELSE
205:
206: l_display_name := l_wf_item_attributes_vl_tbl(1).display_name;
210: p_display_name := l_display_name;
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: Wf_Core.Context('wf_item_attributes_pub',
215: 'fetch_item_attribute_display',
216: p_internal_name);
217:
218: END fetch_item_attribute_display;
240: /*
241: ** Create the the attributes title. Indent it to the level specified
242: */
243: wf_item_definition_util_pub.draw_summary_section_title(
244: wf_core.translate('WFITD_ATTRIBUTES'),
245: p_indent_level);
246:
247: /*
248: ** Print out all item attribute display names in the pl*sql table
266: END LOOP;
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: Wf_Core.Context('wf_item_attributes_vl_pub', 'draw_item_attribute_list');
271: wf_item_definition.Error;
272:
273: END draw_item_attribute_list;
274:
295: /*
296: ** Draw the section title for the item type detail section
297: */
298: wf_item_definition_util_pub.draw_detail_section_title (
299: wf_core.translate('WFITD_ATTRIBUTE_DETAILS'),
300: 0);
301:
302: /*
303: ** Print out all item attribute display names in the pl*sql table
308: ** Open a new table for each attribute so you can control the spacing
309: ** between each attribute
310: */
311: htp.tableOpen(cattributes=>'border=0 cellpadding=2 cellspacing=0
312: summary= "' || wf_core.translate('WFITD_ATTRIBUTE_DETAILS') || '"');
313:
314: /*
315: ** Create the target for the hotlink from the summary view. Also
316: ** create the first row in the table which is always the display
319: wf_item_definition_util_pub.create_details_hotlink_target (
320: 'ATTRIBUTE',
321: p_wf_item_attributes_vl_tbl(l_record_num).name,
322: p_wf_item_attributes_vl_tbl(l_record_num).display_name,
323: wf_core.translate('WFITD_ATTRIBUTE_NAME'),
324: 0);
325:
326: /*
327: ** Create the internal name row in the table.
326: /*
327: ** Create the internal name row in the table.
328: */
329: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
330: wf_core.translate('WFITD_INTERNAL_NAME'),
331: p_wf_item_attributes_vl_tbl(l_record_num).name);
332:
333: /*
334: ** Create the description row in the table
333: /*
334: ** Create the description row in the table
335: */
336: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
337: wf_core.translate('DESCRIPTION'),
338: p_wf_item_attributes_vl_tbl(l_record_num).description);
339:
340: /*
341: ** Create the attribute type row in the table. I've named the
343: ** WFITD_ATTR_TYPE_ to the type of resource and I get the
344: ** translated string.
345: */
346: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
347: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),
348: wf_core.translate('WFITD_ATTR_TYPE_'||
349: p_wf_item_attributes_vl_tbl(l_record_num).type));
350:
351: /*
344: ** translated string.
345: */
346: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
347: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),
348: wf_core.translate('WFITD_ATTR_TYPE_'||
349: p_wf_item_attributes_vl_tbl(l_record_num).type));
350:
351: /*
352: ** Create the length/format/lookup type row in the table.
357: */
358: IF (p_wf_item_attributes_vl_tbl(l_record_num).type = 'VARCHAR2') THEN
359:
360: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
361: wf_core.translate('LENGTH'),
362: p_wf_item_attributes_vl_tbl(l_record_num).format);
363:
364: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).type IN ('NUMBER', 'DATE')) THEN
365:
363:
364: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).type IN ('NUMBER', 'DATE')) THEN
365:
366: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
367: wf_core.translate('FORMAT'),
368: p_wf_item_attributes_vl_tbl(l_record_num).format);
369:
370: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).type IN ('URL','DOCUMENT')) THEN
371: /*
372: ** If it is URL or DOCUMENT, indicate where the resulting page should be displayed
373: */
374: IF (NVL(p_wf_item_attributes_vl_tbl(l_record_num).format, '_top') = '_top') THEN
375: wf_item_definition_util_pub.draw_detail_prompt_value_pair
376: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));
377: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_blank') THEN
378: wf_item_definition_util_pub.draw_detail_prompt_value_pair
379: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
380: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_self') THEN
375: wf_item_definition_util_pub.draw_detail_prompt_value_pair
376: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));
377: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_blank') THEN
378: wf_item_definition_util_pub.draw_detail_prompt_value_pair
379: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
380: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_self') THEN
381: wf_item_definition_util_pub.draw_detail_prompt_value_pair
382: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
383: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_parent') THEN
378: wf_item_definition_util_pub.draw_detail_prompt_value_pair
379: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
380: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_self') THEN
381: wf_item_definition_util_pub.draw_detail_prompt_value_pair
382: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
383: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_parent') THEN
384: wf_item_definition_util_pub.draw_detail_prompt_value_pair
385: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));
386: END IF;
381: wf_item_definition_util_pub.draw_detail_prompt_value_pair
382: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
383: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).format = '_parent') THEN
384: wf_item_definition_util_pub.draw_detail_prompt_value_pair
385: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));
386: END IF;
387:
388: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).type = 'LOOKUP') THEN
389:
387:
388: ELSIF (p_wf_item_attributes_vl_tbl(l_record_num).type = 'LOOKUP') THEN
389:
390: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
391: wf_core.translate('LOOKUP'),
392: p_wf_item_attributes_vl_tbl(l_record_num).lookup_type_display_name);
393:
394: END IF;
395:
402: */
403: IF (p_wf_item_attributes_vl_tbl(l_record_num).type = 'LOOKUP') THEN
404:
405: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
406: wf_core.translate('WFITD_DEFAULT_VALUE'),
407: p_wf_item_attributes_vl_tbl(l_record_num).lookup_code_display_name);
408:
409: ELSE
410:
408:
409: ELSE
410:
411: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
412: wf_core.translate('WFITD_DEFAULT_VALUE'),
413: NVL(p_wf_item_attributes_vl_tbl(l_record_num).text_default,
414: NVL(TO_CHAR(p_wf_item_attributes_vl_tbl(l_record_num).number_default),
415: TO_CHAR(p_wf_item_attributes_vl_tbl(l_record_num).date_default))));
416:
442: END LOOP;
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: Wf_Core.Context('wf_item_attributes_vl_pub', 'draw_item_attribute_details');
447: wf_item_definition.Error;
448:
449: END draw_item_attribute_details;
450: