[Home] [Help]
27: -- ----------------------------------------------------------------------------
28: function item_attribute_exists
29: (p_item_type in wf_items.item_type%type
30: ,p_item_key in wf_items.item_key%type
31: ,p_name in wf_item_attribute_values.name%type)
32: return boolean is
33: -- --------------------------------------------------------------------------
34: -- declare local variables
35: -- --------------------------------------------------------------------------
37: l_return boolean := TRUE;
38: -- cursor determines if an attribute exists
39: cursor csr_wiav is
40: select 1
41: from wf_item_attribute_values wiav
42: where wiav.item_type = p_item_type
43: and wiav.item_key = p_item_key
44: and wiav.name = p_name;
45: --
289: lv_checkProfile VARCHAR2(10);
290: lv_profileValue VARCHAR2(1);
291: lv_status hr_api_transactions.status%type;
292: lv_link_label wf_message_attributes_vl.display_name%type;
293: lv_pageFunc wf_item_attribute_values.text_value%type;
294: lv_web_html_call fnd_form_functions_vl.web_html_call%type;
295: lv_params fnd_form_functions_vl.parameters%type;
296: lv_addtnlParams VARCHAR2(30) ;
297:
548: funcmode in varchar2,
549: resultout in out nocopy varchar2)
550: is
551: --local variables
552: lv_participants_list wf_item_attribute_values.text_value%type default '';
553: ln_particpant_person_id varchar2(100);
554: lv_particpant_user_name varchar2(320);
555: lv_particpant_display_name varchar2(360);
556: check_sep number;
624: funcmode in varchar2,
625: resultout in out nocopy varchar2)
626: is
627: --local variables
628: ln_participant_person_id wf_item_attribute_values.number_value%type ;
629: lv_particpant_user_name varchar2(320);
630: lv_particpant_display_name varchar2(360);
631: lv_participant_type per_participants.participation_type%type;
632: ln_participant_id per_participants.participant_id%type;