49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error
54: (p_api_name => l_proc
55: ,p_argument => 'communication_property_id'
56: ,p_argument_value => p_communication_property_id
57: );
76: close csr_sec_grp;
77: --
78: -- Set the security_group_id in CLIENT_INFO
79: --
80: hr_api.set_security_group_id
81: (p_security_group_id => l_security_group_id
82: );
83: --
84: -- Set the sessions legislation context in HR_SESSION_DATA
82: );
83: --
84: -- Set the sessions legislation context in HR_SESSION_DATA
85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error
129: (p_api_name => l_proc
130: ,p_argument => 'communication_property_id'
131: ,p_argument_value => p_communication_property_id
132: );
130: ,p_argument => 'communication_property_id'
131: ,p_argument_value => p_communication_property_id
132: );
133: --
134: if ( nvl(irc_cmp_bus.g_communication_property_id, hr_api.g_number)
135: = p_communication_property_id) then
136: --
137: -- The legislation code has already been found with a previous
138: -- call to this function. Just return the value in the global
206: begin
207: hr_utility.set_location('Entering:'||l_proc,10);
208: --
209: if ((p_rec.communication_property_id is not null) and (
210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
207: hr_utility.set_location('Entering:'||l_proc,10);
208: --
209: if ((p_rec.communication_property_id is not null) and (
210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
208: --
209: if ((p_rec.communication_property_id is not null) and (
210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
209: if ((p_rec.communication_property_id is not null) and (
210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
213: nvl(p_rec.information1, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
215: nvl(p_rec.information2, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
217: nvl(p_rec.information3, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
219: nvl(p_rec.information4, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
221: nvl(p_rec.information5, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
223: nvl(p_rec.information6, hr_api.g_varchar2) or
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
231: nvl(p_rec.information10, hr_api.g_varchar2) ))
224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
231: nvl(p_rec.information10, hr_api.g_varchar2) ))
232: or (p_rec.communication_property_id is null) then
225: nvl(p_rec.information7, hr_api.g_varchar2) or
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
231: nvl(p_rec.information10, hr_api.g_varchar2) ))
232: or (p_rec.communication_property_id is null) then
233: --
226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
231: nvl(p_rec.information10, hr_api.g_varchar2) ))
232: or (p_rec.communication_property_id is null) then
233: --
234: -- Only execute the validation if absolutely necessary:
227: nvl(p_rec.information8, hr_api.g_varchar2) or
228: nvl(irc_cmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
229: nvl(p_rec.information9, hr_api.g_varchar2) or
230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
231: nvl(p_rec.information10, hr_api.g_varchar2) ))
232: or (p_rec.communication_property_id is null) then
233: --
234: -- Only execute the validation if absolutely necessary:
235: -- a) During update, the structure column value or any
303: begin
304: hr_utility.set_location('Entering:'||l_proc,10);
305: --
306: if ((p_rec.communication_property_id is not null) and (
307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
304: hr_utility.set_location('Entering:'||l_proc,10);
305: --
306: if ((p_rec.communication_property_id is not null) and (
307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
305: --
306: if ((p_rec.communication_property_id is not null) and (
307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
306: if ((p_rec.communication_property_id is not null) and (
307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute1, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute2, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute3, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute4, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
318: nvl(p_rec.attribute5, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
320: nvl(p_rec.attribute6, hr_api.g_varchar2) or
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
329: or (p_rec.communication_property_id is null) then
322: nvl(p_rec.attribute7, hr_api.g_varchar2) or
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
329: or (p_rec.communication_property_id is null) then
330: --
323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
329: or (p_rec.communication_property_id is null) then
330: --
331: -- Only execute the validation if absolutely necessary:
324: nvl(p_rec.attribute8, hr_api.g_varchar2) or
325: nvl(irc_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute9, hr_api.g_varchar2) or
327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
329: or (p_rec.communication_property_id is null) then
330: --
331: -- Only execute the validation if absolutely necessary:
332: -- a) During update, the structure column value or any
416: -- not been updated.
417: --
418: IF p_rec.object_type <>
419: irc_cmp_shd.g_old_rec.object_type then
420: hr_api.argument_changed_error
421: (p_api_name => l_proc
422: ,p_argument => 'OBJECT_TYPE'
423: ,p_base_table => irc_cmp_shd.g_tab_nam
424: );
425: END IF;
426: --
427: IF p_rec.object_id <> irc_cmp_shd.g_old_rec.object_id THEN
428: IF p_rec.object_type = 'VACANCY' THEN
429: hr_api.argument_changed_error
430: ( p_api_name => l_proc
431: ,p_argument => 'VACANCY_ID'
432: ,p_base_table => irc_cmp_shd.g_tab_nam
433: );
478: (p_communication_property_id => p_communication_property_id,
479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and nvl(p_status,hr_api.g_varchar2)
483: <> nvl(irc_cmp_shd.g_old_rec.default_comm_status,hr_api.g_varchar2)
484: or not l_api_updating) then
485: --
486: -- check if value of type falls within lookup.
479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and nvl(p_status,hr_api.g_varchar2)
483: <> nvl(irc_cmp_shd.g_old_rec.default_comm_status,hr_api.g_varchar2)
484: or not l_api_updating) then
485: --
486: -- check if value of type falls within lookup.
487: --
484: or not l_api_updating) then
485: --
486: -- check if value of type falls within lookup.
487: --
488: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_DEFAULT_COMM_STATUS',
489: p_lookup_code => p_status,
490: p_effective_date => sysdate)
491: then
492: --
542: (p_communication_property_id => p_communication_property_id,
543: p_object_version_number => p_object_version_number);
544: --
545: if (l_api_updating
546: and nvl(p_flag,hr_api.g_varchar2)
547: <> nvl(irc_cmp_shd.g_old_rec.allow_attachment_flag,hr_api.g_varchar2)
548: or not l_api_updating) then
549: --
550: -- check if value of type falls within lookup.
543: p_object_version_number => p_object_version_number);
544: --
545: if (l_api_updating
546: and nvl(p_flag,hr_api.g_varchar2)
547: <> nvl(irc_cmp_shd.g_old_rec.allow_attachment_flag,hr_api.g_varchar2)
548: or not l_api_updating) then
549: --
550: -- check if value of type falls within lookup.
551: --
548: or not l_api_updating) then
549: --
550: -- check if value of type falls within lookup.
551: --
552: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_ALLOW_ATTACHMENT_FLAG',
553: p_lookup_code => p_flag,
554: p_effective_date => sysdate)
555: then
556: --
606: (p_communication_property_id => p_communication_property_id,
607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating
610: and nvl(p_allow_add_recipients,hr_api.g_varchar2)
611: <> nvl(irc_cmp_shd.g_old_rec.allow_add_recipients,hr_api.g_varchar2)
612: or not l_api_updating) then
613: --
614: -- check if value of type falls within lookup.
607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating
610: and nvl(p_allow_add_recipients,hr_api.g_varchar2)
611: <> nvl(irc_cmp_shd.g_old_rec.allow_add_recipients,hr_api.g_varchar2)
612: or not l_api_updating) then
613: --
614: -- check if value of type falls within lookup.
615: --
612: or not l_api_updating) then
613: --
614: -- check if value of type falls within lookup.
615: --
616: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_ALLOW_ADD_RECIPIENTS',
617: p_lookup_code => p_allow_add_recipients,
618: p_effective_date => sysdate)
619: then
620: --
670: (p_communication_property_id => p_communication_property_id,
671: p_object_version_number => p_object_version_number);
672: --
673: if (l_api_updating
674: and nvl(p_auto_notification_flag,hr_api.g_varchar2)
675: <> nvl(irc_cmp_shd.g_old_rec.auto_notification_flag,hr_api.g_varchar2)
676: or not l_api_updating) then
677: --
678: -- check if value of type falls within lookup.
671: p_object_version_number => p_object_version_number);
672: --
673: if (l_api_updating
674: and nvl(p_auto_notification_flag,hr_api.g_varchar2)
675: <> nvl(irc_cmp_shd.g_old_rec.auto_notification_flag,hr_api.g_varchar2)
676: or not l_api_updating) then
677: --
678: -- check if value of type falls within lookup.
679: --
676: or not l_api_updating) then
677: --
678: -- check if value of type falls within lookup.
679: --
680: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'YES_NO',
681: p_lookup_code => p_auto_notification_flag,
682: p_effective_date => sysdate)
683: then
684: --
734: (p_communication_property_id => p_communication_property_id,
735: p_object_version_number => p_object_version_number);
736: --
737: if (l_api_updating
738: and nvl(p_default_moderator,hr_api.g_varchar2)
739: <> nvl(irc_cmp_shd.g_old_rec.default_moderator,hr_api.g_varchar2)
740: or not l_api_updating) then
741: --
742: -- check if value of type falls within lookup.
735: p_object_version_number => p_object_version_number);
736: --
737: if (l_api_updating
738: and nvl(p_default_moderator,hr_api.g_varchar2)
739: <> nvl(irc_cmp_shd.g_old_rec.default_moderator,hr_api.g_varchar2)
740: or not l_api_updating) then
741: --
742: -- check if value of type falls within lookup.
743: --
740: or not l_api_updating) then
741: --
742: -- check if value of type falls within lookup.
743: --
744: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_DEFAULT_MODERATOR',
745: p_lookup_code => p_default_moderator,
746: p_effective_date => sysdate)
747: then
748: --
804: --
805: begin
806: hr_utility.set_location('Entering:'||l_proc,10);
807: -- Check that object_id is not null.
808: hr_api.mandatory_arg_error
809: (p_api_name => l_proc
810: ,p_argument => 'OBJECT_ID'
811: ,p_argument_value => p_object_id
812: );
878: --
879: begin
880: hr_utility.set_location('Entering:'||l_proc,10);
881: -- Check that object_type is not null.
882: hr_api.mandatory_arg_error
883: (p_api_name => l_proc
884: ,p_argument => 'OBJECT_TYPE'
885: ,p_argument_value => p_object_type
886: );