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

APPS.PER_PER_BUS dependencies on PER_PER_SHD

Line 295: l_api_updating := per_per_shd.api_updating

291: -- a) The current g_old_rec is current and
292: -- b) The person type id value has changed
293: -- c) A record is being inserted
294: --
295: l_api_updating := per_per_shd.api_updating
296: (p_person_id => p_person_id
297: ,p_effective_date => p_effective_date
298: ,p_object_version_number => p_object_version_number);
299: --

Line 300: if ((l_api_updating and per_per_shd.g_old_rec.person_type_id

296: (p_person_id => p_person_id
297: ,p_effective_date => p_effective_date
298: ,p_object_version_number => p_object_version_number);
299: --
300: if ((l_api_updating and per_per_shd.g_old_rec.person_type_id
301: <> p_person_type_id) or
302: (NOT l_api_updating)) then
303: --
304: if g_debug then

Line 393: p_current_employee_flag := per_per_shd.g_old_rec.current_employee_flag;

389: if g_debug then
390: hr_utility.set_location(l_proc, 11);
391: end if;
392: --
393: p_current_employee_flag := per_per_shd.g_old_rec.current_employee_flag;
394: p_current_applicant_flag := per_per_shd.g_old_rec.current_applicant_flag;
395: p_current_emp_or_apl_flag := per_per_shd.g_old_rec.current_emp_or_apl_flag;
396: end if;
397: if g_debug then

Line 394: p_current_applicant_flag := per_per_shd.g_old_rec.current_applicant_flag;

390: hr_utility.set_location(l_proc, 11);
391: end if;
392: --
393: p_current_employee_flag := per_per_shd.g_old_rec.current_employee_flag;
394: p_current_applicant_flag := per_per_shd.g_old_rec.current_applicant_flag;
395: p_current_emp_or_apl_flag := per_per_shd.g_old_rec.current_emp_or_apl_flag;
396: end if;
397: if g_debug then
398: hr_utility.set_location(' Leaving:'|| l_proc, 12);

Line 395: p_current_emp_or_apl_flag := per_per_shd.g_old_rec.current_emp_or_apl_flag;

391: end if;
392: --
393: p_current_employee_flag := per_per_shd.g_old_rec.current_employee_flag;
394: p_current_applicant_flag := per_per_shd.g_old_rec.current_applicant_flag;
395: p_current_emp_or_apl_flag := per_per_shd.g_old_rec.current_emp_or_apl_flag;
396: end if;
397: if g_debug then
398: hr_utility.set_location(' Leaving:'|| l_proc, 12);
399: end if;

Line 569: l_api_updating := per_per_shd.api_updating

565: -- a) The current g_old_rec is current and
566: -- b) The person type id value has changed
567: -- c) or a record is being inserted
568: --
569: l_api_updating := per_per_shd.api_updating
570: (p_person_id => p_person_id
571: ,p_effective_date => p_effective_date
572: ,p_object_version_number => p_object_version_number);
573: --

Line 574: if ((l_api_updating and per_per_shd.g_old_rec.person_type_id <>

570: (p_person_id => p_person_id
571: ,p_effective_date => p_effective_date
572: ,p_object_version_number => p_object_version_number);
573: --
574: if ((l_api_updating and per_per_shd.g_old_rec.person_type_id <>
575: p_person_type_id) or
576: (NOT l_api_updating)) then
577: --
578: -- Perform Insert/Update Checks

Line 621: if ((l_api_updating and per_per_shd.g_old_rec.person_type_id <>

617: -- Only proceed with validation if:
618: -- a) The current g_old_rec is current and
619: -- b) The person type id value has changed
620: --
621: if ((l_api_updating and per_per_shd.g_old_rec.person_type_id <>
622: p_person_type_id)) then
623: --
624: -- Perform Update Checks
625: --

Line 870: l_api_updating := per_per_shd.api_updating

866: -- a) The current g_old_rec is current and
867: -- b) The start date value has changed
868: -- c) a record is being inserted
869: --
870: l_api_updating := per_per_shd.api_updating
871: (p_person_id => p_person_id
872: ,p_effective_date => p_effective_date
873: ,p_object_version_number => p_object_version_number);
874: --

Line 875: if ((l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,

871: (p_person_id => p_person_id
872: ,p_effective_date => p_effective_date
873: ,p_object_version_number => p_object_version_number);
874: --
875: if ((l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
876: hr_api.g_date)
877: <> nvl(p_date_of_birth,hr_api.g_date)) or
878: (NOT l_api_updating)) then
879: if g_debug then

Line 1101: l_api_updating := per_per_shd.api_updating

1097: -- a) The current g_old_rec is current and
1098: -- b) The marital status value has changed
1099: -- c) a record is being inserted
1100: --
1101: l_api_updating := per_per_shd.api_updating
1102: (p_person_id => p_person_id
1103: ,p_effective_date => p_effective_date
1104: ,p_object_version_number => p_object_version_number
1105: );

Line 1107: and nvl(per_per_shd.g_old_rec.marital_status, hr_api.g_varchar2)

1103: ,p_effective_date => p_effective_date
1104: ,p_object_version_number => p_object_version_number
1105: );
1106: if ((l_api_updating
1107: and nvl(per_per_shd.g_old_rec.marital_status, hr_api.g_varchar2)
1108: <> nvl(p_marital_status,hr_api.g_varchar2))
1109: or
1110: (NOT l_api_updating))
1111: then

Line 1228: l_api_updating := per_per_shd.api_updating

1224: -- a) The current g_old_rec is current and
1225: -- b) The party value has changed
1226: -- c) a record is being inserted
1227: --
1228: l_api_updating := per_per_shd.api_updating
1229: (p_person_id => p_person_id
1230: ,p_effective_date => p_effective_date
1231: ,p_object_version_number => p_object_version_number
1232: );

Line 1234: and nvl(per_per_shd.g_old_rec.party_id, hr_api.g_number)

1230: ,p_effective_date => p_effective_date
1231: ,p_object_version_number => p_object_version_number
1232: );
1233: if ((l_api_updating
1234: and nvl(per_per_shd.g_old_rec.party_id, hr_api.g_number)
1235: <> nvl(p_party_id,hr_api.g_number))
1236: or
1237: (NOT l_api_updating))
1238: then

Line 1368: l_api_updating := per_per_shd.api_updating

1364: -- a) The current g_old_rec is current and
1365: -- b) The nationality value has changed
1366: -- c) A record is being inserted
1367: --
1368: l_api_updating := per_per_shd.api_updating
1369: (p_person_id => p_person_id
1370: ,p_effective_date => p_effective_date
1371: ,p_object_version_number => p_object_version_number
1372: );

Line 1374: and nvl(per_per_shd.g_old_rec.nationality, hr_api.g_varchar2)

1370: ,p_effective_date => p_effective_date
1371: ,p_object_version_number => p_object_version_number
1372: );
1373: if ((l_api_updating
1374: and nvl(per_per_shd.g_old_rec.nationality, hr_api.g_varchar2)
1375: <> nvl(p_nationality,hr_api.g_varchar2))
1376: or
1377: (NOT l_api_updating))
1378: then

Line 1551: l_api_updating := per_per_shd.api_updating

1547: -- a) The current g_old_rec is current and
1548: -- b) national identifier has changed
1549: -- c) A record is being inserted
1550: --
1551: l_api_updating := per_per_shd.api_updating
1552: (p_person_id => p_person_id
1553: ,p_effective_date => p_effective_date
1554: ,p_object_version_number => p_object_version_number);
1555: --

Line 1556: if ((l_api_updating and nvl(per_per_shd.g_old_rec.national_identifier,

1552: (p_person_id => p_person_id
1553: ,p_effective_date => p_effective_date
1554: ,p_object_version_number => p_object_version_number);
1555: --
1556: if ((l_api_updating and nvl(per_per_shd.g_old_rec.national_identifier,
1557: hr_api.g_varchar2)
1558: <> nvl(p_national_identifier,hr_api.g_varchar2)) or
1559: (NOT l_api_updating)) then
1560: --

Line 1892: l_api_updating := per_per_shd.api_updating

1888: -- now required.
1889: -- d) The NI has changed and the generation method for emp num is 'N'
1890: -- e) a record is being inserted
1891: --
1892: l_api_updating := per_per_shd.api_updating
1893: (p_person_id => p_person_id
1894: ,p_effective_date => p_effective_date
1895: ,p_object_version_number => p_object_version_number);
1896: --

Line 1911: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.employee_number,

1907: -- has changed or if the system person type has changed in such a way
1908: -- that an employee number is now required or if the NI number has changed
1909: -- and the generation method is 'N'.
1910: --
1911: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.employee_number,
1912: hr_api.g_varchar2) <>
1913: nvl(p_employee_number, hr_api.g_varchar2)
1914: or emp_sys_per_type_change
1915: (p_person_type_id

Line 1916: ,per_per_shd.g_old_rec.person_type_id

1912: hr_api.g_varchar2) <>
1913: nvl(p_employee_number, hr_api.g_varchar2)
1914: or emp_sys_per_type_change
1915: (p_person_type_id
1916: ,per_per_shd.g_old_rec.person_type_id
1917: ,p_business_group_id)
1918: or emp_ni_change
1919: (p_national_identifier
1920: ,per_per_shd.g_old_rec.national_identifier

Line 1920: ,per_per_shd.g_old_rec.national_identifier

1916: ,per_per_shd.g_old_rec.person_type_id
1917: ,p_business_group_id)
1918: or emp_ni_change
1919: (p_national_identifier
1920: ,per_per_shd.g_old_rec.national_identifier
1921: ,l_gen_method)))
1922: or
1923: (NOT l_api_updating)) then
1924: --

