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 44: l_date:= fnd_date.canonical_to_date(p_per_information8);

40: hr_utility.raise_error;
41: END IF;
42: IF p_date_of_birth IS NOT NULL AND p_per_information8 IS NOT NULL THEN
43: BEGIN
44: l_date:= fnd_date.canonical_to_date(p_per_information8);
45: IF p_date_of_birth >= l_date THEN
46: fnd_message.set_name('PER', 'HR_376609_FI_INVALID_DATE');
47: hr_utility.raise_error;
48: END IF;

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

432: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
433: AND ou.organization_id = hoi.organization_id
434: AND ou.organization_id = nvl(p_organization_id , 0)
435: AND ou.business_group_id = l_business_group_id
436: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
437: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

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

433: AND ou.organization_id = hoi.organization_id
434: AND ou.organization_id = nvl(p_organization_id , 0)
435: AND ou.business_group_id = l_business_group_id
436: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
437: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 438: 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

434: AND ou.organization_id = nvl(p_organization_id , 0)
435: AND ou.business_group_id = l_business_group_id
436: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
437: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
442: 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 439: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

435: AND ou.business_group_id = l_business_group_id
436: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
437: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
442: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

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

436: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
437: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
442: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
444:

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

437: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
442: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
444:
445: CURSOR c_ins_lu_ap_dtls IS

Line 442: 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

438: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
442: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
444:
445: CURSOR c_ins_lu_ap_dtls IS
446: SELECT COUNT(*)

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

439: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
440: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
441: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
442: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
444:
445: CURSOR c_ins_lu_ap_dtls IS
446: SELECT COUNT(*)
447: FROM hr_organization_information hoi, hr_organization_units ou

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

448: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
449: AND ou.organization_id = hoi.organization_id
450: AND ou.organization_id = nvl(p_organization_id , 0)
451: AND ou.business_group_id = l_business_group_id
452: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
453: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

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

449: AND ou.organization_id = hoi.organization_id
450: AND ou.organization_id = nvl(p_organization_id , 0)
451: AND ou.business_group_id = l_business_group_id
452: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
453: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 454: 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

450: AND ou.organization_id = nvl(p_organization_id , 0)
451: AND ou.business_group_id = l_business_group_id
452: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
453: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
458: 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 455: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

451: AND ou.business_group_id = l_business_group_id
452: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
453: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
458: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

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

452: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
453: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
458: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
460:

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

453: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
458: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
460:
461: CURSOR c_ins_pp_user_pt IS

Line 458: 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

454: 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: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
458: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
460:
461: CURSOR c_ins_pp_user_pt IS
462: SELECT COUNT(*)

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

455: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
456: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
457: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
458: 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: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
460:
461: CURSOR c_ins_pp_user_pt IS
462: SELECT COUNT(*)
463: FROM hr_organization_information hoi, hr_organization_units ou

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

689:
690:
691: IF p_org_information2 IS NOT NULL THEN
692:
693: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
694: RAISE INVALID_DATE ;
695: END IF;
696:
697: END IF;

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

889: IF p_org_info_type_code = 'FI_ACCIDENT_PROVIDERS' THEN
890:
891: IF p_org_information2 IS NOT NULL THEN
892:
893: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
894: RAISE INVALID_DATE ;
895: END IF;
896:
897: END IF;

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

927: IF p_org_info_type_code = 'FI_LU_ACCIDENT_PROVIDERS' THEN
928:
929: IF p_org_information2 IS NOT NULL THEN
930:
931: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
932: RAISE INVALID_DATE ;
933: END IF;
934:
935: END IF;

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

1258: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
1259: AND ou.organization_id = hoi.organization_id
1260: AND ou.organization_id = nvl(l_organization_id , 0)
1261: AND ou.business_group_id = l_business_group_id
1262: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1263: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

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

