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_CPN_BUS dependencies on PER_CPN_SHD

Line 20: Procedure chk_non_updateable_args(p_rec in per_cpn_shd.g_rec_type) is

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

Line 32: if not per_cpn_shd.api_updating

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

Line 43: if p_rec.business_group_id <> per_cpn_shd.g_old_rec.business_group_id then

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

Line 49: if per_cpn_shd.g_old_rec.competence_cluster = 'UNIT_STANDARD'

45: raise l_error;
46: end if;
47: hr_utility.set_location(l_proc, 7);
48:
49: if per_cpn_shd.g_old_rec.competence_cluster = 'UNIT_STANDARD'
50: and (p_rec.competence_cluster is NULL
51: or p_rec.competence_cluster <> 'UNIT_STANDARD') then
52: --
53: fnd_message.set_name('PER','HR_449146_QUA_FWK_CHG_CLUSTER');

Line 144: l_api_updating := per_cpn_shd.api_updating

140: -- Only proceed with validation if :
141: -- a) The current g_old_rec is current and
142: -- b) The value for name has changed
143: --
144: l_api_updating := per_cpn_shd.api_updating
145: (p_competence_id => p_competence_id
146: ,p_object_version_number => p_object_version_number);
147: --
148: if ( (l_api_updating and (per_cpn_shd.g_old_rec.competence_definition_id

Line 148: if ( (l_api_updating and (per_cpn_shd.g_old_rec.competence_definition_id

144: l_api_updating := per_cpn_shd.api_updating
145: (p_competence_id => p_competence_id
146: ,p_object_version_number => p_object_version_number);
147: --
148: if ( (l_api_updating and (per_cpn_shd.g_old_rec.competence_definition_id
149: <> nvl(p_competence_definition_id,hr_api.g_number))
150: ) or
151: (NOT l_api_updating)
152: ) then

Line 280: and ( p_date_from <> per_cpn_shd.g_old_rec.date_from

276: -- Check dates againts competence elements (only in Update mode)
277: --
278: if p_called_from = 'UPDATE'
279:
280: and ( p_date_from <> per_cpn_shd.g_old_rec.date_from
281: or nvl(p_date_to,hr_api.g_date)<>nvl(per_cpn_shd.g_old_rec.date_to,hr_api.g_date)
282: ) then
283:
284: open csr_check_dates_in_ele;

Line 281: or nvl(p_date_to,hr_api.g_date)<>nvl(per_cpn_shd.g_old_rec.date_to,hr_api.g_date)

277: --
278: if p_called_from = 'UPDATE'
279:
280: and ( p_date_from <> per_cpn_shd.g_old_rec.date_from
281: or nvl(p_date_to,hr_api.g_date)<>nvl(per_cpn_shd.g_old_rec.date_to,hr_api.g_date)
282: ) then
283:
284: open csr_check_dates_in_ele;
285: fetch csr_check_dates_in_ele into l_exists;

Line 358: l_api_updating := per_cpn_shd.api_updating

354: -- Only proceed with validation if :
355: -- a) The current g_old_rec is current and
356: -- b) The value for certification required flag has changed
357: --
358: l_api_updating := per_cpn_shd.api_updating
359: (p_competence_id => p_competence_id
360: ,p_object_version_number => p_object_version_number);
361: --
362: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.certification_required,

Line 362: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.certification_required,

358: l_api_updating := per_cpn_shd.api_updating
359: (p_competence_id => p_competence_id
360: ,p_object_version_number => p_object_version_number);
361: --
362: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.certification_required,
363: hr_api.g_varchar2)
364: <> nvl(p_certification_required,hr_api.g_varchar2)
365: ) or
366: (NOT l_api_updating)

Line 453: l_api_updating := per_cpn_shd.api_updating

449: -- Only proceed with validation if :
450: -- a) The current g_old_rec is current and
451: -- b) The value for evaluation method has changed
452: --
453: l_api_updating := per_cpn_shd.api_updating
454: (p_competence_id => p_competence_id
455: ,p_object_version_number => p_object_version_number);
456: --
457: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.evaluation_method,

Line 457: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.evaluation_method,

453: l_api_updating := per_cpn_shd.api_updating
454: (p_competence_id => p_competence_id
455: ,p_object_version_number => p_object_version_number);
456: --
457: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.evaluation_method,
458: hr_api.g_varchar2)
459: <> nvl(p_evaluation_method,hr_api.g_varchar2)
460: ) or
461: (NOT l_api_updating)

