eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1253: lv_page wf_item_attribute_values.text_value%type;

1249: p_additional_params out nocopy varchar2 )is
1250: -- local variables
1251: lv_procedure_name varchar2(30) default 'getPageDetails';
1252: ln_activityId wf_item_activity_statuses.process_activity%type;
1253: lv_page wf_item_attribute_values.text_value%type;
1254: lv_page_type wf_item_attribute_values.text_value%type;
1255: ln_page_applicationId wf_item_attribute_values.number_value%type;
1256: lv_additional_params wf_item_attribute_values.text_value%type;
1257: BEGIN

Line 1254: lv_page_type wf_item_attribute_values.text_value%type;

1250: -- local variables
1251: lv_procedure_name varchar2(30) default 'getPageDetails';
1252: ln_activityId wf_item_activity_statuses.process_activity%type;
1253: lv_page wf_item_attribute_values.text_value%type;
1254: lv_page_type wf_item_attribute_values.text_value%type;
1255: ln_page_applicationId wf_item_attribute_values.number_value%type;
1256: lv_additional_params wf_item_attribute_values.text_value%type;
1257: BEGIN
1258: hr_utility.set_location(lv_procedure_name,1);

Line 1255: ln_page_applicationId wf_item_attribute_values.number_value%type;

1251: lv_procedure_name varchar2(30) default 'getPageDetails';
1252: ln_activityId wf_item_activity_statuses.process_activity%type;
1253: lv_page wf_item_attribute_values.text_value%type;
1254: lv_page_type wf_item_attribute_values.text_value%type;
1255: ln_page_applicationId wf_item_attribute_values.number_value%type;
1256: lv_additional_params wf_item_attribute_values.text_value%type;
1257: BEGIN
1258: hr_utility.set_location(lv_procedure_name,1);
1259: if(hr_utility.debug_enabled) then

Line 1256: lv_additional_params wf_item_attribute_values.text_value%type;

1252: ln_activityId wf_item_activity_statuses.process_activity%type;
1253: lv_page wf_item_attribute_values.text_value%type;
1254: lv_page_type wf_item_attribute_values.text_value%type;
1255: ln_page_applicationId wf_item_attribute_values.number_value%type;
1256: lv_additional_params wf_item_attribute_values.text_value%type;
1257: BEGIN
1258: hr_utility.set_location(lv_procedure_name,1);
1259: if(hr_utility.debug_enabled) then
1260: -- write debug statements

Line 1478: lv_pageFunc wf_item_attribute_values.text_value%type;

1474: lv_checkProfile VARCHAR2(10);
1475: lv_profileValue VARCHAR2(1);
1476: lv_status hr_api_transactions.status%type;
1477: lv_link_label wf_message_attributes_vl.display_name%type;
1478: lv_pageFunc wf_item_attribute_values.text_value%type;
1479: lv_web_html_call fnd_form_functions_vl.web_html_call%type;
1480: lv_params fnd_form_functions_vl.parameters%type;
1481: lv_addtnlParams VARCHAR2(30) ;
1482: lv_restrict_edit_to_owner varchar2(3);

Line 1857: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

1853: is
1854: lv_display_name wf_runnable_processes_v.display_name%type;
1855: c_proc varchar2(30) default 'getProcessDisplayName';
1856:
1857: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1858:
1859: begin
1860: if g_debug then
1861: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);

Line 1959: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

1955: l_current_person_id per_people_f.person_id%type;
1956: l_current_disp_name wf_users.display_name%type;
1957: l_current_username wf_users.name%type;
1958: lv_process_display_name wf_runnable_processes_v.display_name%type;
1959: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1960: lv_custom_callBack varchar2(60);
1961: l_sqlbuf Varchar2(1000);
1962:
1963: begin