131: BEGIN
132:
133: hr_utility.set_location('Entering: '||l_proc, 10);
134:
135: hr_api.mandatory_arg_error(p_api_name => l_proc,
136: p_argument => 'p_accrual_plan_name',
137: p_argument_value => p_accrual_plan_name);
138:
139: --
204: (p_accrual_plan_id => p_accrual_plan_id
205: ,p_object_version_number => p_object_version_number);
206:
207: IF (l_api_updating
208: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
210: RETURN;
211: END IF;
212:
205: ,p_object_version_number => p_object_version_number);
206:
207: IF (l_api_updating
208: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
210: RETURN;
211: END IF;
212:
213: hr_api.mandatory_arg_error(p_api_name => l_proc,
209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
210: RETURN;
211: END IF;
212:
213: hr_api.mandatory_arg_error(p_api_name => l_proc,
214: p_argument => 'p_accrual_category',
215: p_argument_value => p_accrual_category);
216:
217: --
216:
217: --
218: -- Bug 1744331: use leg_lookups.
219: --
220: IF hr_api.not_exists_in_leg_lookups
221: (p_effective_date => p_effective_date
222: ,p_lookup_type => 'US_PTO_ACCRUAL'
223: ,p_lookup_code => p_accrual_category) THEN
224:
269: (p_accrual_plan_id => p_accrual_plan_id
270: ,p_object_version_number => p_object_version_number);
271:
272: IF (l_api_updating
273: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)
274: = NVL(p_accrual_start, hr_api.g_varchar2)) THEN
275: RETURN;
276: END IF;
277:
270: ,p_object_version_number => p_object_version_number);
271:
272: IF (l_api_updating
273: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)
274: = NVL(p_accrual_start, hr_api.g_varchar2)) THEN
275: RETURN;
276: END IF;
277:
278: IF p_accrual_start IS NOT NULL THEN
278: IF p_accrual_start IS NOT NULL THEN
279:
280: hr_utility.set_location(l_proc, 20);
281:
282: IF hr_api.not_exists_in_hr_lookups
283: (p_effective_date => p_effective_date
284: ,p_lookup_type => 'US_ACCRUAL_START_TYPE'
285: ,p_lookup_code => p_accrual_start) THEN
286:
322: BEGIN
323:
324: hr_utility.set_location('Entering: '||l_proc, 10);
325:
326: hr_api.mandatory_arg_error(p_api_name => l_proc,
327: p_argument => 'p_accrual_units_of_measure',
328: p_argument_value => p_accrual_units_of_measure);
329:
330: IF hr_api.not_exists_in_hr_lookups
326: hr_api.mandatory_arg_error(p_api_name => l_proc,
327: p_argument => 'p_accrual_units_of_measure',
328: p_argument_value => p_accrual_units_of_measure);
329:
330: IF hr_api.not_exists_in_hr_lookups
331: (p_effective_date => p_effective_date
332: ,p_lookup_type => 'HOURS_OR_DAYS'
333: ,p_lookup_code => p_accrual_units_of_measure) THEN
334:
382: (p_accrual_plan_id => p_accrual_plan_id
383: ,p_object_version_number => p_object_version_number);
384:
385: IF (l_api_updating
386: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
388: RETURN;
389: END IF;
390:
383: ,p_object_version_number => p_object_version_number);
384:
385: IF (l_api_updating
386: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
388: RETURN;
389: END IF;
390:
391: hr_api.mandatory_arg_error(p_api_name => l_proc,
387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
388: RETURN;
389: END IF;
390:
391: hr_api.mandatory_arg_error(p_api_name => l_proc,
392: p_argument => 'p_accrual_formula_id',
393: p_argument_value => p_accrual_formula_id);
394:
395: hr_utility.set_location(l_proc, 20);
456: (p_accrual_plan_id => p_accrual_plan_id
457: ,p_object_version_number => p_object_version_number);
458:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
457: ,p_object_version_number => p_object_version_number);
458:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
458:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
466:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
466:
467: hr_api.mandatory_arg_error(p_api_name => l_proc,
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
466:
467: hr_api.mandatory_arg_error(p_api_name => l_proc,
468: p_argument => 'p_co_formula_id',
469: p_argument_value => p_co_formula_id);
470:
471: hr_utility.set_location(l_proc, 20);
645: (p_accrual_plan_id => p_accrual_plan_id
646: ,p_object_version_number => p_object_version_number);
647:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
646: ,p_object_version_number => p_object_version_number);
647:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
647:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
655:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
655:
656: hr_api.mandatory_arg_error(p_api_name => l_proc,
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
655:
656: hr_api.mandatory_arg_error(p_api_name => l_proc,
657: p_argument => 'p_pto_input_value_id',
658: p_argument_value => p_pto_input_value_id);
659:
660: hr_utility.set_location(l_proc, 20);
781: (p_accrual_plan_id => p_accrual_plan_id
782: ,p_object_version_number => p_object_version_number);
783:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
782: ,p_object_version_number => p_object_version_number);
783:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;
783:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;
791:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;
791:
792: hr_utility.set_location(l_proc, 20);
795:
796: hr_utility.set_location(l_proc, 30);
797:
798: IF l_api_updating
799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
800: <> hr_api.g_number THEN
801:
802: --
803: -- The balance dimension has previously been set and is trying
796: hr_utility.set_location(l_proc, 30);
797:
798: IF l_api_updating
799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
800: <> hr_api.g_number THEN
801:
802: --
803: -- The balance dimension has previously been set and is trying
804: -- to be updated. This is not allowed so error.
916: IF (l_balance_type = 'DE' AND
917: l_dimension_name NOT IN ('_ASG_PTO_DE_YTD'
918: ,'_ASG_PTO_DE_SM_YTD'
919: ,'_ASG_PTO_DE_HD_YTD'))
920: OR (NVL(l_balance_type, hr_api.g_varchar2) <> 'DE' AND
921: l_dimension_name IN ('_ASG_PTO_DE_YTD'
922: ,'_ASG_PTO_DE_SM_YTD'
923: ,'_ASG_PTO_DE_HD_YTD')) THEN
924:
987: (p_accrual_plan_id => p_accrual_plan_id
988: ,p_object_version_number => p_object_version_number);
989:
990: IF (l_api_updating
991: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)
992: = NVL(p_ineligible_period_type, hr_api.g_varchar2)) THEN
993: RETURN;
994: END IF;
995:
988: ,p_object_version_number => p_object_version_number);
989:
990: IF (l_api_updating
991: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)
992: = NVL(p_ineligible_period_type, hr_api.g_varchar2)) THEN
993: RETURN;
994: END IF;
995:
996: IF p_ineligible_period_type IS NOT NULL THEN
996: IF p_ineligible_period_type IS NOT NULL THEN
997:
998: hr_utility.set_location(l_proc, 20);
999:
1000: IF hr_api.not_exists_in_hr_lookups
1001: (p_effective_date => p_effective_date
1002: ,p_lookup_type => 'PROC_PERIOD_TYPE'
1003: ,p_lookup_code => p_ineligible_period_type) THEN
1004:
1055: (p_accrual_plan_id => p_accrual_plan_id
1056: ,p_object_version_number => p_object_version_number);
1057:
1058: IF (l_api_updating
1059: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)
1060: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1061: RETURN;
1062: END IF;
1063:
1056: ,p_object_version_number => p_object_version_number);
1057:
1058: IF (l_api_updating
1059: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)
1060: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1061: RETURN;
1062: END IF;
1063:
1064: hr_utility.set_location(l_proc, 20);
1128: begin
1129: hr_utility.set_location('Entering:'||l_proc,10);
1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1129: hr_utility.set_location('Entering:'||l_proc,10);
1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1195: --
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1195: --
1196: -- Only execute the validation if absolutely necessary:
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1195: --
1196: -- Only execute the validation if absolutely necessary:
1197: -- a) During update, the structure column value or any
1316: p_object_version_number => p_object_version_number);
1317: --
1318:
1319: if (l_api_updating
1320: and (nvl(p_information_category,hr_api.g_varchar2)
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1317: --
1318:
1319: if (l_api_updating
1320: and (nvl(p_information_category,hr_api.g_varchar2)
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1320: and (nvl(p_information_category,hr_api.g_varchar2)
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: ))
1327: OR not l_api_updating
1328: --
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: ))
1327: OR not l_api_updating
1328: --
1329: -- it is an update with values changing, or it is an insert
1346: fnd_message.set_name('PER','HR_289740_PAP_BAD_INFO_CONTEXT');
1347: fnd_message.raise_error;
1348: end if;
1349: -- error if accrual category is changing and ddf is already used.
1350: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1351: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1352: and pay_pap_shd.g_old_rec.information_category is not null )
1353: then
1354: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1347: fnd_message.raise_error;
1348: end if;
1349: -- error if accrual category is changing and ddf is already used.
1350: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1351: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1352: and pay_pap_shd.g_old_rec.information_category is not null )
1353: then
1354: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1355: fnd_message.raise_error;
1373: BEGIN
1374:
1375: hr_utility.set_location('Entering:'||l_proc, 10);
1376:
1377: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1378:
1379: --
1380: -- Call all supporting business operations
1381: --
1526: BEGIN
1527:
1528: hr_utility.set_location('Entering:'||l_proc, 10);
1529:
1530: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1531:
1532: --
1533: -- Call all supporting business operations
1534: --
1691: hr_utility.set_location('Entering:'|| l_proc, 10);
1692: --
1693: -- Ensure that all the mandatory parameter are not null
1694: --
1695: hr_api.mandatory_arg_error(p_api_name => l_proc,
1696: p_argument => 'accrual_plan_id',
1697: p_argument_value => p_accrual_plan_id);
1698: --
1699: open csr_leg_code;
1746: hr_utility.set_location('Entering:'|| l_proc, 10);
1747: --
1748: -- Ensure that all the mandatory parameter are not null
1749: --
1750: hr_api.mandatory_arg_error(p_api_name => l_proc,
1751: p_argument => 'accrual_plan_id',
1752: p_argument_value => p_accrual_plan_id);
1753: --
1754: open csr_sec_grp;
1764: close csr_sec_grp;
1765: --
1766: -- Set the security_group_id in CLIENT_INFO
1767: --
1768: hr_api.set_security_group_id
1769: (p_security_group_id => l_security_group_id
1770: );
1771: --
1772: hr_utility.set_location(' Leaving:'|| l_proc, 20);