APPS.PER_BPR_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error(p_api_name => l_proc,

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 => 'PAYROLL_RUN_ID',
47: p_argument_value => p_payroll_run_id);
48: --
49: open csr_sec_grp;

Line 66: hr_api.set_security_group_id

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

Line 101: hr_api.mandatory_arg_error(p_api_name => l_proc,

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 => 'PAYROLL_RUN_ID',
103: p_argument_value => p_payroll_run_id);
104: --
105: if ( nvl(g_payroll_run_id, hr_api.g_number) = p_payroll_run_id) then

Line 105: if ( nvl(g_payroll_run_id, hr_api.g_number) = p_payroll_run_id) then

101: hr_api.mandatory_arg_error(p_api_name => l_proc,
102: p_argument => 'PAYROLL_RUN_ID',
103: p_argument_value => p_payroll_run_id);
104: --
105: if ( nvl(g_payroll_run_id, hr_api.g_number) = p_payroll_run_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.

Line 180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>

176: begin
177: hr_utility.set_location('Entering:'||l_proc,10);
178: --
179: if ((p_rec.payroll_run_id is not null) and (
180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>

Line 181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or

177: hr_utility.set_location('Entering:'||l_proc,10);
178: --
179: if ((p_rec.payroll_run_id is not null) and (
180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or

Line 182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>

178: --
179: if ((p_rec.payroll_run_id is not null) and (
180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>

Line 183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or

179: if ((p_rec.payroll_run_id is not null) and (
180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or

Line 184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>

180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>

Line 185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or

181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or

Line 186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>

182: nvl(per_bpr_shd.g_old_rec.bpr_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>

Line 187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or

183: nvl(p_rec.bpr_attribute1, hr_api.g_varchar2) or
184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or

Line 188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>

184: nvl(per_bpr_shd.g_old_rec.bpr_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>

Line 189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or

185: nvl(p_rec.bpr_attribute2, hr_api.g_varchar2) or
186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or

Line 190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>

186: nvl(per_bpr_shd.g_old_rec.bpr_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>

Line 191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or

187: nvl(p_rec.bpr_attribute3, hr_api.g_varchar2) or
188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or

Line 192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>

188: nvl(per_bpr_shd.g_old_rec.bpr_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>

Line 193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or

189: nvl(p_rec.bpr_attribute4, hr_api.g_varchar2) or
190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or

Line 194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>

190: nvl(per_bpr_shd.g_old_rec.bpr_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>

Line 195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or

191: nvl(p_rec.bpr_attribute5, hr_api.g_varchar2) or
192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or

Line 196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>

192: nvl(per_bpr_shd.g_old_rec.bpr_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>

Line 197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or

193: nvl(p_rec.bpr_attribute6, hr_api.g_varchar2) or
194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or

Line 198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>

194: nvl(per_bpr_shd.g_old_rec.bpr_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>

Line 199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or

195: nvl(p_rec.bpr_attribute7, hr_api.g_varchar2) or
196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or

Line 200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>

196: nvl(per_bpr_shd.g_old_rec.bpr_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>

Line 201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or

197: nvl(p_rec.bpr_attribute8, hr_api.g_varchar2) or
198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or

Line 202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>

198: nvl(per_bpr_shd.g_old_rec.bpr_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>

Line 203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or

199: nvl(p_rec.bpr_attribute9, hr_api.g_varchar2) or
200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or

Line 204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>

200: nvl(per_bpr_shd.g_old_rec.bpr_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>

Line 205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or

201: nvl(p_rec.bpr_attribute10, hr_api.g_varchar2) or
202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or

Line 206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>

202: nvl(per_bpr_shd.g_old_rec.bpr_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>

Line 207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or

203: nvl(p_rec.bpr_attribute11, hr_api.g_varchar2) or
204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or

Line 208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>

204: nvl(per_bpr_shd.g_old_rec.bpr_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>

Line 209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or

205: nvl(p_rec.bpr_attribute12, hr_api.g_varchar2) or
206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or

Line 210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>

206: nvl(per_bpr_shd.g_old_rec.bpr_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>

Line 211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or

207: nvl(p_rec.bpr_attribute13, hr_api.g_varchar2) or
208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or

Line 212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>

208: nvl(per_bpr_shd.g_old_rec.bpr_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>

Line 213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or

209: nvl(p_rec.bpr_attribute14, hr_api.g_varchar2) or
210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or

Line 214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>

210: nvl(per_bpr_shd.g_old_rec.bpr_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>

Line 215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or

211: nvl(p_rec.bpr_attribute15, hr_api.g_varchar2) or
212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or

Line 216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>

212: nvl(per_bpr_shd.g_old_rec.bpr_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>

Line 217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or

213: nvl(p_rec.bpr_attribute16, hr_api.g_varchar2) or
214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or

Line 218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>

214: nvl(per_bpr_shd.g_old_rec.bpr_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>

Line 219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or

215: nvl(p_rec.bpr_attribute17, hr_api.g_varchar2) or
216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or

Line 220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>

216: nvl(per_bpr_shd.g_old_rec.bpr_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>

Line 221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or

217: nvl(p_rec.bpr_attribute18, hr_api.g_varchar2) or
218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or

Line 222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>

218: nvl(per_bpr_shd.g_old_rec.bpr_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>

Line 223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or

219: nvl(p_rec.bpr_attribute19, hr_api.g_varchar2) or
220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or

Line 224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>

220: nvl(per_bpr_shd.g_old_rec.bpr_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>

Line 225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or

221: nvl(p_rec.bpr_attribute20, hr_api.g_varchar2) or
222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or

Line 226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>

222: nvl(per_bpr_shd.g_old_rec.bpr_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>

Line 227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or

223: nvl(p_rec.bpr_attribute21, hr_api.g_varchar2) or
224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or

Line 228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>

224: nvl(per_bpr_shd.g_old_rec.bpr_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>

Line 229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or

225: nvl(p_rec.bpr_attribute22, hr_api.g_varchar2) or
226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or

Line 230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>

226: nvl(per_bpr_shd.g_old_rec.bpr_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>

Line 231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or

227: nvl(p_rec.bpr_attribute23, hr_api.g_varchar2) or
228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or

Line 232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>

228: nvl(per_bpr_shd.g_old_rec.bpr_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>

Line 233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or

229: nvl(p_rec.bpr_attribute24, hr_api.g_varchar2) or
230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or

Line 234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>

230: nvl(per_bpr_shd.g_old_rec.bpr_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>

Line 235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or

231: nvl(p_rec.bpr_attribute25, hr_api.g_varchar2) or
232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or

Line 236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>

232: nvl(per_bpr_shd.g_old_rec.bpr_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or
240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>

Line 237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or

233: nvl(p_rec.bpr_attribute26, hr_api.g_varchar2) or
234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or
240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bpr_attribute30, hr_api.g_varchar2) ))

Line 238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>

234: nvl(per_bpr_shd.g_old_rec.bpr_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or
240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bpr_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.payroll_run_id is null) then

Line 239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or

235: nvl(p_rec.bpr_attribute27, hr_api.g_varchar2) or
236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or
240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bpr_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.payroll_run_id is null) then
243: --

Line 240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>

236: nvl(per_bpr_shd.g_old_rec.bpr_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or
240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bpr_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.payroll_run_id is null) then
243: --
244: -- Only execute the validation if absolutely necessary:

Line 241: nvl(p_rec.bpr_attribute30, hr_api.g_varchar2) ))

237: nvl(p_rec.bpr_attribute28, hr_api.g_varchar2) or
238: nvl(per_bpr_shd.g_old_rec.bpr_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bpr_attribute29, hr_api.g_varchar2) or
240: nvl(per_bpr_shd.g_old_rec.bpr_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bpr_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.payroll_run_id is null) then
243: --
244: -- Only execute the validation if absolutely necessary:
245: -- a) During update, the structure column value or any

Line 369: IF nvl(p_rec.payroll_id, hr_api.g_number) <>

365: END IF;
366: --
367: hr_utility.set_location(l_proc,10);
368: --
369: IF nvl(p_rec.payroll_id, hr_api.g_number) <>
370: per_bpr_shd.g_old_rec.payroll_id then
371: l_argument:='payroll_id';
372: raise l_error;
373: END IF;

Line 376: IF nvl(p_rec.business_group_id, hr_api.g_number) <>

372: raise l_error;
373: END IF;
374: hr_utility.set_location(l_proc,20);
375: --
376: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
377: per_bpr_shd.g_old_rec.business_group_id then
378: l_argument:='business_group_id';
379: raise l_error;
380: END IF;

Line 386: hr_api.argument_changed_error

382: --
383: --
384: EXCEPTION
385: WHEN l_error THEN
386: hr_api.argument_changed_error
387: (p_api_name => l_proc
388: ,p_argument => l_argument);
389: WHEN OTHERS THEN
390: RAISE;

Line 436: hr_api.mandatory_arg_error

432: --
433: --
434: -- Check that the business_group_id is not null.
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc
438: ,p_argument => 'business_group_id'
439: ,p_argument_value => p_business_group_id
440: );

Line 509: AND NVL (per_bpr_shd.g_old_rec.period_start_date, hr_api.g_date)

505: );
506: --
507: IF ( (p_period_start_date IS NULL)
508: OR ( l_api_updating
509: AND NVL (per_bpr_shd.g_old_rec.period_start_date, hr_api.g_date)
510: = NVL (p_period_start_date, hr_api.g_date)
511: AND per_bpr_shd.g_old_rec.period_start_date IS NULL
512: )
513: ) THEN

Line 510: = NVL (p_period_start_date, hr_api.g_date)

506: --
507: IF ( (p_period_start_date IS NULL)
508: OR ( l_api_updating
509: AND NVL (per_bpr_shd.g_old_rec.period_start_date, hr_api.g_date)
510: = NVL (p_period_start_date, hr_api.g_date)
511: AND per_bpr_shd.g_old_rec.period_start_date IS NULL
512: )
513: ) THEN
514: --

Line 517: AND NVL (per_bpr_shd.g_old_rec.period_end_date, hr_api.g_date)

513: ) THEN
514: --
515: IF ( (p_period_end_date IS NULL)
516: OR ( l_api_updating
517: AND NVL (per_bpr_shd.g_old_rec.period_end_date, hr_api.g_date)
518: = NVL (p_period_end_date, hr_api.g_date)
519: AND per_bpr_shd.g_old_rec.period_end_date IS NULL
520: )
521: ) THEN

Line 518: = NVL (p_period_end_date, hr_api.g_date)

514: --
515: IF ( (p_period_end_date IS NULL)
516: OR ( l_api_updating
517: AND NVL (per_bpr_shd.g_old_rec.period_end_date, hr_api.g_date)
518: = NVL (p_period_end_date, hr_api.g_date)
519: AND per_bpr_shd.g_old_rec.period_end_date IS NULL
520: )
521: ) THEN
522: --

Line 525: AND NVL (per_bpr_shd.g_old_rec.processing_date, hr_api.g_date)

521: ) THEN
522: --
523: IF ( (p_processing_date IS NULL)
524: OR ( l_api_updating
525: AND NVL (per_bpr_shd.g_old_rec.processing_date, hr_api.g_date)
526: = NVL (p_processing_date, hr_api.g_date)
527: AND per_bpr_shd.g_old_rec.processing_date IS NULL
528: )
529: ) THEN

Line 526: = NVL (p_processing_date, hr_api.g_date)

522: --
523: IF ( (p_processing_date IS NULL)
524: OR ( l_api_updating
525: AND NVL (per_bpr_shd.g_old_rec.processing_date, hr_api.g_date)
526: = NVL (p_processing_date, hr_api.g_date)
527: AND per_bpr_shd.g_old_rec.processing_date IS NULL
528: )
529: ) THEN
530: --

Line 544: IF ((NOT l_api_updating AND NVL(p_period_start_date, hr_api.g_sot)

540: -- Check to make sure that the processing date is later or equal to the
541: -- start date.
542: --
543: -- If inserting and the start date is greater than the processing date ..
544: IF ((NOT l_api_updating AND NVL(p_period_start_date, hr_api.g_sot)
545: > p_processing_date)
546: OR
547: -- If updating and either the start date or processing date have changed
548: ((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_date,

Line 549: hr_api.g_date)

545: > p_processing_date)
546: OR
547: -- If updating and either the start date or processing date have changed
548: ((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_date,
549: hr_api.g_date)
550: <> nvl(p_period_start_date, hr_api.g_date))
551: OR
552: (l_api_updating and nvl(per_bpr_shd.g_old_rec.processing_date,
553: hr_api.g_date)

Line 550: <> nvl(p_period_start_date, hr_api.g_date))

546: OR
547: -- If updating and either the start date or processing date have changed
548: ((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_date,
549: hr_api.g_date)
550: <> nvl(p_period_start_date, hr_api.g_date))
551: OR
552: (l_api_updating and nvl(per_bpr_shd.g_old_rec.processing_date,
553: hr_api.g_date)
554: <> nvl(p_processing_date, hr_api.g_date)))) THEN

Line 553: hr_api.g_date)

549: hr_api.g_date)
550: <> nvl(p_period_start_date, hr_api.g_date))
551: OR
552: (l_api_updating and nvl(per_bpr_shd.g_old_rec.processing_date,
553: hr_api.g_date)
554: <> nvl(p_processing_date, hr_api.g_date)))) THEN
555: --
556: -- Make the dates are equal to their actual value and not
557: -- hr_api.g_date

Line 554: <> nvl(p_processing_date, hr_api.g_date)))) THEN

550: <> nvl(p_period_start_date, hr_api.g_date))
551: OR
552: (l_api_updating and nvl(per_bpr_shd.g_old_rec.processing_date,
553: hr_api.g_date)
554: <> nvl(p_processing_date, hr_api.g_date)))) THEN
555: --
556: -- Make the dates are equal to their actual value and not
557: -- hr_api.g_date
558: --

Line 557: -- hr_api.g_date

553: hr_api.g_date)
554: <> nvl(p_processing_date, hr_api.g_date)))) THEN
555: --
556: -- Make the dates are equal to their actual value and not
557: -- hr_api.g_date
558: --
559: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN
560: --
561: l_start_date := NVL(per_bpr_shd.g_old_rec.period_start_date

Line 559: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN

555: --
556: -- Make the dates are equal to their actual value and not
557: -- hr_api.g_date
558: --
559: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN
560: --
561: l_start_date := NVL(per_bpr_shd.g_old_rec.period_start_date
562: ,hr_api.g_sot);
563: --

Line 562: ,hr_api.g_sot);

558: --
559: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN
560: --
561: l_start_date := NVL(per_bpr_shd.g_old_rec.period_start_date
562: ,hr_api.g_sot);
563: --
564: ELSE
565: --
566: l_start_date := NVL(p_period_start_date, hr_api.g_sot);

Line 566: l_start_date := NVL(p_period_start_date, hr_api.g_sot);

562: ,hr_api.g_sot);
563: --
564: ELSE
565: --
566: l_start_date := NVL(p_period_start_date, hr_api.g_sot);
567: --
568: END IF;
569: IF (l_api_updating AND p_processing_date = hr_api.g_date) THEN
570: --

Line 569: IF (l_api_updating AND p_processing_date = hr_api.g_date) THEN

565: --
566: l_start_date := NVL(p_period_start_date, hr_api.g_sot);
567: --
568: END IF;
569: IF (l_api_updating AND p_processing_date = hr_api.g_date) THEN
570: --
571: l_processing_date := NVL(per_bpr_shd.g_old_rec.processing_date
572: ,hr_api.g_eot);
573: --

Line 572: ,hr_api.g_eot);

568: END IF;
569: IF (l_api_updating AND p_processing_date = hr_api.g_date) THEN
570: --
571: l_processing_date := NVL(per_bpr_shd.g_old_rec.processing_date
572: ,hr_api.g_eot);
573: --
574: ELSE
575: --
576: l_processing_date := NVL(p_processing_date,hr_api.g_eot);

Line 576: l_processing_date := NVL(p_processing_date,hr_api.g_eot);

572: ,hr_api.g_eot);
573: --
574: ELSE
575: --
576: l_processing_date := NVL(p_processing_date,hr_api.g_eot);
577: --
578: END IF;
579: --
580: -- Now the actual date exist, perform the check

Line 637: hr_api.g_date)

633: ,p_object_version_number => p_object_version_number
634: );
635: --
636: IF (((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_date,
637: hr_api.g_date)
638: <> nvl(p_period_start_date, hr_api.g_date))
639: OR
640: (l_api_updating and nvl(per_bpr_shd.g_old_rec.period_end_date,
641: hr_api.g_date)

Line 638: <> nvl(p_period_start_date, hr_api.g_date))

634: );
635: --
636: IF (((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_date,
637: hr_api.g_date)
638: <> nvl(p_period_start_date, hr_api.g_date))
639: OR
640: (l_api_updating and nvl(per_bpr_shd.g_old_rec.period_end_date,
641: hr_api.g_date)
642: <> nvl(p_period_end_date, hr_api.g_date))

Line 641: hr_api.g_date)

637: hr_api.g_date)
638: <> nvl(p_period_start_date, hr_api.g_date))
639: OR
640: (l_api_updating and nvl(per_bpr_shd.g_old_rec.period_end_date,
641: hr_api.g_date)
642: <> nvl(p_period_end_date, hr_api.g_date))
643: )
644: OR
645: (NOT l_api_updating)) THEN

Line 642: <> nvl(p_period_end_date, hr_api.g_date))

638: <> nvl(p_period_start_date, hr_api.g_date))
639: OR
640: (l_api_updating and nvl(per_bpr_shd.g_old_rec.period_end_date,
641: hr_api.g_date)
642: <> nvl(p_period_end_date, hr_api.g_date))
643: )
644: OR
645: (NOT l_api_updating)) THEN
646: --

Line 649: -- hr_api.g_date

645: (NOT l_api_updating)) THEN
646: --
647: --
648: -- Make sure the dates are equal to their actual value and not
649: -- hr_api.g_date
650: --
651: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN
652: --
653: l_start_date := per_bpr_shd.g_old_rec.period_start_date;

Line 651: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN

647: --
648: -- Make sure the dates are equal to their actual value and not
649: -- hr_api.g_date
650: --
651: IF (l_api_updating and p_period_start_date = hr_api.g_date) THEN
652: --
653: l_start_date := per_bpr_shd.g_old_rec.period_start_date;
654: --
655: ELSE

Line 660: IF (l_api_updating AND p_period_end_date = hr_api.g_date) THEN

656: --
657: l_start_date := p_period_start_date;
658: --
659: END IF;
660: IF (l_api_updating AND p_period_end_date = hr_api.g_date) THEN
661: --
662: l_end_date := per_bpr_shd.g_old_rec.period_end_date;
663: --
664: ELSE

Line 740: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

736: --
737: -- Call all supporting business operations.
738: --
739: --
740: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
741: --
742: chk_identifier
743: ( p_payroll_identifier => p_rec.payroll_identifier
744: , p_business_group_id => p_rec.business_group_id

Line 784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: -- Call all supporting business operations
783: --
784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
785: --
786: -- VALIDATE IDENTIFIER
787: -- Business Rule Mapping
788: -- =====================