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 237: -- this is nvl(cpe.effective_date_from,hr_api.g_sot) chnaged to

233: -- whether the from date of the competence element is later than the new
234: -- competence end date.
235:
236: -- bug fix 6207965
237: -- this is nvl(cpe.effective_date_from,hr_api.g_sot) chnaged to
238: -- nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot) in the
239: -- following cursor query, to meet the condition wen,cpe.effective_date_from
240: -- is coming as null.
241:

Line 238: -- nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot) in the

234: -- competence end date.
235:
236: -- bug fix 6207965
237: -- this is nvl(cpe.effective_date_from,hr_api.g_sot) chnaged to
238: -- nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot) in the
239: -- following cursor query, to meet the condition wen,cpe.effective_date_from
240: -- is coming as null.
241:
242: Cursor csr_check_dates_in_ele is

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

241:
242: Cursor csr_check_dates_in_ele is
243: select 'Y'
244: from per_competence_elements cpe
245: where ( nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot)) <
246: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
247: or nvl(cpe.effective_date_from,hr_api.g_sot) >
248: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
249: )

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

242: Cursor csr_check_dates_in_ele is
243: select 'Y'
244: from per_competence_elements cpe
245: where ( nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot)) <
246: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
247: or nvl(cpe.effective_date_from,hr_api.g_sot) >
248: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
249: )
250: and cpe.competence_id = p_competence_id

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

243: select 'Y'
244: from per_competence_elements cpe
245: where ( nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot)) <
246: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
247: or nvl(cpe.effective_date_from,hr_api.g_sot) >
248: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
249: )
250: and cpe.competence_id = p_competence_id
251: --adhunter reinstated the following check for 2533926

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

244: from per_competence_elements cpe
245: where ( nvl(cpe.effective_date_from,nvl(p_date_from,hr_api.g_sot)) <
246: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
247: or nvl(cpe.effective_date_from,hr_api.g_sot) >
248: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))
249: )
250: and cpe.competence_id = p_competence_id
251: --adhunter reinstated the following check for 2533926
252: and cpe.type not in

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

266: end if;
267: --
268: -- The date from has to be >= the date to, else error.
269: --
270: if (p_date_from > nvl(p_date_to,hr_api.g_eot)) then
271: --
272: hr_utility.set_message(801, 'HR_51599_CPN_DATE_TO_LATER');
273: hr_utility.raise_error;
274: --

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

350: hr_utility.set_location('Entering:'|| l_proc, 1);
351: --
352: -- Check mandatory parameters have been set
353: --
354: hr_api.mandatory_arg_error
355: (p_api_name => l_proc
356: ,p_argument => 'effective_date'
357: ,p_argument_value => p_effective_date
358: );

Line 369: hr_api.g_varchar2)

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

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

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)
373: ) then
374: --

Line 384: if hr_api.not_exists_in_hr_lookups

380: -- where the lookup_type = 'YES_NO'
381: --
382: --
383: if p_certification_required is not null then
384: if hr_api.not_exists_in_hr_lookups
385: (p_effective_date => p_effective_date
386: ,p_lookup_type => 'YES_NO'
387: ,p_lookup_code => p_certification_required
388: ) then

Line 449: hr_api.mandatory_arg_error

445: hr_utility.set_location('Entering:'|| l_proc, 1);
446: --
447: -- Check mandatory parameters have been set
448: --
449: hr_api.mandatory_arg_error
450: (p_api_name => l_proc
451: ,p_argument => 'effective_date'
452: ,p_argument_value => p_effective_date
453: );

Line 464: hr_api.g_varchar2)

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

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

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)
468: ) then
469: --

Line 481: if hr_api.not_exists_in_hrstanlookups

477: -- ngundura changes for pa requirements.
478: --
479: if p_evaluation_method is not null then
480: if p_business_group_id is null then
481: if hr_api.not_exists_in_hrstanlookups
482: (p_effective_date => p_effective_date
483: ,p_lookup_type => 'COMPETENCE_EVAL_TYPE'
484: ,p_lookup_code => p_evaluation_method
485: ) then

Line 490: if hr_api.not_exists_in_hr_lookups

486: hr_utility.set_message(801,'HR_51433_COMP_EVAL_METHOD');
487: hr_utility.raise_error;
488: end if;
489: else
490: if hr_api.not_exists_in_hr_lookups
491: (p_effective_date => p_effective_date
492: ,p_lookup_type => 'COMPETENCE_EVAL_TYPE'
493: ,p_lookup_code => p_evaluation_method
494: ) then

Line 556: hr_api.mandatory_arg_error

552: hr_utility.set_location('Entering:'|| l_proc, 1);
553: --
554: -- Check mandatory parameters have been set
555: --
556: hr_api.mandatory_arg_error
557: (p_api_name => l_proc
558: ,p_argument => 'effective_date'
559: ,p_argument_value => p_effective_date
560: );

Line 571: hr_api.g_varchar2)

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

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

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)
575: ) then
576: --

Line 591: -- if hr_api.not_exists_in_hr_lookups

587: --where the lookup_type = 'FREQUENCY'
588: --
589: --
590: if p_renewal_period_units is not null then
591: -- if hr_api.not_exists_in_hr_lookups
592: -- (p_effective_date => p_effective_date
593: -- ,p_lookup_type => 'UNITS'
594: -- ,p_lookup_code => p_renewal_period_units
595: -- ) then

Line 597: if hr_api.not_exists_in_hr_lookups

593: -- ,p_lookup_type => 'UNITS'
594: -- ,p_lookup_code => p_renewal_period_units
595: -- ) then
596: -- error invalid period units
597: if hr_api.not_exists_in_hr_lookups
598: (p_effective_date => p_effective_date
599: ,p_lookup_type => 'FREQUENCY'
600: ,p_lookup_code => p_renewal_period_units
601: ) then

Line 671: hr_api.g_varchar2)

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

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

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

Line 675: hr_api.g_number)

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

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

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

Line 763: hr_api.g_number)

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

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

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)
767: ) then
768: --

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

784: hr_utility.set_message(801,'HR_51453_COMP_DIFF_BUS_GRP');
785: hr_utility.raise_error;
786: end if;
787: else
788: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id and l_business_group_id is not null then
789: hr_utility.set_message(801,'HR_51453_COMP_DIFF_BUS_GRP');
790: hr_utility.raise_error;
791: end if;
792: end if;

Line 864: hr_api.g_number)

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

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

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)
868: ) then
869: --

Line 949: hr_api.g_number)

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

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

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)
953: ) then
954: --

Line 1042: hr_api.g_number)

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

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

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)
1046: ) then
1047: --

Line 1139: hr_api.mandatory_arg_error

1135: hr_utility.set_location('Entering:'|| l_proc, 1);
1136: --
1137: -- Check mandatory parameters have been set
1138: --
1139: hr_api.mandatory_arg_error
1140: (p_api_name => l_proc
1141: ,p_argument => 'competence_id'
1142: ,p_argument_value => p_competence_id
1143: );

Line 1286: hr_api.g_varchar2)

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

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

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)
1290: ) then
1291: --

Line 1296: IF hr_api.not_exists_in_hr_lookups

1292: hr_utility.set_location(l_proc, 20);
1293: --
1294: -- Check that the category exists in HR_LOOKUPS
1295: --
1296: IF hr_api.not_exists_in_hr_lookups
1297: (p_effective_date => p_effective_date
1298: ,p_lookup_type => 'PER_COMPETENCE_CLUSTER'
1299: ,p_lookup_code => p_competence_cluster) THEN
1300: --

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

1354: cursor csr_local_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id
1357: and business_group_id = p_business_group_id
1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1359: --
1360: cursor csr_global_unit_standard_id is
1361: select 1 from per_competences
1362: where unit_standard_id = p_unit_standard_id

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

1359: --
1360: cursor csr_global_unit_standard_id is
1361: select 1 from per_competences
1362: where unit_standard_id = p_unit_standard_id
1363: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1364:
1365: l_proc varchar2(72) := g_package||'chk_unit_standard_id';
1366: l_api_updating boolean;
1367: l_exists varchar2(1);

Line 1382: hr_api.g_varchar2)

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

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

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)
1386: ) then
1387: --

Line 1482: hr_api.g_varchar2)

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

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

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)
1486: ) then
1487: --

Line 1492: IF hr_api.not_exists_in_hr_lookups

1488: hr_utility.set_location(l_proc, 20);
1489: --
1490: -- Check that the category exists in HR_LOOKUPS
1491: --
1492: IF hr_api.not_exists_in_hr_lookups
1493: (p_effective_date => p_effective_date
1494: ,p_lookup_type => 'PER_QUAL_FWK_CREDIT_TYPE'
1495: ,p_lookup_code => p_credit_type) THEN
1496: --

Line 1563: hr_api.g_varchar2)

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

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

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)
1567: ) then
1568: --

Line 1573: IF hr_api.not_exists_in_hr_lookups

1569: hr_utility.set_location(l_proc, 20);
1570: --
1571: -- Check that the category exists in HR_LOOKUPS
1572: --
1573: IF hr_api.not_exists_in_hr_lookups
1574: (p_effective_date => p_effective_date
1575: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL_TYPE'
1576: ,p_lookup_code => p_level_type) THEN
1577: --

Line 1644: hr_api.g_number)

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

Line 1645: <> nvl(p_level_number,hr_api.g_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)
1648: ) then
1649: --

Line 1654: IF hr_api.not_exists_in_hr_lookups

1650: hr_utility.set_location(l_proc, 20);
1651: --
1652: -- Check that the category exists in HR_LOOKUPS
1653: --
1654: IF hr_api.not_exists_in_hr_lookups
1655: (p_effective_date => p_effective_date
1656: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL'
1657: ,p_lookup_code => p_level_number) THEN
1658: --

Line 1725: hr_api.g_varchar2)

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

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

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)
1729: ) then
1730: --

Line 1735: IF hr_api.not_exists_in_hr_lookups

1731: hr_utility.set_location(l_proc, 20);
1732: --
1733: -- Check that the category exists in HR_LOOKUPS
1734: --
1735: IF hr_api.not_exists_in_hr_lookups
1736: (p_effective_date => p_effective_date
1737: ,p_lookup_type => 'PER_QUAL_FWK_FIELD'
1738: ,p_lookup_code => p_field) THEN
1739: --

Line 1806: hr_api.g_varchar2)

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

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

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)
1810: ) then
1811: --

Line 1816: IF hr_api.not_exists_in_hr_lookups

1812: hr_utility.set_location(l_proc, 20);
1813: --
1814: -- Check that the category exists in HR_LOOKUPS
1815: --
1816: IF hr_api.not_exists_in_hr_lookups
1817: (p_effective_date => p_effective_date
1818: ,p_lookup_type => 'PER_QUAL_FWK_SUB_FIELD'
1819: ,p_lookup_code => p_sub_field) THEN
1820: --

Line 1887: hr_api.g_varchar2)

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

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

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)
1891: ) then
1892: --

Line 1897: IF hr_api.not_exists_in_hr_lookups

1893: hr_utility.set_location(l_proc, 20);
1894: --
1895: -- Check that the category exists in HR_LOOKUPS
1896: --
1897: IF hr_api.not_exists_in_hr_lookups
1898: (p_effective_date => p_effective_date
1899: ,p_lookup_type => 'PER_QUAL_FWK_PROVIDER'
1900: ,p_lookup_code => p_provider) THEN
1901: --

Line 1968: hr_api.g_varchar2)

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

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

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)
1972: ) then
1973: --

Line 1978: IF hr_api.not_exists_in_hr_lookups

1974: hr_utility.set_location(l_proc, 20);
1975: --
1976: -- Check that the category exists in HR_LOOKUPS
1977: --
1978: IF hr_api.not_exists_in_hr_lookups
1979: (p_effective_date => p_effective_date
1980: ,p_lookup_type => 'PER_QUAL_FWK_QA_ORG'
1981: ,p_lookup_code => p_qa_organization) THEN
1982: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 2073: nvl(p_rec.attribute20, 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
2077: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2281: --
2282: -- Rule Check Business group is valid
2283: -- ngundura changes for pa requirements
2284: if p_rec.business_group_id is not null then
2285: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2286: end if;
2287: -- ngundura end of changes.
2288: hr_utility.set_location(l_proc, 10);
2289: --

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

2360: ,p_renewal_period_units => p_rec.renewal_period_units
2361: ,p_renewal_period_frequency => p_rec.renewal_period_frequency
2362: );
2363: -- added by ngundura as part of global competence changes
2364: hr_api.mandatory_arg_error (p_api_name => l_proc,
2365: p_argument => 'competence_definition_id',
2366: p_argument_value => p_rec.competence_definition_id );
2367:
2368: hr_utility.set_location(l_proc, 40);

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

2595: );
2596: --
2597: hr_utility.set_location(l_proc, 50);
2598: --
2599: hr_api.mandatory_arg_error (p_api_name => l_proc,
2600: p_argument => 'competence_definition_id',
2601: p_argument_value => p_rec.competence_definition_id );
2602: hr_utility.set_location(l_proc, 60);
2603: --

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

2763: hr_utility.set_location('Entering:'||l_proc, 5);
2764: --
2765: -- Ensure that all the mandatory parameters are not null
2766: --
2767: hr_api.mandatory_arg_error (p_api_name => l_proc,
2768: p_argument => 'competence_id',
2769: p_argument_value => p_competence_id );
2770: --
2771: if nvl(g_competence_id, hr_api.g_number) = p_competence_id then

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

2767: hr_api.mandatory_arg_error (p_api_name => l_proc,
2768: p_argument => 'competence_id',
2769: p_argument_value => p_competence_id );
2770: --
2771: if nvl(g_competence_id, hr_api.g_number) = p_competence_id then
2772: --
2773: -- The legislation code has already been found with a previous
2774: -- call to this function. Just return the value in the global
2775: -- variable.