APPS.HR_APPROVAL_SS dependencies on WF_RUNNABLE_PROCESSES_V

Line 4875: return wf_runnable_processes_v.display_name%type is

4871: -- ----------------------------------------------------------------------------
4872: function wf_get_runnable_process_name
4873: (p_item_type in wf_items.item_type%type
4874: ,p_process_name in wf_process_activities.process_name%type)
4875: return wf_runnable_processes_v.display_name%type is
4876: -- cursor determines is the specified process is runnable
4877: cursor csr_wrpv is
4878: select wrpv.display_name
4879: from wf_runnable_processes_v wrpv

Line 4879: from wf_runnable_processes_v wrpv

4875: return wf_runnable_processes_v.display_name%type is
4876: -- cursor determines is the specified process is runnable
4877: cursor csr_wrpv is
4878: select wrpv.display_name
4879: from wf_runnable_processes_v wrpv
4880: where wrpv.item_type = p_item_type
4881: and wrpv.process_name = p_process_name;
4882: --
4883: l_display_name wf_runnable_processes_v.display_name%type;

Line 4883: l_display_name wf_runnable_processes_v.display_name%type;

4879: from wf_runnable_processes_v wrpv
4880: where wrpv.item_type = p_item_type
4881: and wrpv.process_name = p_process_name;
4882: --
4883: l_display_name wf_runnable_processes_v.display_name%type;
4884: --
4885: begin
4886: -- Determine if the specified process is runnable
4887: open csr_wrpv;

Line 5889: lv_process_display_name wf_runnable_processes_v.display_name%type;

5885: is
5886:
5887: l_creator_disp_name wf_users.display_name%type;
5888: l_aprv_routing_username varchar2(60);
5889: lv_process_display_name wf_runnable_processes_v.display_name%type;
5890: c_application_id integer;
5891: c_transaction_id varchar2(25);
5892: c_transaction_type varchar2(25);
5893: l_forward_from_display_name wf_users.display_name%type;