APPS.PER_CTC_BUS dependencies on PER_CTC_SHD

Line 245: AND p_reference <> per_ctc_shd.g_old_rec.reference

241: if p_datetrack_mode in ('UPDATE_OVERRIDE',
242: 'UPDATE',
243: 'CORRECTION',
244: 'UPDATE_CHANGE_INSERT')
245: AND p_reference <> per_ctc_shd.g_old_rec.reference
246: THEN
247: open csr_update;
248: fetch csr_update into l_exists;
249: if csr_update%FOUND then

Line 339: l_api_updating := per_ctc_shd.api_updating

335: ,p_argument_value => p_validation_end_date
336: );
337: hr_utility.set_location(l_proc, 20);
338: --
339: l_api_updating := per_ctc_shd.api_updating
340: (p_contract_id => p_contract_id
341: ,p_effective_date => p_effective_date
342: ,p_object_version_number => p_object_version_number
343: );

Line 347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

343: );
344: hr_utility.set_location(l_proc, 30);
345: --
346: if ((l_api_updating and
347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
348: nvl(p_type, hr_api.g_varchar2))
349: or (NOT l_api_updating))
350: then
351: hr_utility.set_location(l_proc, 40);

Line 453: l_api_updating := per_ctc_shd.api_updating

449: ,p_argument_value => p_validation_end_date
450: );
451: hr_utility.set_location(l_proc, 20);
452: --
453: l_api_updating := per_ctc_shd.api_updating
454: (p_contract_id => p_contract_id
455: ,p_effective_date => p_effective_date
456: ,p_object_version_number => p_object_version_number
457: );

Line 461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

457: );
458: hr_utility.set_location(l_proc, 30);
459: --
460: if ((l_api_updating and
461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
462: nvl(p_status, hr_api.g_varchar2))
463: or (NOT l_api_updating))
464: then
465: hr_utility.set_location(l_proc, 40);

Line 567: l_api_updating := per_ctc_shd.api_updating

563: ,p_argument_value => p_validation_end_date
564: );
565: hr_utility.set_location(l_proc, 20);
566: --
567: l_api_updating := per_ctc_shd.api_updating
568: (p_contract_id => p_contract_id
569: ,p_effective_date => p_effective_date
570: ,p_object_version_number => p_object_version_number
571: );

Line 575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

571: );
572: hr_utility.set_location(l_proc, 30);
573: --
574: if ((l_api_updating and
575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
576: nvl(p_status_reason, hr_api.g_varchar2))
577: or (NOT l_api_updating))
578: then
579: hr_utility.set_location(l_proc, 40);

Line 683: l_api_updating := per_ctc_shd.api_updating

679: ,p_argument_value => p_validation_end_date
680: );
681: hr_utility.set_location(l_proc, 20);
682: --
683: l_api_updating := per_ctc_shd.api_updating
684: (p_contract_id => p_contract_id
685: ,p_effective_date => p_effective_date
686: ,p_object_version_number => p_object_version_number
687: );

Line 691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

687: );
688: hr_utility.set_location(l_proc, 30);
689: --
690: if ((l_api_updating and
691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
692: nvl(p_duration_units, hr_api.g_varchar2))
693: or (NOT l_api_updating))
694: then
695: hr_utility.set_location(l_proc, 40);

Line 816: l_api_updating := per_ctc_shd.api_updating

812: ,p_argument_value => p_validation_end_date
813: );
814: hr_utility.set_location(l_proc, 20);
815: --
816: l_api_updating := per_ctc_shd.api_updating
817: (p_contract_id => p_contract_id
818: ,p_effective_date => p_effective_date
819: ,p_object_version_number => p_object_version_number
820: );

Line 824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

820: );
821: hr_utility.set_location(l_proc, 30);
822: --
823: if ((l_api_updating and
824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
825: nvl(p_start_reason, hr_api.g_varchar2))
826: or (NOT l_api_updating))
827: then
828: hr_utility.set_location(l_proc, 40);

Line 930: l_api_updating := per_ctc_shd.api_updating

926: ,p_argument_value => p_validation_end_date
927: );
928: hr_utility.set_location(l_proc, 20);
929: --
930: l_api_updating := per_ctc_shd.api_updating
931: (p_contract_id => p_contract_id
932: ,p_effective_date => p_effective_date
933: ,p_object_version_number => p_object_version_number
934: );

Line 938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

934: );
935: hr_utility.set_location(l_proc, 30);
936: --
937: if ((l_api_updating and
938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
939: nvl(p_end_reason, hr_api.g_varchar2))
940: or (NOT l_api_updating))
941: then
942: hr_utility.set_location(l_proc, 40);

Line 1046: l_api_updating := per_ctc_shd.api_updating

1042: ,p_argument_value => p_validation_end_date
1043: );
1044: hr_utility.set_location(l_proc, 20);
1045: --
1046: l_api_updating := per_ctc_shd.api_updating
1047: (p_contract_id => p_contract_id
1048: ,p_effective_date => p_effective_date
1049: ,p_object_version_number => p_object_version_number
1050: );

Line 1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

1050: );
1051: hr_utility.set_location(l_proc, 30);
1052: --
1053: if ((l_api_updating and
1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
1055: nvl(p_extension_period_units, hr_api.g_varchar2))
1056: or (NOT l_api_updating))
1057: then
1058: hr_utility.set_location(l_proc, 40);

Line 1181: (p_rec in per_ctc_shd.g_rec_type) is

1177: -- Access Status:
1178: -- Internal Row Handler Use Only.
1179: --
1180: procedure chk_df
1181: (p_rec in per_ctc_shd.g_rec_type) is
1182: --
1183: l_proc varchar2(72) := g_package||'chk_df';
1184: --
1185: begin

Line 1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1185: begin
1186: hr_utility.set_location('Entering:'||l_proc, 10);
1187: --
1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1187: --
1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1231: or (p_rec.contract_id is null) then

Line 1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1231: or (p_rec.contract_id is null) then
1232: --
1233: -- Only execute the validation if absolutely necessary:

Line 1321: (p_rec in per_ctc_shd.g_rec_type) is

1317: -- {End Of Comments}
1318: -- ----------------------------------------------------------------------------
1319: --
1320: procedure chk_ddf
1321: (p_rec in per_ctc_shd.g_rec_type) is
1322: --
1323: l_proc varchar2(72) := g_package||'chk_ddf';
1324: l_error exception;
1325: --

Line 1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>

1331: --
1332: if (p_rec.contract_id is null)
1333: or ((p_rec.contract_id is not null)
1334: and
1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>

Line 1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>

1333: or ((p_rec.contract_id is not null)
1334: and
1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>

Line 1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>

1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>

Line 1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>

1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>

Line 1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>

1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>

Line 1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>

1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>

Line 1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>

1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>

Line 1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>

1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>

Line 1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>

1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>

Line 1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>

1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>

Line 1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>

1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>

Line 1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>

1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>

Line 1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>

1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>

Line 1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>

1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>

Line 1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>

1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>

Line 1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>

1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>

Line 1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>

1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>

Line 1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>

1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>

Line 1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>

1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>

Line 1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>

1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))
1377: then

Line 1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>

1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))
1377: then
1378: --
1379: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 1733: (p_rec in per_ctc_shd.g_rec_type,

1729: -- ----------------------------------------------------------------------------
1730: -- |---------------------------< insert_validate >----------------------------|
1731: -- ----------------------------------------------------------------------------
1732: Procedure insert_validate
1733: (p_rec in per_ctc_shd.g_rec_type,
1734: p_effective_date in date,
1735: p_datetrack_mode in varchar2,
1736: p_validation_start_date in date,
1737: p_validation_end_date in date) is

Line 1882: (p_rec in per_ctc_shd.g_rec_type,

1878: -- ----------------------------------------------------------------------------
1879: -- |---------------------------< update_validate >----------------------------|
1880: -- ----------------------------------------------------------------------------
1881: Procedure update_validate
1882: (p_rec in per_ctc_shd.g_rec_type,
1883: p_effective_date in date,
1884: p_datetrack_mode in varchar2,
1885: p_validation_start_date in date,
1886: p_validation_end_date in date) is

Line 2034: (p_rec in per_ctc_shd.g_rec_type,

2030: -- ----------------------------------------------------------------------------
2031: -- |---------------------------< delete_validate >----------------------------|
2032: -- ----------------------------------------------------------------------------
2033: Procedure delete_validate
2034: (p_rec in per_ctc_shd.g_rec_type,
2035: p_effective_date in date,
2036: p_datetrack_mode in varchar2,
2037: p_validation_start_date in date,
2038: p_validation_end_date in date) is