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 874: l_api_updating := per_per_shd.api_updating

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

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

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

Line 1105: l_api_updating := per_per_shd.api_updating

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

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

1107: ,p_effective_date => p_effective_date
1108: ,p_object_version_number => p_object_version_number
1109: );
1110: if ((l_api_updating
1111: and nvl(per_per_shd.g_old_rec.marital_status, hr_api.g_varchar2)
1112: <> nvl(p_marital_status,hr_api.g_varchar2))
1113: or
1114: (NOT l_api_updating))
1115: then

Line 1232: l_api_updating := per_per_shd.api_updating

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

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

1234: ,p_effective_date => p_effective_date
1235: ,p_object_version_number => p_object_version_number
1236: );
1237: if ((l_api_updating
1238: and nvl(per_per_shd.g_old_rec.party_id, hr_api.g_number)
1239: <> nvl(p_party_id,hr_api.g_number))
1240: or
1241: (NOT l_api_updating))
1242: then

Line 1372: l_api_updating := per_per_shd.api_updating

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

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

1374: ,p_effective_date => p_effective_date
1375: ,p_object_version_number => p_object_version_number
1376: );
1377: if ((l_api_updating
1378: and nvl(per_per_shd.g_old_rec.nationality, hr_api.g_varchar2)
1379: <> nvl(p_nationality,hr_api.g_varchar2))
1380: or
1381: (NOT l_api_updating))
1382: then

Line 1555: l_api_updating := per_per_shd.api_updating

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

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

1556: (p_person_id => p_person_id
1557: ,p_effective_date => p_effective_date
1558: ,p_object_version_number => p_object_version_number);
1559: --
1560: if ((l_api_updating and nvl(per_per_shd.g_old_rec.national_identifier,
1561: hr_api.g_varchar2)
1562: <> nvl(p_national_identifier,hr_api.g_varchar2)) or
1563: (NOT l_api_updating)) then
1564: --

Line 1896: l_api_updating := per_per_shd.api_updating

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

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

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

Line 1920: ,per_per_shd.g_old_rec.person_type_id

1916: hr_api.g_varchar2) <>
1917: nvl(p_employee_number, hr_api.g_varchar2)
1918: or emp_sys_per_type_change
1919: (p_person_type_id
1920: ,per_per_shd.g_old_rec.person_type_id
1921: ,p_business_group_id)
1922: or emp_ni_change
1923: (p_national_identifier
1924: ,per_per_shd.g_old_rec.national_identifier

Line 1924: ,per_per_shd.g_old_rec.national_identifier

1920: ,per_per_shd.g_old_rec.person_type_id
1921: ,p_business_group_id)
1922: or emp_ni_change
1923: (p_national_identifier
1924: ,per_per_shd.g_old_rec.national_identifier
1925: ,l_gen_method)))
1926: or
1927: (NOT l_api_updating)) then
1928: --

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

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

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

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

Line 2295: l_api_updating := per_per_shd.api_updating

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

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

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

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

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

Line 2322: ,per_per_shd.g_old_rec.national_identifier

2318: or (p_current_npw_flag = 'Y'
2319: and per_per_shd.g_old_rec.current_npw_flag is null)
2320: or npw_ni_change
2321: (p_national_identifier
2322: ,per_per_shd.g_old_rec.national_identifier
2323: ,l_gen_method)))
2324: or
2325: (NOT l_api_updating)) then
2326: --

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

2331: -- If we are updating and the npw number has actually changed then
2332: -- ensure the number generation method is not automatic.
2333: --
2334: if l_api_updating and
2335: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>
2336: nvl(p_npw_number, hr_api.g_varchar2) and
2337: l_gen_method = 'A' then
2338: -- ER FPT
2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then

Line 2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then

2335: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>
2336: nvl(p_npw_number, hr_api.g_varchar2) and
2337: l_gen_method = 'A' then
2338: -- ER FPT
2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2340: hr_utility.set_message(800, 'HR_289657_PER_INV_CWK_UPD');
2341: hr_utility.raise_error;
2342: end if;
2343: end if;

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

2371: --
2372: if l_gen_method = 'A' and
2373: p_npw_number is not null and
2374:
2375: p_npw_number <> nvl(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2) then
2376: -- ER FPT
2377: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2378: hr_utility.set_message(800,'PER_289635_CWK_NUM_NOT_NULL');
2379: hr_utility.raise_error;

