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 286: and ( p_date_from <> per_cpn_shd.g_old_rec.date_from

282: -- Check dates againts competence elements (only in Update mode)
283: --
284: if p_called_from = 'UPDATE'
285:
286: and ( p_date_from <> per_cpn_shd.g_old_rec.date_from
287: or nvl(p_date_to,hr_api.g_date)<>nvl(per_cpn_shd.g_old_rec.date_to,hr_api.g_date)
288: ) then
289:
290: open csr_check_dates_in_ele;

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

283: --
284: if p_called_from = 'UPDATE'
285:
286: and ( p_date_from <> per_cpn_shd.g_old_rec.date_from
287: or nvl(p_date_to,hr_api.g_date)<>nvl(per_cpn_shd.g_old_rec.date_to,hr_api.g_date)
288: ) then
289:
290: open csr_check_dates_in_ele;
291: fetch csr_check_dates_in_ele into l_exists;

Line 364: l_api_updating := per_cpn_shd.api_updating

360: -- Only proceed with validation if :
361: -- a) The current g_old_rec is current and
362: -- b) The value for certification required flag has changed
363: --
364: l_api_updating := per_cpn_shd.api_updating
365: (p_competence_id => p_competence_id
366: ,p_object_version_number => p_object_version_number);
367: --
368: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.certification_required,

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

364: l_api_updating := per_cpn_shd.api_updating
365: (p_competence_id => p_competence_id
366: ,p_object_version_number => p_object_version_number);
367: --
368: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.certification_required,
369: hr_api.g_varchar2)
370: <> nvl(p_certification_required,hr_api.g_varchar2)
371: ) or
372: (NOT l_api_updating)

Line 459: l_api_updating := per_cpn_shd.api_updating

455: -- Only proceed with validation if :
456: -- a) The current g_old_rec is current and
457: -- b) The value for evaluation method has changed
458: --
459: l_api_updating := per_cpn_shd.api_updating
460: (p_competence_id => p_competence_id
461: ,p_object_version_number => p_object_version_number);
462: --
463: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.evaluation_method,

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

459: l_api_updating := per_cpn_shd.api_updating
460: (p_competence_id => p_competence_id
461: ,p_object_version_number => p_object_version_number);
462: --
463: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.evaluation_method,
464: hr_api.g_varchar2)
465: <> nvl(p_evaluation_method,hr_api.g_varchar2)
466: ) or
467: (NOT l_api_updating)

Line 566: l_api_updating := per_cpn_shd.api_updating

562: -- Only proceed with validation if :
563: -- a) The current g_old_rec is current and
564: -- b) The value for renewal period units has changed
565: --
566: l_api_updating := per_cpn_shd.api_updating
567: (p_competence_id => p_competence_id
568: ,p_object_version_number => p_object_version_number);
569: --
570: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.renewal_period_units,

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

566: l_api_updating := per_cpn_shd.api_updating
567: (p_competence_id => p_competence_id
568: ,p_object_version_number => p_object_version_number);
569: --
570: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.renewal_period_units,
571: hr_api.g_varchar2)
572: <> nvl(p_renewal_period_units,hr_api.g_varchar2)
573: ) or
574: (NOT l_api_updating)

Line 664: l_api_updating := per_cpn_shd.api_updating

660: -- a) The current g_old_rec is current and
661: -- b) The value for renewal period units or renewal period frquency has
662: -- changed
663: --
664: l_api_updating := per_cpn_shd.api_updating
665: (p_competence_id => p_competence_id
666: ,p_object_version_number => p_object_version_number);
667: --
668: if (l_api_updating

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

666: ,p_object_version_number => p_object_version_number);
667: --
668: if (l_api_updating
669: and
670: ((nvl(per_cpn_shd.g_old_rec.renewal_period_units,
671: hr_api.g_varchar2)
672: <> nvl(p_renewal_period_units,hr_api.g_varchar2))
673: or
674: (nvl(per_cpn_shd.g_old_rec.renewal_period_frequency,

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

670: ((nvl(per_cpn_shd.g_old_rec.renewal_period_units,
671: hr_api.g_varchar2)
672: <> nvl(p_renewal_period_units,hr_api.g_varchar2))
673: or
674: (nvl(per_cpn_shd.g_old_rec.renewal_period_frequency,
675: hr_api.g_number)
676: <> nvl(p_renewal_period_frequency,hr_api.g_number))))
677: or
678: NOT l_api_updating then

Line 758: l_api_updating := per_cpn_shd.api_updating

754: -- Only proceed with validation if :
755: -- a) The current g_old_rec is current and
756: -- b) The value for rating scale has changed
757: --
758: l_api_updating := per_cpn_shd.api_updating
759: (p_competence_id => p_competence_id
760: ,p_object_version_number => p_object_version_number);
761: --
762: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

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

758: l_api_updating := per_cpn_shd.api_updating
759: (p_competence_id => p_competence_id
760: ,p_object_version_number => p_object_version_number);
761: --
762: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
763: hr_api.g_number)
764: <> nvl(p_rating_scale_id,hr_api.g_number)
765: ) or
766: (NOT l_api_updating)