Line 560: l_api_updating := per_cpn_shd.api_updating

556: -- Only proceed with validation if :
557: -- a) The current g_old_rec is current and
558: -- b) The value for renewal period units has changed
559: --
560: l_api_updating := per_cpn_shd.api_updating
561: (p_competence_id => p_competence_id
562: ,p_object_version_number => p_object_version_number);
563: --
564: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.renewal_period_units,

Line 564: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.renewal_period_units,

560: l_api_updating := per_cpn_shd.api_updating
561: (p_competence_id => p_competence_id
562: ,p_object_version_number => p_object_version_number);
563: --
564: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.renewal_period_units,
565: hr_api.g_varchar2)
566: <> nvl(p_renewal_period_units,hr_api.g_varchar2)
567: ) or
568: (NOT l_api_updating)

Line 658: l_api_updating := per_cpn_shd.api_updating

654: -- a) The current g_old_rec is current and
655: -- b) The value for renewal period units or renewal period frquency has
656: -- changed
657: --
658: l_api_updating := per_cpn_shd.api_updating
659: (p_competence_id => p_competence_id
660: ,p_object_version_number => p_object_version_number);
661: --
662: if (l_api_updating

Line 664: ((nvl(per_cpn_shd.g_old_rec.renewal_period_units,

660: ,p_object_version_number => p_object_version_number);
661: --
662: if (l_api_updating
663: and
664: ((nvl(per_cpn_shd.g_old_rec.renewal_period_units,
665: hr_api.g_varchar2)
666: <> nvl(p_renewal_period_units,hr_api.g_varchar2))
667: or
668: (nvl(per_cpn_shd.g_old_rec.renewal_period_frequency,

Line 668: (nvl(per_cpn_shd.g_old_rec.renewal_period_frequency,

664: ((nvl(per_cpn_shd.g_old_rec.renewal_period_units,
665: hr_api.g_varchar2)
666: <> nvl(p_renewal_period_units,hr_api.g_varchar2))
667: or
668: (nvl(per_cpn_shd.g_old_rec.renewal_period_frequency,
669: hr_api.g_number)
670: <> nvl(p_renewal_period_frequency,hr_api.g_number))))
671: or
672: NOT l_api_updating then

Line 752: l_api_updating := per_cpn_shd.api_updating

748: -- Only proceed with validation if :
749: -- a) The current g_old_rec is current and
750: -- b) The value for rating scale has changed
751: --
752: l_api_updating := per_cpn_shd.api_updating
753: (p_competence_id => p_competence_id
754: ,p_object_version_number => p_object_version_number);
755: --
756: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

Line 756: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

752: l_api_updating := per_cpn_shd.api_updating
753: (p_competence_id => p_competence_id
754: ,p_object_version_number => p_object_version_number);
755: --
756: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
757: hr_api.g_number)
758: <> nvl(p_rating_scale_id,hr_api.g_number)
759: ) or
760: (NOT l_api_updating)

Line 853: l_api_updating := per_cpn_shd.api_updating

849: -- Only proceed with validation if :
850: -- a) The current g_old_rec is current and
851: -- b) The value for rating scale has changed
852: --
853: l_api_updating := per_cpn_shd.api_updating
854: (p_competence_id => p_competence_id
855: ,p_object_version_number => p_object_version_number);
856: --
857: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

Line 857: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

853: l_api_updating := per_cpn_shd.api_updating
854: (p_competence_id => p_competence_id
855: ,p_object_version_number => p_object_version_number);
856: --
857: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
858: hr_api.g_number)
859: <> nvl(p_rating_scale_id,hr_api.g_number)
860: ) or
861: (NOT l_api_updating)

Line 938: l_api_updating := per_cpn_shd.api_updating

934: -- Only proceed with validation if :
935: -- a) The current g_old_rec is current and
936: -- b) The value for rating scale has changed
937: --
938: l_api_updating := per_cpn_shd.api_updating
939: (p_competence_id => p_competence_id
940: ,p_object_version_number => p_object_version_number);
941: --
942: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

Line 942: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

938: l_api_updating := per_cpn_shd.api_updating
939: (p_competence_id => p_competence_id
940: ,p_object_version_number => p_object_version_number);
941: --
942: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
943: hr_api.g_number)
944: <> nvl(p_rating_scale_id,hr_api.g_number)
945: ) or
946: (NOT l_api_updating)