Line 1933: nvl(per_per_shd.g_old_rec.employee_number, hr_api.g_varchar2) <>

1929: -- If we are updating and the employee number has actually changed then
1930: -- ensure the number generation method is not automatic.
1931: --
1932: if l_api_updating and
1933: nvl(per_per_shd.g_old_rec.employee_number, hr_api.g_varchar2) <>
1934: nvl(p_employee_number, hr_api.g_varchar2) and
1935: l_gen_method = 'A'
1936: and (not g_global_transfer_in_process
1937: OR

Line 1941: and per_per_shd.g_old_rec.employee_number is not null)

1937: OR
1938: (g_global_transfer_in_process
1939: and (PER_BG_NUMBERING_METHOD_PKG.Get_PersonNumber_Formula
1940: ('EMP',p_effective_date) is not null))
1941: and per_per_shd.g_old_rec.employee_number is not null)
1942: then
1943: hr_utility.set_message(801, 'HR_51239_PER_INV_EMP_UPD');
1944: hr_utility.raise_error;
1945: end if;

Line 2291: l_api_updating := per_per_shd.api_updating

2287: -- now required.
2288: -- d) The NI has changed and the generation method for npw num is 'N'
2289: -- e) a record is being inserted
2290: --
2291: l_api_updating := per_per_shd.api_updating
2292: (p_person_id => p_person_id
2293: ,p_effective_date => p_effective_date
2294: ,p_object_version_number => p_object_version_number);
2295: --

Line 2311: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.npw_number,

2307: -- has changed or if the current_npw_flag has changed in such a way
2308: -- that an npw number is now required or if the NI number has changed
2309: -- and the generation method is 'N'.
2310: --
2311: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.npw_number,
2312: hr_api.g_varchar2) <>
2313: nvl(p_npw_number, hr_api.g_varchar2)
2314: or (p_current_npw_flag = 'Y'
2315: and per_per_shd.g_old_rec.current_npw_flag is null)

Line 2315: and per_per_shd.g_old_rec.current_npw_flag is null)

2311: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.npw_number,
2312: hr_api.g_varchar2) <>
2313: nvl(p_npw_number, hr_api.g_varchar2)
2314: or (p_current_npw_flag = 'Y'
2315: and per_per_shd.g_old_rec.current_npw_flag is null)
2316: or npw_ni_change
2317: (p_national_identifier
2318: ,per_per_shd.g_old_rec.national_identifier
2319: ,l_gen_method)))

Line 2318: ,per_per_shd.g_old_rec.national_identifier

2314: or (p_current_npw_flag = 'Y'
2315: and per_per_shd.g_old_rec.current_npw_flag is null)
2316: or npw_ni_change
2317: (p_national_identifier
2318: ,per_per_shd.g_old_rec.national_identifier
2319: ,l_gen_method)))
2320: or
2321: (NOT l_api_updating)) then
2322: --

Line 2331: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>

2327: -- If we are updating and the npw number has actually changed then
2328: -- ensure the number generation method is not automatic.
2329: --
2330: if l_api_updating and
2331: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>
2332: nvl(p_npw_number, hr_api.g_varchar2) and
2333: l_gen_method = 'A' then
2334: hr_utility.set_message(800, 'HR_289657_PER_INV_CWK_UPD');
2335: hr_utility.raise_error;

Line 2367: p_npw_number <> nvl(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2) then

2363: -- or has not changed from its previous value (fixes 2876274)
2364: --
2365: if l_gen_method = 'A' and
2366: p_npw_number is not null and
2367: p_npw_number <> nvl(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2) then
2368: --
2369: hr_utility.set_message(800,'PER_289635_CWK_NUM_NOT_NULL');
2370: hr_utility.raise_error;
2371: end if;

Line 2590: l_api_updating := per_per_shd.api_updating

2586: -- a) The current g_old_rec is current and
2587: -- b) The expense check send to address value has changed
2588: -- c) a record is being inserted
2589: --
2590: l_api_updating := per_per_shd.api_updating
2591: (p_person_id => p_person_id
2592: ,p_effective_date => p_effective_date
2593: ,p_object_version_number => p_object_version_number
2594: );

Line 2600: and nvl(per_per_shd.g_old_rec.expense_check_send_to_address,

2596: hr_utility.set_location(l_proc, 30);
2597: end if;
2598: --
2599: if ((l_api_updating
2600: and nvl(per_per_shd.g_old_rec.expense_check_send_to_address,
2601: hr_api.g_varchar2)
2602: <> nvl(p_expense_check_send_to_addres,hr_api.g_varchar2))
2603: or
2604: (NOT l_api_updating))

Line 2775: l_api_updating := per_per_shd.api_updating

2771: -- b) The sex value has changed
2772: -- c) The title value has changed
2773: -- d)A record is being inserted
2774: --
2775: l_api_updating := per_per_shd.api_updating
2776: (p_person_id => p_person_id
2777: ,p_effective_date => p_effective_date
2778: ,p_object_version_number => p_object_version_number
2779: );

Line 2785: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)

2781: hr_utility.set_location(l_proc, 30);
2782: end if;
2783: --
2784: if ((l_api_updating
2785: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2786: <> nvl(p_sex,hr_api.g_varchar2))
2787: or
2788: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2789: <> nvl(p_title,hr_api.g_varchar2))

Line 2788: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)

2784: if ((l_api_updating
2785: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2786: <> nvl(p_sex,hr_api.g_varchar2))
2787: or
2788: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2789: <> nvl(p_title,hr_api.g_varchar2))
2790: or
2791: (NOT l_api_updating))
2792: then

Line 2976: nvl(p_town_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2))) then

2972: --
2973: if ((p_person_id is null)
2974: OR
2975: ((p_person_id is not null) and
2976: nvl(p_town_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2))) then
2977: --
2978: if g_debug then
2979: hr_utility.set_location(l_proc, 2);
2980: end if;

Line 3090: nvl(p_region_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2))) then

3086: --
3087: if ((p_person_id is null)
3088: OR
3089: ((p_person_id is not null) and
3090: nvl(p_region_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2))) then
3091: --
3092: if g_debug then
3093: hr_utility.set_location(l_proc, 2);
3094: end if;

Line 3192: nvl(p_country_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2))) then

3188: --
3189: if ((p_person_id is null)
3190: OR
3191: ((p_person_id is not null) and
3192: nvl(p_country_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2))) then
3193: --
3194: if g_debug then
3195: hr_utility.set_location(l_proc, 2);
3196: end if;

Line 3305: l_api_updating := per_per_shd.api_updating

3301: -- a) The current g_old_rec is current and
3302: -- b) The start date value has changed
3303: -- c) A record is being inserted
3304: --
3305: l_api_updating := per_per_shd.api_updating
3306: (p_person_id => p_person_id
3307: ,p_effective_date => p_effective_date
3308: ,p_object_version_number => p_object_version_number);
3309: --

Line 3323: elsif(l_api_updating and per_per_shd.g_old_rec.start_date <>

3319: -- Error: Invalid Start Date
3320: hr_utility.set_message(801, 'HR_7514_PER_START_DATE_INVALID');
3321: hr_utility.raise_error;
3322: end if;
3323: elsif(l_api_updating and per_per_shd.g_old_rec.start_date <>
3324: p_start_date) then
3325: --
3326: -- On update check if start date is the same as the earliest effective
3327: -- start date

Line 3447: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)

3443: hr_utility.set_location('Entering:'|| l_proc,5);
3444: end if;
3445: --
3446: if p_original_date_of_hire is NOT NULL then
3447: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3448: <> nvl(p_original_date_of_hire, hr_api.g_date)) or
3449: (per_per_shd.g_old_rec.start_date <> p_start_date) then
3450: --
3451: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then

