[Home] [Help]
41: WfItemKey in varchar2,
42: PersonId in out nocopy varchar2,
43: AssignmentId in out nocopy varchar2) is
44:
45: cursor csr_person is select person_id from per_all_people_f where person_id = PersonId;
46:
47: cursor csr_txn_step_id is
48: select trs.transaction_step_id
49: from hr_api_transaction_steps trs
60: l_session_c number;
61: l_transaction_step_id number;
62: l_business_grp_Id number;
63:
64: l_newUserPersonId per_all_people_f.person_id%type;
65: l_result varchar2(100);
66: l_proc varchar2(72) := g_package||'processNewUserTransaction';
67: --Added for the Bug 14158934
68: l_prof varchar2(10);
429: p_source in varchar2 default null) is
430:
431: l_person_id number;
432:
433: cursor csr_person is select person_id,person_type_id from per_all_people_f where person_id = l_person_id
434: and CURRENT_EMPLOYEE_FLAG = 'Y';
435:
436:
437: l_newUserPersonId per_all_people_f.person_id%type;
433: cursor csr_person is select person_id,person_type_id from per_all_people_f where person_id = l_person_id
434: and CURRENT_EMPLOYEE_FLAG = 'Y';
435:
436:
437: l_newUserPersonId per_all_people_f.person_id%type;
438: l_person_type_id number;
439: l_object_version_number number;
440: l_asg_object_version_number number;
441: l_per_effective_start_date date;
462: begin
463: savepoint ex_emp_process;
464: if csr_person%found then
465: begin
466: select max(object_version_number) into l_object_version_number from per_all_people_f
467: where person_id = l_person_id
468: and l_date between effective_start_date and effective_end_date; --Added the condition as a part of bug#13739532
469: exception
470: when others then