APPS.HR_NL_EXTRA_ASG_RULES dependencies on FND_DATE

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

844:
845: IF p_scl_segment21 IS NULL then
846: l_commencing_date := NULL;
847: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then
848: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);
849: ELSE
850: l_commencing_date := hr_api.g_date;
851: END if;
852:

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

852:
853: IF p_scl_segment23 IS NULL then
854: l_date_ending := NULL;
855: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then
856: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);
857: ELSE
858: l_date_ending := hr_api.g_date;
859: END if;
860:

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

1030: IF p_segment21 = hr_api.g_varchar2 THEN
1031: open csr_get_date_details(p_assignment_id,p_effective_date);
1032: hr_utility.trace('DATE1');
1033: fetch csr_get_date_details into date_details_rec;
1034: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);
1035: close csr_get_date_details;
1036: ELSE
1037: l_commencing_date := fnd_date.canonical_to_date(p_segment21);
1038: END IF;

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

1033: fetch csr_get_date_details into date_details_rec;
1034: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);
1035: close csr_get_date_details;
1036: ELSE
1037: l_commencing_date := fnd_date.canonical_to_date(p_segment21);
1038: END IF;
1039:
1040: IF p_segment23 = hr_api.g_varchar2 THEN
1041: open csr_get_date_details(p_assignment_id,p_effective_date);

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

1039:
1040: IF p_segment23 = hr_api.g_varchar2 THEN
1041: open csr_get_date_details(p_assignment_id,p_effective_date);
1042: fetch csr_get_date_details into date_details_rec;
1043: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);
1044: close csr_get_date_details;
1045: ELSE
1046: l_date_ending := fnd_date.canonical_to_date(p_segment23);
1047: END IF;

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

1042: fetch csr_get_date_details into date_details_rec;
1043: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);
1044: close csr_get_date_details;
1045: ELSE
1046: l_date_ending := fnd_date.canonical_to_date(p_segment23);
1047: END IF;
1048:
1049: IF p_segment28 IS NULL THEN
1050: l_ind_working_hrs := NULL;