APPS.PER_PQH_SHR dependencies on HR_GENERAL

Line 33: and nvl(ver.date_to, hr_general.end_of_time);

29: ver.organization_structure_id = str.organization_structure_id
30: and str.business_group_id = p_business_group_id
31: and str.position_control_structure_flg='Y'
32: and nvl(p_effective_date, sysdate) between ver.date_from
33: and nvl(ver.date_to, hr_general.end_of_time);
34: --
35: --
36: cursor c_assignment(p_assignment_id number, p_effective_date date) is
37: select organization_id, business_group_id

Line 659: p_start_date => hr_general.end_of_time,

655: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => l_user_orig_system,
656: p_user_orig_system_id => l_user_orig_system_id,
657: p_role_orig_system => l_role_orig_system,
658: p_role_orig_system_id => l_role_orig_system_id,
659: p_start_date => hr_general.end_of_time,
660: p_expiration_date => hr_general.end_of_time);
661: hr_utility.set_location(l_proc,170);
662: else
663:

Line 660: p_expiration_date => hr_general.end_of_time);

656: p_user_orig_system_id => l_user_orig_system_id,
657: p_role_orig_system => l_role_orig_system,
658: p_role_orig_system_id => l_role_orig_system_id,
659: p_start_date => hr_general.end_of_time,
660: p_expiration_date => hr_general.end_of_time);
661: hr_utility.set_location(l_proc,170);
662: else
663:
664: /* Below call to Wf_Directory.DeleteUserRole is to deleted already end-dated old POS - PER relation.

Line 838: p_expiration_date => least(p_rec.effective_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));

834: p_user_orig_system_id => p_rec.person_id,
835: p_role_orig_system => 'POS',
836: p_role_orig_system_id => l_old_pos_id,
837: p_start_date => greatest(p_rec.effective_start_date,l_usr_strt_date),
838: p_expiration_date => least(p_rec.effective_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));
839:
840: elsif (trunc(p_rec.effective_start_date) > trunc(sysdate) and trunc(p_rec.effective_end_date) >= trunc(sysdate))
841: then
842:

Line 847: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(p_rec.effective_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));

843: l_per_id_can := fnd_number.number_to_canonical(p_rec.person_id);
844: l_assignment_id_canonical := fnd_number.number_to_canonical(l_assignment_id);
845: l_position_id_canonical := fnd_number.number_to_canonical(l_position_id);
846: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(p_rec.effective_start_date,l_usr_strt_date));
847: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(p_rec.effective_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));
848:
849:
850: wf_event.addparametertolist(p_name => 'CONTEXT',
851: p_value => 'POSITION',

Line 947: p_expiration_date => least(l_assg_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));

943: p_user_orig_system_id => p_rec.person_id,
944: p_role_orig_system => 'POS',
945: p_role_orig_system_id => l_position_id,
946: p_start_date => l_assg_start_date,
947: p_expiration_date => least(l_assg_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));
948: else -- below call is to queue and call back later on appropriate date as the start date is in the future
949: hr_utility.set_location(l_proc,95);
950: l_per_id_can := fnd_number.number_to_canonical(p_rec.person_id);
951: l_assignment_id_canonical := fnd_number.number_to_canonical(l_assignment_id);