Line 2377: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then

2373: p_npw_number is not null and
2374:
2375: p_npw_number <> nvl(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2) then
2376: -- ER FPT
2377: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2378: hr_utility.set_message(800,'PER_289635_CWK_NUM_NOT_NULL');
2379: hr_utility.raise_error;
2380: end if;
2381: end if;

Line 2600: l_api_updating := per_per_shd.api_updating

2596: -- a) The current g_old_rec is current and
2597: -- b) The expense check send to address value has changed
2598: -- c) a record is being inserted
2599: --
2600: l_api_updating := per_per_shd.api_updating
2601: (p_person_id => p_person_id
2602: ,p_effective_date => p_effective_date
2603: ,p_object_version_number => p_object_version_number
2604: );

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

2606: hr_utility.set_location(l_proc, 30);
2607: end if;
2608: --
2609: if ((l_api_updating
2610: and nvl(per_per_shd.g_old_rec.expense_check_send_to_address,
2611: hr_api.g_varchar2)
2612: <> nvl(p_expense_check_send_to_addres,hr_api.g_varchar2))
2613: or
2614: (NOT l_api_updating))

Line 2785: l_api_updating := per_per_shd.api_updating

2781: -- b) The sex value has changed
2782: -- c) The title value has changed
2783: -- d)A record is being inserted
2784: --
2785: l_api_updating := per_per_shd.api_updating
2786: (p_person_id => p_person_id
2787: ,p_effective_date => p_effective_date
2788: ,p_object_version_number => p_object_version_number
2789: );

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

2791: hr_utility.set_location(l_proc, 30);
2792: end if;
2793: --
2794: if ((l_api_updating
2795: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2796: <> nvl(p_sex,hr_api.g_varchar2))
2797: or
2798: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2799: <> nvl(p_title,hr_api.g_varchar2))

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

2794: if ((l_api_updating
2795: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2796: <> nvl(p_sex,hr_api.g_varchar2))
2797: or
2798: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2799: <> nvl(p_title,hr_api.g_varchar2))
2800: or
2801: (NOT l_api_updating))
2802: then

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

2982: --
2983: if ((p_person_id is null)
2984: OR
2985: ((p_person_id is not null) and
2986: nvl(p_town_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2))) then
2987: --
2988: if g_debug then
2989: hr_utility.set_location(l_proc, 2);
2990: end if;

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

3096: --
3097: if ((p_person_id is null)
3098: OR
3099: ((p_person_id is not null) and
3100: nvl(p_region_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2))) then
3101: --
3102: if g_debug then
3103: hr_utility.set_location(l_proc, 2);
3104: end if;

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

3198: --
3199: if ((p_person_id is null)
3200: OR
3201: ((p_person_id is not null) and
3202: nvl(p_country_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2))) then
3203: --
3204: if g_debug then
3205: hr_utility.set_location(l_proc, 2);
3206: end if;

Line 3315: l_api_updating := per_per_shd.api_updating

3311: -- a) The current g_old_rec is current and
3312: -- b) The start date value has changed
3313: -- c) A record is being inserted
3314: --
3315: l_api_updating := per_per_shd.api_updating
3316: (p_person_id => p_person_id
3317: ,p_effective_date => p_effective_date
3318: ,p_object_version_number => p_object_version_number);
3319: --

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

3329: -- Error: Invalid Start Date
3330: hr_utility.set_message(801, 'HR_7514_PER_START_DATE_INVALID');
3331: hr_utility.raise_error;
3332: end if;
3333: elsif(l_api_updating and per_per_shd.g_old_rec.start_date <>
3334: p_start_date) then
3335: --
3336: -- On update check if start date is the same as the earliest effective
3337: -- start date

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

3453: hr_utility.set_location('Entering:'|| l_proc,5);
3454: end if;
3455: --
3456: if p_original_date_of_hire is NOT NULL then
3457: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3458: <> nvl(p_original_date_of_hire, hr_api.g_date)) or
3459: (per_per_shd.g_old_rec.start_date <> p_start_date) then
3460: --
3461: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then

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

