DBA Data[Home] [Help]

APPS.PER_BPR_UPD dependencies on PER_BPR_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_bpr_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_bpr_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 115: per_bpr_shd.constraint_error

111: --
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: per_bpr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_bpr_shd.constraint_error

Line 119: per_bpr_shd.constraint_error

115: per_bpr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_bpr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_bpr_shd.constraint_error

Line 123: per_bpr_shd.constraint_error

119: per_bpr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_bpr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: Raise;
127: End update_dml;

Line 161: Procedure pre_update(p_rec in per_bpr_shd.g_rec_type) is

157: -- Internal Row Handler Use Only.
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_update(p_rec in per_bpr_shd.g_rec_type) is
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --
165: Begin

Line 204: p_rec in per_bpr_shd.g_rec_type) is

200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure post_update(p_effective_date in date,
204: p_rec in per_bpr_shd.g_rec_type) is
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207: --
208: Begin

Line 252: => per_bpr_shd.g_old_rec.payroll_id,

248: p_bpr_attribute28 => p_rec.bpr_attribute28,
249: p_bpr_attribute29 => p_rec.bpr_attribute29,
250: p_bpr_attribute30 => p_rec.bpr_attribute30,
251: p_payroll_id_o
252: => per_bpr_shd.g_old_rec.payroll_id,
253: p_business_group_id_o
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,

Line 254: => per_bpr_shd.g_old_rec.business_group_id,

250: p_bpr_attribute30 => p_rec.bpr_attribute30,
251: p_payroll_id_o
252: => per_bpr_shd.g_old_rec.payroll_id,
253: p_business_group_id_o
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,

Line 256: => per_bpr_shd.g_old_rec.payroll_identifier,

252: => per_bpr_shd.g_old_rec.payroll_id,
253: p_business_group_id_o
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,

Line 258: => per_bpr_shd.g_old_rec.period_start_date,

254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,

Line 260: => per_bpr_shd.g_old_rec.period_end_date,

256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,

Line 262: => per_bpr_shd.g_old_rec.processing_date,

258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,

Line 264: => per_bpr_shd.g_old_rec.object_version_number,

260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,

Line 266: => per_bpr_shd.g_old_rec.bpr_attribute_category,

262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,

Line 268: => per_bpr_shd.g_old_rec.bpr_attribute1,

264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,

Line 270: => per_bpr_shd.g_old_rec.bpr_attribute2,

266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,

Line 272: => per_bpr_shd.g_old_rec.bpr_attribute3,

268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,

Line 274: => per_bpr_shd.g_old_rec.bpr_attribute4,

270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,

Line 276: => per_bpr_shd.g_old_rec.bpr_attribute5,

272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,

Line 278: => per_bpr_shd.g_old_rec.bpr_attribute6,

274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,

Line 280: => per_bpr_shd.g_old_rec.bpr_attribute7,

276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,

Line 282: => per_bpr_shd.g_old_rec.bpr_attribute8,

278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,

Line 284: => per_bpr_shd.g_old_rec.bpr_attribute9,

280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,

Line 286: => per_bpr_shd.g_old_rec.bpr_attribute10,

282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,

Line 288: => per_bpr_shd.g_old_rec.bpr_attribute11,

284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,

Line 290: => per_bpr_shd.g_old_rec.bpr_attribute12,

286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,

Line 292: => per_bpr_shd.g_old_rec.bpr_attribute13,

288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,

Line 294: => per_bpr_shd.g_old_rec.bpr_attribute14,

290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,

Line 296: => per_bpr_shd.g_old_rec.bpr_attribute15,

292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,

Line 298: => per_bpr_shd.g_old_rec.bpr_attribute16,

294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,

Line 300: => per_bpr_shd.g_old_rec.bpr_attribute17,

296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,

Line 302: => per_bpr_shd.g_old_rec.bpr_attribute18,

298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,

Line 304: => per_bpr_shd.g_old_rec.bpr_attribute19,

300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,

Line 306: => per_bpr_shd.g_old_rec.bpr_attribute20,

302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,

Line 308: => per_bpr_shd.g_old_rec.bpr_attribute21,

304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,

Line 310: => per_bpr_shd.g_old_rec.bpr_attribute22,

306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,

Line 312: => per_bpr_shd.g_old_rec.bpr_attribute23,

308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,

Line 314: => per_bpr_shd.g_old_rec.bpr_attribute24,

310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,

Line 316: => per_bpr_shd.g_old_rec.bpr_attribute25,

312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,

Line 318: => per_bpr_shd.g_old_rec.bpr_attribute26,

