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_SUC_BUS dependencies on HR_API

Line 58: AND NVL (p_succession_plan_id, hr_api.g_number) <>

54: );
55:
56: --
57: IF ( l_api_updating
58: AND NVL (p_succession_plan_id, hr_api.g_number) <>
59: per_suc_shd.g_old_rec.succession_plan_id
60: )
61: THEN
62: --

Line 152: AND NVL (p_person_id, hr_api.g_number) <>

148: );
149:
150: --
151: IF ( l_api_updating
152: AND NVL (p_person_id, hr_api.g_number) <>
153: NVL (per_suc_shd.g_old_rec.person_id, hr_api.g_number)
154: OR NOT l_api_updating
155: )
156: THEN

Line 153: NVL (per_suc_shd.g_old_rec.person_id, hr_api.g_number)

149:
150: --
151: IF ( l_api_updating
152: AND NVL (p_person_id, hr_api.g_number) <>
153: NVL (per_suc_shd.g_old_rec.person_id, hr_api.g_number)
154: OR NOT l_api_updating
155: )
156: THEN
157: --

Line 261: hr_api.g_eot

257: WHERE per.position_id = NVL (p_position_id, -1)
258: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
259: AND p_effective_date BETWEEN per.date_effective
260: AND NVL (hr_general.get_position_date_end (per.position_id),
261: hr_api.g_eot
262: );
263: --
264: BEGIN
265: --

Line 275: AND NVL (p_position_id, hr_api.g_number) <>

271: );
272:
273: --
274: IF ( l_api_updating
275: AND NVL (p_position_id, hr_api.g_number) <>
276: NVL (per_suc_shd.g_old_rec.position_id, hr_api.g_number)
277: OR NOT l_api_updating
278: )
279: THEN

Line 276: NVL (per_suc_shd.g_old_rec.position_id, hr_api.g_number)

272:
273: --
274: IF ( l_api_updating
275: AND NVL (p_position_id, hr_api.g_number) <>
276: NVL (per_suc_shd.g_old_rec.position_id, hr_api.g_number)
277: OR NOT l_api_updating
278: )
279: THEN
280: --

Line 392: AND NVL (p_job_id, hr_api.g_number) <>

388: );
389:
390: --
391: IF ( l_api_updating
392: AND NVL (p_job_id, hr_api.g_number) <>
393: NVL (per_suc_shd.g_old_rec.job_id, hr_api.g_number)
394: OR NOT l_api_updating
395: )
396: THEN

Line 393: NVL (per_suc_shd.g_old_rec.job_id, hr_api.g_number)

389:
390: --
391: IF ( l_api_updating
392: AND NVL (p_job_id, hr_api.g_number) <>
393: NVL (per_suc_shd.g_old_rec.job_id, hr_api.g_number)
394: OR NOT l_api_updating
395: )
396: THEN
397: --

Line 509: AND NVL (p_successee_person_id, hr_api.g_number) <>

505: );
506:
507: --
508: IF ( l_api_updating
509: AND NVL (p_successee_person_id, hr_api.g_number) <>
510: NVL (per_suc_shd.g_old_rec.successee_person_id, hr_api.g_number)
511: )
512: THEN
513: --

Line 510: NVL (per_suc_shd.g_old_rec.successee_person_id, hr_api.g_number)

506:
507: --
508: IF ( l_api_updating
509: AND NVL (p_successee_person_id, hr_api.g_number) <>
510: NVL (per_suc_shd.g_old_rec.successee_person_id, hr_api.g_number)
511: )
512: THEN
513: --
514: -- raise error as the person can not be updated.

Line 633: AND p_start_date BETWEEN NVL (per.start_date, hr_api.g_eot)

629: AND per.successee_person_id = p_successee_person_id
630: )
631: )
632: AND per.person_rank = p_person_rank
633: AND p_start_date BETWEEN NVL (per.start_date, hr_api.g_eot)
634: AND NVL (per.end_date, hr_api.g_eot);
635:
636: -- cursor to check duplication of successors for the same successee
637: CURSOR c2

Line 634: AND NVL (per.end_date, hr_api.g_eot);

