APPS.PER_APT_BUS dependencies on PER_APT_SHD

Line 19: Procedure chk_non_updateable_args(p_rec in per_apt_shd.g_rec_type) is

15: -- -------------------------------------------------------------------------+
16: -- |----------------------< chk_non_updateable_args >-----------------------|
17: -- -------------------------------------------------------------------------+
18:
19: Procedure chk_non_updateable_args(p_rec in per_apt_shd.g_rec_type) is
20:
21: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
22: l_error exception;
23: l_argument varchar2(30);

Line 31: if not per_apt_shd.api_updating

27:
28: -- Only proceed with validation if a row exists for
29: -- the current record in the HR Schema
30:
31: if not per_apt_shd.api_updating
32: (p_appraisal_template_id => p_rec.appraisal_template_id
33: ,p_object_version_number => p_rec.object_version_number
34: ) then
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 42: if p_rec.business_group_id <> per_apt_shd.g_old_rec.business_group_id then

38: end if;
39:
40: hr_utility.set_location(l_proc, 6);
41:
42: if p_rec.business_group_id <> per_apt_shd.g_old_rec.business_group_id then
43: l_argument := 'business_group_id';
44: raise l_error;
45: end if;
46: hr_utility.set_location(l_proc, 11);

Line 124: l_api_updating := per_apt_shd.api_updating

120: -- Only proceed with validation if :
121: -- a) The current g_old_rec is current and
122: -- b) The value for name has changed
123:
124: l_api_updating := per_apt_shd.api_updating
125: (p_appraisal_template_id => p_appraisal_template_id
126: ,p_object_version_number => p_object_version_number);
127:
128: if ( (l_api_updating and (per_apt_shd.g_old_rec.name

Line 128: if ( (l_api_updating and (per_apt_shd.g_old_rec.name

124: l_api_updating := per_apt_shd.api_updating
125: (p_appraisal_template_id => p_appraisal_template_id
126: ,p_object_version_number => p_object_version_number);
127:
128: if ( (l_api_updating and (per_apt_shd.g_old_rec.name
129: <> nvl(p_name,hr_api.g_varchar2))
130: ) or
131: (NOT l_api_updating)
132: ) then

Line 242: l_api_updating := per_apt_shd.api_updating

238: hr_utility.set_message(801, 'HR_51910_APT_DATE_TO_AFTER');
239: hr_utility.raise_error;
240: end if;
241:
242: l_api_updating := per_apt_shd.api_updating
243: (p_appraisal_template_id => p_appraisal_template_id
244: ,p_object_version_number => p_object_version_number);
245:
246: -- Only continue if:

Line 250: if ( ((l_api_updating) and (per_apt_shd.g_old_rec.date_from <> nvl(p_date_from,hr_api.g_date)) )

246: -- Only continue if:
247: -- a) The current g_old_rec is current and
248: -- b) The value for dates have changed
249:
250: if ( ((l_api_updating) and (per_apt_shd.g_old_rec.date_from <> nvl(p_date_from,hr_api.g_date)) )
251: or ((l_api_updating) and (per_apt_shd.g_old_rec.date_to <> nvl(p_date_to,hr_api.g_date)) )
252: ) then
253:
254: -- only continue if we are updating and the dates have changed from the

Line 251: or ((l_api_updating) and (per_apt_shd.g_old_rec.date_to <> nvl(p_date_to,hr_api.g_date)) )

247: -- a) The current g_old_rec is current and
248: -- b) The value for dates have changed
249:
250: if ( ((l_api_updating) and (per_apt_shd.g_old_rec.date_from <> nvl(p_date_from,hr_api.g_date)) )
251: or ((l_api_updating) and (per_apt_shd.g_old_rec.date_to <> nvl(p_date_to,hr_api.g_date)) )
252: ) then
253:
254: -- only continue if we are updating and the dates have changed from the
255: -- previous values

Line 359: l_api_updating := per_apt_shd.api_updating

355:
356:
357: hr_utility.set_location('Entering:'|| l_proc, 2);
358:
359: l_api_updating := per_apt_shd.api_updating
360: (p_appraisal_template_id => p_appraisal_template_id
361: ,p_object_version_number => p_object_version_number);
362:
363: -- Only continue if:

Line 368: and (nvl(per_apt_shd.g_old_rec.assessment_type_id,hr_api.g_number)

364: -- a) The current g_old_rec is current and
365: -- b) The value for assessment type has changed
366:
367: if ( (l_api_updating
368: and (nvl(per_apt_shd.g_old_rec.assessment_type_id,hr_api.g_number)
369: <> nvl(p_assessment_type_id,hr_api.g_number))
370: ) or
371: (NOT l_api_updating)
372: ) then

Line 489: l_api_updating := per_apt_shd.api_updating

485: hr_utility.set_location('Entering:'|| l_proc, 1);
486:
487:
488:
489: l_api_updating := per_apt_shd.api_updating
490: (p_appraisal_template_id => p_appraisal_template_id
491: ,p_object_version_number => p_object_version_number);
492:
493: -- Only continue if:

Line 498: and (nvl(per_apt_shd.g_old_rec.objective_asmnt_type_id,hr_api.g_number)

494: -- a) The current g_old_rec is current and
495: -- b) The value for assessment type has changed
496:
497: if ( (l_api_updating
498: and (nvl(per_apt_shd.g_old_rec.objective_asmnt_type_id,hr_api.g_number)
499: <> nvl(p_objective_asmnt_type_id,hr_api.g_number))
500: ) or
501: (NOT l_api_updating)
502: ) then

Line 634: l_api_updating := per_apt_shd.api_updating

630:
631: begin
632: hr_utility.set_location('Entering:'|| l_proc, 1);
633:
634: l_api_updating := per_apt_shd.api_updating
635: (p_appraisal_template_id => p_appraisal_template_id
636: ,p_object_version_number => p_object_version_number);
637:
638: -- Perfom the following check when inserting only

Line 675: -- Added nvl around per_apt_shd.g_old_rec.questionnaire_template_id

671:
672: -- Perform the following check only if updating and the value of
673: -- questionnaire_template_id has changed
674:
675: -- Added nvl around per_apt_shd.g_old_rec.questionnaire_template_id
676: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.questionnaire_template_id, hr_api.g_number)
677: <> nvl(p_questionnaire_template_id,hr_api.g_number)) )
678: )
679: then

