APPS.PER_SUB_BUS dependencies on PER_SUB_SHD

Line 44: l_api_updating := per_sub_shd.api_updating

40: Begin
41: --
42: hr_utility.set_location('Entering:'||l_proc,5);
43: --
44: l_api_updating := per_sub_shd.api_updating
45: (p_subjects_taken_id => p_subjects_taken_id,
46: p_object_version_number => p_object_version_number);
47: --
48: if (l_api_updating

Line 50: <> per_sub_shd.g_old_rec.subjects_taken_id) then

46: p_object_version_number => p_object_version_number);
47: --
48: if (l_api_updating
49: and nvl(p_subjects_taken_id,hr_api.g_number)
50: <> per_sub_shd.g_old_rec.subjects_taken_id) then
51: --
52: -- raise error as PK has changed
53: --
54: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');

Line 54: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');

50: <> per_sub_shd.g_old_rec.subjects_taken_id) then
51: --
52: -- raise error as PK has changed
53: --
54: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');
55: --
56: elsif not l_api_updating then
57: --
58: -- check if PK is null

Line 64: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');

60: if p_subjects_taken_id is not null then
61: --
62: -- raise error as PK is not null
63: --
64: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');
65: --
66: end if;
67: --
68: end if;

Line 116: l_api_updating := per_sub_shd.api_updating

112: Begin
113: --
114: hr_utility.set_location('Entering:'||l_proc,5);
115: --
116: l_api_updating := per_sub_shd.api_updating
117: (p_subjects_taken_id => p_subjects_taken_id,
118: p_object_version_number => p_object_version_number);
119: --
120: if (l_api_updating

Line 122: <> per_sub_shd.g_old_rec.qualification_id

118: p_object_version_number => p_object_version_number);
119: --
120: if (l_api_updating
121: and nvl(p_qualification_id,hr_api.g_number)
122: <> per_sub_shd.g_old_rec.qualification_id
123: or not l_api_updating) then
124: --
125: -- check if qualification id exists in per_qualifications table.
126: -- it must also be a not null value.

Line 134: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_FK1');

130: fetch c1 into l_dummy;
131: if c1%notfound then
132: --
133: close c1;
134: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_FK1');
135: --
136: end if;
137: --
138: close c1;

Line 213: l_api_updating := per_sub_shd.api_updating

209: where per.qualification_id = p_qualification_id;
210: --
211: hr_utility.set_location('Entering:'||l_proc,5);
212: --
213: l_api_updating := per_sub_shd.api_updating
214: (p_subjects_taken_id => p_subjects_taken_id,
215: p_object_version_number => p_object_version_number);
216: --
217: if (l_api_updating

Line 221: <> per_sub_shd.g_old_rec.start_date

217: if (l_api_updating
218: /*
219: WWBUG 2502284 backport drove this.
220: and (nvl(p_start_date,hr_api.g_date)
221: <> per_sub_shd.g_old_rec.start_date
222: or nvl(p_end_date,hr_api.g_date)
223: <> per_sub_shd.g_old_rec.end_date)
224: */
225: or not l_api_updating) then

Line 223: <> per_sub_shd.g_old_rec.end_date)

219: WWBUG 2502284 backport drove this.
220: and (nvl(p_start_date,hr_api.g_date)
221: <> per_sub_shd.g_old_rec.start_date
222: or nvl(p_end_date,hr_api.g_date)
223: <> per_sub_shd.g_old_rec.end_date)
224: */
225: or not l_api_updating) then
226: --
227: -- check if start_date and end date fall within the dates of the

Line 249: per_sub_shd.constraint_error('PER_SUB_START_DATES');

245: -- Check if end date is greater than start date
246: --
247: if p_end_date < p_start_date then
248: --
249: per_sub_shd.constraint_error('PER_SUB_START_DATES');
250: --
251: end if;
252: --
253: if p_start_date > nvl(l_end_date,p_start_date) then

Line 338: l_api_updating := per_sub_shd.api_updating

