eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TPS_BUS dependencies on HR_API

Line 46: hr_api.mandatory_arg_error

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

Line 74: hr_api.set_security_group_id

70: CLOSE csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: END IF;

Line 112: hr_api.mandatory_arg_error

108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --
110: -- Ensure that all the mandatory parameter are not null
111: --
112: hr_api.mandatory_arg_error
113: (p_api_name => l_proc
114: ,p_argument => 'training_plan_id'
115: ,p_argument_value => p_training_plan_id
116: );

Line 118: IF ( NVL(ota_tps_bus.g_training_plan_id, hr_api.g_number)

114: ,p_argument => 'training_plan_id'
115: ,p_argument_value => p_training_plan_id
116: );
117: --
118: IF ( NVL(ota_tps_bus.g_training_plan_id, hr_api.g_number)
119: = p_training_plan_id) THEN
120: --
121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global

Line 194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

190: BEGIN
191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: IF ((p_rec.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR

191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: IF ((p_rec.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR

Line 196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

192: --
193: IF ((p_rec.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR

193: IF ((p_rec.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR

Line 198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR

195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR

Line 200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR

197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR

Line 202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR

199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR

Line 204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR

201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR

Line 206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR

203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR

Line 208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR

205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR

Line 210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR

207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR

Line 212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR

209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR

Line 214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR

211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR

Line 216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR

213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR

Line 218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR

215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR

Line 220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR

217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR

Line 222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR

219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR

Line 224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR

221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR

Line 226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR

223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR

Line 228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR

225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR

Line 230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR

227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR

Line 232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR

229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR

Line 234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR

231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR

Line 236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR

233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR

Line 238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR

235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR

Line 240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR

237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR

Line 242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR

239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR

Line 244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR

241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR

Line 246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR

243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR

Line 248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR

245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR

Line 250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR

247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )

Line 252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_id IS NULL) THEN

Line 253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR

249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_id IS NULL) THEN
257: --

Line 254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_id IS NULL) THEN
257: --
258: -- Only execute the validation if absolutely necessary:

Line 255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )

251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_id IS NULL) THEN
257: --
258: -- Only execute the validation if absolutely necessary:
259: -- a) During update, the structure column value or any

Line 386: IF NVL(p_rec.business_group_id, hr_api.g_number) <>

382: END IF;
383: --
384: --
385: hr_utility.set_location(' Step:'|| l_proc, 10);
386: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
388: hr_api.argument_changed_error
389: (p_api_name => l_proc
390: ,p_argument => 'BUSINESS_GROUP_ID'

Line 387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

383: --
384: --
385: hr_utility.set_location(' Step:'|| l_proc, 10);
386: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
388: hr_api.argument_changed_error
389: (p_api_name => l_proc
390: ,p_argument => 'BUSINESS_GROUP_ID'
391: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 388: hr_api.argument_changed_error

384: --
385: hr_utility.set_location(' Step:'|| l_proc, 10);
386: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
388: hr_api.argument_changed_error
389: (p_api_name => l_proc
390: ,p_argument => 'BUSINESS_GROUP_ID'
391: ,p_base_table => ota_tps_shd.g_tab_nam);
392: END IF;

Line 395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>

391: ,p_base_table => ota_tps_shd.g_tab_nam);
392: END IF;
393: --
394: hr_utility.set_location(' Step:'|| l_proc, 20);
395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>
396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN
397: hr_api.argument_changed_error
398: (p_api_name => l_proc
399: ,p_argument => 'TRAINING_PLAN_ID'

Line 396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN

392: END IF;
393: --
394: hr_utility.set_location(' Step:'|| l_proc, 20);
395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>
396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN
397: hr_api.argument_changed_error
398: (p_api_name => l_proc
399: ,p_argument => 'TRAINING_PLAN_ID'
400: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 397: hr_api.argument_changed_error

393: --
394: hr_utility.set_location(' Step:'|| l_proc, 20);
395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>
396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN
397: hr_api.argument_changed_error
398: (p_api_name => l_proc
399: ,p_argument => 'TRAINING_PLAN_ID'
400: ,p_base_table => ota_tps_shd.g_tab_nam);
401: END IF;

Line 404: IF NVL(p_rec.organization_id, hr_api.g_number) <>

400: ,p_base_table => ota_tps_shd.g_tab_nam);
401: END IF;
402: --
403: hr_utility.set_location(' Step:'|| l_proc, 30);
404: IF NVL(p_rec.organization_id, hr_api.g_number) <>
405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN
406: hr_api.argument_changed_error
407: (p_api_name => l_proc
408: ,p_argument => 'ORGANIZATION_ID'

Line 405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN

401: END IF;
402: --
403: hr_utility.set_location(' Step:'|| l_proc, 30);
404: IF NVL(p_rec.organization_id, hr_api.g_number) <>
405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN
406: hr_api.argument_changed_error
407: (p_api_name => l_proc
408: ,p_argument => 'ORGANIZATION_ID'
409: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 406: hr_api.argument_changed_error

402: --
403: hr_utility.set_location(' Step:'|| l_proc, 30);
404: IF NVL(p_rec.organization_id, hr_api.g_number) <>
405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN
406: hr_api.argument_changed_error
407: (p_api_name => l_proc
408: ,p_argument => 'ORGANIZATION_ID'
409: ,p_base_table => ota_tps_shd.g_tab_nam);
410: END IF;

Line 413: IF NVL(p_rec.person_id, hr_api.g_number) <>

409: ,p_base_table => ota_tps_shd.g_tab_nam);
410: END IF;
411: --
412: hr_utility.set_location(' Step:'|| l_proc, 40);
413: IF NVL(p_rec.person_id, hr_api.g_number) <>
414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN
415: hr_api.argument_changed_error
416: (p_api_name => l_proc
417: ,p_argument => 'PERSON_ID'

Line 414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN

410: END IF;
411: --
412: hr_utility.set_location(' Step:'|| l_proc, 40);
413: IF NVL(p_rec.person_id, hr_api.g_number) <>
414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN
415: hr_api.argument_changed_error
416: (p_api_name => l_proc
417: ,p_argument => 'PERSON_ID'
418: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 415: hr_api.argument_changed_error

411: --
412: hr_utility.set_location(' Step:'|| l_proc, 40);
413: IF NVL(p_rec.person_id, hr_api.g_number) <>
414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN
415: hr_api.argument_changed_error
416: (p_api_name => l_proc
417: ,p_argument => 'PERSON_ID'
418: ,p_base_table => ota_tps_shd.g_tab_nam);
419: END IF;

Line 443: hr_api.validate_bus_grp_id(p_rec.business_group_id

439: --
440: -- Call all supporting business operations
441: --Validate Important Attributes
442: --
443: hr_api.validate_bus_grp_id(p_rec.business_group_id
444: ,p_associated_column1 => ota_tps_shd.g_tab_nam || '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
445: --
446: hr_multi_message.end_validation_set;
447:

Line 559: hr_api.validate_bus_grp_id(p_rec.business_group_id

555: --
556: -- Call all supporting business operations
557: --Validate Important attribute
558:
559: hr_api.validate_bus_grp_id(p_rec.business_group_id
560: ,p_associated_column1 => ota_tps_shd.g_tab_nam || '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
561: --
562: hr_multi_message.end_validation_set;
563: