APPS.HR_APPROVAL_SS dependencies on WF_RUNNABLE_PROCESSES_V

Line 3848: return wf_runnable_processes_v.display_name%type is

3844: -- ----------------------------------------------------------------------------
3845: function wf_get_runnable_process_name
3846: (p_item_type in wf_items.item_type%type
3847: ,p_process_name in wf_process_activities.process_name%type)
3848: return wf_runnable_processes_v.display_name%type is
3849: -- cursor determines is the specified process is runnable
3850: cursor csr_wrpv is
3851: select wrpv.display_name
3852: from wf_runnable_processes_v wrpv

Line 3852: from wf_runnable_processes_v wrpv

3848: return wf_runnable_processes_v.display_name%type is
3849: -- cursor determines is the specified process is runnable
3850: cursor csr_wrpv is
3851: select wrpv.display_name
3852: from wf_runnable_processes_v wrpv
3853: where wrpv.item_type = p_item_type
3854: and wrpv.process_name = p_process_name;
3855: --
3856: l_display_name wf_runnable_processes_v.display_name%type;

Line 3856: l_display_name wf_runnable_processes_v.display_name%type;

3852: from wf_runnable_processes_v wrpv
3853: where wrpv.item_type = p_item_type
3854: and wrpv.process_name = p_process_name;
3855: --
3856: l_display_name wf_runnable_processes_v.display_name%type;
3857: --
3858: begin
3859: -- Determine if the specified process is runnable
3860: open csr_wrpv;

Line 4841: lv_process_display_name wf_runnable_processes_v.display_name%type;

4837: is
4838:
4839: l_creator_disp_name wf_users.display_name%type;
4840: l_aprv_routing_username varchar2(60);
4841: lv_process_display_name wf_runnable_processes_v.display_name%type;
4842: c_application_id integer;
4843: c_transaction_id varchar2(25);
4844: c_transaction_type varchar2(25);
4845: l_forward_from_display_name wf_users.display_name%type;