Line 3449: (per_per_shd.g_old_rec.start_date <> p_start_date) then

3445: --
3446: if p_original_date_of_hire is NOT NULL then
3447: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3448: <> nvl(p_original_date_of_hire, hr_api.g_date)) or
3449: (per_per_shd.g_old_rec.start_date <> p_start_date) then
3450: --
3451: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
3452: --
3453: if (p_person_id is null and

Line 4296: <> nvl(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)

4292: -- Check if the value for per information1 is set on insert or has
4293: -- changed on update.
4294: --
4295: if (((nvl(p_per_information1,hr_api.g_varchar2)
4296: <> nvl(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
4297: and p_api_updating)
4298: or (NOT p_api_updating))
4299: and p_per_information1 is not null)
4300: then

Line 4333: nvl(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)

4329: -- Check if the value for per information2 is set on insert or has
4330: -- changed on update.
4331: --
4332: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
4333: nvl(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
4334: and p_api_updating) or
4335: (NOT p_api_updating)) and
4336: p_per_information2 is not null)
4337: then

Line 4370: nvl(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)

4366: -- Check if the value for per information3 is set on insert or has
4367: -- changed on update.
4368: --
4369: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
4370: nvl(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
4371: and p_api_updating) or
4372: (NOT p_api_updating)) and
4373: p_per_information3 is not null)
4374: then

Line 4396: nvl(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)

4392: -- Check if the value for per information4 is set on insert or has
4393: -- changed on update.
4394: --
4395: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
4396: nvl(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
4397: and p_api_updating) or
4398: (NOT p_api_updating)) and
4399: p_per_information4 is not null)
4400: then

Line 4433: nvl(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)

4429: -- Check if the value for per information5 is set on insert or has
4430: -- changed on update.
4431: --
4432: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
4433: nvl(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
4434: and p_api_updating) or
4435: (NOT p_api_updating)) and
4436: p_per_information5 is not null)
4437: then

Line 4470: nvl(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)

4466: -- Check if the value for per information6 is set on insert or has
4467: -- changed on update.
4468: --
4469: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
4470: nvl(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
4471: and p_api_updating) or
4472: (NOT p_api_updating)) and
4473: p_per_information6 is not null)
4474: then

Line 4507: nvl(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)

4503: -- Check if the value for per information7 is set on insert or has
4504: -- changed on update.
4505: --
4506: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
4507: nvl(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
4508: and p_api_updating) or
4509: (NOT p_api_updating)) and
4510: p_per_information7 is not null)
4511: then

Line 4544: nvl(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)

4540: -- Check if the value for per information8 is set on insert or has
4541: -- changed on update.
4542: --
4543: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
4544: nvl(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
4545: and p_api_updating) or
4546: (NOT p_api_updating)) and
4547: p_per_information8 is not null)
4548: then

Line 4593: nvl(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)

4589: -- Check if the value for per information9 is set on insert or has
4590: -- changed on update.
4591: --
4592: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
4593: nvl(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
4594: and p_api_updating) or
4595: (NOT p_api_updating)) and
4596: p_per_information9 is not null)
4597: then

Line 4627: nvl(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)

4623: hr_utility.set_location( l_proc, 200);
4624: end if;
4625: --
4626: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
4627: nvl(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
4628: and p_api_updating) or
4629: (NOT p_api_updating)) and
4630: p_per_information10 is not null)
4631: then

Line 4958: (p_rec in per_per_shd.g_rec_type) is

4954: -- |-------------------------------< chk_ddf >---------------------------------|
4955: -- -----------------------------------------------------------------------------
4956: --
4957: procedure chk_ddf
4958: (p_rec in per_per_shd.g_rec_type) is
4959: --
4960: l_proc varchar2(72);
4961: l_error exception;
4962: --

Line 4975: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>

4971: --
4972: if (p_rec.person_id is null)
4973: or ((p_rec.person_id is not null)
4974: and
4975: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4976: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4977: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4978: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4979: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>

Line 4977: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>

4973: or ((p_rec.person_id is not null)
4974: and
4975: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4976: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4977: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4978: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4979: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4980: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4981: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>

Line 4979: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>

4975: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4976: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4977: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4978: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4979: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4980: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4981: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4982: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4983: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>

Line 4981: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>

4977: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4978: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4979: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4980: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4981: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4982: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4983: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4984: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4985: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>

Line 4983: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>

4979: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4980: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4981: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4982: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4983: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4984: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4985: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4986: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4987: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>

Line 4985: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>

4981: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4982: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4983: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4984: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4985: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4986: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4987: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4988: nvl(p_rec.per_information6, hr_api.g_varchar2) or
4989: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>

Line 4987: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>

4983: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4984: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4985: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4986: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4987: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4988: nvl(p_rec.per_information6, hr_api.g_varchar2) or
4989: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
4990: nvl(p_rec.per_information7, hr_api.g_varchar2) or
4991: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>

Line 4989: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>

4985: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4986: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4987: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4988: nvl(p_rec.per_information6, hr_api.g_varchar2) or
4989: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
4990: nvl(p_rec.per_information7, hr_api.g_varchar2) or
4991: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
4992: nvl(p_rec.per_information8, hr_api.g_varchar2) or
4993: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>

Line 4991: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>

4987: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4988: nvl(p_rec.per_information6, hr_api.g_varchar2) or
4989: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
4990: nvl(p_rec.per_information7, hr_api.g_varchar2) or
4991: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
4992: nvl(p_rec.per_information8, hr_api.g_varchar2) or
4993: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
4994: nvl(p_rec.per_information9, hr_api.g_varchar2) or
4995: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>

Line 4993: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>

4989: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
4990: nvl(p_rec.per_information7, hr_api.g_varchar2) or
4991: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
4992: nvl(p_rec.per_information8, hr_api.g_varchar2) or
4993: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
4994: nvl(p_rec.per_information9, hr_api.g_varchar2) or
4995: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
4996: nvl(p_rec.per_information10, hr_api.g_varchar2) or
4997: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>

Line 4995: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>

4991: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
4992: nvl(p_rec.per_information8, hr_api.g_varchar2) or
4993: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
4994: nvl(p_rec.per_information9, hr_api.g_varchar2) or
4995: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
4996: nvl(p_rec.per_information10, hr_api.g_varchar2) or
4997: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
4998: nvl(p_rec.per_information11, hr_api.g_varchar2) or
4999: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>

Line 4997: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>

4993: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
4994: nvl(p_rec.per_information9, hr_api.g_varchar2) or
4995: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
4996: nvl(p_rec.per_information10, hr_api.g_varchar2) or
4997: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
4998: nvl(p_rec.per_information11, hr_api.g_varchar2) or
4999: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5000: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5001: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>

Line 4999: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>

4995: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
4996: nvl(p_rec.per_information10, hr_api.g_varchar2) or
4997: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
4998: nvl(p_rec.per_information11, hr_api.g_varchar2) or
4999: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5000: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5001: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5002: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5003: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>

Line 5001: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>

4997: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
4998: nvl(p_rec.per_information11, hr_api.g_varchar2) or
4999: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5000: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5001: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5002: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5003: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5004: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5005: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>

Line 5003: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>

4999: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5000: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5001: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5002: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5003: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5004: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5005: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5006: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5007: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>

Line 5005: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>

5001: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5002: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5003: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5004: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5005: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5006: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5007: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5008: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5009: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>

Line 5007: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>

5003: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5004: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5005: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5006: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5007: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5008: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5009: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5010: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5011: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>

Line 5009: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>

5005: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5006: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5007: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5008: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5009: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5010: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5011: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5012: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5013: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>

Line 5011: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>

5007: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5008: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5009: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5010: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5011: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5012: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5013: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5014: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5015: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>

Line 5013: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>

5009: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5010: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5011: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5012: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5013: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5014: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5015: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5016: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5017: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>

Line 5015: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>

5011: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5012: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5013: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5014: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5015: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5016: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5017: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5018: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5019: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>

Line 5017: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>

5013: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5014: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5015: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5016: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5017: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5018: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5019: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5020: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5021: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>

Line 5019: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>

5015: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5016: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5017: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5018: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5019: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5020: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5021: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5022: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5023: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>

Line 5021: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>

5017: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5018: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5019: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5020: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5021: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5022: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5023: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5024: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5025: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>

Line 5023: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>

5019: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5020: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5021: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5022: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5023: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5024: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5025: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5026: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5027: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>

Line 5025: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>

5021: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5022: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5023: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5024: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5025: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5026: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5027: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5028: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5029: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>

Line 5027: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>

5023: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5024: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5025: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5026: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5027: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5028: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5029: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5030: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5031: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>

Line 5029: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>

5025: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5026: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5027: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5028: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5029: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5030: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5031: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5032: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5033: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>

Line 5031: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>

5027: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5028: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5029: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5030: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5031: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5032: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5033: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5034: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5035: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>

Line 5033: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>

5029: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5030: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5031: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5032: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5033: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5034: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5035: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5036: nvl(p_rec.per_information30, hr_api.g_varchar2))
5037: then

Line 5035: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>

5031: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5032: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5033: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5034: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5035: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5036: nvl(p_rec.per_information30, hr_api.g_varchar2))
5037: then
5038: --
5039: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 5174: (p_rec in out nocopy per_per_shd.g_rec_type

5170: -- Access Status:
5171: -- Internal Table Handler Use Only.
5172: --
5173: procedure chk_per_information
5174: (p_rec in out nocopy per_per_shd.g_rec_type
5175: ,p_effective_date in date
5176: ,p_validation_start_date in date
5177: ,p_validation_end_date in date) is
5178: --

Line 5220: l_api_updating := per_per_shd.api_updating

5216: -- b) Any of the per_information (developer descriptive flex) values have
5217: -- changed
5218: -- c) A record is being inserted
5219: --
5220: l_api_updating := per_per_shd.api_updating
5221: (p_person_id => p_rec.person_id
5222: ,p_effective_date => p_effective_date
5223: ,p_object_version_number => p_rec.object_version_number
5224: );

Line 5229: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,

5225: if g_debug then
5226: hr_utility.set_location(l_proc, 30);
5227: end if;
5228: --
5229: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5230: hr_api.g_varchar2)
5231: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5232: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5233: hr_api.g_varchar2)

Line 5232: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,

5228: --
5229: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5230: hr_api.g_varchar2)
5231: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5232: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5233: hr_api.g_varchar2)
5234: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5235: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5236: hr_api.g_varchar2)

Line 5235: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,

5231: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5232: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5233: hr_api.g_varchar2)
5234: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5235: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5236: hr_api.g_varchar2)
5237: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5238: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5239: hr_api.g_varchar2)

Line 5238: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,

5234: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5235: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5236: hr_api.g_varchar2)
5237: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5238: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5239: hr_api.g_varchar2)
5240: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5241: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5242: hr_api.g_varchar2)

Line 5241: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,

5237: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5238: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5239: hr_api.g_varchar2)
5240: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5241: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5242: hr_api.g_varchar2)
5243: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5244: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5245: hr_api.g_varchar2)

Line 5244: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,

5240: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5241: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5242: hr_api.g_varchar2)
5243: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5244: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5245: hr_api.g_varchar2)
5246: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5247: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5248: hr_api.g_varchar2)

Line 5247: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,

5243: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5244: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5245: hr_api.g_varchar2)
5246: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5247: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5248: hr_api.g_varchar2)
5249: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5250: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5251: hr_api.g_varchar2)

Line 5250: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,

5246: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5247: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5248: hr_api.g_varchar2)
5249: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5250: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5251: hr_api.g_varchar2)
5252: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5253: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5254: hr_api.g_varchar2)

Line 5253: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,

5249: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5250: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5251: hr_api.g_varchar2)
5252: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5253: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5254: hr_api.g_varchar2)
5255: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5256: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5257: hr_api.g_varchar2)

Line 5256: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,

5252: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5253: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5254: hr_api.g_varchar2)
5255: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5256: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5257: hr_api.g_varchar2)
5258: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5259: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5260: hr_api.g_varchar2)

Line 5259: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,

5255: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5256: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5257: hr_api.g_varchar2)
5258: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5259: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5260: hr_api.g_varchar2)
5261: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5262: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5263: hr_api.g_varchar2)

Line 5262: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,

5258: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5259: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5260: hr_api.g_varchar2)
5261: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5262: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5263: hr_api.g_varchar2)
5264: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5265: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5266: hr_api.g_varchar2)

Line 5265: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,

5261: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5262: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5263: hr_api.g_varchar2)
5264: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5265: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5266: hr_api.g_varchar2)
5267: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5268: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5269: hr_api.g_varchar2)

Line 5268: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,

5264: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5265: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5266: hr_api.g_varchar2)
5267: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5268: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5269: hr_api.g_varchar2)
5270: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5271: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5272: hr_api.g_varchar2)

Line 5271: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,

5267: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5268: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5269: hr_api.g_varchar2)
5270: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5271: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5272: hr_api.g_varchar2)
5273: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5274: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5275: hr_api.g_varchar2)

Line 5274: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,

5270: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5271: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5272: hr_api.g_varchar2)
5273: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5274: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5275: hr_api.g_varchar2)
5276: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5277: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5278: hr_api.g_varchar2)

Line 5277: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,

5273: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5274: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5275: hr_api.g_varchar2)
5276: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5277: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5278: hr_api.g_varchar2)
5279: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5280: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5281: hr_api.g_varchar2)

Line 5280: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,

5276: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5277: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5278: hr_api.g_varchar2)
5279: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5280: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5281: hr_api.g_varchar2)
5282: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5283: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5284: hr_api.g_varchar2)

Line 5283: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,

5279: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5280: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5281: hr_api.g_varchar2)
5282: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5283: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5284: hr_api.g_varchar2)
5285: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5286: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5287: hr_api.g_varchar2)

Line 5286: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,

5282: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5283: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5284: hr_api.g_varchar2)
5285: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5286: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5287: hr_api.g_varchar2)
5288: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5289: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5290: hr_api.g_varchar2)

Line 5289: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,

5285: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5286: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5287: hr_api.g_varchar2)
5288: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5289: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5290: hr_api.g_varchar2)
5291: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5292: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5293: hr_api.g_varchar2)

Line 5292: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,

5288: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5289: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5290: hr_api.g_varchar2)
5291: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5292: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5293: hr_api.g_varchar2)
5294: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5295: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5296: hr_api.g_varchar2)

Line 5295: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,

5291: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5292: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5293: hr_api.g_varchar2)
5294: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5295: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5296: hr_api.g_varchar2)
5297: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5298: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5299: hr_api.g_varchar2)

Line 5298: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,

5294: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5295: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5296: hr_api.g_varchar2)
5297: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5298: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5299: hr_api.g_varchar2)
5300: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5301: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5302: hr_api.g_varchar2)

Line 5301: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,

5297: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5298: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5299: hr_api.g_varchar2)
5300: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5301: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5302: hr_api.g_varchar2)
5303: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5304: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5305: hr_api.g_varchar2)

Line 5304: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,

5300: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5301: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5302: hr_api.g_varchar2)
5303: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5304: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5305: hr_api.g_varchar2)
5306: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5307: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5308: hr_api.g_varchar2)

Line 5307: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,

5303: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5304: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5305: hr_api.g_varchar2)
5306: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5307: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5308: hr_api.g_varchar2)
5309: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5310: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5311: hr_api.g_varchar2)

Line 5310: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,

5306: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5307: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5308: hr_api.g_varchar2)
5309: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5310: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5311: hr_api.g_varchar2)
5312: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5313: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5314: hr_api.g_varchar2)

Line 5313: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,

5309: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5310: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5311: hr_api.g_varchar2)
5312: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5313: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5314: hr_api.g_varchar2)
5315: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5316: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5317: hr_api.g_varchar2)

Line 5316: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,

5312: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5313: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5314: hr_api.g_varchar2)
5315: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5316: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5317: hr_api.g_varchar2)
5318: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5319: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5320: hr_api.g_varchar2)

Line 5319: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,

5315: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5316: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5317: hr_api.g_varchar2)
5318: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5319: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5320: hr_api.g_varchar2)
5321: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
5322: (NOT l_api_updating))
5323: then

Line 5548: l_api_updating := per_per_shd.api_updating

5544: if hr_multi_message.no_exclusive_error
5545: (p_check_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5546: )
5547: then
5548: l_api_updating := per_per_shd.api_updating
5549: (p_person_id => p_person_id
5550: ,p_effective_date => p_effective_date
5551: ,p_object_version_number => p_object_version_number);
5552: --

Line 5564: and nvl(per_per_shd.g_old_rec.last_name, hr_api.g_varchar2)

5560: hr_utility.set_location(l_proc, 2);
5561: end if;
5562: --
5563: if ((l_api_updating
5564: and nvl(per_per_shd.g_old_rec.last_name, hr_api.g_varchar2)
5565: <> nvl(p_last_name,hr_api.g_varchar2))
5566: or
5567: (NOT l_api_updating)) then
5568: --

Line 5587: and nvl(per_per_shd.g_old_rec.first_name, hr_api.g_varchar2)

