APPS.PER_PQH_SHR dependencies on FND_DATE

Line 625: l_start_date := fnd_date.canonical_to_date(l_start_date_can);

621:
622: l_start_date_can := wf_event.getvalueforparameter( p_name => 'START_DATE',
623: p_parameterlist => my_parms);
624:
625: l_start_date := fnd_date.canonical_to_date(l_start_date_can);
626:
627: l_expiration_date_can := wf_event.getvalueforparameter( p_name => 'EXPIRATION_DATE',
628: p_parameterlist => my_parms);
629:

Line 630: l_expiration_date := fnd_date.canonical_to_date(l_expiration_date_can);

626:
627: l_expiration_date_can := wf_event.getvalueforparameter( p_name => 'EXPIRATION_DATE',
628: p_parameterlist => my_parms);
629:
630: l_expiration_date := fnd_date.canonical_to_date(l_expiration_date_can);
631:
632:
633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);
634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);

Line 846: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(p_rec.effective_start_date,l_usr_strt_date));

842:
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',

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 953: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(l_effective_start_date,l_usr_strt_date));

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);
952: l_position_id_canonical := fnd_number.number_to_canonical(l_position_id);
953: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(l_effective_start_date,l_usr_strt_date));
954: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(l_assg_end_date,l_usr_end_date));
955: l_old_position_id_can := fnd_number.number_to_canonical(l_old_pos_id);
956:
957: wf_event.addparametertolist(p_name => 'CONTEXT',

Line 954: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(l_assg_end_date,l_usr_end_date));

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);
952: l_position_id_canonical := fnd_number.number_to_canonical(l_position_id);
953: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(l_effective_start_date,l_usr_strt_date));
954: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(l_assg_end_date,l_usr_end_date));
955: l_old_position_id_can := fnd_number.number_to_canonical(l_old_pos_id);
956:
957: wf_event.addparametertolist(p_name => 'CONTEXT',
958: p_value => 'POSITION',