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 HR_API

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 45: NVL(p_rate_basis, hr_api.g_varchar2) AND (p_rate_basis IS NOT NULL)) OR

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);
49: hr_utility.set_location('p_rate_basis'||p_rate_basis,888);

Line 52: IF hr_api.not_exists_in_hr_lookups

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
53: (p_effective_date => p_effective_date
54: ,p_lookup_type => 'RATE_BASIS'
55: ,p_lookup_code => p_rate_basis) THEN
56: --

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 114: NVL(p_rate_uom, hr_api.g_varchar2) AND (p_rate_uom IS NOT NULL)) OR

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

Line 119: IF hr_api.not_exists_in_hr_lookups

115: (NOT l_api_updating and p_rate_uom IS NOT NULL)) THEN
116: --
117: -- Check that the rate uom exists in HR_LOOKUPS
118: --
119: IF hr_api.not_exists_in_hr_lookups
120: (p_effective_date => p_effective_date
121: ,p_lookup_type => 'UNITS'
122: ,p_lookup_code => p_rate_uom) THEN
123: --

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 181: NVL(p_rate_type, hr_api.g_varchar2) AND (p_rate_type IS NOT NULL)) OR

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

Line 186: IF hr_api.not_exists_in_hr_lookups

182: (NOT l_api_updating and p_rate_type IS NOT NULL)) THEN
183: --
184: -- Check that the rate type exists in HR_LOOKUPS
185: --
186: IF hr_api.not_exists_in_hr_lookups
187: (p_effective_date => p_effective_date
188: ,p_lookup_type => 'RATE_TYPE'
189: ,p_lookup_code => p_rate_type) THEN
190: --

Line 258: hr_api.mandatory_arg_error

254: BEGIN
255: --
256: hr_utility.set_location('Entering: '||l_proc,10);
257: --
258: hr_api.mandatory_arg_error
259: (p_api_name => l_proc
260: ,p_argument => 'name'
261: ,p_argument_value => p_name);
262: --

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 275: NVL(p_name, hr_api.g_varchar2) AND (p_Name IS NOT NULL)) OR

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);
279: --

Line 346: hr_api.mandatory_arg_error

342: BEGIN
343: --
344: hr_utility.set_location('Entering: '||l_proc,10);
345: --
346: hr_api.mandatory_arg_error
347: (p_api_name => l_proc
348: ,p_argument => 'rate_id'
349: ,p_argument_value => p_rate_id);
350: --

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 535: NVL(p_rate_id, hr_api.g_number) AND (p_rate_id IS NOT NULL)) OR

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);
539: --

Line 621: AND p_effective_date between nvl(start_date_active,hr_api.g_sot)

617: FROM fnd_lookups
618: WHERE lookup_type='PRICE DIFFERENTIALS'
619: AND lookup_code=p_asg_rate_type
620: AND enabled_flag='Y'
621: AND p_effective_date between nvl(start_date_active,hr_api.g_sot)
622: and nvl(end_date_active,hr_api.g_eot));
623: --
624: BEGIN
625: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 622: and nvl(end_date_active,hr_api.g_eot));

618: WHERE lookup_type='PRICE DIFFERENTIALS'
619: AND lookup_code=p_asg_rate_type
620: AND enabled_flag='Y'
621: AND p_effective_date between nvl(start_date_active,hr_api.g_sot)
622: and nvl(end_date_active,hr_api.g_eot));
623: --
624: BEGIN
625: hr_utility.set_location('Entering:'|| l_proc, 10);
626: --

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 637: NVL(p_asg_rate_type, hr_api.g_varchar2) AND (p_asg_rate_type IS NOT NULL)) OR

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

Line 700: hr_api.mandatory_arg_error

696: hr_utility.set_location('Entering:'|| l_proc, 10);
697: --
698: -- Ensure that all the mandatory parameter are not NULL
699: --
700: hr_api.mandatory_arg_error
701: (p_api_name => l_proc
702: ,p_argument => 'rate_id'
703: ,p_argument_value => p_rate_id
704: );

Line 726: hr_api.set_security_group_id

722: CLOSE csr_sec_grp;
723: --
724: -- Set the security_group_id IN CLIENT_INFO
725: --
726: hr_api.set_security_group_id
727: (p_security_group_id => l_security_group_id
728: );
729: END IF;
730: --

Line 764: hr_api.mandatory_arg_error

760: hr_utility.set_location('Entering:'|| l_proc, 10);
761: --
762: -- Ensure that all the mandatory parameter are not NULL
763: --
764: hr_api.mandatory_arg_error
765: (p_api_name => l_proc
766: ,p_argument => 'rate_id'
767: ,p_argument_value => p_rate_id
768: );

