APPS.PER_VAC_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

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

Line 69: hr_api.set_security_group_id

65: close csr_sec_grp;
66: --
67: -- Set the security_group_id in CLIENT_INFO
68: --
69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: end if;

Line 107: hr_api.mandatory_arg_error

103: hr_utility.set_location('Entering:'|| l_proc, 10);
104: --
105: -- Ensure that all the mandatory parameter are not null
106: --
107: hr_api.mandatory_arg_error
108: (p_api_name => l_proc
109: ,p_argument => 'vacancy_id'
110: ,p_argument_value => p_vacancy_id
111: );

Line 113: if ( nvl(per_vac_bus.g_vacancy_id, hr_api.g_number)

109: ,p_argument => 'vacancy_id'
110: ,p_argument_value => p_vacancy_id
111: );
112: --
113: if ( nvl(per_vac_bus.g_vacancy_id, hr_api.g_number)
114: = p_vacancy_id) then
115: --
116: -- The legislation code has already been found with a previous
117: -- call to this function. Just return the value in the global

Line 189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

186: hr_utility.set_location('Entering:'||l_proc,10);
187: --
188: if ((p_rec.vacancy_id is not null) and (
189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

187: --
188: if ((p_rec.vacancy_id is not null) and (
189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

188: if ((p_rec.vacancy_id is not null) and (
189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

Line 195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

Line 197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

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

Line 199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

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

Line 201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

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

Line 203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

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

Line 205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

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

Line 207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

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

Line 209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

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

Line 211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

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

Line 213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

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

Line 215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

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

Line 217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

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

Line 219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

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

Line 221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

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

Line 223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

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

Line 225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
231: or (p_rec.vacancy_id is null) then

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

224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
231: or (p_rec.vacancy_id is null) then
232: --

Line 229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
231: or (p_rec.vacancy_id is null) then
232: --
233: -- Only execute the validation if absolutely necessary:

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

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

Line 339: hr_api.argument_changed_error

335:
336:
337: if per_vac_shd.g_old_rec.business_group_id <> p_rec.business_group_id
338: then
339: hr_api.argument_changed_error
340: (p_api_name => l_proc
341: ,p_argument => 'business_group_id'
342: ,p_base_table => per_vac_shd.g_tab_name
343: );

Line 347: hr_api.argument_changed_error

343: );
344: end if;
345:
346: if per_vac_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id then
347: hr_api.argument_changed_error
348: (p_api_name => l_proc
349: ,p_argument => 'vacancy_id'
350: ,p_base_table => per_vac_shd.g_tab_name
351: );

Line 355: hr_api.argument_changed_error

351: );
352: end if;
353:
354: if per_vac_shd.g_old_rec.name <> p_rec.name then
355: hr_api.argument_changed_error
356: (p_api_name => l_proc
357: ,p_argument => 'name'
358: ,p_base_table => per_vac_shd.g_tab_name
359: );

Line 405: hr_api.mandatory_arg_error

401: hr_utility.set_location('Entering:'||l_proc,10);
402: --
403: if (p_name is null)
404: then
405: hr_api.mandatory_arg_error
406: (p_api_name => l_proc
407: ,p_argument => 'NAME'
408: ,p_argument_value => p_name
409: );

Line 481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>

477: --
478: hr_utility.set_location(l_proc,20);
479: if ((l_api_updating
480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or
483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>
484: nvl(p_date_to, hr_api.g_date)))
485: or

Line 482: nvl(p_date_from, hr_api.g_date) or

478: hr_utility.set_location(l_proc,20);
479: if ((l_api_updating
480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or
483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>
484: nvl(p_date_to, hr_api.g_date)))
485: or
486: (NOT l_api_updating)) then

Line 483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>

479: if ((l_api_updating
480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or
483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>
484: nvl(p_date_to, hr_api.g_date)))
485: or
486: (NOT l_api_updating)) then
487: --

Line 484: nvl(p_date_to, hr_api.g_date)))

480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or
483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>
484: nvl(p_date_to, hr_api.g_date)))
485: or
486: (NOT l_api_updating)) then
487: --
488: hr_utility.set_location(l_proc,30);