Line 1021: and rl.rating_scale_id = nvl(per_cpn_shd.g_old_rec.rating_scale_id,-9999)

1017: from per_rating_levels rl,
1018: per_competence_elements ce
1019: where ((rl.rating_level_id = ce.proficiency_level_id) or
1020: (rl.rating_level_id = ce.high_proficiency_level_id))
1021: and rl.rating_scale_id = nvl(per_cpn_shd.g_old_rec.rating_scale_id,-9999)
1022: and ce.competence_id = p_competence_id;
1023: --
1024: begin
1025: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1031: l_api_updating := per_cpn_shd.api_updating

1027: -- Only proceed with validation if :
1028: -- a) The current g_old_rec is current and
1029: -- b) The value for rating scale has changed
1030: --
1031: l_api_updating := per_cpn_shd.api_updating
1032: (p_competence_id => p_competence_id
1033: ,p_object_version_number => p_object_version_number);
1034: --
1035: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

Line 1035: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

1031: l_api_updating := per_cpn_shd.api_updating
1032: (p_competence_id => p_competence_id
1033: ,p_object_version_number => p_object_version_number);
1034: --
1035: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
1036: hr_api.g_number)
1037: <> nvl(p_rating_scale_id,hr_api.g_number)
1038: ) or
1039: (NOT l_api_updating)

Line 1274: l_api_updating := per_cpn_shd.api_updating

1270: -- Only proceed with validation if :
1271: -- a) The current g_old_rec is current and
1272: -- b) The value for cluster name has changed
1273: --
1274: l_api_updating := per_cpn_shd.api_updating
1275: (p_competence_id => p_competence_id
1276: ,p_object_version_number => p_object_version_number);
1277: --
1278: if (p_competence_cluster is not NULL) then

Line 1279: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.competence_cluster,

1275: (p_competence_id => p_competence_id
1276: ,p_object_version_number => p_object_version_number);
1277: --
1278: if (p_competence_cluster is not NULL) then
1279: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.competence_cluster,
1280: hr_api.g_varchar2)
1281: <> nvl(p_competence_cluster,hr_api.g_varchar2)
1282: ) or
1283: (NOT l_api_updating)

Line 1370: l_api_updating := per_cpn_shd.api_updating

1366: -- Only proceed with validation if :
1367: -- a) The current g_old_rec is current and
1368: -- b) The value for unit_standard_id has changed
1369: --
1370: l_api_updating := per_cpn_shd.api_updating
1371: (p_competence_id => p_competence_id
1372: ,p_object_version_number => p_object_version_number);
1373: --
1374: if (p_unit_standard_id is not NULL) then

Line 1375: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,

1371: (p_competence_id => p_competence_id
1372: ,p_object_version_number => p_object_version_number);
1373: --
1374: if (p_unit_standard_id is not NULL) then
1375: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,
1376: hr_api.g_varchar2)
1377: <> nvl(p_unit_standard_id,hr_api.g_varchar2)
1378: ) or
1379: (NOT l_api_updating)

Line 1470: l_api_updating := per_cpn_shd.api_updating

1466: -- Only proceed with validation if :
1467: -- a) The current g_old_rec is current and
1468: -- b) The value for credit type has changed
1469: --
1470: l_api_updating := per_cpn_shd.api_updating
1471: (p_competence_id => p_competence_id
1472: ,p_object_version_number => p_object_version_number);
1473: --
1474: if p_credit_type is not null then

Line 1475: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.credit_type,

1471: (p_competence_id => p_competence_id
1472: ,p_object_version_number => p_object_version_number);
1473: --
1474: if p_credit_type is not null then
1475: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.credit_type,
1476: hr_api.g_varchar2)
1477: <> nvl(p_credit_type,hr_api.g_varchar2)
1478: ) or
1479: (NOT l_api_updating)

Line 1551: l_api_updating := per_cpn_shd.api_updating

1547: -- Only proceed with validation if :
1548: -- a) The current g_old_rec is current and
1549: -- b) The value for level type has changed
1550: --
1551: l_api_updating := per_cpn_shd.api_updating
1552: (p_competence_id => p_competence_id
1553: ,p_object_version_number => p_object_version_number);
1554: --
1555: if p_level_type is not null then

Line 1556: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.level_type,

1552: (p_competence_id => p_competence_id
1553: ,p_object_version_number => p_object_version_number);
1554: --
1555: if p_level_type is not null then
1556: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.level_type,
1557: hr_api.g_varchar2)
1558: <> nvl(p_level_type,hr_api.g_varchar2)
1559: ) or
1560: (NOT l_api_updating)