630: )
631: )
632: AND per.person_rank = p_person_rank
633: AND p_start_date BETWEEN NVL (per.start_date, hr_api.g_eot)
634: AND NVL (per.end_date, hr_api.g_eot);
635:
636: -- cursor to check duplication of successors for the same successee
637: CURSOR c2
638: IS

Line 649: AND p_start_date BETWEEN NVL (per.start_date, hr_api.g_eot)

645: AND per.successee_person_id = p_successee_person_id
646: )
647: )
648: AND per.person_id = p_person_id
649: AND p_start_date BETWEEN NVL (per.start_date, hr_api.g_eot)
650: AND NVL (per.end_date, hr_api.g_eot);
651: BEGIN
652: --
653: hr_utility.set_location ('Entering:' || l_proc, 5);

Line 650: AND NVL (per.end_date, hr_api.g_eot);

646: )
647: )
648: AND per.person_id = p_person_id
649: AND p_start_date BETWEEN NVL (per.start_date, hr_api.g_eot)
650: AND NVL (per.end_date, hr_api.g_eot);
651: BEGIN
652: --
653: hr_utility.set_location ('Entering:' || l_proc, 5);
654: --

Line 662: AND NVL (p_person_id, hr_api.g_number) <>

658: );
659:
660: --
661: IF ( l_api_updating
662: AND NVL (p_person_id, hr_api.g_number) <>
663: NVL (per_suc_shd.g_old_rec.person_id, hr_api.g_number)
664: OR NOT l_api_updating
665: )
666: THEN

Line 663: NVL (per_suc_shd.g_old_rec.person_id, hr_api.g_number)

659:
660: --
661: IF ( l_api_updating
662: AND NVL (p_person_id, hr_api.g_number) <>
663: NVL (per_suc_shd.g_old_rec.person_id, hr_api.g_number)
664: OR NOT l_api_updating
665: )
666: THEN
667: --

Line 800: AND NVL (p_time_scale, hr_api.g_varchar2) <>

796: );
797:
798: --
799: IF ( l_api_updating
800: AND NVL (p_time_scale, hr_api.g_varchar2) <>
801: NVL (per_suc_shd.g_old_rec.time_scale, hr_api.g_varchar2)
802: OR NOT l_api_updating
803: )
804: THEN

Line 801: NVL (per_suc_shd.g_old_rec.time_scale, hr_api.g_varchar2)

797:
798: --
799: IF ( l_api_updating
800: AND NVL (p_time_scale, hr_api.g_varchar2) <>
801: NVL (per_suc_shd.g_old_rec.time_scale, hr_api.g_varchar2)
802: OR NOT l_api_updating
803: )
804: THEN
805: --

Line 809: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'READINESS_LEVEL',

805: --
806: --
807: -- check if value of time scale lookup falls within lookup.
808: -- LOV name changed for bug 8478347
809: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'READINESS_LEVEL',
810: p_lookup_code => p_time_scale,
811: p_effective_date => p_effective_date
812: )
813: AND hr_api.not_exists_in_hr_lookups (p_lookup_type => 'PER_TIME_SCALES',

Line 813: AND hr_api.not_exists_in_hr_lookups (p_lookup_type => 'PER_TIME_SCALES',

809: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'READINESS_LEVEL',
810: p_lookup_code => p_time_scale,
811: p_effective_date => p_effective_date
812: )
813: AND hr_api.not_exists_in_hr_lookups (p_lookup_type => 'PER_TIME_SCALES',
814: p_lookup_code => p_time_scale,
815: p_effective_date => p_effective_date
816: )
817: THEN

Line 877: AND NVL (p_start_date, hr_api.g_date) <>

873: );
874:
875: --
876: IF ( l_api_updating
877: AND NVL (p_start_date, hr_api.g_date) <>
878: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
879: OR NOT l_api_updating
880: )
881: THEN

Line 878: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)

874:
875: --
876: IF ( l_api_updating
877: AND NVL (p_start_date, hr_api.g_date) <>
878: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
879: OR NOT l_api_updating
880: )
881: THEN
882: --

Line 949: AND ( NVL (p_start_date, hr_api.g_date) <>

945: );
946:
947: --
948: IF ( l_api_updating
949: AND ( NVL (p_start_date, hr_api.g_date) <>
950: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
951: OR NVL (p_end_date, hr_api.g_date) <>
952: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
953: )

Line 950: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)

