DBA Data[Home] [Help]

APPS.PER_BPD_UPD dependencies on PER_BPD_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_bpd_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_bpd_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 114: per_bpd_shd.constraint_error

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

Line 118: per_bpd_shd.constraint_error

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

Line 122: per_bpd_shd.constraint_error

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

Line 160: Procedure pre_update(p_rec in per_bpd_shd.g_rec_type) is

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

Line 203: p_rec in per_bpd_shd.g_rec_type) is

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

Line 252: => per_bpd_shd.g_old_rec.processed_assignment_id,

248: p_bpd_attribute29 => p_rec.bpd_attribute29,
249: p_bpd_attribute30 => p_rec.bpd_attribute30,
250:
251: p_processed_assignment_id_o
252: => per_bpd_shd.g_old_rec.processed_assignment_id,
253: p_personal_payment_method_id_o
254: => per_bpd_shd.g_old_rec.personal_payment_method_id,
255: p_business_group_id_o
256: => per_bpd_shd.g_old_rec.business_group_id,

Line 254: => per_bpd_shd.g_old_rec.personal_payment_method_id,

250:
251: p_processed_assignment_id_o
252: => per_bpd_shd.g_old_rec.processed_assignment_id,
253: p_personal_payment_method_id_o
254: => per_bpd_shd.g_old_rec.personal_payment_method_id,
255: p_business_group_id_o
256: => per_bpd_shd.g_old_rec.business_group_id,
257: p_check_number_o
258: => per_bpd_shd.g_old_rec.check_number,

Line 256: => per_bpd_shd.g_old_rec.business_group_id,

252: => per_bpd_shd.g_old_rec.processed_assignment_id,
253: p_personal_payment_method_id_o
254: => per_bpd_shd.g_old_rec.personal_payment_method_id,
255: p_business_group_id_o
256: => per_bpd_shd.g_old_rec.business_group_id,
257: p_check_number_o
258: => per_bpd_shd.g_old_rec.check_number,
259: p_payment_date_o
260: => per_bpd_shd.g_old_rec.payment_date,

Line 258: => per_bpd_shd.g_old_rec.check_number,

254: => per_bpd_shd.g_old_rec.personal_payment_method_id,
255: p_business_group_id_o
256: => per_bpd_shd.g_old_rec.business_group_id,
257: p_check_number_o
258: => per_bpd_shd.g_old_rec.check_number,
259: p_payment_date_o
260: => per_bpd_shd.g_old_rec.payment_date,
261: p_amount_o
262: => per_bpd_shd.g_old_rec.amount,

Line 260: => per_bpd_shd.g_old_rec.payment_date,

256: => per_bpd_shd.g_old_rec.business_group_id,
257: p_check_number_o
258: => per_bpd_shd.g_old_rec.check_number,
259: p_payment_date_o
260: => per_bpd_shd.g_old_rec.payment_date,
261: p_amount_o
262: => per_bpd_shd.g_old_rec.amount,
263: p_check_type_o
264: => per_bpd_shd.g_old_rec.check_type,

Line 262: => per_bpd_shd.g_old_rec.amount,

258: => per_bpd_shd.g_old_rec.check_number,
259: p_payment_date_o
260: => per_bpd_shd.g_old_rec.payment_date,
261: p_amount_o
262: => per_bpd_shd.g_old_rec.amount,
263: p_check_type_o
264: => per_bpd_shd.g_old_rec.check_type,
265: p_object_version_number_o
266: => per_bpd_shd.g_old_rec.object_version_number,

Line 264: => per_bpd_shd.g_old_rec.check_type,

260: => per_bpd_shd.g_old_rec.payment_date,
261: p_amount_o
262: => per_bpd_shd.g_old_rec.amount,
263: p_check_type_o
264: => per_bpd_shd.g_old_rec.check_type,
265: p_object_version_number_o
266: => per_bpd_shd.g_old_rec.object_version_number,
267: p_bpd_attribute_category_o
268: => per_bpd_shd.g_old_rec.bpd_attribute_category,

Line 266: => per_bpd_shd.g_old_rec.object_version_number,

262: => per_bpd_shd.g_old_rec.amount,
263: p_check_type_o
264: => per_bpd_shd.g_old_rec.check_type,
265: p_object_version_number_o
266: => per_bpd_shd.g_old_rec.object_version_number,
267: p_bpd_attribute_category_o
268: => per_bpd_shd.g_old_rec.bpd_attribute_category,
269: p_bpd_attribute1_o
270: => per_bpd_shd.g_old_rec.bpd_attribute1,

Line 268: => per_bpd_shd.g_old_rec.bpd_attribute_category,

264: => per_bpd_shd.g_old_rec.check_type,
265: p_object_version_number_o
266: => per_bpd_shd.g_old_rec.object_version_number,
267: p_bpd_attribute_category_o
268: => per_bpd_shd.g_old_rec.bpd_attribute_category,
269: p_bpd_attribute1_o
270: => per_bpd_shd.g_old_rec.bpd_attribute1,
271: p_bpd_attribute2_o
272: => per_bpd_shd.g_old_rec.bpd_attribute2,

Line 270: => per_bpd_shd.g_old_rec.bpd_attribute1,

266: => per_bpd_shd.g_old_rec.object_version_number,
267: p_bpd_attribute_category_o
268: => per_bpd_shd.g_old_rec.bpd_attribute_category,
269: p_bpd_attribute1_o
270: => per_bpd_shd.g_old_rec.bpd_attribute1,
271: p_bpd_attribute2_o
272: => per_bpd_shd.g_old_rec.bpd_attribute2,
273: p_bpd_attribute3_o
274: => per_bpd_shd.g_old_rec.bpd_attribute3,