Line 676: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.questionnaire_template_id, hr_api.g_number)

672: -- Perform the following check only if updating and the value of
673: -- questionnaire_template_id has changed
674:
675: -- Added nvl around per_apt_shd.g_old_rec.questionnaire_template_id
676: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.questionnaire_template_id, hr_api.g_number)
677: <> nvl(p_questionnaire_template_id,hr_api.g_number)) )
678: )
679: then
680:

Line 823: l_api_updating := per_apt_shd.api_updating

819:
820: begin
821: hr_utility.set_location('Entering:'|| l_proc, 1);
822:
823: l_api_updating := per_apt_shd.api_updating
824: (p_appraisal_template_id => p_appraisal_template_id
825: ,p_object_version_number => p_object_version_number);
826:
827: -- Perfom the following check when inserting only

Line 859: -- Added nvl around per_apt_shd.g_old_rec.ma_quest_template_id

855:
856: -- Perform the following check only if updating and the value of
857: -- ma_quest_template_id has changed
858:
859: -- Added nvl around per_apt_shd.g_old_rec.ma_quest_template_id
860: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.ma_quest_template_id, hr_api.g_number)
861: <> nvl(p_ma_quest_template_id,hr_api.g_number)) )
862: )
863: then

Line 860: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.ma_quest_template_id, hr_api.g_number)

856: -- Perform the following check only if updating and the value of
857: -- ma_quest_template_id has changed
858:
859: -- Added nvl around per_apt_shd.g_old_rec.ma_quest_template_id
860: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.ma_quest_template_id, hr_api.g_number)
861: <> nvl(p_ma_quest_template_id,hr_api.g_number)) )
862: )
863: then
864:

Line 1015: l_api_updating := per_apt_shd.api_updating

1011: -- ngundura end of changes
1012:
1013: hr_utility.set_location('Entering:'|| l_proc, 2);
1014:
1015: l_api_updating := per_apt_shd.api_updating
1016: (p_appraisal_template_id => p_appraisal_template_id
1017: ,p_object_version_number => p_object_version_number);
1018:
1019: -- Only continue if:

Line 1058: if ( (l_api_updating and (per_apt_shd.g_old_rec.rating_scale_id

1054:
1055: -- Perform the below checks only if updating and the value of the
1056: -- rating_scale_id has changed
1057:
1058: if ( (l_api_updating and (per_apt_shd.g_old_rec.rating_scale_id
1059: <> nvl(p_rating_scale_id,hr_api.g_number)) )
1060: )
1061: then
1062:

Line 1273: l_api_updating := per_apt_shd.api_updating

1269: -- b) The value has changed.
1270: -- c) A record is being inserted
1271: --
1272:
1273: l_api_updating := per_apt_shd.api_updating
1274: (p_appraisal_template_id => p_appraisal_template_id
1275: ,p_object_version_number => p_object_version_number);
1276: --
1277: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.update_personal_comp_profile,

Line 1277: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.update_personal_comp_profile,

1273: l_api_updating := per_apt_shd.api_updating
1274: (p_appraisal_template_id => p_appraisal_template_id
1275: ,p_object_version_number => p_object_version_number);
1276: --
1277: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.update_personal_comp_profile,
1278: hr_api.g_varchar2)
1279: <> nvl(p_update_personal_comp_profile, hr_api.g_varchar2))
1280: or
1281: (NOT l_api_updating)) then

