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 HR_API

Line 61: hr_api.argument_changed_error

57:
58: --
59: exception
60: when l_error then
61: hr_api.argument_changed_error
62: (p_api_name => l_proc
63: ,p_argument => l_argument);
64: when others then
65: raise;

Line 149: <> nvl(p_competence_definition_id,hr_api.g_number))

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

Line 239: where ( nvl(cpe.effective_date_from,hr_api.g_sot) <

235:
236: Cursor csr_check_dates_in_ele is
237: select 'Y'
238: from per_competence_elements cpe
239: where ( nvl(cpe.effective_date_from,hr_api.g_sot) <
240: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
241: or nvl(cpe.effective_date_from,hr_api.g_sot) >
242: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
243: )

Line 240: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))

236: Cursor csr_check_dates_in_ele is
237: select 'Y'
238: from per_competence_elements cpe
239: where ( nvl(cpe.effective_date_from,hr_api.g_sot) <
240: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
241: or nvl(cpe.effective_date_from,hr_api.g_sot) >
242: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
243: )
244: and cpe.competence_id = p_competence_id

Line 241: or nvl(cpe.effective_date_from,hr_api.g_sot) >

237: select 'Y'
238: from per_competence_elements cpe
239: where ( nvl(cpe.effective_date_from,hr_api.g_sot) <
240: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
241: or nvl(cpe.effective_date_from,hr_api.g_sot) >
242: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
243: )
244: and cpe.competence_id = p_competence_id
245: --adhunter reinstated the following check for 2533926

Line 242: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))

238: from per_competence_elements cpe
239: where ( nvl(cpe.effective_date_from,hr_api.g_sot) <
240: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
241: or nvl(cpe.effective_date_from,hr_api.g_sot) >
242: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
243: )
244: and cpe.competence_id = p_competence_id
245: --adhunter reinstated the following check for 2533926
246: and cpe.type not in

Line 264: if (p_date_from > nvl(p_date_to,hr_api.g_eot)) then

260: end if;
261: --
262: -- The date from has to be >= the date to, else error.
263: --
264: if (p_date_from > nvl(p_date_to,hr_api.g_eot)) then
265: --
266: hr_utility.set_message(801, 'HR_51599_CPN_DATE_TO_LATER');
267: hr_utility.raise_error;
268: --

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 348: hr_api.mandatory_arg_error

344: hr_utility.set_location('Entering:'|| l_proc, 1);
345: --
346: -- Check mandatory parameters have been set
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc
350: ,p_argument => 'effective_date'
351: ,p_argument_value => p_effective_date
352: );

Line 363: hr_api.g_varchar2)

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)
367: ) then

Line 364: <> nvl(p_certification_required,hr_api.g_varchar2)

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)
367: ) then
368: --

Line 378: if hr_api.not_exists_in_hr_lookups

374: -- where the lookup_type = 'YES_NO'
375: --
376: --
377: if p_certification_required is not null then
378: if hr_api.not_exists_in_hr_lookups
379: (p_effective_date => p_effective_date
380: ,p_lookup_type => 'YES_NO'
381: ,p_lookup_code => p_certification_required
382: ) then

Line 443: hr_api.mandatory_arg_error

439: hr_utility.set_location('Entering:'|| l_proc, 1);
440: --
441: -- Check mandatory parameters have been set
442: --
443: hr_api.mandatory_arg_error
444: (p_api_name => l_proc
445: ,p_argument => 'effective_date'
446: ,p_argument_value => p_effective_date
447: );

Line 458: hr_api.g_varchar2)

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)
462: ) then

Line 459: <> nvl(p_evaluation_method,hr_api.g_varchar2)

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)
462: ) then
463: --

Line 475: if hr_api.not_exists_in_hrstanlookups

471: -- ngundura changes for pa requirements.
472: --
473: if p_evaluation_method is not null then
474: if p_business_group_id is null then
475: if hr_api.not_exists_in_hrstanlookups
476: (p_effective_date => p_effective_date
477: ,p_lookup_type => 'COMPETENCE_EVAL_TYPE'
478: ,p_lookup_code => p_evaluation_method
479: ) then

