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 PER_SUC_SHD

Line 52: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

48: --
49: hr_utility.set_location ('Entering:' || l_proc, 5);
50: --
51: l_api_updating :=
52: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
53: p_object_version_number => p_object_version_number
54: );
55:
56: --

Line 59: per_suc_shd.g_old_rec.succession_plan_id

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: --
63: -- raise error as PK has changed

Line 65: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_PK');

61: THEN
62: --
63: -- raise error as PK has changed
64: --
65: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_PK');
66: --
67: ELSIF NOT l_api_updating
68: THEN
69: --

Line 77: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_PK');

73: THEN
74: --
75: -- raise error as PK is not null
76: --
77: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_PK');
78: --
79: END IF;
80: --
81: END IF;

Line 146: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

142: --
143: hr_utility.set_location ('Entering:' || l_proc, 5);
144: --
145: l_api_updating :=
146: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
147: p_object_version_number => p_object_version_number
148: );
149:
150: --

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 269: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

265: --
266: hr_utility.set_location ('Entering:' || l_proc, 5);
267: --
268: l_api_updating :=
269: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
270: p_object_version_number => p_object_version_number
271: );
272:
273: --

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 320: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_FK1');

316:
317: --
318: -- raise error as position does not exist as of effective date.
319: --
320: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_FK1');
321: --
322: END IF;
323:
324: --

Line 386: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

382: --
383: hr_utility.set_location ('Entering:' || l_proc, 5);
384: --
385: l_api_updating :=
386: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
387: p_object_version_number => p_object_version_number
388: );
389:
390: --

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 437: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_FK2');

433:
434: --
435: -- raise error as job does not exist as of effective date.
436: --
437: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_FK2');
438: --
439: END IF;
440:
441: --

Line 503: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

499: --
500: hr_utility.set_location ('Entering:' || l_proc, 5);
501: --
502: l_api_updating :=
503: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
504: p_object_version_number => p_object_version_number
505: );
506:
507: --

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 562: per_suc_shd.constraint_error ('HR_50495_SUC_CHK_SUC_MISSING');

558: THEN
559: --
560: -- raise error as JOB OR POSITION OR SUCCESSEE PERSON ID IS MANDATORY
561: --
562: per_suc_shd.constraint_error ('HR_50495_SUC_CHK_SUC_MISSING');
563: ELSIF (l_notnulls > 1)
564: THEN
565: --
566: -- raise error as MORE THAN ONE SUCCESSEE ID IS ENTERED

Line 568: per_suc_shd.constraint_error ('HR_50496_SUC_CHK_SUC_EXIST');

564: THEN
565: --
566: -- raise error as MORE THAN ONE SUCCESSEE ID IS ENTERED
567: --
568: per_suc_shd.constraint_error ('HR_50496_SUC_CHK_SUC_EXIST');
569: END IF;
570:
571: --
572: hr_utility.set_location (' Leaving:' || l_proc, 10);

Line 656: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

652: --
653: hr_utility.set_location ('Entering:' || l_proc, 5);
654: --
655: l_api_updating :=
656: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
657: p_object_version_number => p_object_version_number
658: );
659:
660: --

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 794: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

790: hr_utility.set_location ('p_effective_date:' || p_effective_date, 5);
791: hr_utility.set_location ('p_time_scale:' || p_time_scale, 5);
792: --
793: l_api_updating :=
794: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
795: p_object_version_number => p_object_version_number
796: );
797:
798: --

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 871: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

867: --
868: hr_utility.set_location ('Entering:' || l_proc, 5);
869: --
870: l_api_updating :=
871: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
872: p_object_version_number => p_object_version_number
873: );
874:
875: --

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 943: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

939: --
940: hr_utility.set_location ('Entering:' || l_proc, 5);
941: --
942: l_api_updating :=
943: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
944: p_object_version_number => p_object_version_number
945: );
946:
947: --

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 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 1020: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

1016: --
1017: hr_utility.set_location ('Entering:' || l_proc, 5);
1018: --
1019: l_api_updating :=
1020: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
1021: p_object_version_number => p_object_version_number
1022: );
1023:
1024: --

Line 1027: per_suc_shd.g_old_rec.available_for_promotion

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
1031: --

Line 1046: per_suc_shd.constraint_error ('PER_SUC_AVAIL_FOR_PROMOTION');

1042: THEN
1043: --
1044: -- raise error as does not exist as lookup
1045: --
1046: per_suc_shd.constraint_error ('PER_SUC_AVAIL_FOR_PROMOTION');
1047: --
1048: END IF;
1049: --
1050: END IF;

Line 1102: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

1098: --
1099: hr_utility.set_location ('Entering:' || l_proc, 5);
1100: --
1101: l_api_updating :=
1102: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
1103: p_object_version_number => p_object_version_number
1104: );
1105:
1106: --

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 1181: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

1177: --
1178: hr_utility.set_location ('Entering:' || l_proc, 5);
1179: --
1180: l_api_updating :=
1181: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
1182: p_object_version_number => p_object_version_number
1183: );
1184:
1185: --

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 1343: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,

1339: --
1340: hr_utility.set_location ('Entering:' || l_proc, 5);
1341: --
1342: l_api_updating :=
1343: per_suc_shd.api_updating (p_succession_plan_id => p_succession_plan_id,
1344: p_object_version_number => p_object_version_number
1345: );
1346:
1347: --

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 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 1375: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_UK');

1371:
1372: --
1373: -- raise error as succession plan records overlap.
1374: --
1375: per_suc_shd.constraint_error ('PER_SUCCESSION_PLANNING_UK');
1376: --
1377: END IF;
1378:
1379: --

Line 1420: PROCEDURE chk_df (p_rec IN per_suc_shd.g_rec_type)

1416: --
1417: -- {End Of Comments}
1418: -- ----------------------------------------------------------------------------
1419: --
1420: PROCEDURE chk_df (p_rec IN per_suc_shd.g_rec_type)
1421: IS
1422: --
1423: l_proc VARCHAR2 (72) := g_package || 'chk_df';
1424: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1537: PROCEDURE insert_validate (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)

1533: --
1534: -- ----------------------------------------------------------------------------
1535: -- |---------------------------< insert_validate >----------------------------|
1536: -- ----------------------------------------------------------------------------
1537: PROCEDURE insert_validate (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)
1538: IS
1539: --
1540: l_proc VARCHAR2 (72) := g_package || 'insert_validate';
1541: --

Line 1678: PROCEDURE update_validate (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)

1674: --
1675: -- ----------------------------------------------------------------------------
1676: -- |---------------------------< update_validate >----------------------------|
1677: -- ----------------------------------------------------------------------------
1678: PROCEDURE update_validate (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)
1679: IS
1680: --
1681: l_proc VARCHAR2 (72) := g_package || 'update_validate';
1682: --

Line 1821: PROCEDURE delete_validate (p_rec IN per_suc_shd.g_rec_type)

1817: --
1818: -- ----------------------------------------------------------------------------
1819: -- |---------------------------< delete_validate >----------------------------|
1820: -- ----------------------------------------------------------------------------
1821: PROCEDURE delete_validate (p_rec IN per_suc_shd.g_rec_type)
1822: IS
1823: --
1824: l_proc VARCHAR2 (72) := g_package || 'delete_validate';
1825: --