APPS.PER_RAA_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 => 'recruitment_activity_id'
48: ,p_argument_value => p_recruitment_activity_id
49: );

Line 71: hr_api.set_security_group_id

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

Line 109: hr_api.mandatory_arg_error

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

Line 115: if ( nvl(per_raa_bus.g_recruitment_activity_id, hr_api.g_number)

111: ,p_argument => 'recruitment_activity_id'
112: ,p_argument_value => p_recruitment_activity_id
113: );
114: --
115: if ( nvl(per_raa_bus.g_recruitment_activity_id, hr_api.g_number)
116: = p_recruitment_activity_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

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

Line 193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

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

190: if ((p_rec.recruitment_activity_id is not null) and (
191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

Line 197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

Line 199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

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

Line 201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

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

Line 203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

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

Line 205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

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

Line 207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

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

Line 209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

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

Line 211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

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

Line 213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

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

Line 215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

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

Line 217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

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

Line 219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

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

Line 221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

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

Line 223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

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

Line 225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

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

Line 227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

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

Line 229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

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

226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(per_raa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.recruitment_activity_id is null) then
234: --

Line 231: nvl(per_raa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

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

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

Line 341: hr_api.argument_changed_error

337: --
338: -- Add checks to ensure non-updateable args have
339: -- not been updated.
340: if p_rec.business_group_id <> per_raa_shd.g_old_rec.business_group_id then
341: hr_api.argument_changed_error
342: (p_api_name => l_proc
343: ,p_argument => 'BUSINESS_GROUP_ID'
344: ,p_base_table => per_raa_shd.g_tab_nam
345: );

Line 349: hr_api.argument_changed_error

345: );
346: end if;
347:
348: if p_rec.recruitment_activity_id <> per_raa_shd.g_old_rec.recruitment_activity_id then
349: hr_api.argument_changed_error
350: (p_api_name => l_proc
351: ,p_argument => 'RECRUITMENT_ACTIVITY_ID'
352: ,p_base_table => per_raa_shd.g_tab_nam
353: );

Line 402: hr_api.mandatory_arg_error

398: --
399: begin
400: hr_utility.set_location('Entering:'||l_proc,10);
401: --
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc
404: ,p_argument => 'NAME'
405: ,p_argument_value => p_name
406: );

Line 414: NVL(per_raa_shd.g_old_rec.name,hr_api.g_varchar2)

410: ,p_object_version_number => p_object_version_number);
411: hr_utility.set_location(l_proc,20);
412: if(l_api_updating and
413: p_name <>
414: NVL(per_raa_shd.g_old_rec.name,hr_api.g_varchar2)
415: ) or (NOT l_api_updating) then
416: hr_utility.set_location(l_proc,30);
417: open csr_name;
418: fetch csr_name into l_name;

Line 511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)

507: hr_utility.set_location(l_proc,20);
508: if p_authorising_person_id is not null then
509: if (l_api_updating and
510: p_authorising_person_id <>
511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)
512: ) or (NOT l_api_updating) then
513:
514: -- check that authorising_person_id exists in per_all_people_f.
515: hr_utility.set_location(l_proc,30);

Line 605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))

601: hr_utility.set_location(l_proc,20);
602: if p_run_by_organization_id is not null then
603: if (l_api_updating and
604: p_run_by_organization_id <>
605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))
606: or (NOT l_api_updating) then
607:
608: -- check that run_by_organization_id exists in per_all_people_f.
609: hr_utility.set_location(l_proc,30);

Line 706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))

702: hr_utility.set_location(l_proc,20);
703: if p_internal_contact_person_id is not null then
704: if (l_api_updating and
705: p_internal_contact_person_id <>
706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))
707: or (NOT l_api_updating) then
708:
709: -- check that internal_contact_person_id exists in per_all_people_f.
710: hr_utility.set_location(l_proc,30);

Line 810: and p_date_start between r1.date_start and nvl(r1.date_end, hr_api.g_eot)

806: select null from PER_RECRUITMENT_ACTIVITIES r1
807: where r1.business_group_id = p_business_group_id and
808: p_recruitment_activity_id <> r1.recruitment_activity_id
809: and r1.recruitment_activity_id=p_parent_recruitment_activity
810: and p_date_start between r1.date_start and nvl(r1.date_end, hr_api.g_eot)
811: and r1.recruitment_activity_id not in (select r2.recruitment_activity_id
812: from per_recruitment_activities r2 connect by
813: r2.parent_recruitment_activity_id = prior r2.recruitment_activity_id
814: start with r2.parent_recruitment_activity_id = p_recruitment_activity_id);

Line 826: NVL(per_raa_shd.g_old_rec.parent_recruitment_activity_id,hr_api.g_number)

822:
823: if p_parent_recruitment_activity is not null then
824: if (l_api_updating and
825: (p_parent_recruitment_activity <>
826: NVL(per_raa_shd.g_old_rec.parent_recruitment_activity_id,hr_api.g_number)
827: or
828: p_recruitment_activity_id <>
829: per_raa_shd.g_old_rec.recruitment_activity_id))
830: or (NOT l_api_updating) then

Line 944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))

940: hr_utility.set_location(l_proc,20);
941: if p_currency_code is not null then
942: if (l_api_updating and
943: p_currency_code <>
944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))
945: or (NOT l_api_updating) then
946:
947: -- check that currency_code exists in FND_CURRENCIES.
948: hr_utility.set_location(l_proc,30);

