APPS.BEN_PTY_BUS dependencies on BEN_PTY_SHD

Line 52: l_api_updating := ben_pty_shd.api_updating

48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := ben_pty_shd.api_updating
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

Line 58: <> ben_pty_shd.g_old_rec.pl_pcp_typ_id) then

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: --
62: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

Line 62: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

58: <> ben_pty_shd.g_old_rec.pl_pcp_typ_id) then
59: --
60: -- raise error as PK has changed
61: --
62: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 72: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

68: if p_pl_pcp_typ_id is not null then
69: --
70: -- raise error as PK is not null
71: --
72: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');
73: --
74: end if;
75: --
76: end if;

Line 124: l_api_updating := ben_pty_shd.api_updating

120: Begin
121: --
122: hr_utility.set_location('Entering:'||l_proc,5);
123: --
124: l_api_updating := ben_pty_shd.api_updating
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

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 145: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_FK2');

141: --
142: -- raise error as FK does not relate to PK in ben_pl_pcp
143: -- table.
144: --
145: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_FK2');
146: --
147: end if;
148: --
149: close c1;

Line 195: l_api_updating := ben_pty_shd.api_updating

191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_pty_shd.api_updating
196: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
197: p_object_version_number => p_object_version_number);
198: --
199: if p_pcp_typ_cd is null then

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 272: l_api_updating := ben_pty_shd.api_updating

268: Begin
269: --
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: l_api_updating := ben_pty_shd.api_updating
273: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
274: p_object_version_number => p_object_version_number);
275: --
276: if p_gndr_alwd_cd is null and p_min_age is null and p_max_age is null

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 523: (p_rec in ben_pty_shd.g_rec_type

519: -- Internal Row Handler Use Only.
520: --
521: -- ----------------------------------------------------------------------------
522: procedure chk_df
523: (p_rec in ben_pty_shd.g_rec_type
524: ) is
525: --
526: l_proc varchar2(72) := g_package || 'chk_df';
527: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 699: (p_rec in ben_pty_shd.g_rec_type

695: --
696: -- {End Of Comments}
697: -- ----------------------------------------------------------------------------
698: Procedure chk_non_updateable_args
699: (p_rec in ben_pty_shd.g_rec_type
700: ) IS
701: --
702: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
703: l_error EXCEPTION;

Line 711: IF NOT ben_pty_shd.api_updating

707: --
708: -- Only proceed with the validation if a row exists for the current
709: -- record in the HR Schema.
710: --
711: IF NOT ben_pty_shd.api_updating
712: (p_pl_pcp_typ_id => p_rec.pl_pcp_typ_id
713: ,p_object_version_number => p_rec.object_version_number
714: ) THEN
715: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 737: (p_rec in ben_pty_shd.g_rec_type ,

733: -- ----------------------------------------------------------------------------
734: -- |---------------------------< insert_validate >----------------------------|
735: -- ----------------------------------------------------------------------------
736: Procedure insert_validate
737: (p_rec in ben_pty_shd.g_rec_type ,
738: p_effective_date in date) is
739: --
740: l_proc varchar2(72) := g_package||'insert_validate';
741: --

Line 782: (p_rec in ben_pty_shd.g_rec_type

778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< update_validate >----------------------------|
780: -- ----------------------------------------------------------------------------
781: Procedure update_validate
782: (p_rec in ben_pty_shd.g_rec_type
783: ,p_effective_date in date) is
784: --
785: l_proc varchar2(72) := g_package||'update_validate';
786: --

Line 830: (p_rec in ben_pty_shd.g_rec_type

826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< delete_validate >----------------------------|
828: -- ----------------------------------------------------------------------------
829: Procedure delete_validate
830: (p_rec in ben_pty_shd.g_rec_type
831: ) is
832: --
833: l_proc varchar2(72) := g_package||'delete_validate';
834: --