APPS.OTA_ACI_BUS dependencies on HR_API

Line 53: hr_api.mandatory_arg_error

49: hr_utility.set_location('Entering:'|| v_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error
54: (p_api_name => v_proc
55: ,p_argument => 'activity_version_id'
56: ,p_argument_value => p_activity_version_id
57: );

Line 58: hr_api.mandatory_arg_error

54: (p_api_name => v_proc
55: ,p_argument => 'activity_version_id'
56: ,p_argument_value => p_activity_version_id
57: );
58: hr_api.mandatory_arg_error
59: (p_api_name => v_proc
60: ,p_argument => 'category_usage_id'
61: ,p_argument_value => p_category_usage_id
62: );

Line 87: hr_api.set_security_group_id

83: close csr_sec_grp;
84: --
85: -- Set the security_group_id in CLIENT_INFO
86: --
87: hr_api.set_security_group_id
88: (p_security_group_id => l_security_group_id
89: );
90: --
91: -- Set the sessions legislation context in HR_SESSION_DATA

Line 93: hr_api.set_legislation_context(l_legislation_code);

89: );
90: --
91: -- Set the sessions legislation context in HR_SESSION_DATA
92: --
93: hr_api.set_legislation_context(l_legislation_code);
94: end if;
95: --
96: hr_utility.set_location(' Leaving:'|| v_proc, 20);
97: --

Line 133: hr_api.mandatory_arg_error

129: hr_utility.set_location('Entering:'|| v_proc, 10);
130: --
131: -- Ensure that all the mandatory parameter are not null
132: --
133: hr_api.mandatory_arg_error
134: (p_api_name => v_proc
135: ,p_argument => 'activity_version_id'
136: ,p_argument_value => p_activity_version_id
137: );

Line 138: hr_api.mandatory_arg_error

134: (p_api_name => v_proc
135: ,p_argument => 'activity_version_id'
136: ,p_argument_value => p_activity_version_id
137: );
138: hr_api.mandatory_arg_error
139: (p_api_name => v_proc
140: ,p_argument => 'category_usage_id'
141: ,p_argument_value => p_category_usage_id
142: );

