eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FI_VALIDATE_PKG dependencies on FND_DATE

Line 49: l_date:= fnd_date.canonical_to_date(p_per_information8);

45: hr_utility.raise_error;
46: END IF;
47: IF p_date_of_birth IS NOT NULL AND p_per_information8 IS NOT NULL THEN
48: BEGIN
49: l_date:= fnd_date.canonical_to_date(p_per_information8);
50: IF p_date_of_birth >= l_date THEN
51: fnd_message.set_name('PER', 'HR_376609_FI_INVALID_DATE');
52: hr_utility.raise_error;
53: END IF;

Line 441: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND

437: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
438: AND ou.organization_id = hoi.organization_id
439: AND ou.organization_id = nvl(p_organization_id , 0)
440: AND ou.business_group_id = l_business_group_id
441: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

Line 442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

438: AND ou.organization_id = hoi.organization_id
439: AND ou.organization_id = nvl(p_organization_id , 0)
440: AND ou.business_group_id = l_business_group_id
441: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND

439: AND ou.organization_id = nvl(p_organization_id , 0)
440: AND ou.business_group_id = l_business_group_id
441: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

Line 444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

440: AND ou.business_group_id = l_business_group_id
441: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

Line 445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

441: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
449:

Line 446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

442: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
449:
450: CURSOR c_ins_lu_ap_dtls IS

Line 447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

443: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
449:
450: CURSOR c_ins_lu_ap_dtls IS
451: SELECT COUNT(*)

Line 448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

444: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
445: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
446: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
447: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
449:
450: CURSOR c_ins_lu_ap_dtls IS
451: SELECT COUNT(*)
452: FROM hr_organization_information hoi, hr_organization_units ou

Line 457: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND

453: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
454: AND ou.organization_id = hoi.organization_id
455: AND ou.organization_id = nvl(p_organization_id , 0)
456: AND ou.business_group_id = l_business_group_id
457: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

Line 458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

454: AND ou.organization_id = hoi.organization_id
455: AND ou.organization_id = nvl(p_organization_id , 0)
456: AND ou.business_group_id = l_business_group_id
457: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND

455: AND ou.organization_id = nvl(p_organization_id , 0)
456: AND ou.business_group_id = l_business_group_id
457: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

Line 460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

456: AND ou.business_group_id = l_business_group_id
457: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

Line 461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

457: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
465:

Line 462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

458: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
465:
466: CURSOR c_ins_pp_user_pt IS

Line 463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

459: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
465:
466: CURSOR c_ins_pp_user_pt IS
467: SELECT COUNT(*)

Line 464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

460: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
461: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
462: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
463: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
465:
466: CURSOR c_ins_pp_user_pt IS
467: SELECT COUNT(*)
468: FROM hr_organization_information hoi, hr_organization_units ou

Line 698: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN

694:
695:
696: IF p_org_information2 IS NOT NULL THEN
697:
698: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
699: RAISE INVALID_DATE ;
700: END IF;
701:
702: END IF;

Line 899: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN

895: IF p_org_info_type_code = 'FI_ACCIDENT_PROVIDERS' THEN
896:
897: IF p_org_information2 IS NOT NULL THEN
898:
899: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
900: RAISE INVALID_DATE ;
901: END IF;
902:
903: END IF;

Line 939: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN

935: IF p_org_info_type_code = 'FI_LU_ACCIDENT_PROVIDERS' THEN
936:
937: IF p_org_information2 IS NOT NULL THEN
938:
939: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
940: RAISE INVALID_DATE ;
941: END IF;
942:
943: END IF;

Line 1276: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND

1272: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
1273: AND ou.organization_id = hoi.organization_id
1274: AND ou.organization_id = nvl(l_organization_id , 0)
1275: AND ou.business_group_id = l_business_group_id
1276: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

Line 1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1273: AND ou.organization_id = hoi.organization_id
1274: AND ou.organization_id = nvl(l_organization_id , 0)
1275: AND ou.business_group_id = l_business_group_id
1276: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND

1274: AND ou.organization_id = nvl(l_organization_id , 0)
1275: AND ou.business_group_id = l_business_group_id
1276: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

Line 1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1275: AND ou.business_group_id = l_business_group_id
1276: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1283: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))

Line 1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

1276: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1283: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1284: AND hoi.org_information_id <> p_org_information_id ;

Line 1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1277: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1283: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1284: AND hoi.org_information_id <> p_org_information_id ;
1285:

Line 1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

1278: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1283: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1284: AND hoi.org_information_id <> p_org_information_id ;
1285:
1286: CURSOR c_upd_lu_ap_dtls IS

Line 1283: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))

1279: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1280: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1281: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1282: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1283: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1284: AND hoi.org_information_id <> p_org_information_id ;
1285:
1286: CURSOR c_upd_lu_ap_dtls IS
1287: SELECT COUNT(*)

Line 1293: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND

1289: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
1290: AND ou.organization_id = hoi.organization_id
1291: AND ou.organization_id = nvl(l_organization_id , 0)
1292: AND ou.business_group_id = l_business_group_id
1293: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

Line 1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1290: AND ou.organization_id = hoi.organization_id
1291: AND ou.organization_id = nvl(l_organization_id , 0)
1292: AND ou.business_group_id = l_business_group_id
1293: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND

1291: AND ou.organization_id = nvl(l_organization_id , 0)
1292: AND ou.business_group_id = l_business_group_id
1293: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

Line 1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1292: AND ou.business_group_id = l_business_group_id
1293: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1300: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))

Line 1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

1293: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1300: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1301: AND hoi.org_information_id <> p_org_information_id ;

Line 1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1294: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1300: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1301: AND hoi.org_information_id <> p_org_information_id ;
1302:

Line 1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND

1295: OR ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hoi.org_information1) AND
1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1300: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1301: AND hoi.org_information_id <> p_org_information_id ;
1302:
1303:

Line 1300: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))

1296: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1297: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1298: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1299: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information1) AND
1300: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1301: AND hoi.org_information_id <> p_org_information_id ;
1302:
1303:
1304:

Line 1542: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN

1538:
1539:
1540: IF p_org_information2 IS NOT NULL THEN
1541:
1542: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
1543: RAISE INVALID_DATE ;
1544: END IF;
1545:
1546: END IF;

Line 1742: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN

1738:
1739:
1740: IF p_org_information2 IS NOT NULL THEN
1741:
1742: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
1743: RAISE INVALID_DATE ;
1744: END IF;
1745:
1746: END IF;

Line 1783: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN

1779:
1780:
1781: IF p_org_information2 IS NOT NULL THEN
1782:
1783: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
1784: RAISE INVALID_DATE ;
1785: END IF;
1786:
1787: END IF;

Line 2330: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN

2326: OPEN get_start_date(p_person_id);
2327: FETCH get_start_date into l_start_date;
2328: CLOSE get_start_date;
2329:
2330: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2331: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2332: hr_utility.raise_error;
2333: END IF;
2334: END IF;

Line 2383: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN

2379: OPEN get_start_date(l_person_id);
2380: FETCH get_start_date into l_start_date;
2381: CLOSE get_start_date;
2382:
2383: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2384: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2385: hr_utility.raise_error;
2386: END IF;
2387: END IF;