DBA Data[Home] [Help]

APPS.PQH_RLS_UPD dependencies on WF_PARAMETER_LIST_T

Line 312: l_plist wf_parameter_list_t;

308: and p_rec.enable_flag = 'Y' then
309: hr_utility.set_location('Role enabled'||l_proc,10);
310: declare
311: l_user_name varchar2(50);
312: l_plist wf_parameter_list_t;
313: cursor c1 is
314: select ppei.person_id,usr.user_name
315: from
316: per_people_extra_info ppei,

Line 368: l_plist wf_parameter_list_t;

364: elsif nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'
365: and p_rec.enable_flag = 'N' then
366: hr_utility.set_location('role being disabled '||l_proc, 30);
367: declare
368: l_plist wf_parameter_list_t;
369: --
370: cursor c0 is
371: select *
372: from wf_local_user_roles