Line 272: => per_bpd_shd.g_old_rec.bpd_attribute2,

268: => per_bpd_shd.g_old_rec.bpd_attribute_category,
269: p_bpd_attribute1_o
270: => per_bpd_shd.g_old_rec.bpd_attribute1,
271: p_bpd_attribute2_o
272: => per_bpd_shd.g_old_rec.bpd_attribute2,
273: p_bpd_attribute3_o
274: => per_bpd_shd.g_old_rec.bpd_attribute3,
275: p_bpd_attribute4_o
276: => per_bpd_shd.g_old_rec.bpd_attribute4,

Line 274: => per_bpd_shd.g_old_rec.bpd_attribute3,

270: => per_bpd_shd.g_old_rec.bpd_attribute1,
271: p_bpd_attribute2_o
272: => per_bpd_shd.g_old_rec.bpd_attribute2,
273: p_bpd_attribute3_o
274: => per_bpd_shd.g_old_rec.bpd_attribute3,
275: p_bpd_attribute4_o
276: => per_bpd_shd.g_old_rec.bpd_attribute4,
277: p_bpd_attribute5_o
278: => per_bpd_shd.g_old_rec.bpd_attribute5,

Line 276: => per_bpd_shd.g_old_rec.bpd_attribute4,

272: => per_bpd_shd.g_old_rec.bpd_attribute2,
273: p_bpd_attribute3_o
274: => per_bpd_shd.g_old_rec.bpd_attribute3,
275: p_bpd_attribute4_o
276: => per_bpd_shd.g_old_rec.bpd_attribute4,
277: p_bpd_attribute5_o
278: => per_bpd_shd.g_old_rec.bpd_attribute5,
279: p_bpd_attribute6_o
280: => per_bpd_shd.g_old_rec.bpd_attribute6,

Line 278: => per_bpd_shd.g_old_rec.bpd_attribute5,

274: => per_bpd_shd.g_old_rec.bpd_attribute3,
275: p_bpd_attribute4_o
276: => per_bpd_shd.g_old_rec.bpd_attribute4,
277: p_bpd_attribute5_o
278: => per_bpd_shd.g_old_rec.bpd_attribute5,
279: p_bpd_attribute6_o
280: => per_bpd_shd.g_old_rec.bpd_attribute6,
281: p_bpd_attribute7_o
282: => per_bpd_shd.g_old_rec.bpd_attribute7,

Line 280: => per_bpd_shd.g_old_rec.bpd_attribute6,

276: => per_bpd_shd.g_old_rec.bpd_attribute4,
277: p_bpd_attribute5_o
278: => per_bpd_shd.g_old_rec.bpd_attribute5,
279: p_bpd_attribute6_o
280: => per_bpd_shd.g_old_rec.bpd_attribute6,
281: p_bpd_attribute7_o
282: => per_bpd_shd.g_old_rec.bpd_attribute7,
283: p_bpd_attribute8_o
284: => per_bpd_shd.g_old_rec.bpd_attribute8,

Line 282: => per_bpd_shd.g_old_rec.bpd_attribute7,

278: => per_bpd_shd.g_old_rec.bpd_attribute5,
279: p_bpd_attribute6_o
280: => per_bpd_shd.g_old_rec.bpd_attribute6,
281: p_bpd_attribute7_o
282: => per_bpd_shd.g_old_rec.bpd_attribute7,
283: p_bpd_attribute8_o
284: => per_bpd_shd.g_old_rec.bpd_attribute8,
285: p_bpd_attribute9_o
286: => per_bpd_shd.g_old_rec.bpd_attribute9,

Line 284: => per_bpd_shd.g_old_rec.bpd_attribute8,

280: => per_bpd_shd.g_old_rec.bpd_attribute6,
281: p_bpd_attribute7_o
282: => per_bpd_shd.g_old_rec.bpd_attribute7,
283: p_bpd_attribute8_o
284: => per_bpd_shd.g_old_rec.bpd_attribute8,
285: p_bpd_attribute9_o
286: => per_bpd_shd.g_old_rec.bpd_attribute9,
287: p_bpd_attribute10_o
288: => per_bpd_shd.g_old_rec.bpd_attribute10,

Line 286: => per_bpd_shd.g_old_rec.bpd_attribute9,

282: => per_bpd_shd.g_old_rec.bpd_attribute7,
283: p_bpd_attribute8_o
284: => per_bpd_shd.g_old_rec.bpd_attribute8,
285: p_bpd_attribute9_o
286: => per_bpd_shd.g_old_rec.bpd_attribute9,
287: p_bpd_attribute10_o
288: => per_bpd_shd.g_old_rec.bpd_attribute10,
289: p_bpd_attribute11_o
290: => per_bpd_shd.g_old_rec.bpd_attribute11,

Line 288: => per_bpd_shd.g_old_rec.bpd_attribute10,

284: => per_bpd_shd.g_old_rec.bpd_attribute8,
285: p_bpd_attribute9_o
286: => per_bpd_shd.g_old_rec.bpd_attribute9,
287: p_bpd_attribute10_o
288: => per_bpd_shd.g_old_rec.bpd_attribute10,
289: p_bpd_attribute11_o
290: => per_bpd_shd.g_old_rec.bpd_attribute11,
291: p_bpd_attribute12_o
292: => per_bpd_shd.g_old_rec.bpd_attribute12,

Line 290: => per_bpd_shd.g_old_rec.bpd_attribute11,

