41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error(p_api_name => l_proc,
46: p_argument => 'BALANCE_AMOUNT_ID',
47: p_argument_value => p_balance_amount_id);
48: --
49: open csr_sec_grp;
62: close csr_sec_grp;
63: --
64: -- Set the security_group_id in CLIENT_INFO
65: --
66: hr_api.set_security_group_id
67: (p_security_group_id => l_security_group_id
68: );
69: --
70: hr_utility.set_location(' Leaving:'|| l_proc, 20);
97: hr_utility.set_location('Entering:'|| l_proc, 10);
98: --
99: -- Ensure that all the mandatory parameter are not null
100: --
101: hr_api.mandatory_arg_error(p_api_name => l_proc,
102: p_argument => 'BALANCE_AMOUNT_ID',
103: p_argument_value => p_balance_amount_id);
104: --
105: if ( nvl(g_balance_amount_id, hr_api.g_number) = p_balance_amount_id) then
101: hr_api.mandatory_arg_error(p_api_name => l_proc,
102: p_argument => 'BALANCE_AMOUNT_ID',
103: p_argument_value => p_balance_amount_id);
104: --
105: if ( nvl(g_balance_amount_id, hr_api.g_number) = p_balance_amount_id) then
106: --
107: -- The legislation code has already been found with a previous
108: -- call to this function. Just return the value in the global
109: -- variable.
176: begin
177: hr_utility.set_location('Entering:'||l_proc,10);
178: --
179: if ((p_rec.balance_amount_id is not null) and (
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
177: hr_utility.set_location('Entering:'||l_proc,10);
178: --
179: if ((p_rec.balance_amount_id is not null) and (
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
178: --
179: if ((p_rec.balance_amount_id is not null) and (
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
179: if ((p_rec.balance_amount_id is not null) and (
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.balance_amount_id is null) then
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.balance_amount_id is null) then
243: --
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.balance_amount_id is null) then
243: --
244: -- Only execute the validation if absolutely necessary:
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.balance_amount_id is null) then
243: --
244: -- Only execute the validation if absolutely necessary:
245: -- a) During update, the structure column value or any
365: END IF;
366: --
367: hr_utility.set_location(l_proc,10);
368: --
369: IF nvl(p_rec.balance_type_id, hr_api.g_number) <>
370: per_bba_shd.g_old_rec.balance_type_id then
371: l_argument:='balance_type_id';
372: raise l_error;
373: END IF;
372: raise l_error;
373: END IF;
374: hr_utility.set_location(l_proc,20);
375: --
376: IF nvl(p_rec.processed_assignment_id, hr_api.g_number) <>
377: per_bba_shd.g_old_rec.processed_assignment_id then
378: l_argument:='processed_assignment_id';
379: raise l_error;
380: END IF;
379: raise l_error;
380: END IF;
381: hr_utility.set_location(l_proc,30);
382: --
383: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
384: per_bba_shd.g_old_rec.business_group_id then
385: l_argument:='business_group_id';
386: raise l_error;
387: END IF;
388: hr_utility.set_location(l_proc,40);
389: --
390: EXCEPTION
391: WHEN l_error THEN
392: hr_api.argument_changed_error
393: (p_api_name => l_proc
394: ,p_argument => l_argument);
395: WHEN OTHERS THEN
396: RAISE;
517: hr_utility.set_location('Entering:'||l_proc, 5);
518: --
519: -- Call all supporting business operations
520: --
521: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
522: --
523: CHK_PROCESSED_ASG_ID
524: (p_processed_assignment_id => p_rec.processed_assignment_id);
525: --
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call all supporting business operations
550: --
551: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
552: --
553: chk_non_updateable_args(p_rec => p_rec);
554: --
555: -- Validate flexfields