APPS.PAY_PAP_BUS dependencies on PAY_PAP_SHD

Line 203: l_api_updating := pay_pap_shd.api_updating

199: -- a) inserting or
200: -- b) updating and the parameters used within this chk procedure
201: -- have not changed.
202: --
203: l_api_updating := pay_pap_shd.api_updating
204: (p_accrual_plan_id => p_accrual_plan_id
205: ,p_object_version_number => p_object_version_number);
206:
207: IF (l_api_updating

Line 208: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

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:

Line 268: l_api_updating := pay_pap_shd.api_updating

264: -- a) inserting or
265: -- b) updating and the parameters used within this chk procedure
266: -- have not changed.
267: --
268: l_api_updating := pay_pap_shd.api_updating
269: (p_accrual_plan_id => p_accrual_plan_id
270: ,p_object_version_number => p_object_version_number);
271:
272: IF (l_api_updating

Line 273: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)

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:

Line 381: l_api_updating := pay_pap_shd.api_updating

377: -- a) inserting or
378: -- b) updating and the parameters used within this chk procedure
379: -- have not changed.
380: --
381: l_api_updating := pay_pap_shd.api_updating
382: (p_accrual_plan_id => p_accrual_plan_id
383: ,p_object_version_number => p_object_version_number);
384:
385: IF (l_api_updating

Line 386: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)

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:

Line 455: l_api_updating := pay_pap_shd.api_updating

451: -- a) inserting or
452: -- b) updating and the parameters used within this chk procedure
453: -- have not changed.
454: --
455: l_api_updating := pay_pap_shd.api_updating
456: (p_accrual_plan_id => p_accrual_plan_id
457: ,p_object_version_number => p_object_version_number);
458:
459: IF (l_api_updating

Line 460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)

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;

Line 462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_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;
466:

Line 644: l_api_updating := pay_pap_shd.api_updating

640: -- a) inserting or
641: -- b) updating and the parameters used within this chk procedure
642: -- have not changed.
643: --
644: l_api_updating := pay_pap_shd.api_updating
645: (p_accrual_plan_id => p_accrual_plan_id
646: ,p_object_version_number => p_object_version_number);
647:
648: IF (l_api_updating

Line 649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)

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;

Line 651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)

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:

Line 780: l_api_updating := pay_pap_shd.api_updating

776: -- a) inserting or
777: -- b) updating and the parameters used within this chk procedure
778: -- have not changed.
779: --
780: l_api_updating := pay_pap_shd.api_updating
781: (p_accrual_plan_id => p_accrual_plan_id
782: ,p_object_version_number => p_object_version_number);
783:
784: IF (l_api_updating

Line 785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)

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;

Line 787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_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;
791:

Line 799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)

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

Line 986: l_api_updating := pay_pap_shd.api_updating

982: -- a) inserting or
983: -- b) updating and the parameters used within this chk procedure
984: -- have not changed.
985: --
986: l_api_updating := pay_pap_shd.api_updating
987: (p_accrual_plan_id => p_accrual_plan_id
988: ,p_object_version_number => p_object_version_number);
989:
990: IF (l_api_updating

Line 991: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)

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:

Line 1054: l_api_updating := pay_pap_shd.api_updating

1050: -- a) inserting or
1051: -- b) updating and the parameters used within this chk procedure
1052: -- have not changed.
1053: --
1054: l_api_updating := pay_pap_shd.api_updating
1055: (p_accrual_plan_id => p_accrual_plan_id
1056: ,p_object_version_number => p_object_version_number);
1057:
1058: IF (l_api_updating

Line 1059: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)

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:

Line 1123: (p_rec in pay_pap_shd.g_rec_type

1119: -- Internal Row Handler Use Only.
1120: --
1121: -- ----------------------------------------------------------------------------
1122: procedure chk_ddf
1123: (p_rec in pay_pap_shd.g_rec_type
1124: ) is
1125: --
1126: l_proc varchar2(72) := g_package || 'chk_ddf';
1127: --

Line 1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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

Line 1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>

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

Line 1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

Line 1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

Line 1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

Line 1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

Line 1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

Line 1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

Line 1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

Line 1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

Line 1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

Line 1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

Line 1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

Line 1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

Line 1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

Line 1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

Line 1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

Line 1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

Line 1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

Line 1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

Line 1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

Line 1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>

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

Line 1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>

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

Line 1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>

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

Line 1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>

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

Line 1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>

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

Line 1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>

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

Line 1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>

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

Line 1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>

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

Line 1190: nvl(pay_pap_shd.g_old_rec.information29, 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

Line 1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>

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:

Line 1314: l_api_updating := pay_pap_shd.api_updating

1310: Begin
1311: --
1312: hr_utility.set_location('Entering:'||l_proc, 5);
1313: --
1314: l_api_updating := pay_pap_shd.api_updating
1315: (p_accrual_plan_id => p_accrual_plan_id,
1316: p_object_version_number => p_object_version_number);
1317: --
1318:

Line 1321: <> nvl(pay_pap_shd.g_old_rec.information_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)

Line 1325: <> nvl(pay_pap_shd.g_old_rec.accrual_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: --
1329: -- it is an update with values changing, or it is an insert

Line 1351: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

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;

Line 1352: and pay_pap_shd.g_old_rec.information_category is not null )

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;
1356: end if;

Line 1367: ,p_rec IN pay_pap_shd.g_rec_type

1363: -- |---------------------------< insert_validate >----------------------------|
1364: -- ----------------------------------------------------------------------------
1365: PROCEDURE insert_validate
1366: (p_effective_date IN DATE
1367: ,p_rec IN pay_pap_shd.g_rec_type
1368: ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
1369: IS
1370:
1371: l_proc varchar2(72) := g_package||'insert_validate';

Line 1520: ,p_rec IN pay_pap_shd.g_rec_type

1516: -- |---------------------------< update_validate >----------------------------|
1517: -- ----------------------------------------------------------------------------
1518: PROCEDURE update_validate
1519: (p_effective_date IN DATE
1520: ,p_rec IN pay_pap_shd.g_rec_type
1521: ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
1522: IS
1523:
1524: l_proc varchar2(72) := g_package||'update_validate';

Line 1655: Procedure delete_validate(p_rec in pay_pap_shd.g_rec_type) is

1651: --
1652: -- ----------------------------------------------------------------------------
1653: -- |---------------------------< delete_validate >----------------------------|
1654: -- ----------------------------------------------------------------------------
1655: Procedure delete_validate(p_rec in pay_pap_shd.g_rec_type) is
1656: --
1657: l_proc varchar2(72) := g_package||'delete_validate';
1658: --
1659: Begin