Line 499: if (p_date_from > nvl(p_date_to,hr_api.g_eot))

495: hr_multi_message.end_validation_set();
496: end if;
497: hr_utility.set_location(l_proc,40);
498: --
499: if (p_date_from > nvl(p_date_to,hr_api.g_eot))
500: then
501: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
502: hr_multi_message.add
503: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'

Line 558: nvl(per_vac_shd.g_old_rec.status, hr_api.g_varchar2) <>

554: --
555: hr_utility.set_location(l_proc,20);
556: if ((l_api_updating
557: and
558: nvl(per_vac_shd.g_old_rec.status, hr_api.g_varchar2) <>
559: nvl(p_status, hr_api.g_varchar2))
560: or
561: (NOT l_api_updating)) then
562: if (p_status is not null)

Line 559: nvl(p_status, hr_api.g_varchar2))

555: hr_utility.set_location(l_proc,20);
556: if ((l_api_updating
557: and
558: nvl(per_vac_shd.g_old_rec.status, hr_api.g_varchar2) <>
559: nvl(p_status, hr_api.g_varchar2))
560: or
561: (NOT l_api_updating)) then
562: if (p_status is not null)
563: then

Line 564: l_exists := hr_api.not_exists_in_hr_lookups(p_effective_date

560: or
561: (NOT l_api_updating)) then
562: if (p_status is not null)
563: then
564: l_exists := hr_api.not_exists_in_hr_lookups(p_effective_date
565: ,'VACANCY_STATUS'
566: ,p_status);
567: hr_utility.set_location(l_proc,30);
568: if (l_exists = true)

Line 636: nvl(per_vac_shd.g_old_rec.budget_measurement_type,hr_api.g_varchar2) <>

632: --
633: hr_utility.set_location(l_proc,20);
634: if ((l_api_updating
635: and
636: nvl(per_vac_shd.g_old_rec.budget_measurement_type,hr_api.g_varchar2) <>
637: nvl(p_budget_measurement_type, hr_api.g_varchar2))
638: or
639: (NOT l_api_updating)) then
640: --

Line 637: nvl(p_budget_measurement_type, hr_api.g_varchar2))

633: hr_utility.set_location(l_proc,20);
634: if ((l_api_updating
635: and
636: nvl(per_vac_shd.g_old_rec.budget_measurement_type,hr_api.g_varchar2) <>
637: nvl(p_budget_measurement_type, hr_api.g_varchar2))
638: or
639: (NOT l_api_updating)) then
640: --
641: if (p_budget_measurement_type is not null)

Line 643: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date

639: (NOT l_api_updating)) then
640: --
641: if (p_budget_measurement_type is not null)
642: then
643: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date
644: ,'BUDGET_MEASUREMENT_TYPE'
645: ,p_budget_measurement_type);
646: hr_utility.set_location(l_proc,30);
647: if (l_api_updating = true)

Line 712: nvl(per_vac_shd.g_old_rec.security_method,hr_api.g_varchar2) <>

708: --
709: hr_utility.set_location(l_proc,20);
710: if ((l_api_updating
711: and
712: nvl(per_vac_shd.g_old_rec.security_method,hr_api.g_varchar2) <>
713: nvl(p_security_method, hr_api.g_varchar2))
714: or
715: (NOT l_api_updating)) then
716: --

Line 713: nvl(p_security_method, hr_api.g_varchar2))

709: hr_utility.set_location(l_proc,20);
710: if ((l_api_updating
711: and
712: nvl(per_vac_shd.g_old_rec.security_method,hr_api.g_varchar2) <>
713: nvl(p_security_method, hr_api.g_varchar2))
714: or
715: (NOT l_api_updating)) then
716: --
717: hr_utility.set_location(l_proc,30);

Line 720: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date

716: --
717: hr_utility.set_location(l_proc,30);
718: if(p_security_method is not null)
719: then
720: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date
721: ,'IRC_SECURITY_METHOD'
722: ,p_security_method);
723: hr_utility.set_location(l_proc,40);
724: if (l_api_updating = true)