1259: AND ou.organization_id = hoi.organization_id
1260: AND ou.organization_id = nvl(l_organization_id , 0)
1261: AND ou.business_group_id = l_business_group_id
1262: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1263: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 1264: 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

1260: AND ou.organization_id = nvl(l_organization_id , 0)
1261: AND ou.business_group_id = l_business_group_id
1262: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1263: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1268: 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 1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1261: AND ou.business_group_id = l_business_group_id
1262: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1263: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1268: 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
1269: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))

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

1262: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1263: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1268: 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
1269: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1270: AND hoi.org_information_id <> p_org_information_id ;

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

1263: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1268: 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
1269: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1270: AND hoi.org_information_id <> p_org_information_id ;
1271:

Line 1268: 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

1264: 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
1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1268: 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
1269: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1270: AND hoi.org_information_id <> p_org_information_id ;
1271:
1272: CURSOR c_upd_lu_ap_dtls IS

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

1265: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1266: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1267: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1268: 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
1269: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1270: AND hoi.org_information_id <> p_org_information_id ;
1271:
1272: CURSOR c_upd_lu_ap_dtls IS
1273: SELECT COUNT(*)

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

1275: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
1276: AND ou.organization_id = hoi.organization_id
1277: AND ou.organization_id = nvl(l_organization_id , 0)
1278: AND ou.business_group_id = l_business_group_id
1279: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1280: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND

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

1276: AND ou.organization_id = hoi.organization_id
1277: AND ou.organization_id = nvl(l_organization_id , 0)
1278: AND ou.business_group_id = l_business_group_id
1279: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1280: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))

Line 1281: 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

1277: AND ou.organization_id = nvl(l_organization_id , 0)
1278: AND ou.business_group_id = l_business_group_id
1279: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1280: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1285: 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 1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))

1278: AND ou.business_group_id = l_business_group_id
1279: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1280: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1285: 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
1286: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))

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

1279: AND (( fnd_date.canonical_to_date(p_org_information1) between fnd_date.canonical_to_date(hoi.org_information1) AND
1280: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1285: 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
1286: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1287: AND hoi.org_information_id <> p_org_information_id ;

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

1280: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1285: 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
1286: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1287: AND hoi.org_information_id <> p_org_information_id ;
1288:

Line 1285: 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

1281: 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
1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1285: 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
1286: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1287: AND hoi.org_information_id <> p_org_information_id ;
1288:
1289:

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

1282: nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1283: OR ( fnd_date.canonical_to_date(hoi.org_information1) between fnd_date.canonical_to_date(p_org_information1) AND
1284: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
1285: 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
1286: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
1287: AND hoi.org_information_id <> p_org_information_id ;
1288:
1289:
1290:

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

1524:
1525:
1526: IF p_org_information2 IS NOT NULL THEN
1527:
1528: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
1529: RAISE INVALID_DATE ;
1530: END IF;
1531:
1532: END IF;

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

1724:
1725:
1726: IF p_org_information2 IS NOT NULL THEN
1727:
1728: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
1729: RAISE INVALID_DATE ;
1730: END IF;
1731:
1732: END IF;

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

1761:
1762:
1763: IF p_org_information2 IS NOT NULL THEN
1764:
1765: IF fnd_date.canonical_to_date(p_org_information2) < fnd_date.canonical_to_date(p_org_information1) THEN
1766: RAISE INVALID_DATE ;
1767: END IF;
1768:
1769: END IF;

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

2306: OPEN get_start_date(p_person_id);
2307: FETCH get_start_date into l_start_date;
2308: CLOSE get_start_date;
2309:
2310: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2311: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2312: hr_utility.raise_error;
2313: END IF;
2314: END IF;

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

2359: OPEN get_start_date(l_person_id);
2360: FETCH get_start_date into l_start_date;
2361: CLOSE get_start_date;
2362:
2363: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2364: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2365: hr_utility.raise_error;
2366: END IF;
2367: END IF;