DBA Data[Home] [Help]

APPS.SSP_MAT_BUS dependencies on FND_DATE

Line 257: and (p_ewc - 28) <= nvl(paa.sickness_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00'))

253: paa.sickness_end_date
254: from per_absence_attendances paa
255: where paa.person_id = p_person_id
256: and paa.pregnancy_related_illness = 'Y'
257: and (p_ewc - 28) <= nvl(paa.sickness_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00'))
258: and p_ewc >= paa.sickness_start_date;
259: --
260: l_pregnancy_related_illness pregnancy_related_absences%ROWTYPE;
261: -- bug 2649315, translation fix

Line 277: if p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and

273: -- within four weeks of the EWC
274: --
275: -- this conditions checks if the baby is born earlier then the mpp start date
276: -- if yes then it allows the mpp start date to be ABD + 1 else raises the error.
277: if p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and
278: (p_prev_mpp_start_date is null or p_actual_birth_date < p_prev_mpp_start_date) and
279: p_actual_birth_date is not null then
280: if p_mpp_start_date = p_actual_birth_date + 1 then
281: CLOSE pregnancy_related_absences;

Line 283: elsif p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and

279: p_actual_birth_date is not null then
280: if p_mpp_start_date = p_actual_birth_date + 1 then
281: CLOSE pregnancy_related_absences;
282: null;
283: elsif p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and
284: p_actual_birth_date > p_prev_mpp_start_date and
285: p_actual_birth_date is not null then
286: -- user cannot reset the value of MPP
287: if p_prev_mpp_start_date <> p_mpp_start_date then

Line 291: elsif ( p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')

287: if p_prev_mpp_start_date <> p_mpp_start_date then
288: fnd_message.set_name('SSP','SSP_36078_MPP_RESET_MPP');
289: fnd_message.raise_error;
290: end if;
291: elsif ( p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')
292: and p_mpp_start_date = p_actual_birth_date + 1 ) or
293: ( pregnancy_related_absences%FOUND and
294: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date ) then
295: CLOSE pregnancy_related_absences;

Line 298: elsif ( p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and

294: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date ) then
295: CLOSE pregnancy_related_absences;
296: null;
297: -- Bug 3944196 - additional check
298: elsif ( p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and
299: p_actual_birth_date + 1 = p_prev_mpp_start_date and
300: p_actual_birth_date is not null) then
301: CLOSE pregnancy_related_absences;
302: null;

Line 328: elsif p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and

324: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date + 1 then
325: CLOSE pregnancy_related_absences;
326: null;
327: -- end bug fix 5331152
328: elsif p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and
329: p_actual_birth_date is not null and
330: p_mpp_start_date <> p_actual_birth_date + 1 then
331: CLOSE pregnancy_related_absences;
332: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');

Line 336: p_due_date < fnd_date.canonical_to_date('2007/04/01 00:00:00') then

332: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');
333: fnd_message.raise_error;
334: elsif to_char(to_date(to_char(p_mpp_start_date,'DD/MM/YYYY'),'DD/MM/YYYY'),'fmDAY') <> l_sunday
335: and
336: p_due_date < fnd_date.canonical_to_date('2007/04/01 00:00:00') then
337: CLOSE pregnancy_related_absences;
338: fnd_message.set_name('SSP','SSP_35054_MPP_NOT_SUNDAY');
339: fnd_message.raise_error;
340: end if;

Line 838: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information1));

834: end if;
835: --
836:
837:
838: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information1));
839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));
840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));

Line 839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));

835: --
836:
837:
838: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information1));
839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));
840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));

Line 840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));

836:
837:
838: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information1));
839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));
840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));

Line 841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));

837:
838: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information1));
839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));
840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));

Line 842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));

838: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information1));
839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));
840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));
846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));

Line 843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));

839: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information2));
840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));
846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));
847: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information10));

Line 844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));

840: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information3));
841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));
846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));
847: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information10));
848: end if;

Line 845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));

841: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information4));
842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));
846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));
847: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information10));
848: end if;
849: END check_kit_days;

Line 846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));

842: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information5));
843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));
846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));
847: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information10));
848: end if;
849: END check_kit_days;
850: --------------------------------------------------------------------------------

Line 847: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information10));

843: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information6));
844: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information7));
845: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information8));
846: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information9));
847: validate_kit(l_start_date,l_end_date,fnd_date.canonical_to_date(p_rec.mat_information10));
848: end if;
849: END check_kit_days;
850: --------------------------------------------------------------------------------
851: -- ----------------------------------------------------------------------------