Line 796: if(p_date_from not between l_date_from and nvl(l_date_to,hr_api.g_eot)) then

792: );
793: else
794: close csr_requisition;
795: hr_utility.set_location(l_proc,20);
796: if(p_date_from not between l_date_from and nvl(l_date_to,hr_api.g_eot)) then
797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');
798: hr_multi_message.add
799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
800: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'

Line 838: and nvl(hp.date_end, hr_api.g_eot)

834: between hp.effective_start_date
835: and hp.effective_end_date
836: and p_effective_date
837: between hp.date_effective
838: and nvl(hp.date_end, hr_api.g_eot)
839: and ps.shared_type_id = hp.availability_status_id
840: and ps.system_type_cd = 'ACTIVE' ;
841: --
842: begin

Line 856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

852: --
853: hr_utility.set_location(l_proc,20);
854: if ((l_api_updating
855: and
856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
857: nvl(p_position_id, hr_api.g_number))
858: or
859: (NOT l_api_updating)) then
860: hr_utility.set_location(l_proc, 30);

Line 857: nvl(p_position_id, hr_api.g_number))

853: hr_utility.set_location(l_proc,20);
854: if ((l_api_updating
855: and
856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
857: nvl(p_position_id, hr_api.g_number))
858: or
859: (NOT l_api_updating)) then
860: hr_utility.set_location(l_proc, 30);
861: --

Line 930: and nvl(date_to, hr_api.g_eot);

926: where position_id = p_position_id
927: and grade_id = p_grade_id
928: and p_effective_date
929: between date_from
930: and nvl(date_to, hr_api.g_eot);
931: --
932: begin
933: --
934: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

946: (p_vacancy_id => p_vacancy_id
947: ,p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating and
950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
951: nvl(p_position_id, hr_api.g_number))
952: or
953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>
954: nvl(p_grade_id, hr_api.g_number))

Line 951: nvl(p_position_id, hr_api.g_number))

947: ,p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating and
950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
951: nvl(p_position_id, hr_api.g_number))
952: or
953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>
954: nvl(p_grade_id, hr_api.g_number))
955: ))

Line 953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>

949: if (l_api_updating and
950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
951: nvl(p_position_id, hr_api.g_number))
952: or
953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>
954: nvl(p_grade_id, hr_api.g_number))
955: ))
956: or
957: (NOT l_api_updating) then

Line 954: nvl(p_grade_id, hr_api.g_number))

950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
951: nvl(p_position_id, hr_api.g_number))
952: or
953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>
954: nvl(p_grade_id, hr_api.g_number))
955: ))
956: or
957: (NOT l_api_updating) then
958: --

Line 1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

1026: (p_vacancy_id => p_vacancy_id
1027: ,p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating and
1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1031: nvl(p_position_id, hr_api.g_number))
1032: or
1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>
1034: nvl(p_organization_id, hr_api.g_number))

Line 1031: nvl(p_position_id, hr_api.g_number))

1027: ,p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating and
1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1031: nvl(p_position_id, hr_api.g_number))
1032: or
1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>
1034: nvl(p_organization_id, hr_api.g_number))
1035: ))

Line 1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>

1029: if (l_api_updating and
1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1031: nvl(p_position_id, hr_api.g_number))
1032: or
1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>
1034: nvl(p_organization_id, hr_api.g_number))
1035: ))
1036: or
1037: (NOT l_api_updating) then

Line 1034: nvl(p_organization_id, hr_api.g_number))

1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1031: nvl(p_position_id, hr_api.g_number))
1032: or
1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>
1034: nvl(p_organization_id, hr_api.g_number))
1035: ))
1036: or
1037: (NOT l_api_updating) then
1038: --

Line 1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

1115: ,p_object_version_number => p_object_version_number);
1116: hr_utility.set_location(l_proc, 30);
1117: --
1118: if (l_api_updating and
1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))
1121: or
1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>
1123: nvl(p_job_id, hr_api.g_number))

Line 1120: nvl(p_position_id, hr_api.g_number))