314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,

Line 320: => per_bpr_shd.g_old_rec.bpr_attribute27,

316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,

Line 322: => per_bpr_shd.g_old_rec.bpr_attribute28,

318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
325: p_bpr_attribute30_o
326: => per_bpr_shd.g_old_rec.bpr_attribute30

Line 324: => per_bpr_shd.g_old_rec.bpr_attribute29,

320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
325: p_bpr_attribute30_o
326: => per_bpr_shd.g_old_rec.bpr_attribute30
327: );
328: --

Line 326: => per_bpr_shd.g_old_rec.bpr_attribute30

322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
325: p_bpr_attribute30_o
326: => per_bpr_shd.g_old_rec.bpr_attribute30
327: );
328: --
329: exception
330: --

Line 385: Procedure convert_defs(p_rec in out nocopy per_bpr_shd.g_rec_type) is

381: -- Internal Row Handler Use Only.
382: --
383: -- {End Of Comments}
384: -- ----------------------------------------------------------------------------
385: Procedure convert_defs(p_rec in out nocopy per_bpr_shd.g_rec_type) is
386: --
387: l_proc varchar2(72) := g_package||'convert_defs';
388: --
389: Begin

Line 400: per_bpr_shd.g_old_rec.payroll_id;

396: -- is being used then we must set to the 'current' argument value.
397: --
398: If (p_rec.payroll_id = hr_api.g_number) then
399: p_rec.payroll_id :=
400: per_bpr_shd.g_old_rec.payroll_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: per_bpr_shd.g_old_rec.business_group_id;

Line 404: per_bpr_shd.g_old_rec.business_group_id;

400: per_bpr_shd.g_old_rec.payroll_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: per_bpr_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.payroll_identifier = hr_api.g_varchar2) then
407: p_rec.payroll_identifier :=
408: per_bpr_shd.g_old_rec.payroll_identifier;

Line 408: per_bpr_shd.g_old_rec.payroll_identifier;

404: per_bpr_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.payroll_identifier = hr_api.g_varchar2) then
407: p_rec.payroll_identifier :=
408: per_bpr_shd.g_old_rec.payroll_identifier;
409: End If;
410: If (p_rec.period_start_date = hr_api.g_date) then
411: p_rec.period_start_date :=
412: per_bpr_shd.g_old_rec.period_start_date;

Line 412: per_bpr_shd.g_old_rec.period_start_date;

408: per_bpr_shd.g_old_rec.payroll_identifier;
409: End If;
410: If (p_rec.period_start_date = hr_api.g_date) then
411: p_rec.period_start_date :=
412: per_bpr_shd.g_old_rec.period_start_date;
413: End If;
414: If (p_rec.period_end_date = hr_api.g_date) then
415: p_rec.period_end_date :=
416: per_bpr_shd.g_old_rec.period_end_date;

Line 416: per_bpr_shd.g_old_rec.period_end_date;

412: per_bpr_shd.g_old_rec.period_start_date;
413: End If;
414: If (p_rec.period_end_date = hr_api.g_date) then
415: p_rec.period_end_date :=
416: per_bpr_shd.g_old_rec.period_end_date;
417: End If;
418: If (p_rec.processing_date = hr_api.g_date) then
419: p_rec.processing_date :=
420: per_bpr_shd.g_old_rec.processing_date;

Line 420: per_bpr_shd.g_old_rec.processing_date;

416: per_bpr_shd.g_old_rec.period_end_date;
417: End If;
418: If (p_rec.processing_date = hr_api.g_date) then
419: p_rec.processing_date :=
420: per_bpr_shd.g_old_rec.processing_date;
421: End If;
422: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
423: p_rec.bpr_attribute_category :=
424: per_bpr_shd.g_old_rec.bpr_attribute_category;

Line 424: per_bpr_shd.g_old_rec.bpr_attribute_category;

420: per_bpr_shd.g_old_rec.processing_date;
421: End If;
422: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
423: p_rec.bpr_attribute_category :=
424: per_bpr_shd.g_old_rec.bpr_attribute_category;
425: End If;
426: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
427: p_rec.bpr_attribute1:=
428: per_bpr_shd.g_old_rec.bpr_attribute1;

Line 428: per_bpr_shd.g_old_rec.bpr_attribute1;

424: per_bpr_shd.g_old_rec.bpr_attribute_category;
425: End If;
426: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
427: p_rec.bpr_attribute1:=
428: per_bpr_shd.g_old_rec.bpr_attribute1;
429: End If;
430: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
431: p_rec.bpr_attribute2:=
432: per_bpr_shd.g_old_rec.bpr_attribute2;