286: => per_bpd_shd.g_old_rec.bpd_attribute9,
287: p_bpd_attribute10_o
288: => per_bpd_shd.g_old_rec.bpd_attribute10,
289: p_bpd_attribute11_o
290: => per_bpd_shd.g_old_rec.bpd_attribute11,
291: p_bpd_attribute12_o
292: => per_bpd_shd.g_old_rec.bpd_attribute12,
293: p_bpd_attribute13_o
294: => per_bpd_shd.g_old_rec.bpd_attribute13,

Line 292: => per_bpd_shd.g_old_rec.bpd_attribute12,

288: => per_bpd_shd.g_old_rec.bpd_attribute10,
289: p_bpd_attribute11_o
290: => per_bpd_shd.g_old_rec.bpd_attribute11,
291: p_bpd_attribute12_o
292: => per_bpd_shd.g_old_rec.bpd_attribute12,
293: p_bpd_attribute13_o
294: => per_bpd_shd.g_old_rec.bpd_attribute13,
295: p_bpd_attribute14_o
296: => per_bpd_shd.g_old_rec.bpd_attribute14,

Line 294: => per_bpd_shd.g_old_rec.bpd_attribute13,

290: => per_bpd_shd.g_old_rec.bpd_attribute11,
291: p_bpd_attribute12_o
292: => per_bpd_shd.g_old_rec.bpd_attribute12,
293: p_bpd_attribute13_o
294: => per_bpd_shd.g_old_rec.bpd_attribute13,
295: p_bpd_attribute14_o
296: => per_bpd_shd.g_old_rec.bpd_attribute14,
297: p_bpd_attribute15_o
298: => per_bpd_shd.g_old_rec.bpd_attribute15,

Line 296: => per_bpd_shd.g_old_rec.bpd_attribute14,

292: => per_bpd_shd.g_old_rec.bpd_attribute12,
293: p_bpd_attribute13_o
294: => per_bpd_shd.g_old_rec.bpd_attribute13,
295: p_bpd_attribute14_o
296: => per_bpd_shd.g_old_rec.bpd_attribute14,
297: p_bpd_attribute15_o
298: => per_bpd_shd.g_old_rec.bpd_attribute15,
299: p_bpd_attribute16_o
300: => per_bpd_shd.g_old_rec.bpd_attribute16,

Line 298: => per_bpd_shd.g_old_rec.bpd_attribute15,

294: => per_bpd_shd.g_old_rec.bpd_attribute13,
295: p_bpd_attribute14_o
296: => per_bpd_shd.g_old_rec.bpd_attribute14,
297: p_bpd_attribute15_o
298: => per_bpd_shd.g_old_rec.bpd_attribute15,
299: p_bpd_attribute16_o
300: => per_bpd_shd.g_old_rec.bpd_attribute16,
301: p_bpd_attribute17_o
302: => per_bpd_shd.g_old_rec.bpd_attribute17,

Line 300: => per_bpd_shd.g_old_rec.bpd_attribute16,

296: => per_bpd_shd.g_old_rec.bpd_attribute14,
297: p_bpd_attribute15_o
298: => per_bpd_shd.g_old_rec.bpd_attribute15,
299: p_bpd_attribute16_o
300: => per_bpd_shd.g_old_rec.bpd_attribute16,
301: p_bpd_attribute17_o
302: => per_bpd_shd.g_old_rec.bpd_attribute17,
303: p_bpd_attribute18_o
304: => per_bpd_shd.g_old_rec.bpd_attribute18,

Line 302: => per_bpd_shd.g_old_rec.bpd_attribute17,

298: => per_bpd_shd.g_old_rec.bpd_attribute15,
299: p_bpd_attribute16_o
300: => per_bpd_shd.g_old_rec.bpd_attribute16,
301: p_bpd_attribute17_o
302: => per_bpd_shd.g_old_rec.bpd_attribute17,
303: p_bpd_attribute18_o
304: => per_bpd_shd.g_old_rec.bpd_attribute18,
305: p_bpd_attribute19_o
306: => per_bpd_shd.g_old_rec.bpd_attribute19,

Line 304: => per_bpd_shd.g_old_rec.bpd_attribute18,

300: => per_bpd_shd.g_old_rec.bpd_attribute16,
301: p_bpd_attribute17_o
302: => per_bpd_shd.g_old_rec.bpd_attribute17,
303: p_bpd_attribute18_o
304: => per_bpd_shd.g_old_rec.bpd_attribute18,
305: p_bpd_attribute19_o
306: => per_bpd_shd.g_old_rec.bpd_attribute19,
307: p_bpd_attribute20_o
308: => per_bpd_shd.g_old_rec.bpd_attribute20,

Line 306: => per_bpd_shd.g_old_rec.bpd_attribute19,

302: => per_bpd_shd.g_old_rec.bpd_attribute17,
303: p_bpd_attribute18_o
304: => per_bpd_shd.g_old_rec.bpd_attribute18,
305: p_bpd_attribute19_o
306: => per_bpd_shd.g_old_rec.bpd_attribute19,
307: p_bpd_attribute20_o
308: => per_bpd_shd.g_old_rec.bpd_attribute20,
309: p_bpd_attribute21_o
310: => per_bpd_shd.g_old_rec.bpd_attribute21,

Line 308: => per_bpd_shd.g_old_rec.bpd_attribute20,

304: => per_bpd_shd.g_old_rec.bpd_attribute18,
305: p_bpd_attribute19_o
306: => per_bpd_shd.g_old_rec.bpd_attribute19,
307: p_bpd_attribute20_o
308: => per_bpd_shd.g_old_rec.bpd_attribute20,
309: p_bpd_attribute21_o
310: => per_bpd_shd.g_old_rec.bpd_attribute21,
311: p_bpd_attribute22_o
312: => per_bpd_shd.g_old_rec.bpd_attribute22,

Line 310: => per_bpd_shd.g_old_rec.bpd_attribute21,

306: => per_bpd_shd.g_old_rec.bpd_attribute19,
307: p_bpd_attribute20_o
308: => per_bpd_shd.g_old_rec.bpd_attribute20,
309: p_bpd_attribute21_o
310: => per_bpd_shd.g_old_rec.bpd_attribute21,
311: p_bpd_attribute22_o
312: => per_bpd_shd.g_old_rec.bpd_attribute22,
313: p_bpd_attribute23_o
314: => per_bpd_shd.g_old_rec.bpd_attribute23,

Line 312: => per_bpd_shd.g_old_rec.bpd_attribute22,

308: => per_bpd_shd.g_old_rec.bpd_attribute20,
309: p_bpd_attribute21_o
310: => per_bpd_shd.g_old_rec.bpd_attribute21,
311: p_bpd_attribute22_o
312: => per_bpd_shd.g_old_rec.bpd_attribute22,
313: p_bpd_attribute23_o
314: => per_bpd_shd.g_old_rec.bpd_attribute23,
315: p_bpd_attribute24_o
316: => per_bpd_shd.g_old_rec.bpd_attribute24,

Line 314: => per_bpd_shd.g_old_rec.bpd_attribute23,

310: => per_bpd_shd.g_old_rec.bpd_attribute21,
311: p_bpd_attribute22_o
312: => per_bpd_shd.g_old_rec.bpd_attribute22,
313: p_bpd_attribute23_o
314: => per_bpd_shd.g_old_rec.bpd_attribute23,
315: p_bpd_attribute24_o
316: => per_bpd_shd.g_old_rec.bpd_attribute24,
317: p_bpd_attribute25_o
318: => per_bpd_shd.g_old_rec.bpd_attribute25,

Line 316: => per_bpd_shd.g_old_rec.bpd_attribute24,

312: => per_bpd_shd.g_old_rec.bpd_attribute22,
313: p_bpd_attribute23_o
314: => per_bpd_shd.g_old_rec.bpd_attribute23,
315: p_bpd_attribute24_o
316: => per_bpd_shd.g_old_rec.bpd_attribute24,
317: p_bpd_attribute25_o
318: => per_bpd_shd.g_old_rec.bpd_attribute25,
319: p_bpd_attribute26_o
320: => per_bpd_shd.g_old_rec.bpd_attribute26,

Line 318: => per_bpd_shd.g_old_rec.bpd_attribute25,

314: => per_bpd_shd.g_old_rec.bpd_attribute23,
315: p_bpd_attribute24_o
316: => per_bpd_shd.g_old_rec.bpd_attribute24,
317: p_bpd_attribute25_o
318: => per_bpd_shd.g_old_rec.bpd_attribute25,
319: p_bpd_attribute26_o
320: => per_bpd_shd.g_old_rec.bpd_attribute26,
321: p_bpd_attribute27_o
322: => per_bpd_shd.g_old_rec.bpd_attribute27,

Line 320: => per_bpd_shd.g_old_rec.bpd_attribute26,

316: => per_bpd_shd.g_old_rec.bpd_attribute24,
317: p_bpd_attribute25_o
318: => per_bpd_shd.g_old_rec.bpd_attribute25,
319: p_bpd_attribute26_o
320: => per_bpd_shd.g_old_rec.bpd_attribute26,
321: p_bpd_attribute27_o
322: => per_bpd_shd.g_old_rec.bpd_attribute27,
323: p_bpd_attribute28_o
324: => per_bpd_shd.g_old_rec.bpd_attribute28,

Line 322: => per_bpd_shd.g_old_rec.bpd_attribute27,

318: => per_bpd_shd.g_old_rec.bpd_attribute25,
319: p_bpd_attribute26_o
320: => per_bpd_shd.g_old_rec.bpd_attribute26,
321: p_bpd_attribute27_o
322: => per_bpd_shd.g_old_rec.bpd_attribute27,
323: p_bpd_attribute28_o
324: => per_bpd_shd.g_old_rec.bpd_attribute28,
325: p_bpd_attribute29_o
326: => per_bpd_shd.g_old_rec.bpd_attribute29,

Line 324: => per_bpd_shd.g_old_rec.bpd_attribute28,

320: => per_bpd_shd.g_old_rec.bpd_attribute26,
321: p_bpd_attribute27_o
322: => per_bpd_shd.g_old_rec.bpd_attribute27,
323: p_bpd_attribute28_o
324: => per_bpd_shd.g_old_rec.bpd_attribute28,
325: p_bpd_attribute29_o
326: => per_bpd_shd.g_old_rec.bpd_attribute29,
327: p_bpd_attribute30_o
328: => per_bpd_shd.g_old_rec.bpd_attribute30

Line 326: => per_bpd_shd.g_old_rec.bpd_attribute29,

322: => per_bpd_shd.g_old_rec.bpd_attribute27,
323: p_bpd_attribute28_o
324: => per_bpd_shd.g_old_rec.bpd_attribute28,
325: p_bpd_attribute29_o
326: => per_bpd_shd.g_old_rec.bpd_attribute29,
327: p_bpd_attribute30_o
328: => per_bpd_shd.g_old_rec.bpd_attribute30
329: );
330: --

Line 328: => per_bpd_shd.g_old_rec.bpd_attribute30

324: => per_bpd_shd.g_old_rec.bpd_attribute28,
325: p_bpd_attribute29_o
326: => per_bpd_shd.g_old_rec.bpd_attribute29,
327: p_bpd_attribute30_o
328: => per_bpd_shd.g_old_rec.bpd_attribute30
329: );
330: --
331: exception
332: --