Line 859: l_api_updating := per_cpn_shd.api_updating

855: -- Only proceed with validation if :
856: -- a) The current g_old_rec is current and
857: -- b) The value for rating scale has changed
858: --
859: l_api_updating := per_cpn_shd.api_updating
860: (p_competence_id => p_competence_id
861: ,p_object_version_number => p_object_version_number);
862: --
863: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

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

859: l_api_updating := per_cpn_shd.api_updating
860: (p_competence_id => p_competence_id
861: ,p_object_version_number => p_object_version_number);
862: --
863: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
864: hr_api.g_number)
865: <> nvl(p_rating_scale_id,hr_api.g_number)
866: ) or
867: (NOT l_api_updating)

Line 944: l_api_updating := per_cpn_shd.api_updating

940: -- Only proceed with validation if :
941: -- a) The current g_old_rec is current and
942: -- b) The value for rating scale has changed
943: --
944: l_api_updating := per_cpn_shd.api_updating
945: (p_competence_id => p_competence_id
946: ,p_object_version_number => p_object_version_number);
947: --
948: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

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

944: l_api_updating := per_cpn_shd.api_updating
945: (p_competence_id => p_competence_id
946: ,p_object_version_number => p_object_version_number);
947: --
948: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
949: hr_api.g_number)
950: <> nvl(p_rating_scale_id,hr_api.g_number)
951: ) or
952: (NOT l_api_updating)

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

1023: from per_rating_levels rl,
1024: per_competence_elements ce
1025: where ((rl.rating_level_id = ce.proficiency_level_id) or
1026: (rl.rating_level_id = ce.high_proficiency_level_id))
1027: and rl.rating_scale_id = nvl(per_cpn_shd.g_old_rec.rating_scale_id,-9999)
1028: and ce.competence_id = p_competence_id;
1029: --
1030: begin
1031: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1037: l_api_updating := per_cpn_shd.api_updating

1033: -- Only proceed with validation if :
1034: -- a) The current g_old_rec is current and
1035: -- b) The value for rating scale has changed
1036: --
1037: l_api_updating := per_cpn_shd.api_updating
1038: (p_competence_id => p_competence_id
1039: ,p_object_version_number => p_object_version_number);
1040: --
1041: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,

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

1037: l_api_updating := per_cpn_shd.api_updating
1038: (p_competence_id => p_competence_id
1039: ,p_object_version_number => p_object_version_number);
1040: --
1041: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.rating_scale_id,
1042: hr_api.g_number)
1043: <> nvl(p_rating_scale_id,hr_api.g_number)
1044: ) or
1045: (NOT l_api_updating)

Line 1280: l_api_updating := per_cpn_shd.api_updating

1276: -- Only proceed with validation if :
1277: -- a) The current g_old_rec is current and
1278: -- b) The value for cluster name has changed
1279: --
1280: l_api_updating := per_cpn_shd.api_updating
1281: (p_competence_id => p_competence_id
1282: ,p_object_version_number => p_object_version_number);
1283: --
1284: if (p_competence_cluster is not NULL) then

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

1281: (p_competence_id => p_competence_id
1282: ,p_object_version_number => p_object_version_number);
1283: --
1284: if (p_competence_cluster is not NULL) then
1285: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.competence_cluster,
1286: hr_api.g_varchar2)
1287: <> nvl(p_competence_cluster,hr_api.g_varchar2)
1288: ) or
1289: (NOT l_api_updating)