Line 484: if hr_api.not_exists_in_hr_lookups

480: hr_utility.set_message(801,'HR_51433_COMP_EVAL_METHOD');
481: hr_utility.raise_error;
482: end if;
483: else
484: if hr_api.not_exists_in_hr_lookups
485: (p_effective_date => p_effective_date
486: ,p_lookup_type => 'COMPETENCE_EVAL_TYPE'
487: ,p_lookup_code => p_evaluation_method
488: ) then

Line 550: hr_api.mandatory_arg_error

546: hr_utility.set_location('Entering:'|| l_proc, 1);
547: --
548: -- Check mandatory parameters have been set
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc
552: ,p_argument => 'effective_date'
553: ,p_argument_value => p_effective_date
554: );

Line 565: hr_api.g_varchar2)

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)
569: ) then

Line 566: <> nvl(p_renewal_period_units,hr_api.g_varchar2)

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)
569: ) then
570: --

Line 585: -- if hr_api.not_exists_in_hr_lookups

581: --where the lookup_type = 'FREQUENCY'
582: --
583: --
584: if p_renewal_period_units is not null then
585: -- if hr_api.not_exists_in_hr_lookups
586: -- (p_effective_date => p_effective_date
587: -- ,p_lookup_type => 'UNITS'
588: -- ,p_lookup_code => p_renewal_period_units
589: -- ) then

Line 591: if hr_api.not_exists_in_hr_lookups

587: -- ,p_lookup_type => 'UNITS'
588: -- ,p_lookup_code => p_renewal_period_units
589: -- ) then
590: -- error invalid period units
591: if hr_api.not_exists_in_hr_lookups
592: (p_effective_date => p_effective_date
593: ,p_lookup_type => 'FREQUENCY'
594: ,p_lookup_code => p_renewal_period_units
595: ) then

Line 665: hr_api.g_varchar2)

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,
669: hr_api.g_number)

Line 666: <> nvl(p_renewal_period_units,hr_api.g_varchar2))

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,
669: hr_api.g_number)
670: <> nvl(p_renewal_period_frequency,hr_api.g_number))))

Line 669: hr_api.g_number)

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

Line 670: <> nvl(p_renewal_period_frequency,hr_api.g_number))))

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
673: --
674: hr_utility.set_location(l_proc, 2);

Line 757: hr_api.g_number)

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)
761: ) then

Line 758: <> nvl(p_rating_scale_id,hr_api.g_number)

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)
761: ) then
762: --

Line 782: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id and l_business_group_id is not null then

778: hr_utility.set_message(801,'HR_51453_COMP_DIFF_BUS_GRP');
779: hr_utility.raise_error;
780: end if;
781: else
782: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id and l_business_group_id is not null then
783: hr_utility.set_message(801,'HR_51453_COMP_DIFF_BUS_GRP');
784: hr_utility.raise_error;
785: end if;
786: end if;

Line 858: hr_api.g_number)

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)
862: ) then

Line 859: <> nvl(p_rating_scale_id,hr_api.g_number)

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)
862: ) then
863: --

Line 943: hr_api.g_number)

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)
947: ) then

Line 944: <> nvl(p_rating_scale_id,hr_api.g_number)

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)
947: ) then
948: --

Line 1036: hr_api.g_number)

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)
1040: ) then

Line 1037: <> nvl(p_rating_scale_id,hr_api.g_number)

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)
1040: ) then
1041: --

Line 1133: hr_api.mandatory_arg_error

1129: hr_utility.set_location('Entering:'|| l_proc, 1);
1130: --
1131: -- Check mandatory parameters have been set
1132: --
1133: hr_api.mandatory_arg_error
1134: (p_api_name => l_proc
1135: ,p_argument => 'competence_id'
1136: ,p_argument_value => p_competence_id
1137: );

Line 1280: hr_api.g_varchar2)

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)
1284: ) then

Line 1281: <> nvl(p_competence_cluster,hr_api.g_varchar2)

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)
1284: ) then
1285: --

Line 1290: IF hr_api.not_exists_in_hr_lookups

1286: hr_utility.set_location(l_proc, 20);
1287: --
1288: -- Check that the category exists in HR_LOOKUPS
1289: --
1290: IF hr_api.not_exists_in_hr_lookups
1291: (p_effective_date => p_effective_date
1292: ,p_lookup_type => 'PER_COMPETENCE_CLUSTER'
1293: ,p_lookup_code => p_competence_cluster) THEN
1294: --

Line 1352: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);

1348: cursor csr_local_unit_standard_id is
1349: select 1 from per_competences
1350: where unit_standard_id = p_unit_standard_id
1351: and business_group_id = p_business_group_id
1352: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1353: --
1354: cursor csr_global_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id

Line 1357: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);

1353: --
1354: cursor csr_global_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id
1357: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1358:
1359: l_proc varchar2(72) := g_package||'chk_unit_standard_id';
1360: l_api_updating boolean;
1361: l_exists varchar2(1);

Line 1376: hr_api.g_varchar2)

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)
1380: ) then

Line 1377: <> nvl(p_unit_standard_id,hr_api.g_varchar2)

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)
1380: ) then
1381: --

Line 1476: hr_api.g_varchar2)

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)
1480: ) then

Line 1477: <> nvl(p_credit_type,hr_api.g_varchar2)

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)
1480: ) then
1481: --

Line 1486: IF hr_api.not_exists_in_hr_lookups

1482: hr_utility.set_location(l_proc, 20);
1483: --
1484: -- Check that the category exists in HR_LOOKUPS
1485: --
1486: IF hr_api.not_exists_in_hr_lookups
1487: (p_effective_date => p_effective_date
1488: ,p_lookup_type => 'PER_QUAL_FWK_CREDIT_TYPE'
1489: ,p_lookup_code => p_credit_type) THEN
1490: --

Line 1557: hr_api.g_varchar2)

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)
1561: ) then

Line 1558: <> nvl(p_level_type,hr_api.g_varchar2)

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)
1561: ) then
1562: --

Line 1567: IF hr_api.not_exists_in_hr_lookups

1563: hr_utility.set_location(l_proc, 20);
1564: --
1565: -- Check that the category exists in HR_LOOKUPS
1566: --
1567: IF hr_api.not_exists_in_hr_lookups
1568: (p_effective_date => p_effective_date
1569: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL_TYPE'
1570: ,p_lookup_code => p_level_type) THEN
1571: --

Line 1638: hr_api.g_number)

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)
1642: ) then

Line 1639: <> nvl(p_level_number,hr_api.g_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)
1642: ) then
1643: --

Line 1648: IF hr_api.not_exists_in_hr_lookups

1644: hr_utility.set_location(l_proc, 20);
1645: --
1646: -- Check that the category exists in HR_LOOKUPS
1647: --
1648: IF hr_api.not_exists_in_hr_lookups
1649: (p_effective_date => p_effective_date
1650: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL'
1651: ,p_lookup_code => p_level_number) THEN
1652: --

Line 1719: hr_api.g_varchar2)

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)
1723: ) then

Line 1720: <> nvl(p_field,hr_api.g_varchar2)

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)
1723: ) then
1724: --

Line 1729: IF hr_api.not_exists_in_hr_lookups

1725: hr_utility.set_location(l_proc, 20);
1726: --
1727: -- Check that the category exists in HR_LOOKUPS
1728: --
1729: IF hr_api.not_exists_in_hr_lookups
1730: (p_effective_date => p_effective_date
1731: ,p_lookup_type => 'PER_QUAL_FWK_FIELD'
1732: ,p_lookup_code => p_field) THEN
1733: --

Line 1800: hr_api.g_varchar2)

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)
1804: ) then

Line 1801: <> nvl(p_sub_field,hr_api.g_varchar2)

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)
1804: ) then
1805: --

Line 1810: IF hr_api.not_exists_in_hr_lookups

1806: hr_utility.set_location(l_proc, 20);
1807: --
1808: -- Check that the category exists in HR_LOOKUPS
1809: --
1810: IF hr_api.not_exists_in_hr_lookups
1811: (p_effective_date => p_effective_date
1812: ,p_lookup_type => 'PER_QUAL_FWK_SUB_FIELD'
1813: ,p_lookup_code => p_sub_field) THEN
1814: --

Line 1881: hr_api.g_varchar2)

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)
1885: ) then

Line 1882: <> nvl(p_provider,hr_api.g_varchar2)

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)
1885: ) then
1886: --

Line 1891: IF hr_api.not_exists_in_hr_lookups

1887: hr_utility.set_location(l_proc, 20);
1888: --
1889: -- Check that the category exists in HR_LOOKUPS
1890: --
1891: IF hr_api.not_exists_in_hr_lookups
1892: (p_effective_date => p_effective_date
1893: ,p_lookup_type => 'PER_QUAL_FWK_PROVIDER'
1894: ,p_lookup_code => p_provider) THEN
1895: --

Line 1962: hr_api.g_varchar2)

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)
1966: ) then

Line 1963: <> nvl(p_qa_organization,hr_api.g_varchar2)

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)
1966: ) then
1967: --

Line 1972: IF hr_api.not_exists_in_hr_lookups

1968: hr_utility.set_location(l_proc, 20);
1969: --
1970: -- Check that the category exists in HR_LOOKUPS
1971: --
1972: IF hr_api.not_exists_in_hr_lookups
1973: (p_effective_date => p_effective_date
1974: ,p_lookup_type => 'PER_QUAL_FWK_QA_ORG'
1975: ,p_lookup_code => p_qa_organization) THEN
1976: --

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 2027: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
2031: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 2029: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
2033: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 2031: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
2035: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 2033: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
2037: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 2035: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
2039: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 2037: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
2041: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 2039: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
2043: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 2041: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
2045: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 2043: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
2047: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 2045: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
2049: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 2047: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
2051: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 2049: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
2053: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 2051: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
2055: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 2053: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
2057: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 2055: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
2059: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 2057: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
2061: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 2059: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
2063: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 2061: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
2065: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 2063: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
2067: nvl(p_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 2065: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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
2069: p_rec.competence_id is null)

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 2067: nvl(p_rec.attribute20, 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
2071: --

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 2167: nvl(p_rec.information_category, hr_api.g_varchar2) or

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) <>
2171: nvl(p_rec.information2, hr_api.g_varchar2) or

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 2169: nvl(p_rec.information1, hr_api.g_varchar2) or

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) <>
2173: nvl(p_rec.information3, hr_api.g_varchar2) or

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 2171: nvl(p_rec.information2, hr_api.g_varchar2) or

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) <>
2175: nvl(p_rec.information4, hr_api.g_varchar2) or

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 2173: nvl(p_rec.information3, hr_api.g_varchar2) or

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) <>
2177: nvl(p_rec.information5, hr_api.g_varchar2) or

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 2175: nvl(p_rec.information4, hr_api.g_varchar2) or

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) <>
2179: nvl(p_rec.information6, hr_api.g_varchar2) or

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 2177: nvl(p_rec.information5, hr_api.g_varchar2) or

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) <>
2181: nvl(p_rec.information7, hr_api.g_varchar2) or

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 2179: nvl(p_rec.information6, hr_api.g_varchar2) or

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) <>
2183: nvl(p_rec.information8, hr_api.g_varchar2) or

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 2181: nvl(p_rec.information7, hr_api.g_varchar2) or

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) <>
2185: nvl(p_rec.information9, hr_api.g_varchar2) or

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 2183: nvl(p_rec.information8, hr_api.g_varchar2) or

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) <>
2187: nvl(p_rec.information10, hr_api.g_varchar2) or

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 2185: nvl(p_rec.information9, hr_api.g_varchar2) or

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) <>
2189: nvl(p_rec.information11, hr_api.g_varchar2) or

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 2187: nvl(p_rec.information10, hr_api.g_varchar2) or

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) <>
2191: nvl(p_rec.information13, hr_api.g_varchar2) or

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 2189: nvl(p_rec.information11, hr_api.g_varchar2) or

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) <>
2193: nvl(p_rec.information14, hr_api.g_varchar2) or

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 2191: nvl(p_rec.information13, hr_api.g_varchar2) or

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) <>
2195: nvl(p_rec.information15, hr_api.g_varchar2) or

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 2193: nvl(p_rec.information14, hr_api.g_varchar2) or

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) <>
2197: nvl(p_rec.information16, hr_api.g_varchar2) or

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 2195: nvl(p_rec.information15, hr_api.g_varchar2) or

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) <>
2199: nvl(p_rec.information17, hr_api.g_varchar2) or

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 2197: nvl(p_rec.information16, hr_api.g_varchar2) or

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) <>
2201: nvl(p_rec.information18, hr_api.g_varchar2) or

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 2199: nvl(p_rec.information17, hr_api.g_varchar2) or

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) <>
2203: nvl(p_rec.information19, hr_api.g_varchar2) or

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 2201: nvl(p_rec.information18, hr_api.g_varchar2) or

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) <>
2205: nvl(p_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 2203: nvl(p_rec.information19, hr_api.g_varchar2) or

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))
2207: and hr_competences_api.g_ignore_df <> 'Y' then -- BUG3621261

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 2205: nvl(p_rec.information20, 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: --
2209: -- Only execute the validation if absolutely necessary:

Line 2279: hr_api.validate_bus_grp_id(p_rec.business_group_id);

2275: --
2276: -- Rule Check Business group is valid
2277: -- ngundura changes for pa requirements
2278: if p_rec.business_group_id is not null then
2279: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2280: end if;
2281: -- ngundura end of changes.
2282: hr_utility.set_location(l_proc, 10);
2283: --

Line 2358: hr_api.mandatory_arg_error (p_api_name => l_proc,

2354: ,p_renewal_period_units => p_rec.renewal_period_units
2355: ,p_renewal_period_frequency => p_rec.renewal_period_frequency
2356: );
2357: -- added by ngundura as part of global competence changes
2358: hr_api.mandatory_arg_error (p_api_name => l_proc,
2359: p_argument => 'competence_definition_id',
2360: p_argument_value => p_rec.competence_definition_id );
2361:
2362: hr_utility.set_location(l_proc, 40);

Line 2593: hr_api.mandatory_arg_error (p_api_name => l_proc,

2589: );
2590: --
2591: hr_utility.set_location(l_proc, 50);
2592: --
2593: hr_api.mandatory_arg_error (p_api_name => l_proc,
2594: p_argument => 'competence_definition_id',
2595: p_argument_value => p_rec.competence_definition_id );
2596: hr_utility.set_location(l_proc, 60);
2597: --

Line 2761: hr_api.mandatory_arg_error (p_api_name => l_proc,

2757: hr_utility.set_location('Entering:'||l_proc, 5);
2758: --
2759: -- Ensure that all the mandatory parameters are not null
2760: --
2761: hr_api.mandatory_arg_error (p_api_name => l_proc,
2762: p_argument => 'competence_id',
2763: p_argument_value => p_competence_id );
2764: --
2765: if nvl(g_competence_id, hr_api.g_number) = p_competence_id then

Line 2765: if nvl(g_competence_id, hr_api.g_number) = p_competence_id then

2761: hr_api.mandatory_arg_error (p_api_name => l_proc,
2762: p_argument => 'competence_id',
2763: p_argument_value => p_competence_id );
2764: --
2765: if nvl(g_competence_id, hr_api.g_number) = p_competence_id then
2766: --
2767: -- The legislation code has already been found with a previous
2768: -- call to this function. Just return the value in the global
2769: -- variable.