Line 144: if (( nvl(ota_aci_bus.g_activity_version_id, hr_api.g_number)

140: ,p_argument => 'category_usage_id'
141: ,p_argument_value => p_category_usage_id
142: );
143: --
144: if (( nvl(ota_aci_bus.g_activity_version_id, hr_api.g_number)
145: = p_activity_version_id)
146: and ( nvl(ota_aci_bus.g_category_usage_id, hr_api.g_number)
147: = p_category_usage_id)) then
148: --

Line 146: and ( nvl(ota_aci_bus.g_category_usage_id, hr_api.g_number)

142: );
143: --
144: if (( nvl(ota_aci_bus.g_activity_version_id, hr_api.g_number)
145: = p_activity_version_id)
146: and ( nvl(ota_aci_bus.g_category_usage_id, hr_api.g_number)
147: = p_category_usage_id)) then
148: --
149: -- The legislation code has already been found with a previous
150: -- call to this function. Just return the value in the global

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 227: nvl(p_rec.aci_information_category, hr_api.g_varchar2) or

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) <>
231: nvl(p_rec.aci_information2, hr_api.g_varchar2) or

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 229: nvl(p_rec.aci_information1, hr_api.g_varchar2) or

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) <>
233: nvl(p_rec.aci_information3, hr_api.g_varchar2) or

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 231: nvl(p_rec.aci_information2, hr_api.g_varchar2) or

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) <>
235: nvl(p_rec.aci_information4, hr_api.g_varchar2) or

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 233: nvl(p_rec.aci_information3, hr_api.g_varchar2) or

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) <>
237: nvl(p_rec.aci_information5, hr_api.g_varchar2) or

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 235: nvl(p_rec.aci_information4, hr_api.g_varchar2) or

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) <>
239: nvl(p_rec.aci_information6, hr_api.g_varchar2) or

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 237: nvl(p_rec.aci_information5, hr_api.g_varchar2) or

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) <>
241: nvl(p_rec.aci_information7, hr_api.g_varchar2) or

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 239: nvl(p_rec.aci_information6, hr_api.g_varchar2) or

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) <>
243: nvl(p_rec.aci_information8, hr_api.g_varchar2) or

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 241: nvl(p_rec.aci_information7, hr_api.g_varchar2) or

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) <>
245: nvl(p_rec.aci_information9, hr_api.g_varchar2) or

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 243: nvl(p_rec.aci_information8, hr_api.g_varchar2) or

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) <>
247: nvl(p_rec.aci_information10, hr_api.g_varchar2) or

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 245: nvl(p_rec.aci_information9, hr_api.g_varchar2) or

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) <>
249: nvl(p_rec.aci_information11, hr_api.g_varchar2) or

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 247: nvl(p_rec.aci_information10, hr_api.g_varchar2) or

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) <>
251: nvl(p_rec.aci_information12, hr_api.g_varchar2) or

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 249: nvl(p_rec.aci_information11, hr_api.g_varchar2) or

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) <>
253: nvl(p_rec.aci_information13, hr_api.g_varchar2) or

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 251: nvl(p_rec.aci_information12, hr_api.g_varchar2) or

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) <>
255: nvl(p_rec.aci_information14, hr_api.g_varchar2) or

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 253: nvl(p_rec.aci_information13, hr_api.g_varchar2) or

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) <>
257: nvl(p_rec.aci_information15, hr_api.g_varchar2) or

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 255: nvl(p_rec.aci_information14, hr_api.g_varchar2) or

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) <>
259: nvl(p_rec.aci_information16, hr_api.g_varchar2) or

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 257: nvl(p_rec.aci_information15, hr_api.g_varchar2) or

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) <>
261: nvl(p_rec.aci_information17, hr_api.g_varchar2) or

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 259: nvl(p_rec.aci_information16, hr_api.g_varchar2) or

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) <>
263: nvl(p_rec.aci_information18, hr_api.g_varchar2) or

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 261: nvl(p_rec.aci_information17, hr_api.g_varchar2) or

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) <>
265: nvl(p_rec.aci_information19, hr_api.g_varchar2) or

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 263: nvl(p_rec.aci_information18, hr_api.g_varchar2) or

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) <>
267: nvl(p_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 265: nvl(p_rec.aci_information19, hr_api.g_varchar2) or

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)
269: -- (p_rec.category_usage_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 267: nvl(p_rec.aci_information20, 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
271: --

Line 402: nvl(end_date_active, hr_api.g_eot ),

398:
399: CURSOR csr_cat_start_end_date is
400: SELECT
401: start_date_active,
402: nvl(end_date_active, hr_api.g_eot ),
403: type
404: FROM ota_category_usages
405: WHERE category_usage_id =p_category_usage_id;
406:

Line 410: nvl(end_date, hr_api.g_eot)

406:
407: CURSOR csr_course_start_end_date IS
408: SELECT
409: start_date,
410: nvl(end_date, hr_api.g_eot)
411: FROM ota_activity_versions
412: WHERE activity_version_id = p_activity_version_id;
413:
414:

Line 689: If nvl( p_end_date, hr_api.g_eot) < v_start_date Then

685: End if;
686: --
687: -- Child enddate is earlier than parent startdate
688: --
689: If nvl( p_end_date, hr_api.g_eot) < v_start_date Then
690: --
691: l_error := TRUE;
692: --
693: End if;

Line 703: If nvl(p_start_date, hr_api.g_sot) > v_end_date Then

699: If v_end_date is not null Then
700: --
701: -- Child startdate is later than parent enddate
702: --
703: If nvl(p_start_date, hr_api.g_sot) > v_end_date Then
704: --
705: l_error := TRUE;
706: --
707: End if;

Line 809: If nvl( p_end_date, hr_api.g_eot) < v_start_date Then

805: End if;
806: --
807: -- Child enddate is earlier than parent startdate
808: --
809: If nvl( p_end_date, hr_api.g_eot) < v_start_date Then
810: --
811: l_error := TRUE;
812: --
813: End if;

Line 823: If nvl(p_start_date, hr_api.g_sot) > v_end_date Then

819: If v_end_date is not null Then
820: --
821: -- Child startdate is later than parent enddate
822: --
823: If nvl(p_start_date, hr_api.g_sot) > v_end_date Then
824: --
825: l_error := TRUE;
826: --
827: End if;