Line 1632: l_api_updating := per_cpn_shd.api_updating

1628: -- Only proceed with validation if :
1629: -- a) The current g_old_rec is current and
1630: -- b) The value for level has changed
1631: --
1632: l_api_updating := per_cpn_shd.api_updating
1633: (p_competence_id => p_competence_id
1634: ,p_object_version_number => p_object_version_number);
1635: --
1636: if p_level_number is not null then

Line 1637: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.level_number,

1633: (p_competence_id => p_competence_id
1634: ,p_object_version_number => p_object_version_number);
1635: --
1636: if p_level_number is not null then
1637: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.level_number,
1638: hr_api.g_number)
1639: <> nvl(p_level_number,hr_api.g_number)
1640: ) or
1641: (NOT l_api_updating)

Line 1713: l_api_updating := per_cpn_shd.api_updating

1709: -- Only proceed with validation if :
1710: -- a) The current g_old_rec is current and
1711: -- b) The value for field has changed
1712: --
1713: l_api_updating := per_cpn_shd.api_updating
1714: (p_competence_id => p_competence_id
1715: ,p_object_version_number => p_object_version_number);
1716: --
1717: if p_field is not null then

Line 1718: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.field,

1714: (p_competence_id => p_competence_id
1715: ,p_object_version_number => p_object_version_number);
1716: --
1717: if p_field is not null then
1718: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.field,
1719: hr_api.g_varchar2)
1720: <> nvl(p_field,hr_api.g_varchar2)
1721: ) or
1722: (NOT l_api_updating)

Line 1794: l_api_updating := per_cpn_shd.api_updating

1790: -- Only proceed with validation if :
1791: -- a) The current g_old_rec is current and
1792: -- b) The value for sub field has changed
1793: --
1794: l_api_updating := per_cpn_shd.api_updating
1795: (p_competence_id => p_competence_id
1796: ,p_object_version_number => p_object_version_number);
1797: --
1798: if p_sub_field is not null then

Line 1799: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.sub_field,

1795: (p_competence_id => p_competence_id
1796: ,p_object_version_number => p_object_version_number);
1797: --
1798: if p_sub_field is not null then
1799: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.sub_field,
1800: hr_api.g_varchar2)
1801: <> nvl(p_sub_field,hr_api.g_varchar2)
1802: ) or
1803: (NOT l_api_updating)

Line 1875: l_api_updating := per_cpn_shd.api_updating

1871: -- Only proceed with validation if :
1872: -- a) The current g_old_rec is current and
1873: -- b) The value for provider has changed
1874: --
1875: l_api_updating := per_cpn_shd.api_updating
1876: (p_competence_id => p_competence_id
1877: ,p_object_version_number => p_object_version_number);
1878: --
1879: if p_provider is not null then

Line 1880: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.provider,

1876: (p_competence_id => p_competence_id
1877: ,p_object_version_number => p_object_version_number);
1878: --
1879: if p_provider is not null then
1880: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.provider,
1881: hr_api.g_varchar2)
1882: <> nvl(p_provider,hr_api.g_varchar2)
1883: ) or
1884: (NOT l_api_updating)

Line 1956: l_api_updating := per_cpn_shd.api_updating

1952: -- Only proceed with validation if :
1953: -- a) The current g_old_rec is current and
1954: -- b) The value for qa organization has changed
1955: --
1956: l_api_updating := per_cpn_shd.api_updating
1957: (p_competence_id => p_competence_id
1958: ,p_object_version_number => p_object_version_number);
1959: --
1960: if p_qa_organization is not null then

Line 1961: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.qa_organization,

1957: (p_competence_id => p_competence_id
1958: ,p_object_version_number => p_object_version_number);
1959: --
1960: if p_qa_organization is not null then
1961: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.qa_organization,
1962: hr_api.g_varchar2)
1963: <> nvl(p_qa_organization,hr_api.g_varchar2)
1964: ) or
1965: (NOT l_api_updating)

Line 2018: (p_rec in per_cpn_shd.g_rec_type) is

2014: -- Access Status:
2015: -- Internal Row Handler Use Only.
2016: --
2017: procedure chk_df
2018: (p_rec in per_cpn_shd.g_rec_type) is
2019: --
2020: l_proc varchar2(72) := g_package||'chk_df';
2021: --
2022: begin

