APPS.PER_BPR_BUS dependencies on PER_BPR_SHD

Line 171: (p_rec in per_bpr_shd.g_rec_type

167: -- Internal Row Handler Use Only.
168: --
169: -- ----------------------------------------------------------------------------
170: procedure chk_df
171: (p_rec in per_bpr_shd.g_rec_type
172: ) is
173: --
174: l_proc varchar2(72) := g_package || 'chk_df';
175: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 346: Procedure chk_non_updateable_args(p_rec in per_bpr_shd.g_rec_type) IS

342: -- have been altered.
343: --
344: -- {End Of Comments}
345: -- ----------------------------------------------------------------------------
346: Procedure chk_non_updateable_args(p_rec in per_bpr_shd.g_rec_type) IS
347: --
348: l_proc varchar2(72) := g_package || 'check_non_updateable_args';
349: l_error EXCEPTION;
350: l_argument varchar2(30);

Line 358: IF NOT per_bpr_shd.api_updating

354: --
355: -- Only proceed with the validation if a row exists for the current
356: -- record in the HR Schema.
357: --
358: IF NOT per_bpr_shd.api_updating
359: (p_payroll_run_id => p_rec.payroll_run_id
360: ,p_object_version_number => p_rec.object_version_number
361: ) THEN
362: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 370: per_bpr_shd.g_old_rec.payroll_id then

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;
374: hr_utility.set_location(l_proc,20);

Line 377: per_bpr_shd.g_old_rec.business_group_id then

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;
381: hr_utility.set_location(l_proc,30);

Line 452: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_UK1');

448: -- so error.
449: --
450: close c_check_identifier;
451: --
452: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_UK1');
453: --
454: END IF;
455: --
456: close c_check_identifier;

Line 502: l_api_updating := per_bpr_shd.api_updating

498: --
499: BEGIN
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: l_api_updating := per_bpr_shd.api_updating
503: (p_payroll_run_id => p_payroll_run_id
504: ,p_object_version_number => p_object_version_number
505: );
506: --

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 511: AND per_bpr_shd.g_old_rec.period_start_date IS NULL

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: --
515: IF ( (p_period_end_date IS NULL)

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 519: AND per_bpr_shd.g_old_rec.period_end_date IS NULL

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: --
523: IF ( (p_processing_date IS NULL)

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 527: AND per_bpr_shd.g_old_rec.processing_date IS NULL

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: --
531: -- All the dates are Null, so raise an error as at least one must be

Line 548: ((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_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,
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,

Line 552: (l_api_updating and nvl(per_bpr_shd.g_old_rec.processing_date,

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
555: --
556: -- Make the dates are equal to their actual value and not

Line 561: l_start_date := NVL(per_bpr_shd.g_old_rec.period_start_date

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: --
564: ELSE
565: --

Line 571: l_processing_date := NVL(per_bpr_shd.g_old_rec.processing_date

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: --
574: ELSE
575: --

Line 631: l_api_updating := per_bpr_shd.api_updating

627: -- c) The period_end_date has changed.
628: -- d) a record is being inserted.
629: --
630: --
631: l_api_updating := per_bpr_shd.api_updating
632: (p_payroll_run_id => p_payroll_run_id
633: ,p_object_version_number => p_object_version_number
634: );
635: --

Line 636: IF (((l_api_updating and nvl(per_bpr_shd.g_old_rec.period_start_date,

632: (p_payroll_run_id => p_payroll_run_id
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,

Line 640: (l_api_updating and nvl(per_bpr_shd.g_old_rec.period_end_date,

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))
643: )
644: OR

Line 653: l_start_date := per_bpr_shd.g_old_rec.period_start_date;

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
656: --
657: l_start_date := p_period_start_date;

Line 662: l_end_date := per_bpr_shd.g_old_rec.period_end_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
665: --
666: l_end_date := p_period_end_date;

Line 718: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_REX');

714: fetch csr_payroll_exists into l_exists;
715: if csr_payroll_exists%FOUND then
716: -- row exists - raise error by calling contraint error
717: close csr_payroll_exists;
718: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_REX');
719: end if;
720: close csr_payroll_exists;
721: end if;
722: end chk_row_exists;

Line 729: p_rec in per_bpr_shd.g_rec_type

725: -- ----------------------------------------------------------------------------
726: -- |---------------------------< insert_validate >----------------------------|
727: -- ----------------------------------------------------------------------------
728: Procedure insert_validate(p_effective_date in date,
729: p_rec in per_bpr_shd.g_rec_type
730: ) is
731: --
732: l_proc varchar2(72) := g_package||'insert_validate';
733: --

Line 774: p_rec in per_bpr_shd.g_rec_type

770: -- ----------------------------------------------------------------------------
771: -- |---------------------------< update_validate >----------------------------|
772: -- ----------------------------------------------------------------------------
773: Procedure update_validate(p_effective_date in date,
774: p_rec in per_bpr_shd.g_rec_type
775: ) is
776: --
777: l_proc varchar2(72) := g_package||'update_validate';
778: --

Line 824: Procedure delete_validate(p_rec in per_bpr_shd.g_rec_type) is

820: --
821: -- ----------------------------------------------------------------------------
822: -- |---------------------------< delete_validate >----------------------------|
823: -- ----------------------------------------------------------------------------
824: Procedure delete_validate(p_rec in per_bpr_shd.g_rec_type) is
825: --
826: l_proc varchar2(72) := g_package||'delete_validate';
827: --
828: Begin