Line 432: per_bpr_shd.g_old_rec.bpr_attribute2;

428: per_bpr_shd.g_old_rec.bpr_attribute1;
429: End If;
430: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
431: p_rec.bpr_attribute2:=
432: per_bpr_shd.g_old_rec.bpr_attribute2;
433: End If;
434: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
435: p_rec.bpr_attribute3:=
436: per_bpr_shd.g_old_rec.bpr_attribute3;

Line 436: per_bpr_shd.g_old_rec.bpr_attribute3;

432: per_bpr_shd.g_old_rec.bpr_attribute2;
433: End If;
434: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
435: p_rec.bpr_attribute3:=
436: per_bpr_shd.g_old_rec.bpr_attribute3;
437: End If;
438: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
439: p_rec.bpr_attribute4:=
440: per_bpr_shd.g_old_rec.bpr_attribute4;

Line 440: per_bpr_shd.g_old_rec.bpr_attribute4;

436: per_bpr_shd.g_old_rec.bpr_attribute3;
437: End If;
438: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
439: p_rec.bpr_attribute4:=
440: per_bpr_shd.g_old_rec.bpr_attribute4;
441: End If;
442: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
443: p_rec.bpr_attribute5:=
444: per_bpr_shd.g_old_rec.bpr_attribute5;

Line 444: per_bpr_shd.g_old_rec.bpr_attribute5;

440: per_bpr_shd.g_old_rec.bpr_attribute4;
441: End If;
442: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
443: p_rec.bpr_attribute5:=
444: per_bpr_shd.g_old_rec.bpr_attribute5;
445: End If;
446: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
447: p_rec.bpr_attribute6:=
448: per_bpr_shd.g_old_rec.bpr_attribute6;

Line 448: per_bpr_shd.g_old_rec.bpr_attribute6;

444: per_bpr_shd.g_old_rec.bpr_attribute5;
445: End If;
446: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
447: p_rec.bpr_attribute6:=
448: per_bpr_shd.g_old_rec.bpr_attribute6;
449: End If;
450: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
451: p_rec.bpr_attribute7:=
452: per_bpr_shd.g_old_rec.bpr_attribute7;

Line 452: per_bpr_shd.g_old_rec.bpr_attribute7;

448: per_bpr_shd.g_old_rec.bpr_attribute6;
449: End If;
450: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
451: p_rec.bpr_attribute7:=
452: per_bpr_shd.g_old_rec.bpr_attribute7;
453: End If;
454: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
455: p_rec.bpr_attribute8:=
456: per_bpr_shd.g_old_rec.bpr_attribute8;

Line 456: per_bpr_shd.g_old_rec.bpr_attribute8;

452: per_bpr_shd.g_old_rec.bpr_attribute7;
453: End If;
454: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
455: p_rec.bpr_attribute8:=
456: per_bpr_shd.g_old_rec.bpr_attribute8;
457: End If;
458: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
459: p_rec.bpr_attribute9:=
460: per_bpr_shd.g_old_rec.bpr_attribute9;

Line 460: per_bpr_shd.g_old_rec.bpr_attribute9;

456: per_bpr_shd.g_old_rec.bpr_attribute8;
457: End If;
458: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
459: p_rec.bpr_attribute9:=
460: per_bpr_shd.g_old_rec.bpr_attribute9;
461: End If;
462: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
463: p_rec.bpr_attribute10:=
464: per_bpr_shd.g_old_rec.bpr_attribute10;

Line 464: per_bpr_shd.g_old_rec.bpr_attribute10;

460: per_bpr_shd.g_old_rec.bpr_attribute9;
461: End If;
462: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
463: p_rec.bpr_attribute10:=
464: per_bpr_shd.g_old_rec.bpr_attribute10;
465: End If;
466: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
467: p_rec.bpr_attribute11:=
468: per_bpr_shd.g_old_rec.bpr_attribute11;

Line 468: per_bpr_shd.g_old_rec.bpr_attribute11;

464: per_bpr_shd.g_old_rec.bpr_attribute10;
465: End If;
466: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
467: p_rec.bpr_attribute11:=
468: per_bpr_shd.g_old_rec.bpr_attribute11;
469: End If;
470: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
471: p_rec.bpr_attribute12:=
472: per_bpr_shd.g_old_rec.bpr_attribute12;

Line 472: per_bpr_shd.g_old_rec.bpr_attribute12;

