79: hr_utility.set_location(l_proc, 9);
80: --
81: exception
82: when l_error then
83: hr_api.argument_changed_error
84: (p_api_name => l_proc
85: ,p_argument => l_argument);
86: when others then
87: raise;
223: hr_utility.set_location('Entering:'|| l_proc, 1);
224: --
225: -- Check mandatory parameters have been set
226: --
227: hr_api.mandatory_arg_error
228: (p_api_name => l_proc
229: ,p_argument => 'business_group_id'
230: ,p_argument_value => p_business_group_id
231: );
229: ,p_argument => 'business_group_id'
230: ,p_argument_value => p_business_group_id
231: );
232: --
233: hr_api.mandatory_arg_error
234: (p_api_name => l_proc
235: ,p_argument => 'pay_proposal_id'
236: ,p_argument_value => p_pay_proposal_id
237: );
337: --
338: begin
339: hr_utility.set_location('Entering:'|| l_proc, 1);
340: --
341: hr_api.mandatory_arg_error
342: (p_api_name => l_proc
343: ,p_argument => 'approved'
344: ,p_argument_value => p_approved
345: );
343: ,p_argument => 'approved'
344: ,p_argument_value => p_approved
345: );
346: --
347: hr_api.mandatory_arg_error
348: (p_api_name => l_proc
349: ,p_argument => 'component_reason'
350: ,p_argument_value => p_component_reason
351: );
480: close csr_get_date;
481: --
482: -- Check mandatory parameters have been set
483: --
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc
486: ,p_argument => 'pay_proposal_id'
487: ,p_argument_value => p_pay_proposal_id
488: );
486: ,p_argument => 'pay_proposal_id'
487: ,p_argument_value => p_pay_proposal_id
488: );
489: --
490: hr_api.mandatory_arg_error
491: (p_api_name => l_proc
492: ,p_argument => 'approved'
493: ,p_argument_value => p_approved
494: );
492: ,p_argument => 'approved'
493: ,p_argument_value => p_approved
494: );
495: --
496: hr_api.mandatory_arg_error
497: (p_api_name => l_proc
498: ,p_argument => 'component_reason'
499: ,p_argument_value => p_component_reason
500: );
545: -- end if;
546: --
547: -- check that the p_component_reason exists in hr_lookups.
548: --
549: if hr_api.not_exists_in_hr_lookups
550: (p_effective_date => l_change_date
551: ,p_lookup_type => 'PROPOSAL_REASON'
552: ,p_lookup_code => p_component_reason
553: ) then
720: hr_utility.set_location('Entering:'|| l_proc, 1);
721: --
722: -- Check for mandatory arguments
723: --
724: hr_api.mandatory_arg_error
725: (p_api_name => l_proc
726: ,p_argument => 'pay_proposal_id'
727: ,p_argument_value => p_pay_proposal_id
728: );
727: ,p_argument_value => p_pay_proposal_id
728: );
729: --
730: --
731: hr_api.mandatory_arg_error
732: (p_api_name => l_proc
733: ,p_argument => 'approved'
734: ,p_argument_value => p_approved
735: );
766: l_change_amount_n := p_change_amount_n;
767: l_change_percentage := p_change_percentage;
768: --
769: if (l_api_updating AND
770: (nvl(per_ppc_shd.g_old_rec.change_amount_n,hr_api.g_number)
771: <> nvl(p_change_amount_n, hr_api.g_number) OR
772: nvl(per_ppc_shd.g_old_rec.change_percentage,hr_api.g_number)
773: <>
774: nvl(p_change_percentage ,hr_api.g_number))
767: l_change_percentage := p_change_percentage;
768: --
769: if (l_api_updating AND
770: (nvl(per_ppc_shd.g_old_rec.change_amount_n,hr_api.g_number)
771: <> nvl(p_change_amount_n, hr_api.g_number) OR
772: nvl(per_ppc_shd.g_old_rec.change_percentage,hr_api.g_number)
773: <>
774: nvl(p_change_percentage ,hr_api.g_number))
775: OR not l_api_updating) then
768: --
769: if (l_api_updating AND
770: (nvl(per_ppc_shd.g_old_rec.change_amount_n,hr_api.g_number)
771: <> nvl(p_change_amount_n, hr_api.g_number) OR
772: nvl(per_ppc_shd.g_old_rec.change_percentage,hr_api.g_number)
773: <>
774: nvl(p_change_percentage ,hr_api.g_number))
775: OR not l_api_updating) then
776: --
770: (nvl(per_ppc_shd.g_old_rec.change_amount_n,hr_api.g_number)
771: <> nvl(p_change_amount_n, hr_api.g_number) OR
772: nvl(per_ppc_shd.g_old_rec.change_percentage,hr_api.g_number)
773: <>
774: nvl(p_change_percentage ,hr_api.g_number))
775: OR not l_api_updating) then
776: --
777: -- Don't do anything if both are null.
778: --
909: hr_utility.set_location('Entering:'|| l_proc, 1);
910: --
911: -- Check mandatory parameters have been set
912: --
913: hr_api.mandatory_arg_error
914: (p_api_name => l_proc
915: ,p_argument => 'component_id'
916: ,p_argument_value => p_component_id
917: );
981: begin
982: hr_utility.set_location('Entering:'||l_proc, 10);
983: --
984: if ((p_rec.component_id is not null) and (
985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
982: hr_utility.set_location('Entering:'||l_proc, 10);
983: --
984: if ((p_rec.component_id is not null) and (
985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
983: --
984: if ((p_rec.component_id is not null) and (
985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
984: if ((p_rec.component_id is not null) and (
985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
988: nvl(p_rec.attribute1, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
990: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
992: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1027: or
1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1027: or
1028: (p_rec.component_id is null) then
1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1027: or
1028: (p_rec.component_id is null) then
1029: --
1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_ppc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1027: or
1028: (p_rec.component_id is null) then
1029: --
1030: -- Only execute the validation if absolutely necessary:
1103: -- Business Rule Mapping
1104: -- =====================
1105: -- Rule CHK_BUSINESS_GROUP_ID a,c
1106: --
1107: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1108: --
1109: hr_utility.set_location(l_proc, 10);
1110: --
1111: -- Validate pay_proposal_id
1199: -- relevant)
1200: --
1201: -- Validate business_group id
1202: --
1203: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1204: --
1205: hr_utility.set_location(l_proc, 12);
1206: --
1207: -- Check those columns which cannot be updated
1359: hr_utility.set_location('Entering:'|| l_proc, 10);
1360: --
1361: -- Ensure that all the mandatory parameter are not null
1362: --
1363: hr_api.mandatory_arg_error(p_api_name => l_proc,
1364: p_argument => 'component_id',
1365: p_argument_value => p_component_id);
1366: --
1367: if nvl(g_component_id, hr_api.g_number) = p_component_id then
1363: hr_api.mandatory_arg_error(p_api_name => l_proc,
1364: p_argument => 'component_id',
1365: p_argument_value => p_component_id);
1366: --
1367: if nvl(g_component_id, hr_api.g_number) = p_component_id then
1368: --
1369: -- The legislation code has already been found with a previous
1370: -- call to this function. Just return the value in the global
1371: -- variable.