5583: hr_utility.set_location(l_proc, 3);
5584: end if;
5585: --
5586: if ((l_api_updating
5587: and nvl(per_per_shd.g_old_rec.first_name, hr_api.g_varchar2)
5588: <> nvl(p_first_name,hr_api.g_varchar2))
5589: or
5590: (NOT l_api_updating)) then
5591: --

Line 5810: l_api_updating := per_per_shd.api_updating

5806: -- e) known as values has changed
5807: -- f) date of birth has changed
5808: -- g) A record is being inserted
5809: --
5810: l_api_updating := per_per_shd.api_updating
5811: (p_person_id => p_person_id
5812: ,p_effective_date => p_effective_date
5813: ,p_object_version_number => p_object_version_number);
5814: --

Line 5815: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,

5811: (p_person_id => p_person_id
5812: ,p_effective_date => p_effective_date
5813: ,p_object_version_number => p_object_version_number);
5814: --
5815: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5816: hr_api.g_varchar2)
5817: <> nvl(p_last_name,hr_api.g_varchar2)) or
5818: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5819: hr_api.g_varchar2)

Line 5818: (l_api_updating and nvl(per_per_shd.g_old_rec.title,

5814: --
5815: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5816: hr_api.g_varchar2)
5817: <> nvl(p_last_name,hr_api.g_varchar2)) or
5818: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5819: hr_api.g_varchar2)
5820: <> nvl(p_title,hr_api.g_varchar2)) or
5821: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5822: hr_api.g_varchar2)

Line 5821: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,

5817: <> nvl(p_last_name,hr_api.g_varchar2)) or
5818: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5819: hr_api.g_varchar2)
5820: <> nvl(p_title,hr_api.g_varchar2)) or
5821: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5822: hr_api.g_varchar2)
5823: <> nvl(p_first_name,hr_api.g_varchar2)) or
5824: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5825: hr_api.g_varchar2)

Line 5824: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,

5820: <> nvl(p_title,hr_api.g_varchar2)) or
5821: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5822: hr_api.g_varchar2)
5823: <> nvl(p_first_name,hr_api.g_varchar2)) or
5824: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5825: hr_api.g_varchar2)
5826: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5827: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5828: hr_api.g_varchar2)

Line 5827: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,

5823: <> nvl(p_first_name,hr_api.g_varchar2)) or
5824: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5825: hr_api.g_varchar2)
5826: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5827: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5828: hr_api.g_varchar2)
5829: <> nvl(p_suffix,hr_api.g_varchar2)) or
5830: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5831: hr_api.g_varchar2)

Line 5830: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,

5826: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5827: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5828: hr_api.g_varchar2)
5829: <> nvl(p_suffix,hr_api.g_varchar2)) or
5830: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5831: hr_api.g_varchar2)
5832: <> nvl(p_known_as,hr_api.g_varchar2)) or
5833: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5834: hr_api.g_date)

Line 5833: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,

5829: <> nvl(p_suffix,hr_api.g_varchar2)) or
5830: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5831: hr_api.g_varchar2)
5832: <> nvl(p_known_as,hr_api.g_varchar2)) or
5833: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5834: hr_api.g_date)
5835: <> nvl(p_date_of_birth,hr_api.g_date)) or
5836: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5837: hr_api.g_varchar2)

Line 5836: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,

5832: <> nvl(p_known_as,hr_api.g_varchar2)) or
5833: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5834: hr_api.g_date)
5835: <> nvl(p_date_of_birth,hr_api.g_date)) or
5836: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5837: hr_api.g_varchar2)
5838: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5839: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5840: hr_api.g_varchar2)

Line 5839: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,

5835: <> nvl(p_date_of_birth,hr_api.g_date)) or
5836: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5837: hr_api.g_varchar2)
5838: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5839: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5840: hr_api.g_varchar2)
5841: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5842: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5843: hr_api.g_varchar2)

Line 5842: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,

5838: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5839: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5840: hr_api.g_varchar2)
5841: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5842: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5843: hr_api.g_varchar2)
5844: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5845: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5846: hr_api.g_varchar2)

Line 5845: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,

5841: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5842: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5843: hr_api.g_varchar2)
5844: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5845: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5846: hr_api.g_varchar2)
5847: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5848: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5849: hr_api.g_varchar2)

Line 5848: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,

5844: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5845: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5846: hr_api.g_varchar2)
5847: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5848: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5849: hr_api.g_varchar2)
5850: <> nvl(p_email_address,hr_api.g_varchar2)) or
5851: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5852: hr_api.g_varchar2)

Line 5851: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,

5847: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5848: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5849: hr_api.g_varchar2)
5850: <> nvl(p_email_address,hr_api.g_varchar2)) or
5851: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5852: hr_api.g_varchar2)
5853: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5854: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5855: hr_api.g_varchar2)

Line 5854: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,

5850: <> nvl(p_email_address,hr_api.g_varchar2)) or
5851: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5852: hr_api.g_varchar2)
5853: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5854: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5855: hr_api.g_varchar2)
5856: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5857: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5858: hr_api.g_varchar2)

Line 5857: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,

5853: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5854: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5855: hr_api.g_varchar2)
5856: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5857: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5858: hr_api.g_varchar2)
5859: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5860: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5861: hr_api.g_varchar2)

Line 5860: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,

5856: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5857: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5858: hr_api.g_varchar2)
5859: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5860: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5861: hr_api.g_varchar2)
5862: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5863: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5864: hr_api.g_varchar2)

Line 5863: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,

5859: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5860: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5861: hr_api.g_varchar2)
5862: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5863: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5864: hr_api.g_varchar2)
5865: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5866: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5867: hr_api.g_varchar2)

Line 5866: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,

5862: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5863: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5864: hr_api.g_varchar2)
5865: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5866: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5867: hr_api.g_varchar2)
5868: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5869: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5870: hr_api.g_varchar2)

Line 5869: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,

5865: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5866: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5867: hr_api.g_varchar2)
5868: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5869: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5870: hr_api.g_varchar2)
5871: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5872: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5873: hr_api.g_varchar2)

Line 5872: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,

5868: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5869: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5870: hr_api.g_varchar2)
5871: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5872: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5873: hr_api.g_varchar2)
5874: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5875: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5876: hr_api.g_varchar2)

Line 5875: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,

5871: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5872: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5873: hr_api.g_varchar2)
5874: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5875: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5876: hr_api.g_varchar2)
5877: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5878: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5879: hr_api.g_varchar2)

Line 5878: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,

5874: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5875: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5876: hr_api.g_varchar2)
5877: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5878: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5879: hr_api.g_varchar2)
5880: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5881: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5882: hr_api.g_varchar2)

Line 5881: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,

5877: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5878: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5879: hr_api.g_varchar2)
5880: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5881: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5882: hr_api.g_varchar2)
5883: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5884: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5885: hr_api.g_varchar2)

Line 5884: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,

5880: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5881: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5882: hr_api.g_varchar2)
5883: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5884: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5885: hr_api.g_varchar2)
5886: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5887: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5888: hr_api.g_varchar2)

Line 5887: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,

5883: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5884: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5885: hr_api.g_varchar2)
5886: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5887: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5888: hr_api.g_varchar2)
5889: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5890: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5891: hr_api.g_varchar2)

Line 5890: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,

5886: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5887: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5888: hr_api.g_varchar2)
5889: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5890: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5891: hr_api.g_varchar2)
5892: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5893: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5894: hr_api.g_varchar2)

Line 5893: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,

5889: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5890: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5891: hr_api.g_varchar2)
5892: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5893: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5894: hr_api.g_varchar2)
5895: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5896: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5897: hr_api.g_varchar2)

Line 5896: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,

5892: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5893: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5894: hr_api.g_varchar2)
5895: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5896: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5897: hr_api.g_varchar2)
5898: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5899: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5900: hr_api.g_varchar2)

Line 5899: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,

5895: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5896: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5897: hr_api.g_varchar2)
5898: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5899: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5900: hr_api.g_varchar2)
5901: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5902: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5903: hr_api.g_varchar2)

Line 5902: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,

5898: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5899: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5900: hr_api.g_varchar2)
5901: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5902: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5903: hr_api.g_varchar2)
5904: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5905: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5906: hr_api.g_varchar2)

Line 5905: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,

5901: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5902: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5903: hr_api.g_varchar2)
5904: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5905: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5906: hr_api.g_varchar2)
5907: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5908: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5909: hr_api.g_varchar2)

Line 5908: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,

5904: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5905: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5906: hr_api.g_varchar2)
5907: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5908: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5909: hr_api.g_varchar2)
5910: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5911: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5912: hr_api.g_varchar2)

Line 5911: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,

