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: );
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
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: --
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: );
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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) ))
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
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: --
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:
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
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;
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;