[Home] [Help]
1022: -- ---------------------------------------------------------------------------
1023: --
1024: -- Description:
1025: -- - Validates that the marital status exists as a lookup code on
1026: -- HR_LOOKUPS for the lookup type 'MAR_STATUS' with an enabled
1027: -- flag set to 'Y' and the effective start date of the person between
1028: -- start date active and end date active on HR_LOOKUPS.
1029: --
1030: -- Pre-conditions:
1024: -- Description:
1025: -- - Validates that the marital status exists as a lookup code on
1026: -- HR_LOOKUPS for the lookup type 'MAR_STATUS' with an enabled
1027: -- flag set to 'Y' and the effective start date of the person between
1028: -- start date active and end date active on HR_LOOKUPS.
1029: --
1030: -- Pre-conditions:
1031: -- None
1032: --
1039: -- p_object_version_number
1040: --
1041: -- Post Success:
1042: -- Processing continues if:
1043: -- - marital status exists as a lookup code in HR_LOOKUPS
1044: -- for the lookup type 'MAR_STATUS' where the enabled
1045: -- flag is 'Y' and the effective start date of the person
1046: -- is between start date active and end date active on HR_LOOKUPS.
1047: --
1042: -- Processing continues if:
1043: -- - marital status exists as a lookup code in HR_LOOKUPS
1044: -- for the lookup type 'MAR_STATUS' where the enabled
1045: -- flag is 'Y' and the effective start date of the person
1046: -- is between start date active and end date active on HR_LOOKUPS.
1047: --
1048: -- Post Failure:
1049: -- An application error is raised and processing is terminated if:
1050: -- - marital status does'nt exist as a lookup code in HR_LOOKUPS
1046: -- is between start date active and end date active on HR_LOOKUPS.
1047: --
1048: -- Post Failure:
1049: -- An application error is raised and processing is terminated if:
1050: -- - marital status does'nt exist as a lookup code in HR_LOOKUPS
1051: -- for the lookup type 'MAR_STATUS' where the enabled
1052: -- flag is 'Y' and the effective start date of the person
1053: -- is between start date active and end date active on HR_LOOKUPS.
1054: --
1049: -- An application error is raised and processing is terminated if:
1050: -- - marital status does'nt exist as a lookup code in HR_LOOKUPS
1051: -- for the lookup type 'MAR_STATUS' where the enabled
1052: -- flag is 'Y' and the effective start date of the person
1053: -- is between start date active and end date active on HR_LOOKUPS.
1054: --
1055: -- Access Status:
1056: -- Internal Table Handler Use Only.
1057: --
1120: -- Check if marital status is set
1121: --
1122: If p_marital_status is not null then
1123: --
1124: -- Check that the marital status exists in hr_lookups for the
1125: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1126: -- the effective start date of the person is between start date
1127: -- active and end date active in hr_lookups.
1128: --
1123: --
1124: -- Check that the marital status exists in hr_lookups for the
1125: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1126: -- the effective start date of the person is between start date
1127: -- active and end date active in hr_lookups.
1128: --
1129: if hr_api.not_exists_in_dt_hr_lookups
1130: (p_effective_date => p_effective_date
1131: ,p_validation_start_date => p_validation_start_date
1125: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1126: -- the effective start date of the person is between start date
1127: -- active and end date active in hr_lookups.
1128: --
1129: if hr_api.not_exists_in_dt_hr_lookups
1130: (p_effective_date => p_effective_date
1131: ,p_validation_start_date => p_validation_start_date
1132: ,p_validation_end_date => p_validation_end_date
1133: ,p_lookup_type => 'MAR_STATUS'
1293: --
1294: -- Description:
1295: -- Checks that a nationality value is valid
1296: -- - Validates that the nationality exists as a lookup code on
1297: -- HR_LOOKUPS for the lookup type 'NATIONALITY' with an enabled
1298: -- flag set to 'Y' and the effective start date of the person between
1299: -- start date active and end date active on HR_LOOKUPS.
1300: --
1301: -- Pre-conditions:
1295: -- Checks that a nationality value is valid
1296: -- - Validates that the nationality exists as a lookup code on
1297: -- HR_LOOKUPS for the lookup type 'NATIONALITY' with an enabled
1298: -- flag set to 'Y' and the effective start date of the person between
1299: -- start date active and end date active on HR_LOOKUPS.
1300: --
1301: -- Pre-conditions:
1302: -- None
1303: --
1310: -- p_object_version_number
1311: --
1312: -- Post Success:
1313: -- Processing continues if:
1314: -- - nationality exists as a lookup code in HR_LOOKUPS
1315: -- for the lookup type 'NATIONALITY' where the enabled
1316: -- flag is 'Y' and the effective start date of the person
1317: -- is between start date active and end date active on HR_LOOKUPS.
1318: --
1313: -- Processing continues if:
1314: -- - nationality exists as a lookup code in HR_LOOKUPS
1315: -- for the lookup type 'NATIONALITY' where the enabled
1316: -- flag is 'Y' and the effective start date of the person
1317: -- is between start date active and end date active on HR_LOOKUPS.
1318: --
1319: -- Post Failure:
1320: -- An application error is raised and processing is terminated if:
1321: -- - nationality does'nt exist as a lookup code in HR_LOOKUPS
1317: -- is between start date active and end date active on HR_LOOKUPS.
1318: --
1319: -- Post Failure:
1320: -- An application error is raised and processing is terminated if:
1321: -- - nationality does'nt exist as a lookup code in HR_LOOKUPS
1322: -- for the lookup type 'NATIONALITY' where the enabled
1323: -- flag is 'Y' and the effective start date of the person
1324: -- is between start date active and end date active on HR_LOOKUPS.
1325: --
1320: -- An application error is raised and processing is terminated if:
1321: -- - nationality does'nt exist as a lookup code in HR_LOOKUPS
1322: -- for the lookup type 'NATIONALITY' where the enabled
1323: -- flag is 'Y' and the effective start date of the person
1324: -- is between start date active and end date active on HR_LOOKUPS.
1325: --
1326: -- Access Status:
1327: -- Internal Table Handler Use Only.
1328: --
1387: -- Check if nationality is set
1388: --
1389: if p_nationality is not null then
1390: --
1391: -- Check that the nationality exists in hr_lookups for the
1392: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1393: -- the effective start date of the person is between start date
1394: -- active and end date active in hr_lookups.
1395: --
1390: --
1391: -- Check that the nationality exists in hr_lookups for the
1392: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1393: -- the effective start date of the person is between start date
1394: -- active and end date active in hr_lookups.
1395: --
1396: if hr_api.not_exists_in_dt_hr_lookups
1397: (p_effective_date => p_effective_date
1398: ,p_validation_start_date => p_validation_start_date
1392: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1393: -- the effective start date of the person is between start date
1394: -- active and end date active in hr_lookups.
1395: --
1396: if hr_api.not_exists_in_dt_hr_lookups
1397: (p_effective_date => p_effective_date
1398: ,p_validation_start_date => p_validation_start_date
1399: ,p_validation_end_date => p_validation_end_date
1400: ,p_lookup_type => 'NATIONALITY'
2518: -- ---------------------------------------------------------------------------
2519: --
2520: -- Description:
2521: -- - Validates that the expense check send to address exists as a lookup
2522: -- code on HR_LOOKUPS for the lookup type 'HOME_OFFICE' with an enabled
2523: -- flag set to 'Y' and the effective start date of the person between
2524: -- start date active and end date active on HR_LOOKUPS.
2525: --
2526: -- Pre-conditions:
2520: -- Description:
2521: -- - Validates that the expense check send to address exists as a lookup
2522: -- code on HR_LOOKUPS for the lookup type 'HOME_OFFICE' with an enabled
2523: -- flag set to 'Y' and the effective start date of the person between
2524: -- start date active and end date active on HR_LOOKUPS.
2525: --
2526: -- Pre-conditions:
2527: -- None
2528: --
2534: -- p_object_version_number
2535: --
2536: -- Post Success:
2537: -- Processing continues if:
2538: -- - expense check send to address exists as a lookup code in HR_LOOKUPS
2539: -- for the lookup type 'HOME_OFFICE' where the enabled flag is 'Y' and
2540: -- the effective start date of the person is between start date active
2541: -- and end date active on HR_LOOKUPS.
2542: --
2537: -- Processing continues if:
2538: -- - expense check send to address exists as a lookup code in HR_LOOKUPS
2539: -- for the lookup type 'HOME_OFFICE' where the enabled flag is 'Y' and
2540: -- the effective start date of the person is between start date active
2541: -- and end date active on HR_LOOKUPS.
2542: --
2543: -- Post Failure:
2544: -- An application error is raised and processing is terminated if:
2545: -- - expense check send to address does'nt exist as a lookup code in
2542: --
2543: -- Post Failure:
2544: -- An application error is raised and processing is terminated if:
2545: -- - expense check send to address does'nt exist as a lookup code in
2546: -- HR_LOOKUPS for the lookup type 'HOME_OFFICE' where the enabled
2547: -- flag is 'Y' and the effective start date of the person
2548: -- is between start date active and end date active on HR_LOOKUPS.
2549: --
2550: -- Access Status:
2544: -- An application error is raised and processing is terminated if:
2545: -- - expense check send to address does'nt exist as a lookup code in
2546: -- HR_LOOKUPS for the lookup type 'HOME_OFFICE' where the enabled
2547: -- flag is 'Y' and the effective start date of the person
2548: -- is between start date active and end date active on HR_LOOKUPS.
2549: --
2550: -- Access Status:
2551: -- Internal Table Handler Use Only.
2552: --
2620: -- Check if expense check send to address is set
2621: --
2622: If p_expense_check_send_to_addres is not null then
2623: --
2624: -- Check that the expense check send to address exists in hr_lookups for the
2625: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2626: -- the effective start date of the person is between start date
2627: -- active and end date active in hr_lookups.
2628: --
2623: --
2624: -- Check that the expense check send to address exists in hr_lookups for the
2625: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2626: -- the effective start date of the person is between start date
2627: -- active and end date active in hr_lookups.
2628: --
2629: if hr_api.not_exists_in_dt_hr_lookups
2630: (p_effective_date => p_effective_date
2631: ,p_validation_start_date => p_validation_start_date
2625: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2626: -- the effective start date of the person is between start date
2627: -- active and end date active in hr_lookups.
2628: --
2629: if hr_api.not_exists_in_dt_hr_lookups
2630: (p_effective_date => p_effective_date
2631: ,p_validation_start_date => p_validation_start_date
2632: ,p_validation_end_date => p_validation_end_date
2633: ,p_lookup_type => 'HOME_OFFICE'
2673: -- ---------------------------------------------------------------------------
2674: --
2675: -- Description:
2676: -- - Validates that the sex exists as a lookup code on
2677: -- HR_LOOKUPS for the lookup type 'SEX' with an enabled
2678: -- flag set to 'Y' and the effective start date of the person between
2679: -- start date active and end date active on HR_LOOKUPS.
2680: -- - Validates that the title exists as a lookup code on
2681: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2675: -- Description:
2676: -- - Validates that the sex exists as a lookup code on
2677: -- HR_LOOKUPS for the lookup type 'SEX' with an enabled
2678: -- flag set to 'Y' and the effective start date of the person between
2679: -- start date active and end date active on HR_LOOKUPS.
2680: -- - Validates that the title exists as a lookup code on
2681: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2682: -- flag set to 'Y' and the effective start date of the person between
2683: -- start date active and end date active on HR_LOOKUPS.
2677: -- HR_LOOKUPS for the lookup type 'SEX' with an enabled
2678: -- flag set to 'Y' and the effective start date of the person between
2679: -- start date active and end date active on HR_LOOKUPS.
2680: -- - Validates that the title exists as a lookup code on
2681: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2682: -- flag set to 'Y' and the effective start date of the person between
2683: -- start date active and end date active on HR_LOOKUPS.
2684: --
2685: -- Pre-conditions:
2679: -- start date active and end date active on HR_LOOKUPS.
2680: -- - Validates that the title exists as a lookup code on
2681: -- HR_LOOKUPS for the lookup type 'TITLE' with an enabled
2682: -- flag set to 'Y' and the effective start date of the person between
2683: -- start date active and end date active on HR_LOOKUPS.
2684: --
2685: -- Pre-conditions:
2686: -- A valid person type
2687: --
2697: -- p_object_version_number
2698: --
2699: -- Post Success:
2700: -- Processing continues if:
2701: -- - a sex exists as a lookup code in HR_LOOKUPS for the lookup type
2702: -- 'SEX' where the enabled flag is 'Y' and the effective start
2703: -- date of the person is between start date active and end date
2704: -- active on HR_LOOKUPS.
2705: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2700: -- Processing continues if:
2701: -- - a sex exists as a lookup code in HR_LOOKUPS for the lookup type
2702: -- 'SEX' where the enabled flag is 'Y' and the effective start
2703: -- date of the person is between start date active and end date
2704: -- active on HR_LOOKUPS.
2705: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2706: -- 'TITLE' where the enabled flag is 'Y' and the effective start
2707: -- date of the person is between start date active and end date
2708: -- active on HR_LOOKUPS.
2701: -- - a sex exists as a lookup code in HR_LOOKUPS for the lookup type
2702: -- 'SEX' where the enabled flag is 'Y' and the effective start
2703: -- date of the person is between start date active and end date
2704: -- active on HR_LOOKUPS.
2705: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2706: -- 'TITLE' where the enabled flag is 'Y' and the effective start
2707: -- date of the person is between start date active and end date
2708: -- active on HR_LOOKUPS.
2709: -- - a sex value is 'M' and the title value is not 'MISS','MRS.',
2704: -- active on HR_LOOKUPS.
2705: -- - a title exists as a lookup code in HR_LOOKUPS for the lookup type
2706: -- 'TITLE' where the enabled flag is 'Y' and the effective start
2707: -- date of the person is between start date active and end date
2708: -- active on HR_LOOKUPS.
2709: -- - a sex value is 'M' and the title value is not 'MISS','MRS.',
2710: -- 'MS.'
2711: -- - a sex value is 'F' and the title value is 'MR'.
2712: -- - the related system person type is 'EMP' and a sex value is
2713: -- set.
2714: --
2715: -- Post Failure:
2716: -- An application error is raised and processing is terminated if:
2717: -- - a sex does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2718: -- type 'SEX' where the enabled flag is 'Y' and the effective start
2719: -- date of the person is between start date active and end date
2720: -- active on HR_LOOKUPS.
2721: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2716: -- An application error is raised and processing is terminated if:
2717: -- - a sex does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2718: -- type 'SEX' where the enabled flag is 'Y' and the effective start
2719: -- date of the person is between start date active and end date
2720: -- active on HR_LOOKUPS.
2721: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2722: -- type 'TITLE' where the enabled flag is 'Y' and the effective start
2723: -- date of the person is between start date active and end date
2724: -- active on HR_LOOKUPS.
2717: -- - a sex does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2718: -- type 'SEX' where the enabled flag is 'Y' and the effective start
2719: -- date of the person is between start date active and end date
2720: -- active on HR_LOOKUPS.
2721: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2722: -- type 'TITLE' where the enabled flag is 'Y' and the effective start
2723: -- date of the person is between start date active and end date
2724: -- active on HR_LOOKUPS.
2725: -- - a sex value is 'M' and the title value is 'MISS','MRS.', 'MS.'
2720: -- active on HR_LOOKUPS.
2721: -- - a title does'nt exist as a lookup code in HR_LOOKUPS for the lookup
2722: -- type 'TITLE' where the enabled flag is 'Y' and the effective start
2723: -- date of the person is between start date active and end date
2724: -- active on HR_LOOKUPS.
2725: -- - a sex value is 'M' and the title value is 'MISS','MRS.', 'MS.'
2726: -- - a sex value is 'F' and the title value is 'MR.'
2727: -- - the related system person type is 'EMP' and a sex value is not
2728: -- set.
2807: -- Check if title is set
2808: --
2809: If p_title is not null then
2810: --
2811: -- Check that the title exists in hr_lookups for the lookup type
2812: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2813: -- start date of the person is between start date active and end
2814: -- date active in hr_lookups.
2815: --
2810: --
2811: -- Check that the title exists in hr_lookups for the lookup type
2812: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2813: -- start date of the person is between start date active and end
2814: -- date active in hr_lookups.
2815: --
2816: if hr_api.not_exists_in_dt_hr_lookups
2817: (p_effective_date => p_effective_date
2818: ,p_validation_start_date => p_validation_start_date
2812: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2813: -- start date of the person is between start date active and end
2814: -- date active in hr_lookups.
2815: --
2816: if hr_api.not_exists_in_dt_hr_lookups
2817: (p_effective_date => p_effective_date
2818: ,p_validation_start_date => p_validation_start_date
2819: ,p_validation_end_date => p_validation_end_date
2820: ,p_lookup_type => 'TITLE'
2837: -- Check if sex is set
2838: --
2839: If p_sex is not null then
2840: --
2841: -- Check that the sex exists in hr_lookups for the lookup type
2842: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2843: -- start date of the person is between start date active and end
2844: -- date active in hr_lookups.
2845: --
2840: --
2841: -- Check that the sex exists in hr_lookups for the lookup type
2842: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2843: -- start date of the person is between start date active and end
2844: -- date active in hr_lookups.
2845: --
2846: if hr_api.not_exists_in_dt_hr_lookups
2847: (p_effective_date => p_effective_date
2848: ,p_validation_start_date => p_validation_start_date
2842: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2843: -- start date of the person is between start date active and end
2844: -- date active in hr_lookups.
2845: --
2846: if hr_api.not_exists_in_dt_hr_lookups
2847: (p_effective_date => p_effective_date
2848: ,p_validation_start_date => p_validation_start_date
2849: ,p_validation_end_date => p_validation_end_date
2850: ,p_lookup_type => 'SEX'
2965: WHERE upper(plfi.field_name) = 'TOWN_OF_BIRTH'
2966: AND plfi.legislation_code = p_legislation_code;
2967: --
2968: l_exists varchar2(1);
2969: l_lookup_type hr_lookups.lookup_type%TYPE;
2970: l_proc varchar2(72);
2971: --
2972: begin
2973: if g_debug then
2994: if csr_plfi%found then
2995: close csr_plfi;
2996: -- attempt to decode the lookup type returned from plfi record
2997: -- with the p_town_of_birth lookup_value supplied to the api.
2998: if hr_api.not_exists_in_dt_hr_lookups
2999: (p_effective_date => p_effective_date
3000: ,p_validation_start_date => p_validation_start_date
3001: ,p_validation_end_date => p_validation_end_date
3002: ,p_lookup_type => l_lookup_type
3079: WHERE upper(plfi.field_name) = 'REGION_OF_BIRTH'
3080: AND plfi.legislation_code = p_legislation_code;
3081: --
3082: l_exists varchar2(1);
3083: l_lookup_type hr_lookups.lookup_type%TYPE;
3084: l_proc varchar2(72);
3085: --
3086: begin
3087: if g_debug then
3108: if csr_plfi%found then
3109: close csr_plfi;
3110: -- attempt to decode the lookup type returned from plfi record
3111: -- with the p_region_of_birth lookup_value supplied to the api.
3112: if hr_api.not_exists_in_dt_hr_lookups
3113: (p_effective_date => p_effective_date
3114: ,p_validation_start_date => p_validation_start_date
3115: ,p_validation_end_date => p_validation_end_date
3116: ,p_lookup_type => l_lookup_type
3520: -- - Checks that the values held in developer descriptive flexfields
3521: -- are valid for a category of 'GB'
3522: -- - Validates that per information3 and per information11 to 20 are null.
3523: -- - Validates that per information2, 4 ,9 and 10 exists as a lookup code on
3524: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag set to 'Y'
3525: -- and the effective start date of the person between start date active
3526: -- and end date active on HR_LOOKUPS.
3527: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3528: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3522: -- - Validates that per information3 and per information11 to 20 are null.
3523: -- - Validates that per information2, 4 ,9 and 10 exists as a lookup code on
3524: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag set to 'Y'
3525: -- and the effective start date of the person between start date active
3526: -- and end date active on HR_LOOKUPS.
3527: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3528: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3529: -- effective start date of the person between start date active and end
3530: -- date active on HR_LOOKUPS.
3523: -- - Validates that per information2, 4 ,9 and 10 exists as a lookup code on
3524: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag set to 'Y'
3525: -- and the effective start date of the person between start date active
3526: -- and end date active on HR_LOOKUPS.
3527: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3528: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3529: -- effective start date of the person between start date active and end
3530: -- date active on HR_LOOKUPS.
3531: -- - Validates that per information5 is less than or equal to 30 characters
3526: -- and end date active on HR_LOOKUPS.
3527: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
3528: -- for the lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and the
3529: -- effective start date of the person between start date active and end
3530: -- date active on HR_LOOKUPS.
3531: -- - Validates that per information5 is less than or equal to 30 characters
3532: -- and in uppercase.
3533: --
3534: -- Pre-conditions:
3564: --
3565: -- Post Success:
3566: -- Processing continues if:
3567: -- - per_information3 and per_information11 to 20 values are null
3568: -- - per information2, 4 , 9 and 10 exists as a lookup code in HR_LOOKUPS
3569: -- for the lookup type 'YES_NO' where the enabled flag is 'Y'
3570: -- and the effective start date of the person is between start
3571: -- date active and end date active on HR_LOOKUPS.
3572: -- - per information1 exists as a lookup code in HR_LOOKUPS
3567: -- - per_information3 and per_information11 to 20 values are null
3568: -- - per information2, 4 , 9 and 10 exists as a lookup code in HR_LOOKUPS
3569: -- for the lookup type 'YES_NO' where the enabled flag is 'Y'
3570: -- and the effective start date of the person is between start
3571: -- date active and end date active on HR_LOOKUPS.
3572: -- - per information1 exists as a lookup code in HR_LOOKUPS
3573: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3574: -- and the effective start date of the person is between start
3575: -- date active and end date active on HR_LOOKUPS.
3568: -- - per information2, 4 , 9 and 10 exists as a lookup code in HR_LOOKUPS
3569: -- for the lookup type 'YES_NO' where the enabled flag is 'Y'
3570: -- and the effective start date of the person is between start
3571: -- date active and end date active on HR_LOOKUPS.
3572: -- - per information1 exists as a lookup code in HR_LOOKUPS
3573: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3574: -- and the effective start date of the person is between start
3575: -- date active and end date active on HR_LOOKUPS.
3576: -- - per_information5 is less than or equal to 30 characters long
3571: -- date active and end date active on HR_LOOKUPS.
3572: -- - per information1 exists as a lookup code in HR_LOOKUPS
3573: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3574: -- and the effective start date of the person is between start
3575: -- date active and end date active on HR_LOOKUPS.
3576: -- - per_information5 is less than or equal to 30 characters long
3577: -- and upper case.
3578: --
3579: -- Post Failure:
3580: -- An application error is raised and processing is terminated if:
3581: -- - any of per_information3 and per_information10 to 20 values are
3582: -- not null.
3583: -- - any of per information2, 4,9 and 10 does'nt exist as a lookup code
3584: -- in HR_LOOKUPS for the lookup type 'YES_NO' where the enabled flag
3585: -- is 'Y' and the effective start date of the person is between start
3586: -- date active and end date active on HR_LOOKUPS.
3587: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3588: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3582: -- not null.
3583: -- - any of per information2, 4,9 and 10 does'nt exist as a lookup code
3584: -- in HR_LOOKUPS for the lookup type 'YES_NO' where the enabled flag
3585: -- is 'Y' and the effective start date of the person is between start
3586: -- date active and end date active on HR_LOOKUPS.
3587: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3588: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3589: -- and the effective start date of the person is between start
3590: -- date active and end date active on HR_LOOKUPS.
3583: -- - any of per information2, 4,9 and 10 does'nt exist as a lookup code
3584: -- in HR_LOOKUPS for the lookup type 'YES_NO' where the enabled flag
3585: -- is 'Y' and the effective start date of the person is between start
3586: -- date active and end date active on HR_LOOKUPS.
3587: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3588: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3589: -- and the effective start date of the person is between start
3590: -- date active and end date active on HR_LOOKUPS.
3591: -- - per_information5 is not less than or equal to 30 characters long
3586: -- date active and end date active on HR_LOOKUPS.
3587: -- - per information1 does'nt exist as a lookup code in HR_LOOKUPS
3588: -- for the lookup type 'ETH_TYPE' where the enabled flag is 'Y'
3589: -- and the effective start date of the person is between start
3590: -- date active and end date active on HR_LOOKUPS.
3591: -- - per_information5 is not less than or equal to 30 characters long
3592: -- or not upper case.
3593: --
3594: -- Access Status:
3676: --
3677: -- We know the per_information_category is GB, so check the rest of
3678: -- the per_information fields within this context.
3679: --
3680: -- Check if the per_information1 value exists in hr_lookups
3681: -- where the lookup_type is 'ETH_TYPE'
3682: --
3683: if p_per_information1 is not null then
3684: --
3681: -- where the lookup_type is 'ETH_TYPE'
3682: --
3683: if p_per_information1 is not null then
3684: --
3685: -- Check that per information1 exists in hr_lookups for the
3686: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3687: -- the effective start date of the person is between start date
3688: -- active and end date active in hr_lookups.
3689: --
3684: --
3685: -- Check that per information1 exists in hr_lookups for the
3686: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3687: -- the effective start date of the person is between start date
3688: -- active and end date active in hr_lookups.
3689: --
3690: if hr_api.not_exists_in_dt_hr_lookups
3691: (p_effective_date => p_effective_date
3692: ,p_validation_start_date => p_validation_start_date
3686: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3687: -- the effective start date of the person is between start date
3688: -- active and end date active in hr_lookups.
3689: --
3690: if hr_api.not_exists_in_dt_hr_lookups
3691: (p_effective_date => p_effective_date
3692: ,p_validation_start_date => p_validation_start_date
3693: ,p_validation_end_date => p_validation_end_date
3694: ,p_lookup_type => 'ETH_TYPE'
3708: if g_debug then
3709: hr_utility.set_location(l_proc,40);
3710: end if;
3711: --
3712: -- Check if the per_information2 value exists in hr_lookups
3713: -- where the lookup_type is 'YES_NO'
3714: --
3715: if p_per_information2 is not null then
3716: --
3713: -- where the lookup_type is 'YES_NO'
3714: --
3715: if p_per_information2 is not null then
3716: --
3717: -- Check that per information2 exists in hr_lookups for the
3718: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3719: -- the effective start date of the person is between start date
3720: -- active and end date active in hr_lookups.
3721: --
3716: --
3717: -- Check that per information2 exists in hr_lookups for the
3718: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3719: -- the effective start date of the person is between start date
3720: -- active and end date active in hr_lookups.
3721: --
3722: if hr_api.not_exists_in_dt_hr_lookups
3723: (p_effective_date => p_effective_date
3724: ,p_validation_start_date => p_validation_start_date
3718: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3719: -- the effective start date of the person is between start date
3720: -- active and end date active in hr_lookups.
3721: --
3722: if hr_api.not_exists_in_dt_hr_lookups
3723: (p_effective_date => p_effective_date
3724: ,p_validation_start_date => p_validation_start_date
3725: ,p_validation_end_date => p_validation_end_date
3726: ,p_lookup_type => 'YES_NO'
3740: if g_debug then
3741: hr_utility.set_location(l_proc,60);
3742: end if;
3743: --
3744: -- Check if the per_information4 value exists in hr_lookups
3745: -- where the lookup_type is 'YES_NO'
3746: --
3747: if p_per_information4 is not null then
3748: --
3745: -- where the lookup_type is 'YES_NO'
3746: --
3747: if p_per_information4 is not null then
3748: --
3749: -- Check that per information4 exists in hr_lookups for the
3750: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3751: -- the effective start date of the person is between start date
3752: -- active and end date active in hr_lookups.
3753: --
3748: --
3749: -- Check that per information4 exists in hr_lookups for the
3750: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3751: -- the effective start date of the person is between start date
3752: -- active and end date active in hr_lookups.
3753: --
3754: if hr_api.not_exists_in_dt_hr_lookups
3755: (p_effective_date => p_effective_date
3756: ,p_validation_start_date => p_validation_start_date
3750: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3751: -- the effective start date of the person is between start date
3752: -- active and end date active in hr_lookups.
3753: --
3754: if hr_api.not_exists_in_dt_hr_lookups
3755: (p_effective_date => p_effective_date
3756: ,p_validation_start_date => p_validation_start_date
3757: ,p_validation_end_date => p_validation_end_date
3758: ,p_lookup_type => 'YES_NO'
3886: if g_debug then
3887: hr_utility.set_location(l_proc, 190);
3888: end if;
3889: --
3890: -- Check if the per_information9 value exists in hr_lookups
3891: -- where the lookup_type is 'YES_NO'
3892: --
3893: if p_per_information9 is not null then
3894: --
3891: -- where the lookup_type is 'YES_NO'
3892: --
3893: if p_per_information9 is not null then
3894: --
3895: -- Check that per information9 exists in hr_lookups for the
3896: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3897: -- the effective start date of the person is between start date
3898: -- active and end date active in hr_lookups.
3899: --
3894: --
3895: -- Check that per information9 exists in hr_lookups for the
3896: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3897: -- the effective start date of the person is between start date
3898: -- active and end date active in hr_lookups.
3899: --
3900: if hr_api.not_exists_in_dt_hr_lookups
3901: (p_effective_date => p_effective_date
3902: ,p_validation_start_date => p_validation_start_date
3896: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3897: -- the effective start date of the person is between start date
3898: -- active and end date active in hr_lookups.
3899: --
3900: if hr_api.not_exists_in_dt_hr_lookups
3901: (p_effective_date => p_effective_date
3902: ,p_validation_start_date => p_validation_start_date
3903: ,p_validation_end_date => p_validation_end_date
3904: ,p_lookup_type => 'YES_NO'
3922: -- ***** Start new code for bug 2236999 **************
3923:
3924: if p_per_information10 is not null then
3925: --
3926: -- Check that per information10 exists in hr_lookups for the
3927: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3928: -- the effective start date of the person is between start date
3929: -- active and end date active in hr_lookups.
3930: --
3925: --
3926: -- Check that per information10 exists in hr_lookups for the
3927: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3928: -- the effective start date of the person is between start date
3929: -- active and end date active in hr_lookups.
3930: --
3931: if hr_api.not_exists_in_dt_hr_lookups
3932: (p_effective_date => p_effective_date
3933: ,p_validation_start_date => p_validation_start_date
3927: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3928: -- the effective start date of the person is between start date
3929: -- active and end date active in hr_lookups.
3930: --
3931: if hr_api.not_exists_in_dt_hr_lookups
3932: (p_effective_date => p_effective_date
3933: ,p_validation_start_date => p_validation_start_date
3934: ,p_validation_end_date => p_validation_end_date
3935: ,p_lookup_type => 'YES_NO'
4047: -- Description:
4048: -- - Checks that the values held in developer descriptive flexfields
4049: -- are valid for a category of 'US'.
4050: -- - Validates that per information6 and 9 exist as a lookup code on
4051: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4052: -- set to 'Y' and the effective start date of the person between start
4053: -- date active and end date active on HR_LOOKUPS.
4054: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4055: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4049: -- are valid for a category of 'US'.
4050: -- - Validates that per information6 and 9 exist as a lookup code on
4051: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4052: -- set to 'Y' and the effective start date of the person between start
4053: -- date active and end date active on HR_LOOKUPS.
4054: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4055: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4056: -- and the effective start date of the person between start date active
4057: -- and end date active on HR_LOOKUPS.
4050: -- - Validates that per information6 and 9 exist as a lookup code on
4051: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4052: -- set to 'Y' and the effective start date of the person between start
4053: -- date active and end date active on HR_LOOKUPS.
4054: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4055: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4056: -- and the effective start date of the person between start date active
4057: -- and end date active on HR_LOOKUPS.
4058: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4053: -- date active and end date active on HR_LOOKUPS.
4054: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4055: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4056: -- and the effective start date of the person between start date active
4057: -- and end date active on HR_LOOKUPS.
4058: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4059: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4060: -- and the effective start date of the person between start date active
4061: -- and end date active on HR_LOOKUPS.
4054: -- - Validates that per information1 exists as a lookup code on HR_LOOKUPS
4055: -- for the lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4056: -- and the effective start date of the person between start date active
4057: -- and end date active on HR_LOOKUPS.
4058: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4059: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4060: -- and the effective start date of the person between start date active
4061: -- and end date active on HR_LOOKUPS.
4062: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4057: -- and end date active on HR_LOOKUPS.
4058: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4059: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4060: -- and the effective start date of the person between start date active
4061: -- and end date active on HR_LOOKUPS.
4062: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4063: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4064: -- and the effective start date of the person between start date active
4065: -- and end date active on HR_LOOKUPS.
4058: -- - Validates that per information2 exists as a lookup code on HR_LOOKUPS
4059: -- for the lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y'
4060: -- and the effective start date of the person between start date active
4061: -- and end date active on HR_LOOKUPS.
4062: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4063: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4064: -- and the effective start date of the person between start date active
4065: -- and end date active on HR_LOOKUPS.
4066: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4061: -- and end date active on HR_LOOKUPS.
4062: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4063: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4064: -- and the effective start date of the person between start date active
4065: -- and end date active on HR_LOOKUPS.
4066: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4067: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4068: -- and the effective start date of the person between start date active
4069: -- and end date active on HR_LOOKUPS.
4062: -- - Validates that per information4 exists as a lookup code on HR_LOOKUPS
4063: -- for the lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4064: -- and the effective start date of the person between start date active
4065: -- and end date active on HR_LOOKUPS.
4066: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4067: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4068: -- and the effective start date of the person between start date active
4069: -- and end date active on HR_LOOKUPS.
4070: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4065: -- and end date active on HR_LOOKUPS.
4066: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4067: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4068: -- and the effective start date of the person between start date active
4069: -- and end date active on HR_LOOKUPS.
4070: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4071: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4072: -- and the effective start date of the person between start date active
4073: -- and end date active on HR_LOOKUPS.
4066: -- - Validates that per information5 exists as a lookup code on HR_LOOKUPS
4067: -- for the lookup type 'US_VETERAN_STATUS' with an enabled flag set to 'Y'
4068: -- and the effective start date of the person between start date active
4069: -- and end date active on HR_LOOKUPS.
4070: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4071: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4072: -- and the effective start date of the person between start date active
4073: -- and end date active on HR_LOOKUPS.
4074: -- - Validates that when per information7 is set to 'EXCL' that per
4069: -- and end date active on HR_LOOKUPS.
4070: -- - Validates that per information7 exists as a lookup code on HR_LOOKUPS
4071: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4072: -- and the effective start date of the person between start date active
4073: -- and end date active on HR_LOOKUPS.
4074: -- - Validates that when per information7 is set to 'EXCL' that per
4075: -- information8 exists as a lookup code on HR_LOOKUPS for the lookup type
4076: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4077: -- effective start date of the person between start date active and end
4071: -- for the lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4072: -- and the effective start date of the person between start date active
4073: -- and end date active on HR_LOOKUPS.
4074: -- - Validates that when per information7 is set to 'EXCL' that per
4075: -- information8 exists as a lookup code on HR_LOOKUPS for the lookup type
4076: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4077: -- effective start date of the person between start date active and end
4078: -- date active on HR_LOOKUPS.
4079: -- - Validates that per information10 exists as a lookup code on
4074: -- - Validates that when per information7 is set to 'EXCL' that per
4075: -- information8 exists as a lookup code on HR_LOOKUPS for the lookup type
4076: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4077: -- effective start date of the person between start date active and end
4078: -- date active on HR_LOOKUPS.
4079: -- - Validates that per information10 exists as a lookup code on
4080: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4081: -- set to 'Y' and the effective start date of the person between start
4082: -- date active and end date active on HR_LOOKUPS.
4076: -- 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y' and the
4077: -- effective start date of the person between start date active and end
4078: -- date active on HR_LOOKUPS.
4079: -- - Validates that per information10 exists as a lookup code on
4080: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4081: -- set to 'Y' and the effective start date of the person between start
4082: -- date active and end date active on HR_LOOKUPS.
4083: --
4084: -- Pre-conditions:
4078: -- date active on HR_LOOKUPS.
4079: -- - Validates that per information10 exists as a lookup code on
4080: -- HR_LOOKUPS for the lookup type 'YES_NO' with an enabled flag
4081: -- set to 'Y' and the effective start date of the person between start
4082: -- date active and end date active on HR_LOOKUPS.
4083: --
4084: -- Pre-conditions:
4085: -- None
4086: --
4124: -- p_api_updating
4125: --
4126: -- Post Success:
4127: -- Processing continues if:
4128: -- - per information6 and 9 exist as a lookup code in HR_LOOKUPS
4129: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4130: -- the effective start date of the person is between start date
4131: -- active and end date active on HR_LOOKUPS.
4132: -- - per information1 exists as a lookup code in HR_LOOKUPS
4127: -- Processing continues if:
4128: -- - per information6 and 9 exist as a lookup code in HR_LOOKUPS
4129: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4130: -- the effective start date of the person is between start date
4131: -- active and end date active on HR_LOOKUPS.
4132: -- - per information1 exists as a lookup code in HR_LOOKUPS
4133: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4134: -- 'Y' and the effective start date of the person is between start
4135: -- date active and end date active on HR_LOOKUPS.
4128: -- - per information6 and 9 exist as a lookup code in HR_LOOKUPS
4129: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4130: -- the effective start date of the person is between start date
4131: -- active and end date active on HR_LOOKUPS.
4132: -- - per information1 exists as a lookup code in HR_LOOKUPS
4133: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4134: -- 'Y' and the effective start date of the person is between start
4135: -- date active and end date active on HR_LOOKUPS.
4136: -- - per information2 exists as a lookup code in HR_LOOKUPS
4131: -- active and end date active on HR_LOOKUPS.
4132: -- - per information1 exists as a lookup code in HR_LOOKUPS
4133: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4134: -- 'Y' and the effective start date of the person is between start
4135: -- date active and end date active on HR_LOOKUPS.
4136: -- - per information2 exists as a lookup code in HR_LOOKUPS
4137: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4138: -- 'Y' and the effective start date of the person is between start
4139: -- date active and end date active on HR_LOOKUPS.
4132: -- - per information1 exists as a lookup code in HR_LOOKUPS
4133: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4134: -- 'Y' and the effective start date of the person is between start
4135: -- date active and end date active on HR_LOOKUPS.
4136: -- - per information2 exists as a lookup code in HR_LOOKUPS
4137: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4138: -- 'Y' and the effective start date of the person is between start
4139: -- date active and end date active on HR_LOOKUPS.
4140: -- - per information3 is a valid date and 11 characters long.
4135: -- date active and end date active on HR_LOOKUPS.
4136: -- - per information2 exists as a lookup code in HR_LOOKUPS
4137: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4138: -- 'Y' and the effective start date of the person is between start
4139: -- date active and end date active on HR_LOOKUPS.
4140: -- - per information3 is a valid date and 11 characters long.
4141: -- - per information4 exists as a lookup code in HR_LOOKUPS
4142: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4143: -- 'Y' and the effective start date of the person is between start
4137: -- for the lookup type 'PER_US_I9_STATE' where the enabled flag is
4138: -- 'Y' and the effective start date of the person is between start
4139: -- date active and end date active on HR_LOOKUPS.
4140: -- - per information3 is a valid date and 11 characters long.
4141: -- - per information4 exists as a lookup code in HR_LOOKUPS
4142: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4143: -- 'Y' and the effective start date of the person is between start
4144: -- date active and end date active on HR_LOOKUPS.
4145: -- - per information5 exists as a lookup code in HR_LOOKUPS
4140: -- - per information3 is a valid date and 11 characters long.
4141: -- - per information4 exists as a lookup code in HR_LOOKUPS
4142: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4143: -- 'Y' and the effective start date of the person is between start
4144: -- date active and end date active on HR_LOOKUPS.
4145: -- - per information5 exists as a lookup code in HR_LOOKUPS
4146: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4147: -- 'Y' and the effective start date of the person is between start
4148: -- date active and end date active on HR_LOOKUPS.
4141: -- - per information4 exists as a lookup code in HR_LOOKUPS
4142: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4143: -- 'Y' and the effective start date of the person is between start
4144: -- date active and end date active on HR_LOOKUPS.
4145: -- - per information5 exists as a lookup code in HR_LOOKUPS
4146: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4147: -- 'Y' and the effective start date of the person is between start
4148: -- date active and end date active on HR_LOOKUPS.
4149: -- - per information7 exists as a lookup code in HR_LOOKUPS
4144: -- date active and end date active on HR_LOOKUPS.
4145: -- - per information5 exists as a lookup code in HR_LOOKUPS
4146: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4147: -- 'Y' and the effective start date of the person is between start
4148: -- date active and end date active on HR_LOOKUPS.
4149: -- - per information7 exists as a lookup code in HR_LOOKUPS
4150: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4151: -- 'Y' and the effective start date of the person is between start
4152: -- date active and end date active on HR_LOOKUPS.
4145: -- - per information5 exists as a lookup code in HR_LOOKUPS
4146: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4147: -- 'Y' and the effective start date of the person is between start
4148: -- date active and end date active on HR_LOOKUPS.
4149: -- - per information7 exists as a lookup code in HR_LOOKUPS
4150: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4151: -- 'Y' and the effective start date of the person is between start
4152: -- date active and end date active on HR_LOOKUPS.
4153: -- - when per information7 is set to 'EXCL' and per information8 exists
4148: -- date active and end date active on HR_LOOKUPS.
4149: -- - per information7 exists as a lookup code in HR_LOOKUPS
4150: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4151: -- 'Y' and the effective start date of the person is between start
4152: -- date active and end date active on HR_LOOKUPS.
4153: -- - when per information7 is set to 'EXCL' and per information8 exists
4154: -- as a lookup code in HR_LOOKUPS for the lookup type
4155: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4156: -- effective start date of the person is between start date active
4150: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4151: -- 'Y' and the effective start date of the person is between start
4152: -- date active and end date active on HR_LOOKUPS.
4153: -- - when per information7 is set to 'EXCL' and per information8 exists
4154: -- as a lookup code in HR_LOOKUPS for the lookup type
4155: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4156: -- effective start date of the person is between start date active
4157: -- and end date active on HR_LOOKUPS.
4158: --
4153: -- - when per information7 is set to 'EXCL' and per information8 exists
4154: -- as a lookup code in HR_LOOKUPS for the lookup type
4155: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4156: -- effective start date of the person is between start date active
4157: -- and end date active on HR_LOOKUPS.
4158: --
4159: -- 9) per_information9 value exists in hr_lookups
4160: -- where lookup_type = 'YES_NO'
4161: --
4155: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4156: -- effective start date of the person is between start date active
4157: -- and end date active on HR_LOOKUPS.
4158: --
4159: -- 9) per_information9 value exists in hr_lookups
4160: -- where lookup_type = 'YES_NO'
4161: --
4162: -- 10) per information10 exists as a lookup code in HR_LOOKUPS
4163: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4158: --
4159: -- 9) per_information9 value exists in hr_lookups
4160: -- where lookup_type = 'YES_NO'
4161: --
4162: -- 10) per information10 exists as a lookup code in HR_LOOKUPS
4163: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4164: -- the effective start date of the person is between start date
4165: -- active and end date active on HR_LOOKUPS.
4166: --
4161: --
4162: -- 10) per information10 exists as a lookup code in HR_LOOKUPS
4163: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4164: -- the effective start date of the person is between start date
4165: -- active and end date active on HR_LOOKUPS.
4166: --
4167: -- 11) per_information11 to 20 values are null
4168: --
4169: -- Post Failure:
4168: --
4169: -- Post Failure:
4170: -- An application error is raised and processing is terminated if:
4171: -- - per information6 and 9 does not exist as a lookup code in
4172: -- HR_LOOKUPS for the lookup type 'YES_NO' where the
4173: -- enabled flag is 'Y' and the effective start date of the person
4174: -- is between start date active and end date active on HR_LOOKUPS.
4175: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_ETHNIC_GROUP' where the enabled flag is
4170: -- An application error is raised and processing is terminated if:
4171: -- - per information6 and 9 does not exist as a lookup code in
4172: -- HR_LOOKUPS for the lookup type 'YES_NO' where the
4173: -- enabled flag is 'Y' and the effective start date of the person
4174: -- is between start date active and end date active on HR_LOOKUPS.
4175: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_ETHNIC_GROUP' 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.
4171: -- - per information6 and 9 does not exist as a lookup code in
4172: -- HR_LOOKUPS for the lookup type 'YES_NO' where the
4173: -- enabled flag is 'Y' and the effective start date of the person
4174: -- is between start date active and end date active on HR_LOOKUPS.
4175: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_ETHNIC_GROUP' 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 information2 doesn't exist as a lookup code in HR_LOOKUPS
4174: -- is between start date active and end date active on HR_LOOKUPS.
4175: -- - per information1 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_ETHNIC_GROUP' 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 information2 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'PER_US_I9_STATE' 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 information1 doesn't exist as a lookup code in HR_LOOKUPS
4176: -- for the lookup type 'US_ETHNIC_GROUP' 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 information2 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'PER_US_I9_STATE' 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 information3 value is an invalid date or less than 11
4178: -- date active and end date active on HR_LOOKUPS.
4179: -- - per information2 doesn't exist as a lookup code in HR_LOOKUPS
4180: -- for the lookup type 'PER_US_I9_STATE' 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 information3 value is an invalid date or less than 11
4184: -- characters long.
4185: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4186: -- for the lookup type 'US_VISA_TYPE' 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 information3 value is an invalid date or less than 11
4184: -- characters long.
4185: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4186: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4187: -- 'Y' and the effective start date of the person is between start
4188: -- date active and end date active on HR_LOOKUPS.
4189: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4184: -- characters long.
4185: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4186: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4187: -- 'Y' and the effective start date of the person is between start
4188: -- date active and end date active on HR_LOOKUPS.
4189: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4190: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4191: -- 'Y' and the effective start date of the person is between start
4192: -- date active and end date active on HR_LOOKUPS.
4185: -- - per information4 doesn't exist as a lookup code in HR_LOOKUPS
4186: -- for the lookup type 'US_VISA_TYPE' where the enabled flag is
4187: -- 'Y' and the effective start date of the person is between start
4188: -- date active and end date active on HR_LOOKUPS.
4189: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4190: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4191: -- 'Y' and the effective start date of the person is between start
4192: -- date active and end date active on HR_LOOKUPS.
4193: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4188: -- date active and end date active on HR_LOOKUPS.
4189: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4190: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4191: -- 'Y' and the effective start date of the person is between start
4192: -- date active and end date active on HR_LOOKUPS.
4193: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4194: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4195: -- 'Y' and the effective start date of the person is between start
4196: -- date active and end date active on HR_LOOKUPS.
4189: -- - per information5 doesn't exist as a lookup code in HR_LOOKUPS
4190: -- for the lookup type 'US_VETERAN_STATUS' where the enabled flag is
4191: -- 'Y' and the effective start date of the person is between start
4192: -- date active and end date active on HR_LOOKUPS.
4193: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4194: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4195: -- 'Y' and the effective start date of the person is between start
4196: -- date active and end date active on HR_LOOKUPS.
4197: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4192: -- date active and end date active on HR_LOOKUPS.
4193: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4194: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4195: -- 'Y' and the effective start date of the person is between start
4196: -- date active and end date active on HR_LOOKUPS.
4197: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4198: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4199: -- 'Y' and the effective start date of the person is between start
4200: -- date active and end date active on HR_LOOKUPS.
4193: -- - per information7 doesn't exist as a lookup code in HR_LOOKUPS
4194: -- for the lookup type 'US_NEW_HIRE_STATUS' where the enabled flag is
4195: -- 'Y' and the effective start date of the person is between start
4196: -- date active and end date active on HR_LOOKUPS.
4197: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4198: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4199: -- 'Y' and the effective start date of the person is between start
4200: -- date active and end date active on HR_LOOKUPS.
4201: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4196: -- date active and end date active on HR_LOOKUPS.
4197: -- - per information8 doesn't exist as a lookup code in HR_LOOKUPS
4198: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4199: -- 'Y' and the effective start date of the person is between start
4200: -- date active and end date active on HR_LOOKUPS.
4201: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4202: -- exist as a lookup code in HR_LOOKUPS for the lookup type
4203: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4204: -- effective start date of the person is between start date active
4198: -- for the lookup type 'US_NEW_HIRE_EXCEPTION' where the enabled flag is
4199: -- 'Y' and the effective start date of the person is between start
4200: -- date active and end date active on HR_LOOKUPS.
4201: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4202: -- exist as a lookup code in HR_LOOKUPS for the lookup type
4203: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4204: -- effective start date of the person is between start date active
4205: -- and end date active on HR_LOOKUPS.
4206: --
4201: -- - when per information7 is set to 'EXCL' and per information8 doesn't
4202: -- exist as a lookup code in HR_LOOKUPS for the lookup type
4203: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4204: -- effective start date of the person is between start date active
4205: -- and end date active on HR_LOOKUPS.
4206: --
4207: -- 9) per_information9 value does not exists in hr_lookups
4208: -- where lookup_type = 'YES_NO'
4209: --
4203: -- 'US_NEW_HIRE_EXCEPTIONS' where the enabled flag is 'Y' and the
4204: -- effective start date of the person is between start date active
4205: -- and end date active on HR_LOOKUPS.
4206: --
4207: -- 9) per_information9 value does not exists in hr_lookups
4208: -- where lookup_type = 'YES_NO'
4209: --
4210: -- 10) per information10 does not exist as a lookup code in HR_LOOKUPS
4211: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4206: --
4207: -- 9) per_information9 value does not exists in hr_lookups
4208: -- where lookup_type = 'YES_NO'
4209: --
4210: -- 10) per information10 does not exist as a lookup code in HR_LOOKUPS
4211: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4212: -- the effective start date of the person is between start date
4213: -- active and end date active on HR_LOOKUPS.
4214: --
4209: --
4210: -- 10) per information10 does not exist as a lookup code in HR_LOOKUPS
4211: -- for the lookup type 'YES_NO' where the enabled flag is 'Y' and
4212: -- the effective start date of the person is between start date
4213: -- active and end date active on HR_LOOKUPS.
4214: --
4215: -- 11) per_information11 to 20 values are not null
4216: --
4217: -- Access Status:
4308: or (NOT p_api_updating))
4309: and p_per_information1 is not null)
4310: then
4311: --
4312: -- Check that per information1 exists in hr_lookups for the
4313: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4314: -- and that the effective start date of the person is between start
4315: -- date active and end date active in hr_lookups.
4316: --
4311: --
4312: -- Check that per information1 exists in hr_lookups for the
4313: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4314: -- and that the effective start date of the person is between start
4315: -- date active and end date active in hr_lookups.
4316: --
4317: if hr_api.not_exists_in_dt_hr_lookups
4318: (p_effective_date => p_effective_date
4319: ,p_validation_start_date => p_validation_start_date
4313: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4314: -- and that the effective start date of the person is between start
4315: -- date active and end date active in hr_lookups.
4316: --
4317: if hr_api.not_exists_in_dt_hr_lookups
4318: (p_effective_date => p_effective_date
4319: ,p_validation_start_date => p_validation_start_date
4320: ,p_validation_end_date => p_validation_end_date
4321: ,p_lookup_type => 'US_ETHNIC_GROUP'
4345: (NOT p_api_updating)) and
4346: p_per_information2 is not null)
4347: then
4348: --
4349: -- Check that per information2 exists in hr_lookups for the
4350: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4351: -- the effective start date of the person is between start date
4352: -- active and end date active in hr_lookups.
4353: --
4348: --
4349: -- Check that per information2 exists in hr_lookups for the
4350: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4351: -- the effective start date of the person is between start date
4352: -- active and end date active in hr_lookups.
4353: --
4354: if hr_api.not_exists_in_dt_hr_lookups
4355: (p_effective_date => p_effective_date
4356: ,p_validation_start_date => p_validation_start_date
4350: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4351: -- the effective start date of the person is between start date
4352: -- active and end date active in hr_lookups.
4353: --
4354: if hr_api.not_exists_in_dt_hr_lookups
4355: (p_effective_date => p_effective_date
4356: ,p_validation_start_date => p_validation_start_date
4357: ,p_validation_end_date => p_validation_end_date
4358: ,p_lookup_type => 'PER_US_I9_STATE'
4408: (NOT p_api_updating)) and
4409: p_per_information4 is not null)
4410: then
4411: --
4412: -- Check that per information4 exists in hr_lookups for the
4413: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4414: -- and that the effective start date of the person is between start
4415: -- date active and end date active in hr_lookups.
4416: --
4411: --
4412: -- Check that per information4 exists in hr_lookups for the
4413: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4414: -- and that the effective start date of the person is between start
4415: -- date active and end date active in hr_lookups.
4416: --
4417: if hr_api.not_exists_in_dt_hr_lookups
4418: (p_effective_date => p_effective_date
4419: ,p_validation_start_date => p_validation_start_date
4413: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4414: -- and that the effective start date of the person is between start
4415: -- date active and end date active in hr_lookups.
4416: --
4417: if hr_api.not_exists_in_dt_hr_lookups
4418: (p_effective_date => p_effective_date
4419: ,p_validation_start_date => p_validation_start_date
4420: ,p_validation_end_date => p_validation_end_date
4421: ,p_lookup_type => 'US_VISA_TYPE'
4445: (NOT p_api_updating)) and
4446: p_per_information5 is not null)
4447: then
4448: --
4449: -- Check that per information5 exists in hr_lookups for the
4450: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4451: -- and that the effective start date of the person is between start
4452: -- date active and end date active in hr_lookups.
4453: --
4448: --
4449: -- Check that per information5 exists in hr_lookups for the
4450: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4451: -- and that the effective start date of the person is between start
4452: -- date active and end date active in hr_lookups.
4453: --
4454: if hr_api.not_exists_in_dt_hr_lookups
4455: (p_effective_date => p_effective_date
4456: ,p_validation_start_date => p_validation_start_date
4450: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4451: -- and that the effective start date of the person is between start
4452: -- date active and end date active in hr_lookups.
4453: --
4454: if hr_api.not_exists_in_dt_hr_lookups
4455: (p_effective_date => p_effective_date
4456: ,p_validation_start_date => p_validation_start_date
4457: ,p_validation_end_date => p_validation_end_date
4458: ,p_lookup_type => 'US_VETERAN_STATUS'
4482: (NOT p_api_updating)) and
4483: p_per_information6 is not null)
4484: then
4485: --
4486: -- Check that per information6 exists in hr_lookups for the
4487: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4488: -- the effective start date of the person is between start date
4489: -- active and end date active in hr_lookups.
4490: --
4485: --
4486: -- Check that per information6 exists in hr_lookups for the
4487: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4488: -- the effective start date of the person is between start date
4489: -- active and end date active in hr_lookups.
4490: --
4491: if hr_api.not_exists_in_dt_hr_lookups
4492: (p_effective_date => p_effective_date
4493: ,p_validation_start_date => p_validation_start_date
4487: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4488: -- the effective start date of the person is between start date
4489: -- active and end date active in hr_lookups.
4490: --
4491: if hr_api.not_exists_in_dt_hr_lookups
4492: (p_effective_date => p_effective_date
4493: ,p_validation_start_date => p_validation_start_date
4494: ,p_validation_end_date => p_validation_end_date
4495: ,p_lookup_type => 'YES_NO'
4519: (NOT p_api_updating)) and
4520: p_per_information7 is not null)
4521: then
4522: --
4523: -- Check that per information7 exists in hr_lookups for the
4524: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4525: -- and that the effective start date of the person is between start
4526: -- date active and end date active in hr_lookups.
4527: --
4522: --
4523: -- Check that per information7 exists in hr_lookups for the
4524: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4525: -- and that the effective start date of the person is between start
4526: -- date active and end date active in hr_lookups.
4527: --
4528: if hr_api.not_exists_in_dt_hr_lookups
4529: (p_effective_date => p_effective_date
4530: ,p_validation_start_date => p_validation_start_date
4524: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4525: -- and that the effective start date of the person is between start
4526: -- date active and end date active in hr_lookups.
4527: --
4528: if hr_api.not_exists_in_dt_hr_lookups
4529: (p_effective_date => p_effective_date
4530: ,p_validation_start_date => p_validation_start_date
4531: ,p_validation_end_date => p_validation_end_date
4532: ,p_lookup_type => 'US_NEW_HIRE_STATUS'
4567: hr_utility.set_message(801, 'HR_51286_PER_INFO8_NOT_NULL');
4568: hr_utility.raise_error;
4569: else
4570: --
4571: -- Check that per information7 exists in hr_lookups for the
4572: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4573: -- and that the effective start date of the person is between start
4574: -- date active and end date active in hr_lookups.
4575: --
4570: --
4571: -- Check that per information7 exists in hr_lookups for the
4572: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4573: -- and that the effective start date of the person is between start
4574: -- date active and end date active in hr_lookups.
4575: --
4576: if hr_api.not_exists_in_dt_hr_lookups
4577: (p_effective_date => p_effective_date
4578: ,p_validation_start_date => p_validation_start_date
4572: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4573: -- and that the effective start date of the person is between start
4574: -- date active and end date active in hr_lookups.
4575: --
4576: if hr_api.not_exists_in_dt_hr_lookups
4577: (p_effective_date => p_effective_date
4578: ,p_validation_start_date => p_validation_start_date
4579: ,p_validation_end_date => p_validation_end_date
4580: ,p_lookup_type => 'US_NEW_HIRE_EXCEPTIONS'
4605: (NOT p_api_updating)) and
4606: p_per_information9 is not null)
4607: then
4608: --
4609: -- Check that per information9 exists in hr_lookups for the
4610: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4611: -- the effective start date of the person is between start date
4612: -- active and end date active in hr_lookups.
4613: --
4608: --
4609: -- Check that per information9 exists in hr_lookups for the
4610: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4611: -- the effective start date of the person is between start date
4612: -- active and end date active in hr_lookups.
4613: --
4614: if hr_api.not_exists_in_dt_hr_lookups
4615: (p_effective_date => p_effective_date
4616: ,p_validation_start_date => p_validation_start_date
4610: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4611: -- the effective start date of the person is between start date
4612: -- active and end date active in hr_lookups.
4613: --
4614: if hr_api.not_exists_in_dt_hr_lookups
4615: (p_effective_date => p_effective_date
4616: ,p_validation_start_date => p_validation_start_date
4617: ,p_validation_end_date => p_validation_end_date
4618: ,p_lookup_type => 'YES_NO'
4639: (NOT p_api_updating)) and
4640: p_per_information10 is not null)
4641: then
4642: --
4643: -- Check that per information10 exists in hr_lookups for the
4644: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4645: -- the effective start date of the person is between start date
4646: -- active and end date active in hr_lookups.
4647: --
4642: --
4643: -- Check that per information10 exists in hr_lookups for the
4644: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4645: -- the effective start date of the person is between start date
4646: -- active and end date active in hr_lookups.
4647: --
4648: if hr_api.not_exists_in_dt_hr_lookups
4649: (p_effective_date => p_effective_date
4650: ,p_validation_start_date => p_validation_start_date
4644: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4645: -- the effective start date of the person is between start date
4646: -- active and end date active in hr_lookups.
4647: --
4648: if hr_api.not_exists_in_dt_hr_lookups
4649: (p_effective_date => p_effective_date
4650: ,p_validation_start_date => p_validation_start_date
4651: ,p_validation_end_date => p_validation_end_date
4652: ,p_lookup_type => 'YES_NO'
4832: --
4833: -- We know the per_information_category is JP, so check the rest of
4834: -- the per_information fields within this context.
4835: --
4836: -- Check if the per_information1 value exists in hr_lookups
4837: -- where the lookup_type is 'YES_NO'
4838: --
4839: if p_per_information1 is not null then
4840: --
4837: -- where the lookup_type is 'YES_NO'
4838: --
4839: if p_per_information1 is not null then
4840: --
4841: -- Check that per information1 exists in hr_lookups for the
4842: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4843: -- the effective start date of the person is between start date
4844: -- active and end date active in hr_lookups.
4845: --
4840: --
4841: -- Check that per information1 exists in hr_lookups for the
4842: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4843: -- the effective start date of the person is between start date
4844: -- active and end date active in hr_lookups.
4845: --
4846: if hr_api.not_exists_in_dt_hr_lookups
4847: (p_effective_date => p_effective_date
4848: ,p_validation_start_date => p_validation_start_date
4842: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4843: -- the effective start date of the person is between start date
4844: -- active and end date active in hr_lookups.
4845: --
4846: if hr_api.not_exists_in_dt_hr_lookups
4847: (p_effective_date => p_effective_date
4848: ,p_validation_start_date => p_validation_start_date
4849: ,p_validation_end_date => p_validation_end_date
4850: ,p_lookup_type => 'YES_NO'
4864: if g_debug then
4865: hr_utility.set_location(l_proc,40);
4866: end if;
4867: --
4868: -- Check if the per_information2 value exists in hr_lookups
4869: -- where the lookup_type is 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'
4870: --
4871: if p_per_information2 is not null then
4872: --
4869: -- where the lookup_type is 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'
4870: --
4871: if p_per_information2 is not null then
4872: --
4873: -- Check that per information2 exists in hr_lookups for the
4874: -- lookup type 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE' with an enabled
4875: -- flag set to 'Y' and that
4876: -- the effective start date of the person is between start date
4877: -- active and end date active in hr_lookups.
4873: -- Check that per information2 exists in hr_lookups for the
4874: -- lookup type 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE' with an enabled
4875: -- flag set to 'Y' and that
4876: -- the effective start date of the person is between start date
4877: -- active and end date active in hr_lookups.
4878: --
4879: if hr_api.not_exists_in_dt_hr_lookups
4880: (p_effective_date => p_effective_date
4881: ,p_validation_start_date => p_validation_start_date
4875: -- flag set to 'Y' and that
4876: -- the effective start date of the person is between start date
4877: -- active and end date active in hr_lookups.
4878: --
4879: if hr_api.not_exists_in_dt_hr_lookups
4880: (p_effective_date => p_effective_date
4881: ,p_validation_start_date => p_validation_start_date
4882: ,p_validation_end_date => p_validation_end_date
4883: ,p_lookup_type => 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'