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_id'
51: ,p_argument_value => p_learning_path_id
52: );
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
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: --
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_id'
120: ,p_argument_value => p_learning_path_id
121: );
119: ,p_argument => 'learning_path_id'
120: ,p_argument_value => p_learning_path_id
121: );
122: --
123: if ( nvl(ota_lps_bus.g_learning_path_id, hr_api.g_number)
124: = p_learning_path_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
195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any
344: fnd_message.raise_error;
345: END IF;
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
345: END IF;
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);
354: END IF;
353: ,p_base_table => ota_lps_shd.g_tab_nam);
354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
362: ,p_base_table => ota_lps_shd.g_tab_nam);
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
362: ,p_base_table => ota_lps_shd.g_tab_nam);
363: END IF;
404: --
405: -- Check if anything is changing, or this is an insert
406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
405: -- Check if anything is changing, or this is an insert
406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
414: -- check the duration is positive
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
414: -- check the duration is positive
415: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: --
464: -- check mandatory parameters has been set
465: --
466: hr_api.mandatory_arg_error
467: (p_api_name => l_proc
468: ,p_argument => 'effective_date'
469: ,p_argument_value => p_effective_date);
470:
473: ,p_object_version_number => p_object_version_number);
474:
475:
476: IF ((l_api_updating AND
477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
478: NVL(p_duration_units, hr_api.g_varchar2))
479: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
480:
481: hr_utility.set_location(' Leaving:'||l_proc, 20);
474:
475:
476: IF ((l_api_updating AND
477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
478: NVL(p_duration_units, hr_api.g_varchar2))
479: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
480:
481: hr_utility.set_location(' Leaving:'||l_proc, 20);
482: --
481: hr_utility.set_location(' Leaving:'||l_proc, 20);
482: --
483:
484: IF p_duration_units IS NOT NULL THEN
485: IF hr_api.not_exists_in_hr_lookups
486: (p_effective_date => p_effective_date
487: ,p_lookup_type => 'OTA_DURATION_UNITS'
488: ,p_lookup_code => p_duration_units) THEN
489: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
576: hr_utility.set_location(' Leaving:'||l_proc, 10);
577: --
578: -- check mandatory parameters has been set
579: --
580: hr_api.mandatory_arg_error
581: (p_api_name => l_proc
582: ,p_argument => 'effective_date'
583: ,p_argument_value => p_effective_date);
584:
586: (p_learning_path_id => p_learning_path_id
587: ,p_object_version_number => p_object_version_number);
588:
589: IF ((l_api_updating AND
590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>
591: NVL(p_path_source_code, hr_api.g_varchar2))
592: OR NOT l_api_updating AND p_path_source_code IS NOT NULL) THEN
593:
594: hr_utility.set_location(' Leaving:'||l_proc, 20);
587: ,p_object_version_number => p_object_version_number);
588:
589: IF ((l_api_updating AND
590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>
591: NVL(p_path_source_code, hr_api.g_varchar2))
592: OR NOT l_api_updating AND p_path_source_code IS NOT NULL) THEN
593:
594: hr_utility.set_location(' Leaving:'||l_proc, 20);
595: --
594: hr_utility.set_location(' Leaving:'||l_proc, 20);
595: --
596:
597: IF p_path_source_code IS NOT NULL THEN
598: IF hr_api.not_exists_in_hr_lookups
599: (p_effective_date => p_effective_date
600: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
601: ,p_lookup_code => p_path_source_code) THEN
602: fnd_message.set_name('OTA','OTA_13176_TPS_PLN_SRC_INVLD');
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: --
643: -- check mandatory parameters has been set
644: --
645: hr_api.mandatory_arg_error
646: (p_api_name => l_proc
647: ,p_argument => 'effective_date'
648: ,p_argument_value => p_effective_date);
649:
652: ,p_object_version_number => p_object_version_number);
653:
654:
655: IF ((l_api_updating AND
656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>
657: NVL(p_source_function_code, hr_api.g_varchar2))
658: OR NOT l_api_updating AND p_source_function_code IS NOT NULL) THEN
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
653:
654:
655: IF ((l_api_updating AND
656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>
657: NVL(p_source_function_code, hr_api.g_varchar2))
658: OR NOT l_api_updating AND p_source_function_code IS NOT NULL) THEN
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661: --
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661: --
662:
663: IF p_source_function_code IS NOT NULL THEN
664: IF hr_api.not_exists_in_hr_lookups
665: (p_effective_date => p_effective_date
666: ,p_lookup_type => 'OTA_PLAN_COMPONENT_SOURCE'
667: ,p_lookup_code => p_source_function_code) THEN
668: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: --
708: -- check mandatory parameters has been set
709: --
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc
712: ,p_argument => 'effective_date'
713: ,p_argument_value => p_effective_date);
714:
717: ,p_object_version_number => p_object_version_number);
718:
719:
720: IF ((l_api_updating AND
721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
722: NVL(p_competency_update_level, hr_api.g_varchar2))
723: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 20);
718:
719:
720: IF ((l_api_updating AND
721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
722: NVL(p_competency_update_level, hr_api.g_varchar2))
723: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 20);
726: --
725: hr_utility.set_location(' Leaving:'||l_proc, 20);
726: --
727:
728: IF p_competency_update_level IS NOT NULL THEN
729: IF hr_api.not_exists_in_hr_lookups
730: (p_effective_date => p_effective_date
731: ,p_lookup_type => 'OTA_COMPETENCY_UPDATE_LEVEL'
732: ,p_lookup_code => p_competency_update_level) THEN
733: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');
838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN
844: l_upd_start_date := TRUE;
845: l_start_date_active := p_start_date;
846: ELSE
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN
844: l_upd_start_date := TRUE;
845: l_start_date_active := p_start_date;
846: ELSE
847: l_upd_start_date := FALSE;
847: l_upd_start_date := FALSE;
848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
849: END IF;
850:
851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
852: NVL( p_end_date, hr_api.g_date )) THEN
853: l_upd_end_date := TRUE;
854: l_end_date_active := p_end_date;
855: ELSE
848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
849: END IF;
850:
851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
852: NVL( p_end_date, hr_api.g_date )) THEN
853: l_upd_end_date := TRUE;
854: l_end_date_active := p_end_date;
855: ELSE
856: l_upd_end_date := FALSE;
950: --
951: OPEN cur_cat_start_end_date;
952: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;
953:
954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
955: NVL( p_start_date, hr_api.g_date )) THEN
956: l_start_date_active := p_start_date;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
951: OPEN cur_cat_start_end_date;
952: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;
953:
954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
955: NVL( p_start_date, hr_api.g_date )) THEN
956: l_start_date_active := p_start_date;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
960:
961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN
963: l_end_date_active := p_end_date;
964: ELSE
965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
960:
961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN
963: l_end_date_active := p_end_date;
964: ELSE
965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;
966: END IF;
1017: --
1018: -- check mandatory parameters have been set
1019: --
1020: hr_utility.set_location('Entering:'||l_proc, 5);
1021: hr_api.mandatory_arg_error
1022: (p_api_name => l_proc
1023: ,p_argument => 'p_learning_path_id'
1024: ,p_argument_value => p_learning_path_id
1025: );
1052: --
1053: -- check mandatory parameters have been set
1054: --
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: hr_api.mandatory_arg_error
1057: (p_api_name => l_proc
1058: ,p_argument => 'p_learning_path_id'
1059: ,p_argument_value => p_learning_path_id
1060: );
1088: hr_utility.set_location('Entering:'||l_proc, 5);
1089: --
1090: -- Call all supporting business operations
1091: --
1092: hr_api.validate_bus_grp_id
1093: (p_business_group_id => p_rec.business_group_id
1094: ,p_associated_column1 => ota_lps_shd.g_tab_nam
1095: || '.BUSINESS_GROUP_ID');
1096: --
1184: hr_utility.set_location('Entering:'||l_proc, 5);
1185: --
1186: -- Call all supporting business operations
1187: --
1188: hr_api.validate_bus_grp_id
1189: (p_business_group_id => p_rec.business_group_id
1190: ,p_associated_column1 => ota_lps_shd.g_tab_nam
1191: || '.BUSINESS_GROUP_ID');
1192: --