DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SERVICE dependencies on WF_ITEM_ATTRIBUTES

Line 222: ,p_name in wf_item_attributes.name%type

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

Line 224: ,p_subtype out nocopy wf_item_attributes.subtype%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

Line 225: ,p_type out nocopy wf_item_attributes.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
229: ,p_text_value out nocopy wf_item_attribute_values.text_value%type) is

Line 226: ,p_format out nocopy wf_item_attributes.format%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
230: -- --------------------------------------------------------------------------

Line 233: l_type wf_item_attributes.type%type;

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

Line 234: l_name wf_item_attributes.name%type := upper(p_name);

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;