Line 1376: l_api_updating := per_cpn_shd.api_updating

1372: -- Only proceed with validation if :
1373: -- a) The current g_old_rec is current and
1374: -- b) The value for unit_standard_id has changed
1375: --
1376: l_api_updating := per_cpn_shd.api_updating
1377: (p_competence_id => p_competence_id
1378: ,p_object_version_number => p_object_version_number);
1379: --
1380: if (p_unit_standard_id is not NULL) then

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

1377: (p_competence_id => p_competence_id
1378: ,p_object_version_number => p_object_version_number);
1379: --
1380: if (p_unit_standard_id is not NULL) then
1381: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,
1382: hr_api.g_varchar2)
1383: <> nvl(p_unit_standard_id,hr_api.g_varchar2)
1384: ) or
1385: (NOT l_api_updating)

Line 1476: l_api_updating := per_cpn_shd.api_updating

1472: -- Only proceed with validation if :
1473: -- a) The current g_old_rec is current and
1474: -- b) The value for credit type has changed
1475: --
1476: l_api_updating := per_cpn_shd.api_updating
1477: (p_competence_id => p_competence_id
1478: ,p_object_version_number => p_object_version_number);
1479: --
1480: if p_credit_type is not null then

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

1477: (p_competence_id => p_competence_id
1478: ,p_object_version_number => p_object_version_number);
1479: --
1480: if p_credit_type is not null then
1481: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.credit_type,
1482: hr_api.g_varchar2)
1483: <> nvl(p_credit_type,hr_api.g_varchar2)
1484: ) or
1485: (NOT l_api_updating)

Line 1557: l_api_updating := per_cpn_shd.api_updating

1553: -- Only proceed with validation if :
1554: -- a) The current g_old_rec is current and
1555: -- b) The value for level type has changed
1556: --
1557: l_api_updating := per_cpn_shd.api_updating
1558: (p_competence_id => p_competence_id
1559: ,p_object_version_number => p_object_version_number);
1560: --
1561: if p_level_type is not null then

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

1558: (p_competence_id => p_competence_id
1559: ,p_object_version_number => p_object_version_number);
1560: --
1561: if p_level_type is not null then
1562: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.level_type,
1563: hr_api.g_varchar2)
1564: <> nvl(p_level_type,hr_api.g_varchar2)
1565: ) or
1566: (NOT l_api_updating)

Line 1638: l_api_updating := per_cpn_shd.api_updating

1634: -- Only proceed with validation if :
1635: -- a) The current g_old_rec is current and
1636: -- b) The value for level has changed
1637: --
1638: l_api_updating := per_cpn_shd.api_updating
1639: (p_competence_id => p_competence_id
1640: ,p_object_version_number => p_object_version_number);
1641: --
1642: if p_level_number is not null then

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

1639: (p_competence_id => p_competence_id
1640: ,p_object_version_number => p_object_version_number);
1641: --
1642: if p_level_number is not null then
1643: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.level_number,
1644: hr_api.g_number)
1645: <> nvl(p_level_number,hr_api.g_number)
1646: ) or
1647: (NOT l_api_updating)

Line 1719: l_api_updating := per_cpn_shd.api_updating

1715: -- Only proceed with validation if :
1716: -- a) The current g_old_rec is current and
1717: -- b) The value for field has changed
1718: --
1719: l_api_updating := per_cpn_shd.api_updating
1720: (p_competence_id => p_competence_id
1721: ,p_object_version_number => p_object_version_number);
1722: --
1723: if p_field is not null then

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

1720: (p_competence_id => p_competence_id
1721: ,p_object_version_number => p_object_version_number);
1722: --
1723: if p_field is not null then
1724: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.field,
1725: hr_api.g_varchar2)
1726: <> nvl(p_field,hr_api.g_varchar2)
1727: ) or
1728: (NOT l_api_updating)

Line 1800: l_api_updating := per_cpn_shd.api_updating

1796: -- Only proceed with validation if :
1797: -- a) The current g_old_rec is current and
1798: -- b) The value for sub field has changed
1799: --
1800: l_api_updating := per_cpn_shd.api_updating
1801: (p_competence_id => p_competence_id
1802: ,p_object_version_number => p_object_version_number);
1803: --
1804: if p_sub_field is not null then

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

