218: -- ----------------------------------------------------------------------------
219: procedure get_item_attr_expanded_info
220: (p_item_type in wf_items.item_type%type
221: ,p_item_key in wf_items.item_key%type
222: ,p_name in wf_item_attributes.name%type
223: ,p_exists out nocopy boolean
224: ,p_subtype out nocopy wf_item_attributes.subtype%type
225: ,p_type out nocopy wf_item_attributes.type%type
226: ,p_format out nocopy wf_item_attributes.format%type
220: (p_item_type in wf_items.item_type%type
221: ,p_item_key in wf_items.item_key%type
222: ,p_name in wf_item_attributes.name%type
223: ,p_exists out nocopy boolean
224: ,p_subtype out nocopy wf_item_attributes.subtype%type
225: ,p_type out nocopy wf_item_attributes.type%type
226: ,p_format out nocopy wf_item_attributes.format%type
227: ,p_date_value out nocopy wf_item_attribute_values.date_value%type
228: ,p_number_value out nocopy wf_item_attribute_values.number_value%type
221: ,p_item_key in wf_items.item_key%type
222: ,p_name in wf_item_attributes.name%type
223: ,p_exists out nocopy boolean
224: ,p_subtype out nocopy wf_item_attributes.subtype%type
225: ,p_type out nocopy wf_item_attributes.type%type
226: ,p_format out nocopy wf_item_attributes.format%type
227: ,p_date_value out nocopy wf_item_attribute_values.date_value%type
228: ,p_number_value out nocopy wf_item_attribute_values.number_value%type
229: ,p_text_value out nocopy wf_item_attribute_values.text_value%type) is
222: ,p_name in wf_item_attributes.name%type
223: ,p_exists out nocopy boolean
224: ,p_subtype out nocopy wf_item_attributes.subtype%type
225: ,p_type out nocopy wf_item_attributes.type%type
226: ,p_format out nocopy wf_item_attributes.format%type
227: ,p_date_value out nocopy wf_item_attribute_values.date_value%type
228: ,p_number_value out nocopy wf_item_attribute_values.number_value%type
229: ,p_text_value out nocopy wf_item_attribute_values.text_value%type) is
230: -- --------------------------------------------------------------------------
229: ,p_text_value out nocopy wf_item_attribute_values.text_value%type) is
230: -- --------------------------------------------------------------------------
231: -- declare local variables
232: -- --------------------------------------------------------------------------
233: l_type wf_item_attributes.type%type;
234: l_name wf_item_attributes.name%type := upper(p_name);
235: --
236: begin
237: -- initialise the OUT parameters
230: -- --------------------------------------------------------------------------
231: -- declare local variables
232: -- --------------------------------------------------------------------------
233: l_type wf_item_attributes.type%type;
234: l_name wf_item_attributes.name%type := upper(p_name);
235: --
236: begin
237: -- initialise the OUT parameters
238: p_exists := true;