5907: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5908: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5909: hr_api.g_varchar2)
5910: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5911: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5912: hr_api.g_varchar2)
5913: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5914: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5915: hr_api.g_varchar2)

Line 5914: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,

5910: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5911: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5912: hr_api.g_varchar2)
5913: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5914: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5915: hr_api.g_varchar2)
5916: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5917: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5918: hr_api.g_varchar2)

Line 5917: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,

5913: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5914: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5915: hr_api.g_varchar2)
5916: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5917: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5918: hr_api.g_varchar2)
5919: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5920: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5921: hr_api.g_varchar2)

Line 5920: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,

5916: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5917: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5918: hr_api.g_varchar2)
5919: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5920: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5921: hr_api.g_varchar2)
5922: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5923: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5924: hr_api.g_varchar2)

Line 5923: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,

5919: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5920: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5921: hr_api.g_varchar2)
5922: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5923: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5924: hr_api.g_varchar2)
5925: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5926: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5927: hr_api.g_varchar2)

Line 5926: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,

5922: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5923: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5924: hr_api.g_varchar2)
5925: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5926: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5927: hr_api.g_varchar2)
5928: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5929: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5930: hr_api.g_varchar2)

Line 5929: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,

5925: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5926: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5927: hr_api.g_varchar2)
5928: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5929: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5930: hr_api.g_varchar2)
5931: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5932: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5933: hr_api.g_varchar2)

Line 5932: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,

5928: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5929: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5930: hr_api.g_varchar2)
5931: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5932: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5933: hr_api.g_varchar2)
5934: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5935: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5936: hr_api.g_varchar2)

Line 5935: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,

5931: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5932: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5933: hr_api.g_varchar2)
5934: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5935: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5936: hr_api.g_varchar2)
5937: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5938: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5939: hr_api.g_varchar2)

Line 5938: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,

5934: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5935: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5936: hr_api.g_varchar2)
5937: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5938: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5939: hr_api.g_varchar2)
5940: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5941: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5942: hr_api.g_varchar2)

Line 5941: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,

5937: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5938: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5939: hr_api.g_varchar2)
5940: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5941: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5942: hr_api.g_varchar2)
5943: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5944: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5945: hr_api.g_varchar2)

Line 5944: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,

5940: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5941: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5942: hr_api.g_varchar2)
5943: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5944: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5945: hr_api.g_varchar2)
5946: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5947: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5948: hr_api.g_varchar2)

Line 5947: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,

5943: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5944: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5945: hr_api.g_varchar2)
5946: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5947: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5948: hr_api.g_varchar2)
5949: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5950: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5951: hr_api.g_varchar2)

Line 5950: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,

5946: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5947: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5948: hr_api.g_varchar2)
5949: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5950: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5951: hr_api.g_varchar2)
5952: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5953: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5954: hr_api.g_varchar2)

Line 5953: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,

5949: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5950: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5951: hr_api.g_varchar2)
5952: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5953: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5954: hr_api.g_varchar2)
5955: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5956: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5957: hr_api.g_varchar2)

Line 5956: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,

5952: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5953: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5954: hr_api.g_varchar2)
5955: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5956: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5957: hr_api.g_varchar2)
5958: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5959: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5960: hr_api.g_varchar2)

Line 5959: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,

5955: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5956: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5957: hr_api.g_varchar2)
5958: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5959: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5960: hr_api.g_varchar2)
5961: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5962: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5963: hr_api.g_varchar2)

Line 5962: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,

5958: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5959: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5960: hr_api.g_varchar2)
5961: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5962: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5963: hr_api.g_varchar2)
5964: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5965: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5966: hr_api.g_varchar2)

Line 5965: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,

5961: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5962: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5963: hr_api.g_varchar2)
5964: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5965: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5966: hr_api.g_varchar2)
5967: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5968: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5969: hr_api.g_varchar2)

Line 5968: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,

5964: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5965: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5966: hr_api.g_varchar2)
5967: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5968: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5969: hr_api.g_varchar2)
5970: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5971: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5972: hr_api.g_varchar2)

Line 5971: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,

5967: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5968: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5969: hr_api.g_varchar2)
5970: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5971: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5972: hr_api.g_varchar2)
5973: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5974: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5975: hr_api.g_varchar2)

Line 5974: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,

5970: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5971: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5972: hr_api.g_varchar2)
5973: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5974: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5975: hr_api.g_varchar2)
5976: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5977: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5978: hr_api.g_varchar2)

Line 5977: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,

5973: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5974: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5975: hr_api.g_varchar2)
5976: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5977: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5978: hr_api.g_varchar2)
5979: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5980: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5981: hr_api.g_varchar2)

Line 5980: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,

5976: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5977: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5978: hr_api.g_varchar2)
5979: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5980: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5981: hr_api.g_varchar2)
5982: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5983: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5984: hr_api.g_varchar2)

Line 5983: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,

5979: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5980: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5981: hr_api.g_varchar2)
5982: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5983: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5984: hr_api.g_varchar2)
5985: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5986: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5987: hr_api.g_varchar2)

Line 5986: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,

5982: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5983: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5984: hr_api.g_varchar2)
5985: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5986: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5987: hr_api.g_varchar2)
5988: <> nvl(p_attribute16,hr_api.g_varchar2)) or
5989: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
5990: hr_api.g_varchar2)

Line 5989: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,

5985: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5986: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5987: hr_api.g_varchar2)
5988: <> nvl(p_attribute16,hr_api.g_varchar2)) or
5989: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
5990: hr_api.g_varchar2)
5991: <> nvl(p_attribute17,hr_api.g_varchar2)) or
5992: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
5993: hr_api.g_varchar2)

Line 5992: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,

5988: <> nvl(p_attribute16,hr_api.g_varchar2)) or
5989: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
5990: hr_api.g_varchar2)
5991: <> nvl(p_attribute17,hr_api.g_varchar2)) or
5992: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
5993: hr_api.g_varchar2)
5994: <> nvl(p_attribute18,hr_api.g_varchar2)) or
5995: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
5996: hr_api.g_varchar2)

Line 5995: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,

5991: <> nvl(p_attribute17,hr_api.g_varchar2)) or
5992: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
5993: hr_api.g_varchar2)
5994: <> nvl(p_attribute18,hr_api.g_varchar2)) or
5995: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
5996: hr_api.g_varchar2)
5997: <> nvl(p_attribute19,hr_api.g_varchar2)) or
5998: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
5999: hr_api.g_varchar2)

Line 5998: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,

5994: <> nvl(p_attribute18,hr_api.g_varchar2)) or
5995: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
5996: hr_api.g_varchar2)
5997: <> nvl(p_attribute19,hr_api.g_varchar2)) or
5998: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
5999: hr_api.g_varchar2)
6000: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6001: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6002: hr_api.g_varchar2)

Line 6001: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,

5997: <> nvl(p_attribute19,hr_api.g_varchar2)) or
5998: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
5999: hr_api.g_varchar2)
6000: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6001: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6002: hr_api.g_varchar2)
6003: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6004: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6005: hr_api.g_varchar2)

Line 6004: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,

6000: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6001: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6002: hr_api.g_varchar2)
6003: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6004: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6005: hr_api.g_varchar2)
6006: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6007: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6008: hr_api.g_varchar2)

Line 6007: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,

6003: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6004: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6005: hr_api.g_varchar2)
6006: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6007: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6008: hr_api.g_varchar2)
6009: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6010: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6011: hr_api.g_varchar2)

Line 6010: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,

6006: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6007: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6008: hr_api.g_varchar2)
6009: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6010: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6011: hr_api.g_varchar2)
6012: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6013: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6014: hr_api.g_varchar2)

Line 6013: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,

6009: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6010: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6011: hr_api.g_varchar2)
6012: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6013: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6014: hr_api.g_varchar2)
6015: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6016: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6017: hr_api.g_varchar2)

Line 6016: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,

6012: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6013: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6014: hr_api.g_varchar2)
6015: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6016: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6017: hr_api.g_varchar2)
6018: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6019: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6020: hr_api.g_varchar2)

Line 6019: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,

6015: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6016: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6017: hr_api.g_varchar2)
6018: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6019: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6020: hr_api.g_varchar2)
6021: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6022: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6023: hr_api.g_varchar2)

Line 6022: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,

6018: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6019: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6020: hr_api.g_varchar2)
6021: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6022: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6023: hr_api.g_varchar2)
6024: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6025: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6026: hr_api.g_varchar2)

Line 6025: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,

6021: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6022: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6023: hr_api.g_varchar2)
6024: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6025: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6026: hr_api.g_varchar2)
6027: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6028: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6029: hr_api.g_varchar2)

Line 6028: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,

