APPS.BEN_CSO_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

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

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: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

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

Line 116: hr_api.mandatory_arg_error

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

Line 122: if ( nvl(ben_cso_bus.g_cwb_stock_optn_dtls_id, hr_api.g_number)

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

Line 288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>

284: begin
285: hr_utility.set_location('Entering:'||l_proc,10);
286: --
287: if ((p_rec.cwb_stock_optn_dtls_id is not null) and (
288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>

Line 289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or

285: hr_utility.set_location('Entering:'||l_proc,10);
286: --
287: if ((p_rec.cwb_stock_optn_dtls_id is not null) and (
288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or

Line 290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>

286: --
287: if ((p_rec.cwb_stock_optn_dtls_id is not null) and (
288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>

Line 291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or

287: if ((p_rec.cwb_stock_optn_dtls_id is not null) and (
288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or

Line 292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>

288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>

Line 293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or

289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or

Line 294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>

290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>

Line 295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or

291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or

Line 296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>

292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>

Line 297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or

293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or

Line 298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>

294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>

Line 299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or

295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or

Line 300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>

296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>

Line 301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or

297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or

Line 302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>

298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>

Line 303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or

299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or

Line 304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>

300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>

Line 305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or

301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or

Line 306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>

302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>

Line 307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or

303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or

Line 308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>

304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>

Line 309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or

305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or

Line 310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>

306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>

Line 311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or

307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or

Line 312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>

308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>

Line 313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or

309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or

Line 314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>

310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>

Line 315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or

311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or

Line 316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>

312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>

Line 317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or

313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or

Line 318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>

314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>

Line 319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or

315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or

Line 320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>

316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>

Line 321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or

317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or

Line 322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>

318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>

Line 323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or

319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or

Line 324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>

320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>

Line 325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or

321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or

Line 326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>

322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>

Line 327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or

323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or

Line 328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>

324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>

Line 329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or

325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or

Line 330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>

326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>

Line 331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or

327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or

Line 332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>

328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>

Line 333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or

329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or

Line 334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>

330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>

Line 335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or

331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or

Line 336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>

332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>

Line 337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or

333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or

Line 338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>

334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>

Line 339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or

335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or

Line 340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>

336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>

Line 341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or

337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or

Line 342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>

338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>

Line 343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or

339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or

Line 344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>

340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>

Line 345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or

341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))

Line 346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>

342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))
350: or (p_rec.cwb_stock_optn_dtls_id is null) then

Line 347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or

343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))
350: or (p_rec.cwb_stock_optn_dtls_id is null) then
351: --

Line 348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>

344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))
350: or (p_rec.cwb_stock_optn_dtls_id is null) then
351: --
352: -- Only execute the validation if absolutely necessary:

Line 349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))

345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))
350: or (p_rec.cwb_stock_optn_dtls_id is null) then
351: --
352: -- Only execute the validation if absolutely necessary:
353: -- a) During update, the structure column value or any

Line 502: hr_api.validate_bus_grp_id

498: );
499:
500: if(p_rec.business_group_id is not null)
501: then
502: hr_api.validate_bus_grp_id
503: (p_business_group_id => p_rec.business_group_id
504: ,p_associated_column1 => ben_cso_shd.g_tab_nam
505: || '.BUSINESS_GROUP_ID');
506: end if;

Line 546: hr_api.validate_bus_grp_id

542: );
543:
544: if(p_rec.business_group_id is not null)
545: then
546: hr_api.validate_bus_grp_id
547: (p_business_group_id => p_rec.business_group_id
548: ,p_associated_column1 => ben_cso_shd.g_tab_nam
549: || '.BUSINESS_GROUP_ID');
550: end if;