APPS.HR_NL_EXTRA_ASG_RULES dependencies on FND_DATE

Line 748: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);

744:
745: IF p_scl_segment21 IS NULL then
746: l_commencing_date := NULL;
747: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then
748: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);
749: ELSE
750: l_commencing_date := hr_api.g_date;
751: END if;
752:

Line 756: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);

752:
753: IF p_scl_segment23 IS NULL then
754: l_date_ending := NULL;
755: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then
756: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);
757: ELSE
758: l_date_ending := hr_api.g_date;
759: END if;
760:

Line 933: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);

929: IF p_segment21 = hr_api.g_varchar2 THEN
930: open csr_get_date_details(p_assignment_id,p_effective_date);
931: hr_utility.trace('DATE1');
932: fetch csr_get_date_details into date_details_rec;
933: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);
934: close csr_get_date_details;
935: ELSE
936: l_commencing_date := fnd_date.canonical_to_date(p_segment21);
937: END IF;

Line 936: l_commencing_date := fnd_date.canonical_to_date(p_segment21);

932: fetch csr_get_date_details into date_details_rec;
933: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);
934: close csr_get_date_details;
935: ELSE
936: l_commencing_date := fnd_date.canonical_to_date(p_segment21);
937: END IF;
938:
939: IF p_segment23 = hr_api.g_varchar2 THEN
940: open csr_get_date_details(p_assignment_id,p_effective_date);

Line 942: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);

938:
939: IF p_segment23 = hr_api.g_varchar2 THEN
940: open csr_get_date_details(p_assignment_id,p_effective_date);
941: fetch csr_get_date_details into date_details_rec;
942: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);
943: close csr_get_date_details;
944: ELSE
945: l_date_ending := fnd_date.canonical_to_date(p_segment23);
946: END IF;

Line 945: l_date_ending := fnd_date.canonical_to_date(p_segment23);

941: fetch csr_get_date_details into date_details_rec;
942: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);
943: close csr_get_date_details;
944: ELSE
945: l_date_ending := fnd_date.canonical_to_date(p_segment23);
946: END IF;
947:
948: IF p_segment28 IS NULL THEN
949: l_ind_working_hrs := NULL;