Line 1377: l_api_updating := per_apt_shd.api_updating

1373: -- b) The value has changed.
1374: -- c) A record is being inserted
1375: --
1376:
1377: l_api_updating := per_apt_shd.api_updating
1378: (p_appraisal_template_id => p_appraisal_template_id
1379: ,p_object_version_number => p_object_version_number);
1380: --
1381: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.comp_profile_source_type,

Line 1381: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.comp_profile_source_type,

1377: l_api_updating := per_apt_shd.api_updating
1378: (p_appraisal_template_id => p_appraisal_template_id
1379: ,p_object_version_number => p_object_version_number);
1380: --
1381: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.comp_profile_source_type,
1382: hr_api.g_varchar2)
1383: <> nvl(p_comp_profile_source_type, hr_api.g_varchar2))
1384: or
1385: (NOT l_api_updating)) then

Line 1472: l_api_updating := per_apt_shd.api_updating

1468: -- b) The value has changed.
1469: -- c) A record is being inserted
1470: --
1471:
1472: l_api_updating := per_apt_shd.api_updating
1473: (p_appraisal_template_id => p_appraisal_template_id
1474: ,p_object_version_number => p_object_version_number);
1475: --
1476: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.link_appr_to_learning_path,

Line 1476: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.link_appr_to_learning_path,

1472: l_api_updating := per_apt_shd.api_updating
1473: (p_appraisal_template_id => p_appraisal_template_id
1474: ,p_object_version_number => p_object_version_number);
1475: --
1476: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.link_appr_to_learning_path,
1477: hr_api.g_varchar2)
1478: <> nvl(p_link_appr_to_learning_path, hr_api.g_varchar2))
1479: or
1480: (NOT l_api_updating)) then

Line 1567: l_api_updating := per_apt_shd.api_updating

1563: -- b) The value has changed.
1564: -- c) A record is being inserted
1565: --
1566:
1567: l_api_updating := per_apt_shd.api_updating
1568: (p_appraisal_template_id => p_appraisal_template_id
1569: ,p_object_version_number => p_object_version_number);
1570: --
1571: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.available_flag,

Line 1571: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.available_flag,

1567: l_api_updating := per_apt_shd.api_updating
1568: (p_appraisal_template_id => p_appraisal_template_id
1569: ,p_object_version_number => p_object_version_number);
1570: --
1571: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.available_flag,
1572: hr_api.g_varchar2)
1573: <> nvl(p_available_flag, hr_api.g_varchar2))
1574: or
1575: (NOT l_api_updating)) then

Line 1622: (p_rec in per_apt_shd.g_rec_type) is

1618: -- Access Status:
1619: -- Internal Row Handler Use Only.
1620:
1621: procedure chk_df
1622: (p_rec in per_apt_shd.g_rec_type) is
1623:
1624: l_proc varchar2(72) := g_package||'chk_df';
1625:
1626: begin

Line 1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1626: begin
1627: hr_utility.set_location('Entering:'||l_proc, 10);
1628:
1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1628:
1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1672: or

Line 1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1672: or
1673: (p_rec.appraisal_template_id is null) then
1674:

Line 1734: Procedure insert_validate(p_rec in per_apt_shd.g_rec_type

1730:
1731: -- ---------------------------------------------------------------------------+
1732: -- |---------------------------< insert_validate >----------------------------|
1733: -- ---------------------------------------------------------------------------+
1734: Procedure insert_validate(p_rec in per_apt_shd.g_rec_type
1735: ,p_effective_date in date) is
1736:
1737: l_proc varchar2(72) := g_package||'insert_validate';
1738:

Line 1870: Procedure update_validate(p_rec in per_apt_shd.g_rec_type

1866:
1867: -- ---------------------------------------------------------------------------+
1868: -- |---------------------------< update_validate >----------------------------|
1869: -- ---------------------------------------------------------------------------+
1870: Procedure update_validate(p_rec in per_apt_shd.g_rec_type
1871: ,p_effective_date in date) is
1872:
1873: l_proc varchar2(72) := g_package||'update_validate';
1874:

Line 2012: Procedure delete_validate(p_rec in per_apt_shd.g_rec_type) is

2008:
2009: -- ---------------------------------------------------------------------------+
2010: -- |---------------------------< delete_validate >----------------------------|
2011: -- ---------------------------------------------------------------------------+
2012: Procedure delete_validate(p_rec in per_apt_shd.g_rec_type) is
2013:
2014: l_proc varchar2(72) := g_package||'delete_validate';
2015:
2016: Begin