468: per_bpr_shd.g_old_rec.bpr_attribute11;
469: End If;
470: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
471: p_rec.bpr_attribute12:=
472: per_bpr_shd.g_old_rec.bpr_attribute12;
473: End If;
474: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
475: p_rec.bpr_attribute13:=
476: per_bpr_shd.g_old_rec.bpr_attribute13;

Line 476: per_bpr_shd.g_old_rec.bpr_attribute13;

472: per_bpr_shd.g_old_rec.bpr_attribute12;
473: End If;
474: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
475: p_rec.bpr_attribute13:=
476: per_bpr_shd.g_old_rec.bpr_attribute13;
477: End If;
478: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
479: p_rec.bpr_attribute14:=
480: per_bpr_shd.g_old_rec.bpr_attribute14;

Line 480: per_bpr_shd.g_old_rec.bpr_attribute14;

476: per_bpr_shd.g_old_rec.bpr_attribute13;
477: End If;
478: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
479: p_rec.bpr_attribute14:=
480: per_bpr_shd.g_old_rec.bpr_attribute14;
481: End If;
482: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
483: p_rec.bpr_attribute15:=
484: per_bpr_shd.g_old_rec.bpr_attribute15;

Line 484: per_bpr_shd.g_old_rec.bpr_attribute15;

480: per_bpr_shd.g_old_rec.bpr_attribute14;
481: End If;
482: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
483: p_rec.bpr_attribute15:=
484: per_bpr_shd.g_old_rec.bpr_attribute15;
485: End If;
486: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
487: p_rec.bpr_attribute16:=
488: per_bpr_shd.g_old_rec.bpr_attribute16;

Line 488: per_bpr_shd.g_old_rec.bpr_attribute16;

484: per_bpr_shd.g_old_rec.bpr_attribute15;
485: End If;
486: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
487: p_rec.bpr_attribute16:=
488: per_bpr_shd.g_old_rec.bpr_attribute16;
489: End If;
490: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
491: p_rec.bpr_attribute17:=
492: per_bpr_shd.g_old_rec.bpr_attribute17;

Line 492: per_bpr_shd.g_old_rec.bpr_attribute17;

488: per_bpr_shd.g_old_rec.bpr_attribute16;
489: End If;
490: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
491: p_rec.bpr_attribute17:=
492: per_bpr_shd.g_old_rec.bpr_attribute17;
493: End If;
494: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
495: p_rec.bpr_attribute18:=
496: per_bpr_shd.g_old_rec.bpr_attribute18;

Line 496: per_bpr_shd.g_old_rec.bpr_attribute18;

492: per_bpr_shd.g_old_rec.bpr_attribute17;
493: End If;
494: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
495: p_rec.bpr_attribute18:=
496: per_bpr_shd.g_old_rec.bpr_attribute18;
497: End If;
498: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
499: p_rec.bpr_attribute19:=
500: per_bpr_shd.g_old_rec.bpr_attribute19;

Line 500: per_bpr_shd.g_old_rec.bpr_attribute19;

496: per_bpr_shd.g_old_rec.bpr_attribute18;
497: End If;
498: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
499: p_rec.bpr_attribute19:=
500: per_bpr_shd.g_old_rec.bpr_attribute19;
501: End If;
502: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
503: p_rec.bpr_attribute20:=
504: per_bpr_shd.g_old_rec.bpr_attribute20;

Line 504: per_bpr_shd.g_old_rec.bpr_attribute20;

500: per_bpr_shd.g_old_rec.bpr_attribute19;
501: End If;
502: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
503: p_rec.bpr_attribute20:=
504: per_bpr_shd.g_old_rec.bpr_attribute20;
505: End If;
506: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
507: p_rec.bpr_attribute21:=
508: per_bpr_shd.g_old_rec.bpr_attribute21;

Line 508: per_bpr_shd.g_old_rec.bpr_attribute21;

504: per_bpr_shd.g_old_rec.bpr_attribute20;
505: End If;
506: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
507: p_rec.bpr_attribute21:=
508: per_bpr_shd.g_old_rec.bpr_attribute21;
509: End If;
510: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
511: p_rec.bpr_attribute22:=
512: per_bpr_shd.g_old_rec.bpr_attribute22;

Line 512: per_bpr_shd.g_old_rec.bpr_attribute22;

508: per_bpr_shd.g_old_rec.bpr_attribute21;
509: End If;
510: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
511: p_rec.bpr_attribute22:=
512: per_bpr_shd.g_old_rec.bpr_attribute22;
513: End If;
514: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
515: p_rec.bpr_attribute23:=
516: per_bpr_shd.g_old_rec.bpr_attribute23;

