APPS.PQH_RLS_UPD dependencies on WF_PARAMETER_LIST_T

Line 311: l_plist wf_parameter_list_t;

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

Line 372: l_plist wf_parameter_list_t;

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