3455: --
3456: if p_original_date_of_hire is NOT NULL then
3457: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3458: <> nvl(p_original_date_of_hire, hr_api.g_date)) or
3459: (per_per_shd.g_old_rec.start_date <> p_start_date) then
3460: --
3461: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
3462: --
3463: if (p_person_id is null and

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

4302: -- Check if the value for per information1 is set on insert or has
4303: -- changed on update.
4304: --
4305: if (((nvl(p_per_information1,hr_api.g_varchar2)
4306: <> nvl(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
4307: and p_api_updating)
4308: or (NOT p_api_updating))
4309: and p_per_information1 is not null)
4310: then

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

4339: -- Check if the value for per information2 is set on insert or has
4340: -- changed on update.
4341: --
4342: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
4343: nvl(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
4344: and p_api_updating) or
4345: (NOT p_api_updating)) and
4346: p_per_information2 is not null)
4347: then

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

4376: -- Check if the value for per information3 is set on insert or has
4377: -- changed on update.
4378: --
4379: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
4380: nvl(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
4381: and p_api_updating) or
4382: (NOT p_api_updating)) and
4383: p_per_information3 is not null)
4384: then

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

4402: -- Check if the value for per information4 is set on insert or has
4403: -- changed on update.
4404: --
4405: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
4406: nvl(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
4407: and p_api_updating) or
4408: (NOT p_api_updating)) and
4409: p_per_information4 is not null)
4410: then

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

4439: -- Check if the value for per information5 is set on insert or has
4440: -- changed on update.
4441: --
4442: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
4443: nvl(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
4444: and p_api_updating) or
4445: (NOT p_api_updating)) and
4446: p_per_information5 is not null)
4447: then

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

4476: -- Check if the value for per information6 is set on insert or has
4477: -- changed on update.
4478: --
4479: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
4480: nvl(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
4481: and p_api_updating) or
4482: (NOT p_api_updating)) and
4483: p_per_information6 is not null)
4484: then

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

4513: -- Check if the value for per information7 is set on insert or has
4514: -- changed on update.
4515: --
4516: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
4517: nvl(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
4518: and p_api_updating) or
4519: (NOT p_api_updating)) and
4520: p_per_information7 is not null)
4521: then

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

4550: -- Check if the value for per information8 is set on insert or has
4551: -- changed on update.
4552: --
4553: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
4554: nvl(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
4555: and p_api_updating) or
4556: (NOT p_api_updating)) and
4557: p_per_information8 is not null)
4558: then

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

4599: -- Check if the value for per information9 is set on insert or has
4600: -- changed on update.
4601: --
4602: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
4603: nvl(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
4604: and p_api_updating) or
4605: (NOT p_api_updating)) and
4606: p_per_information9 is not null)
4607: then

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

4633: hr_utility.set_location( l_proc, 200);
4634: end if;
4635: --
4636: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
4637: nvl(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
4638: and p_api_updating) or
4639: (NOT p_api_updating)) and
4640: p_per_information10 is not null)
4641: then

Line 4969: (p_rec in per_per_shd.g_rec_type) is

4965: -- |-------------------------------< chk_ddf >---------------------------------|
4966: -- -----------------------------------------------------------------------------
4967: --
4968: procedure chk_ddf
4969: (p_rec in per_per_shd.g_rec_type) is
4970: --
4971: l_proc varchar2(72);
4972: l_error exception;
4973: --

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

4982: --
4983: if (p_rec.person_id is null)
4984: or ((p_rec.person_id is not null)
4985: and
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>

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

4984: or ((p_rec.person_id is not null)
4985: and
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>

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

4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>

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

4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>

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

4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>

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

4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>

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

4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>

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

4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>

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

4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>

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

5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>

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

5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>

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

5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>

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

5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>

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

5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>

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

5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>

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

5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>

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

5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>

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

5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>

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

5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>

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

5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>

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

5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>

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

5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>

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

5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>

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

5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>

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

5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>

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

5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>

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

5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>

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

5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>

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

5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>

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

5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5048: then

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

5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5048: then
5049: --
5050: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 5185: (p_rec in out nocopy per_per_shd.g_rec_type

5181: -- Access Status:
5182: -- Internal Table Handler Use Only.
5183: --
5184: procedure chk_per_information
5185: (p_rec in out nocopy per_per_shd.g_rec_type
5186: ,p_effective_date in date
5187: ,p_validation_start_date in date
5188: ,p_validation_end_date in date) is
5189: --

Line 5231: l_api_updating := per_per_shd.api_updating

5227: -- b) Any of the per_information (developer descriptive flex) values have
5228: -- changed
5229: -- c) A record is being inserted
5230: --
5231: l_api_updating := per_per_shd.api_updating
5232: (p_person_id => p_rec.person_id
5233: ,p_effective_date => p_effective_date
5234: ,p_object_version_number => p_rec.object_version_number
5235: );

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

5236: if g_debug then
5237: hr_utility.set_location(l_proc, 30);
5238: end if;
5239: --
5240: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5241: hr_api.g_varchar2)
5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)

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

5239: --
5240: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5241: hr_api.g_varchar2)
5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)

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

5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)

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

5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)

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

5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)

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

5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)

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

5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)

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

5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)

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

5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)

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

5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)

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

5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)

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

5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)

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

5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)

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

5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)

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

5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)

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

5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)

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

5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)

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

5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)

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

5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)

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

5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)

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

5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)

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

5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)

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

5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)

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

5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)

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

5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)

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

5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)

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

5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)

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

5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)

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

5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)

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

5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5331: hr_api.g_varchar2)

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

5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5331: hr_api.g_varchar2)
5332: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
5333: (NOT l_api_updating))
5334: then

Line 5559: l_api_updating := per_per_shd.api_updating

5555: if hr_multi_message.no_exclusive_error
5556: (p_check_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5557: )
5558: then
5559: l_api_updating := per_per_shd.api_updating
5560: (p_person_id => p_person_id
5561: ,p_effective_date => p_effective_date
5562: ,p_object_version_number => p_object_version_number);
5563: --

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

5571: hr_utility.set_location(l_proc, 2);
5572: end if;
5573: --
5574: if ((l_api_updating
5575: and nvl(per_per_shd.g_old_rec.last_name, hr_api.g_varchar2)
5576: <> nvl(p_last_name,hr_api.g_varchar2))
5577: or
5578: (NOT l_api_updating)) then
5579: --

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

5594: hr_utility.set_location(l_proc, 3);
5595: end if;
5596: --
5597: if ((l_api_updating
5598: and nvl(per_per_shd.g_old_rec.first_name, hr_api.g_varchar2)
5599: <> nvl(p_first_name,hr_api.g_varchar2))
5600: or
5601: (NOT l_api_updating)) then
5602: --

Line 5821: l_api_updating := per_per_shd.api_updating

5817: -- e) known as values has changed
5818: -- f) date of birth has changed
5819: -- g) A record is being inserted
5820: --
5821: l_api_updating := per_per_shd.api_updating
5822: (p_person_id => p_person_id
5823: ,p_effective_date => p_effective_date
5824: ,p_object_version_number => p_object_version_number);
5825: --

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

5822: (p_person_id => p_person_id
5823: ,p_effective_date => p_effective_date
5824: ,p_object_version_number => p_object_version_number);
5825: --
5826: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5827: hr_api.g_varchar2)
5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)

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

5825: --
5826: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5827: hr_api.g_varchar2)
5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)

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

5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)

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

5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)

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

5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)

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

5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)

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

5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)

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

5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)

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

5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)

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

5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)

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

5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)

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

5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)

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

5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)

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

5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)

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

5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)

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

5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)

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

5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)

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

5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)

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

5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)

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

5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)

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

5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)

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

5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)

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

5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)

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

5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)

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

5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)

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

5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)

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

5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)

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

5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)

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

5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)

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

5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)

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

5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)

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

5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)

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

5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)

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

5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)

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

5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)

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

5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)

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

5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)

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

5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)

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

5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)

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

5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)

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

5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)

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

5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)

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

5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)

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

5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)

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

5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)

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

5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)

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

5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)

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

5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)

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

5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)

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

5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)

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

5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)

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

5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)

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

5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)

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

5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)

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

5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)

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

5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)

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

5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)

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

5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)

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

5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)

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

5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)

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

6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)

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

6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)

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

6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)

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

6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)

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

6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)

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

6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)

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

6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)

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

6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)

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

6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)

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

6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)

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

6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6040: hr_api.g_varchar2)

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

6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6040: hr_api.g_varchar2)
6041: <> nvl(p_attribute30,hr_api.g_varchar2)) or
6042: (NOT l_api_updating)) then
6043: --

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