1801: (p_competence_id => p_competence_id
1802: ,p_object_version_number => p_object_version_number);
1803: --
1804: if p_sub_field is not null then
1805: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.sub_field,
1806: hr_api.g_varchar2)
1807: <> nvl(p_sub_field,hr_api.g_varchar2)
1808: ) or
1809: (NOT l_api_updating)

Line 1881: l_api_updating := per_cpn_shd.api_updating

1877: -- Only proceed with validation if :
1878: -- a) The current g_old_rec is current and
1879: -- b) The value for provider has changed
1880: --
1881: l_api_updating := per_cpn_shd.api_updating
1882: (p_competence_id => p_competence_id
1883: ,p_object_version_number => p_object_version_number);
1884: --
1885: if p_provider is not null then

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

1882: (p_competence_id => p_competence_id
1883: ,p_object_version_number => p_object_version_number);
1884: --
1885: if p_provider is not null then
1886: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.provider,
1887: hr_api.g_varchar2)
1888: <> nvl(p_provider,hr_api.g_varchar2)
1889: ) or
1890: (NOT l_api_updating)

Line 1962: l_api_updating := per_cpn_shd.api_updating

1958: -- Only proceed with validation if :
1959: -- a) The current g_old_rec is current and
1960: -- b) The value for qa organization has changed
1961: --
1962: l_api_updating := per_cpn_shd.api_updating
1963: (p_competence_id => p_competence_id
1964: ,p_object_version_number => p_object_version_number);
1965: --
1966: if p_qa_organization is not null then

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

1963: (p_competence_id => p_competence_id
1964: ,p_object_version_number => p_object_version_number);
1965: --
1966: if p_qa_organization is not null then
1967: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.qa_organization,
1968: hr_api.g_varchar2)
1969: <> nvl(p_qa_organization,hr_api.g_varchar2)
1970: ) or
1971: (NOT l_api_updating)

Line 2024: (p_rec in per_cpn_shd.g_rec_type) is

2020: -- Access Status:
2021: -- Internal Row Handler Use Only.
2022: --
2023: procedure chk_df
2024: (p_rec in per_cpn_shd.g_rec_type) is
2025: --
2026: l_proc varchar2(72) := g_package||'chk_df';
2027: --
2028: begin

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

