APPS.PER_EVT_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'event_id'
47: ,p_argument_value => p_event_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'event_id'
107: ,p_argument_value => p_event_id
108: );

Line 110: if ( nvl(per_evt_bus.g_event_id, hr_api.g_number)

106: ,p_argument => 'event_id'
107: ,p_argument_value => p_event_id
108: );
109: --
110: if ( nvl(per_evt_bus.g_event_id, hr_api.g_number)
111: = p_event_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.event_id is not null) and (
186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.event_id is not null) and (
186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.event_id is not null) and (
186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

185: if ((p_rec.event_id is not null) and (
186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

188: nvl(per_evt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

190: nvl(per_evt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

192: nvl(per_evt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

194: nvl(per_evt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

196: nvl(per_evt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

198: nvl(per_evt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

200: nvl(per_evt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

202: nvl(per_evt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 207: nvl(p_rec.attribute10, hr_api.g_varchar2) or

203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

204: nvl(per_evt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 209: nvl(p_rec.attribute11, hr_api.g_varchar2) or

205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

206: nvl(per_evt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

208: nvl(per_evt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

210: nvl(per_evt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

212: nvl(per_evt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

214: nvl(per_evt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

216: nvl(per_evt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

218: nvl(per_evt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

220: nvl(per_evt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.event_id is null) then

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

221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.event_id is null) then
229: --

Line 226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

222: nvl(per_evt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.event_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_evt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_evt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.event_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:
231: -- a) During update, the structure column value or any

Line 342: hr_api.argument_changed_error

338: end if;
339: --
340: EXCEPTION
341: WHEN l_error THEN
342: hr_api.argument_changed_error
343: (p_api_name => l_proc
344: ,p_argument => l_argument);
345: WHEN OTHERS THEN
346: RAISE;

Line 384: hr_api.mandatory_arg_error

380: hr_utility.set_location('Entering:'|| l_proc, 20);
381: --
382: -- Check mandatory parameters have been set
383: --
384: hr_api.mandatory_arg_error
385: (
386: p_api_name => l_proc,
387: p_argument => 'type',
388: p_argument_value => p_type

Line 440: hr_api.mandatory_arg_error

436: hr_utility.set_location('Entering:'|| l_proc, 1);
437: --
438: -- Check mandatory parameters have been set
439: --
440: hr_api.mandatory_arg_error
441: (
442: p_api_name => l_proc,
443: p_argument => 'date_start',
444: p_argument_value => p_date_start

Line 473: and (nvl(l_time_end, hr_api.g_eot) < nvl(l_time_start, hr_api.g_sot)))

469: if (p_date_end is not null) then
470:
471: if ((p_date_end < p_date_start)
472: or ( (p_date_end = p_date_start)
473: and (nvl(l_time_end, hr_api.g_eot) < nvl(l_time_start, hr_api.g_sot)))
474: ) then
475: -- raise an error with message "The Start date must be before the End date."
476: hr_utility.set_message(800, 'HR_289321_START_DATE_AFTER_END');
477: hr_utility.raise_error;

Line 526: or nvl(per_evt_shd.g_old_rec.emp_or_apl, hr_api.g_varchar2)

522: -- a) The g_old_rec is current and
523: -- b) The value for employee/applicant flag has changed
524: --
525: if (per_evt_shd.g_old_rec.event_id is null
526: or nvl(per_evt_shd.g_old_rec.emp_or_apl, hr_api.g_varchar2)
527: <> nvl(p_emp_or_apl, hr_api.g_varchar2)
528: ) then
529: --
530: hr_utility.set_location(l_proc, 20);

Line 527: <> nvl(p_emp_or_apl, hr_api.g_varchar2)

523: -- b) The value for employee/applicant flag has changed
524: --
525: if (per_evt_shd.g_old_rec.event_id is null
526: or nvl(per_evt_shd.g_old_rec.emp_or_apl, hr_api.g_varchar2)
527: <> nvl(p_emp_or_apl, hr_api.g_varchar2)
528: ) then
529: --
530: hr_utility.set_location(l_proc, 20);
531: --

Line 537: if hr_api.not_exists_in_hr_lookups

533: -- check if the value exists in hr_lookups
534: -- where the lookup_type = 'EMP_APL'
535: --
536: if p_emp_or_apl is not null then
537: if hr_api.not_exists_in_hr_lookups
538: (p_effective_date => p_date_start
539: ,p_lookup_type => 'EMP_APL'
540: ,p_lookup_code => p_emp_or_apl
541: ) then

Line 594: or nvl(per_evt_shd.g_old_rec.event_or_interview, hr_api.g_varchar2)

590: -- a) The current g_old_rec is current and
591: -- b) The value for event_or_interview has changed
592: --
593: if (per_evt_shd.g_old_rec.event_id is null
594: or nvl(per_evt_shd.g_old_rec.event_or_interview, hr_api.g_varchar2)
595: <> nvl(p_event_or_interview, hr_api.g_varchar2) ) then
596: --
597: hr_utility.set_location(l_proc, 20);
598: --

Line 595: <> nvl(p_event_or_interview, hr_api.g_varchar2) ) then

591: -- b) The value for event_or_interview has changed
592: --
593: if (per_evt_shd.g_old_rec.event_id is null
594: or nvl(per_evt_shd.g_old_rec.event_or_interview, hr_api.g_varchar2)
595: <> nvl(p_event_or_interview, hr_api.g_varchar2) ) then
596: --
597: hr_utility.set_location(l_proc, 20);
598: --
599: -- If event_or_interview is not null then

Line 605: if hr_api.not_exists_in_hr_lookups

601: -- where the lookup_type = 'EVENT_INTERVIEW'
602: --
603: --
604: if p_event_or_interview is not null then
605: if hr_api.not_exists_in_hr_lookups
606: (p_effective_date => p_date_start
607: ,p_lookup_type => 'EVENT_INTERVIEW'
608: ,p_lookup_code => p_event_or_interview
609: ) then

Line 683: and nvl(per_evt_shd.g_old_rec.internal_contact_person_id, hr_api.g_number)

679: hr_utility.set_location('new person id : ' || p_internal_contact_person_id, 13);
680:
681: if ((per_evt_shd.g_old_rec.event_id is null and p_internal_contact_person_id is not null)
682: or (per_evt_shd.g_old_rec.event_id is not null
683: and nvl(per_evt_shd.g_old_rec.internal_contact_person_id, hr_api.g_number)
684: <> nvl(p_internal_contact_person_id, hr_api.g_number))) then
685: --
686: hr_utility.set_location(l_proc, 20);
687: --

Line 684: <> nvl(p_internal_contact_person_id, hr_api.g_number))) then

680:
681: if ((per_evt_shd.g_old_rec.event_id is null and p_internal_contact_person_id is not null)
682: or (per_evt_shd.g_old_rec.event_id is not null
683: and nvl(per_evt_shd.g_old_rec.internal_contact_person_id, hr_api.g_number)
684: <> nvl(p_internal_contact_person_id, hr_api.g_number))) then
685: --
686: hr_utility.set_location(l_proc, 20);
687: --
688: -- Check that the Internal Contact Person ID is linked to a

Line 768: and p_date_start between date_from and nvl(date_to, hr_api.g_eot);

764: cursor csr_valid_org is
765: select business_group_id
766: from hr_all_organization_units hou
767: where hou.organization_id = p_organization_run_by_id
768: and p_date_start between date_from and nvl(date_to, hr_api.g_eot);
769: --
770: begin
771: hr_utility.set_location('Entering:'|| l_proc, 10);
772: --

Line 775: and nvl(per_evt_shd.g_old_rec.organization_run_by_id, hr_api.g_number)

771: hr_utility.set_location('Entering:'|| l_proc, 10);
772: --
773: if ((per_evt_shd.g_old_rec.event_id is null and p_organization_run_by_id is not null)
774: or (per_evt_shd.g_old_rec.event_id is not null
775: and nvl(per_evt_shd.g_old_rec.organization_run_by_id, hr_api.g_number)
776: <> nvl(p_organization_run_by_id, hr_api.g_number))) then
777: --
778: hr_utility.set_location(l_proc, 20);
779: --

Line 776: <> nvl(p_organization_run_by_id, hr_api.g_number))) then

772: --
773: if ((per_evt_shd.g_old_rec.event_id is null and p_organization_run_by_id is not null)
774: or (per_evt_shd.g_old_rec.event_id is not null
775: and nvl(per_evt_shd.g_old_rec.organization_run_by_id, hr_api.g_number)
776: <> nvl(p_organization_run_by_id, hr_api.g_number))) then
777: --
778: hr_utility.set_location(l_proc, 20);
779: --
780: -- Check that the Organization Run By is linked to a

Line 862: if (p_assignment_id <> hr_api.g_number) then

858: -- a) The g_old_rec is current and
859: -- b) The value for assignment has changed
860: --
861: if (p_assignment_id is not null) then
862: if (p_assignment_id <> hr_api.g_number) then
863: l_assignment_id := p_assignment_id;
864: else
865: l_assignment_id := per_evt_shd.g_old_rec.assignment_id;
866: end if;

Line 942: if p_location_id is not null and p_location_id <> hr_api.g_number then

938: --
939: begin
940: hr_utility.set_location('Entering:'|| l_proc, 10);
941: --
942: if p_location_id is not null and p_location_id <> hr_api.g_number then
943: hr_utility.set_location(l_proc, 20);
944: --
945: -- Check that the Location ID is linked to a
946: -- valid location on HR_LOCATIONS

Line 1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1075: if p_rec.party_id is null and p_rec.business_group_id is not null then
1076: --
1077: -- Call all supporting business operations
1078: --
1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1080: end if;
1081:
1082: --
1083: -- Validate CHK_EVENT_TYPE

Line 1183: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1179: if p_rec.business_group_id is not null then
1180: --
1181: -- Call all supporting business operations
1182: --
1183: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1184: end if;
1185: --
1186: chk_non_updateable_args
1187: (p_rec