Line 516: per_bpr_shd.g_old_rec.bpr_attribute23;

512: per_bpr_shd.g_old_rec.bpr_attribute22;
513: End If;
514: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
515: p_rec.bpr_attribute23:=
516: per_bpr_shd.g_old_rec.bpr_attribute23;
517: End If;
518: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
519: p_rec.bpr_attribute24:=
520: per_bpr_shd.g_old_rec.bpr_attribute24;

Line 520: per_bpr_shd.g_old_rec.bpr_attribute24;

516: per_bpr_shd.g_old_rec.bpr_attribute23;
517: End If;
518: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
519: p_rec.bpr_attribute24:=
520: per_bpr_shd.g_old_rec.bpr_attribute24;
521: End If;
522: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
523: p_rec.bpr_attribute25:=
524: per_bpr_shd.g_old_rec.bpr_attribute25;

Line 524: per_bpr_shd.g_old_rec.bpr_attribute25;

520: per_bpr_shd.g_old_rec.bpr_attribute24;
521: End If;
522: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
523: p_rec.bpr_attribute25:=
524: per_bpr_shd.g_old_rec.bpr_attribute25;
525: End If;
526: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
527: p_rec.bpr_attribute26:=
528: per_bpr_shd.g_old_rec.bpr_attribute26;

Line 528: per_bpr_shd.g_old_rec.bpr_attribute26;

524: per_bpr_shd.g_old_rec.bpr_attribute25;
525: End If;
526: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
527: p_rec.bpr_attribute26:=
528: per_bpr_shd.g_old_rec.bpr_attribute26;
529: End If;
530: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
531: p_rec.bpr_attribute27:=
532: per_bpr_shd.g_old_rec.bpr_attribute27;

Line 532: per_bpr_shd.g_old_rec.bpr_attribute27;

528: per_bpr_shd.g_old_rec.bpr_attribute26;
529: End If;
530: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
531: p_rec.bpr_attribute27:=
532: per_bpr_shd.g_old_rec.bpr_attribute27;
533: End If;
534: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
535: p_rec.bpr_attribute28:=
536: per_bpr_shd.g_old_rec.bpr_attribute28;

Line 536: per_bpr_shd.g_old_rec.bpr_attribute28;

532: per_bpr_shd.g_old_rec.bpr_attribute27;
533: End If;
534: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
535: p_rec.bpr_attribute28:=
536: per_bpr_shd.g_old_rec.bpr_attribute28;
537: End If;
538: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
539: p_rec.bpr_attribute29:=
540: per_bpr_shd.g_old_rec.bpr_attribute29;

Line 540: per_bpr_shd.g_old_rec.bpr_attribute29;

536: per_bpr_shd.g_old_rec.bpr_attribute28;
537: End If;
538: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
539: p_rec.bpr_attribute29:=
540: per_bpr_shd.g_old_rec.bpr_attribute29;
541: End If;
542: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
543: p_rec.bpr_attribute30:=
544: per_bpr_shd.g_old_rec.bpr_attribute30;

Line 544: per_bpr_shd.g_old_rec.bpr_attribute30;

540: per_bpr_shd.g_old_rec.bpr_attribute29;
541: End If;
542: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
543: p_rec.bpr_attribute30:=
544: per_bpr_shd.g_old_rec.bpr_attribute30;
545: End If;
546:
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 558: p_rec in out nocopy per_bpr_shd.g_rec_type

554: -- ----------------------------------------------------------------------------
555: Procedure upd
556: (
557: p_effective_date in date,
558: p_rec in out nocopy per_bpr_shd.g_rec_type
559: ) is
560: --
561: l_proc varchar2(72) := g_package||'upd';
562: --

Line 568: per_bpr_shd.lck

564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- We must lock the row which we need to update.
567: --
568: per_bpr_shd.lck
569: (
570: p_rec.payroll_run_id,
571: p_rec.object_version_number
572: );

Line 644: l_rec per_bpr_shd.g_rec_type;

640: p_bpr_attribute29 in varchar2 default hr_api.g_varchar2,
641: p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
642: ) is
643: --
644: l_rec per_bpr_shd.g_rec_type;
645: l_proc varchar2(72) := g_package||'upd';
646: --
647: Begin
648: hr_utility.set_location('Entering:'||l_proc, 5);

Line 654: per_bpr_shd.convert_args

650: -- Call conversion function to turn arguments into the
651: -- l_rec structure.
652: --
653: l_rec :=
654: per_bpr_shd.convert_args
655: (
656: p_payroll_run_id,
657: hr_api.g_number,
658: hr_api.g_number,