APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on HR_GENERAL

Line 1151: l_effective_end_date date := hr_general.end_of_time;

1147: and ppt.system_person_type = 'OTHER' )));
1148:
1149: l_csr_upd_per_type_usages csr_upded_person_type_usages%rowtype;
1150:
1151: l_effective_end_date date := hr_general.end_of_time;
1152: begin
1153:
1154: hr_utility.set_location('Entering Upd_Person_Type_Usage_End_Date',491);
1155:

Line 1850: if l_person_end_date = hr_general.end_of_time then --#1998140

1846: fetch person into p_rowid, l_person_end_date;
1847: exit when person%notfound;
1848: if l_back2back
1849: then
1850: if l_person_end_date = hr_general.end_of_time then --#1998140
1851:
1852: select person_type_id into l_person_type_id
1853: from per_person_types
1854: where business_group_id = p_business_group_id

Line 1879: if l_person_end_date = hr_general.end_of_time then --#1998140

1875: end if;
1876:
1877: elsif l_pp_id is not null then -- 3194314
1878:
1879: if l_person_end_date = hr_general.end_of_time then --#1998140
1880:
1881: -- 3848352 start
1882: if hr_person_type_usage_info.is_person_of_type
1883: ( p_effective_date => p_date_start

Line 2689: if l_effective_end_date = hr_general.effective_date -1 then

2685: fetch new_people_b2b into l_rowid,l_effective_end_date,
2686: l_effective_start_date,l_current_applicant_flag;
2687: exit when new_people_b2b%notfound;
2688:
2689: if l_effective_end_date = hr_general.effective_date -1 then
2690: delete from per_people_f
2691: where rowid = l_rowid;
2692: elsif l_current_applicant_flag = 'Y' then
2693: -- Get the latest person Type Id to update the person table.

Line 2712: effective_end_date=hr_general.end_of_time

2708: set applicant_number = null,
2709: current_applicant_flag=null,
2710: current_emp_or_apl_flag=null,
2711: PERSON_TYPE_ID=l_person_type_id,
2712: effective_end_date=hr_general.end_of_time
2713: where rowid = l_rowid;
2714: end if;
2715: end if;
2716: --

Line 3269: l_end_of_time DATE := hr_general.end_of_time;

3265: --
3266: l_proc VARCHAR2(72) := g_package||'do_cancel_placement';
3267: --
3268: l_assignment_id NUMBER;
3269: l_end_of_time DATE := hr_general.end_of_time;
3270: l_effective_date DATE;
3271: l_rowid ROWID;
3272: l_dummy_id NUMBER;
3273: l_person_type_id NUMBER;

Line 3879: IF person_rec.effective_end_date = hr_general.end_of_time THEN

3875: IF l_pop_back_to_back THEN
3876: --
3877: hr_utility.set_location(l_proc,380);
3878: --
3879: IF person_rec.effective_end_date = hr_general.end_of_time THEN
3880: --
3881: hr_utility.set_location(l_proc,390);
3882: --
3883: OPEN csr_get_person_type (p_system_person_type => 'EX_CWK');

Line 3920: IF person_rec.effective_end_date = hr_general.end_of_time THEN

3916:
3917: ELSIF l_pos_back_to_back then -- 3194314
3918: -- this is a back-to-back with Employee/Cwk
3919:
3920: IF person_rec.effective_end_date = hr_general.end_of_time THEN
3921:
3922: -- it should restore the EX_EMP record instead of removing it
3923: hr_utility.set_location(l_proc,405);
3924: --