Line 387: Procedure convert_defs(p_rec in out nocopy per_bpd_shd.g_rec_type) is

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

Line 402: per_bpd_shd.g_old_rec.processed_assignment_id;

398: -- is being used then we must set to the 'current' argument value.
399: --
400: If (p_rec.processed_assignment_id = hr_api.g_number) then
401: p_rec.processed_assignment_id :=
402: per_bpd_shd.g_old_rec.processed_assignment_id;
403: End If;
404: If (p_rec.personal_payment_method_id = hr_api.g_number) then
405: p_rec.personal_payment_method_id :=
406: per_bpd_shd.g_old_rec.personal_payment_method_id;

Line 406: per_bpd_shd.g_old_rec.personal_payment_method_id;

402: per_bpd_shd.g_old_rec.processed_assignment_id;
403: End If;
404: If (p_rec.personal_payment_method_id = hr_api.g_number) then
405: p_rec.personal_payment_method_id :=
406: per_bpd_shd.g_old_rec.personal_payment_method_id;
407: End If;
408: If (p_rec.business_group_id = hr_api.g_number) then
409: p_rec.business_group_id :=
410: per_bpd_shd.g_old_rec.business_group_id;

Line 410: per_bpd_shd.g_old_rec.business_group_id;

406: per_bpd_shd.g_old_rec.personal_payment_method_id;
407: End If;
408: If (p_rec.business_group_id = hr_api.g_number) then
409: p_rec.business_group_id :=
410: per_bpd_shd.g_old_rec.business_group_id;
411: End If;
412: If (p_rec.check_number = hr_api.g_number) then
413: p_rec.check_number :=
414: per_bpd_shd.g_old_rec.check_number;

Line 414: per_bpd_shd.g_old_rec.check_number;

410: per_bpd_shd.g_old_rec.business_group_id;
411: End If;
412: If (p_rec.check_number = hr_api.g_number) then
413: p_rec.check_number :=
414: per_bpd_shd.g_old_rec.check_number;
415: End If;
416: If (p_rec.payment_date = hr_api.g_date) then
417: p_rec.payment_date :=
418: per_bpd_shd.g_old_rec.payment_date;

Line 418: per_bpd_shd.g_old_rec.payment_date;

414: per_bpd_shd.g_old_rec.check_number;
415: End If;
416: If (p_rec.payment_date = hr_api.g_date) then
417: p_rec.payment_date :=
418: per_bpd_shd.g_old_rec.payment_date;
419: End If;
420: If (p_rec.amount = hr_api.g_number) then
421: p_rec.amount :=
422: per_bpd_shd.g_old_rec.amount;

Line 422: per_bpd_shd.g_old_rec.amount;

418: per_bpd_shd.g_old_rec.payment_date;
419: End If;
420: If (p_rec.amount = hr_api.g_number) then
421: p_rec.amount :=
422: per_bpd_shd.g_old_rec.amount;
423: End If;
424: If (p_rec.check_type = hr_api.g_varchar2) then
425: p_rec.check_type :=
426: per_bpd_shd.g_old_rec.check_type;

Line 426: per_bpd_shd.g_old_rec.check_type;

422: per_bpd_shd.g_old_rec.amount;
423: End If;
424: If (p_rec.check_type = hr_api.g_varchar2) then
425: p_rec.check_type :=
426: per_bpd_shd.g_old_rec.check_type;
427: End If;
428: If (p_rec.bpd_attribute_category = hr_api.g_varchar2) then
429: p_rec.bpd_attribute_category :=
430: per_bpd_shd.g_old_rec.bpd_attribute_category;

Line 430: per_bpd_shd.g_old_rec.bpd_attribute_category;

426: per_bpd_shd.g_old_rec.check_type;
427: End If;
428: If (p_rec.bpd_attribute_category = hr_api.g_varchar2) then
429: p_rec.bpd_attribute_category :=
430: per_bpd_shd.g_old_rec.bpd_attribute_category;
431: End If;
432: If (p_rec.bpd_attribute1 = hr_api.g_varchar2) then
433: p_rec.bpd_attribute1:=
434: per_bpd_shd.g_old_rec.bpd_attribute1;

Line 434: per_bpd_shd.g_old_rec.bpd_attribute1;

430: per_bpd_shd.g_old_rec.bpd_attribute_category;
431: End If;
432: If (p_rec.bpd_attribute1 = hr_api.g_varchar2) then
433: p_rec.bpd_attribute1:=
434: per_bpd_shd.g_old_rec.bpd_attribute1;
435: End If;
436: If (p_rec.bpd_attribute2 = hr_api.g_varchar2) then
437: p_rec.bpd_attribute2:=
438: per_bpd_shd.g_old_rec.bpd_attribute2;

Line 438: per_bpd_shd.g_old_rec.bpd_attribute2;

434: per_bpd_shd.g_old_rec.bpd_attribute1;
435: End If;
436: If (p_rec.bpd_attribute2 = hr_api.g_varchar2) then
437: p_rec.bpd_attribute2:=
438: per_bpd_shd.g_old_rec.bpd_attribute2;
439: End If;
440: If (p_rec.bpd_attribute3 = hr_api.g_varchar2) then
441: p_rec.bpd_attribute3:=
442: per_bpd_shd.g_old_rec.bpd_attribute3;

Line 442: per_bpd_shd.g_old_rec.bpd_attribute3;

