APPS.HR_WORKFLOW_SS dependencies on WF_RUNNABLE_PROCESSES_V

Line 1852: return wf_runnable_processes_v.display_name%type

1848: end updateSFLTransaction;
1849:
1850: function getProcessDisplayName(itemtype in varchar2,
1851: itemkey in varchar2)
1852: return wf_runnable_processes_v.display_name%type
1853: is
1854: lv_display_name wf_runnable_processes_v.display_name%type;
1855: c_proc varchar2(30) default 'getProcessDisplayName';
1856:

Line 1854: lv_display_name wf_runnable_processes_v.display_name%type;

1850: function getProcessDisplayName(itemtype in varchar2,
1851: itemkey in varchar2)
1852: return wf_runnable_processes_v.display_name%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:

Line 1864: hr_utility.set_location('Querying wf_runnable_processes_v',11);

1860: if g_debug then
1861: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1862: end if;
1863: if g_debug then
1864: hr_utility.set_location('Querying wf_runnable_processes_v',11);
1865: hr_utility.set_location('ItemType:'||itemtype,12);
1866: hr_utility.set_location('ItemKey:'||itemkey,13);
1867: end if;
1868:

Line 1877: FROM wf_runnable_processes_v wrpv

1873: ignore_notfound=>true);
1874: if(lv_ntf_sub_msg is null) then
1875: SELECT wrpv.display_name displayName
1876: into getProcessDisplayName.lv_display_name
1877: FROM wf_runnable_processes_v wrpv
1878: WHERE wrpv.item_type = itemtype
1879: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1880: AND rownum <=1;
1881: else

Line 1958: lv_process_display_name wf_runnable_processes_v.display_name%type;

1954: l_creator_username wf_users.name%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: