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_member_id'
51: ,p_argument_value => p_learning_path_member_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_member_id'
120: ,p_argument_value => p_learning_path_member_id
121: );
119: ,p_argument => 'learning_path_member_id'
120: ,p_argument_value => p_learning_path_member_id
121: );
122: --
123: if ( nvl(ota_lpm_bus.g_learning_path_member_id, hr_api.g_number)
124: = p_learning_path_member_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_member_id is not null) and (
199: nvl(ota_lpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_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_member_id is not null) and (
199: nvl(ota_lpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_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_member_id is not null) and (
199: nvl(ota_lpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: if ((p_rec.learning_path_member_id is not null) and (
199: nvl(ota_lpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(ota_lpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(ota_lpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(ota_lpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(ota_lpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(ota_lpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(ota_lpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(ota_lpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(ota_lpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(ota_lpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(ota_lpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(ota_lpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(ota_lpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(ota_lpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(ota_lpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(ota_lpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: nvl(ota_lpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_member_id is null) then
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_member_id is null) then
242: --
235: nvl(ota_lpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_member_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_lpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_member_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
475: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN
476:
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc
479: ,p_argument => 'p_business_group_id'
480: ,p_argument_value => p_business_group_id
481: );
488: -- If this is a changing update, or a new insert, test
489: --
490: IF p_activity_version_id IS NOT NULL THEN
491: IF (l_api_updating AND
492: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
493: NVL(p_activity_version_id, hr_api.g_number) )
494: OR (NOT l_api_updating)
495: THEN
496: -- Check that the definition exists
489: --
490: IF p_activity_version_id IS NOT NULL THEN
491: IF (l_api_updating AND
492: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
493: NVL(p_activity_version_id, hr_api.g_number) )
494: OR (NOT l_api_updating)
495: THEN
496: -- Check that the definition exists
497: --
558: --
559: -- check mandatory parameters have been set
560: --
561: hr_utility.set_location(' Step:'|| l_proc, 20);
562: hr_api.mandatory_arg_error
563: (p_api_name => l_proc
564: ,p_argument => 'p_learning_path_id'
565: ,p_argument_value => p_learning_path_id
566: );
565: ,p_argument_value => p_learning_path_id
566: );
567: --
568: hr_utility.set_location(' Step:'|| l_proc, 30);
569: hr_api.mandatory_arg_error
570: (p_api_name => l_proc
571: ,p_argument => 'p_business_group_id'
572: ,p_argument_value => p_business_group_id
573: );
639: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
640: ,p_associated_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
641:
642:
643: hr_api.mandatory_arg_error
644: (p_api_name => l_proc
645: ,p_argument => 'p_learning_path_id'
646: ,p_argument_value => p_learning_path_id
647: );
652: --
653: -- Check if anything is changing, or this is an insert
654: --
655: IF (l_api_updating AND
656: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
657: NVL(p_activity_version_id, hr_api.g_number))
658: OR (NOT l_api_updating) THEN
659: --
660: -- check the combination is unique
653: -- Check if anything is changing, or this is an insert
654: --
655: IF (l_api_updating AND
656: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
657: NVL(p_activity_version_id, hr_api.g_number))
658: OR (NOT l_api_updating) THEN
659: --
660: -- check the combination is unique
661: --
728: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
729: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
730:
731:
732: hr_api.mandatory_arg_error
733: (p_api_name => l_proc
734: ,p_argument => 'p_learning_path_id'
735: ,p_argument_value => p_learning_path_id
736: );
741: --
742: -- Check if anything is changing, or this is an insert
743: --
744: IF (l_api_updating AND
745: NVL(ota_lpm_shd.g_old_rec.course_sequence, hr_api.g_number) <>
746: NVL(p_course_sequence, hr_api.g_number))
747: OR (NOT l_api_updating) THEN
748: --
749: -- check the sequence is unique
742: -- Check if anything is changing, or this is an insert
743: --
744: IF (l_api_updating AND
745: NVL(ota_lpm_shd.g_old_rec.course_sequence, hr_api.g_number) <>
746: NVL(p_course_sequence, hr_api.g_number))
747: OR (NOT l_api_updating) THEN
748: --
749: -- check the sequence is unique
750: --
821: --
822: -- Check if anything is changing, or this is an insert
823: --
824: IF (l_api_updating AND
825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>
826: NVL(p_duration, hr_api.g_number)
827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
828: NVL(p_duration_units, hr_api.g_varchar2))
829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
822: -- Check if anything is changing, or this is an insert
823: --
824: IF (l_api_updating AND
825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>
826: NVL(p_duration, hr_api.g_number)
827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
828: NVL(p_duration_units, hr_api.g_varchar2))
829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
830: --
823: --
824: IF (l_api_updating AND
825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>
826: NVL(p_duration, hr_api.g_number)
827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
828: NVL(p_duration_units, hr_api.g_varchar2))
829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
830: --
831: -- check the duration is positive
824: IF (l_api_updating AND
825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>
826: NVL(p_duration, hr_api.g_number)
827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
828: NVL(p_duration_units, hr_api.g_varchar2))
829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
830: --
831: -- check the duration is positive
832: --
879: hr_utility.set_location(' Leaving:'||l_proc, 10);
880: --
881: -- check mandatory parameters has been set
882: --
883: hr_api.mandatory_arg_error
884: (p_api_name => l_proc
885: ,p_argument => 'effective_date'
886: ,p_argument_value => p_effective_date);
887:
890: ,p_object_version_number => p_object_version_number);
891:
892:
893: IF ((l_api_updating AND
894: NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
895: NVL(p_duration_units, hr_api.g_varchar2))
896: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
897:
898: hr_utility.set_location(' Leaving:'||l_proc, 20);
891:
892:
893: IF ((l_api_updating AND
894: NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
895: NVL(p_duration_units, hr_api.g_varchar2))
896: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
897:
898: hr_utility.set_location(' Leaving:'||l_proc, 20);
899: --
898: hr_utility.set_location(' Leaving:'||l_proc, 20);
899: --
900:
901: IF p_duration_units IS NOT NULL THEN
902: IF hr_api.not_exists_in_hr_lookups
903: (p_effective_date => p_effective_date
904: ,p_lookup_type => 'OTA_DURATION_UNITS'
905: ,p_lookup_code => p_duration_units) THEN
906: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
944: hr_utility.set_location('Entering:'||l_proc, 5);
945: --
946: -- Call all supporting business operations
947: --
948: hr_api.validate_bus_grp_id
949: (p_business_group_id => p_rec.business_group_id
950: ,p_associated_column1 => ota_lpm_shd.g_tab_nam
951: || '.BUSINESS_GROUP_ID');
952: --
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: -- Call all supporting business operations
1025: --
1026: hr_api.validate_bus_grp_id
1027: (p_business_group_id => p_rec.business_group_id
1028: ,p_associated_column1 => ota_lpm_shd.g_tab_nam
1029: || '.BUSINESS_GROUP_ID');
1030: --