438: per_bpd_shd.g_old_rec.bpd_attribute2;
439: End If;
440: If (p_rec.bpd_attribute3 = hr_api.g_varchar2) then
441: p_rec.bpd_attribute3:=
442: per_bpd_shd.g_old_rec.bpd_attribute3;
443: End If;
444: If (p_rec.bpd_attribute4 = hr_api.g_varchar2) then
445: p_rec.bpd_attribute4:=
446: per_bpd_shd.g_old_rec.bpd_attribute4;

Line 446: per_bpd_shd.g_old_rec.bpd_attribute4;

442: per_bpd_shd.g_old_rec.bpd_attribute3;
443: End If;
444: If (p_rec.bpd_attribute4 = hr_api.g_varchar2) then
445: p_rec.bpd_attribute4:=
446: per_bpd_shd.g_old_rec.bpd_attribute4;
447: End If;
448: If (p_rec.bpd_attribute5 = hr_api.g_varchar2) then
449: p_rec.bpd_attribute5:=
450: per_bpd_shd.g_old_rec.bpd_attribute5;

Line 450: per_bpd_shd.g_old_rec.bpd_attribute5;

446: per_bpd_shd.g_old_rec.bpd_attribute4;
447: End If;
448: If (p_rec.bpd_attribute5 = hr_api.g_varchar2) then
449: p_rec.bpd_attribute5:=
450: per_bpd_shd.g_old_rec.bpd_attribute5;
451: End If;
452: If (p_rec.bpd_attribute6 = hr_api.g_varchar2) then
453: p_rec.bpd_attribute6:=
454: per_bpd_shd.g_old_rec.bpd_attribute6;

Line 454: per_bpd_shd.g_old_rec.bpd_attribute6;

450: per_bpd_shd.g_old_rec.bpd_attribute5;
451: End If;
452: If (p_rec.bpd_attribute6 = hr_api.g_varchar2) then
453: p_rec.bpd_attribute6:=
454: per_bpd_shd.g_old_rec.bpd_attribute6;
455: End If;
456: If (p_rec.bpd_attribute7 = hr_api.g_varchar2) then
457: p_rec.bpd_attribute7:=
458: per_bpd_shd.g_old_rec.bpd_attribute7;

Line 458: per_bpd_shd.g_old_rec.bpd_attribute7;

454: per_bpd_shd.g_old_rec.bpd_attribute6;
455: End If;
456: If (p_rec.bpd_attribute7 = hr_api.g_varchar2) then
457: p_rec.bpd_attribute7:=
458: per_bpd_shd.g_old_rec.bpd_attribute7;
459: End If;
460: If (p_rec.bpd_attribute8 = hr_api.g_varchar2) then
461: p_rec.bpd_attribute8:=
462: per_bpd_shd.g_old_rec.bpd_attribute8;

Line 462: per_bpd_shd.g_old_rec.bpd_attribute8;

458: per_bpd_shd.g_old_rec.bpd_attribute7;
459: End If;
460: If (p_rec.bpd_attribute8 = hr_api.g_varchar2) then
461: p_rec.bpd_attribute8:=
462: per_bpd_shd.g_old_rec.bpd_attribute8;
463: End If;
464: If (p_rec.bpd_attribute9 = hr_api.g_varchar2) then
465: p_rec.bpd_attribute9:=
466: per_bpd_shd.g_old_rec.bpd_attribute9;

Line 466: per_bpd_shd.g_old_rec.bpd_attribute9;

462: per_bpd_shd.g_old_rec.bpd_attribute8;
463: End If;
464: If (p_rec.bpd_attribute9 = hr_api.g_varchar2) then
465: p_rec.bpd_attribute9:=
466: per_bpd_shd.g_old_rec.bpd_attribute9;
467: End If;
468: If (p_rec.bpd_attribute10 = hr_api.g_varchar2) then
469: p_rec.bpd_attribute10:=
470: per_bpd_shd.g_old_rec.bpd_attribute10;

Line 470: per_bpd_shd.g_old_rec.bpd_attribute10;

466: per_bpd_shd.g_old_rec.bpd_attribute9;
467: End If;
468: If (p_rec.bpd_attribute10 = hr_api.g_varchar2) then
469: p_rec.bpd_attribute10:=
470: per_bpd_shd.g_old_rec.bpd_attribute10;
471: End If;
472: If (p_rec.bpd_attribute11 = hr_api.g_varchar2) then
473: p_rec.bpd_attribute11:=
474: per_bpd_shd.g_old_rec.bpd_attribute11;

Line 474: per_bpd_shd.g_old_rec.bpd_attribute11;

470: per_bpd_shd.g_old_rec.bpd_attribute10;
471: End If;
472: If (p_rec.bpd_attribute11 = hr_api.g_varchar2) then
473: p_rec.bpd_attribute11:=
474: per_bpd_shd.g_old_rec.bpd_attribute11;
475: End If;
476: If (p_rec.bpd_attribute12 = hr_api.g_varchar2) then
477: p_rec.bpd_attribute12:=
478: per_bpd_shd.g_old_rec.bpd_attribute12;

Line 478: per_bpd_shd.g_old_rec.bpd_attribute12;

474: per_bpd_shd.g_old_rec.bpd_attribute11;
475: End If;
476: If (p_rec.bpd_attribute12 = hr_api.g_varchar2) then
477: p_rec.bpd_attribute12:=
478: per_bpd_shd.g_old_rec.bpd_attribute12;
479: End If;
480: If (p_rec.bpd_attribute13 = hr_api.g_varchar2) then
481: p_rec.bpd_attribute13:=
482: per_bpd_shd.g_old_rec.bpd_attribute13;

Line 482: per_bpd_shd.g_old_rec.bpd_attribute13;

478: per_bpd_shd.g_old_rec.bpd_attribute12;
479: End If;
480: If (p_rec.bpd_attribute13 = hr_api.g_varchar2) then
481: p_rec.bpd_attribute13:=
482: per_bpd_shd.g_old_rec.bpd_attribute13;
483: End If;
484: If (p_rec.bpd_attribute14 = hr_api.g_varchar2) then
485: p_rec.bpd_attribute14:=
486: per_bpd_shd.g_old_rec.bpd_attribute14;

Line 486: per_bpd_shd.g_old_rec.bpd_attribute14;

482: per_bpd_shd.g_old_rec.bpd_attribute13;
483: End If;
484: If (p_rec.bpd_attribute14 = hr_api.g_varchar2) then
485: p_rec.bpd_attribute14:=
486: per_bpd_shd.g_old_rec.bpd_attribute14;
487: End If;
488: If (p_rec.bpd_attribute15 = hr_api.g_varchar2) then
489: p_rec.bpd_attribute15:=
490: per_bpd_shd.g_old_rec.bpd_attribute15;

Line 490: per_bpd_shd.g_old_rec.bpd_attribute15;

486: per_bpd_shd.g_old_rec.bpd_attribute14;
487: End If;
488: If (p_rec.bpd_attribute15 = hr_api.g_varchar2) then
489: p_rec.bpd_attribute15:=
490: per_bpd_shd.g_old_rec.bpd_attribute15;
491: End If;
492: If (p_rec.bpd_attribute16 = hr_api.g_varchar2) then
493: p_rec.bpd_attribute16:=
494: per_bpd_shd.g_old_rec.bpd_attribute16;

Line 494: per_bpd_shd.g_old_rec.bpd_attribute16;

490: per_bpd_shd.g_old_rec.bpd_attribute15;
491: End If;
492: If (p_rec.bpd_attribute16 = hr_api.g_varchar2) then
493: p_rec.bpd_attribute16:=
494: per_bpd_shd.g_old_rec.bpd_attribute16;
495: End If;
496: If (p_rec.bpd_attribute17 = hr_api.g_varchar2) then
497: p_rec.bpd_attribute17:=
498: per_bpd_shd.g_old_rec.bpd_attribute17;

Line 498: per_bpd_shd.g_old_rec.bpd_attribute17;

494: per_bpd_shd.g_old_rec.bpd_attribute16;
495: End If;
496: If (p_rec.bpd_attribute17 = hr_api.g_varchar2) then
497: p_rec.bpd_attribute17:=
498: per_bpd_shd.g_old_rec.bpd_attribute17;
499: End If;
500: If (p_rec.bpd_attribute18 = hr_api.g_varchar2) then
501: p_rec.bpd_attribute18:=
502: per_bpd_shd.g_old_rec.bpd_attribute18;

Line 502: per_bpd_shd.g_old_rec.bpd_attribute18;

498: per_bpd_shd.g_old_rec.bpd_attribute17;
499: End If;
500: If (p_rec.bpd_attribute18 = hr_api.g_varchar2) then
501: p_rec.bpd_attribute18:=
502: per_bpd_shd.g_old_rec.bpd_attribute18;
503: End If;
504: If (p_rec.bpd_attribute19 = hr_api.g_varchar2) then
505: p_rec.bpd_attribute19:=
506: per_bpd_shd.g_old_rec.bpd_attribute19;

Line 506: per_bpd_shd.g_old_rec.bpd_attribute19;

502: per_bpd_shd.g_old_rec.bpd_attribute18;
503: End If;
504: If (p_rec.bpd_attribute19 = hr_api.g_varchar2) then
505: p_rec.bpd_attribute19:=
506: per_bpd_shd.g_old_rec.bpd_attribute19;
507: End If;
508: If (p_rec.bpd_attribute20 = hr_api.g_varchar2) then
509: p_rec.bpd_attribute20:=
510: per_bpd_shd.g_old_rec.bpd_attribute20;

Line 510: per_bpd_shd.g_old_rec.bpd_attribute20;

506: per_bpd_shd.g_old_rec.bpd_attribute19;
507: End If;
508: If (p_rec.bpd_attribute20 = hr_api.g_varchar2) then
509: p_rec.bpd_attribute20:=
510: per_bpd_shd.g_old_rec.bpd_attribute20;
511: End If;
512: If (p_rec.bpd_attribute21 = hr_api.g_varchar2) then
513: p_rec.bpd_attribute21:=
514: per_bpd_shd.g_old_rec.bpd_attribute21;

Line 514: per_bpd_shd.g_old_rec.bpd_attribute21;

510: per_bpd_shd.g_old_rec.bpd_attribute20;
511: End If;
512: If (p_rec.bpd_attribute21 = hr_api.g_varchar2) then
513: p_rec.bpd_attribute21:=
514: per_bpd_shd.g_old_rec.bpd_attribute21;
515: End If;
516: If (p_rec.bpd_attribute22 = hr_api.g_varchar2) then
517: p_rec.bpd_attribute22:=
518: per_bpd_shd.g_old_rec.bpd_attribute22;

Line 518: per_bpd_shd.g_old_rec.bpd_attribute22;

514: per_bpd_shd.g_old_rec.bpd_attribute21;
515: End If;
516: If (p_rec.bpd_attribute22 = hr_api.g_varchar2) then
517: p_rec.bpd_attribute22:=
518: per_bpd_shd.g_old_rec.bpd_attribute22;
519: End If;
520: If (p_rec.bpd_attribute23 = hr_api.g_varchar2) then
521: p_rec.bpd_attribute23:=
522: per_bpd_shd.g_old_rec.bpd_attribute23;

Line 522: per_bpd_shd.g_old_rec.bpd_attribute23;