6024: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6025: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6026: hr_api.g_varchar2)
6027: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6028: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6029: hr_api.g_varchar2)
6030: <> nvl(p_attribute30,hr_api.g_varchar2)) or
6031: (NOT l_api_updating)) then
6032: --

Line 6160: p_full_name := per_per_shd.g_old_rec.full_name;

6156: else
6157: --
6158: -- We are not updating the name so we must return the current full_name
6159: --
6160: p_full_name := per_per_shd.g_old_rec.full_name;
6161: p_order_name := per_per_shd.g_old_rec.order_name;
6162: p_global_name := per_per_shd.g_old_rec.global_name;
6163: p_local_name := per_per_shd.g_old_rec.local_name;
6164: end if;

Line 6161: p_order_name := per_per_shd.g_old_rec.order_name;

6157: --
6158: -- We are not updating the name so we must return the current full_name
6159: --
6160: p_full_name := per_per_shd.g_old_rec.full_name;
6161: p_order_name := per_per_shd.g_old_rec.order_name;
6162: p_global_name := per_per_shd.g_old_rec.global_name;
6163: p_local_name := per_per_shd.g_old_rec.local_name;
6164: end if;
6165: end if;

Line 6162: p_global_name := per_per_shd.g_old_rec.global_name;

6158: -- We are not updating the name so we must return the current full_name
6159: --
6160: p_full_name := per_per_shd.g_old_rec.full_name;
6161: p_order_name := per_per_shd.g_old_rec.order_name;
6162: p_global_name := per_per_shd.g_old_rec.global_name;
6163: p_local_name := per_per_shd.g_old_rec.local_name;
6164: end if;
6165: end if;
6166: if g_debug then

Line 6163: p_local_name := per_per_shd.g_old_rec.local_name;

6159: --
6160: p_full_name := per_per_shd.g_old_rec.full_name;
6161: p_order_name := per_per_shd.g_old_rec.order_name;
6162: p_global_name := per_per_shd.g_old_rec.global_name;
6163: p_local_name := per_per_shd.g_old_rec.local_name;
6164: end if;
6165: end if;
6166: if g_debug then
6167: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 6421: l_api_updating := per_per_shd.api_updating

6417: -- a) The current g_old_rec is current and
6418: -- b) The applicant number value has changed
6419: -- c) a record is being inserted
6420: --
6421: l_api_updating := per_per_shd.api_updating
6422: (p_person_id => p_person_id
6423: ,p_effective_date => p_effective_date
6424: ,p_object_version_number => p_object_version_number);
6425: if g_debug then

Line 6434: (nvl(per_per_shd.g_old_rec.applicant_number,

6430: -- has changed or if the system person type has changed in such a way
6431: -- that an applicant number is now required.
6432: --
6433: if ((l_api_updating and
6434: (nvl(per_per_shd.g_old_rec.applicant_number,
6435: hr_api.g_varchar2) <>
6436: nvl(p_applicant_number, hr_api.g_varchar2)
6437: or apl_sys_per_type_change
6438: (p_person_type_id

Line 6439: ,per_per_shd.g_old_rec.person_type_id

6435: hr_api.g_varchar2) <>
6436: nvl(p_applicant_number, hr_api.g_varchar2)
6437: or apl_sys_per_type_change
6438: (p_person_type_id
6439: ,per_per_shd.g_old_rec.person_type_id
6440: ,p_business_group_id)))
6441: or
6442: (NOT l_api_updating)) then
6443: --

Line 6499: per_per_shd.g_old_rec.applicant_number is not null and

6495: -- applicant number cannot change to null
6496: --
6497: if (l_api_updating) then
6498: if (l_system_person_type in ('EMP','EX_EMP') and
6499: per_per_shd.g_old_rec.applicant_number is not null and
6500: p_applicant_number is null) then
6501: hr_utility.set_message(801, 'HR_51200_PER_APL_NOT_NULL_UPD');
6502: l_apl_sys := true;
6503: hr_utility.raise_error;

Line 6517: nvl(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2) <>

6513: -- Check that on update with Automatic number generation
6514: -- the applicant number is not changed.
6515: --
6516: if (l_api_updating and
6517: nvl(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2) <>
6518: nvl(p_applicant_number, hr_api.g_varchar2) and
6519: l_gen_method = 'A') then
6520: hr_utility.set_message(801, 'HR_51201_PER_INV_APL_UPD');
6521: hr_utility.raise_error;

Line 6675: l_api_updating := per_per_shd.api_updating

6671: end if;
6672: --
6673: -- Check if the person is being updated
6674: --
6675: l_api_updating := per_per_shd.api_updating
6676: (p_person_id => p_person_id
6677: ,p_effective_date => p_effective_start_date
6678: ,p_object_version_number => p_object_version_number);
6679: if g_debug then

Line 6684: nvl(per_per_shd.g_old_rec.date_employee_data_verified,

6680: hr_utility.set_location(l_proc, 2);
6681: end if;
6682: --
6683: if ((l_api_updating and
6684: nvl(per_per_shd.g_old_rec.date_employee_data_verified,
6685: hr_api.g_date) <> nvl(p_date_employee_data_verified,
6686: hr_api.g_date)) or (NOT l_api_updating)) then
6687: --
6688: if g_debug then

Line 6789: l_api_updating := per_per_shd.api_updating

6785: end if;
6786: --
6787: -- Check if the person is being updated
6788: --
6789: l_api_updating := per_per_shd.api_updating
6790: (p_person_id => p_person_id
6791: ,p_effective_date => p_effective_date
6792: ,p_object_version_number => p_object_version_number);
6793: if g_debug then

Line 6798: nvl(per_per_shd.g_old_rec.vendor_id, hr_api.g_number) <>

6794: hr_utility.set_location(l_proc, 20);
6795: end if;
6796: --
6797: if ((l_api_updating and
6798: nvl(per_per_shd.g_old_rec.vendor_id, hr_api.g_number) <>
6799: nvl(p_vendor_id, hr_api.g_number)) or
6800: (NOT l_api_updating)) then
6801: --
6802: if g_debug then

Line 6931: l_api_updating := per_per_shd.api_updating

6927: -- a) The current g_old_rec is current and
6928: -- b) The suffix value has changed
6929: -- c) a record is being inserted
6930: --
6931: l_api_updating := per_per_shd.api_updating
6932: (p_person_id => p_person_id
6933: ,p_effective_date => p_effective_date
6934: ,p_object_version_number => p_object_version_number
6935: );

Line 6941: and nvl(per_per_shd.g_old_rec.suffix, hr_api.g_varchar2)

6937: hr_utility.set_location(l_proc, 30);
6938: end if;
6939: --
6940: if ((l_api_updating
6941: and nvl(per_per_shd.g_old_rec.suffix, hr_api.g_varchar2)
6942: <> nvl(p_suffix,hr_api.g_varchar2))
6943: or
6944: (NOT l_api_updating))
6945: then

Line 6996: l_api_updating := per_per_shd.api_updating

6992: l_proc := g_package||'chk_work_telephone';
6993: hr_utility.set_location('Entering:'|| l_proc, 10);
6994: end if;
6995:
6996: l_api_updating := per_per_shd.api_updating
6997: (p_person_id => p_person_id
6998: ,p_effective_date => p_effective_date
6999: ,p_object_version_number => p_object_version_number
7000: );

Line 7006: and nvl(per_per_shd.g_old_rec.work_telephone, hr_api.g_varchar2)

7002: hr_utility.set_location(l_proc, 30);
7003: end if;
7004: --
7005: if ((l_api_updating
7006: and nvl(per_per_shd.g_old_rec.work_telephone, hr_api.g_varchar2)
7007: <> nvl(p_work_telephone,hr_api.g_varchar2))
7008: or
7009: (NOT l_api_updating))
7010: then

