APPS.PAY_PAP_BUS dependencies on PAY_PAP_SHD

Line 177: l_api_updating := pay_pap_shd.api_updating

173: -- a) inserting or
174: -- b) updating and the parameters used within this chk procedure
175: -- have not changed.
176: --
177: l_api_updating := pay_pap_shd.api_updating
178: (p_accrual_plan_id => p_accrual_plan_id
179: ,p_object_version_number => p_object_version_number);
180:
181: IF (l_api_updating

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

178: (p_accrual_plan_id => p_accrual_plan_id
179: ,p_object_version_number => p_object_version_number);
180:
181: IF (l_api_updating
182: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
183: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
184: RETURN;
185: END IF;
186:

Line 242: l_api_updating := pay_pap_shd.api_updating

238: -- a) inserting or
239: -- b) updating and the parameters used within this chk procedure
240: -- have not changed.
241: --
242: l_api_updating := pay_pap_shd.api_updating
243: (p_accrual_plan_id => p_accrual_plan_id
244: ,p_object_version_number => p_object_version_number);
245:
246: IF (l_api_updating

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

243: (p_accrual_plan_id => p_accrual_plan_id
244: ,p_object_version_number => p_object_version_number);
245:
246: IF (l_api_updating
247: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)
248: = NVL(p_accrual_start, hr_api.g_varchar2)) THEN
249: RETURN;
250: END IF;
251:

Line 355: l_api_updating := pay_pap_shd.api_updating

351: -- a) inserting or
352: -- b) updating and the parameters used within this chk procedure
353: -- have not changed.
354: --
355: l_api_updating := pay_pap_shd.api_updating
356: (p_accrual_plan_id => p_accrual_plan_id
357: ,p_object_version_number => p_object_version_number);
358:
359: IF (l_api_updating

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

356: (p_accrual_plan_id => p_accrual_plan_id
357: ,p_object_version_number => p_object_version_number);
358:
359: IF (l_api_updating
360: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
361: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
362: RETURN;
363: END IF;
364:

Line 429: l_api_updating := pay_pap_shd.api_updating

425: -- a) inserting or
426: -- b) updating and the parameters used within this chk procedure
427: -- have not changed.
428: --
429: l_api_updating := pay_pap_shd.api_updating
430: (p_accrual_plan_id => p_accrual_plan_id
431: ,p_object_version_number => p_object_version_number);
432:
433: IF (l_api_updating

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

430: (p_accrual_plan_id => p_accrual_plan_id
431: ,p_object_version_number => p_object_version_number);
432:
433: IF (l_api_updating
434: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
435: = NVL(p_accrual_formula_id, hr_api.g_number)
436: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
437: = NVL(p_co_formula_id, hr_api.g_number)) THEN
438: RETURN;

Line 436: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)

432:
433: IF (l_api_updating
434: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
435: = NVL(p_accrual_formula_id, hr_api.g_number)
436: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
437: = NVL(p_co_formula_id, hr_api.g_number)) THEN
438: RETURN;
439: END IF;
440:

Line 618: l_api_updating := pay_pap_shd.api_updating

