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_TPM_BUS dependencies on HR_API

Line 49: hr_api.mandatory_arg_error

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

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_member_id'
115: ,p_argument_value => p_training_plan_member_id
116: );

Line 118: IF ( NVL(ota_tpm_bus.g_training_plan_member_id, hr_api.g_number)

114: ,p_argument => 'training_plan_member_id'
115: ,p_argument_value => p_training_plan_member_id
116: );
117: --
118: IF ( NVL(ota_tpm_bus.g_training_plan_member_id, hr_api.g_number)
119: = p_training_plan_member_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_tpm_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_member_id IS NOT NULL) AND (
194: NVL(ota_tpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_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_member_id IS NOT NULL) AND (
194: NVL(ota_tpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR

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

192: --
193: IF ((p_rec.training_plan_member_id IS NOT NULL) AND (
194: NVL(ota_tpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_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_member_id IS NOT NULL) AND (
194: NVL(ota_tpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR

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

194: NVL(ota_tpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR

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

196: NVL(ota_tpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR

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

198: NVL(ota_tpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR

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

200: NVL(ota_tpm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: NVL(p_rec.attribute3, hr_api.g_varchar2) OR
202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR

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

202: NVL(ota_tpm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: NVL(p_rec.attribute4, hr_api.g_varchar2) OR
204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR

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

204: NVL(ota_tpm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: NVL(p_rec.attribute5, hr_api.g_varchar2) OR
206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR

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

206: NVL(ota_tpm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: NVL(p_rec.attribute6, hr_api.g_varchar2) OR
208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR

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

208: NVL(ota_tpm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: NVL(p_rec.attribute7, hr_api.g_varchar2) OR
210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR

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

210: NVL(ota_tpm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: NVL(p_rec.attribute8, hr_api.g_varchar2) OR
212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR

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

212: NVL(ota_tpm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: NVL(p_rec.attribute9, hr_api.g_varchar2) OR
214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR

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

214: NVL(ota_tpm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: NVL(p_rec.attribute10, hr_api.g_varchar2) OR
216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR

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

216: NVL(ota_tpm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: NVL(p_rec.attribute11, hr_api.g_varchar2) OR
218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR

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

218: NVL(ota_tpm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: NVL(p_rec.attribute12, hr_api.g_varchar2) OR
220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR

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

220: NVL(ota_tpm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: NVL(p_rec.attribute13, hr_api.g_varchar2) OR
222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR

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

222: NVL(ota_tpm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: NVL(p_rec.attribute14, hr_api.g_varchar2) OR
224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR

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

224: NVL(ota_tpm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: NVL(p_rec.attribute15, hr_api.g_varchar2) OR
226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR

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

226: NVL(ota_tpm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: NVL(p_rec.attribute16, hr_api.g_varchar2) OR
228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR

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

228: NVL(ota_tpm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: NVL(p_rec.attribute17, hr_api.g_varchar2) OR
230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR

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

230: NVL(ota_tpm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: NVL(p_rec.attribute18, hr_api.g_varchar2) OR
232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR

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

232: NVL(ota_tpm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: NVL(p_rec.attribute19, hr_api.g_varchar2) OR
234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR

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

234: NVL(ota_tpm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: NVL(p_rec.attribute20, hr_api.g_varchar2) OR
236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR

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

236: NVL(ota_tpm_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: NVL(p_rec.attribute21, hr_api.g_varchar2) OR
238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR

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

238: NVL(ota_tpm_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: NVL(p_rec.attribute22, hr_api.g_varchar2) OR
240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR

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

240: NVL(ota_tpm_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: NVL(p_rec.attribute23, hr_api.g_varchar2) OR
242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR

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

242: NVL(ota_tpm_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: NVL(p_rec.attribute24, hr_api.g_varchar2) OR
244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR

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

244: NVL(ota_tpm_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: NVL(p_rec.attribute25, hr_api.g_varchar2) OR
246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR

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

246: NVL(ota_tpm_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: NVL(p_rec.attribute26, hr_api.g_varchar2) OR
248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tpm_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_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tpm_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )

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

248: NVL(ota_tpm_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tpm_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_member_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_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tpm_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_member_id IS NULL) THEN
257: --

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

250: NVL(ota_tpm_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tpm_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_member_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_tpm_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tpm_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_member_id IS NULL) THEN
257: --
258: -- Only execute the validation if absolutely necessary:
259: -- a) During update, the structure column value or any

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

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

Line 386: NVL(ota_tpm_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

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

Line 387: hr_api.argument_changed_error

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

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

391: END IF;
392: --
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_tpm_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_tpm_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN

392: --
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_tpm_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_tpm_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_tpm_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_tpm_shd.g_tab_nam);
401: END IF;

Line 423: hr_api.validate_bus_grp_id(p_rec.business_group_id

419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- VALIDATE IMPORTANT ATTRIBUTES
422: --
423: hr_api.validate_bus_grp_id(p_rec.business_group_id
424: ,p_associated_column1 => ota_tpm_shd.g_tab_nam ||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
425: --
426: hr_multi_message.end_validation_set;
427: --

Line 550: hr_api.validate_bus_grp_id(p_rec.business_group_id

546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- VALIDATE IMPORTANT ATTRIBUTES
549: --
550: hr_api.validate_bus_grp_id(p_rec.business_group_id
551: ,p_associated_column1 => ota_tpm_shd.g_tab_nam ||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
552: --
553: hr_multi_message.end_validation_set;
554: