APPS.BEN_PTY_BUS dependencies on HR_API

Line 57: and nvl(p_pl_pcp_typ_id,hr_api.g_number)

53: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating
57: and nvl(p_pl_pcp_typ_id,hr_api.g_number)
58: <> ben_pty_shd.g_old_rec.pl_pcp_typ_id) then
59: --
60: -- raise error as PK has changed
61: --

Line 129: and nvl(p_pl_pcp_id,hr_api.g_number)

125: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_pl_pcp_id,hr_api.g_number)
130: <> nvl(ben_pty_shd.g_old_rec.pl_pcp_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if pl_pcp_id value exists in ben_pl_pcp table

Line 130: <> nvl(ben_pty_shd.g_old_rec.pl_pcp_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_pl_pcp_id,hr_api.g_number)
130: <> nvl(ben_pty_shd.g_old_rec.pl_pcp_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if pl_pcp_id value exists in ben_pl_pcp table
134: --

Line 205: and p_pcp_typ_cd <> nvl(ben_pty_shd.g_old_rec.pcp_typ_cd,hr_api.g_varchar2)

201: fnd_message.set_token('FIELD', 'PCP Type');
202: fnd_message.raise_error;
203: end if;
204: if (l_api_updating
205: and p_pcp_typ_cd <> nvl(ben_pty_shd.g_old_rec.pcp_typ_cd,hr_api.g_varchar2)
206: or not l_api_updating)
207: and p_pcp_typ_cd is not null then
208: --
209: -- check if value of lookup falls within lookup type.

Line 211: if hr_api.not_exists_in_hr_lookups

207: and p_pcp_typ_cd is not null then
208: --
209: -- check if value of lookup falls within lookup type.
210: --
211: if hr_api.not_exists_in_hr_lookups
212: (p_lookup_type => 'BEN_PCP_SPCLTY',
213: p_lookup_code => p_pcp_typ_cd,
214: p_effective_date => p_effective_date) then
215: --

Line 283: and p_gndr_alwd_cd <> nvl(ben_pty_shd.g_old_rec.gndr_alwd_cd,hr_api.g_varchar2)

279: fnd_message.set_token('FIELD', 'Maximum Age or Minimum Age or Gender');
280: fnd_message.raise_error;
281: end if;
282: if (l_api_updating
283: and p_gndr_alwd_cd <> nvl(ben_pty_shd.g_old_rec.gndr_alwd_cd,hr_api.g_varchar2)
284: or not l_api_updating)
285: and p_gndr_alwd_cd is not null then
286: --
287: -- check if value of lookup falls within lookup type.

Line 289: if hr_api.not_exists_in_hr_lookups

285: and p_gndr_alwd_cd is not null then
286: --
287: -- check if value of lookup falls within lookup type.
288: --
289: if hr_api.not_exists_in_hr_lookups
290: (p_lookup_type => 'SEX',
291: p_lookup_code => p_gndr_alwd_cd,
292: p_effective_date => p_effective_date) then
293: --

Line 390: hr_api.mandatory_arg_error

386: hr_utility.set_location('Entering:'|| l_proc, 10);
387: --
388: -- Ensure that all the mandatory parameter are not null
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc
392: ,p_argument => 'pl_pcp_typ_id'
393: ,p_argument_value => p_pl_pcp_typ_id
394: );

Line 413: hr_api.set_security_group_id

409: close csr_sec_grp;
410: --
411: -- Set the security_group_id in CLIENT_INFO
412: --
413: hr_api.set_security_group_id
414: (p_security_group_id => l_security_group_id
415: );
416: --
417: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 450: hr_api.mandatory_arg_error

446: hr_utility.set_location('Entering:'|| l_proc, 10);
447: --
448: -- Ensure that all the mandatory parameter are not null
449: --
450: hr_api.mandatory_arg_error
451: (p_api_name => l_proc
452: ,p_argument => 'pl_pcp_typ_id'
453: ,p_argument_value => p_pl_pcp_typ_id
454: );

Line 456: if ( nvl(ben_pty_bus.g_pl_pcp_typ_id, hr_api.g_number)

452: ,p_argument => 'pl_pcp_typ_id'
453: ,p_argument_value => p_pl_pcp_typ_id
454: );
455: --
456: if ( nvl(ben_pty_bus.g_pl_pcp_typ_id, hr_api.g_number)
457: = p_pl_pcp_typ_id) then
458: --
459: -- The legislation code has already been found with a previous
460: -- call to this function. Just return the value in the global

Line 532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>

528: begin
529: hr_utility.set_location('Entering:'||l_proc,10);
530: --
531: if ((p_rec.pl_pcp_typ_id is not null) and (
532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>

Line 533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or

529: hr_utility.set_location('Entering:'||l_proc,10);
530: --
531: if ((p_rec.pl_pcp_typ_id is not null) and (
532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or

Line 534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>

530: --
531: if ((p_rec.pl_pcp_typ_id is not null) and (
532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>

Line 535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or

531: if ((p_rec.pl_pcp_typ_id is not null) and (
532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or

Line 536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>

532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>

Line 537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or

533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or

Line 538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>

534: nvl(ben_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>

Line 539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or

535: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or

Line 540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>

536: nvl(ben_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>

Line 541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or

537: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or

Line 542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>

538: nvl(ben_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>

Line 543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or

539: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or

Line 544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>

540: nvl(ben_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>

Line 545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or

541: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or

Line 546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>

542: nvl(ben_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>

Line 547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or

543: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or

Line 548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>

544: nvl(ben_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>

Line 549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or

545: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or

Line 550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>

546: nvl(ben_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>

Line 551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or

547: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or

Line 552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>

548: nvl(ben_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>

Line 553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or

549: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or

Line 554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>

550: nvl(ben_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>

Line 555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or

551: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or

Line 556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>

552: nvl(ben_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>

Line 557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or

553: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or

Line 558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>

554: nvl(ben_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>

Line 559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or

555: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or

Line 560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>

556: nvl(ben_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>

Line 561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or

557: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or

Line 562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>

558: nvl(ben_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>

Line 563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or

559: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or

Line 564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>

560: nvl(ben_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>

Line 565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or

561: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or

Line 566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>

562: nvl(ben_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>

Line 567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or

563: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or

Line 568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>

564: nvl(ben_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>

Line 569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or

565: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or

Line 570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>

566: nvl(ben_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>

Line 571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or

567: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or

Line 572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>

568: nvl(ben_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>

Line 573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or

569: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or

Line 574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>

570: nvl(ben_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>

Line 575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or

571: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or

Line 576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>

572: nvl(ben_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>

Line 577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or

573: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) or
574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or

Line 578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>

574: nvl(ben_pty_shd.g_old_rec.pty_attribute21, hr_api.g_varchar2) <>
575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>

Line 579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or

575: nvl(p_rec.pty_attribute21, hr_api.g_varchar2) or
576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or

Line 580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>

576: nvl(ben_pty_shd.g_old_rec.pty_attribute22, hr_api.g_varchar2) <>
577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>

Line 581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or

577: nvl(p_rec.pty_attribute22, hr_api.g_varchar2) or
578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or

Line 582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>

578: nvl(ben_pty_shd.g_old_rec.pty_attribute23, hr_api.g_varchar2) <>
579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>

Line 583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or

579: nvl(p_rec.pty_attribute23, hr_api.g_varchar2) or
580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or

Line 584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>

580: nvl(ben_pty_shd.g_old_rec.pty_attribute24, hr_api.g_varchar2) <>
581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>

Line 585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or

581: nvl(p_rec.pty_attribute24, hr_api.g_varchar2) or
582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or

Line 586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>

582: nvl(ben_pty_shd.g_old_rec.pty_attribute25, hr_api.g_varchar2) <>
583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>

Line 587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or

583: nvl(p_rec.pty_attribute25, hr_api.g_varchar2) or
584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or

Line 588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>

584: nvl(ben_pty_shd.g_old_rec.pty_attribute26, hr_api.g_varchar2) <>
585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or
592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>

Line 589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or

585: nvl(p_rec.pty_attribute26, hr_api.g_varchar2) or
586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or
592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>
593: nvl(p_rec.pty_attribute30, hr_api.g_varchar2) ))

Line 590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>

586: nvl(ben_pty_shd.g_old_rec.pty_attribute27, hr_api.g_varchar2) <>
587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or
592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>
593: nvl(p_rec.pty_attribute30, hr_api.g_varchar2) ))
594: or (p_rec.pl_pcp_typ_id is null) then

Line 591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or

587: nvl(p_rec.pty_attribute27, hr_api.g_varchar2) or
588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or
592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>
593: nvl(p_rec.pty_attribute30, hr_api.g_varchar2) ))
594: or (p_rec.pl_pcp_typ_id is null) then
595: --

Line 592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>

588: nvl(ben_pty_shd.g_old_rec.pty_attribute28, hr_api.g_varchar2) <>
589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or
592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>
593: nvl(p_rec.pty_attribute30, hr_api.g_varchar2) ))
594: or (p_rec.pl_pcp_typ_id is null) then
595: --
596: -- Only execute the validation if absolutely necessary:

Line 593: nvl(p_rec.pty_attribute30, hr_api.g_varchar2) ))

589: nvl(p_rec.pty_attribute28, hr_api.g_varchar2) or
590: nvl(ben_pty_shd.g_old_rec.pty_attribute29, hr_api.g_varchar2) <>
591: nvl(p_rec.pty_attribute29, hr_api.g_varchar2) or
592: nvl(ben_pty_shd.g_old_rec.pty_attribute30, hr_api.g_varchar2) <>
593: nvl(p_rec.pty_attribute30, hr_api.g_varchar2) ))
594: or (p_rec.pl_pcp_typ_id is null) then
595: --
596: -- Only execute the validation if absolutely necessary:
597: -- a) During update, the structure column value or any

Line 726: hr_api.argument_changed_error

722: -- not been updated.
723: --
724: EXCEPTION
725: WHEN l_error THEN
726: hr_api.argument_changed_error
727: (p_api_name => l_proc
728: ,p_argument => l_argument);
729: WHEN OTHERS THEN
730: RAISE;

Line 770: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

766: p_object_version_number => p_rec.object_version_number);
767:
768: chk_pl_pcp_typ_record ( p_pl_pcp_id => p_rec.pl_pcp_id);
769:
770: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
771: --
772: --
773: --ben_pty_bus.chk_df(p_rec);
774: --

Line 814: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

810: p_object_version_number => p_rec.object_version_number);
811:
812: chk_pl_pcp_typ_record ( p_pl_pcp_id => p_rec.pl_pcp_id);
813:
814: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
815: --
816: chk_non_updateable_args
817: (p_rec => p_rec
818: );