APPS.OTA_CTU_BUS dependencies on OTA_CTU_SHD

Line 189: (p_rec in ota_ctu_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in ota_ctu_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(ota_ctu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.category_usage_id is not null) and (
198: nvl(ota_ctu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_ctu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_ctu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(ota_ctu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.category_usage_id is not null) and (
198: nvl(ota_ctu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_ctu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_ctu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_ctu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(ota_ctu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

198: nvl(ota_ctu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_ctu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_ctu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_ctu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_ctu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(ota_ctu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

200: nvl(ota_ctu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_ctu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_ctu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_ctu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_ctu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(ota_ctu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

202: nvl(ota_ctu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_ctu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_ctu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_ctu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_ctu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(ota_ctu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

204: nvl(ota_ctu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_ctu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_ctu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_ctu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_ctu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(ota_ctu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

206: nvl(ota_ctu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_ctu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_ctu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_ctu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_ctu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(ota_ctu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

208: nvl(ota_ctu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_ctu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_ctu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_ctu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_ctu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(ota_ctu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

210: nvl(ota_ctu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_ctu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_ctu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_ctu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_ctu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(ota_ctu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

212: nvl(ota_ctu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_ctu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_ctu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_ctu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_ctu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(ota_ctu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

214: nvl(ota_ctu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_ctu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_ctu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_ctu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_ctu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(ota_ctu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

216: nvl(ota_ctu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_ctu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_ctu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_ctu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_ctu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(ota_ctu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

218: nvl(ota_ctu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_ctu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_ctu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_ctu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_ctu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(ota_ctu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

220: nvl(ota_ctu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_ctu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_ctu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_ctu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_ctu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(ota_ctu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

222: nvl(ota_ctu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_ctu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_ctu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_ctu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_ctu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 228: nvl(ota_ctu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

224: nvl(ota_ctu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_ctu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_ctu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_ctu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_ctu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 230: nvl(ota_ctu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

226: nvl(ota_ctu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_ctu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_ctu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_ctu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_ctu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 232: nvl(ota_ctu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

228: nvl(ota_ctu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_ctu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_ctu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_ctu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_ctu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 234: nvl(ota_ctu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

230: nvl(ota_ctu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_ctu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_ctu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_ctu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_ctu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 236: nvl(ota_ctu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

232: nvl(ota_ctu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_ctu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_ctu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_ctu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2)))
240: or (p_rec.category_usage_id is null) then

Line 238: nvl(ota_ctu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

234: nvl(ota_ctu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_ctu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_ctu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2)))
240: or (p_rec.category_usage_id is null) then
241: --
242: -- Only execute the validation if absolutely necessary:

Line 866: ,p_rec in ota_ctu_shd.g_rec_type

862: -- {End Of Comments}
863: -- ----------------------------------------------------------------------------
864: Procedure chk_non_updateable_args
865: (p_effective_date in date
866: ,p_rec in ota_ctu_shd.g_rec_type
867: ) IS
868: --
869: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
870: --

Line 876: IF NOT ota_ctu_shd.api_updating

872: --
873: -- Only proceed with the validation if a row exists for the current
874: -- record in the HR Schema.
875: --
876: IF NOT ota_ctu_shd.api_updating
877: (p_category_usage_id => p_rec.category_usage_id
878: ,p_object_version_number => p_rec.object_version_number
879: ) THEN
880: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 962: ,p_rec in ota_ctu_shd.g_rec_type

958: -- |---------------------------< insert_validate >----------------------------|
959: -- ----------------------------------------------------------------------------
960: Procedure insert_validate
961: (p_effective_date in date
962: ,p_rec in ota_ctu_shd.g_rec_type
963: ) is
964: --
965: l_proc varchar2(72) := g_package||'insert_validate';
966: --

Line 974: ,p_associated_column1 => ota_ctu_shd.g_tab_nam

970: -- Call all supporting business operations
971: --
972: hr_api.validate_bus_grp_id
973: (p_business_group_id => p_rec.business_group_id
974: ,p_associated_column1 => ota_ctu_shd.g_tab_nam
975: || '.BUSINESS_GROUP_ID');
976: --
977: -- After validating the set of important attributes,
978: -- if Multiple Message detection is enabled and at least

Line 1045: ,p_rec in ota_ctu_shd.g_rec_type

1041: -- |---------------------------< update_validate >----------------------------|
1042: -- ----------------------------------------------------------------------------
1043: Procedure update_validate
1044: (p_effective_date in date
1045: ,p_rec in ota_ctu_shd.g_rec_type
1046: ) is
1047: --
1048: l_proc varchar2(72) := g_package||'update_validate';
1049: --

Line 1057: ,p_associated_column1 => ota_ctu_shd.g_tab_nam

1053: -- Call all supporting business operations
1054: --
1055: hr_api.validate_bus_grp_id
1056: (p_business_group_id => p_rec.business_group_id
1057: ,p_associated_column1 => ota_ctu_shd.g_tab_nam
1058: || '.BUSINESS_GROUP_ID');
1059: --
1060: -- After validating the set of important attributes,
1061: -- if Multiple Message detection is enabled and at least

Line 1129: IF ( p_rec.online_flag <> ota_ctu_shd.g_old_rec.online_flag

1125: ,p_start_date => p_rec.start_date_active
1126: ,p_end_date => p_rec.end_date_active
1127: );
1128: --
1129: IF ( p_rec.online_flag <> ota_ctu_shd.g_old_rec.online_flag
1130: or p_rec.synchronous_flag <> ota_ctu_shd.g_old_rec.synchronous_flag )THEN
1131: --
1132: Chk_Sync_Online_Flag
1133: (p_category_usage_id => p_rec.category_usage_id

Line 1130: or p_rec.synchronous_flag <> ota_ctu_shd.g_old_rec.synchronous_flag )THEN

1126: ,p_end_date => p_rec.end_date_active
1127: );
1128: --
1129: IF ( p_rec.online_flag <> ota_ctu_shd.g_old_rec.online_flag
1130: or p_rec.synchronous_flag <> ota_ctu_shd.g_old_rec.synchronous_flag )THEN
1131: --
1132: Chk_Sync_Online_Flag
1133: (p_category_usage_id => p_rec.category_usage_id
1134: ,p_online_flag => p_rec.online_flag

Line 1161: (p_rec in ota_ctu_shd.g_rec_type

1157: -- ----------------------------------------------------------------------------
1158: -- |---------------------------< delete_validate >----------------------------|
1159: -- ----------------------------------------------------------------------------
1160: Procedure delete_validate
1161: (p_rec in ota_ctu_shd.g_rec_type
1162: ) is
1163: --
1164: CURSOR cur_category_type is
1165: select