eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYR_BUS dependencies on PAY_PYR_SHD

Line 37: l_api_updating := pay_pyr_shd.api_updating

33: -- Only proceed with validation if :
34: -- a) The rate_basis is changing or new
35: -- b) The value for rate_uom is changing and not null
36: --
37: l_api_updating := pay_pyr_shd.api_updating
38: (p_rate_id => p_rate_id
39: ,p_object_version_number => p_object_version_number);
40: --
41: hr_utility.set_location(l_proc, 20);

Line 44: NVL(pay_pyr_shd.g_old_rec.rate_basis, hr_api.g_varchar2) <>

40: --
41: hr_utility.set_location(l_proc, 20);
42: --
43: IF ((l_api_updating AND
44: NVL(pay_pyr_shd.g_old_rec.rate_basis, hr_api.g_varchar2) <>
45: NVL(p_rate_basis, hr_api.g_varchar2) AND (p_rate_basis IS NOT NULL)) OR
46: (NOT l_api_updating and p_rate_basis IS NOT NULL)) THEN
47: --
48: hr_utility.set_location('g_old_rec.rate_basis'||pay_pyr_shd.g_old_rec.rate_basis,888);

Line 48: hr_utility.set_location('g_old_rec.rate_basis'||pay_pyr_shd.g_old_rec.rate_basis,888);

44: NVL(pay_pyr_shd.g_old_rec.rate_basis, hr_api.g_varchar2) <>
45: NVL(p_rate_basis, hr_api.g_varchar2) AND (p_rate_basis IS NOT NULL)) OR
46: (NOT l_api_updating and p_rate_basis IS NOT NULL)) THEN
47: --
48: hr_utility.set_location('g_old_rec.rate_basis'||pay_pyr_shd.g_old_rec.rate_basis,888);
49: hr_utility.set_location('p_rate_basis'||p_rate_basis,888);
50: -- Check that the rate basis exists in HR_LOOKUPS
51: --
52: IF hr_api.not_exists_in_hr_lookups

Line 106: l_api_updating := pay_pyr_shd.api_updating

102: -- Only proceed with validation if :
103: -- a) The rate_uom is changing or new
104: -- b) The value for rate_uom is changing and not null
105: --
106: l_api_updating := pay_pyr_shd.api_updating
107: (p_rate_id => p_rate_id
108: ,p_object_version_number => p_object_version_number);
109: --
110: hr_utility.set_location(l_proc, 20);

Line 113: NVL(pay_pyr_shd.g_old_rec.rate_uom, hr_api.g_varchar2) <>

109: --
110: hr_utility.set_location(l_proc, 20);
111: --
112: IF ((l_api_updating AND
113: NVL(pay_pyr_shd.g_old_rec.rate_uom, hr_api.g_varchar2) <>
114: NVL(p_rate_uom, hr_api.g_varchar2) AND (p_rate_uom IS NOT NULL)) OR
115: (NOT l_api_updating and p_rate_uom IS NOT NULL)) THEN
116: --
117: -- Check that the rate uom exists in HR_LOOKUPS

Line 173: l_api_updating := pay_pyr_shd.api_updating

169: -- Only proceed with validation if :
170: -- a) The rate_type is changing or new
171: -- b) The value for rate_type is changing and not null
172: --
173: l_api_updating := pay_pyr_shd.api_updating
174: (p_rate_id => p_rate_id
175: ,p_object_version_number => p_object_version_number);
176: --
177: hr_utility.set_location(l_proc, 20);

Line 180: NVL(pay_pyr_shd.g_old_rec.rate_type, hr_api.g_varchar2) <>

176: --
177: hr_utility.set_location(l_proc, 20);
178: --
179: IF ((l_api_updating AND
180: NVL(pay_pyr_shd.g_old_rec.rate_type, hr_api.g_varchar2) <>
181: NVL(p_rate_type, hr_api.g_varchar2) AND (p_rate_type IS NOT NULL)) OR
182: (NOT l_api_updating and p_rate_type IS NOT NULL)) THEN
183: --
184: -- Check that the rate type exists in HR_LOOKUPS

