36: --
37: --
38: --
39: --
40: Procedure check_non_updateable_args(p_rec in per_ppc_shd.g_rec_type) is
41: --
42: l_proc varchar2(72) := g_package||'check_non_updateable_args';
43: l_error exception;
44: l_argument varchar2(30);
48: --
49: -- Only proceed with validation if a row exists for
50: -- the current record in the HR Schema
51: --
52: if not per_ppc_shd.api_updating
53: (p_component_id => p_rec.component_id
54: ,p_object_version_number => p_rec.object_version_number
55: ) then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('STEP', '5');
59: end if;
60: hr_utility.set_location(l_proc, 6);
61: --
62: if p_rec.business_group_id <> per_ppc_shd.g_old_rec.business_group_id
63: then
64: l_argument := 'business_group_id';
65: raise l_error;
66: end if;
65: raise l_error;
66: end if;
67: hr_utility.set_location(l_proc, 7);
68: --
69: if p_rec.pay_proposal_id <> per_ppc_shd.g_old_rec.pay_proposal_id then
70: l_argument := 'pay_proposal_id';
71: raise l_error;
72: end if;
73: hr_utility.set_location(l_proc, 8);
71: raise l_error;
72: end if;
73: hr_utility.set_location(l_proc, 8);
74: --
75: if p_rec.component_id <> per_ppc_shd.g_old_rec.component_id then
76: l_argument := 'component_id';
77: raise l_error;
78: end if;
79: hr_utility.set_location(l_proc, 9);
250: l_multiple_components,l_business_group_id;
251: if csr_pay_proposal_details%notfound then
252: close csr_pay_proposal_details;
253: hr_utility.set_location(l_proc, 3);
254: per_ppc_shd.constraint_error('PER_PAY_PROPOSAL_COMPONENT_FK1');
255: elsif
256: l_business_group_id <> p_business_group_id then
257: --
258: -- The component exists for a proposal in diferent Business Group.
258: -- The component exists for a proposal in diferent Business Group.
259: --
260: close csr_pay_proposal_details;
261: hr_utility.set_location(l_proc, 4);
262: per_ppc_shd.constraint_error('PER_PAY_PROPOSAL_COMPONENT_FK2');
263: else
264: close csr_pay_proposal_details;
265: /*
266: if l_approved = 'Y' and p_validation_strength <>'WEAK' then
353: -- Only proceed with validation if :
354: -- a) The current g_old_rec is current and
355: -- b) The value for approved flag has changed
356: --
357: l_api_updating := per_ppc_shd.api_updating
358: (p_component_id => p_component_id
359: ,p_object_version_number => p_object_version_number);
360: --
361: if (l_api_updating AND
358: (p_component_id => p_component_id
359: ,p_object_version_number => p_object_version_number);
360: --
361: if (l_api_updating AND
362: (per_ppc_shd.g_old_rec.approved <> p_approved)
363: OR not l_api_updating)
364: then
365: --
366: -- check that the value of the approved is either 'Y' or 'N'
366: -- check that the value of the approved is either 'Y' or 'N'
367: --
368: if (p_approved <> 'Y' AND p_approved <> 'N') then
369: hr_utility.set_location(l_proc, 2);
370: per_ppc_shd.constraint_error ('PER_PPC_APPROVED_CHK');
371: end if;
372: --
373: -- Check that a component cannot be approved if the
374: -- change_amount_n or component_reason is null
503: -- Only proceed with validation if :
504: -- a) The current g_old_rec is current and
505: -- b) The value for component_reason has changed
506: --
507: l_api_updating := per_ppc_shd.api_updating
508: (p_component_id => p_component_id
509: ,p_object_version_number => p_object_version_number);
510: --
511: -- if (l_api_updating) then
512: --
513: -- Check that the component reason cannot be updated if the
514: -- the component is already approved.
515: --
516: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
517: -- per_ppc_shd.g_old_rec.component_reason <> p_component_reason) then
518: -- hr_utility.set_location(l_proc, 2);
519: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
520: -- hr_utility.raise_error;
513: -- Check that the component reason cannot be updated if the
514: -- the component is already approved.
515: --
516: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
517: -- per_ppc_shd.g_old_rec.component_reason <> p_component_reason) then
518: -- hr_utility.set_location(l_proc, 2);
519: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
520: -- hr_utility.raise_error;
521: -- end if;
530: hr_utility.raise_error;
531: end if;
532: --
533: if (l_api_updating AND
534: (per_ppc_shd.g_old_rec.component_reason <> p_component_reason)
535: OR not l_api_updating) then
536: --
537: -- Check that the component reason cannot be updated if the
538: -- the component is already approved.
536: --
537: -- Check that the component reason cannot be updated if the
538: -- the component is already approved.
539: --
540: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y'
541: -- AND l_api_updating) then
542: -- hr_utility.set_location(l_proc, 2);
543: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
544: -- hr_utility.raise_error;
566: close csr_unique_comp_reason;
567: else
568: hr_utility.set_location(l_proc, 6);
569: close csr_unique_comp_reason;
570: per_ppc_shd.constraint_error ('PER_PAY_PROPOSAL_COMPONENT_UK2');
571: end if;
572: end if;
573: --
574: hr_utility.set_location('Leaving: ' || l_proc, 7);
737: -- Only proceed with validation if :
738: -- a) The current g_old_rec is current and
739: -- b) The value for change_amount_n or change_percentage has changed
740: --
741: l_api_updating := per_ppc_shd.api_updating
742: (p_component_id => p_component_id
743: ,p_object_version_number => p_object_version_number);
744: --
745:
747: --
748: -- Check that the change_amount_n and change_percentage cannot be
749: -- updated if the the component is already approved.
750: --
751: if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
752: (per_ppc_shd.g_old_rec.change_amount_n <> p_change_amount_n OR
753: per_ppc_shd.g_old_rec.change_percentage <> p_change_percentage))
754: then
755: hr_utility.set_location(l_proc, 1);
748: -- Check that the change_amount_n and change_percentage cannot be
749: -- updated if the the component is already approved.
750: --
751: if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
752: (per_ppc_shd.g_old_rec.change_amount_n <> p_change_amount_n OR
753: per_ppc_shd.g_old_rec.change_percentage <> p_change_percentage))
754: then
755: hr_utility.set_location(l_proc, 1);
756: -- allow Component update.
749: -- updated if the the component is already approved.
750: --
751: if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
752: (per_ppc_shd.g_old_rec.change_amount_n <> p_change_amount_n OR
753: per_ppc_shd.g_old_rec.change_percentage <> p_change_percentage))
754: then
755: hr_utility.set_location(l_proc, 1);
756: -- allow Component update.
757: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
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))
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: --
973: -- Access Status:
974: -- Internal Row Handler Use Only.
975: --
976: procedure chk_df
977: (p_rec in per_ppc_shd.g_rec_type) is
978: --
979: l_proc varchar2(72) := g_package||'chk_df';
980: --
981: begin
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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: --
1084: --
1085: -- ------------------------------------------------------------------
1086: -- |------------------< insert_validate >----------------------------|
1087: -- ------------------------------------------------------------------
1088: Procedure insert_validate(p_rec in out nocopy per_ppc_shd.g_rec_type
1089: ,p_validation_strength in varchar2 default 'STRONG') is
1090: --
1091: l_proc varchar2(72) := g_package||'insert_validate';
1092: --
1185: --
1186: -- ----------------------------------------------------------------------------
1187: -- |---------------------------< update_validate >----------------------------|
1188: -- ----------------------------------------------------------------------------
1189: Procedure update_validate(p_rec in out nocopy per_ppc_shd.g_rec_type
1190: ,p_validation_strength in varchar2 default 'STRONG') is
1191: --
1192: l_proc varchar2(72) := g_package||'update_validate';
1193: --
1297: --
1298: -- ----------------------------------------------------------------------------
1299: -- |---------------------------< delete_validate >----------------------------|
1300: -- ----------------------------------------------------------------------------
1301: Procedure delete_validate(p_rec in per_ppc_shd.g_rec_type,
1302: p_validation_strength in varchar2 default 'STRONG') is
1303: --
1304: l_proc varchar2(72) := g_package||'delete_validate';
1305: --
1309: -- Call all supporting business operations
1310: --
1311: -- Validate delete
1312: -- call to chk_access added for fixing bug#3839734
1313: per_ppc_bus.chk_access(p_pay_proposal_id => per_ppc_shd.g_old_rec.pay_proposal_id);
1314: --
1315: --
1316: -- Business Rule Mapping
1317: -- =====================