614: -- a) inserting or
615: -- b) updating and the parameters used within this chk procedure
616: -- have not changed.
617: --
618: l_api_updating := pay_pap_shd.api_updating
619: (p_accrual_plan_id => p_accrual_plan_id
620: ,p_object_version_number => p_object_version_number);
621:
622: IF (l_api_updating

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

619: (p_accrual_plan_id => p_accrual_plan_id
620: ,p_object_version_number => p_object_version_number);
621:
622: IF (l_api_updating
623: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
624: = NVL(p_pto_input_value_id, hr_api.g_number)
625: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
626: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
627: RETURN;

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

621:
622: IF (l_api_updating
623: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
624: = NVL(p_pto_input_value_id, hr_api.g_number)
625: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
626: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
627: RETURN;
628: END IF;
629:

Line 754: l_api_updating := pay_pap_shd.api_updating

750: -- a) inserting or
751: -- b) updating and the parameters used within this chk procedure
752: -- have not changed.
753: --
754: l_api_updating := pay_pap_shd.api_updating
755: (p_accrual_plan_id => p_accrual_plan_id
756: ,p_object_version_number => p_object_version_number);
757:
758: IF (l_api_updating

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

755: (p_accrual_plan_id => p_accrual_plan_id
756: ,p_object_version_number => p_object_version_number);
757:
758: IF (l_api_updating
759: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
760: = NVL(p_accrual_formula_id, hr_api.g_number)
761: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
762: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
763: RETURN;

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

757:
758: IF (l_api_updating
759: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
760: = NVL(p_accrual_formula_id, hr_api.g_number)
761: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
762: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
763: RETURN;
764: END IF;
765:

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

769:
770: hr_utility.set_location(l_proc, 30);
771:
772: IF l_api_updating
773: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
774: <> hr_api.g_number THEN
775:
776: --
777: -- The balance dimension has previously been set and is trying

Line 960: l_api_updating := pay_pap_shd.api_updating

956: -- a) inserting or
957: -- b) updating and the parameters used within this chk procedure
958: -- have not changed.
959: --
960: l_api_updating := pay_pap_shd.api_updating
961: (p_accrual_plan_id => p_accrual_plan_id
962: ,p_object_version_number => p_object_version_number);
963:
964: IF (l_api_updating

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

961: (p_accrual_plan_id => p_accrual_plan_id
962: ,p_object_version_number => p_object_version_number);
963:
964: IF (l_api_updating
965: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)
966: = NVL(p_ineligible_period_type, hr_api.g_varchar2)) THEN
967: RETURN;
968: END IF;
969:

Line 1028: l_api_updating := pay_pap_shd.api_updating

1024: -- a) inserting or
1025: -- b) updating and the parameters used within this chk procedure
1026: -- have not changed.
1027: --
1028: l_api_updating := pay_pap_shd.api_updating
1029: (p_accrual_plan_id => p_accrual_plan_id
1030: ,p_object_version_number => p_object_version_number);
1031:
1032: IF (l_api_updating

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

1029: (p_accrual_plan_id => p_accrual_plan_id
1030: ,p_object_version_number => p_object_version_number);
1031:
1032: IF (l_api_updating
1033: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)
1034: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1035: RETURN;
1036: END IF;
1037:

Line 1097: (p_rec in pay_pap_shd.g_rec_type

1093: -- Internal Row Handler Use Only.
1094: --
1095: -- ----------------------------------------------------------------------------
1096: procedure chk_ddf
1097: (p_rec in pay_pap_shd.g_rec_type
1098: ) is
1099: --
1100: l_proc varchar2(72) := g_package || 'chk_ddf';
1101: --

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

1102: begin
1103: hr_utility.set_location('Entering:'||l_proc,10);
1104: --
1105: if ((p_rec.accrual_plan_id is not null) and (
1106: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1107: nvl(p_rec.information_category, hr_api.g_varchar2) or
1108: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1109: nvl(p_rec.information1, hr_api.g_varchar2) or
1110: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

1104: --
1105: if ((p_rec.accrual_plan_id is not null) and (
1106: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1107: nvl(p_rec.information_category, hr_api.g_varchar2) or
1108: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1109: nvl(p_rec.information1, hr_api.g_varchar2) or
1110: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1111: nvl(p_rec.information2, hr_api.g_varchar2) or
1112: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

1106: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1107: nvl(p_rec.information_category, hr_api.g_varchar2) or
1108: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1109: nvl(p_rec.information1, hr_api.g_varchar2) or
1110: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1111: nvl(p_rec.information2, hr_api.g_varchar2) or
1112: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1113: nvl(p_rec.information3, hr_api.g_varchar2) or
1114: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

1108: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1109: nvl(p_rec.information1, hr_api.g_varchar2) or
1110: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1111: nvl(p_rec.information2, hr_api.g_varchar2) or
1112: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1113: nvl(p_rec.information3, hr_api.g_varchar2) or
1114: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1115: nvl(p_rec.information4, hr_api.g_varchar2) or
1116: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

1110: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1111: nvl(p_rec.information2, hr_api.g_varchar2) or
1112: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1113: nvl(p_rec.information3, hr_api.g_varchar2) or
1114: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1115: nvl(p_rec.information4, hr_api.g_varchar2) or
1116: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1117: nvl(p_rec.information5, hr_api.g_varchar2) or
1118: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

1112: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1113: nvl(p_rec.information3, hr_api.g_varchar2) or
1114: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1115: nvl(p_rec.information4, hr_api.g_varchar2) or
1116: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1117: nvl(p_rec.information5, hr_api.g_varchar2) or
1118: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1119: nvl(p_rec.information6, hr_api.g_varchar2) or
1120: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

1114: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1115: nvl(p_rec.information4, hr_api.g_varchar2) or
1116: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1117: nvl(p_rec.information5, hr_api.g_varchar2) or
1118: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1119: nvl(p_rec.information6, hr_api.g_varchar2) or
1120: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1121: nvl(p_rec.information7, hr_api.g_varchar2) or
1122: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

1116: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1117: nvl(p_rec.information5, hr_api.g_varchar2) or
1118: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1119: nvl(p_rec.information6, hr_api.g_varchar2) or
1120: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1121: nvl(p_rec.information7, hr_api.g_varchar2) or
1122: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1123: nvl(p_rec.information8, hr_api.g_varchar2) or
1124: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

1118: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1119: nvl(p_rec.information6, hr_api.g_varchar2) or
1120: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1121: nvl(p_rec.information7, hr_api.g_varchar2) or
1122: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1123: nvl(p_rec.information8, hr_api.g_varchar2) or
1124: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1125: nvl(p_rec.information9, hr_api.g_varchar2) or
1126: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

1120: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1121: nvl(p_rec.information7, hr_api.g_varchar2) or
1122: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1123: nvl(p_rec.information8, hr_api.g_varchar2) or
1124: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1125: nvl(p_rec.information9, hr_api.g_varchar2) or
1126: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1127: nvl(p_rec.information10, hr_api.g_varchar2) or
1128: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

1122: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1123: nvl(p_rec.information8, hr_api.g_varchar2) or
1124: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1125: nvl(p_rec.information9, hr_api.g_varchar2) or
1126: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1127: nvl(p_rec.information10, hr_api.g_varchar2) or
1128: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1129: nvl(p_rec.information11, hr_api.g_varchar2) or
1130: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

1124: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1125: nvl(p_rec.information9, hr_api.g_varchar2) or
1126: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1127: nvl(p_rec.information10, hr_api.g_varchar2) or
1128: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1129: nvl(p_rec.information11, hr_api.g_varchar2) or
1130: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1131: nvl(p_rec.information12, hr_api.g_varchar2) or
1132: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

1126: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1127: nvl(p_rec.information10, hr_api.g_varchar2) or
1128: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1129: nvl(p_rec.information11, hr_api.g_varchar2) or
1130: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1131: nvl(p_rec.information12, hr_api.g_varchar2) or
1132: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1133: nvl(p_rec.information13, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

1128: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1129: nvl(p_rec.information11, hr_api.g_varchar2) or
1130: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1131: nvl(p_rec.information12, hr_api.g_varchar2) or
1132: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1133: nvl(p_rec.information13, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1135: nvl(p_rec.information14, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

1130: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1131: nvl(p_rec.information12, hr_api.g_varchar2) or
1132: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1133: nvl(p_rec.information13, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1135: nvl(p_rec.information14, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1137: nvl(p_rec.information15, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

1132: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1133: nvl(p_rec.information13, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1135: nvl(p_rec.information14, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1137: nvl(p_rec.information15, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1139: nvl(p_rec.information16, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

1134: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1135: nvl(p_rec.information14, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1137: nvl(p_rec.information15, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1139: nvl(p_rec.information16, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1141: nvl(p_rec.information17, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

1136: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1137: nvl(p_rec.information15, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1139: nvl(p_rec.information16, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1141: nvl(p_rec.information17, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1143: nvl(p_rec.information18, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

1138: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1139: nvl(p_rec.information16, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1141: nvl(p_rec.information17, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1143: nvl(p_rec.information18, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1145: nvl(p_rec.information19, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

1140: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1141: nvl(p_rec.information17, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1143: nvl(p_rec.information18, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1145: nvl(p_rec.information19, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1147: nvl(p_rec.information20, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>

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

1142: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1143: nvl(p_rec.information18, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1145: nvl(p_rec.information19, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1147: nvl(p_rec.information20, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1149: nvl(p_rec.information21, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>

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

1144: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1145: nvl(p_rec.information19, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1147: nvl(p_rec.information20, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1149: nvl(p_rec.information21, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1151: nvl(p_rec.information22, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>

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

1146: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1147: nvl(p_rec.information20, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1149: nvl(p_rec.information21, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1151: nvl(p_rec.information22, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1153: nvl(p_rec.information23, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>

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

1148: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1149: nvl(p_rec.information21, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1151: nvl(p_rec.information22, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1153: nvl(p_rec.information23, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1155: nvl(p_rec.information24, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>

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

1150: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1151: nvl(p_rec.information22, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1153: nvl(p_rec.information23, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1155: nvl(p_rec.information24, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1157: nvl(p_rec.information25, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>

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

1152: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1153: nvl(p_rec.information23, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1155: nvl(p_rec.information24, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1157: nvl(p_rec.information25, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1159: nvl(p_rec.information26, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>

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

1154: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1155: nvl(p_rec.information24, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1157: nvl(p_rec.information25, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1159: nvl(p_rec.information26, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1161: nvl(p_rec.information27, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>

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

1156: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1157: nvl(p_rec.information25, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1159: nvl(p_rec.information26, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1161: nvl(p_rec.information27, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1163: nvl(p_rec.information28, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>

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

1158: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1159: nvl(p_rec.information26, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1161: nvl(p_rec.information27, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1163: nvl(p_rec.information28, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1165: nvl(p_rec.information29, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>

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

1160: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1161: nvl(p_rec.information27, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1163: nvl(p_rec.information28, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1165: nvl(p_rec.information29, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1167: nvl(p_rec.information30, hr_api.g_varchar2) ))
1168: or (p_rec.accrual_plan_id is null) then

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

1162: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1163: nvl(p_rec.information28, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1165: nvl(p_rec.information29, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1167: nvl(p_rec.information30, hr_api.g_varchar2) ))
1168: or (p_rec.accrual_plan_id is null) then
1169: --
1170: -- Only execute the validation if absolutely necessary:

Line 1288: l_api_updating := pay_pap_shd.api_updating

1284: Begin
1285: --
1286: hr_utility.set_location('Entering:'||l_proc, 5);
1287: --
1288: l_api_updating := pay_pap_shd.api_updating
1289: (p_accrual_plan_id => p_accrual_plan_id,
1290: p_object_version_number => p_object_version_number);
1291: --
1292:

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

1291: --
1292:
1293: if (l_api_updating
1294: and (nvl(p_information_category,hr_api.g_varchar2)
1295: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1296: )
1297: OR
1298: (nvl(p_accrual_category, hr_api.g_varchar2)
1299: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

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

1295: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1296: )
1297: OR
1298: (nvl(p_accrual_category, hr_api.g_varchar2)
1299: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1300: ))
1301: OR not l_api_updating
1302: --
1303: -- it is an update with values changing, or it is an insert

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

1321: fnd_message.raise_error;
1322: end if;
1323: -- error if accrual category is changing and ddf is already used.
1324: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: and pay_pap_shd.g_old_rec.information_category is not null )
1327: then
1328: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1329: fnd_message.raise_error;

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

1322: end if;
1323: -- error if accrual category is changing and ddf is already used.
1324: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: and pay_pap_shd.g_old_rec.information_category is not null )
1327: then
1328: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1329: fnd_message.raise_error;
1330: end if;

Line 1341: ,p_rec IN pay_pap_shd.g_rec_type

1337: -- |---------------------------< insert_validate >----------------------------|
1338: -- ----------------------------------------------------------------------------
1339: PROCEDURE insert_validate
1340: (p_effective_date IN DATE
1341: ,p_rec IN pay_pap_shd.g_rec_type
1342: ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
1343: IS
1344:
1345: l_proc varchar2(72) := g_package||'insert_validate';

Line 1496: ,p_rec IN pay_pap_shd.g_rec_type

1492: -- |---------------------------< update_validate >----------------------------|
1493: -- ----------------------------------------------------------------------------
1494: PROCEDURE update_validate
1495: (p_effective_date IN DATE
1496: ,p_rec IN pay_pap_shd.g_rec_type
1497: ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
1498: IS
1499:
1500: l_proc varchar2(72) := g_package||'update_validate';

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

1627: --
1628: -- ----------------------------------------------------------------------------
1629: -- |---------------------------< delete_validate >----------------------------|
1630: -- ----------------------------------------------------------------------------
1631: Procedure delete_validate(p_rec in pay_pap_shd.g_rec_type) is
1632: --
1633: l_proc varchar2(72) := g_package||'delete_validate';
1634: --
1635: Begin