Line 1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)

1024: hr_utility.set_location(l_proc,20);
1025: if p_recruiting_site_id is not null then
1026: if (l_api_updating and
1027: p_recruiting_site_id <>
1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)
1029: ) or (NOT l_api_updating) then
1030:
1031: -- check that recruiting_site_id exists in IRC_ALL_RECRUITING_SITES.
1032: hr_utility.set_location(l_proc,30);

Line 1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)

1107: hr_utility.set_location(l_proc,20);
1108: if p_posting_content_id is not null then
1109: if (l_api_updating and
1110: p_posting_content_id <>
1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)
1112: ) or (NOT l_api_updating) then
1113:
1114: -- check that posting_content_id exists in IRC_POSTING_CONTENTS.
1115: hr_utility.set_location(l_proc,30);

Line 1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start

1187: l_api_updating :=
1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))
1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.

Line 1192: or NVL(p_date_end,hr_api.g_eot) <>

1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))
1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.
1196: hr_utility.set_location(l_proc,30);

Line 1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))

1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))
1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.
1196: hr_utility.set_location(l_proc,30);
1197: if p_date_start is null then

Line 1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))

1268: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1269: hr_utility.set_location(l_proc,20);
1270: if p_type is not null then
1271: if (l_api_updating and
1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))
1273: or (NOT l_api_updating) then
1274:
1275: -- Checks that type is validated against hr_lookups.
1276: hr_utility.set_location(l_proc,30);

Line 1277: l_ret := hr_api.not_exists_in_hr_lookups(

1273: or (NOT l_api_updating) then
1274:
1275: -- Checks that type is validated against hr_lookups.
1276: hr_utility.set_location(l_proc,30);
1277: l_ret := hr_api.not_exists_in_hr_lookups(
1278: p_effective_date => p_effective_date
1279: ,p_lookup_type => 'REC_TYPE'
1280: ,p_lookup_code => p_type);
1281: if l_ret = true then

Line 1352: (NVL(p_date_closing,hr_api.g_eot) <>

1348: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1349: hr_utility.set_location(l_proc,20);
1350: if p_date_closing is not null then
1351: if (l_api_updating and
1352: (NVL(p_date_closing,hr_api.g_eot) <>
1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)
1354: or p_date_start <> per_raa_shd.g_old_rec.date_start))
1355: or (NOT l_api_updating) then
1356:

Line 1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)

1349: hr_utility.set_location(l_proc,20);
1350: if p_date_closing is not null then
1351: if (l_api_updating and
1352: (NVL(p_date_closing,hr_api.g_eot) <>
1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)
1354: or p_date_start <> per_raa_shd.g_old_rec.date_start))
1355: or (NOT l_api_updating) then
1356:
1357: -- Checks that date_start is not later then corresponding date_closing

Line 1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))

1428: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1429: hr_utility.set_location(l_proc,20);
1430: if p_status is not null then
1431: if (l_api_updating and
1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))
1433: or (NOT l_api_updating) then
1434:
1435: -- Checks that status is validated against hr_lookups.
1436: hr_utility.set_location(l_proc,30);

Line 1437: l_ret := hr_api.not_exists_in_hr_lookups(

1433: or (NOT l_api_updating) then
1434:
1435: -- Checks that status is validated against hr_lookups.
1436: hr_utility.set_location(l_proc,30);
1437: l_ret := hr_api.not_exists_in_hr_lookups(
1438: p_effective_date => p_effective_date
1439: ,p_lookup_type => 'REC_STATUS'
1440: ,p_lookup_code => p_status);
1441: if l_ret = true then

Line 1510: NVL(per_raa_shd.g_old_rec.actual_cost,hr_api.g_number))

1506: hr_utility.set_location(l_proc,20);
1507: if p_actual_cost is not null then
1508: if (l_api_updating and
1509: p_actual_cost <>
1510: NVL(per_raa_shd.g_old_rec.actual_cost,hr_api.g_number))
1511: or (NOT l_api_updating) then
1512:
1513: -- Checks that actual_cost is greater then zero
1514: hr_utility.set_location(l_proc,30);

Line 1585: NVL(per_raa_shd.g_old_rec.planned_cost,hr_api.g_number))

1581: hr_utility.set_location(l_proc,20);
1582: if p_planned_cost is not null then
1583: if (l_api_updating and
1584: p_planned_cost <>
1585: NVL(per_raa_shd.g_old_rec.planned_cost,hr_api.g_number))
1586: or (NOT l_api_updating) then
1587:
1588: -- Checks that planned_cost is greater then zero
1589: hr_utility.set_location(l_proc,30);

Line 1628: hr_api.validate_bus_grp_id

1624: --
1625: -- Call all supporting business operations
1626: --
1627: -- Validate Bus Grp
1628: hr_api.validate_bus_grp_id
1629: (p_business_group_id => p_rec.business_group_id
1630: ,p_associated_column1 => per_raa_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1631: );
1632: --

Line 1760: hr_api.validate_bus_grp_id(

1756: --
1757: -- Call all supporting business operations
1758: --
1759: -- Validate Bus Grp
1760: hr_api.validate_bus_grp_id(
1761: p_business_group_id => p_rec.business_group_id
1762: ,p_associated_column1 => per_raa_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1763: );
1764: --