946:
947: --
948: IF ( l_api_updating
949: AND ( NVL (p_start_date, hr_api.g_date) <>
950: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
951: OR NVL (p_end_date, hr_api.g_date) <>
952: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
953: )
954: OR NOT l_api_updating

Line 951: OR NVL (p_end_date, hr_api.g_date) <>

947: --
948: IF ( l_api_updating
949: AND ( NVL (p_start_date, hr_api.g_date) <>
950: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
951: OR NVL (p_end_date, hr_api.g_date) <>
952: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
953: )
954: OR NOT l_api_updating
955: )

Line 952: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)

948: IF ( l_api_updating
949: AND ( NVL (p_start_date, hr_api.g_date) <>
950: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
951: OR NVL (p_end_date, hr_api.g_date) <>
952: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
953: )
954: OR NOT l_api_updating
955: )
956: THEN

Line 960: IF p_start_date > NVL (p_end_date, hr_api.g_eot)

956: THEN
957: --
958: -- check if end date is greater than start date
959: --
960: IF p_start_date > NVL (p_end_date, hr_api.g_eot)
961: THEN
962: --
963: -- raise error as start date should be less than or equal to end date.
964: --

Line 1026: AND NVL (p_available_for_promotion, hr_api.g_varchar2) <>

1022: );
1023:
1024: --
1025: IF ( l_api_updating
1026: AND NVL (p_available_for_promotion, hr_api.g_varchar2) <>
1027: per_suc_shd.g_old_rec.available_for_promotion
1028: OR NOT l_api_updating
1029: )
1030: THEN

Line 1038: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'YES_NO',

1034: --
1035: IF p_available_for_promotion IS NOT NULL
1036: THEN
1037: --
1038: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'YES_NO',
1039: p_lookup_code => p_available_for_promotion,
1040: p_effective_date => p_effective_date
1041: )
1042: THEN

Line 1108: AND NVL (p_plan_status, hr_api.g_varchar2) <> per_suc_shd.g_old_rec.plan_status

1104: );
1105:
1106: --
1107: IF ( l_api_updating
1108: AND NVL (p_plan_status, hr_api.g_varchar2) <> per_suc_shd.g_old_rec.plan_status
1109: OR NOT l_api_updating
1110: )
1111: THEN
1112: --

Line 1119: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'SUCCESSION_PLAN_STATUS',

1115: --
1116: IF p_plan_status IS NOT NULL
1117: THEN
1118: --
1119: IF hr_api.not_exists_in_hr_lookups (p_lookup_type => 'SUCCESSION_PLAN_STATUS',
1120: p_lookup_code => p_plan_status,
1121: p_effective_date => p_effective_date
1122: )
1123: THEN

Line 1187: AND NVL (p_readiness_percentage, hr_api.g_number) <>

1183: );
1184:
1185: --
1186: IF ( l_api_updating
1187: AND NVL (p_readiness_percentage, hr_api.g_number) <>
1188: NVL (per_suc_shd.g_old_rec.readiness_percentage, hr_api.g_number)
1189: OR NOT l_api_updating
1190: )
1191: THEN

Line 1188: NVL (per_suc_shd.g_old_rec.readiness_percentage, hr_api.g_number)

1184:
1185: --
1186: IF ( l_api_updating
1187: AND NVL (p_readiness_percentage, hr_api.g_number) <>
1188: NVL (per_suc_shd.g_old_rec.readiness_percentage, hr_api.g_number)
1189: OR NOT l_api_updating
1190: )
1191: THEN
1192: --

Line 1333: AND ( per.start_date BETWEEN p_start_date AND NVL (p_end_date, hr_api.g_eot)

1329: OR ( p_successee_person_id IS NOT NULL
1330: AND per.successee_person_id = p_successee_person_id
1331: )
1332: )
1333: AND ( per.start_date BETWEEN p_start_date AND NVL (p_end_date, hr_api.g_eot)
1334: OR NVL (per.end_date, hr_api.g_eot) BETWEEN p_start_date
1335: AND NVL (p_end_date, hr_api.g_eot)
1336: );
1337: --

Line 1334: OR NVL (per.end_date, hr_api.g_eot) BETWEEN p_start_date