334: where per.qualification_id = p_qualification_id;
335: --
336: hr_utility.set_location('Entering:'||l_proc,5);
337: --
338: l_api_updating := per_sub_shd.api_updating
339: (p_subjects_taken_id => p_subjects_taken_id,
340: p_object_version_number => p_object_version_number);
341: --
342: if (l_api_updating

Line 404: l_api_updating := per_sub_shd.api_updating

400: Begin
401: --
402: hr_utility.set_location('Entering:'||l_proc,5);
403: --
404: l_api_updating := per_sub_shd.api_updating
405: (p_subjects_taken_id => p_subjects_taken_id,
406: p_object_version_number => p_object_version_number);
407: --
408: if p_major is not null then --p_major is optional field.

Line 411: <> per_sub_shd.g_old_rec.major

407: --
408: if p_major is not null then --p_major is optional field.
409: if (l_api_updating
410: and nvl(p_major,hr_api.g_varchar2)
411: <> per_sub_shd.g_old_rec.major
412: or not l_api_updating) then
413: --
414: -- check if major exists in the lookup YES_NO.
415: --

Line 470: l_api_updating := per_sub_shd.api_updating

466: Begin
467: --
468: hr_utility.set_location('Entering:'||l_proc,5);
469: --
470: l_api_updating := per_sub_shd.api_updating
471: (p_subjects_taken_id => p_subjects_taken_id,
472: p_object_version_number => p_object_version_number);
473: --
474: if (l_api_updating

Line 476: <> per_sub_shd.g_old_rec.subject_status

472: p_object_version_number => p_object_version_number);
473: --
474: if (l_api_updating
475: and nvl(p_subject_status,hr_api.g_varchar2)
476: <> per_sub_shd.g_old_rec.subject_status
477: or not l_api_updating) then
478: --
479: -- check if subject_status exists in the lookup PER_SUBJECT_STATUSES.
480: --

Line 557: l_api_updating := per_sub_shd.api_updating

553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);
556: --
557: l_api_updating := per_sub_shd.api_updating
558: (p_subjects_taken_id => p_subjects_taken_id,
559: p_object_version_number => p_object_version_number);
560: --
561: if (l_api_updating

Line 563: <> per_sub_shd.g_old_rec.subject

559: p_object_version_number => p_object_version_number);
560: --
561: if (l_api_updating
562: and (nvl(p_subject,hr_api.g_varchar2)
563: <> per_sub_shd.g_old_rec.subject
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date

Line 565: <> per_sub_shd.g_old_rec.start_date

561: if (l_api_updating
562: and (nvl(p_subject,hr_api.g_varchar2)
563: <> per_sub_shd.g_old_rec.subject
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date
568: or nvl(p_qualification_id,hr_api.g_number)
569: <> per_sub_shd.g_old_rec.qualification_id)

Line 567: <> per_sub_shd.g_old_rec.end_date

563: <> per_sub_shd.g_old_rec.subject
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date
568: or nvl(p_qualification_id,hr_api.g_number)
569: <> per_sub_shd.g_old_rec.qualification_id)
570: or not l_api_updating) then
571: --

Line 569: <> per_sub_shd.g_old_rec.qualification_id)

565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date
568: or nvl(p_qualification_id,hr_api.g_number)
569: <> per_sub_shd.g_old_rec.qualification_id)
570: or not l_api_updating) then
571: --
572: -- check if subject exists in the lookup PER_SUBJECTS.
573: --

Line 641: (p_rec in per_sub_shd.g_rec_type) is

637: -- {End Of Comments}
638: -- ----------------------------------------------------------------------------
639: --
640: procedure chk_df
641: (p_rec in per_sub_shd.g_rec_type) is
642: --
643: l_proc varchar2(72) := g_package||'chk_df';
644: --
645: begin

Line 649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

645: begin
646: hr_utility.set_location('Entering:'||l_proc, 10);
647: --
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

647: --
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
691: or

Line 689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
691: or
692: (p_rec.subjects_taken_id is null) then
693: --

Line 776: (p_rec in per_sub_shd.g_rec_type

772: -- Internal Row Handler Use Only.
773: --
774: -- ----------------------------------------------------------------------------
775: procedure chk_ddf
776: (p_rec in per_sub_shd.g_rec_type
777: ) is
778: --
779: l_proc varchar2(72) := g_package || 'chk_ddf';
780: --

Line 785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>

781: begin
782: hr_utility.set_location('Entering:'||l_proc,10);
783: --
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>

Line 787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>

783: --
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>

Line 789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>

785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>

Line 791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>

787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>

Line 793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>

789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>

Line 795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>

791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>

Line 797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>

793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>

Line 799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>

795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>

Line 801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>

797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>

Line 803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>

799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>

Line 805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>

801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>

Line 807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>

803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>

Line 809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>

805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>

Line 811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>

807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>

Line 813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>

809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>

Line 815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>

811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>

Line 817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>

813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>

Line 819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>

815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>

Line 821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>

817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>

Line 823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>

819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
827: or (p_rec.subjects_taken_id is null) then

Line 825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>

821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
827: or (p_rec.subjects_taken_id is null) then
828: --
829: -- Only execute the validation if absolutely necessary:

Line 888: Procedure insert_validate(p_rec in per_sub_shd.g_rec_type,

884: --
885: -- ----------------------------------------------------------------------------
886: -- |---------------------------< insert_validate >----------------------------|
887: -- ----------------------------------------------------------------------------
888: Procedure insert_validate(p_rec in per_sub_shd.g_rec_type,
889: p_effective_date in date) is
890: --
891: l_proc varchar2(72) := g_package||'insert_validate';
892: --

Line 1000: Procedure update_validate(p_rec in per_sub_shd.g_rec_type,

996: --
997: -- ----------------------------------------------------------------------------
998: -- |---------------------------< update_validate >----------------------------|
999: -- ----------------------------------------------------------------------------
1000: Procedure update_validate(p_rec in per_sub_shd.g_rec_type,
1001: p_effective_date in date) is
1002: --
1003: l_proc varchar2(72) := g_package||'update_validate';
1004: --

Line 1109: Procedure delete_validate(p_rec in per_sub_shd.g_rec_type) is

1105: --
1106: -- ----------------------------------------------------------------------------
1107: -- |---------------------------< delete_validate >----------------------------|
1108: -- ----------------------------------------------------------------------------
1109: Procedure delete_validate(p_rec in per_sub_shd.g_rec_type) is
1110: --
1111: l_proc varchar2(72) := g_package||'delete_validate';
1112: --
1113: Begin