APPS.OTA_ACI_BUS dependencies on OTA_ACI_SHD

Line 214: (p_rec in ota_aci_shd.g_rec_type

210: -- Internal Row Handler Use Only.
211: --
212: -- ----------------------------------------------------------------------------
213: procedure chk_ddf
214: (p_rec in ota_aci_shd.g_rec_type
215: ) is
216: --
217: v_proc varchar2(72) := g_package || 'chk_ddf';
218: --

Line 226: nvl(ota_aci_shd.g_old_rec.aci_information_category, hr_api.g_varchar2) <>

222: if (
223: --(p_rec.activity_version_id is not null)
224: --(p_rec.category_usage_id is not null) and
225: (
226: nvl(ota_aci_shd.g_old_rec.aci_information_category, hr_api.g_varchar2) <>
227: nvl(p_rec.aci_information_category, hr_api.g_varchar2) or
228: nvl(ota_aci_shd.g_old_rec.aci_information1, hr_api.g_varchar2) <>
229: nvl(p_rec.aci_information1, hr_api.g_varchar2) or
230: nvl(ota_aci_shd.g_old_rec.aci_information2, hr_api.g_varchar2) <>

Line 228: nvl(ota_aci_shd.g_old_rec.aci_information1, hr_api.g_varchar2) <>

224: --(p_rec.category_usage_id is not null) and
225: (
226: nvl(ota_aci_shd.g_old_rec.aci_information_category, hr_api.g_varchar2) <>
227: nvl(p_rec.aci_information_category, hr_api.g_varchar2) or
228: nvl(ota_aci_shd.g_old_rec.aci_information1, hr_api.g_varchar2) <>
229: nvl(p_rec.aci_information1, hr_api.g_varchar2) or
230: nvl(ota_aci_shd.g_old_rec.aci_information2, hr_api.g_varchar2) <>
231: nvl(p_rec.aci_information2, hr_api.g_varchar2) or
232: nvl(ota_aci_shd.g_old_rec.aci_information3, hr_api.g_varchar2) <>

Line 230: nvl(ota_aci_shd.g_old_rec.aci_information2, hr_api.g_varchar2) <>

226: nvl(ota_aci_shd.g_old_rec.aci_information_category, hr_api.g_varchar2) <>
227: nvl(p_rec.aci_information_category, hr_api.g_varchar2) or
228: nvl(ota_aci_shd.g_old_rec.aci_information1, hr_api.g_varchar2) <>
229: nvl(p_rec.aci_information1, hr_api.g_varchar2) or
230: nvl(ota_aci_shd.g_old_rec.aci_information2, hr_api.g_varchar2) <>
231: nvl(p_rec.aci_information2, hr_api.g_varchar2) or
232: nvl(ota_aci_shd.g_old_rec.aci_information3, hr_api.g_varchar2) <>
233: nvl(p_rec.aci_information3, hr_api.g_varchar2) or
234: nvl(ota_aci_shd.g_old_rec.aci_information4, hr_api.g_varchar2) <>

Line 232: nvl(ota_aci_shd.g_old_rec.aci_information3, hr_api.g_varchar2) <>

228: nvl(ota_aci_shd.g_old_rec.aci_information1, hr_api.g_varchar2) <>
229: nvl(p_rec.aci_information1, hr_api.g_varchar2) or
230: nvl(ota_aci_shd.g_old_rec.aci_information2, hr_api.g_varchar2) <>
231: nvl(p_rec.aci_information2, hr_api.g_varchar2) or
232: nvl(ota_aci_shd.g_old_rec.aci_information3, hr_api.g_varchar2) <>
233: nvl(p_rec.aci_information3, hr_api.g_varchar2) or
234: nvl(ota_aci_shd.g_old_rec.aci_information4, hr_api.g_varchar2) <>
235: nvl(p_rec.aci_information4, hr_api.g_varchar2) or
236: nvl(ota_aci_shd.g_old_rec.aci_information5, hr_api.g_varchar2) <>

Line 234: nvl(ota_aci_shd.g_old_rec.aci_information4, hr_api.g_varchar2) <>

230: nvl(ota_aci_shd.g_old_rec.aci_information2, hr_api.g_varchar2) <>
231: nvl(p_rec.aci_information2, hr_api.g_varchar2) or
232: nvl(ota_aci_shd.g_old_rec.aci_information3, hr_api.g_varchar2) <>
233: nvl(p_rec.aci_information3, hr_api.g_varchar2) or
234: nvl(ota_aci_shd.g_old_rec.aci_information4, hr_api.g_varchar2) <>
235: nvl(p_rec.aci_information4, hr_api.g_varchar2) or
236: nvl(ota_aci_shd.g_old_rec.aci_information5, hr_api.g_varchar2) <>
237: nvl(p_rec.aci_information5, hr_api.g_varchar2) or
238: nvl(ota_aci_shd.g_old_rec.aci_information6, hr_api.g_varchar2) <>

Line 236: nvl(ota_aci_shd.g_old_rec.aci_information5, hr_api.g_varchar2) <>

232: nvl(ota_aci_shd.g_old_rec.aci_information3, hr_api.g_varchar2) <>
233: nvl(p_rec.aci_information3, hr_api.g_varchar2) or
234: nvl(ota_aci_shd.g_old_rec.aci_information4, hr_api.g_varchar2) <>
235: nvl(p_rec.aci_information4, hr_api.g_varchar2) or
236: nvl(ota_aci_shd.g_old_rec.aci_information5, hr_api.g_varchar2) <>
237: nvl(p_rec.aci_information5, hr_api.g_varchar2) or
238: nvl(ota_aci_shd.g_old_rec.aci_information6, hr_api.g_varchar2) <>
239: nvl(p_rec.aci_information6, hr_api.g_varchar2) or
240: nvl(ota_aci_shd.g_old_rec.aci_information7, hr_api.g_varchar2) <>

Line 238: nvl(ota_aci_shd.g_old_rec.aci_information6, hr_api.g_varchar2) <>

234: nvl(ota_aci_shd.g_old_rec.aci_information4, hr_api.g_varchar2) <>
235: nvl(p_rec.aci_information4, hr_api.g_varchar2) or
236: nvl(ota_aci_shd.g_old_rec.aci_information5, hr_api.g_varchar2) <>
237: nvl(p_rec.aci_information5, hr_api.g_varchar2) or
238: nvl(ota_aci_shd.g_old_rec.aci_information6, hr_api.g_varchar2) <>
239: nvl(p_rec.aci_information6, hr_api.g_varchar2) or
240: nvl(ota_aci_shd.g_old_rec.aci_information7, hr_api.g_varchar2) <>
241: nvl(p_rec.aci_information7, hr_api.g_varchar2) or
242: nvl(ota_aci_shd.g_old_rec.aci_information8, hr_api.g_varchar2) <>

Line 240: nvl(ota_aci_shd.g_old_rec.aci_information7, hr_api.g_varchar2) <>

236: nvl(ota_aci_shd.g_old_rec.aci_information5, hr_api.g_varchar2) <>
237: nvl(p_rec.aci_information5, hr_api.g_varchar2) or
238: nvl(ota_aci_shd.g_old_rec.aci_information6, hr_api.g_varchar2) <>
239: nvl(p_rec.aci_information6, hr_api.g_varchar2) or
240: nvl(ota_aci_shd.g_old_rec.aci_information7, hr_api.g_varchar2) <>
241: nvl(p_rec.aci_information7, hr_api.g_varchar2) or
242: nvl(ota_aci_shd.g_old_rec.aci_information8, hr_api.g_varchar2) <>
243: nvl(p_rec.aci_information8, hr_api.g_varchar2) or
244: nvl(ota_aci_shd.g_old_rec.aci_information9, hr_api.g_varchar2) <>

Line 242: nvl(ota_aci_shd.g_old_rec.aci_information8, hr_api.g_varchar2) <>

238: nvl(ota_aci_shd.g_old_rec.aci_information6, hr_api.g_varchar2) <>
239: nvl(p_rec.aci_information6, hr_api.g_varchar2) or
240: nvl(ota_aci_shd.g_old_rec.aci_information7, hr_api.g_varchar2) <>
241: nvl(p_rec.aci_information7, hr_api.g_varchar2) or
242: nvl(ota_aci_shd.g_old_rec.aci_information8, hr_api.g_varchar2) <>
243: nvl(p_rec.aci_information8, hr_api.g_varchar2) or
244: nvl(ota_aci_shd.g_old_rec.aci_information9, hr_api.g_varchar2) <>
245: nvl(p_rec.aci_information9, hr_api.g_varchar2) or
246: nvl(ota_aci_shd.g_old_rec.aci_information10, hr_api.g_varchar2) <>

Line 244: nvl(ota_aci_shd.g_old_rec.aci_information9, hr_api.g_varchar2) <>

240: nvl(ota_aci_shd.g_old_rec.aci_information7, hr_api.g_varchar2) <>
241: nvl(p_rec.aci_information7, hr_api.g_varchar2) or
242: nvl(ota_aci_shd.g_old_rec.aci_information8, hr_api.g_varchar2) <>
243: nvl(p_rec.aci_information8, hr_api.g_varchar2) or
244: nvl(ota_aci_shd.g_old_rec.aci_information9, hr_api.g_varchar2) <>
245: nvl(p_rec.aci_information9, hr_api.g_varchar2) or
246: nvl(ota_aci_shd.g_old_rec.aci_information10, hr_api.g_varchar2) <>
247: nvl(p_rec.aci_information10, hr_api.g_varchar2) or
248: nvl(ota_aci_shd.g_old_rec.aci_information11, hr_api.g_varchar2) <>

Line 246: nvl(ota_aci_shd.g_old_rec.aci_information10, hr_api.g_varchar2) <>

242: nvl(ota_aci_shd.g_old_rec.aci_information8, hr_api.g_varchar2) <>
243: nvl(p_rec.aci_information8, hr_api.g_varchar2) or
244: nvl(ota_aci_shd.g_old_rec.aci_information9, hr_api.g_varchar2) <>
245: nvl(p_rec.aci_information9, hr_api.g_varchar2) or
246: nvl(ota_aci_shd.g_old_rec.aci_information10, hr_api.g_varchar2) <>
247: nvl(p_rec.aci_information10, hr_api.g_varchar2) or
248: nvl(ota_aci_shd.g_old_rec.aci_information11, hr_api.g_varchar2) <>
249: nvl(p_rec.aci_information11, hr_api.g_varchar2) or
250: nvl(ota_aci_shd.g_old_rec.aci_information12, hr_api.g_varchar2) <>

Line 248: nvl(ota_aci_shd.g_old_rec.aci_information11, hr_api.g_varchar2) <>

244: nvl(ota_aci_shd.g_old_rec.aci_information9, hr_api.g_varchar2) <>
245: nvl(p_rec.aci_information9, hr_api.g_varchar2) or
246: nvl(ota_aci_shd.g_old_rec.aci_information10, hr_api.g_varchar2) <>
247: nvl(p_rec.aci_information10, hr_api.g_varchar2) or
248: nvl(ota_aci_shd.g_old_rec.aci_information11, hr_api.g_varchar2) <>
249: nvl(p_rec.aci_information11, hr_api.g_varchar2) or
250: nvl(ota_aci_shd.g_old_rec.aci_information12, hr_api.g_varchar2) <>
251: nvl(p_rec.aci_information12, hr_api.g_varchar2) or
252: nvl(ota_aci_shd.g_old_rec.aci_information13, hr_api.g_varchar2) <>

Line 250: nvl(ota_aci_shd.g_old_rec.aci_information12, hr_api.g_varchar2) <>

246: nvl(ota_aci_shd.g_old_rec.aci_information10, hr_api.g_varchar2) <>
247: nvl(p_rec.aci_information10, hr_api.g_varchar2) or
248: nvl(ota_aci_shd.g_old_rec.aci_information11, hr_api.g_varchar2) <>
249: nvl(p_rec.aci_information11, hr_api.g_varchar2) or
250: nvl(ota_aci_shd.g_old_rec.aci_information12, hr_api.g_varchar2) <>
251: nvl(p_rec.aci_information12, hr_api.g_varchar2) or
252: nvl(ota_aci_shd.g_old_rec.aci_information13, hr_api.g_varchar2) <>
253: nvl(p_rec.aci_information13, hr_api.g_varchar2) or
254: nvl(ota_aci_shd.g_old_rec.aci_information14, hr_api.g_varchar2) <>

Line 252: nvl(ota_aci_shd.g_old_rec.aci_information13, hr_api.g_varchar2) <>

248: nvl(ota_aci_shd.g_old_rec.aci_information11, hr_api.g_varchar2) <>
249: nvl(p_rec.aci_information11, hr_api.g_varchar2) or
250: nvl(ota_aci_shd.g_old_rec.aci_information12, hr_api.g_varchar2) <>
251: nvl(p_rec.aci_information12, hr_api.g_varchar2) or
252: nvl(ota_aci_shd.g_old_rec.aci_information13, hr_api.g_varchar2) <>
253: nvl(p_rec.aci_information13, hr_api.g_varchar2) or
254: nvl(ota_aci_shd.g_old_rec.aci_information14, hr_api.g_varchar2) <>
255: nvl(p_rec.aci_information14, hr_api.g_varchar2) or
256: nvl(ota_aci_shd.g_old_rec.aci_information15, hr_api.g_varchar2) <>

Line 254: nvl(ota_aci_shd.g_old_rec.aci_information14, hr_api.g_varchar2) <>

250: nvl(ota_aci_shd.g_old_rec.aci_information12, hr_api.g_varchar2) <>
251: nvl(p_rec.aci_information12, hr_api.g_varchar2) or
252: nvl(ota_aci_shd.g_old_rec.aci_information13, hr_api.g_varchar2) <>
253: nvl(p_rec.aci_information13, hr_api.g_varchar2) or
254: nvl(ota_aci_shd.g_old_rec.aci_information14, hr_api.g_varchar2) <>
255: nvl(p_rec.aci_information14, hr_api.g_varchar2) or
256: nvl(ota_aci_shd.g_old_rec.aci_information15, hr_api.g_varchar2) <>
257: nvl(p_rec.aci_information15, hr_api.g_varchar2) or
258: nvl(ota_aci_shd.g_old_rec.aci_information16, hr_api.g_varchar2) <>

Line 256: nvl(ota_aci_shd.g_old_rec.aci_information15, hr_api.g_varchar2) <>

252: nvl(ota_aci_shd.g_old_rec.aci_information13, hr_api.g_varchar2) <>
253: nvl(p_rec.aci_information13, hr_api.g_varchar2) or
254: nvl(ota_aci_shd.g_old_rec.aci_information14, hr_api.g_varchar2) <>
255: nvl(p_rec.aci_information14, hr_api.g_varchar2) or
256: nvl(ota_aci_shd.g_old_rec.aci_information15, hr_api.g_varchar2) <>
257: nvl(p_rec.aci_information15, hr_api.g_varchar2) or
258: nvl(ota_aci_shd.g_old_rec.aci_information16, hr_api.g_varchar2) <>
259: nvl(p_rec.aci_information16, hr_api.g_varchar2) or
260: nvl(ota_aci_shd.g_old_rec.aci_information17, hr_api.g_varchar2) <>

Line 258: nvl(ota_aci_shd.g_old_rec.aci_information16, hr_api.g_varchar2) <>

254: nvl(ota_aci_shd.g_old_rec.aci_information14, hr_api.g_varchar2) <>
255: nvl(p_rec.aci_information14, hr_api.g_varchar2) or
256: nvl(ota_aci_shd.g_old_rec.aci_information15, hr_api.g_varchar2) <>
257: nvl(p_rec.aci_information15, hr_api.g_varchar2) or
258: nvl(ota_aci_shd.g_old_rec.aci_information16, hr_api.g_varchar2) <>
259: nvl(p_rec.aci_information16, hr_api.g_varchar2) or
260: nvl(ota_aci_shd.g_old_rec.aci_information17, hr_api.g_varchar2) <>
261: nvl(p_rec.aci_information17, hr_api.g_varchar2) or
262: nvl(ota_aci_shd.g_old_rec.aci_information18, hr_api.g_varchar2) <>

Line 260: nvl(ota_aci_shd.g_old_rec.aci_information17, hr_api.g_varchar2) <>

256: nvl(ota_aci_shd.g_old_rec.aci_information15, hr_api.g_varchar2) <>
257: nvl(p_rec.aci_information15, hr_api.g_varchar2) or
258: nvl(ota_aci_shd.g_old_rec.aci_information16, hr_api.g_varchar2) <>
259: nvl(p_rec.aci_information16, hr_api.g_varchar2) or
260: nvl(ota_aci_shd.g_old_rec.aci_information17, hr_api.g_varchar2) <>
261: nvl(p_rec.aci_information17, hr_api.g_varchar2) or
262: nvl(ota_aci_shd.g_old_rec.aci_information18, hr_api.g_varchar2) <>
263: nvl(p_rec.aci_information18, hr_api.g_varchar2) or
264: nvl(ota_aci_shd.g_old_rec.aci_information19, hr_api.g_varchar2) <>

Line 262: nvl(ota_aci_shd.g_old_rec.aci_information18, hr_api.g_varchar2) <>

258: nvl(ota_aci_shd.g_old_rec.aci_information16, hr_api.g_varchar2) <>
259: nvl(p_rec.aci_information16, hr_api.g_varchar2) or
260: nvl(ota_aci_shd.g_old_rec.aci_information17, hr_api.g_varchar2) <>
261: nvl(p_rec.aci_information17, hr_api.g_varchar2) or
262: nvl(ota_aci_shd.g_old_rec.aci_information18, hr_api.g_varchar2) <>
263: nvl(p_rec.aci_information18, hr_api.g_varchar2) or
264: nvl(ota_aci_shd.g_old_rec.aci_information19, hr_api.g_varchar2) <>
265: nvl(p_rec.aci_information19, hr_api.g_varchar2) or
266: nvl(ota_aci_shd.g_old_rec.aci_information20, hr_api.g_varchar2) <>

Line 264: nvl(ota_aci_shd.g_old_rec.aci_information19, hr_api.g_varchar2) <>

260: nvl(ota_aci_shd.g_old_rec.aci_information17, hr_api.g_varchar2) <>
261: nvl(p_rec.aci_information17, hr_api.g_varchar2) or
262: nvl(ota_aci_shd.g_old_rec.aci_information18, hr_api.g_varchar2) <>
263: nvl(p_rec.aci_information18, hr_api.g_varchar2) or
264: nvl(ota_aci_shd.g_old_rec.aci_information19, hr_api.g_varchar2) <>
265: nvl(p_rec.aci_information19, hr_api.g_varchar2) or
266: nvl(ota_aci_shd.g_old_rec.aci_information20, hr_api.g_varchar2) <>
267: nvl(p_rec.aci_information20, hr_api.g_varchar2) ))
268: --or (p_rec.activity_version_id is null)

Line 266: nvl(ota_aci_shd.g_old_rec.aci_information20, hr_api.g_varchar2) <>

262: nvl(ota_aci_shd.g_old_rec.aci_information18, hr_api.g_varchar2) <>
263: nvl(p_rec.aci_information18, hr_api.g_varchar2) or
264: nvl(ota_aci_shd.g_old_rec.aci_information19, hr_api.g_varchar2) <>
265: nvl(p_rec.aci_information19, hr_api.g_varchar2) or
266: nvl(ota_aci_shd.g_old_rec.aci_information20, hr_api.g_varchar2) <>
267: nvl(p_rec.aci_information20, hr_api.g_varchar2) ))
268: --or (p_rec.activity_version_id is null)
269: -- (p_rec.category_usage_id is null)
270: then

Line 356: ,p_rec in ota_aci_shd.g_rec_type

352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure chk_non_updateable_args
355: (p_effective_date in date
356: ,p_rec in ota_aci_shd.g_rec_type
357: ) IS
358: --
359: v_proc varchar2(72) := g_package || 'chk_non_updateable_args';
360: --

Line 366: IF NOT ota_aci_shd.api_updating

362: --
363: -- Only proceed with the validation if a row exists for the current
364: -- record in the HR Schema.
365: --
366: IF NOT ota_aci_shd.api_updating
367: (p_activity_version_id => p_rec.activity_version_id
368: ,p_category_usage_id => p_rec.category_usage_id
369: ,p_object_version_number => p_rec.object_version_number
370: ) THEN

Line 931: ,p_rec in ota_aci_shd.g_rec_type

927: -- |---------------------------< insert_validate >----------------------------|
928: -- ----------------------------------------------------------------------------
929: Procedure insert_validate
930: (p_effective_date in date
931: ,p_rec in ota_aci_shd.g_rec_type
932: ,p_activity_version_id in number
933: ,p_category_usage_id in number
934: ) is
935: --

Line 981: ,p_rec in ota_aci_shd.g_rec_type

977: -- |---------------------------< update_validate >----------------------------|
978: -- ----------------------------------------------------------------------------
979: Procedure update_validate
980: (p_effective_date in date
981: ,p_rec in ota_aci_shd.g_rec_type
982: ) is
983: --
984: v_proc varchar2(72) := g_package||'update_validate';
985: --