Line 267: l_api_updating := pay_pyr_shd.api_updating

263: -- Only proceed with validation if :
264: -- a) The name is changing or new
265: -- b) The value for name is changing and not null
266: --
267: l_api_updating := pay_pyr_shd.api_updating
268: (p_rate_id => p_rate_id
269: ,p_object_version_number => p_object_version_number);
270: --
271: hr_utility.set_location(l_proc||'/'||p_business_group_id, 20);

Line 274: NVL(pay_pyr_shd.g_old_rec.name, hr_api.g_varchar2) <>

270: --
271: hr_utility.set_location(l_proc||'/'||p_business_group_id, 20);
272: --
273: IF ((l_api_updating AND
274: NVL(pay_pyr_shd.g_old_rec.name, hr_api.g_varchar2) <>
275: NVL(p_name, hr_api.g_varchar2) AND (p_Name IS NOT NULL)) OR
276: (NOT l_api_updating and p_name IS NOT NULL)) THEN
277: --
278: hr_utility.set_location(l_proc, 30);

Line 527: l_api_updating := pay_pyr_shd.api_updating

523: -- Only proceed with validation if :
524: -- a) The parent_spine_id is changing or new
525: -- b) The value for parent_spine_id is changing and not null
526: --
527: l_api_updating := pay_pyr_shd.api_updating
528: (p_rate_id => p_rate_id
529: ,p_object_version_number => p_object_version_number);
530: --
531: hr_utility.set_location(l_proc, 20);

Line 534: NVL(pay_pyr_shd.g_old_rec.rate_id, hr_api.g_number) <>

530: --
531: hr_utility.set_location(l_proc, 20);
532: --
533: IF ((l_api_updating AND
534: NVL(pay_pyr_shd.g_old_rec.rate_id, hr_api.g_number) <>
535: NVL(p_rate_id, hr_api.g_number) AND (p_rate_id IS NOT NULL)) OR
536: (NOT l_api_updating and p_rate_id IS NOT NULL)) THEN
537: --
538: hr_utility.set_location(l_proc, 30);

Line 631: l_api_updating := pay_pyr_shd.api_updating