1116: hr_utility.set_location(l_proc, 30);
1117: --
1118: if (l_api_updating and
1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))
1121: or
1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>
1123: nvl(p_job_id, hr_api.g_number))
1124: ))

Line 1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>

1118: if (l_api_updating and
1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))
1121: or
1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>
1123: nvl(p_job_id, hr_api.g_number))
1124: ))
1125: or
1126: (NOT l_api_updating)

Line 1123: nvl(p_job_id, hr_api.g_number))

1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))
1121: or
1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>
1123: nvl(p_job_id, hr_api.g_number))
1124: ))
1125: or
1126: (NOT l_api_updating)
1127: then

Line 1227: nvl(per_vac_shd.g_old_rec.job_id,hr_api.g_number) <>

1223: --
1224: hr_utility.set_location(l_proc,20);
1225: if ((l_api_updating
1226: and
1227: nvl(per_vac_shd.g_old_rec.job_id,hr_api.g_number) <>
1228: nvl(p_job_id, hr_api.g_number))
1229: or
1230: (NOT l_api_updating)) then
1231: --

Line 1228: nvl(p_job_id, hr_api.g_number))

1224: hr_utility.set_location(l_proc,20);
1225: if ((l_api_updating
1226: and
1227: nvl(per_vac_shd.g_old_rec.job_id,hr_api.g_number) <>
1228: nvl(p_job_id, hr_api.g_number))
1229: or
1230: (NOT l_api_updating)) then
1231: --
1232: if (p_job_id is not null) then

Line 1245: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))

1241: );
1242: else
1243: close csr_job;
1244: hr_utility.set_location(l_proc,40);
1245: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1246: then
1247: fnd_message.set_name('PER','PER_289452_VAC_JOB_ID_INV_DATE');
1248: hr_multi_message.add
1249: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'

Line 1286: and nvl(date_to, hr_api.g_eot);

1282: where job_id = p_job_id
1283: and grade_id = p_grade_id
1284: and p_effective_date
1285: between date_from
1286: and nvl(date_to, hr_api.g_eot);
1287: --
1288: begin
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: if hr_multi_message.no_exclusive_error

Line 1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)

1305: -- b) The value for job or grade has changed.
1306: --
1307: if (l_api_updating
1308: and
1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)
1310: <> nvl(p_job_id, hr_api.g_number))
1311: or
1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))

Line 1310: <> nvl(p_job_id, hr_api.g_number))

1306: --
1307: if (l_api_updating
1308: and
1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)
1310: <> nvl(p_job_id, hr_api.g_number))
1311: or
1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))
1314: or

Line 1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)

1308: and
1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)
1310: <> nvl(p_job_id, hr_api.g_number))
1311: or
1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))
1314: or
1315: NOT l_api_updating then
1316: hr_utility.set_location(l_proc, 40);

Line 1313: <> nvl(p_grade_id, hr_api.g_number))))

1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)
1310: <> nvl(p_job_id, hr_api.g_number))
1311: or
1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))
1314: or
1315: NOT l_api_updating then
1316: hr_utility.set_location(l_proc, 40);
1317: --

Line 1406: nvl(per_vac_shd.g_old_rec.grade_id,hr_api.g_number) <>

1402: --
1403: hr_utility.set_location(l_proc,20);
1404: if ((l_api_updating
1405: and
1406: nvl(per_vac_shd.g_old_rec.grade_id,hr_api.g_number) <>
1407: nvl(p_grade_id, hr_api.g_number))
1408: or
1409: (NOT l_api_updating)) then
1410: -- --

Line 1407: nvl(p_grade_id, hr_api.g_number))

1403: hr_utility.set_location(l_proc,20);
1404: if ((l_api_updating
1405: and
1406: nvl(per_vac_shd.g_old_rec.grade_id,hr_api.g_number) <>
1407: nvl(p_grade_id, hr_api.g_number))
1408: or
1409: (NOT l_api_updating)) then
1410: -- --
1411: hr_utility.set_location(l_proc,30);

Line 1427: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))

