APPS.HR_WORKFLOW_SS dependencies on WF_RUNNABLE_PROCESSES_V

Line 1810: return wf_runnable_processes_v.display_name%type

1806: end updateSFLTransaction;
1807:
1808: function getProcessDisplayName(itemtype in varchar2,
1809: itemkey in varchar2)
1810: return wf_runnable_processes_v.display_name%type
1811: is
1812: lv_display_name wf_runnable_processes_v.display_name%type;
1813: c_proc varchar2(30) default 'getProcessDisplayName';
1814:

Line 1812: lv_display_name wf_runnable_processes_v.display_name%type;

1808: function getProcessDisplayName(itemtype in varchar2,
1809: itemkey in varchar2)
1810: return wf_runnable_processes_v.display_name%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:

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

1818: if g_debug then
1819: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1820: end if;
1821: if g_debug then
1822: hr_utility.set_location('Querying wf_runnable_processes_v',11);
1823: hr_utility.set_location('ItemType:'||itemtype,12);
1824: hr_utility.set_location('ItemKey:'||itemkey,13);
1825: end if;
1826:

Line 1835: FROM wf_runnable_processes_v wrpv

1831: ignore_notfound=>true);
1832: if(lv_ntf_sub_msg is null) then
1833: SELECT wrpv.display_name displayName
1834: into getProcessDisplayName.lv_display_name
1835: FROM wf_runnable_processes_v wrpv
1836: WHERE wrpv.item_type = itemtype
1837: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1838: AND rownum <=1;
1839: else

Line 1916: lv_process_display_name wf_runnable_processes_v.display_name%type;

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