Line 770: IF ( NVL(pay_pyr_bus.g_rate_id, hr_api.g_number)

766: ,p_argument => 'rate_id'
767: ,p_argument_value => p_rate_id
768: );
769: --
770: IF ( NVL(pay_pyr_bus.g_rate_id, hr_api.g_number)
771: = p_rate_id) THEN
772: --
773: -- The legislation code has already been found with a previous
774: -- call to this function. Just RETURN the value IN the global

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 847: NVL(p_rec.attribute_category, hr_api.g_VARCHAR2) or

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) <>
851: NVL(p_rec.attribute2, hr_api.g_VARCHAR2) or

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 849: NVL(p_rec.attribute1, hr_api.g_VARCHAR2) or

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) <>
853: NVL(p_rec.attribute3, hr_api.g_VARCHAR2) or

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 851: NVL(p_rec.attribute2, hr_api.g_VARCHAR2) or

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) <>
855: NVL(p_rec.attribute4, hr_api.g_VARCHAR2) or

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 853: NVL(p_rec.attribute3, hr_api.g_VARCHAR2) or

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) <>
857: NVL(p_rec.attribute5, hr_api.g_VARCHAR2) or

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 855: NVL(p_rec.attribute4, hr_api.g_VARCHAR2) or

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) <>
859: NVL(p_rec.attribute6, hr_api.g_VARCHAR2) or

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 857: NVL(p_rec.attribute5, hr_api.g_VARCHAR2) or

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) <>
861: NVL(p_rec.attribute7, hr_api.g_VARCHAR2) or

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 859: NVL(p_rec.attribute6, hr_api.g_VARCHAR2) or

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) <>
863: NVL(p_rec.attribute8, hr_api.g_VARCHAR2) or

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 861: NVL(p_rec.attribute7, hr_api.g_VARCHAR2) or

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) <>
865: NVL(p_rec.attribute9, hr_api.g_VARCHAR2) or

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 863: NVL(p_rec.attribute8, hr_api.g_VARCHAR2) or

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) <>
867: NVL(p_rec.attribute10, hr_api.g_VARCHAR2) or

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 865: NVL(p_rec.attribute9, hr_api.g_VARCHAR2) or

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) <>
869: NVL(p_rec.attribute11, hr_api.g_VARCHAR2) or

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 867: NVL(p_rec.attribute10, hr_api.g_VARCHAR2) or

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) <>
871: NVL(p_rec.attribute12, hr_api.g_VARCHAR2) or

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 869: NVL(p_rec.attribute11, hr_api.g_VARCHAR2) or

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) <>
873: NVL(p_rec.attribute13, hr_api.g_VARCHAR2) or

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 871: NVL(p_rec.attribute12, hr_api.g_VARCHAR2) or

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) <>
875: NVL(p_rec.attribute14, hr_api.g_VARCHAR2) or

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 873: NVL(p_rec.attribute13, hr_api.g_VARCHAR2) or

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) <>
877: NVL(p_rec.attribute15, hr_api.g_VARCHAR2) or

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 875: NVL(p_rec.attribute14, hr_api.g_VARCHAR2) or

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) <>
879: NVL(p_rec.attribute16, hr_api.g_VARCHAR2) or

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 877: NVL(p_rec.attribute15, hr_api.g_VARCHAR2) or

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) <>
881: NVL(p_rec.attribute17, hr_api.g_VARCHAR2) or

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 879: NVL(p_rec.attribute16, hr_api.g_VARCHAR2) or

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) <>
883: NVL(p_rec.attribute18, hr_api.g_VARCHAR2) or

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 881: NVL(p_rec.attribute17, hr_api.g_VARCHAR2) or

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) <>
885: NVL(p_rec.attribute19, hr_api.g_VARCHAR2) or

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 883: NVL(p_rec.attribute18, hr_api.g_VARCHAR2) or

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) <>
887: NVL(p_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 885: NVL(p_rec.attribute19, hr_api.g_VARCHAR2) or

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

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 887: NVL(p_rec.attribute20, 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:
891: -- a) During update, the structure column value or any

Line 1000: IF nvl(p_rec.business_group_id, hr_api.g_number) <>

996: END IF;
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;

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 1013: hr_api.argument_changed_error

1009: --
1010: EXCEPTION
1011: WHEN l_error THEN
1012: --
1013: hr_api.argument_changed_error
1014: (p_api_name => l_proc
1015: ,p_argument => l_argument);
1016: --
1017: WHEN OTHERS THEN

Line 1038: hr_api.validate_bus_grp_id

1034: hr_utility.set_location('Entering:'||l_proc, 10);
1035: --
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: --

Line 1135: hr_api.validate_bus_grp_id

1131: hr_utility.set_location('Entering:'||l_proc, 10);
1132: --
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: --