Line 7283: Procedure check_non_updateable_args(p_rec in per_per_shd.g_rec_type

7279: -- Access Status:
7280: -- Internal Development Use Only.
7281: -- {End Of Comments}
7282: -- ----------------------------------------------------------------------------
7283: Procedure check_non_updateable_args(p_rec in per_per_shd.g_rec_type
7284: ,p_effective_date in date) is
7285: --
7286: l_proc varchar2(72) := g_package||'check_non_updateable_args';
7287: --

Line 7296: if not per_per_shd.api_updating

7292: --
7293: -- Only proceed with validation if a row exists for
7294: -- the current record in the HR Schema
7295: --
7296: if not per_per_shd.api_updating
7297: (p_person_id => p_rec.person_id
7298: ,p_effective_date => p_effective_date
7299: ,p_object_version_number => p_rec.object_version_number) then
7300: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 7310: nvl(per_per_shd.g_old_rec.business_group_id, hr_api.g_number) then

7306: hr_utility.set_location(l_proc, 6);
7307: end if;
7308: --
7309: if nvl(p_rec.business_group_id, hr_api.g_number) <>
7310: nvl(per_per_shd.g_old_rec.business_group_id, hr_api.g_number) then
7311: hr_api.argument_changed_error
7312: (
7313: p_api_name => l_proc
7314: ,p_argument => 'BUSINESS_GROUP_ID'

Line 7315: ,p_base_table => per_per_shd.g_tab_nam

7311: hr_api.argument_changed_error
7312: (
7313: p_api_name => l_proc
7314: ,p_argument => 'BUSINESS_GROUP_ID'
7315: ,p_base_table => per_per_shd.g_tab_nam
7316: );
7317: end if;
7318: if g_debug then
7319: hr_utility.set_location(' Leaving '||l_proc, 7);

Line 7568: (p_rec in per_per_shd.g_rec_type) is

7564: -- Access Status:
7565: -- Internal Row Handler Use Only.
7566: --
7567: procedure chk_df
7568: (p_rec in per_per_shd.g_rec_type) is
7569: --
7570: l_proc varchar2(72);
7571: --
7572: begin

Line 7579: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

7575: hr_utility.set_location('Entering:'||l_proc, 10);
7576: end if;
7577: --
7578: if ((p_rec.person_id is not null) and (
7579: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7580: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7581: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7582: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7583: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 7581: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

7577: --
7578: if ((p_rec.person_id is not null) and (
7579: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7580: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7581: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7582: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7583: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7584: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7585: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 7583: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

7579: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7580: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7581: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7582: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7583: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7584: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7585: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7586: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7587: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 7585: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

7581: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7582: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7583: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7584: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7585: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7586: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7587: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7588: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7589: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 7587: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

7583: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7584: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7585: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7586: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7587: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7588: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7589: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7590: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7591: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 7589: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

7585: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7586: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7587: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7588: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7589: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7590: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7591: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7592: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7593: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 7591: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

7587: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7588: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7589: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7590: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7591: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7592: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7593: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7594: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7595: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 7593: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

7589: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7590: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7591: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7592: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7593: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7594: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7595: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7596: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7597: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 7595: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

7591: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7592: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7593: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7594: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7595: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7596: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7597: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7598: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7599: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 7597: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

7593: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7594: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7595: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7596: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7597: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7598: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7599: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7600: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7601: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 7599: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

7595: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7596: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7597: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7598: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7599: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7600: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7601: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7602: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7603: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 7601: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

7597: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7598: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7599: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7600: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7601: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7602: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7603: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7604: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7605: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 7603: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

7599: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7600: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7601: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7602: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7603: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7604: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7605: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7606: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7607: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 7605: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

7601: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7602: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7603: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7604: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7605: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7606: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7607: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7608: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7609: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 7607: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

7603: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7604: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7605: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7606: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7607: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7608: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7609: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7610: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7611: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 7609: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

7605: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7606: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7607: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7608: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7609: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7610: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7611: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7612: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7613: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 7611: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

7607: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7608: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7609: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7610: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7611: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7612: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7613: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7614: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7615: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 7613: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

7609: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7610: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7611: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7612: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7613: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7614: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7615: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7616: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7617: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 7615: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

7611: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7612: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7613: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7614: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7615: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7616: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7617: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7618: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7619: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 7617: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

7613: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7614: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7615: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7616: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7617: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7618: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7619: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7620: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7621: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 7619: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

7615: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7616: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7617: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7618: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7619: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7620: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7621: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7622: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7623: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 7621: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

7617: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7618: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7619: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7620: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7621: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7622: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7623: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7624: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7625: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 7623: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

7619: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7620: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7621: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7622: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7623: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7624: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7625: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7626: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7627: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 7625: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

7621: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7622: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7623: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7624: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7625: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7626: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7627: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7628: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7629: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 7627: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

7623: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7624: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7625: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7626: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7627: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7628: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7629: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7630: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7631: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 7629: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

7625: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7626: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7627: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7628: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7629: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7630: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7631: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7632: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7633: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 7631: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

7627: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7628: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7629: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7630: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7631: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7632: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7633: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7634: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7635: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 7633: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

7629: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7630: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7631: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7632: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7633: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7634: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7635: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7636: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7637: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 7635: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

7631: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7632: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7633: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7634: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7635: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7636: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7637: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7638: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7639: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 7637: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

7633: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7634: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7635: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7636: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7637: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7638: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7639: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7640: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7641: or (p_rec.person_id is null) then

Line 7639: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

7635: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7636: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7637: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7638: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7639: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7640: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7641: or (p_rec.person_id is null) then
7642: --
7643: -- Only execute the validation if absolutely necessary:

Line 7725: (p_rec in out nocopy per_per_shd.g_rec_type,

7721: -- ----------------------------------------------------------------------------
7722: -- |---------------------------< insert_validate >----------------------------|
7723: -- ----------------------------------------------------------------------------
7724: Procedure insert_validate
7725: (p_rec in out nocopy per_per_shd.g_rec_type,
7726: p_effective_date in date,
7727: p_datetrack_mode in varchar2,
7728: p_validation_start_date in date,
7729: p_validation_end_date in date,

Line 7790: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

7786: -- Validate Business Group Id
7787: --
7788: hr_api.validate_bus_grp_id
7789: (p_business_group_id => p_rec.business_group_id
7790: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
7791: );
7792: hr_multi_message.end_validation_set;
7793: if g_debug then
7794: hr_utility.set_location(l_proc, 20);

Line 8448: (p_rec in out nocopy per_per_shd.g_rec_type,

8444: -- ----------------------------------------------------------------------------
8445: -- |---------------------------< update_validate >----------------------------|
8446: -- ----------------------------------------------------------------------------
8447: Procedure update_validate
8448: (p_rec in out nocopy per_per_shd.g_rec_type,
8449: p_effective_date in date,
8450: p_datetrack_mode in varchar2,
8451: p_validation_start_date in date,
8452: p_validation_end_date in date,

Line 8488: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

8484: -- Validate Business Group Id
8485: --
8486: hr_api.validate_bus_grp_id
8487: (p_business_group_id => p_rec.business_group_id
8488: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
8489: );
8490: hr_multi_message.end_validation_set;
8491: --
8492: --

Line 8693: ,p_old_person_type_id => per_per_shd.g_old_rec.person_type_id

8689: chk_person_type_id
8690: (p_person_id => p_rec.person_id
8691: ,p_business_group_id => p_rec.business_group_id
8692: ,p_person_type_id => p_rec.person_type_id
8693: ,p_old_person_type_id => per_per_shd.g_old_rec.person_type_id
8694: ,p_current_employee_flag => p_rec.current_employee_flag
8695: ,p_current_applicant_flag => p_rec.current_applicant_flag
8696: ,p_current_emp_or_apl_flag => p_rec.current_emp_or_apl_flag
8697: ,p_effective_date => p_effective_date

Line 9141: (p_rec in per_per_shd.g_rec_type,

9137: -- ----------------------------------------------------------------------------
9138: -- |---------------------------< delete_validate >----------------------------|
9139: -- ----------------------------------------------------------------------------
9140: Procedure delete_validate
9141: (p_rec in per_per_shd.g_rec_type,
9142: p_effective_date in date,
9143: p_datetrack_mode in varchar2,
9144: p_validation_start_date in date,
9145: p_validation_end_date in date) is

Line 9169: ,p_person_type_id => per_per_shd.g_old_rec.person_type_id

9165: -- check if delete operations are allowed
9166: --
9167: chk_delete
9168: (p_person_id => p_rec.person_id
9169: ,p_person_type_id => per_per_shd.g_old_rec.person_type_id
9170: ,p_business_group_id => per_per_shd.g_old_rec.business_group_id
9171: ,p_effective_date => p_effective_date
9172: ,p_datetrack_mode => p_datetrack_mode
9173: );

Line 9170: ,p_business_group_id => per_per_shd.g_old_rec.business_group_id

9166: --
9167: chk_delete
9168: (p_person_id => p_rec.person_id
9169: ,p_person_type_id => per_per_shd.g_old_rec.person_type_id
9170: ,p_business_group_id => per_per_shd.g_old_rec.business_group_id
9171: ,p_effective_date => p_effective_date
9172: ,p_datetrack_mode => p_datetrack_mode
9173: );
9174: --

Line 9226: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

9222: -- Validate the specified business group
9223: --
9224: hr_api.validate_bus_grp_id
9225: (p_business_group_id => p_business_group_id
9226: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
9227: );
9228: hr_multi_message.end_validation_set;
9229: if g_debug then
9230: hr_utility.set_location(l_proc,20);