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: );
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: );
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
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: --
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: );
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: );
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: --
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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) ))
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)
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)
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
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: --
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:
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:
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;
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;
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;
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;