1330: AND per.successee_person_id = p_successee_person_id
1331: )
1332: )
1333: AND ( per.start_date BETWEEN p_start_date AND NVL (p_end_date, hr_api.g_eot)
1334: OR NVL (per.end_date, hr_api.g_eot) BETWEEN p_start_date
1335: AND NVL (p_end_date, hr_api.g_eot)
1336: );
1337: --
1338: BEGIN

Line 1335: AND NVL (p_end_date, hr_api.g_eot)

1331: )
1332: )
1333: AND ( per.start_date BETWEEN p_start_date AND NVL (p_end_date, hr_api.g_eot)
1334: OR NVL (per.end_date, hr_api.g_eot) BETWEEN p_start_date
1335: AND NVL (p_end_date, hr_api.g_eot)
1336: );
1337: --
1338: BEGIN
1339: --

Line 1349: AND ( NVL (p_start_date, hr_api.g_date) <>

1345: );
1346:
1347: --
1348: IF ( l_api_updating
1349: AND ( NVL (p_start_date, hr_api.g_date) <>
1350: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
1351: OR NVL (p_end_date, hr_api.g_date) <>
1352: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
1353: )

Line 1350: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)

1346:
1347: --
1348: IF ( l_api_updating
1349: AND ( NVL (p_start_date, hr_api.g_date) <>
1350: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
1351: OR NVL (p_end_date, hr_api.g_date) <>
1352: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
1353: )
1354: OR NOT l_api_updating

Line 1351: OR NVL (p_end_date, hr_api.g_date) <>

1347: --
1348: IF ( l_api_updating
1349: AND ( NVL (p_start_date, hr_api.g_date) <>
1350: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
1351: OR NVL (p_end_date, hr_api.g_date) <>
1352: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
1353: )
1354: OR NOT l_api_updating
1355: )

Line 1352: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)

1348: IF ( l_api_updating
1349: AND ( NVL (p_start_date, hr_api.g_date) <>
1350: NVL (per_suc_shd.g_old_rec.start_date, hr_api.g_date)
1351: OR NVL (p_end_date, hr_api.g_date) <>
1352: NVL (per_suc_shd.g_old_rec.end_date, hr_api.g_date)
1353: )
1354: OR NOT l_api_updating
1355: )
1356: THEN