2028: begin
2029: hr_utility.set_location('Entering:'||l_proc, 10);
2030: --
2031: if (((p_rec.competence_id is not null) and (
2032: nvl(per_cpn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2033: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2034: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2035: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2036: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

2030: --
2031: if (((p_rec.competence_id is not null) and (
2032: nvl(per_cpn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2033: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2034: nvl(per_cpn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2035: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2036: nvl(per_cpn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2037: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2038: nvl(per_cpn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2062: nvl(per_cpn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2063: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2064: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2065: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2066: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2067: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2068: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2069: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2070: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

2064: nvl(per_cpn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2065: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2066: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2067: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2068: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2069: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2070: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2071: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2072: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

2066: nvl(per_cpn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2067: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2068: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2069: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2070: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2071: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2072: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2073: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2074: or

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

2068: nvl(per_cpn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2069: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2070: nvl(per_cpn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2071: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2072: nvl(per_cpn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2073: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2074: or
2075: p_rec.competence_id is null)
2076: and hr_competences_api.g_ignore_df <> 'Y' then -- BUG3621261

Line 2163: (p_rec in per_cpn_shd.g_rec_type

2159: -- Internal Row Handler Use Only.
2160: --
2161: -- ----------------------------------------------------------------------------
2162: procedure chk_ddf
2163: (p_rec in per_cpn_shd.g_rec_type
2164: ) is
2165: --
2166: l_proc varchar2(72) := g_package || 'chk_ddf';
2167: --

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

2168: begin
2169: hr_utility.set_location('Entering:'||l_proc,10);
2170: --
2171: if (((p_rec.competence_id is not null) and (
2172: nvl(per_cpn_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
2173: nvl(p_rec.information_category, hr_api.g_varchar2) or
2174: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>
2175: nvl(p_rec.information1, hr_api.g_varchar2) or
2176: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

2170: --
2171: if (((p_rec.competence_id is not null) and (
2172: nvl(per_cpn_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
2173: nvl(p_rec.information_category, hr_api.g_varchar2) or
2174: nvl(per_cpn_shd.g_old_rec.information1, hr_api.g_varchar2) <>
2175: nvl(p_rec.information1, hr_api.g_varchar2) or
2176: nvl(per_cpn_shd.g_old_rec.information2, hr_api.g_varchar2) <>
2177: nvl(p_rec.information2, hr_api.g_varchar2) or
2178: nvl(per_cpn_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2198: nvl(per_cpn_shd.g_old_rec.information14, hr_api.g_varchar2) <>
2199: nvl(p_rec.information14, hr_api.g_varchar2) or
2200: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>
2201: nvl(p_rec.information15, hr_api.g_varchar2) or
2202: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2203: nvl(p_rec.information16, hr_api.g_varchar2) or
2204: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2205: nvl(p_rec.information17, hr_api.g_varchar2) or
2206: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

2200: nvl(per_cpn_shd.g_old_rec.information15, hr_api.g_varchar2) <>
2201: nvl(p_rec.information15, hr_api.g_varchar2) or
2202: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2203: nvl(p_rec.information16, hr_api.g_varchar2) or
2204: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2205: nvl(p_rec.information17, hr_api.g_varchar2) or
2206: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2207: nvl(p_rec.information18, hr_api.g_varchar2) or
2208: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

2202: nvl(per_cpn_shd.g_old_rec.information16, hr_api.g_varchar2) <>
2203: nvl(p_rec.information16, hr_api.g_varchar2) or
2204: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2205: nvl(p_rec.information17, hr_api.g_varchar2) or
2206: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2207: nvl(p_rec.information18, hr_api.g_varchar2) or
2208: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>
2209: nvl(p_rec.information19, hr_api.g_varchar2) or
2210: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

2204: nvl(per_cpn_shd.g_old_rec.information17, hr_api.g_varchar2) <>
2205: nvl(p_rec.information17, hr_api.g_varchar2) or
2206: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2207: nvl(p_rec.information18, hr_api.g_varchar2) or
2208: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>
2209: nvl(p_rec.information19, hr_api.g_varchar2) or
2210: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>
2211: nvl(p_rec.information20, hr_api.g_varchar2) ))
2212: or (p_rec.competence_id is null))

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

2206: nvl(per_cpn_shd.g_old_rec.information18, hr_api.g_varchar2) <>
2207: nvl(p_rec.information18, hr_api.g_varchar2) or
2208: nvl(per_cpn_shd.g_old_rec.information19, hr_api.g_varchar2) <>
2209: nvl(p_rec.information19, hr_api.g_varchar2) or
2210: nvl(per_cpn_shd.g_old_rec.information20, hr_api.g_varchar2) <>
2211: nvl(p_rec.information20, hr_api.g_varchar2) ))
2212: or (p_rec.competence_id is null))
2213: and hr_competences_api.g_ignore_df <> 'Y' then -- BUG3621261
2214: --

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

2267: -- ---------------------------------------------------------------------------
2268: -- |---------------------------< insert_validate >----------------------------|
2269: -- ---------------------------------------------------------------------------
2270: --
2271: Procedure insert_validate(p_rec in per_cpn_shd.g_rec_type,
2272: p_effective_date in date) is
2273: --
2274: l_proc varchar2(72) := g_package||'insert_validate';
2275: --

Line 2484: Procedure update_validate(p_rec in per_cpn_shd.g_rec_type

2480: --
2481: -- ----------------------------------------------------------------------------
2482: -- |---------------------------< update_validate >----------------------------|
2483: -- ----------------------------------------------------------------------------
2484: Procedure update_validate(p_rec in per_cpn_shd.g_rec_type
2485: ,p_effective_date in date ) is
2486: --
2487: l_proc varchar2(72) := g_package||'update_validate';
2488: --

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

2715: --
2716: -- ----------------------------------------------------------------------------
2717: -- |---------------------------< delete_validate >----------------------------|
2718: -- ----------------------------------------------------------------------------
2719: Procedure delete_validate(p_rec in per_cpn_shd.g_rec_type) is
2720: --
2721: l_proc varchar2(72) := g_package||'delete_validate';
2722: --
2723: Begin