Line 2026: nvl(per_cpn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2022: begin
2023: hr_utility.set_location('Entering:'||l_proc, 10);
2024: --
2025: if (((p_rec.competence_id is not null) and (
2026: nvl(per_cpn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2027: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2028: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2029: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2030: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 2028: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2024: --
2025: if (((p_rec.competence_id is not null) and (
2026: nvl(per_cpn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2027: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2028: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2029: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2030: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2031: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2032: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 2030: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2026: nvl(per_cpn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2027: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2028: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2029: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2030: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2031: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2032: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2033: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2034: nvl(per_cpn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 2032: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2028: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2029: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2030: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2031: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2032: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2033: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2034: nvl(per_cpn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2035: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2036: nvl(per_cpn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 2034: nvl(per_cpn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2030: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2031: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2032: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2033: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2034: nvl(per_cpn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2035: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2036: nvl(per_cpn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2037: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2038: nvl(per_cpn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 2036: nvl(per_cpn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2032: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2033: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2034: nvl(per_cpn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2035: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2036: nvl(per_cpn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2037: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2038: nvl(per_cpn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2039: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2040: nvl(per_cpn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 2038: nvl(per_cpn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2034: nvl(per_cpn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2035: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2036: nvl(per_cpn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2037: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2038: nvl(per_cpn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2039: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2040: nvl(per_cpn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2041: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2042: nvl(per_cpn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 2040: nvl(per_cpn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2036: nvl(per_cpn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2037: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2038: nvl(per_cpn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2039: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2040: nvl(per_cpn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2041: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2042: nvl(per_cpn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2043: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2044: nvl(per_cpn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 2042: nvl(per_cpn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2038: nvl(per_cpn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2039: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2040: nvl(per_cpn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2041: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2042: nvl(per_cpn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2043: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2044: nvl(per_cpn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2045: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2046: nvl(per_cpn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 2044: nvl(per_cpn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2040: nvl(per_cpn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2041: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2042: nvl(per_cpn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2043: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2044: nvl(per_cpn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2045: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2046: nvl(per_cpn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2047: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2048: nvl(per_cpn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 2046: nvl(per_cpn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2042: nvl(per_cpn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2043: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2044: nvl(per_cpn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2045: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2046: nvl(per_cpn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2047: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2048: nvl(per_cpn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2049: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2050: nvl(per_cpn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 2048: nvl(per_cpn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2044: nvl(per_cpn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2045: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2046: nvl(per_cpn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2047: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2048: nvl(per_cpn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2049: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2050: nvl(per_cpn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2051: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2052: nvl(per_cpn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 2050: nvl(per_cpn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2046: nvl(per_cpn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2047: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2048: nvl(per_cpn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2049: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2050: nvl(per_cpn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2051: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2052: nvl(per_cpn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2053: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2054: nvl(per_cpn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 2052: nvl(per_cpn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2048: nvl(per_cpn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2049: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2050: nvl(per_cpn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2051: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2052: nvl(per_cpn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2053: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2054: nvl(per_cpn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2055: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2056: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 2054: nvl(per_cpn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2050: nvl(per_cpn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2051: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2052: nvl(per_cpn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2053: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2054: nvl(per_cpn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2055: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2056: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2057: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2058: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 2056: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2052: nvl(per_cpn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2053: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2054: nvl(per_cpn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2055: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2056: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2057: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2058: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2059: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2060: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 2058: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2054: nvl(per_cpn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2055: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2056: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2057: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2058: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2059: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2060: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2061: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2062: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 2060: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2056: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2057: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2058: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2059: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2060: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2061: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2062: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2063: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2064: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 2062: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2058: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2059: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2060: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2061: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2062: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2063: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2064: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2065: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2066: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 2064: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2060: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2061: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2062: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2063: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2064: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2065: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2066: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2067: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2068: or

Line 2066: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2062: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2063: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2064: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2065: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2066: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2067: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2068: or
2069: p_rec.competence_id is null)
2070: and hr_competences_api.g_ignore_df <> 'Y' then -- BUG3621261

Line 2157: (p_rec in per_cpn_shd.g_rec_type

2153: -- Internal Row Handler Use Only.
2154: --
2155: -- ----------------------------------------------------------------------------
2156: procedure chk_ddf
2157: (p_rec in per_cpn_shd.g_rec_type
2158: ) is
2159: --
2160: l_proc varchar2(72) := g_package || 'chk_ddf';
2161: --

Line 2166: nvl(per_cpn_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

2162: begin
2163: hr_utility.set_location('Entering:'||l_proc,10);
2164: --
2165: if (((p_rec.competence_id is not null) and (
2166: nvl(per_cpn_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
2167: nvl(p_rec.information_category, hr_api.g_varchar2) or
2168: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>
2169: nvl(p_rec.information1, hr_api.g_varchar2) or
2170: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 2168: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>

2164: --
2165: if (((p_rec.competence_id is not null) and (
2166: nvl(per_cpn_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
2167: nvl(p_rec.information_category, hr_api.g_varchar2) or
2168: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>
2169: nvl(p_rec.information1, hr_api.g_varchar2) or
2170: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>
2171: nvl(p_rec.information2, hr_api.g_varchar2) or
2172: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 2170: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>

2166: nvl(per_cpn_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
2167: nvl(p_rec.information_category, hr_api.g_varchar2) or
2168: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>
2169: nvl(p_rec.information1, hr_api.g_varchar2) or
2170: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>
2171: nvl(p_rec.information2, hr_api.g_varchar2) or
2172: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>
2173: nvl(p_rec.information3, hr_api.g_varchar2) or
2174: nvl(per_cpn_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 2172: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>

2168: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>
2169: nvl(p_rec.information1, hr_api.g_varchar2) or
2170: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>
2171: nvl(p_rec.information2, hr_api.g_varchar2) or
2172: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>
2173: nvl(p_rec.information3, hr_api.g_varchar2) or
2174: nvl(per_cpn_shd.g_old_rec.information4, hr_api.g_varchar2) <>
2175: nvl(p_rec.information4, hr_api.g_varchar2) or
2176: nvl(per_cpn_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 2174: nvl(per_cpn_shd.g_old_rec.information4, hr_api.g_varchar2) <>

2170: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>
2171: nvl(p_rec.information2, hr_api.g_varchar2) or
2172: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>
2173: nvl(p_rec.information3, hr_api.g_varchar2) or
2174: nvl(per_cpn_shd.g_old_rec.information4, hr_api.g_varchar2) <>
2175: nvl(p_rec.information4, hr_api.g_varchar2) or
2176: nvl(per_cpn_shd.g_old_rec.information5, hr_api.g_varchar2) <>
2177: nvl(p_rec.information5, hr_api.g_varchar2) or
2178: nvl(per_cpn_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 2176: nvl(per_cpn_shd.g_old_rec.information5, hr_api.g_varchar2) <>

2172: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>
2173: nvl(p_rec.information3, hr_api.g_varchar2) or
2174: nvl(per_cpn_shd.g_old_rec.information4, hr_api.g_varchar2) <>
2175: nvl(p_rec.information4, hr_api.g_varchar2) or
2176: nvl(per_cpn_shd.g_old_rec.information5, hr_api.g_varchar2) <>
2177: nvl(p_rec.information5, hr_api.g_varchar2) or
2178: nvl(per_cpn_shd.g_old_rec.information6, hr_api.g_varchar2) <>
2179: nvl(p_rec.information6, hr_api.g_varchar2) or
2180: nvl(per_cpn_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 2178: nvl(per_cpn_shd.g_old_rec.information6, hr_api.g_varchar2) <>

2174: nvl(per_cpn_shd.g_old_rec.information4, hr_api.g_varchar2) <>
2175: nvl(p_rec.information4, hr_api.g_varchar2) or
2176: nvl(per_cpn_shd.g_old_rec.information5, hr_api.g_varchar2) <>
2177: nvl(p_rec.information5, hr_api.g_varchar2) or
2178: nvl(per_cpn_shd.g_old_rec.information6, hr_api.g_varchar2) <>
2179: nvl(p_rec.information6, hr_api.g_varchar2) or
2180: nvl(per_cpn_shd.g_old_rec.information7, hr_api.g_varchar2) <>
2181: nvl(p_rec.information7, hr_api.g_varchar2) or
2182: nvl(per_cpn_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 2180: nvl(per_cpn_shd.g_old_rec.information7, hr_api.g_varchar2) <>

2176: nvl(per_cpn_shd.g_old_rec.information5, hr_api.g_varchar2) <>
2177: nvl(p_rec.information5, hr_api.g_varchar2) or
2178: nvl(per_cpn_shd.g_old_rec.information6, hr_api.g_varchar2) <>
2179: nvl(p_rec.information6, hr_api.g_varchar2) or
2180: nvl(per_cpn_shd.g_old_rec.information7, hr_api.g_varchar2) <>
2181: nvl(p_rec.information7, hr_api.g_varchar2) or
2182: nvl(per_cpn_shd.g_old_rec.information8, hr_api.g_varchar2) <>
2183: nvl(p_rec.information8, hr_api.g_varchar2) or
2184: nvl(per_cpn_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 2182: nvl(per_cpn_shd.g_old_rec.information8, hr_api.g_varchar2) <>

2178: nvl(per_cpn_shd.g_old_rec.information6, hr_api.g_varchar2) <>
2179: nvl(p_rec.information6, hr_api.g_varchar2) or
2180: nvl(per_cpn_shd.g_old_rec.information7, hr_api.g_varchar2) <>
2181: nvl(p_rec.information7, hr_api.g_varchar2) or
2182: nvl(per_cpn_shd.g_old_rec.information8, hr_api.g_varchar2) <>
2183: nvl(p_rec.information8, hr_api.g_varchar2) or
2184: nvl(per_cpn_shd.g_old_rec.information9, hr_api.g_varchar2) <>
2185: nvl(p_rec.information9, hr_api.g_varchar2) or
2186: nvl(per_cpn_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 2184: nvl(per_cpn_shd.g_old_rec.information9, hr_api.g_varchar2) <>

2180: nvl(per_cpn_shd.g_old_rec.information7, hr_api.g_varchar2) <>
2181: nvl(p_rec.information7, hr_api.g_varchar2) or
2182: nvl(per_cpn_shd.g_old_rec.information8, hr_api.g_varchar2) <>
2183: nvl(p_rec.information8, hr_api.g_varchar2) or
2184: nvl(per_cpn_shd.g_old_rec.information9, hr_api.g_varchar2) <>
2185: nvl(p_rec.information9, hr_api.g_varchar2) or
2186: nvl(per_cpn_shd.g_old_rec.information10, hr_api.g_varchar2) <>
2187: nvl(p_rec.information10, hr_api.g_varchar2) or
2188: nvl(per_cpn_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 2186: nvl(per_cpn_shd.g_old_rec.information10, hr_api.g_varchar2) <>

2182: nvl(per_cpn_shd.g_old_rec.information8, hr_api.g_varchar2) <>
2183: nvl(p_rec.information8, hr_api.g_varchar2) or
2184: nvl(per_cpn_shd.g_old_rec.information9, hr_api.g_varchar2) <>
2185: nvl(p_rec.information9, hr_api.g_varchar2) or
2186: nvl(per_cpn_shd.g_old_rec.information10, hr_api.g_varchar2) <>
2187: nvl(p_rec.information10, hr_api.g_varchar2) or
2188: nvl(per_cpn_shd.g_old_rec.information11, hr_api.g_varchar2) <>
2189: nvl(p_rec.information11, hr_api.g_varchar2) or
2190: nvl(per_cpn_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 2188: nvl(per_cpn_shd.g_old_rec.information11, hr_api.g_varchar2) <>

2184: nvl(per_cpn_shd.g_old_rec.information9, hr_api.g_varchar2) <>
2185: nvl(p_rec.information9, hr_api.g_varchar2) or
2186: nvl(per_cpn_shd.g_old_rec.information10, hr_api.g_varchar2) <>
2187: nvl(p_rec.information10, hr_api.g_varchar2) or
2188: nvl(per_cpn_shd.g_old_rec.information11, hr_api.g_varchar2) <>
2189: nvl(p_rec.information11, hr_api.g_varchar2) or
2190: nvl(per_cpn_shd.g_old_rec.information13, hr_api.g_varchar2) <>
2191: nvl(p_rec.information13, hr_api.g_varchar2) or
2192: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 2190: nvl(per_cpn_shd.g_old_rec.information13, hr_api.g_varchar2) <>

2186: nvl(per_cpn_shd.g_old_rec.information10, hr_api.g_varchar2) <>
2187: nvl(p_rec.information10, hr_api.g_varchar2) or
2188: nvl(per_cpn_shd.g_old_rec.information11, hr_api.g_varchar2) <>
2189: nvl(p_rec.information11, hr_api.g_varchar2) or
2190: nvl(per_cpn_shd.g_old_rec.information13, hr_api.g_varchar2) <>
2191: nvl(p_rec.information13, hr_api.g_varchar2) or
2192: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>
2193: nvl(p_rec.information14, hr_api.g_varchar2) or
2194: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 2192: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>

2188: nvl(per_cpn_shd.g_old_rec.information11, hr_api.g_varchar2) <>
2189: nvl(p_rec.information11, hr_api.g_varchar2) or
2190: nvl(per_cpn_shd.g_old_rec.information13, hr_api.g_varchar2) <>
2191: nvl(p_rec.information13, hr_api.g_varchar2) or
2192: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>
2193: nvl(p_rec.information14, hr_api.g_varchar2) or
2194: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>
2195: nvl(p_rec.information15, hr_api.g_varchar2) or
2196: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 2194: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>

2190: nvl(per_cpn_shd.g_old_rec.information13, hr_api.g_varchar2) <>
2191: nvl(p_rec.information13, hr_api.g_varchar2) or
2192: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>
2193: nvl(p_rec.information14, hr_api.g_varchar2) or
2194: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>
2195: nvl(p_rec.information15, hr_api.g_varchar2) or
2196: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2197: nvl(p_rec.information16, hr_api.g_varchar2) or
2198: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 2196: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>

2192: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>
2193: nvl(p_rec.information14, hr_api.g_varchar2) or
2194: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>
2195: nvl(p_rec.information15, hr_api.g_varchar2) or
2196: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2197: nvl(p_rec.information16, hr_api.g_varchar2) or
2198: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2199: nvl(p_rec.information17, hr_api.g_varchar2) or
2200: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 2198: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>

2194: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>
2195: nvl(p_rec.information15, hr_api.g_varchar2) or
2196: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2197: nvl(p_rec.information16, hr_api.g_varchar2) or
2198: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2199: nvl(p_rec.information17, hr_api.g_varchar2) or
2200: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2201: nvl(p_rec.information18, hr_api.g_varchar2) or
2202: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 2200: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>

2196: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2197: nvl(p_rec.information16, hr_api.g_varchar2) or
2198: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2199: nvl(p_rec.information17, hr_api.g_varchar2) or
2200: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2201: nvl(p_rec.information18, hr_api.g_varchar2) or
2202: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>
2203: nvl(p_rec.information19, hr_api.g_varchar2) or
2204: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 2202: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>

2198: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2199: nvl(p_rec.information17, hr_api.g_varchar2) or
2200: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2201: nvl(p_rec.information18, hr_api.g_varchar2) or
2202: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>
2203: nvl(p_rec.information19, hr_api.g_varchar2) or
2204: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>
2205: nvl(p_rec.information20, hr_api.g_varchar2) ))
2206: or (p_rec.competence_id is null))

Line 2204: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>

2200: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2201: nvl(p_rec.information18, hr_api.g_varchar2) or
2202: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>
2203: nvl(p_rec.information19, hr_api.g_varchar2) or
2204: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>
2205: nvl(p_rec.information20, hr_api.g_varchar2) ))
2206: or (p_rec.competence_id is null))
2207: and hr_competences_api.g_ignore_df <> 'Y' then -- BUG3621261
2208: --

Line 2265: Procedure insert_validate(p_rec in per_cpn_shd.g_rec_type,

2261: -- ---------------------------------------------------------------------------
2262: -- |---------------------------< insert_validate >----------------------------|
2263: -- ---------------------------------------------------------------------------
2264: --
2265: Procedure insert_validate(p_rec in per_cpn_shd.g_rec_type,
2266: p_effective_date in date) is
2267: --
2268: l_proc varchar2(72) := g_package||'insert_validate';
2269: --

Line 2478: Procedure update_validate(p_rec in per_cpn_shd.g_rec_type

2474: --
2475: -- ----------------------------------------------------------------------------
2476: -- |---------------------------< update_validate >----------------------------|
2477: -- ----------------------------------------------------------------------------
2478: Procedure update_validate(p_rec in per_cpn_shd.g_rec_type
2479: ,p_effective_date in date ) is
2480: --
2481: l_proc varchar2(72) := g_package||'update_validate';
2482: --

Line 2713: Procedure delete_validate(p_rec in per_cpn_shd.g_rec_type) is

2709: --
2710: -- ----------------------------------------------------------------------------
2711: -- |---------------------------< delete_validate >----------------------------|
2712: -- ----------------------------------------------------------------------------
2713: Procedure delete_validate(p_rec in per_cpn_shd.g_rec_type) is
2714: --
2715: l_proc varchar2(72) := g_package||'delete_validate';
2716: --
2717: Begin