Line 1430: AND ( NVL (per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1426: hr_utility.set_location ('Entering:' || l_proc, 10);
1427:
1428: --
1429: IF ( (p_rec.succession_plan_id IS NOT NULL)
1430: AND ( NVL (per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)
1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)

1427:
1428: --
1429: IF ( (p_rec.succession_plan_id IS NOT NULL)
1430: AND ( NVL (per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)
1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)

Line 1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1428: --
1429: IF ( (p_rec.succession_plan_id IS NOT NULL)
1430: AND ( NVL (per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)
1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1433: NVL (p_rec.attribute1, hr_api.g_varchar2)

1429: IF ( (p_rec.succession_plan_id IS NOT NULL)
1430: AND ( NVL (per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)
1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)

Line 1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1430: AND ( NVL (per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)
1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1435: NVL (p_rec.attribute2, hr_api.g_varchar2)

1431: NVL (p_rec.attribute_category, hr_api.g_varchar2)
1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)

Line 1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1432: OR NVL (per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1437: NVL (p_rec.attribute3, hr_api.g_varchar2)

1433: NVL (p_rec.attribute1, hr_api.g_varchar2)
1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)

Line 1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1434: OR NVL (per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1439: NVL (p_rec.attribute4, hr_api.g_varchar2)

1435: NVL (p_rec.attribute2, hr_api.g_varchar2)
1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)

Line 1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1436: OR NVL (per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1441: NVL (p_rec.attribute5, hr_api.g_varchar2)

1437: NVL (p_rec.attribute3, hr_api.g_varchar2)
1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)

Line 1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1438: OR NVL (per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1443: NVL (p_rec.attribute6, hr_api.g_varchar2)

1439: NVL (p_rec.attribute4, hr_api.g_varchar2)
1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)

Line 1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1440: OR NVL (per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1445: NVL (p_rec.attribute7, hr_api.g_varchar2)

1441: NVL (p_rec.attribute5, hr_api.g_varchar2)
1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)

Line 1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1442: OR NVL (per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1447: NVL (p_rec.attribute8, hr_api.g_varchar2)

1443: NVL (p_rec.attribute6, hr_api.g_varchar2)
1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)

Line 1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1444: OR NVL (per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1449: NVL (p_rec.attribute9, hr_api.g_varchar2)

1445: NVL (p_rec.attribute7, hr_api.g_varchar2)
1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)

Line 1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1446: OR NVL (per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1451: NVL (p_rec.attribute10, hr_api.g_varchar2)

1447: NVL (p_rec.attribute8, hr_api.g_varchar2)
1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)

Line 1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1448: OR NVL (per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1453: NVL (p_rec.attribute11, hr_api.g_varchar2)

1449: NVL (p_rec.attribute9, hr_api.g_varchar2)
1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)

Line 1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1450: OR NVL (per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1455: NVL (p_rec.attribute12, hr_api.g_varchar2)

1451: NVL (p_rec.attribute10, hr_api.g_varchar2)
1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)

Line 1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1452: OR NVL (per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1457: NVL (p_rec.attribute13, hr_api.g_varchar2)

1453: NVL (p_rec.attribute11, hr_api.g_varchar2)
1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)

Line 1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1454: OR NVL (per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1459: NVL (p_rec.attribute14, hr_api.g_varchar2)

1455: NVL (p_rec.attribute12, hr_api.g_varchar2)
1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)

Line 1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1456: OR NVL (per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1461: NVL (p_rec.attribute15, hr_api.g_varchar2)

1457: NVL (p_rec.attribute13, hr_api.g_varchar2)
1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)

Line 1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1458: OR NVL (per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1463: NVL (p_rec.attribute16, hr_api.g_varchar2)

1459: NVL (p_rec.attribute14, hr_api.g_varchar2)
1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)

Line 1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1460: OR NVL (per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1465: NVL (p_rec.attribute17, hr_api.g_varchar2)

1461: NVL (p_rec.attribute15, hr_api.g_varchar2)
1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)

Line 1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1462: OR NVL (per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)
1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1467: NVL (p_rec.attribute18, hr_api.g_varchar2)

1463: NVL (p_rec.attribute16, hr_api.g_varchar2)
1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)
1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1471: NVL (p_rec.attribute20, hr_api.g_varchar2)

Line 1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1464: OR NVL (per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)
1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1471: NVL (p_rec.attribute20, hr_api.g_varchar2)
1472: )

Line 1469: NVL (p_rec.attribute19, hr_api.g_varchar2)

1465: NVL (p_rec.attribute17, hr_api.g_varchar2)
1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)
1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1471: NVL (p_rec.attribute20, hr_api.g_varchar2)
1472: )
1473: )

Line 1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1466: OR NVL (per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)
1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1471: NVL (p_rec.attribute20, hr_api.g_varchar2)
1472: )
1473: )
1474: OR (p_rec.succession_plan_id IS NULL)

Line 1471: NVL (p_rec.attribute20, hr_api.g_varchar2)

1467: NVL (p_rec.attribute18, hr_api.g_varchar2)
1468: OR NVL (per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1469: NVL (p_rec.attribute19, hr_api.g_varchar2)
1470: OR NVL (per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1471: NVL (p_rec.attribute20, hr_api.g_varchar2)
1472: )
1473: )
1474: OR (p_rec.succession_plan_id IS NULL)
1475: THEN

Line 1545: hr_api.validate_bus_grp_id (p_rec.business_group_id); -- Validate Bus Grp

1541: --
1542: BEGIN
1543: hr_utility.set_location ('Entering:' || l_proc, 5);
1544: --
1545: hr_api.validate_bus_grp_id (p_rec.business_group_id); -- Validate Bus Grp
1546: --
1547: -- Call all supporting business operations
1548: --
1549: -- Business Rule Mapping

Line 1686: hr_api.validate_bus_grp_id (p_rec.business_group_id); -- Validate Bus Grp

1682: --
1683: BEGIN
1684: hr_utility.set_location ('Entering:' || l_proc, 5);
1685: --
1686: hr_api.validate_bus_grp_id (p_rec.business_group_id); -- Validate Bus Grp
1687: --
1688: -- Call all supporting business operations
1689: --
1690: -- Business Rule Mapping