APPS.OTA_LPC_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error

44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'learning_path_section_id'
51: ,p_argument_value => p_learning_path_section_id
52: );

Line 75: hr_api.set_security_group_id

71: close csr_sec_grp;
72: --
73: -- Set the security_group_id in CLIENT_INFO
74: --
75: hr_api.set_security_group_id
76: (p_security_group_id => l_security_group_id
77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA

Line 81: hr_api.set_legislation_context(l_legislation_code);

77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'learning_path_section_id'
120: ,p_argument_value => p_learning_path_section_id
121: );

Line 123: if ( nvl(ota_lpc_bus.g_learning_path_section_id, hr_api.g_number)

119: ,p_argument => 'learning_path_section_id'
120: ,p_argument_value => p_learning_path_section_id
121: );
122: --
123: if ( nvl(ota_lpc_bus.g_learning_path_section_id, hr_api.g_number)
124: = p_learning_path_section_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

197: --
198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_section_id is null) then

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

234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_section_id is null) then
242: --

Line 239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_section_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:

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

236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_section_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any

Line 726: hr_api.validate_bus_grp_id

722: hr_utility.set_location('Entering:'||l_proc, 5);
723: --
724: -- Call all supporting business operations
725: --
726: hr_api.validate_bus_grp_id
727: (p_business_group_id => p_rec.business_group_id
728: ,p_associated_column1 => ota_lpc_shd.g_tab_nam
729: || '.BUSINESS_GROUP_ID');
730: --

Line 778: hr_api.validate_bus_grp_id

774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: hr_api.validate_bus_grp_id
779: (p_business_group_id => p_rec.business_group_id
780: ,p_associated_column1 => ota_lpc_shd.g_tab_nam
781: || '.BUSINESS_GROUP_ID');
782: --