[Home] [Help]
2039: and ppt.system_person_type = 'OTHER' )));
2040:
2041: l_csr_upd_per_type_usages csr_upded_person_type_usages%rowtype;
2042:
2043: l_effective_end_date date := hr_general.end_of_time;
2044: begin
2045:
2046: hr_utility.set_location('Entering Upd_Person_Type_Usage_End_Date',491);
2047:
2800: fetch person into p_rowid, l_person_end_date;
2801: exit when person%notfound;
2802: if l_back2back
2803: then
2804: if l_person_end_date = hr_general.end_of_time then --#1998140
2805:
2806: select person_type_id into l_person_type_id
2807: from per_person_types
2808: where business_group_id = p_business_group_id
2860: end if;
2861:
2862: elsif l_pp_id is not null then -- 3194314
2863:
2864: if l_person_end_date = hr_general.end_of_time then --#1998140
2865:
2866: -- 3848352 start
2867: if hr_person_type_usage_info.is_person_of_type
2868: ( p_effective_date => p_date_start
3293: cursor chk_action_perform_date is
3294: select effective_start_date
3295: from per_people_f
3296: where person_id = p_person_id
3297: and effective_start_date = hr_general.effective_date;
3298:
3299: -- Bug 8405711: Cursor get the future records along with end-dated record
3300: -- on the previous day, in the case if the action performs on future date.
3301: cursor people_b2b_with_prev_record is
3302: select rowid,effective_end_date,effective_start_date,current_applicant_flag
3303: from per_people_f
3304: where person_id = p_person_id
3305: and (effective_start_date > p_date_received
3306: or effective_end_date = hr_general.effective_date - 1);
3307:
3308: --
3309: -- NEW CURSORS FOR CANCEL_APPL END
3310: --
3792: l_effective_start_date,l_current_applicant_flag;
3793: exit when new_people_b2b%notfound;
3794:
3795: --start changes for bug 8405711
3796: /* if l_effective_end_date = hr_general.effective_date -1 then
3797: delete from per_people_f
3798: where rowid = l_rowid;
3799: elsif */
3800: IF l_current_applicant_flag = 'Y' then
3809: set applicant_number = l_apl_number, --null, -- commented for fix of Bug#14156610
3810: current_applicant_flag=null,
3811: current_emp_or_apl_flag=DECODE (l_system_person_type,'EMP','Y',null),
3812: PERSON_TYPE_ID=l_person_type_id,
3813: effective_end_date=hr_general.end_of_time
3814: where rowid = l_rowid;
3815:
3816: -- Changes end for the bug 14156610
3817: --
3834: set applicant_number = null,
3835: current_applicant_flag=null,
3836: current_emp_or_apl_flag=DECODE (l_system_person_type,'EMP','Y',null),
3837: PERSON_TYPE_ID=l_person_type_id,
3838: effective_end_date=hr_general.end_of_time
3839: where rowid = l_rowid;
3840: end if;
3841: end if;*/
3842: --
4477: --
4478: l_proc VARCHAR2(72) := g_package||'do_cancel_placement';
4479: --
4480: l_assignment_id NUMBER;
4481: l_end_of_time DATE := hr_general.end_of_time;
4482: l_effective_date DATE;
4483: l_rowid ROWID;
4484: l_dummy_id NUMBER;
4485: l_person_type_id NUMBER;
5172: IF l_pop_back_to_back THEN
5173: --
5174: hr_utility.set_location(l_proc,380);
5175: --
5176: IF person_rec.effective_end_date = hr_general.end_of_time THEN
5177: --
5178: hr_utility.set_location(l_proc,390);
5179: --
5180: OPEN csr_get_person_type (p_system_person_type => 'EX_CWK');
5213:
5214: ELSIF l_pos_back_to_back then -- 3194314
5215: -- this is a back-to-back with Employee/Cwk
5216:
5217: IF person_rec.effective_end_date = hr_general.end_of_time THEN
5218:
5219: -- it should restore the EX_EMP record instead of removing it
5220: hr_utility.set_location(l_proc,405);
5221: --