6167: else
6168: --
6169: -- We are not updating the name so we must return the current full_name
6170: --
6171: p_full_name := per_per_shd.g_old_rec.full_name;
6172: p_order_name := per_per_shd.g_old_rec.order_name;
6173: p_global_name := per_per_shd.g_old_rec.global_name;
6174: p_local_name := per_per_shd.g_old_rec.local_name;
6175: end if;

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

6168: --
6169: -- We are not updating the name so we must return the current full_name
6170: --
6171: p_full_name := per_per_shd.g_old_rec.full_name;
6172: p_order_name := per_per_shd.g_old_rec.order_name;
6173: p_global_name := per_per_shd.g_old_rec.global_name;
6174: p_local_name := per_per_shd.g_old_rec.local_name;
6175: end if;
6176: end if;

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

6169: -- We are not updating the name so we must return the current full_name
6170: --
6171: p_full_name := per_per_shd.g_old_rec.full_name;
6172: p_order_name := per_per_shd.g_old_rec.order_name;
6173: p_global_name := per_per_shd.g_old_rec.global_name;
6174: p_local_name := per_per_shd.g_old_rec.local_name;
6175: end if;
6176: end if;
6177: if g_debug then

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

6170: --
6171: p_full_name := per_per_shd.g_old_rec.full_name;
6172: p_order_name := per_per_shd.g_old_rec.order_name;
6173: p_global_name := per_per_shd.g_old_rec.global_name;
6174: p_local_name := per_per_shd.g_old_rec.local_name;
6175: end if;
6176: end if;
6177: if g_debug then
6178: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 6432: l_api_updating := per_per_shd.api_updating

6428: -- a) The current g_old_rec is current and
6429: -- b) The applicant number value has changed
6430: -- c) a record is being inserted
6431: --
6432: l_api_updating := per_per_shd.api_updating
6433: (p_person_id => p_person_id
6434: ,p_effective_date => p_effective_date
6435: ,p_object_version_number => p_object_version_number);
6436: if g_debug then

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

6441: -- has changed or if the system person type has changed in such a way
6442: -- that an applicant number is now required.
6443: --
6444: if ((l_api_updating and
6445: (nvl(per_per_shd.g_old_rec.applicant_number,
6446: hr_api.g_varchar2) <>
6447: nvl(p_applicant_number, hr_api.g_varchar2)
6448: or apl_sys_per_type_change
6449: (p_person_type_id

Line 6450: ,per_per_shd.g_old_rec.person_type_id

6446: hr_api.g_varchar2) <>
6447: nvl(p_applicant_number, hr_api.g_varchar2)
6448: or apl_sys_per_type_change
6449: (p_person_type_id
6450: ,per_per_shd.g_old_rec.person_type_id
6451: ,p_business_group_id)))
6452: or
6453: (NOT l_api_updating)) then
6454: --

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

6506: -- applicant number cannot change to null
6507: --
6508: if (l_api_updating) then
6509: if (l_system_person_type in ('EMP','EX_EMP') and
6510: per_per_shd.g_old_rec.applicant_number is not null and
6511: p_applicant_number is null) then
6512: hr_utility.set_message(801, 'HR_51200_PER_APL_NOT_NULL_UPD');
6513: l_apl_sys := true;
6514: hr_utility.raise_error;

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

6524: -- Check that on update with Automatic number generation
6525: -- the applicant number is not changed.
6526: --
6527: if (l_api_updating and
6528: nvl(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2) <>
6529: nvl(p_applicant_number, hr_api.g_varchar2) and
6530: l_gen_method = 'A') then
6531: hr_utility.set_message(801, 'HR_51201_PER_INV_APL_UPD');
6532: hr_utility.raise_error;

Line 6686: l_api_updating := per_per_shd.api_updating

6682: end if;
6683: --
6684: -- Check if the person is being updated
6685: --
6686: l_api_updating := per_per_shd.api_updating
6687: (p_person_id => p_person_id
6688: ,p_effective_date => p_effective_start_date
6689: ,p_object_version_number => p_object_version_number);
6690: if g_debug then