518: per_bpd_shd.g_old_rec.bpd_attribute22;
519: End If;
520: If (p_rec.bpd_attribute23 = hr_api.g_varchar2) then
521: p_rec.bpd_attribute23:=
522: per_bpd_shd.g_old_rec.bpd_attribute23;
523: End If;
524: If (p_rec.bpd_attribute24 = hr_api.g_varchar2) then
525: p_rec.bpd_attribute24:=
526: per_bpd_shd.g_old_rec.bpd_attribute24;

Line 526: per_bpd_shd.g_old_rec.bpd_attribute24;

522: per_bpd_shd.g_old_rec.bpd_attribute23;
523: End If;
524: If (p_rec.bpd_attribute24 = hr_api.g_varchar2) then
525: p_rec.bpd_attribute24:=
526: per_bpd_shd.g_old_rec.bpd_attribute24;
527: End If;
528: If (p_rec.bpd_attribute25 = hr_api.g_varchar2) then
529: p_rec.bpd_attribute25:=
530: per_bpd_shd.g_old_rec.bpd_attribute25;

Line 530: per_bpd_shd.g_old_rec.bpd_attribute25;

526: per_bpd_shd.g_old_rec.bpd_attribute24;
527: End If;
528: If (p_rec.bpd_attribute25 = hr_api.g_varchar2) then
529: p_rec.bpd_attribute25:=
530: per_bpd_shd.g_old_rec.bpd_attribute25;
531: End If;
532: If (p_rec.bpd_attribute26 = hr_api.g_varchar2) then
533: p_rec.bpd_attribute26:=
534: per_bpd_shd.g_old_rec.bpd_attribute26;

Line 534: per_bpd_shd.g_old_rec.bpd_attribute26;

530: per_bpd_shd.g_old_rec.bpd_attribute25;
531: End If;
532: If (p_rec.bpd_attribute26 = hr_api.g_varchar2) then
533: p_rec.bpd_attribute26:=
534: per_bpd_shd.g_old_rec.bpd_attribute26;
535: End If;
536: If (p_rec.bpd_attribute27 = hr_api.g_varchar2) then
537: p_rec.bpd_attribute27:=
538: per_bpd_shd.g_old_rec.bpd_attribute27;

Line 538: per_bpd_shd.g_old_rec.bpd_attribute27;

534: per_bpd_shd.g_old_rec.bpd_attribute26;
535: End If;
536: If (p_rec.bpd_attribute27 = hr_api.g_varchar2) then
537: p_rec.bpd_attribute27:=
538: per_bpd_shd.g_old_rec.bpd_attribute27;
539: End If;
540: If (p_rec.bpd_attribute28 = hr_api.g_varchar2) then
541: p_rec.bpd_attribute28:=
542: per_bpd_shd.g_old_rec.bpd_attribute28;

Line 542: per_bpd_shd.g_old_rec.bpd_attribute28;

538: per_bpd_shd.g_old_rec.bpd_attribute27;
539: End If;
540: If (p_rec.bpd_attribute28 = hr_api.g_varchar2) then
541: p_rec.bpd_attribute28:=
542: per_bpd_shd.g_old_rec.bpd_attribute28;
543: End If;
544: If (p_rec.bpd_attribute29 = hr_api.g_varchar2) then
545: p_rec.bpd_attribute29:=
546: per_bpd_shd.g_old_rec.bpd_attribute29;

Line 546: per_bpd_shd.g_old_rec.bpd_attribute29;

542: per_bpd_shd.g_old_rec.bpd_attribute28;
543: End If;
544: If (p_rec.bpd_attribute29 = hr_api.g_varchar2) then
545: p_rec.bpd_attribute29:=
546: per_bpd_shd.g_old_rec.bpd_attribute29;
547: End If;
548: If (p_rec.bpd_attribute30 = hr_api.g_varchar2) then
549: p_rec.bpd_attribute30:=
550: per_bpd_shd.g_old_rec.bpd_attribute30;

Line 550: per_bpd_shd.g_old_rec.bpd_attribute30;

546: per_bpd_shd.g_old_rec.bpd_attribute29;
547: End If;
548: If (p_rec.bpd_attribute30 = hr_api.g_varchar2) then
549: p_rec.bpd_attribute30:=
550: per_bpd_shd.g_old_rec.bpd_attribute30;
551: End If;
552:
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 564: p_rec in out nocopy per_bpd_shd.g_rec_type

560: -- ----------------------------------------------------------------------------
561: Procedure upd
562: (
563: p_effective_date in date,
564: p_rec in out nocopy per_bpd_shd.g_rec_type
565: ) is
566: --
567: l_proc varchar2(72) := g_package||'upd';
568: --

Line 574: per_bpd_shd.lck

570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- We must lock the row which we need to update.
573: --
574: per_bpd_shd.lck
575: (
576: p_rec.payment_detail_id,
577: p_rec.object_version_number
578: );

Line 650: l_rec per_bpd_shd.g_rec_type;

646: p_bpd_attribute29 in varchar2 default hr_api.g_varchar2,
647: p_bpd_attribute30 in varchar2 default hr_api.g_varchar2
648: ) is
649: --
650: l_rec per_bpd_shd.g_rec_type;
651: l_proc varchar2(72) := g_package||'upd';
652: --
653: Begin
654: hr_utility.set_location('Entering:'||l_proc, 5);

Line 660: per_bpd_shd.convert_args

656: -- Call conversion function to turn arguments into the
657: -- l_rec structure.
658: --
659: l_rec :=
660: per_bpd_shd.convert_args
661: (
662: p_payment_detail_id,
663: hr_api.g_number,
664: hr_api.g_number,