DBA Data[Home] [Help]

APPS.PER_PPC_BUS dependencies on HR_API

Line 83: hr_api.argument_changed_error

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;

Line 227: hr_api.mandatory_arg_error

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

Line 233: hr_api.mandatory_arg_error

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

Line 341: hr_api.mandatory_arg_error

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

Line 347: hr_api.mandatory_arg_error

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

Line 484: hr_api.mandatory_arg_error

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

Line 490: hr_api.mandatory_arg_error

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

Line 496: hr_api.mandatory_arg_error

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

Line 549: if hr_api.not_exists_in_hr_lookups

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

Line 724: hr_api.mandatory_arg_error

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

Line 731: hr_api.mandatory_arg_error

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

Line 770: (nvl(per_ppc_shd.g_old_rec.change_amount_n,hr_api.g_number)

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))

Line 771: <> nvl(p_change_amount_n, hr_api.g_number) OR

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

Line 772: nvl(per_ppc_shd.g_old_rec.change_percentage,hr_api.g_number)

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

Line 774: nvl(p_change_percentage ,hr_api.g_number))

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

Line 913: hr_api.mandatory_arg_error

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

Line 985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

Line 987: nvl(per_ppc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 988: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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

Line 989: nvl(per_ppc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 990: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 991: nvl(per_ppc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 992: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 993: nvl(per_ppc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 994: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 995: nvl(per_ppc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 996: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 997: nvl(per_ppc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 998: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 999: nvl(per_ppc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 1000: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 1001: nvl(per_ppc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 1002: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 1003: nvl(per_ppc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 1004: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 1005: nvl(per_ppc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 1006: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

Line 1007: nvl(per_ppc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 1008: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

Line 1009: nvl(per_ppc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 1010: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

Line 1011: nvl(per_ppc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 1012: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

Line 1013: nvl(per_ppc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 1014: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

Line 1015: nvl(per_ppc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 1016: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

Line 1017: nvl(per_ppc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 1018: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

Line 1019: nvl(per_ppc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 1020: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

Line 1021: nvl(per_ppc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 1022: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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)))

Line 1023: nvl(per_ppc_shd.g_old_rec.attribute19, 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

Line 1024: nvl(p_rec.attribute19, hr_api.g_varchar2) 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

Line 1025: nvl(per_ppc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 1026: nvl(p_rec.attribute20, 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: --
1030: -- Only execute the validation if absolutely necessary:

Line 1107: hr_api.validate_bus_grp_id(p_rec.business_group_id);

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

Line 1203: hr_api.validate_bus_grp_id(p_rec.business_group_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

Line 1363: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

Line 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.