Line 987: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_version_id

983: --
984: v_proc varchar2(72) := g_package||'update_validate';
985: --
986: l_activity_version_id_changed boolean
987: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_version_id
988: , p_rec.activity_version_id );
989: --
990: l_activity_category_changed boolean
991: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_category

Line 991: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_category

987: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_version_id
988: , p_rec.activity_version_id );
989: --
990: l_activity_category_changed boolean
991: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_category
992: , p_rec.activity_category );
993: l_primary_flag_changed boolean
994: := ota_general.value_changed( ota_aci_shd.g_old_rec.primary_flag
995: , p_rec.primary_flag );

Line 994: := ota_general.value_changed( ota_aci_shd.g_old_rec.primary_flag

990: l_activity_category_changed boolean
991: := ota_general.value_changed( ota_aci_shd.g_old_rec.activity_category
992: , p_rec.activity_category );
993: l_primary_flag_changed boolean
994: := ota_general.value_changed( ota_aci_shd.g_old_rec.primary_flag
995: , p_rec.primary_flag );
996: --
997: --
998: Begin

Line 1066: (p_rec in ota_aci_shd.g_rec_type

1062: -- ----------------------------------------------------------------------------
1063: -- |---------------------------< delete_validate >----------------------------|
1064: -- ----------------------------------------------------------------------------
1065: Procedure delete_validate
1066: (p_rec in ota_aci_shd.g_rec_type
1067: ) is
1068: --
1069: v_proc varchar2(72) := g_package||'delete_validate';
1070: --