Line 6695: nvl(per_per_shd.g_old_rec.date_employee_data_verified,

6691: hr_utility.set_location(l_proc, 2);
6692: end if;
6693: --
6694: if ((l_api_updating and
6695: nvl(per_per_shd.g_old_rec.date_employee_data_verified,
6696: hr_api.g_date) <> nvl(p_date_employee_data_verified,
6697: hr_api.g_date)) or (NOT l_api_updating)) then
6698: --
6699: if g_debug then

Line 6800: l_api_updating := per_per_shd.api_updating

6796: end if;
6797: --
6798: -- Check if the person is being updated
6799: --
6800: l_api_updating := per_per_shd.api_updating
6801: (p_person_id => p_person_id
6802: ,p_effective_date => p_effective_date
6803: ,p_object_version_number => p_object_version_number);
6804: if g_debug then

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

6805: hr_utility.set_location(l_proc, 20);
6806: end if;
6807: --
6808: if ((l_api_updating and
6809: nvl(per_per_shd.g_old_rec.vendor_id, hr_api.g_number) <>
6810: nvl(p_vendor_id, hr_api.g_number)) or
6811: (NOT l_api_updating)) then
6812: --
6813: if g_debug then

Line 6942: l_api_updating := per_per_shd.api_updating

6938: -- a) The current g_old_rec is current and
6939: -- b) The suffix value has changed
6940: -- c) a record is being inserted
6941: --
6942: l_api_updating := per_per_shd.api_updating
6943: (p_person_id => p_person_id
6944: ,p_effective_date => p_effective_date
6945: ,p_object_version_number => p_object_version_number
6946: );

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

6948: hr_utility.set_location(l_proc, 30);
6949: end if;
6950: --
6951: if ((l_api_updating
6952: and nvl(per_per_shd.g_old_rec.suffix, hr_api.g_varchar2)
6953: <> nvl(p_suffix,hr_api.g_varchar2))
6954: or
6955: (NOT l_api_updating))
6956: then

Line 7007: l_api_updating := per_per_shd.api_updating

7003: l_proc := g_package||'chk_work_telephone';
7004: hr_utility.set_location('Entering:'|| l_proc, 10);
7005: end if;
7006:
7007: l_api_updating := per_per_shd.api_updating
7008: (p_person_id => p_person_id
7009: ,p_effective_date => p_effective_date
7010: ,p_object_version_number => p_object_version_number
7011: );

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

7013: hr_utility.set_location(l_proc, 30);
7014: end if;
7015: --
7016: if ((l_api_updating
7017: and nvl(per_per_shd.g_old_rec.work_telephone, hr_api.g_varchar2)
7018: <> nvl(p_work_telephone,hr_api.g_varchar2))
7019: or
7020: (NOT l_api_updating))
7021: then

