APPS.HR_WORKFLOW_SS dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 25: from wf_item_attribute_values wiav

21: ,p_item_key in varchar2
22: ,p_name in varchar2)
23: IS
24: select 1
25: from wf_item_attribute_values wiav
26: where wiav.item_type = p_item_type
27: and wiav.item_key = p_item_key
28: and wiav.name = p_name;
29:

Line 1211: lv_page wf_item_attribute_values.text_value%type;

1207: p_additional_params out nocopy varchar2 )is
1208: -- local variables
1209: lv_procedure_name varchar2(30) default 'getPageDetails';
1210: ln_activityId wf_item_activity_statuses.process_activity%type;
1211: lv_page wf_item_attribute_values.text_value%type;
1212: lv_page_type wf_item_attribute_values.text_value%type;
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;
1215: BEGIN

Line 1212: lv_page_type wf_item_attribute_values.text_value%type;

1208: -- local variables
1209: lv_procedure_name varchar2(30) default 'getPageDetails';
1210: ln_activityId wf_item_activity_statuses.process_activity%type;
1211: lv_page wf_item_attribute_values.text_value%type;
1212: lv_page_type wf_item_attribute_values.text_value%type;
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;
1215: BEGIN
1216: hr_utility.set_location(lv_procedure_name,1);

Line 1213: ln_page_applicationId wf_item_attribute_values.number_value%type;

1209: lv_procedure_name varchar2(30) default 'getPageDetails';
1210: ln_activityId wf_item_activity_statuses.process_activity%type;
1211: lv_page wf_item_attribute_values.text_value%type;
1212: lv_page_type wf_item_attribute_values.text_value%type;
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;
1215: BEGIN
1216: hr_utility.set_location(lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then

Line 1214: lv_additional_params wf_item_attribute_values.text_value%type;

1210: ln_activityId wf_item_activity_statuses.process_activity%type;
1211: lv_page wf_item_attribute_values.text_value%type;
1212: lv_page_type wf_item_attribute_values.text_value%type;
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;
1215: BEGIN
1216: hr_utility.set_location(lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements

Line 1436: lv_pageFunc wf_item_attribute_values.text_value%type;

1432: lv_checkProfile VARCHAR2(10);
1433: lv_profileValue VARCHAR2(1);
1434: lv_status hr_api_transactions.status%type;
1435: lv_link_label wf_message_attributes_vl.display_name%type;
1436: lv_pageFunc wf_item_attribute_values.text_value%type;
1437: lv_web_html_call fnd_form_functions_vl.web_html_call%type;
1438: lv_params fnd_form_functions_vl.parameters%type;
1439: lv_addtnlParams VARCHAR2(30) ;
1440: lv_restrict_edit_to_owner varchar2(3);

Line 1815: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

1811: is
1812: lv_display_name wf_runnable_processes_v.display_name%type;
1813: c_proc varchar2(30) default 'getProcessDisplayName';
1814:
1815: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1816:
1817: begin
1818: if g_debug then
1819: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);

Line 1917: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

1913: l_current_person_id per_people_f.person_id%type;
1914: l_current_disp_name wf_users.display_name%type;
1915: l_current_username wf_users.name%type;
1916: lv_process_display_name wf_runnable_processes_v.display_name%type;
1917: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1918: lv_custom_callBack varchar2(60);
1919: l_sqlbuf Varchar2(1000);
1920:
1921: begin