[Home] [Help]
1018: -- ---------------------------------------------------------------------------
1019: --
1020: -- Description:
1021: -- - Validates that the marital status exists as a lookup code on
1022: -- HR_LOOKUPS for the lookup type 'MAR_STATUS' with an enabled
1023: -- flag set to 'Y' and the effective start date of the person between
1024: -- start date active and end date active on HR_LOOKUPS.
1025: --
1026: -- Pre-conditions:
1020: -- Description:
1021: -- - Validates that the marital status exists as a lookup code on
1022: -- HR_LOOKUPS for the lookup type 'MAR_STATUS' with an enabled
1023: -- flag set to 'Y' and the effective start date of the person between
1024: -- start date active and end date active on HR_LOOKUPS.
1025: --
1026: -- Pre-conditions:
1027: -- None
1028: --
1035: -- p_object_version_number
1036: --
1037: -- Post Success:
1038: -- Processing continues if:
1039: -- - marital status exists as a lookup code in HR_LOOKUPS
1040: -- for the lookup type 'MAR_STATUS' where the enabled
1041: -- flag is 'Y' and the effective start date of the person
1042: -- is between start date active and end date active on HR_LOOKUPS.
1043: --
1038: -- Processing continues if:
1039: -- - marital status exists as a lookup code in HR_LOOKUPS
1040: -- for the lookup type 'MAR_STATUS' where the enabled
1041: -- flag is 'Y' and the effective start date of the person
1042: -- is between start date active and end date active on HR_LOOKUPS.
1043: --
1044: -- Post Failure:
1045: -- An application error is raised and processing is terminated if:
1046: -- - marital status does'nt exist as a lookup code in HR_LOOKUPS
1042: -- is between start date active and end date active on HR_LOOKUPS.
1043: --
1044: -- Post Failure:
1045: -- An application error is raised and processing is terminated if:
1046: -- - marital status does'nt exist as a lookup code in HR_LOOKUPS
1047: -- for the lookup type 'MAR_STATUS' where the enabled
1048: -- flag is 'Y' and the effective start date of the person
1049: -- is between start date active and end date active on HR_LOOKUPS.
1050: --
1045: -- An application error is raised and processing is terminated if:
1046: -- - marital status does'nt exist as a lookup code in HR_LOOKUPS
1047: -- for the lookup type 'MAR_STATUS' where the enabled
1048: -- flag is 'Y' and the effective start date of the person
1049: -- is between start date active and end date active on HR_LOOKUPS.
1050: --
1051: -- Access Status:
1052: -- Internal Table Handler Use Only.
1053: --
1116: -- Check if marital status is set
1117: --
1118: If p_marital_status is not null then
1119: --
1120: -- Check that the marital status exists in hr_lookups for the
1121: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1122: -- the effective start date of the person is between start date
1123: -- active and end date active in hr_lookups.
1124: --
1119: --
1120: -- Check that the marital status exists in hr_lookups for the
1121: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1122: -- the effective start date of the person is between start date
1123: -- active and end date active in hr_lookups.
1124: --
1125: if hr_api.not_exists_in_dt_hr_lookups
1126: (p_effective_date => p_effective_date
1127: ,p_validation_start_date => p_validation_start_date
1121: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1122: -- the effective start date of the person is between start date
1123: -- active and end date active in hr_lookups.
1124: --
1125: if hr_api.not_exists_in_dt_hr_lookups
1126: (p_effective_date => p_effective_date
1127: ,p_validation_start_date => p_validation_start_date
1128: ,p_validation_end_date => p_validation_end_date
1129: ,p_lookup_type => 'MAR_STATUS'
1289: --
1290: -- Description:
1291: -- Checks that a nationality value is valid
1292: -- - Validates that the nationality exists as a lookup code on
1293: -- HR_LOOKUPS for the lookup type 'NATIONALITY' with an enabled
1294: -- flag set to 'Y' and the effective start date of the person between
1295: -- start date active and end date active on HR_LOOKUPS.
1296: --
1297: -- Pre-conditions:
1291: -- Checks that a nationality value is valid
1292: -- - Validates that the nationality exists as a lookup code on
1293: -- HR_LOOKUPS for the lookup type 'NATIONALITY' with an enabled
1294: -- flag set to 'Y' and the effective start date of the person between
1295: -- start date active and end date active on HR_LOOKUPS.
1296: --
1297: -- Pre-conditions:
1298: -- None
1299: --
1306: -- p_object_version_number
1307: --
1308: -- Post Success:
1309: -- Processing continues if:
1310: -- - nationality exists as a lookup code in HR_LOOKUPS
1311: -- for the lookup type 'NATIONALITY' where the enabled
1312: -- flag is 'Y' and the effective start date of the person
1313: -- is between start date active and end date active on HR_LOOKUPS.
1314: --
1309: -- Processing continues if:
1310: -- - nationality exists as a lookup code in HR_LOOKUPS
1311: -- for the lookup type 'NATIONALITY' where the enabled
1312: -- flag is 'Y' and the effective start date of the person
1313: -- is between start date active and end date active on HR_LOOKUPS.
1314: --
1315: -- Post Failure:
1316: -- An application error is raised and processing is terminated if:
1317: -- - nationality does'nt exist as a lookup code in HR_LOOKUPS
1313: -- is between start date active and end date active on HR_LOOKUPS.
1314: --
1315: -- Post Failure:
1316: -- An application error is raised and processing is terminated if:
1317: -- - nationality does'nt exist as a lookup code in HR_LOOKUPS
1318: -- for the lookup type 'NATIONALITY' where the enabled
1319: -- flag is 'Y' and the effective start date of the person
1320: -- is between start date active and end date active on HR_LOOKUPS.
1321: --
1316: -- An application error is raised and processing is terminated if:
1317: -- - nationality does'nt exist as a lookup code in HR_LOOKUPS
1318: -- for the lookup type 'NATIONALITY' where the enabled
1319: -- flag is 'Y' and the effective start date of the person
1320: -- is between start date active and end date active on HR_LOOKUPS.
1321: --
1322: -- Access Status:
1323: -- Internal Table Handler Use Only.
1324: --
1383: -- Check if nationality is set
1384: --
1385: if p_nationality is not null then
1386: --
1387: -- Check that the nationality exists in hr_lookups for the
1388: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1389: -- the effective start date of the person is between start date
1390: -- active and end date active in hr_lookups.
1391: --
1386: --
1387: -- Check that the nationality exists in hr_lookups for the
1388: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1389: -- the effective start date of the person is between start date
1390: -- active and end date active in hr_lookups.
1391: --
1392: if hr_api.not_exists_in_dt_hr_lookups
1393: (p_effective_date => p_effective_date
1394: ,p_validation_start_date => p_validation_start_date
1388: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1389: -- the effective start date of the person is between start date
1390: -- active and end date active in hr_lookups.
1391: --
1392: if hr_api.not_exists_in_dt_hr_lookups
1393: (p_effective_date => p_effective_date
1394: ,p_validation_start_date => p_validation_start_date
1395: ,p_validation_end_date => p_validation_end_date
1396: ,p_lookup_type => 'NATIONALITY'
2508: -- ---------------------------------------------------------------------------
2509: --
2510: -- Description:
2511: -- - Validates that the expense check send to address exists as a lookup
2512: -- code on HR_LOOKUPS for the lookup type 'HOME_OFFICE' with an enabled
2513: -- flag set to 'Y' and the effective start date of the person between
2514: -- start date active and end date active on HR_LOOKUPS.
2515: --
2516: -- Pre-conditions:
2510: -- Description:
2511: -- - Validates that the expense check send to address exists as a lookup
2512: -- code on HR_LOOKUPS for the lookup type 'HOME_OFFICE' with an enabled
2513: -- flag set to 'Y' and the effective start date of the person between
2514: -- start date active and end date active on HR_LOOKUPS.
2515: --
2516: -- Pre-conditions:
2517: -- None
2518: --
2524: -- p_object_version_number
2525: --
2526: -- Post Success:
2527: -- Processing continues if:
2528: -- - expense check send to address exists as a lookup code in HR_LOOKUPS
2529: -- for the lookup type 'HOME_OFFICE' where the enabled flag is 'Y' and
2530: -- the effective start date of the person is between start date active
2531: -- and end date active on HR_LOOKUPS.
2532: --
2527: -- Processing continues if:
2528: -- - expense check send to address exists as a lookup code in HR_LOOKUPS
2529: -- for the lookup type 'HOME_OFFICE' where the enabled flag is 'Y' and
2530: -- the effective start date of the person is between start date active
2531: -- and end date active on HR_LOOKUPS.
2532: --
2533: -- Post Failure:
2534: -- An application error is raised and processing is terminated if:
2535: -- - expense check send to address does'nt exist as a lookup code in
2532: --
2533: -- Post Failure:
2534: -- An application error is raised and processing is terminated if:
2535: -- - expense check send to address does'nt exist as a lookup code in
2536: -- HR_LOOKUPS for the lookup type 'HOME_OFFICE' where the enabled
2537: -- flag is 'Y' and the effective start date of the person
2538: -- is between start date active and end date active on HR_LOOKUPS.
2539: --
2540: -- Access Status:
2534: -- An application error is raised and processing is terminated if:
2535: -- - expense check send to address does'nt exist as a lookup code in
2536: -- HR_LOOKUPS for the lookup type 'HOME_OFFICE' where the enabled
2537: -- flag is 'Y' and the effective start date of the person
2538: -- is between start date active and end date active on HR_LOOKUPS.
2539: --
2540: -- Access Status:
2541: -- Internal Table Handler Use Only.
2542: --
2610: -- Check if expense check send to address is set
2611: --
2612: If p_expense_check_send_to_addres is not null then
2613: --
2614: -- Check that the expense check send to address exists in hr_lookups for the
2615: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2616: -- the effective start date of the person is between start date
2617: -- active and end date active in hr_lookups.
2618: --
2613: --
2614: -- Check that the expense check send to address exists in hr_lookups for the
2615: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2616: -- the effective start date of the person is between start date
2617: -- active and end date active in hr_lookups.
2618: --
2619: if hr_api.not_exists_in_dt_hr_lookups
2620: (p_effective_date => p_effective_date
2621: ,p_validation_start_date => p_validation_start_date
2615: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2616: -- the effective start date of the person is between start date
2617: -- active and end date active in hr_lookups.
2618: --
2619: if hr_api.not_exists_in_dt_hr_lookups
2620: (p_effective_date => p_effective_date
2621: ,p_validation_start_date => p_validation_start_date
2622: ,p_validation_end_date => p_validation_end_date
2623: ,p_lookup_type => 'HOME_OFFICE'
2663: -- ---------------------------------------------------------------------------
2664: --
2665: -- Description:
2666: -- - Validates that the sex exists as a lookup code on
2667: -- HR_LOOKUPS for the lookup type 'SEX' with an enabled
2668: -- flag set to 'Y' and the effective start date of the person between
2669: -- start date active and end date active on HR_LOOKUPS.
2670: -- - Validates that the title exists as a lookup code on
2671: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2665: -- Description:
2666: -- - Validates that the sex exists as a lookup code on
2667: -- HR_LOOKUPS for the lookup type 'SEX' with an enabled
2668: -- flag set to 'Y' and the effective start date of the person between
2669: -- start date active and end date active on HR_LOOKUPS.
2670: -- - Validates that the title exists as a lookup code on
2671: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2672: -- flag set to 'Y' and the effective start date of the person between
2673: -- start date active and end date active on HR_LOOKUPS.
2667: -- HR_LOOKUPS for the lookup type 'SEX' with an enabled
2668: -- flag set to 'Y' and the effective start date of the person between
2669: -- start date active and end date active on HR_LOOKUPS.
2670: -- - Validates that the title exists as a lookup code on
2671: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2672: -- flag set to 'Y' and the effective start date of the person between
2673: -- start date active and end date active on HR_LOOKUPS.
2674: --
2675: -- Pre-conditions:
2669: -- start date active and end date active on HR_LOOKUPS.
2670: -- - Validates that the title exists as a lookup code on
2671: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2672: -- flag set to 'Y' and the effective start date of the person between
2673: -- start date active and end date active on HR_LOOKUPS.
2674: --
2675: -- Pre-conditions:
2676: -- A valid person type
2677: --
2687: -- p_object_version_number
2688: --
2689: -- Post Success:
2690: -- Processing continues if:
2691: -- - a sex exists as a lookup code in HR_LOOKUPS for the lookup type
2692: -- 'SEX' where the enabled flag is 'Y' and the effective start
2693: -- date of the person is between start date active and end date
2694: -- active on HR_LOOKUPS.
2695: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2690: -- Processing continues if:
2691: -- - a sex exists as a lookup code in HR_LOOKUPS for the lookup type
2692: -- 'SEX' where the enabled flag is 'Y' and the effective start
2693: -- date of the person is between start date active and end date
2694: -- active on HR_LOOKUPS.
2695: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2696: -- 'TITLE' where the enabled flag is 'Y' and the effective start
2697: -- date of the person is between start date active and end date
2698: -- active on HR_LOOKUPS.
2691: -- - a sex exists as a lookup code in HR_LOOKUPS for the lookup type
2692: -- 'SEX' where the enabled flag is 'Y' and the effective start
2693: -- date of the person is between start date active and end date
2694: -- active on HR_LOOKUPS.
2695: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2696: -- 'TITLE' where the enabled flag is 'Y' and the effective start
2697: -- date of the person is between start date active and end date
2698: -- active on HR_LOOKUPS.
2699: -- - a sex value is 'M' and the title value is not 'MISS','MRS.',
2694: -- active on HR_LOOKUPS.
2695: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2696: -- 'TITLE' where the enabled flag is 'Y' and the effective start
2697: -- date of the person is between start date active and end date
2698: -- active on HR_LOOKUPS.
2699: -- - a sex value is 'M' and the title value is not 'MISS','MRS.',
2700: -- 'MS.'
2701: -- - a sex value is 'F' and the title value is 'MR'.
2702: -- - the related system person type is 'EMP' and a sex value is
2703: -- set.
2704: --
2705: -- Post Failure:
2706: -- An application error is raised and processing is terminated if:
2707: -- - a sex does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2708: -- type 'SEX' where the enabled flag is 'Y' and the effective start
2709: -- date of the person is between start date active and end date
2710: -- active on HR_LOOKUPS.
2711: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2706: -- An application error is raised and processing is terminated if:
2707: -- - a sex does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2708: -- type 'SEX' where the enabled flag is 'Y' and the effective start
2709: -- date of the person is between start date active and end date
2710: -- active on HR_LOOKUPS.
2711: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2712: -- type 'TITLE' where the enabled flag is 'Y' and the effective start
2713: -- date of the person is between start date active and end date
2714: -- active on HR_LOOKUPS.
2707: -- - a sex does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2708: -- type 'SEX' where the enabled flag is 'Y' and the effective start
2709: -- date of the person is between start date active and end date
2710: -- active on HR_LOOKUPS.
2711: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2712: -- type 'TITLE' where the enabled flag is 'Y' and the effective start
2713: -- date of the person is between start date active and end date
2714: -- active on HR_LOOKUPS.
2715: -- - a sex value is 'M' and the title value is 'MISS','MRS.', 'MS.'
2710: -- active on HR_LOOKUPS.
2711: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2712: -- type 'TITLE' where the enabled flag is 'Y' and the effective start
2713: -- date of the person is between start date active and end date
2714: -- active on HR_LOOKUPS.
2715: -- - a sex value is 'M' and the title value is 'MISS','MRS.', 'MS.'
2716: -- - a sex value is 'F' and the title value is 'MR.'
2717: -- - the related system person type is 'EMP' and a sex value is not
2718: -- set.
2797: -- Check if title is set
2798: --
2799: If p_title is not null then
2800: --
2801: -- Check that the title exists in hr_lookups for the lookup type
2802: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2803: -- start date of the person is between start date active and end
2804: -- date active in hr_lookups.
2805: --
2800: --
2801: -- Check that the title exists in hr_lookups for the lookup type
2802: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2803: -- start date of the person is between start date active and end
2804: -- date active in hr_lookups.
2805: --
2806: if hr_api.not_exists_in_dt_hr_lookups
2807: (p_effective_date => p_effective_date
2808: ,p_validation_start_date => p_validation_start_date
2802: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2803: -- start date of the person is between start date active and end
2804: -- date active in hr_lookups.
2805: --
2806: if hr_api.not_exists_in_dt_hr_lookups
2807: (p_effective_date => p_effective_date
2808: ,p_validation_start_date => p_validation_start_date
2809: ,p_validation_end_date => p_validation_end_date
2810: ,p_lookup_type => 'TITLE'
2827: -- Check if sex is set
2828: --
2829: If p_sex is not null then
2830: --
2831: -- Check that the sex exists in hr_lookups for the lookup type
2832: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2833: -- start date of the person is between start date active and end
2834: -- date active in hr_lookups.
2835: --
2830: --
2831: -- Check that the sex exists in hr_lookups for the lookup type
2832: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2833: -- start date of the person is between start date active and end
2834: -- date active in hr_lookups.
2835: --
2836: if hr_api.not_exists_in_dt_hr_lookups
2837: (p_effective_date => p_effective_date
2838: ,p_validation_start_date => p_validation_start_date
2832: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2833: -- start date of the person is between start date active and end
2834: -- date active in hr_lookups.
2835: --
2836: if hr_api.not_exists_in_dt_hr_lookups
2837: (p_effective_date => p_effective_date
2838: ,p_validation_start_date => p_validation_start_date
2839: ,p_validation_end_date => p_validation_end_date
2840: ,p_lookup_type => 'SEX'
2955: WHERE upper(plfi.field_name) = 'TOWN_OF_BIRTH'
2956: AND plfi.legislation_code = p_legislation_code;
2957: --
2958: l_exists varchar2(1);
2959: l_lookup_type hr_lookups.lookup_type%TYPE;
2960: l_proc varchar2(72);
2961: --
2962: begin
2963: if g_debug then
2984: if csr_plfi%found then
2985: close csr_plfi;
2986: -- attempt to decode the lookup type returned from plfi record
2987: -- with the p_town_of_birth lookup_value supplied to the api.
2988: if hr_api.not_exists_in_dt_hr_lookups
2989: (p_effective_date => p_effective_date
2990: ,p_validation_start_date => p_validation_start_date
2991: ,p_validation_end_date => p_validation_end_date
2992: ,p_lookup_type => l_lookup_type
3069: WHERE upper(plfi.field_name) = 'REGION_OF_BIRTH'
3070: AND plfi.legislation_code = p_legislation_code;
3071: --
3072: l_exists varchar2(1);
3073: l_lookup_type hr_lookups.lookup_type%TYPE;
3074: l_proc varchar2(72);
3075: --
3076: begin
3077: if g_debug then
3098: if csr_plfi%found then
3099: close csr_plfi;
3100: -- attempt to decode the lookup type returned from plfi record
3101: -- with the p_region_of_birth lookup_value supplied to the api.
3102: if hr_api.not_exists_in_dt_hr_lookups
3103: (p_effective_date => p_effective_date
3104: ,p_validation_start_date => p_validation_start_date
3105: ,p_validation_end_date => p_validation_end_date
3106: ,p_lookup_type => l_lookup_type
3510: -- - Checks that the values held in developer descriptive flexfields
3511: -- are valid for a category of 'GB'
3512: -- - Validates that per information3 and per information11 to 20 are null.
3513: -- - Validates that per information2, 4 ,9 and 10 exists as a lookup code on
3514: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag set to 'Y'
3515: -- and the effective start date of the person between start date active
3516: -- and end date active on HR_LOOKUPS.
3517: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3518: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3512: -- - Validates that per information3 and per information11 to 20 are null.
3513: -- - Validates that per information2, 4 ,9 and 10 exists as a lookup code on
3514: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag set to 'Y'
3515: -- and the effective start date of the person between start date active
3516: -- and end date active on HR_LOOKUPS.
3517: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3518: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3519: -- effective start date of the person between start date active and end
3520: -- date active on HR_LOOKUPS.
3513: -- - Validates that per information2, 4 ,9 and 10 exists as a lookup code on
3514: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag set to 'Y'
3515: -- and the effective start date of the person between start date active
3516: -- and end date active on HR_LOOKUPS.
3517: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3518: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3519: -- effective start date of the person between start date active and end
3520: -- date active on HR_LOOKUPS.
3521: -- - Validates that per information5 is less than or equal to 30 characters
3516: -- and end date active on HR_LOOKUPS.
3517: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3518: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3519: -- effective start date of the person between start date active and end
3520: -- date active on HR_LOOKUPS.
3521: -- - Validates that per information5 is less than or equal to 30 characters
3522: -- and in uppercase.
3523: --
3524: -- Pre-conditions:
3554: --
3555: -- Post Success:
3556: -- Processing continues if:
3557: -- - per_information3 and per_information11 to 20 values are null
3558: -- - per information2, 4 , 9 and 10 exists as a lookup code in HR_LOOKUPS
3559: -- for the lookup type 'YES_NO' where the enabled flag is 'Y'
3560: -- and the effective start date of the person is between start
3561: -- date active and end date active on HR_LOOKUPS.
3562: -- - per information1 exists as a lookup code in HR_LOOKUPS
3557: -- - per_information3 and per_information11 to 20 values are null
3558: -- - per information2, 4 , 9 and 10 exists as a lookup code in HR_LOOKUPS
3559: -- for the lookup type 'YES_NO' where the enabled flag is 'Y'
3560: -- and the effective start date of the person is between start
3561: -- date active and end date active on HR_LOOKUPS.
3562: -- - per information1 exists as a lookup code in HR_LOOKUPS
3563: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3564: -- and the effective start date of the person is between start
3565: -- date active and end date active on HR_LOOKUPS.
3558: -- - per information2, 4 , 9 and 10 exists as a lookup code in HR_LOOKUPS
3559: -- for the lookup type 'YES_NO' where the enabled flag is 'Y'
3560: -- and the effective start date of the person is between start
3561: -- date active and end date active on HR_LOOKUPS.
3562: -- - per information1 exists as a lookup code in HR_LOOKUPS
3563: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3564: -- and the effective start date of the person is between start
3565: -- date active and end date active on HR_LOOKUPS.
3566: -- - per_information5 is less than or equal to 30 characters long
3561: -- date active and end date active on HR_LOOKUPS.
3562: -- - per information1 exists as a lookup code in HR_LOOKUPS
3563: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3564: -- and the effective start date of the person is between start
3565: -- date active and end date active on HR_LOOKUPS.
3566: -- - per_information5 is less than or equal to 30 characters long
3567: -- and upper case.
3568: --
3569: -- Post Failure:
3570: -- An application error is raised and processing is terminated if:
3571: -- - any of per_information3 and per_information10 to 20 values are
3572: -- not null.
3573: -- - any of per information2, 4,9 and 10 does'nt exist as a lookup code
3574: -- in HR_LOOKUPS for the lookup type 'YES_NO' where the enabled flag
3575: -- is 'Y' and the effective start date of the person is between start
3576: -- date active and end date active on HR_LOOKUPS.
3577: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3578: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3572: -- not null.
3573: -- - any of per information2, 4,9 and 10 does'nt exist as a lookup code
3574: -- in HR_LOOKUPS for the lookup type 'YES_NO' where the enabled flag
3575: -- is 'Y' and the effective start date of the person is between start
3576: -- date active and end date active on HR_LOOKUPS.
3577: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3578: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3579: -- and the effective start date of the person is between start
3580: -- date active and end date active on HR_LOOKUPS.
3573: -- - any of per information2, 4,9 and 10 does'nt exist as a lookup code
3574: -- in HR_LOOKUPS for the lookup type 'YES_NO' where the enabled flag
3575: -- is 'Y' and the effective start date of the person is between start
3576: -- date active and end date active on HR_LOOKUPS.
3577: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3578: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3579: -- and the effective start date of the person is between start
3580: -- date active and end date active on HR_LOOKUPS.
3581: -- - per_information5 is not less than or equal to 30 characters long
3576: -- date active and end date active on HR_LOOKUPS.
3577: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3578: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3579: -- and the effective start date of the person is between start
3580: -- date active and end date active on HR_LOOKUPS.
3581: -- - per_information5 is not less than or equal to 30 characters long
3582: -- or not upper case.
3583: --
3584: -- Access Status:
3666: --
3667: -- We know the per_information_category is GB, so check the rest of
3668: -- the per_information fields within this context.
3669: --
3670: -- Check if the per_information1 value exists in hr_lookups
3671: -- where the lookup_type is 'ETH_TYPE'
3672: --
3673: if p_per_information1 is not null then
3674: --
3671: -- where the lookup_type is 'ETH_TYPE'
3672: --
3673: if p_per_information1 is not null then
3674: --
3675: -- Check that per information1 exists in hr_lookups for the
3676: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3677: -- the effective start date of the person is between start date
3678: -- active and end date active in hr_lookups.
3679: --
3674: --
3675: -- Check that per information1 exists in hr_lookups for the
3676: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3677: -- the effective start date of the person is between start date
3678: -- active and end date active in hr_lookups.
3679: --
3680: if hr_api.not_exists_in_dt_hr_lookups
3681: (p_effective_date => p_effective_date
3682: ,p_validation_start_date => p_validation_start_date
3676: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3677: -- the effective start date of the person is between start date
3678: -- active and end date active in hr_lookups.
3679: --
3680: if hr_api.not_exists_in_dt_hr_lookups
3681: (p_effective_date => p_effective_date
3682: ,p_validation_start_date => p_validation_start_date
3683: ,p_validation_end_date => p_validation_end_date
3684: ,p_lookup_type => 'ETH_TYPE'
3698: if g_debug then
3699: hr_utility.set_location(l_proc,40);
3700: end if;
3701: --
3702: -- Check if the per_information2 value exists in hr_lookups
3703: -- where the lookup_type is 'YES_NO'
3704: --
3705: if p_per_information2 is not null then
3706: --
3703: -- where the lookup_type is 'YES_NO'
3704: --
3705: if p_per_information2 is not null then
3706: --
3707: -- Check that per information2 exists in hr_lookups for the
3708: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3709: -- the effective start date of the person is between start date
3710: -- active and end date active in hr_lookups.
3711: --
3706: --
3707: -- Check that per information2 exists in hr_lookups for the
3708: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3709: -- the effective start date of the person is between start date
3710: -- active and end date active in hr_lookups.
3711: --
3712: if hr_api.not_exists_in_dt_hr_lookups
3713: (p_effective_date => p_effective_date
3714: ,p_validation_start_date => p_validation_start_date
3708: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3709: -- the effective start date of the person is between start date
3710: -- active and end date active in hr_lookups.
3711: --
3712: if hr_api.not_exists_in_dt_hr_lookups
3713: (p_effective_date => p_effective_date
3714: ,p_validation_start_date => p_validation_start_date
3715: ,p_validation_end_date => p_validation_end_date
3716: ,p_lookup_type => 'YES_NO'
3730: if g_debug then
3731: hr_utility.set_location(l_proc,60);
3732: end if;
3733: --
3734: -- Check if the per_information4 value exists in hr_lookups
3735: -- where the lookup_type is 'YES_NO'
3736: --
3737: if p_per_information4 is not null then
3738: --
3735: -- where the lookup_type is 'YES_NO'
3736: --
3737: if p_per_information4 is not null then
3738: --
3739: -- Check that per information4 exists in hr_lookups for the
3740: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3741: -- the effective start date of the person is between start date
3742: -- active and end date active in hr_lookups.
3743: --
3738: --
3739: -- Check that per information4 exists in hr_lookups for the
3740: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3741: -- the effective start date of the person is between start date
3742: -- active and end date active in hr_lookups.
3743: --
3744: if hr_api.not_exists_in_dt_hr_lookups
3745: (p_effective_date => p_effective_date
3746: ,p_validation_start_date => p_validation_start_date
3740: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3741: -- the effective start date of the person is between start date
3742: -- active and end date active in hr_lookups.
3743: --
3744: if hr_api.not_exists_in_dt_hr_lookups
3745: (p_effective_date => p_effective_date
3746: ,p_validation_start_date => p_validation_start_date
3747: ,p_validation_end_date => p_validation_end_date
3748: ,p_lookup_type => 'YES_NO'
3876: if g_debug then
3877: hr_utility.set_location(l_proc, 190);
3878: end if;
3879: --
3880: -- Check if the per_information9 value exists in hr_lookups
3881: -- where the lookup_type is 'YES_NO'
3882: --
3883: if p_per_information9 is not null then
3884: --
3881: -- where the lookup_type is 'YES_NO'
3882: --
3883: if p_per_information9 is not null then
3884: --
3885: -- Check that per information9 exists in hr_lookups for the
3886: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3887: -- the effective start date of the person is between start date
3888: -- active and end date active in hr_lookups.
3889: --
3884: --
3885: -- Check that per information9 exists in hr_lookups for the
3886: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3887: -- the effective start date of the person is between start date
3888: -- active and end date active in hr_lookups.
3889: --
3890: if hr_api.not_exists_in_dt_hr_lookups
3891: (p_effective_date => p_effective_date
3892: ,p_validation_start_date => p_validation_start_date
3886: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3887: -- the effective start date of the person is between start date
3888: -- active and end date active in hr_lookups.
3889: --
3890: if hr_api.not_exists_in_dt_hr_lookups
3891: (p_effective_date => p_effective_date
3892: ,p_validation_start_date => p_validation_start_date
3893: ,p_validation_end_date => p_validation_end_date
3894: ,p_lookup_type => 'YES_NO'
3912: -- ***** Start new code for bug 2236999 **************
3913:
3914: if p_per_information10 is not null then
3915: --
3916: -- Check that per information10 exists in hr_lookups for the
3917: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3918: -- the effective start date of the person is between start date
3919: -- active and end date active in hr_lookups.
3920: --
3915: --
3916: -- Check that per information10 exists in hr_lookups for the
3917: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3918: -- the effective start date of the person is between start date
3919: -- active and end date active in hr_lookups.
3920: --
3921: if hr_api.not_exists_in_dt_hr_lookups
3922: (p_effective_date => p_effective_date
3923: ,p_validation_start_date => p_validation_start_date
3917: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3918: -- the effective start date of the person is between start date
3919: -- active and end date active in hr_lookups.
3920: --
3921: if hr_api.not_exists_in_dt_hr_lookups
3922: (p_effective_date => p_effective_date
3923: ,p_validation_start_date => p_validation_start_date
3924: ,p_validation_end_date => p_validation_end_date
3925: ,p_lookup_type => 'YES_NO'
4037: -- Description:
4038: -- - Checks that the values held in developer descriptive flexfields
4039: -- are valid for a category of 'US'.
4040: -- - Validates that per information6 and 9 exist as a lookup code on
4041: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4042: -- set to 'Y' and the effective start date of the person between start
4043: -- date active and end date active on HR_LOOKUPS.
4044: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4045: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4039: -- are valid for a category of 'US'.
4040: -- - Validates that per information6 and 9 exist as a lookup code on
4041: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4042: -- set to 'Y' and the effective start date of the person between start
4043: -- date active and end date active on HR_LOOKUPS.
4044: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4045: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4046: -- and the effective start date of the person between start date active
4047: -- and end date active on HR_LOOKUPS.
4040: -- - Validates that per information6 and 9 exist as a lookup code on
4041: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4042: -- set to 'Y' and the effective start date of the person between start
4043: -- date active and end date active on HR_LOOKUPS.
4044: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4045: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4046: -- and the effective start date of the person between start date active
4047: -- and end date active on HR_LOOKUPS.
4048: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4043: -- date active and end date active on HR_LOOKUPS.
4044: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4045: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4046: -- and the effective start date of the person between start date active
4047: -- and end date active on HR_LOOKUPS.
4048: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4049: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4050: -- and the effective start date of the person between start date active
4051: -- and end date active on HR_LOOKUPS.
4044: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4045: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4046: -- and the effective start date of the person between start date active
4047: -- and end date active on HR_LOOKUPS.
4048: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4049: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4050: -- and the effective start date of the person between start date active
4051: -- and end date active on HR_LOOKUPS.
4052: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4047: -- and end date active on HR_LOOKUPS.
4048: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4049: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4050: -- and the effective start date of the person between start date active
4051: -- and end date active on HR_LOOKUPS.
4052: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4053: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4054: -- and the effective start date of the person between start date active
4055: -- and end date active on HR_LOOKUPS.
4048: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4049: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4050: -- and the effective start date of the person between start date active
4051: -- and end date active on HR_LOOKUPS.
4052: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4053: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4054: -- and the effective start date of the person between start date active
4055: -- and end date active on HR_LOOKUPS.
4056: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4051: -- and end date active on HR_LOOKUPS.
4052: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4053: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4054: -- and the effective start date of the person between start date active
4055: -- and end date active on HR_LOOKUPS.
4056: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4057: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4058: -- and the effective start date of the person between start date active
4059: -- and end date active on HR_LOOKUPS.
4052: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4053: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4054: -- and the effective start date of the person between start date active
4055: -- and end date active on HR_LOOKUPS.
4056: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4057: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4058: -- and the effective start date of the person between start date active
4059: -- and end date active on HR_LOOKUPS.
4060: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4055: -- and end date active on HR_LOOKUPS.
4056: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4057: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4058: -- and the effective start date of the person between start date active
4059: -- and end date active on HR_LOOKUPS.
4060: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4061: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4062: -- and the effective start date of the person between start date active
4063: -- and end date active on HR_LOOKUPS.
4056: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4057: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4058: -- and the effective start date of the person between start date active
4059: -- and end date active on HR_LOOKUPS.
4060: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4061: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4062: -- and the effective start date of the person between start date active
4063: -- and end date active on HR_LOOKUPS.
4064: -- - Validates that when per information7 is set to 'EXCL' that per
4059: -- and end date active on HR_LOOKUPS.
4060: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4061: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4062: -- and the effective start date of the person between start date active
4063: -- and end date active on HR_LOOKUPS.
4064: -- - Validates that when per information7 is set to 'EXCL' that per
4065: -- information8 exists as a lookup code on HR_LOOKUPS for the lookup type
4066: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4067: -- effective start date of the person between start date active and end
4061: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4062: -- and the effective start date of the person between start date active
4063: -- and end date active on HR_LOOKUPS.
4064: -- - Validates that when per information7 is set to 'EXCL' that per
4065: -- information8 exists as a lookup code on HR_LOOKUPS for the lookup type
4066: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4067: -- effective start date of the person between start date active and end
4068: -- date active on HR_LOOKUPS.
4069: -- - Validates that per information10 exists as a lookup code on
4064: -- - Validates that when per information7 is set to 'EXCL' that per
4065: -- information8 exists as a lookup code on HR_LOOKUPS for the lookup type
4066: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4067: -- effective start date of the person between start date active and end
4068: -- date active on HR_LOOKUPS.
4069: -- - Validates that per information10 exists as a lookup code on
4070: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4071: -- set to 'Y' and the effective start date of the person between start
4072: -- date active and end date active on HR_LOOKUPS.
4066: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4067: -- effective start date of the person between start date active and end
4068: -- date active on HR_LOOKUPS.
4069: -- - Validates that per information10 exists as a lookup code on
4070: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4071: -- set to 'Y' and the effective start date of the person between start
4072: -- date active and end date active on HR_LOOKUPS.
4073: --
4074: -- Pre-conditions:
4068: -- date active on HR_LOOKUPS.
4069: -- - Validates that per information10 exists as a lookup code on
4070: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4071: -- set to 'Y' and the effective start date of the person between start
4072: -- date active and end date active on HR_LOOKUPS.
4073: --
4074: -- Pre-conditions:
4075: -- None
4076: --
4114: -- p_api_updating
4115: --
4116: -- Post Success:
4117: -- Processing continues if:
4118: -- - per information6 and 9 exist as a lookup code in HR_LOOKUPS
4119: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4120: -- the effective start date of the person is between start date
4121: -- active and end date active on HR_LOOKUPS.
4122: -- - per information1 exists as a lookup code in HR_LOOKUPS
4117: -- Processing continues if:
4118: -- - per information6 and 9 exist as a lookup code in HR_LOOKUPS
4119: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4120: -- the effective start date of the person is between start date
4121: -- active and end date active on HR_LOOKUPS.
4122: -- - per information1 exists as a lookup code in HR_LOOKUPS
4123: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4124: -- 'Y' and the effective start date of the person is between start
4125: -- date active and end date active on HR_LOOKUPS.
4118: -- - per information6 and 9 exist as a lookup code in HR_LOOKUPS
4119: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4120: -- the effective start date of the person is between start date
4121: -- active and end date active on HR_LOOKUPS.
4122: -- - per information1 exists as a lookup code in HR_LOOKUPS
4123: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4124: -- 'Y' and the effective start date of the person is between start
4125: -- date active and end date active on HR_LOOKUPS.
4126: -- - per information2 exists as a lookup code in HR_LOOKUPS
4121: -- active and end date active on HR_LOOKUPS.
4122: -- - per information1 exists as a lookup code in HR_LOOKUPS
4123: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4124: -- 'Y' and the effective start date of the person is between start
4125: -- date active and end date active on HR_LOOKUPS.
4126: -- - per information2 exists as a lookup code in HR_LOOKUPS
4127: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4128: -- 'Y' and the effective start date of the person is between start
4129: -- date active and end date active on HR_LOOKUPS.
4122: -- - per information1 exists as a lookup code in HR_LOOKUPS
4123: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4124: -- 'Y' and the effective start date of the person is between start
4125: -- date active and end date active on HR_LOOKUPS.
4126: -- - per information2 exists as a lookup code in HR_LOOKUPS
4127: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4128: -- 'Y' and the effective start date of the person is between start
4129: -- date active and end date active on HR_LOOKUPS.
4130: -- - per information3 is a valid date and 11 characters long.
4125: -- date active and end date active on HR_LOOKUPS.
4126: -- - per information2 exists as a lookup code in HR_LOOKUPS
4127: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4128: -- 'Y' and the effective start date of the person is between start
4129: -- date active and end date active on HR_LOOKUPS.
4130: -- - per information3 is a valid date and 11 characters long.
4131: -- - per information4 exists as a lookup code in HR_LOOKUPS
4132: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4133: -- 'Y' and the effective start date of the person is between start
4127: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4128: -- 'Y' and the effective start date of the person is between start
4129: -- date active and end date active on HR_LOOKUPS.
4130: -- - per information3 is a valid date and 11 characters long.
4131: -- - per information4 exists as a lookup code in HR_LOOKUPS
4132: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4133: -- 'Y' and the effective start date of the person is between start
4134: -- date active and end date active on HR_LOOKUPS.
4135: -- - per information5 exists as a lookup code in HR_LOOKUPS
4130: -- - per information3 is a valid date and 11 characters long.
4131: -- - per information4 exists as a lookup code in HR_LOOKUPS
4132: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4133: -- 'Y' and the effective start date of the person is between start
4134: -- date active and end date active on HR_LOOKUPS.
4135: -- - per information5 exists as a lookup code in HR_LOOKUPS
4136: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4137: -- 'Y' and the effective start date of the person is between start
4138: -- date active and end date active on HR_LOOKUPS.
4131: -- - per information4 exists as a lookup code in HR_LOOKUPS
4132: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4133: -- 'Y' and the effective start date of the person is between start
4134: -- date active and end date active on HR_LOOKUPS.
4135: -- - per information5 exists as a lookup code in HR_LOOKUPS
4136: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4137: -- 'Y' and the effective start date of the person is between start
4138: -- date active and end date active on HR_LOOKUPS.
4139: -- - per information7 exists as a lookup code in HR_LOOKUPS
4134: -- date active and end date active on HR_LOOKUPS.
4135: -- - per information5 exists as a lookup code in HR_LOOKUPS
4136: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4137: -- 'Y' and the effective start date of the person is between start
4138: -- date active and end date active on HR_LOOKUPS.
4139: -- - per information7 exists as a lookup code in HR_LOOKUPS
4140: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4141: -- 'Y' and the effective start date of the person is between start
4142: -- date active and end date active on HR_LOOKUPS.
4135: -- - per information5 exists as a lookup code in HR_LOOKUPS
4136: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4137: -- 'Y' and the effective start date of the person is between start
4138: -- date active and end date active on HR_LOOKUPS.
4139: -- - per information7 exists as a lookup code in HR_LOOKUPS
4140: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4141: -- 'Y' and the effective start date of the person is between start
4142: -- date active and end date active on HR_LOOKUPS.
4143: -- - when per information7 is set to 'EXCL' and per information8 exists
4138: -- date active and end date active on HR_LOOKUPS.
4139: -- - per information7 exists as a lookup code in HR_LOOKUPS
4140: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4141: -- 'Y' and the effective start date of the person is between start
4142: -- date active and end date active on HR_LOOKUPS.
4143: -- - when per information7 is set to 'EXCL' and per information8 exists
4144: -- as a lookup code in HR_LOOKUPS for the lookup type
4145: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4146: -- effective start date of the person is between start date active
4140: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4141: -- 'Y' and the effective start date of the person is between start
4142: -- date active and end date active on HR_LOOKUPS.
4143: -- - when per information7 is set to 'EXCL' and per information8 exists
4144: -- as a lookup code in HR_LOOKUPS for the lookup type
4145: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4146: -- effective start date of the person is between start date active
4147: -- and end date active on HR_LOOKUPS.
4148: --
4143: -- - when per information7 is set to 'EXCL' and per information8 exists
4144: -- as a lookup code in HR_LOOKUPS for the lookup type
4145: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4146: -- effective start date of the person is between start date active
4147: -- and end date active on HR_LOOKUPS.
4148: --
4149: -- 9) per_information9 value exists in hr_lookups
4150: -- where lookup_type = 'YES_NO'
4151: --
4145: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4146: -- effective start date of the person is between start date active
4147: -- and end date active on HR_LOOKUPS.
4148: --
4149: -- 9) per_information9 value exists in hr_lookups
4150: -- where lookup_type = 'YES_NO'
4151: --
4152: -- 10) per information10 exists as a lookup code in HR_LOOKUPS
4153: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4148: --
4149: -- 9) per_information9 value exists in hr_lookups
4150: -- where lookup_type = 'YES_NO'
4151: --
4152: -- 10) per information10 exists as a lookup code in HR_LOOKUPS
4153: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4154: -- the effective start date of the person is between start date
4155: -- active and end date active on HR_LOOKUPS.
4156: --
4151: --
4152: -- 10) per information10 exists as a lookup code in HR_LOOKUPS
4153: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4154: -- the effective start date of the person is between start date
4155: -- active and end date active on HR_LOOKUPS.
4156: --
4157: -- 11) per_information11 to 20 values are null
4158: --
4159: -- Post Failure:
4158: --
4159: -- Post Failure:
4160: -- An application error is raised and processing is terminated if:
4161: -- - per information6 and 9 does not exist as a lookup code in
4162: -- HR_LOOKUPS for the lookup type 'YES_NO' where the
4163: -- enabled flag is 'Y' and the effective start date of the person
4164: -- is between start date active and end date active on HR_LOOKUPS.
4165: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4166: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4160: -- An application error is raised and processing is terminated if:
4161: -- - per information6 and 9 does not exist as a lookup code in
4162: -- HR_LOOKUPS for the lookup type 'YES_NO' where the
4163: -- enabled flag is 'Y' and the effective start date of the person
4164: -- is between start date active and end date active on HR_LOOKUPS.
4165: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4166: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4167: -- 'Y' and the effective start date of the person is between start
4168: -- date active and end date active on HR_LOOKUPS.
4161: -- - per information6 and 9 does not exist as a lookup code in
4162: -- HR_LOOKUPS for the lookup type 'YES_NO' where the
4163: -- enabled flag is 'Y' and the effective start date of the person
4164: -- is between start date active and end date active on HR_LOOKUPS.
4165: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4166: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4167: -- 'Y' and the effective start date of the person is between start
4168: -- date active and end date active on HR_LOOKUPS.
4169: -- - per information2 doesn't exist as a lookup code in HR_LOOKUPS
4164: -- is between start date active and end date active on HR_LOOKUPS.
4165: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4166: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4167: -- 'Y' and the effective start date of the person is between start
4168: -- date active and end date active on HR_LOOKUPS.
4169: -- - per information2 doesn't exist as a lookup code in HR_LOOKUPS
4170: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4171: -- 'Y' and the effective start date of the person is between start
4172: -- date active and end date active on HR_LOOKUPS.
4165: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4166: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4167: -- 'Y' and the effective start date of the person is between start
4168: -- date active and end date active on HR_LOOKUPS.
4169: -- - per information2 doesn't exist as a lookup code in HR_LOOKUPS
4170: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4171: -- 'Y' and the effective start date of the person is between start
4172: -- date active and end date active on HR_LOOKUPS.
4173: -- - per information3 value is an invalid date or less than 11
4168: -- date active and end date active on HR_LOOKUPS.
4169: -- - per information2 doesn't exist as a lookup code in HR_LOOKUPS
4170: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4171: -- 'Y' and the effective start date of the person is between start
4172: -- date active and end date active on HR_LOOKUPS.
4173: -- - per information3 value is an invalid date or less than 11
4174: -- characters long.
4175: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4171: -- 'Y' and the effective start date of the person is between start
4172: -- date active and end date active on HR_LOOKUPS.
4173: -- - per information3 value is an invalid date or less than 11
4174: -- characters long.
4175: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4177: -- 'Y' and the effective start date of the person is between start
4178: -- date active and end date active on HR_LOOKUPS.
4179: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4174: -- characters long.
4175: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4177: -- 'Y' and the effective start date of the person is between start
4178: -- date active and end date active on HR_LOOKUPS.
4179: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4181: -- 'Y' and the effective start date of the person is between start
4182: -- date active and end date active on HR_LOOKUPS.
4175: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4177: -- 'Y' and the effective start date of the person is between start
4178: -- date active and end date active on HR_LOOKUPS.
4179: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4181: -- 'Y' and the effective start date of the person is between start
4182: -- date active and end date active on HR_LOOKUPS.
4183: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4178: -- date active and end date active on HR_LOOKUPS.
4179: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4181: -- 'Y' and the effective start date of the person is between start
4182: -- date active and end date active on HR_LOOKUPS.
4183: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4184: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4185: -- 'Y' and the effective start date of the person is between start
4186: -- date active and end date active on HR_LOOKUPS.
4179: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4181: -- 'Y' and the effective start date of the person is between start
4182: -- date active and end date active on HR_LOOKUPS.
4183: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4184: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4185: -- 'Y' and the effective start date of the person is between start
4186: -- date active and end date active on HR_LOOKUPS.
4187: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4182: -- date active and end date active on HR_LOOKUPS.
4183: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4184: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4185: -- 'Y' and the effective start date of the person is between start
4186: -- date active and end date active on HR_LOOKUPS.
4187: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4188: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4189: -- 'Y' and the effective start date of the person is between start
4190: -- date active and end date active on HR_LOOKUPS.
4183: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4184: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4185: -- 'Y' and the effective start date of the person is between start
4186: -- date active and end date active on HR_LOOKUPS.
4187: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4188: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4189: -- 'Y' and the effective start date of the person is between start
4190: -- date active and end date active on HR_LOOKUPS.
4191: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4186: -- date active and end date active on HR_LOOKUPS.
4187: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4188: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4189: -- 'Y' and the effective start date of the person is between start
4190: -- date active and end date active on HR_LOOKUPS.
4191: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4192: -- exist as a lookup code in HR_LOOKUPS for the lookup type
4193: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4194: -- effective start date of the person is between start date active
4188: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4189: -- 'Y' and the effective start date of the person is between start
4190: -- date active and end date active on HR_LOOKUPS.
4191: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4192: -- exist as a lookup code in HR_LOOKUPS for the lookup type
4193: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4194: -- effective start date of the person is between start date active
4195: -- and end date active on HR_LOOKUPS.
4196: --
4191: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4192: -- exist as a lookup code in HR_LOOKUPS for the lookup type
4193: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4194: -- effective start date of the person is between start date active
4195: -- and end date active on HR_LOOKUPS.
4196: --
4197: -- 9) per_information9 value does not exists in hr_lookups
4198: -- where lookup_type = 'YES_NO'
4199: --
4193: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4194: -- effective start date of the person is between start date active
4195: -- and end date active on HR_LOOKUPS.
4196: --
4197: -- 9) per_information9 value does not exists in hr_lookups
4198: -- where lookup_type = 'YES_NO'
4199: --
4200: -- 10) per information10 does not exist as a lookup code in HR_LOOKUPS
4201: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4196: --
4197: -- 9) per_information9 value does not exists in hr_lookups
4198: -- where lookup_type = 'YES_NO'
4199: --
4200: -- 10) per information10 does not exist as a lookup code in HR_LOOKUPS
4201: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4202: -- the effective start date of the person is between start date
4203: -- active and end date active on HR_LOOKUPS.
4204: --
4199: --
4200: -- 10) per information10 does not exist as a lookup code in HR_LOOKUPS
4201: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4202: -- the effective start date of the person is between start date
4203: -- active and end date active on HR_LOOKUPS.
4204: --
4205: -- 11) per_information11 to 20 values are not null
4206: --
4207: -- Access Status:
4298: or (NOT p_api_updating))
4299: and p_per_information1 is not null)
4300: then
4301: --
4302: -- Check that per information1 exists in hr_lookups for the
4303: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4304: -- and that the effective start date of the person is between start
4305: -- date active and end date active in hr_lookups.
4306: --
4301: --
4302: -- Check that per information1 exists in hr_lookups for the
4303: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4304: -- and that the effective start date of the person is between start
4305: -- date active and end date active in hr_lookups.
4306: --
4307: if hr_api.not_exists_in_dt_hr_lookups
4308: (p_effective_date => p_effective_date
4309: ,p_validation_start_date => p_validation_start_date
4303: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4304: -- and that the effective start date of the person is between start
4305: -- date active and end date active in hr_lookups.
4306: --
4307: if hr_api.not_exists_in_dt_hr_lookups
4308: (p_effective_date => p_effective_date
4309: ,p_validation_start_date => p_validation_start_date
4310: ,p_validation_end_date => p_validation_end_date
4311: ,p_lookup_type => 'US_ETHNIC_GROUP'
4335: (NOT p_api_updating)) and
4336: p_per_information2 is not null)
4337: then
4338: --
4339: -- Check that per information2 exists in hr_lookups for the
4340: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4341: -- the effective start date of the person is between start date
4342: -- active and end date active in hr_lookups.
4343: --
4338: --
4339: -- Check that per information2 exists in hr_lookups for the
4340: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4341: -- the effective start date of the person is between start date
4342: -- active and end date active in hr_lookups.
4343: --
4344: if hr_api.not_exists_in_dt_hr_lookups
4345: (p_effective_date => p_effective_date
4346: ,p_validation_start_date => p_validation_start_date
4340: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4341: -- the effective start date of the person is between start date
4342: -- active and end date active in hr_lookups.
4343: --
4344: if hr_api.not_exists_in_dt_hr_lookups
4345: (p_effective_date => p_effective_date
4346: ,p_validation_start_date => p_validation_start_date
4347: ,p_validation_end_date => p_validation_end_date
4348: ,p_lookup_type => 'PER_US_I9_STATE'
4398: (NOT p_api_updating)) and
4399: p_per_information4 is not null)
4400: then
4401: --
4402: -- Check that per information4 exists in hr_lookups for the
4403: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4404: -- and that the effective start date of the person is between start
4405: -- date active and end date active in hr_lookups.
4406: --
4401: --
4402: -- Check that per information4 exists in hr_lookups for the
4403: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4404: -- and that the effective start date of the person is between start
4405: -- date active and end date active in hr_lookups.
4406: --
4407: if hr_api.not_exists_in_dt_hr_lookups
4408: (p_effective_date => p_effective_date
4409: ,p_validation_start_date => p_validation_start_date
4403: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4404: -- and that the effective start date of the person is between start
4405: -- date active and end date active in hr_lookups.
4406: --
4407: if hr_api.not_exists_in_dt_hr_lookups
4408: (p_effective_date => p_effective_date
4409: ,p_validation_start_date => p_validation_start_date
4410: ,p_validation_end_date => p_validation_end_date
4411: ,p_lookup_type => 'US_VISA_TYPE'
4435: (NOT p_api_updating)) and
4436: p_per_information5 is not null)
4437: then
4438: --
4439: -- Check that per information5 exists in hr_lookups for the
4440: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4441: -- and that the effective start date of the person is between start
4442: -- date active and end date active in hr_lookups.
4443: --
4438: --
4439: -- Check that per information5 exists in hr_lookups for the
4440: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4441: -- and that the effective start date of the person is between start
4442: -- date active and end date active in hr_lookups.
4443: --
4444: if hr_api.not_exists_in_dt_hr_lookups
4445: (p_effective_date => p_effective_date
4446: ,p_validation_start_date => p_validation_start_date
4440: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4441: -- and that the effective start date of the person is between start
4442: -- date active and end date active in hr_lookups.
4443: --
4444: if hr_api.not_exists_in_dt_hr_lookups
4445: (p_effective_date => p_effective_date
4446: ,p_validation_start_date => p_validation_start_date
4447: ,p_validation_end_date => p_validation_end_date
4448: ,p_lookup_type => 'US_VETERAN_STATUS'
4472: (NOT p_api_updating)) and
4473: p_per_information6 is not null)
4474: then
4475: --
4476: -- Check that per information6 exists in hr_lookups for the
4477: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4478: -- the effective start date of the person is between start date
4479: -- active and end date active in hr_lookups.
4480: --
4475: --
4476: -- Check that per information6 exists in hr_lookups for the
4477: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4478: -- the effective start date of the person is between start date
4479: -- active and end date active in hr_lookups.
4480: --
4481: if hr_api.not_exists_in_dt_hr_lookups
4482: (p_effective_date => p_effective_date
4483: ,p_validation_start_date => p_validation_start_date
4477: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4478: -- the effective start date of the person is between start date
4479: -- active and end date active in hr_lookups.
4480: --
4481: if hr_api.not_exists_in_dt_hr_lookups
4482: (p_effective_date => p_effective_date
4483: ,p_validation_start_date => p_validation_start_date
4484: ,p_validation_end_date => p_validation_end_date
4485: ,p_lookup_type => 'YES_NO'
4509: (NOT p_api_updating)) and
4510: p_per_information7 is not null)
4511: then
4512: --
4513: -- Check that per information7 exists in hr_lookups for the
4514: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4515: -- and that the effective start date of the person is between start
4516: -- date active and end date active in hr_lookups.
4517: --
4512: --
4513: -- Check that per information7 exists in hr_lookups for the
4514: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4515: -- and that the effective start date of the person is between start
4516: -- date active and end date active in hr_lookups.
4517: --
4518: if hr_api.not_exists_in_dt_hr_lookups
4519: (p_effective_date => p_effective_date
4520: ,p_validation_start_date => p_validation_start_date
4514: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4515: -- and that the effective start date of the person is between start
4516: -- date active and end date active in hr_lookups.
4517: --
4518: if hr_api.not_exists_in_dt_hr_lookups
4519: (p_effective_date => p_effective_date
4520: ,p_validation_start_date => p_validation_start_date
4521: ,p_validation_end_date => p_validation_end_date
4522: ,p_lookup_type => 'US_NEW_HIRE_STATUS'
4557: hr_utility.set_message(801, 'HR_51286_PER_INFO8_NOT_NULL');
4558: hr_utility.raise_error;
4559: else
4560: --
4561: -- Check that per information7 exists in hr_lookups for the
4562: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4563: -- and that the effective start date of the person is between start
4564: -- date active and end date active in hr_lookups.
4565: --
4560: --
4561: -- Check that per information7 exists in hr_lookups for the
4562: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4563: -- and that the effective start date of the person is between start
4564: -- date active and end date active in hr_lookups.
4565: --
4566: if hr_api.not_exists_in_dt_hr_lookups
4567: (p_effective_date => p_effective_date
4568: ,p_validation_start_date => p_validation_start_date
4562: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4563: -- and that the effective start date of the person is between start
4564: -- date active and end date active in hr_lookups.
4565: --
4566: if hr_api.not_exists_in_dt_hr_lookups
4567: (p_effective_date => p_effective_date
4568: ,p_validation_start_date => p_validation_start_date
4569: ,p_validation_end_date => p_validation_end_date
4570: ,p_lookup_type => 'US_NEW_HIRE_EXCEPTIONS'
4595: (NOT p_api_updating)) and
4596: p_per_information9 is not null)
4597: then
4598: --
4599: -- Check that per information9 exists in hr_lookups for the
4600: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4601: -- the effective start date of the person is between start date
4602: -- active and end date active in hr_lookups.
4603: --
4598: --
4599: -- Check that per information9 exists in hr_lookups for the
4600: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4601: -- the effective start date of the person is between start date
4602: -- active and end date active in hr_lookups.
4603: --
4604: if hr_api.not_exists_in_dt_hr_lookups
4605: (p_effective_date => p_effective_date
4606: ,p_validation_start_date => p_validation_start_date
4600: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4601: -- the effective start date of the person is between start date
4602: -- active and end date active in hr_lookups.
4603: --
4604: if hr_api.not_exists_in_dt_hr_lookups
4605: (p_effective_date => p_effective_date
4606: ,p_validation_start_date => p_validation_start_date
4607: ,p_validation_end_date => p_validation_end_date
4608: ,p_lookup_type => 'YES_NO'
4629: (NOT p_api_updating)) and
4630: p_per_information10 is not null)
4631: then
4632: --
4633: -- Check that per information10 exists in hr_lookups for the
4634: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4635: -- the effective start date of the person is between start date
4636: -- active and end date active in hr_lookups.
4637: --
4632: --
4633: -- Check that per information10 exists in hr_lookups for the
4634: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4635: -- the effective start date of the person is between start date
4636: -- active and end date active in hr_lookups.
4637: --
4638: if hr_api.not_exists_in_dt_hr_lookups
4639: (p_effective_date => p_effective_date
4640: ,p_validation_start_date => p_validation_start_date
4634: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4635: -- the effective start date of the person is between start date
4636: -- active and end date active in hr_lookups.
4637: --
4638: if hr_api.not_exists_in_dt_hr_lookups
4639: (p_effective_date => p_effective_date
4640: ,p_validation_start_date => p_validation_start_date
4641: ,p_validation_end_date => p_validation_end_date
4642: ,p_lookup_type => 'YES_NO'
4821: --
4822: -- We know the per_information_category is JP, so check the rest of
4823: -- the per_information fields within this context.
4824: --
4825: -- Check if the per_information1 value exists in hr_lookups
4826: -- where the lookup_type is 'YES_NO'
4827: --
4828: if p_per_information1 is not null then
4829: --
4826: -- where the lookup_type is 'YES_NO'
4827: --
4828: if p_per_information1 is not null then
4829: --
4830: -- Check that per information1 exists in hr_lookups for the
4831: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4832: -- the effective start date of the person is between start date
4833: -- active and end date active in hr_lookups.
4834: --
4829: --
4830: -- Check that per information1 exists in hr_lookups for the
4831: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4832: -- the effective start date of the person is between start date
4833: -- active and end date active in hr_lookups.
4834: --
4835: if hr_api.not_exists_in_dt_hr_lookups
4836: (p_effective_date => p_effective_date
4837: ,p_validation_start_date => p_validation_start_date
4831: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4832: -- the effective start date of the person is between start date
4833: -- active and end date active in hr_lookups.
4834: --
4835: if hr_api.not_exists_in_dt_hr_lookups
4836: (p_effective_date => p_effective_date
4837: ,p_validation_start_date => p_validation_start_date
4838: ,p_validation_end_date => p_validation_end_date
4839: ,p_lookup_type => 'YES_NO'
4853: if g_debug then
4854: hr_utility.set_location(l_proc,40);
4855: end if;
4856: --
4857: -- Check if the per_information2 value exists in hr_lookups
4858: -- where the lookup_type is 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'
4859: --
4860: if p_per_information2 is not null then
4861: --
4858: -- where the lookup_type is 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'
4859: --
4860: if p_per_information2 is not null then
4861: --
4862: -- Check that per information2 exists in hr_lookups for the
4863: -- lookup type 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE' with an enabled
4864: -- flag set to 'Y' and that
4865: -- the effective start date of the person is between start date
4866: -- active and end date active in hr_lookups.
4862: -- Check that per information2 exists in hr_lookups for the
4863: -- lookup type 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE' with an enabled
4864: -- flag set to 'Y' and that
4865: -- the effective start date of the person is between start date
4866: -- active and end date active in hr_lookups.
4867: --
4868: if hr_api.not_exists_in_dt_hr_lookups
4869: (p_effective_date => p_effective_date
4870: ,p_validation_start_date => p_validation_start_date
4864: -- flag set to 'Y' and that
4865: -- the effective start date of the person is between start date
4866: -- active and end date active in hr_lookups.
4867: --
4868: if hr_api.not_exists_in_dt_hr_lookups
4869: (p_effective_date => p_effective_date
4870: ,p_validation_start_date => p_validation_start_date
4871: ,p_validation_end_date => p_validation_end_date
4872: ,p_lookup_type => 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'