Line 7294: Procedure check_non_updateable_args(p_rec in per_per_shd.g_rec_type

7290: -- Access Status:
7291: -- Internal Development Use Only.
7292: -- {End Of Comments}
7293: -- ----------------------------------------------------------------------------
7294: Procedure check_non_updateable_args(p_rec in per_per_shd.g_rec_type
7295: ,p_effective_date in date) is
7296: --
7297: l_proc varchar2(72) := g_package||'check_non_updateable_args';
7298: --

Line 7307: if not per_per_shd.api_updating

7303: --
7304: -- Only proceed with validation if a row exists for
7305: -- the current record in the HR Schema
7306: --
7307: if not per_per_shd.api_updating
7308: (p_person_id => p_rec.person_id
7309: ,p_effective_date => p_effective_date
7310: ,p_object_version_number => p_rec.object_version_number) then
7311: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

7317: hr_utility.set_location(l_proc, 6);
7318: end if;
7319: --
7320: if nvl(p_rec.business_group_id, hr_api.g_number) <>
7321: nvl(per_per_shd.g_old_rec.business_group_id, hr_api.g_number) then
7322: hr_api.argument_changed_error
7323: (
7324: p_api_name => l_proc
7325: ,p_argument => 'BUSINESS_GROUP_ID'

Line 7326: ,p_base_table => per_per_shd.g_tab_nam

7322: hr_api.argument_changed_error
7323: (
7324: p_api_name => l_proc
7325: ,p_argument => 'BUSINESS_GROUP_ID'
7326: ,p_base_table => per_per_shd.g_tab_nam
7327: );
7328: end if;
7329: if g_debug then
7330: hr_utility.set_location(' Leaving '||l_proc, 7);

Line 7579: (p_rec in per_per_shd.g_rec_type) is

7575: -- Access Status:
7576: -- Internal Row Handler Use Only.
7577: --
7578: procedure chk_df
7579: (p_rec in per_per_shd.g_rec_type) is
7580: --
7581: l_proc varchar2(72);
7582: --
7583: begin

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

7586: hr_utility.set_location('Entering:'||l_proc, 10);
7587: end if;
7588: --
7589: if ((p_rec.person_id is not null) and (
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

7588: --
7589: if ((p_rec.person_id is not null) and (
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7652: or (p_rec.person_id is null) then

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

7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7652: or (p_rec.person_id is null) then
7653: --
7654: -- Only execute the validation if absolutely necessary:

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

7732: -- ----------------------------------------------------------------------------
7733: -- |---------------------------< insert_validate >----------------------------|
7734: -- ----------------------------------------------------------------------------
7735: Procedure insert_validate
7736: (p_rec in out nocopy per_per_shd.g_rec_type,
7737: p_effective_date in date,
7738: p_datetrack_mode in varchar2,
7739: p_validation_start_date in date,
7740: p_validation_end_date in date,

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

7797: -- Validate Business Group Id
7798: --
7799: hr_api.validate_bus_grp_id
7800: (p_business_group_id => p_rec.business_group_id
7801: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
7802: );
7803: hr_multi_message.end_validation_set;
7804: if g_debug then
7805: hr_utility.set_location(l_proc, 20);

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

8455: -- ----------------------------------------------------------------------------
8456: -- |---------------------------< update_validate >----------------------------|
8457: -- ----------------------------------------------------------------------------
8458: Procedure update_validate
8459: (p_rec in out nocopy per_per_shd.g_rec_type,
8460: p_effective_date in date,
8461: p_datetrack_mode in varchar2,
8462: p_validation_start_date in date,
8463: p_validation_end_date in date,

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

8495: -- Validate Business Group Id
8496: --
8497: hr_api.validate_bus_grp_id
8498: (p_business_group_id => p_rec.business_group_id
8499: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
8500: );
8501: hr_multi_message.end_validation_set;
8502: --
8503: --

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

8700: chk_person_type_id
8701: (p_person_id => p_rec.person_id
8702: ,p_business_group_id => p_rec.business_group_id
8703: ,p_person_type_id => p_rec.person_type_id
8704: ,p_old_person_type_id => per_per_shd.g_old_rec.person_type_id
8705: ,p_current_employee_flag => p_rec.current_employee_flag
8706: ,p_current_applicant_flag => p_rec.current_applicant_flag
8707: ,p_current_emp_or_apl_flag => p_rec.current_emp_or_apl_flag
8708: ,p_effective_date => p_effective_date

Line 9152: (p_rec in per_per_shd.g_rec_type,

9148: -- ----------------------------------------------------------------------------
9149: -- |---------------------------< delete_validate >----------------------------|
9150: -- ----------------------------------------------------------------------------
9151: Procedure delete_validate
9152: (p_rec in per_per_shd.g_rec_type,
9153: p_effective_date in date,
9154: p_datetrack_mode in varchar2,
9155: p_validation_start_date in date,
9156: p_validation_end_date in date) is

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

9176: -- check if delete operations are allowed
9177: --
9178: chk_delete
9179: (p_person_id => p_rec.person_id
9180: ,p_person_type_id => per_per_shd.g_old_rec.person_type_id
9181: ,p_business_group_id => per_per_shd.g_old_rec.business_group_id
9182: ,p_effective_date => p_effective_date
9183: ,p_datetrack_mode => p_datetrack_mode
9184: );

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

9177: --
9178: chk_delete
9179: (p_person_id => p_rec.person_id
9180: ,p_person_type_id => per_per_shd.g_old_rec.person_type_id
9181: ,p_business_group_id => per_per_shd.g_old_rec.business_group_id
9182: ,p_effective_date => p_effective_date
9183: ,p_datetrack_mode => p_datetrack_mode
9184: );
9185: --

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

9233: -- Validate the specified business group
9234: --
9235: hr_api.validate_bus_grp_id
9236: (p_business_group_id => p_business_group_id
9237: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
9238: );
9239: hr_multi_message.end_validation_set;
9240: if g_debug then
9241: hr_utility.set_location(l_proc,20);