APPS.IRC_CMP_BUS dependencies on HR_API

Line 53: hr_api.mandatory_arg_error

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

Line 80: hr_api.set_security_group_id

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

Line 86: hr_api.set_legislation_context(l_legislation_code);

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

Line 128: hr_api.mandatory_arg_error

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

Line 134: if ( nvl(irc_cmp_bus.g_communication_property_id, hr_api.g_number)

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

Line 210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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

Line 211: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

Line 212: nvl(irc_cmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

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

Line 213: nvl(p_rec.information1, hr_api.g_varchar2) or

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

Line 214: nvl(irc_cmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

Line 215: nvl(p_rec.information2, hr_api.g_varchar2) or

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

Line 216: nvl(irc_cmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

Line 217: nvl(p_rec.information3, hr_api.g_varchar2) or

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

Line 218: nvl(irc_cmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

Line 219: nvl(p_rec.information4, hr_api.g_varchar2) or

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

Line 220: nvl(irc_cmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

Line 221: nvl(p_rec.information5, hr_api.g_varchar2) or

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

Line 222: nvl(irc_cmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

Line 223: nvl(p_rec.information6, hr_api.g_varchar2) or

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

Line 224: nvl(irc_cmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

Line 225: nvl(p_rec.information7, hr_api.g_varchar2) or

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

Line 226: nvl(irc_cmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

Line 227: nvl(p_rec.information8, hr_api.g_varchar2) or

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

Line 228: nvl(irc_cmp_shd.g_old_rec.information9, 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

Line 229: nvl(p_rec.information9, hr_api.g_varchar2) or

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

Line 230: nvl(irc_cmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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:

Line 231: nvl(p_rec.information10, 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:
235: -- a) During update, the structure column value or any

Line 307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

Line 308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

Line 309: nvl(irc_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

Line 310: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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

Line 311: nvl(irc_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 312: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 313: nvl(irc_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 314: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 315: nvl(irc_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 316: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 317: nvl(irc_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 318: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 319: nvl(irc_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 320: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 321: nvl(irc_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 322: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 323: nvl(irc_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 324: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 325: nvl(irc_cmp_shd.g_old_rec.attribute9, 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

Line 326: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 327: nvl(irc_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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:

Line 328: nvl(p_rec.attribute10, 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:
332: -- a) During update, the structure column value or any

Line 420: hr_api.argument_changed_error

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

Line 429: hr_api.argument_changed_error

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

Line 482: and nvl(p_status,hr_api.g_varchar2)

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.

Line 483: <> nvl(irc_cmp_shd.g_old_rec.default_comm_status,hr_api.g_varchar2)

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

Line 488: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_DEFAULT_COMM_STATUS',

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

Line 546: and nvl(p_flag,hr_api.g_varchar2)

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.

Line 547: <> nvl(irc_cmp_shd.g_old_rec.allow_attachment_flag,hr_api.g_varchar2)

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

Line 552: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_ALLOW_ATTACHMENT_FLAG',

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

Line 610: and nvl(p_allow_add_recipients,hr_api.g_varchar2)

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.

Line 611: <> nvl(irc_cmp_shd.g_old_rec.allow_add_recipients,hr_api.g_varchar2)

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

Line 616: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_ALLOW_ADD_RECIPIENTS',

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

Line 674: and nvl(p_auto_notification_flag,hr_api.g_varchar2)

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.

Line 675: <> nvl(irc_cmp_shd.g_old_rec.auto_notification_flag,hr_api.g_varchar2)

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

Line 680: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'YES_NO',

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

Line 738: and nvl(p_default_moderator,hr_api.g_varchar2)

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.

Line 739: <> nvl(irc_cmp_shd.g_old_rec.default_moderator,hr_api.g_varchar2)

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

Line 744: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_DEFAULT_MODERATOR',

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

Line 808: hr_api.mandatory_arg_error

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

Line 882: hr_api.mandatory_arg_error

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