1423: );
1424: else
1425: close csr_grade;
1426: hr_utility.set_location(l_proc,50);
1427: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1428: then
1429: fnd_message.set_name('PER','PER_289454_VAC_GRD_ID_INV_DATE');
1430: hr_multi_message.add
1431: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'

Line 1496: nvl(per_vac_shd.g_old_rec.organization_id,hr_api.g_number) <>

1492: --
1493: hr_utility.set_location(l_proc,20);
1494: if ((l_api_updating
1495: and
1496: nvl(per_vac_shd.g_old_rec.organization_id,hr_api.g_number) <>
1497: nvl(p_organization_id, hr_api.g_number))
1498: or
1499: (NOT l_api_updating)) then
1500: --

Line 1497: nvl(p_organization_id, hr_api.g_number))

1493: hr_utility.set_location(l_proc,20);
1494: if ((l_api_updating
1495: and
1496: nvl(per_vac_shd.g_old_rec.organization_id,hr_api.g_number) <>
1497: nvl(p_organization_id, hr_api.g_number))
1498: or
1499: (NOT l_api_updating)) then
1500: --
1501: if (p_organization_id is not null)

Line 1516: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))

1512: );
1513: else
1514: close csr_organization;
1515: hr_utility.set_location(l_proc,40);
1516: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1517: then
1518: fnd_message.set_name('PER','PER_289456_VAC_ORG_ID_INV_DATE');
1519: hr_multi_message.add
1520: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'

Line 1581: nvl(per_vac_shd.g_old_rec.people_group_id,hr_api.g_number) <>

1577: --
1578: hr_utility.set_location(l_proc,20);
1579: if ((l_api_updating
1580: and
1581: nvl(per_vac_shd.g_old_rec.people_group_id,hr_api.g_number) <>
1582: nvl(p_people_group_id, hr_api.g_number))
1583: or
1584: (NOT l_api_updating)) then
1585: --

Line 1582: nvl(p_people_group_id, hr_api.g_number))

1578: hr_utility.set_location(l_proc,20);
1579: if ((l_api_updating
1580: and
1581: nvl(per_vac_shd.g_old_rec.people_group_id,hr_api.g_number) <>
1582: nvl(p_people_group_id, hr_api.g_number))
1583: or
1584: (NOT l_api_updating)) then
1585: --
1586: if(p_people_group_id is not null)

Line 1602: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))

1598: );
1599: else
1600: close csr_peoplegrp;
1601: hr_utility.set_location(l_proc,30);
1602: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1603: then
1604: fnd_message.set_name('PER','PER_289458_VAC_GRP_ID_INV_DATE');
1605: hr_multi_message.add
1606: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'

Line 1664: nvl(per_vac_shd.g_old_rec.location_id,hr_api.g_number) <>

1660: --
1661: hr_utility.set_location(l_proc,20);
1662: if ((l_api_updating
1663: and
1664: nvl(per_vac_shd.g_old_rec.location_id,hr_api.g_number) <>
1665: nvl(p_location_id, hr_api.g_number))
1666: or
1667: (NOT l_api_updating)) then
1668: --

Line 1665: nvl(p_location_id, hr_api.g_number))

1661: hr_utility.set_location(l_proc,20);
1662: if ((l_api_updating
1663: and
1664: nvl(per_vac_shd.g_old_rec.location_id,hr_api.g_number) <>
1665: nvl(p_location_id, hr_api.g_number))
1666: or
1667: (NOT l_api_updating)) then
1668: --
1669: if (p_location_id is not null)

Line 1758: nvl(per_vac_shd.g_old_rec.recruiter_id,hr_api.g_number) <>

1754: --
1755: hr_utility.set_location(l_proc,20);
1756: if ((l_api_updating
1757: and
1758: nvl(per_vac_shd.g_old_rec.recruiter_id,hr_api.g_number) <>
1759: nvl(p_recruiter_id, hr_api.g_number))
1760: or
1761: (NOT l_api_updating)) then
1762: --

Line 1759: nvl(p_recruiter_id, hr_api.g_number))

1755: hr_utility.set_location(l_proc,20);
1756: if ((l_api_updating
1757: and
1758: nvl(per_vac_shd.g_old_rec.recruiter_id,hr_api.g_number) <>
1759: nvl(p_recruiter_id, hr_api.g_number))
1760: or
1761: (NOT l_api_updating)) then
1762: --
1763: if (p_recruiter_id is not null)

Line 1973: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>

1969: --
1970: hr_utility.set_location(l_proc,20);
1971: if ((l_api_updating
1972: and
1973: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
1974: nvl(p_manager_id, hr_api.g_number))
1975: or
1976: (NOT l_api_updating)) then
1977: --

Line 1974: nvl(p_manager_id, hr_api.g_number))

1970: hr_utility.set_location(l_proc,20);
1971: if ((l_api_updating
1972: and
1973: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
1974: nvl(p_manager_id, hr_api.g_number))
1975: or
1976: (NOT l_api_updating)) then
1977: --
1978: if (p_manager_id is not null)

Line 2070: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>

2066: --
2067: hr_utility.set_location(l_proc,20);
2068: if ((l_api_updating
2069: and
2070: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
2071: nvl(p_manager_id, hr_api.g_number))
2072: or
2073: (NOT l_api_updating)) then
2074: --

Line 2071: nvl(p_manager_id, hr_api.g_number))

2067: hr_utility.set_location(l_proc,20);
2068: if ((l_api_updating
2069: and
2070: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
2071: nvl(p_manager_id, hr_api.g_number))
2072: or
2073: (NOT l_api_updating)) then
2074: --
2075: if (p_manager_id is not null)

Line 2150: nvl(per_vac_shd.g_old_rec.primary_posting_id,hr_api.g_number) <>

2146: --
2147: hr_utility.set_location(l_proc,20);
2148: if ((l_api_updating
2149: and
2150: nvl(per_vac_shd.g_old_rec.primary_posting_id,hr_api.g_number) <>
2151: nvl(p_primary_posting_id, hr_api.g_number))
2152: or
2153: (NOT l_api_updating)) then
2154: --

Line 2151: nvl(p_primary_posting_id, hr_api.g_number))

2147: hr_utility.set_location(l_proc,20);
2148: if ((l_api_updating
2149: and
2150: nvl(per_vac_shd.g_old_rec.primary_posting_id,hr_api.g_number) <>
2151: nvl(p_primary_posting_id, hr_api.g_number))
2152: or
2153: (NOT l_api_updating)) then
2154: --
2155: if (p_primary_posting_id is not null)

Line 2227: nvl(per_vac_shd.g_old_rec.assessment_id,hr_api.g_number) <>

2223: --
2224: hr_utility.set_location(l_proc,20);
2225: if ((l_api_updating
2226: and
2227: nvl(per_vac_shd.g_old_rec.assessment_id,hr_api.g_number) <>
2228: nvl(p_assessment_id, hr_api.g_number))
2229: or
2230: (NOT l_api_updating)) then
2231: --

Line 2228: nvl(p_assessment_id, hr_api.g_number))

2224: hr_utility.set_location(l_proc,20);
2225: if ((l_api_updating
2226: and
2227: nvl(per_vac_shd.g_old_rec.assessment_id,hr_api.g_number) <>
2228: nvl(p_assessment_id, hr_api.g_number))
2229: or
2230: (NOT l_api_updating)) then
2231: --
2232: if (p_assessment_id is not null)

Line 2272: hr_api.validate_bus_grp_id(p_rec.business_group_id

2268: hr_utility.set_location('Entering:'||l_proc, 5);
2269: --
2270: -- Call all supporting business operations
2271: --
2272: hr_api.validate_bus_grp_id(p_rec.business_group_id
2273: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');
2274: --
2275: hr_utility.set_location(l_proc, 10);
2276: --

Line 2523: hr_api.validate_bus_grp_id(p_rec.business_group_id

2519: (p_rec => p_rec
2520: );
2521: --
2522: --
2523: hr_api.validate_bus_grp_id(p_rec.business_group_id
2524: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');
2525: --
2526: hr_utility.set_location(l_proc, 20);
2527: --