[Home] [Help]
219: l_date_created varchar2(30);
220: l_update_date varchar2(30);
221: l_updated_by varchar2(20);
222: l_created_by varchar2(20);
223: -- l_user_name wf_local_roles.name%type;
224: -- l_user_name varchar2(60); -- 3297591
225: l_user_name fnd_user.user_name%type; -- 5340008
226: l_expiration_date varchar2(30);
227: --l_display_name wf_local_roles.display_name%TYPE;;
223: -- l_user_name wf_local_roles.name%type;
224: -- l_user_name varchar2(60); -- 3297591
225: l_user_name fnd_user.user_name%type; -- 5340008
226: l_expiration_date varchar2(30);
227: --l_display_name wf_local_roles.display_name%TYPE;;
228: l_display_name varchar2(310); -- 3297591,4149356
229: l_update varchar(1) default 'Y'; -- Bug 4597033
230: --
231: -- cursors
231: -- cursors
232: --
233: cursor role_exists(p_person_id in number) is
234: select name
235: from wf_local_roles
236: where orig_system = 'PER'
237: and orig_system_id = p_person_id
238: and rownum = 1; -- This extra WHERE condition is added as per the request of "tpapired"
239: --
250: -- contingent worker to be taken care.
251: --
252: -- Bug fix 3883910
253: -- If condition to check whether the person is an employee or cwk
254: -- is removed, as wf_local_roles as to be updated for all persons.
255:
256: /* if (nvl(p_rec.current_employee_flag,'N') <>'Y'
257: and
258: nvl(p_rec.current_npw_flag,'N') <>'Y') then
659: --
660: l_proc varchar2(80) := g_package||'per_pds_wf';
661: l_date date;
662: l_parameters wf_parameter_list_t;
663: l_user_name wf_local_roles.name%type;
664: --
665: --
666: -- cursors
667: --
666: -- cursors
667: --
668: cursor role_exists(p_person_id in number) is
669: select name
670: from wf_local_roles
671: where orig_system = 'PER'
672: and orig_system_id = p_person_id
673: and rownum = 1; -- This extra WHERE condition is added as per the request of "tpapired"
674: --