627: -- Only proceed with validation if :
628: -- a) Updating and the asg_rate_type is changing
629: -- b) Inserting
630: --
631: l_api_updating := pay_pyr_shd.api_updating
632: (p_rate_id => p_rate_id
633: ,p_object_version_number => p_object_version_number);
634: --
635: IF ((l_api_updating AND

Line 636: NVL(pay_pyr_shd.g_old_rec.asg_rate_type, hr_api.g_varchar2) <>

632: (p_rate_id => p_rate_id
633: ,p_object_version_number => p_object_version_number);
634: --
635: IF ((l_api_updating AND
636: NVL(pay_pyr_shd.g_old_rec.asg_rate_type, hr_api.g_varchar2) <>
637: NVL(p_asg_rate_type, hr_api.g_varchar2) AND (p_asg_rate_type IS NOT NULL)) OR
638: (NOT l_api_updating and p_rate_id IS NULL AND p_asg_rate_type IS NOT NULL)) THEN
639: --
640: -- check the asg_rate_type is valid in the lookup

Line 837: (p_rec IN pay_pyr_shd.g_rec_type

833: -- Internal Row Handler Use Only.
834: --
835: -- ----------------------------------------------------------------------------
836: procedure chk_df
837: (p_rec IN pay_pyr_shd.g_rec_type
838: ) IS
839: --
840: l_proc VARCHAR2(72) := g_package || 'chk_df';
841: --

Line 846: NVL(pay_pyr_shd.g_old_rec.attribute_category, hr_api.g_VARCHAR2) <>

842: BEGIN
843: hr_utility.set_location('Entering:'||l_proc,10);
844: --
845: IF ((p_rec.rate_id IS not NULL) AND (
846: NVL(pay_pyr_shd.g_old_rec.attribute_category, hr_api.g_VARCHAR2) <>
847: NVL(p_rec.attribute_category, hr_api.g_VARCHAR2) or
848: NVL(pay_pyr_shd.g_old_rec.attribute1, hr_api.g_VARCHAR2) <>
849: NVL(p_rec.attribute1, hr_api.g_VARCHAR2) or
850: NVL(pay_pyr_shd.g_old_rec.attribute2, hr_api.g_VARCHAR2) <>

Line 848: NVL(pay_pyr_shd.g_old_rec.attribute1, hr_api.g_VARCHAR2) <>

844: --
845: IF ((p_rec.rate_id IS not NULL) AND (
846: NVL(pay_pyr_shd.g_old_rec.attribute_category, hr_api.g_VARCHAR2) <>
847: NVL(p_rec.attribute_category, hr_api.g_VARCHAR2) or
848: NVL(pay_pyr_shd.g_old_rec.attribute1, hr_api.g_VARCHAR2) <>
849: NVL(p_rec.attribute1, hr_api.g_VARCHAR2) or
850: NVL(pay_pyr_shd.g_old_rec.attribute2, hr_api.g_VARCHAR2) <>
851: NVL(p_rec.attribute2, hr_api.g_VARCHAR2) or
852: NVL(pay_pyr_shd.g_old_rec.attribute3, hr_api.g_VARCHAR2) <>

Line 850: NVL(pay_pyr_shd.g_old_rec.attribute2, hr_api.g_VARCHAR2) <>

846: NVL(pay_pyr_shd.g_old_rec.attribute_category, hr_api.g_VARCHAR2) <>
847: NVL(p_rec.attribute_category, hr_api.g_VARCHAR2) or
848: NVL(pay_pyr_shd.g_old_rec.attribute1, hr_api.g_VARCHAR2) <>
849: NVL(p_rec.attribute1, hr_api.g_VARCHAR2) or
850: NVL(pay_pyr_shd.g_old_rec.attribute2, hr_api.g_VARCHAR2) <>
851: NVL(p_rec.attribute2, hr_api.g_VARCHAR2) or
852: NVL(pay_pyr_shd.g_old_rec.attribute3, hr_api.g_VARCHAR2) <>
853: NVL(p_rec.attribute3, hr_api.g_VARCHAR2) or
854: NVL(pay_pyr_shd.g_old_rec.attribute4, hr_api.g_VARCHAR2) <>

Line 852: NVL(pay_pyr_shd.g_old_rec.attribute3, hr_api.g_VARCHAR2) <>

848: NVL(pay_pyr_shd.g_old_rec.attribute1, hr_api.g_VARCHAR2) <>
849: NVL(p_rec.attribute1, hr_api.g_VARCHAR2) or
850: NVL(pay_pyr_shd.g_old_rec.attribute2, hr_api.g_VARCHAR2) <>
851: NVL(p_rec.attribute2, hr_api.g_VARCHAR2) or
852: NVL(pay_pyr_shd.g_old_rec.attribute3, hr_api.g_VARCHAR2) <>
853: NVL(p_rec.attribute3, hr_api.g_VARCHAR2) or
854: NVL(pay_pyr_shd.g_old_rec.attribute4, hr_api.g_VARCHAR2) <>
855: NVL(p_rec.attribute4, hr_api.g_VARCHAR2) or
856: NVL(pay_pyr_shd.g_old_rec.attribute5, hr_api.g_VARCHAR2) <>

Line 854: NVL(pay_pyr_shd.g_old_rec.attribute4, hr_api.g_VARCHAR2) <>

850: NVL(pay_pyr_shd.g_old_rec.attribute2, hr_api.g_VARCHAR2) <>
851: NVL(p_rec.attribute2, hr_api.g_VARCHAR2) or
852: NVL(pay_pyr_shd.g_old_rec.attribute3, hr_api.g_VARCHAR2) <>
853: NVL(p_rec.attribute3, hr_api.g_VARCHAR2) or
854: NVL(pay_pyr_shd.g_old_rec.attribute4, hr_api.g_VARCHAR2) <>
855: NVL(p_rec.attribute4, hr_api.g_VARCHAR2) or
856: NVL(pay_pyr_shd.g_old_rec.attribute5, hr_api.g_VARCHAR2) <>
857: NVL(p_rec.attribute5, hr_api.g_VARCHAR2) or
858: NVL(pay_pyr_shd.g_old_rec.attribute6, hr_api.g_VARCHAR2) <>

Line 856: NVL(pay_pyr_shd.g_old_rec.attribute5, hr_api.g_VARCHAR2) <>

852: NVL(pay_pyr_shd.g_old_rec.attribute3, hr_api.g_VARCHAR2) <>
853: NVL(p_rec.attribute3, hr_api.g_VARCHAR2) or
854: NVL(pay_pyr_shd.g_old_rec.attribute4, hr_api.g_VARCHAR2) <>
855: NVL(p_rec.attribute4, hr_api.g_VARCHAR2) or
856: NVL(pay_pyr_shd.g_old_rec.attribute5, hr_api.g_VARCHAR2) <>
857: NVL(p_rec.attribute5, hr_api.g_VARCHAR2) or
858: NVL(pay_pyr_shd.g_old_rec.attribute6, hr_api.g_VARCHAR2) <>
859: NVL(p_rec.attribute6, hr_api.g_VARCHAR2) or
860: NVL(pay_pyr_shd.g_old_rec.attribute7, hr_api.g_VARCHAR2) <>

Line 858: NVL(pay_pyr_shd.g_old_rec.attribute6, hr_api.g_VARCHAR2) <>

854: NVL(pay_pyr_shd.g_old_rec.attribute4, hr_api.g_VARCHAR2) <>
855: NVL(p_rec.attribute4, hr_api.g_VARCHAR2) or
856: NVL(pay_pyr_shd.g_old_rec.attribute5, hr_api.g_VARCHAR2) <>
857: NVL(p_rec.attribute5, hr_api.g_VARCHAR2) or
858: NVL(pay_pyr_shd.g_old_rec.attribute6, hr_api.g_VARCHAR2) <>
859: NVL(p_rec.attribute6, hr_api.g_VARCHAR2) or
860: NVL(pay_pyr_shd.g_old_rec.attribute7, hr_api.g_VARCHAR2) <>
861: NVL(p_rec.attribute7, hr_api.g_VARCHAR2) or
862: NVL(pay_pyr_shd.g_old_rec.attribute8, hr_api.g_VARCHAR2) <>

Line 860: NVL(pay_pyr_shd.g_old_rec.attribute7, hr_api.g_VARCHAR2) <>

856: NVL(pay_pyr_shd.g_old_rec.attribute5, hr_api.g_VARCHAR2) <>
857: NVL(p_rec.attribute5, hr_api.g_VARCHAR2) or
858: NVL(pay_pyr_shd.g_old_rec.attribute6, hr_api.g_VARCHAR2) <>
859: NVL(p_rec.attribute6, hr_api.g_VARCHAR2) or
860: NVL(pay_pyr_shd.g_old_rec.attribute7, hr_api.g_VARCHAR2) <>
861: NVL(p_rec.attribute7, hr_api.g_VARCHAR2) or
862: NVL(pay_pyr_shd.g_old_rec.attribute8, hr_api.g_VARCHAR2) <>
863: NVL(p_rec.attribute8, hr_api.g_VARCHAR2) or
864: NVL(pay_pyr_shd.g_old_rec.attribute9, hr_api.g_VARCHAR2) <>

Line 862: NVL(pay_pyr_shd.g_old_rec.attribute8, hr_api.g_VARCHAR2) <>

858: NVL(pay_pyr_shd.g_old_rec.attribute6, hr_api.g_VARCHAR2) <>
859: NVL(p_rec.attribute6, hr_api.g_VARCHAR2) or
860: NVL(pay_pyr_shd.g_old_rec.attribute7, hr_api.g_VARCHAR2) <>
861: NVL(p_rec.attribute7, hr_api.g_VARCHAR2) or
862: NVL(pay_pyr_shd.g_old_rec.attribute8, hr_api.g_VARCHAR2) <>
863: NVL(p_rec.attribute8, hr_api.g_VARCHAR2) or
864: NVL(pay_pyr_shd.g_old_rec.attribute9, hr_api.g_VARCHAR2) <>
865: NVL(p_rec.attribute9, hr_api.g_VARCHAR2) or
866: NVL(pay_pyr_shd.g_old_rec.attribute10, hr_api.g_VARCHAR2) <>

Line 864: NVL(pay_pyr_shd.g_old_rec.attribute9, hr_api.g_VARCHAR2) <>

860: NVL(pay_pyr_shd.g_old_rec.attribute7, hr_api.g_VARCHAR2) <>
861: NVL(p_rec.attribute7, hr_api.g_VARCHAR2) or
862: NVL(pay_pyr_shd.g_old_rec.attribute8, hr_api.g_VARCHAR2) <>
863: NVL(p_rec.attribute8, hr_api.g_VARCHAR2) or
864: NVL(pay_pyr_shd.g_old_rec.attribute9, hr_api.g_VARCHAR2) <>
865: NVL(p_rec.attribute9, hr_api.g_VARCHAR2) or
866: NVL(pay_pyr_shd.g_old_rec.attribute10, hr_api.g_VARCHAR2) <>
867: NVL(p_rec.attribute10, hr_api.g_VARCHAR2) or
868: NVL(pay_pyr_shd.g_old_rec.attribute11, hr_api.g_VARCHAR2) <>

Line 866: NVL(pay_pyr_shd.g_old_rec.attribute10, hr_api.g_VARCHAR2) <>

862: NVL(pay_pyr_shd.g_old_rec.attribute8, hr_api.g_VARCHAR2) <>
863: NVL(p_rec.attribute8, hr_api.g_VARCHAR2) or
864: NVL(pay_pyr_shd.g_old_rec.attribute9, hr_api.g_VARCHAR2) <>
865: NVL(p_rec.attribute9, hr_api.g_VARCHAR2) or
866: NVL(pay_pyr_shd.g_old_rec.attribute10, hr_api.g_VARCHAR2) <>
867: NVL(p_rec.attribute10, hr_api.g_VARCHAR2) or
868: NVL(pay_pyr_shd.g_old_rec.attribute11, hr_api.g_VARCHAR2) <>
869: NVL(p_rec.attribute11, hr_api.g_VARCHAR2) or
870: NVL(pay_pyr_shd.g_old_rec.attribute12, hr_api.g_VARCHAR2) <>

Line 868: NVL(pay_pyr_shd.g_old_rec.attribute11, hr_api.g_VARCHAR2) <>

864: NVL(pay_pyr_shd.g_old_rec.attribute9, hr_api.g_VARCHAR2) <>
865: NVL(p_rec.attribute9, hr_api.g_VARCHAR2) or
866: NVL(pay_pyr_shd.g_old_rec.attribute10, hr_api.g_VARCHAR2) <>
867: NVL(p_rec.attribute10, hr_api.g_VARCHAR2) or
868: NVL(pay_pyr_shd.g_old_rec.attribute11, hr_api.g_VARCHAR2) <>
869: NVL(p_rec.attribute11, hr_api.g_VARCHAR2) or
870: NVL(pay_pyr_shd.g_old_rec.attribute12, hr_api.g_VARCHAR2) <>
871: NVL(p_rec.attribute12, hr_api.g_VARCHAR2) or
872: NVL(pay_pyr_shd.g_old_rec.attribute13, hr_api.g_VARCHAR2) <>

Line 870: NVL(pay_pyr_shd.g_old_rec.attribute12, hr_api.g_VARCHAR2) <>

866: NVL(pay_pyr_shd.g_old_rec.attribute10, hr_api.g_VARCHAR2) <>
867: NVL(p_rec.attribute10, hr_api.g_VARCHAR2) or
868: NVL(pay_pyr_shd.g_old_rec.attribute11, hr_api.g_VARCHAR2) <>
869: NVL(p_rec.attribute11, hr_api.g_VARCHAR2) or
870: NVL(pay_pyr_shd.g_old_rec.attribute12, hr_api.g_VARCHAR2) <>
871: NVL(p_rec.attribute12, hr_api.g_VARCHAR2) or
872: NVL(pay_pyr_shd.g_old_rec.attribute13, hr_api.g_VARCHAR2) <>
873: NVL(p_rec.attribute13, hr_api.g_VARCHAR2) or
874: NVL(pay_pyr_shd.g_old_rec.attribute14, hr_api.g_VARCHAR2) <>

Line 872: NVL(pay_pyr_shd.g_old_rec.attribute13, hr_api.g_VARCHAR2) <>

868: NVL(pay_pyr_shd.g_old_rec.attribute11, hr_api.g_VARCHAR2) <>
869: NVL(p_rec.attribute11, hr_api.g_VARCHAR2) or
870: NVL(pay_pyr_shd.g_old_rec.attribute12, hr_api.g_VARCHAR2) <>
871: NVL(p_rec.attribute12, hr_api.g_VARCHAR2) or
872: NVL(pay_pyr_shd.g_old_rec.attribute13, hr_api.g_VARCHAR2) <>
873: NVL(p_rec.attribute13, hr_api.g_VARCHAR2) or
874: NVL(pay_pyr_shd.g_old_rec.attribute14, hr_api.g_VARCHAR2) <>
875: NVL(p_rec.attribute14, hr_api.g_VARCHAR2) or
876: NVL(pay_pyr_shd.g_old_rec.attribute15, hr_api.g_VARCHAR2) <>

Line 874: NVL(pay_pyr_shd.g_old_rec.attribute14, hr_api.g_VARCHAR2) <>

870: NVL(pay_pyr_shd.g_old_rec.attribute12, hr_api.g_VARCHAR2) <>
871: NVL(p_rec.attribute12, hr_api.g_VARCHAR2) or
872: NVL(pay_pyr_shd.g_old_rec.attribute13, hr_api.g_VARCHAR2) <>
873: NVL(p_rec.attribute13, hr_api.g_VARCHAR2) or
874: NVL(pay_pyr_shd.g_old_rec.attribute14, hr_api.g_VARCHAR2) <>
875: NVL(p_rec.attribute14, hr_api.g_VARCHAR2) or
876: NVL(pay_pyr_shd.g_old_rec.attribute15, hr_api.g_VARCHAR2) <>
877: NVL(p_rec.attribute15, hr_api.g_VARCHAR2) or
878: NVL(pay_pyr_shd.g_old_rec.attribute16, hr_api.g_VARCHAR2) <>

Line 876: NVL(pay_pyr_shd.g_old_rec.attribute15, hr_api.g_VARCHAR2) <>

872: NVL(pay_pyr_shd.g_old_rec.attribute13, hr_api.g_VARCHAR2) <>
873: NVL(p_rec.attribute13, hr_api.g_VARCHAR2) or
874: NVL(pay_pyr_shd.g_old_rec.attribute14, hr_api.g_VARCHAR2) <>
875: NVL(p_rec.attribute14, hr_api.g_VARCHAR2) or
876: NVL(pay_pyr_shd.g_old_rec.attribute15, hr_api.g_VARCHAR2) <>
877: NVL(p_rec.attribute15, hr_api.g_VARCHAR2) or
878: NVL(pay_pyr_shd.g_old_rec.attribute16, hr_api.g_VARCHAR2) <>
879: NVL(p_rec.attribute16, hr_api.g_VARCHAR2) or
880: NVL(pay_pyr_shd.g_old_rec.attribute17, hr_api.g_VARCHAR2) <>

Line 878: NVL(pay_pyr_shd.g_old_rec.attribute16, hr_api.g_VARCHAR2) <>

874: NVL(pay_pyr_shd.g_old_rec.attribute14, hr_api.g_VARCHAR2) <>
875: NVL(p_rec.attribute14, hr_api.g_VARCHAR2) or
876: NVL(pay_pyr_shd.g_old_rec.attribute15, hr_api.g_VARCHAR2) <>
877: NVL(p_rec.attribute15, hr_api.g_VARCHAR2) or
878: NVL(pay_pyr_shd.g_old_rec.attribute16, hr_api.g_VARCHAR2) <>
879: NVL(p_rec.attribute16, hr_api.g_VARCHAR2) or
880: NVL(pay_pyr_shd.g_old_rec.attribute17, hr_api.g_VARCHAR2) <>
881: NVL(p_rec.attribute17, hr_api.g_VARCHAR2) or
882: NVL(pay_pyr_shd.g_old_rec.attribute18, hr_api.g_VARCHAR2) <>

Line 880: NVL(pay_pyr_shd.g_old_rec.attribute17, hr_api.g_VARCHAR2) <>

876: NVL(pay_pyr_shd.g_old_rec.attribute15, hr_api.g_VARCHAR2) <>
877: NVL(p_rec.attribute15, hr_api.g_VARCHAR2) or
878: NVL(pay_pyr_shd.g_old_rec.attribute16, hr_api.g_VARCHAR2) <>
879: NVL(p_rec.attribute16, hr_api.g_VARCHAR2) or
880: NVL(pay_pyr_shd.g_old_rec.attribute17, hr_api.g_VARCHAR2) <>
881: NVL(p_rec.attribute17, hr_api.g_VARCHAR2) or
882: NVL(pay_pyr_shd.g_old_rec.attribute18, hr_api.g_VARCHAR2) <>
883: NVL(p_rec.attribute18, hr_api.g_VARCHAR2) or
884: NVL(pay_pyr_shd.g_old_rec.attribute19, hr_api.g_VARCHAR2) <>

Line 882: NVL(pay_pyr_shd.g_old_rec.attribute18, hr_api.g_VARCHAR2) <>

878: NVL(pay_pyr_shd.g_old_rec.attribute16, hr_api.g_VARCHAR2) <>
879: NVL(p_rec.attribute16, hr_api.g_VARCHAR2) or
880: NVL(pay_pyr_shd.g_old_rec.attribute17, hr_api.g_VARCHAR2) <>
881: NVL(p_rec.attribute17, hr_api.g_VARCHAR2) or
882: NVL(pay_pyr_shd.g_old_rec.attribute18, hr_api.g_VARCHAR2) <>
883: NVL(p_rec.attribute18, hr_api.g_VARCHAR2) or
884: NVL(pay_pyr_shd.g_old_rec.attribute19, hr_api.g_VARCHAR2) <>
885: NVL(p_rec.attribute19, hr_api.g_VARCHAR2) or
886: NVL(pay_pyr_shd.g_old_rec.attribute20, hr_api.g_VARCHAR2) <>

Line 884: NVL(pay_pyr_shd.g_old_rec.attribute19, hr_api.g_VARCHAR2) <>

880: NVL(pay_pyr_shd.g_old_rec.attribute17, hr_api.g_VARCHAR2) <>
881: NVL(p_rec.attribute17, hr_api.g_VARCHAR2) or
882: NVL(pay_pyr_shd.g_old_rec.attribute18, hr_api.g_VARCHAR2) <>
883: NVL(p_rec.attribute18, hr_api.g_VARCHAR2) or
884: NVL(pay_pyr_shd.g_old_rec.attribute19, hr_api.g_VARCHAR2) <>
885: NVL(p_rec.attribute19, hr_api.g_VARCHAR2) or
886: NVL(pay_pyr_shd.g_old_rec.attribute20, hr_api.g_VARCHAR2) <>
887: NVL(p_rec.attribute20, hr_api.g_VARCHAR2) ))
888: or (p_rec.rate_id IS NULL) THEN

Line 886: NVL(pay_pyr_shd.g_old_rec.attribute20, hr_api.g_VARCHAR2) <>

882: NVL(pay_pyr_shd.g_old_rec.attribute18, hr_api.g_VARCHAR2) <>
883: NVL(p_rec.attribute18, hr_api.g_VARCHAR2) or
884: NVL(pay_pyr_shd.g_old_rec.attribute19, hr_api.g_VARCHAR2) <>
885: NVL(p_rec.attribute19, hr_api.g_VARCHAR2) or
886: NVL(pay_pyr_shd.g_old_rec.attribute20, hr_api.g_VARCHAR2) <>
887: NVL(p_rec.attribute20, hr_api.g_VARCHAR2) ))
888: or (p_rec.rate_id IS NULL) THEN
889: --
890: -- Only execute the validation IF absolutely necessary:

Line 974: ,p_rec IN pay_pyr_shd.g_rec_type

970: -- {END OfComments}
971: -- ----------------------------------------------------------------------------
972: PROCEDURE chk_non_updateable_args
973: (p_effective_date IN DATE
974: ,p_rec IN pay_pyr_shd.g_rec_type
975: ) IS
976: --
977: l_proc VARCHAR2(72) := g_package || 'chk_non_updateable_args';
978: l_error EXCEPTION;

Line 988: IF NOT pay_pyr_shd.api_updating

984: --
985: -- Only proceed with the validation IF a row exists for the current
986: -- record IN the HR Schema.
987: --
988: IF NOT pay_pyr_shd.api_updating
989: (p_rate_id => p_rec.rate_id
990: ,p_object_version_number => p_rec.object_version_number
991: ) THEN
992: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1001: nvl(pay_pyr_shd.g_old_rec.business_group_id,hr_api.g_number) THEN

997: --
998: hr_utility.set_location(l_proc,20);
999: --
1000: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1001: nvl(pay_pyr_shd.g_old_rec.business_group_id,hr_api.g_number) THEN
1002: --
1003: l_argument := 'business_group_id';
1004: RAISE l_error;
1005: --

Line 1028: ,p_rec IN pay_pyr_shd.g_rec_type

1024: -- |---------------------------< insert_validate >----------------------------|
1025: -- ----------------------------------------------------------------------------
1026: PROCEDURE insert_validate
1027: (p_effective_date IN DATE
1028: ,p_rec IN pay_pyr_shd.g_rec_type
1029: ) IS
1030: --
1031: l_proc VARCHAR2(72) := g_package||'insert_validate';
1032: --

Line 1040: ,p_associated_column1 => pay_pyr_shd.g_tab_nam

1036: -- Call all supporting business operations
1037: --
1038: hr_api.validate_bus_grp_id
1039: (p_business_group_id => p_rec.business_group_id
1040: ,p_associated_column1 => pay_pyr_shd.g_tab_nam
1041: || '.BUSINESS_GROUP_ID');
1042: --
1043: -- After validating the set of important attributes,
1044: -- IF Multiple Message detection IS enabled AND at least

Line 1124: ,p_rec IN pay_pyr_shd.g_rec_type

1120: -- |---------------------------< update_validate >----------------------------|
1121: -- ----------------------------------------------------------------------------
1122: PROCEDURE update_validate
1123: (p_effective_date IN DATE
1124: ,p_rec IN pay_pyr_shd.g_rec_type
1125: ) IS
1126: --
1127: l_proc VARCHAR2(72) := g_package||'update_validate';
1128: --

Line 1137: ,p_associated_column1 => pay_pyr_shd.g_tab_nam

1133: -- Call all supporting business operations
1134: --
1135: hr_api.validate_bus_grp_id
1136: (p_business_group_id => p_rec.business_group_id
1137: ,p_associated_column1 => pay_pyr_shd.g_tab_nam
1138: || '.BUSINESS_GROUP_ID');
1139: --
1140: -- After validating the set of important attributes,
1141: -- IF Multiple Message detection IS enabled AND at least

Line 1228: (p_rec IN pay_pyr_shd.g_rec_type

1224: -- ----------------------------------------------------------------------------
1225: -- |---------------------------< delete_validate >----------------------------|
1226: -- ----------------------------------------------------------------------------
1227: PROCEDURE delete_validate
1228: (p_rec IN pay_pyr_shd.g_rec_type
1229: ) IS
1230: --
1231: l_proc VARCHAR2(72) := g_package||'delete_validate';
1232: --