[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_bpa_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: per_bpa_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_bpa_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_bpa_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_update
167: (p_rec in per_bpa_shd.g_rec_type
168: ) is
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_update
211: (p_effective_date in date
212: ,p_rec in per_bpa_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'post_update';
216: --
253: p_bpa_attribute28 => p_rec.bpa_attribute28,
254: p_bpa_attribute29 => p_rec.bpa_attribute29,
255: p_bpa_attribute30 => p_rec.bpa_attribute30,
256: p_payroll_run_id_o
257: => per_bpa_shd.g_old_rec.payroll_run_id,
258: p_assignment_id_o
259: => per_bpa_shd.g_old_rec.assignment_id,
260: p_object_version_number_o
261: => per_bpa_shd.g_old_rec.object_version_number,
255: p_bpa_attribute30 => p_rec.bpa_attribute30,
256: p_payroll_run_id_o
257: => per_bpa_shd.g_old_rec.payroll_run_id,
258: p_assignment_id_o
259: => per_bpa_shd.g_old_rec.assignment_id,
260: p_object_version_number_o
261: => per_bpa_shd.g_old_rec.object_version_number,
262: p_bpa_attribute_category_o
263: => per_bpa_shd.g_old_rec.bpa_attribute_category,
257: => per_bpa_shd.g_old_rec.payroll_run_id,
258: p_assignment_id_o
259: => per_bpa_shd.g_old_rec.assignment_id,
260: p_object_version_number_o
261: => per_bpa_shd.g_old_rec.object_version_number,
262: p_bpa_attribute_category_o
263: => per_bpa_shd.g_old_rec.bpa_attribute_category,
264: p_bpa_attribute1_o
265: => per_bpa_shd.g_old_rec.bpa_attribute1,
259: => per_bpa_shd.g_old_rec.assignment_id,
260: p_object_version_number_o
261: => per_bpa_shd.g_old_rec.object_version_number,
262: p_bpa_attribute_category_o
263: => per_bpa_shd.g_old_rec.bpa_attribute_category,
264: p_bpa_attribute1_o
265: => per_bpa_shd.g_old_rec.bpa_attribute1,
266: p_bpa_attribute2_o
267: => per_bpa_shd.g_old_rec.bpa_attribute2,
261: => per_bpa_shd.g_old_rec.object_version_number,
262: p_bpa_attribute_category_o
263: => per_bpa_shd.g_old_rec.bpa_attribute_category,
264: p_bpa_attribute1_o
265: => per_bpa_shd.g_old_rec.bpa_attribute1,
266: p_bpa_attribute2_o
267: => per_bpa_shd.g_old_rec.bpa_attribute2,
268: p_bpa_attribute3_o
269: => per_bpa_shd.g_old_rec.bpa_attribute3,
263: => per_bpa_shd.g_old_rec.bpa_attribute_category,
264: p_bpa_attribute1_o
265: => per_bpa_shd.g_old_rec.bpa_attribute1,
266: p_bpa_attribute2_o
267: => per_bpa_shd.g_old_rec.bpa_attribute2,
268: p_bpa_attribute3_o
269: => per_bpa_shd.g_old_rec.bpa_attribute3,
270: p_bpa_attribute4_o
271: => per_bpa_shd.g_old_rec.bpa_attribute4,
265: => per_bpa_shd.g_old_rec.bpa_attribute1,
266: p_bpa_attribute2_o
267: => per_bpa_shd.g_old_rec.bpa_attribute2,
268: p_bpa_attribute3_o
269: => per_bpa_shd.g_old_rec.bpa_attribute3,
270: p_bpa_attribute4_o
271: => per_bpa_shd.g_old_rec.bpa_attribute4,
272: p_bpa_attribute5_o
273: => per_bpa_shd.g_old_rec.bpa_attribute5,
267: => per_bpa_shd.g_old_rec.bpa_attribute2,
268: p_bpa_attribute3_o
269: => per_bpa_shd.g_old_rec.bpa_attribute3,
270: p_bpa_attribute4_o
271: => per_bpa_shd.g_old_rec.bpa_attribute4,
272: p_bpa_attribute5_o
273: => per_bpa_shd.g_old_rec.bpa_attribute5,
274: p_bpa_attribute6_o
275: => per_bpa_shd.g_old_rec.bpa_attribute6,
269: => per_bpa_shd.g_old_rec.bpa_attribute3,
270: p_bpa_attribute4_o
271: => per_bpa_shd.g_old_rec.bpa_attribute4,
272: p_bpa_attribute5_o
273: => per_bpa_shd.g_old_rec.bpa_attribute5,
274: p_bpa_attribute6_o
275: => per_bpa_shd.g_old_rec.bpa_attribute6,
276: p_bpa_attribute7_o
277: => per_bpa_shd.g_old_rec.bpa_attribute7,
271: => per_bpa_shd.g_old_rec.bpa_attribute4,
272: p_bpa_attribute5_o
273: => per_bpa_shd.g_old_rec.bpa_attribute5,
274: p_bpa_attribute6_o
275: => per_bpa_shd.g_old_rec.bpa_attribute6,
276: p_bpa_attribute7_o
277: => per_bpa_shd.g_old_rec.bpa_attribute7,
278: p_bpa_attribute8_o
279: => per_bpa_shd.g_old_rec.bpa_attribute8,
273: => per_bpa_shd.g_old_rec.bpa_attribute5,
274: p_bpa_attribute6_o
275: => per_bpa_shd.g_old_rec.bpa_attribute6,
276: p_bpa_attribute7_o
277: => per_bpa_shd.g_old_rec.bpa_attribute7,
278: p_bpa_attribute8_o
279: => per_bpa_shd.g_old_rec.bpa_attribute8,
280: p_bpa_attribute9_o
281: => per_bpa_shd.g_old_rec.bpa_attribute9,
275: => per_bpa_shd.g_old_rec.bpa_attribute6,
276: p_bpa_attribute7_o
277: => per_bpa_shd.g_old_rec.bpa_attribute7,
278: p_bpa_attribute8_o
279: => per_bpa_shd.g_old_rec.bpa_attribute8,
280: p_bpa_attribute9_o
281: => per_bpa_shd.g_old_rec.bpa_attribute9,
282: p_bpa_attribute10_o
283: => per_bpa_shd.g_old_rec.bpa_attribute10,
277: => per_bpa_shd.g_old_rec.bpa_attribute7,
278: p_bpa_attribute8_o
279: => per_bpa_shd.g_old_rec.bpa_attribute8,
280: p_bpa_attribute9_o
281: => per_bpa_shd.g_old_rec.bpa_attribute9,
282: p_bpa_attribute10_o
283: => per_bpa_shd.g_old_rec.bpa_attribute10,
284: p_bpa_attribute11_o
285: => per_bpa_shd.g_old_rec.bpa_attribute11,
279: => per_bpa_shd.g_old_rec.bpa_attribute8,
280: p_bpa_attribute9_o
281: => per_bpa_shd.g_old_rec.bpa_attribute9,
282: p_bpa_attribute10_o
283: => per_bpa_shd.g_old_rec.bpa_attribute10,
284: p_bpa_attribute11_o
285: => per_bpa_shd.g_old_rec.bpa_attribute11,
286: p_bpa_attribute12_o
287: => per_bpa_shd.g_old_rec.bpa_attribute12,
281: => per_bpa_shd.g_old_rec.bpa_attribute9,
282: p_bpa_attribute10_o
283: => per_bpa_shd.g_old_rec.bpa_attribute10,
284: p_bpa_attribute11_o
285: => per_bpa_shd.g_old_rec.bpa_attribute11,
286: p_bpa_attribute12_o
287: => per_bpa_shd.g_old_rec.bpa_attribute12,
288: p_bpa_attribute13_o
289: => per_bpa_shd.g_old_rec.bpa_attribute13,
283: => per_bpa_shd.g_old_rec.bpa_attribute10,
284: p_bpa_attribute11_o
285: => per_bpa_shd.g_old_rec.bpa_attribute11,
286: p_bpa_attribute12_o
287: => per_bpa_shd.g_old_rec.bpa_attribute12,
288: p_bpa_attribute13_o
289: => per_bpa_shd.g_old_rec.bpa_attribute13,
290: p_bpa_attribute14_o
291: => per_bpa_shd.g_old_rec.bpa_attribute14,
285: => per_bpa_shd.g_old_rec.bpa_attribute11,
286: p_bpa_attribute12_o
287: => per_bpa_shd.g_old_rec.bpa_attribute12,
288: p_bpa_attribute13_o
289: => per_bpa_shd.g_old_rec.bpa_attribute13,
290: p_bpa_attribute14_o
291: => per_bpa_shd.g_old_rec.bpa_attribute14,
292: p_bpa_attribute15_o
293: => per_bpa_shd.g_old_rec.bpa_attribute15,
287: => per_bpa_shd.g_old_rec.bpa_attribute12,
288: p_bpa_attribute13_o
289: => per_bpa_shd.g_old_rec.bpa_attribute13,
290: p_bpa_attribute14_o
291: => per_bpa_shd.g_old_rec.bpa_attribute14,
292: p_bpa_attribute15_o
293: => per_bpa_shd.g_old_rec.bpa_attribute15,
294: p_bpa_attribute16_o
295: => per_bpa_shd.g_old_rec.bpa_attribute16,
289: => per_bpa_shd.g_old_rec.bpa_attribute13,
290: p_bpa_attribute14_o
291: => per_bpa_shd.g_old_rec.bpa_attribute14,
292: p_bpa_attribute15_o
293: => per_bpa_shd.g_old_rec.bpa_attribute15,
294: p_bpa_attribute16_o
295: => per_bpa_shd.g_old_rec.bpa_attribute16,
296: p_bpa_attribute17_o
297: => per_bpa_shd.g_old_rec.bpa_attribute17,
291: => per_bpa_shd.g_old_rec.bpa_attribute14,
292: p_bpa_attribute15_o
293: => per_bpa_shd.g_old_rec.bpa_attribute15,
294: p_bpa_attribute16_o
295: => per_bpa_shd.g_old_rec.bpa_attribute16,
296: p_bpa_attribute17_o
297: => per_bpa_shd.g_old_rec.bpa_attribute17,
298: p_bpa_attribute18_o
299: => per_bpa_shd.g_old_rec.bpa_attribute18,
293: => per_bpa_shd.g_old_rec.bpa_attribute15,
294: p_bpa_attribute16_o
295: => per_bpa_shd.g_old_rec.bpa_attribute16,
296: p_bpa_attribute17_o
297: => per_bpa_shd.g_old_rec.bpa_attribute17,
298: p_bpa_attribute18_o
299: => per_bpa_shd.g_old_rec.bpa_attribute18,
300: p_bpa_attribute19_o
301: => per_bpa_shd.g_old_rec.bpa_attribute19,
295: => per_bpa_shd.g_old_rec.bpa_attribute16,
296: p_bpa_attribute17_o
297: => per_bpa_shd.g_old_rec.bpa_attribute17,
298: p_bpa_attribute18_o
299: => per_bpa_shd.g_old_rec.bpa_attribute18,
300: p_bpa_attribute19_o
301: => per_bpa_shd.g_old_rec.bpa_attribute19,
302: p_bpa_attribute20_o
303: => per_bpa_shd.g_old_rec.bpa_attribute20,
297: => per_bpa_shd.g_old_rec.bpa_attribute17,
298: p_bpa_attribute18_o
299: => per_bpa_shd.g_old_rec.bpa_attribute18,
300: p_bpa_attribute19_o
301: => per_bpa_shd.g_old_rec.bpa_attribute19,
302: p_bpa_attribute20_o
303: => per_bpa_shd.g_old_rec.bpa_attribute20,
304: p_bpa_attribute21_o
305: => per_bpa_shd.g_old_rec.bpa_attribute21,
299: => per_bpa_shd.g_old_rec.bpa_attribute18,
300: p_bpa_attribute19_o
301: => per_bpa_shd.g_old_rec.bpa_attribute19,
302: p_bpa_attribute20_o
303: => per_bpa_shd.g_old_rec.bpa_attribute20,
304: p_bpa_attribute21_o
305: => per_bpa_shd.g_old_rec.bpa_attribute21,
306: p_bpa_attribute22_o
307: => per_bpa_shd.g_old_rec.bpa_attribute22,
301: => per_bpa_shd.g_old_rec.bpa_attribute19,
302: p_bpa_attribute20_o
303: => per_bpa_shd.g_old_rec.bpa_attribute20,
304: p_bpa_attribute21_o
305: => per_bpa_shd.g_old_rec.bpa_attribute21,
306: p_bpa_attribute22_o
307: => per_bpa_shd.g_old_rec.bpa_attribute22,
308: p_bpa_attribute23_o
309: => per_bpa_shd.g_old_rec.bpa_attribute23,
303: => per_bpa_shd.g_old_rec.bpa_attribute20,
304: p_bpa_attribute21_o
305: => per_bpa_shd.g_old_rec.bpa_attribute21,
306: p_bpa_attribute22_o
307: => per_bpa_shd.g_old_rec.bpa_attribute22,
308: p_bpa_attribute23_o
309: => per_bpa_shd.g_old_rec.bpa_attribute23,
310: p_bpa_attribute24_o
311: => per_bpa_shd.g_old_rec.bpa_attribute24,
305: => per_bpa_shd.g_old_rec.bpa_attribute21,
306: p_bpa_attribute22_o
307: => per_bpa_shd.g_old_rec.bpa_attribute22,
308: p_bpa_attribute23_o
309: => per_bpa_shd.g_old_rec.bpa_attribute23,
310: p_bpa_attribute24_o
311: => per_bpa_shd.g_old_rec.bpa_attribute24,
312: p_bpa_attribute25_o
313: => per_bpa_shd.g_old_rec.bpa_attribute25,
307: => per_bpa_shd.g_old_rec.bpa_attribute22,
308: p_bpa_attribute23_o
309: => per_bpa_shd.g_old_rec.bpa_attribute23,
310: p_bpa_attribute24_o
311: => per_bpa_shd.g_old_rec.bpa_attribute24,
312: p_bpa_attribute25_o
313: => per_bpa_shd.g_old_rec.bpa_attribute25,
314: p_bpa_attribute26_o
315: => per_bpa_shd.g_old_rec.bpa_attribute26,
309: => per_bpa_shd.g_old_rec.bpa_attribute23,
310: p_bpa_attribute24_o
311: => per_bpa_shd.g_old_rec.bpa_attribute24,
312: p_bpa_attribute25_o
313: => per_bpa_shd.g_old_rec.bpa_attribute25,
314: p_bpa_attribute26_o
315: => per_bpa_shd.g_old_rec.bpa_attribute26,
316: p_bpa_attribute27_o
317: => per_bpa_shd.g_old_rec.bpa_attribute27,
311: => per_bpa_shd.g_old_rec.bpa_attribute24,
312: p_bpa_attribute25_o
313: => per_bpa_shd.g_old_rec.bpa_attribute25,
314: p_bpa_attribute26_o
315: => per_bpa_shd.g_old_rec.bpa_attribute26,
316: p_bpa_attribute27_o
317: => per_bpa_shd.g_old_rec.bpa_attribute27,
318: p_bpa_attribute28_o
319: => per_bpa_shd.g_old_rec.bpa_attribute28,
313: => per_bpa_shd.g_old_rec.bpa_attribute25,
314: p_bpa_attribute26_o
315: => per_bpa_shd.g_old_rec.bpa_attribute26,
316: p_bpa_attribute27_o
317: => per_bpa_shd.g_old_rec.bpa_attribute27,
318: p_bpa_attribute28_o
319: => per_bpa_shd.g_old_rec.bpa_attribute28,
320: p_bpa_attribute29_o
321: => per_bpa_shd.g_old_rec.bpa_attribute29,
315: => per_bpa_shd.g_old_rec.bpa_attribute26,
316: p_bpa_attribute27_o
317: => per_bpa_shd.g_old_rec.bpa_attribute27,
318: p_bpa_attribute28_o
319: => per_bpa_shd.g_old_rec.bpa_attribute28,
320: p_bpa_attribute29_o
321: => per_bpa_shd.g_old_rec.bpa_attribute29,
322: p_bpa_attribute30_o
323: => per_bpa_shd.g_old_rec.bpa_attribute30
317: => per_bpa_shd.g_old_rec.bpa_attribute27,
318: p_bpa_attribute28_o
319: => per_bpa_shd.g_old_rec.bpa_attribute28,
320: p_bpa_attribute29_o
321: => per_bpa_shd.g_old_rec.bpa_attribute29,
322: p_bpa_attribute30_o
323: => per_bpa_shd.g_old_rec.bpa_attribute30
324: );
325: --
319: => per_bpa_shd.g_old_rec.bpa_attribute28,
320: p_bpa_attribute29_o
321: => per_bpa_shd.g_old_rec.bpa_attribute29,
322: p_bpa_attribute30_o
323: => per_bpa_shd.g_old_rec.bpa_attribute30
324: );
325: --
326: exception
327: --
379: --
380: -- {End Of Comments}
381: -- ----------------------------------------------------------------------------
382: Procedure convert_defs
383: (p_rec in out nocopy per_bpa_shd.g_rec_type
384: ) is
385: --
386: l_proc varchar2(72) := g_package||'convert_defs';
387: --
395: -- is being used then we must set to the 'current' argument value.
396: --
397: If (p_rec.payroll_run_id = hr_api.g_number) then
398: p_rec.payroll_run_id :=
399: per_bpa_shd.g_old_rec.payroll_run_id;
400: End If;
401: If (p_rec.assignment_id = hr_api.g_number) then
402: p_rec.assignment_id :=
403: per_bpa_shd.g_old_rec.assignment_id;
399: per_bpa_shd.g_old_rec.payroll_run_id;
400: End If;
401: If (p_rec.assignment_id = hr_api.g_number) then
402: p_rec.assignment_id :=
403: per_bpa_shd.g_old_rec.assignment_id;
404: End If;
405: If (p_rec.bpa_attribute_category = hr_api.g_varchar2) then
406: p_rec.bpa_attribute_category :=
407: per_bpa_shd.g_old_rec.bpa_attribute_category;
403: per_bpa_shd.g_old_rec.assignment_id;
404: End If;
405: If (p_rec.bpa_attribute_category = hr_api.g_varchar2) then
406: p_rec.bpa_attribute_category :=
407: per_bpa_shd.g_old_rec.bpa_attribute_category;
408: End If;
409: If (p_rec.bpa_attribute1 = hr_api.g_varchar2) then
410: p_rec.bpa_attribute1:=
411: per_bpa_shd.g_old_rec.bpa_attribute1;
407: per_bpa_shd.g_old_rec.bpa_attribute_category;
408: End If;
409: If (p_rec.bpa_attribute1 = hr_api.g_varchar2) then
410: p_rec.bpa_attribute1:=
411: per_bpa_shd.g_old_rec.bpa_attribute1;
412: End If;
413: If (p_rec.bpa_attribute2 = hr_api.g_varchar2) then
414: p_rec.bpa_attribute2:=
415: per_bpa_shd.g_old_rec.bpa_attribute2;
411: per_bpa_shd.g_old_rec.bpa_attribute1;
412: End If;
413: If (p_rec.bpa_attribute2 = hr_api.g_varchar2) then
414: p_rec.bpa_attribute2:=
415: per_bpa_shd.g_old_rec.bpa_attribute2;
416: End If;
417: If (p_rec.bpa_attribute3 = hr_api.g_varchar2) then
418: p_rec.bpa_attribute3:=
419: per_bpa_shd.g_old_rec.bpa_attribute3;
415: per_bpa_shd.g_old_rec.bpa_attribute2;
416: End If;
417: If (p_rec.bpa_attribute3 = hr_api.g_varchar2) then
418: p_rec.bpa_attribute3:=
419: per_bpa_shd.g_old_rec.bpa_attribute3;
420: End If;
421: If (p_rec.bpa_attribute4 = hr_api.g_varchar2) then
422: p_rec.bpa_attribute4:=
423: per_bpa_shd.g_old_rec.bpa_attribute4;
419: per_bpa_shd.g_old_rec.bpa_attribute3;
420: End If;
421: If (p_rec.bpa_attribute4 = hr_api.g_varchar2) then
422: p_rec.bpa_attribute4:=
423: per_bpa_shd.g_old_rec.bpa_attribute4;
424: End If;
425: If (p_rec.bpa_attribute5 = hr_api.g_varchar2) then
426: p_rec.bpa_attribute5:=
427: per_bpa_shd.g_old_rec.bpa_attribute5;
423: per_bpa_shd.g_old_rec.bpa_attribute4;
424: End If;
425: If (p_rec.bpa_attribute5 = hr_api.g_varchar2) then
426: p_rec.bpa_attribute5:=
427: per_bpa_shd.g_old_rec.bpa_attribute5;
428: End If;
429: If (p_rec.bpa_attribute6 = hr_api.g_varchar2) then
430: p_rec.bpa_attribute6:=
431: per_bpa_shd.g_old_rec.bpa_attribute6;
427: per_bpa_shd.g_old_rec.bpa_attribute5;
428: End If;
429: If (p_rec.bpa_attribute6 = hr_api.g_varchar2) then
430: p_rec.bpa_attribute6:=
431: per_bpa_shd.g_old_rec.bpa_attribute6;
432: End If;
433: If (p_rec.bpa_attribute7 = hr_api.g_varchar2) then
434: p_rec.bpa_attribute7:=
435: per_bpa_shd.g_old_rec.bpa_attribute7;
431: per_bpa_shd.g_old_rec.bpa_attribute6;
432: End If;
433: If (p_rec.bpa_attribute7 = hr_api.g_varchar2) then
434: p_rec.bpa_attribute7:=
435: per_bpa_shd.g_old_rec.bpa_attribute7;
436: End If;
437: If (p_rec.bpa_attribute8 = hr_api.g_varchar2) then
438: p_rec.bpa_attribute8:=
439: per_bpa_shd.g_old_rec.bpa_attribute8;
435: per_bpa_shd.g_old_rec.bpa_attribute7;
436: End If;
437: If (p_rec.bpa_attribute8 = hr_api.g_varchar2) then
438: p_rec.bpa_attribute8:=
439: per_bpa_shd.g_old_rec.bpa_attribute8;
440: End If;
441: If (p_rec.bpa_attribute9 = hr_api.g_varchar2) then
442: p_rec.bpa_attribute9:=
443: per_bpa_shd.g_old_rec.bpa_attribute9;
439: per_bpa_shd.g_old_rec.bpa_attribute8;
440: End If;
441: If (p_rec.bpa_attribute9 = hr_api.g_varchar2) then
442: p_rec.bpa_attribute9:=
443: per_bpa_shd.g_old_rec.bpa_attribute9;
444: End If;
445: If (p_rec.bpa_attribute10 = hr_api.g_varchar2) then
446: p_rec.bpa_attribute10:=
447: per_bpa_shd.g_old_rec.bpa_attribute10;
443: per_bpa_shd.g_old_rec.bpa_attribute9;
444: End If;
445: If (p_rec.bpa_attribute10 = hr_api.g_varchar2) then
446: p_rec.bpa_attribute10:=
447: per_bpa_shd.g_old_rec.bpa_attribute10;
448: End If;
449: If (p_rec.bpa_attribute11 = hr_api.g_varchar2) then
450: p_rec.bpa_attribute11:=
451: per_bpa_shd.g_old_rec.bpa_attribute11;
447: per_bpa_shd.g_old_rec.bpa_attribute10;
448: End If;
449: If (p_rec.bpa_attribute11 = hr_api.g_varchar2) then
450: p_rec.bpa_attribute11:=
451: per_bpa_shd.g_old_rec.bpa_attribute11;
452: End If;
453: If (p_rec.bpa_attribute12 = hr_api.g_varchar2) then
454: p_rec.bpa_attribute12:=
455: per_bpa_shd.g_old_rec.bpa_attribute12;
451: per_bpa_shd.g_old_rec.bpa_attribute11;
452: End If;
453: If (p_rec.bpa_attribute12 = hr_api.g_varchar2) then
454: p_rec.bpa_attribute12:=
455: per_bpa_shd.g_old_rec.bpa_attribute12;
456: End If;
457: If (p_rec.bpa_attribute13 = hr_api.g_varchar2) then
458: p_rec.bpa_attribute13:=
459: per_bpa_shd.g_old_rec.bpa_attribute13;
455: per_bpa_shd.g_old_rec.bpa_attribute12;
456: End If;
457: If (p_rec.bpa_attribute13 = hr_api.g_varchar2) then
458: p_rec.bpa_attribute13:=
459: per_bpa_shd.g_old_rec.bpa_attribute13;
460: End If;
461: If (p_rec.bpa_attribute14 = hr_api.g_varchar2) then
462: p_rec.bpa_attribute14:=
463: per_bpa_shd.g_old_rec.bpa_attribute14;
459: per_bpa_shd.g_old_rec.bpa_attribute13;
460: End If;
461: If (p_rec.bpa_attribute14 = hr_api.g_varchar2) then
462: p_rec.bpa_attribute14:=
463: per_bpa_shd.g_old_rec.bpa_attribute14;
464: End If;
465: If (p_rec.bpa_attribute15 = hr_api.g_varchar2) then
466: p_rec.bpa_attribute15:=
467: per_bpa_shd.g_old_rec.bpa_attribute15;
463: per_bpa_shd.g_old_rec.bpa_attribute14;
464: End If;
465: If (p_rec.bpa_attribute15 = hr_api.g_varchar2) then
466: p_rec.bpa_attribute15:=
467: per_bpa_shd.g_old_rec.bpa_attribute15;
468: End If;
469: If (p_rec.bpa_attribute16 = hr_api.g_varchar2) then
470: p_rec.bpa_attribute16:=
471: per_bpa_shd.g_old_rec.bpa_attribute16;
467: per_bpa_shd.g_old_rec.bpa_attribute15;
468: End If;
469: If (p_rec.bpa_attribute16 = hr_api.g_varchar2) then
470: p_rec.bpa_attribute16:=
471: per_bpa_shd.g_old_rec.bpa_attribute16;
472: End If;
473: If (p_rec.bpa_attribute17 = hr_api.g_varchar2) then
474: p_rec.bpa_attribute17:=
475: per_bpa_shd.g_old_rec.bpa_attribute17;
471: per_bpa_shd.g_old_rec.bpa_attribute16;
472: End If;
473: If (p_rec.bpa_attribute17 = hr_api.g_varchar2) then
474: p_rec.bpa_attribute17:=
475: per_bpa_shd.g_old_rec.bpa_attribute17;
476: End If;
477: If (p_rec.bpa_attribute18 = hr_api.g_varchar2) then
478: p_rec.bpa_attribute18:=
479: per_bpa_shd.g_old_rec.bpa_attribute18;
475: per_bpa_shd.g_old_rec.bpa_attribute17;
476: End If;
477: If (p_rec.bpa_attribute18 = hr_api.g_varchar2) then
478: p_rec.bpa_attribute18:=
479: per_bpa_shd.g_old_rec.bpa_attribute18;
480: End If;
481: If (p_rec.bpa_attribute19 = hr_api.g_varchar2) then
482: p_rec.bpa_attribute19:=
483: per_bpa_shd.g_old_rec.bpa_attribute19;
479: per_bpa_shd.g_old_rec.bpa_attribute18;
480: End If;
481: If (p_rec.bpa_attribute19 = hr_api.g_varchar2) then
482: p_rec.bpa_attribute19:=
483: per_bpa_shd.g_old_rec.bpa_attribute19;
484: End If;
485: If (p_rec.bpa_attribute20 = hr_api.g_varchar2) then
486: p_rec.bpa_attribute20:=
487: per_bpa_shd.g_old_rec.bpa_attribute20;
483: per_bpa_shd.g_old_rec.bpa_attribute19;
484: End If;
485: If (p_rec.bpa_attribute20 = hr_api.g_varchar2) then
486: p_rec.bpa_attribute20:=
487: per_bpa_shd.g_old_rec.bpa_attribute20;
488: End If;
489: If (p_rec.bpa_attribute21 = hr_api.g_varchar2) then
490: p_rec.bpa_attribute21:=
491: per_bpa_shd.g_old_rec.bpa_attribute21;
487: per_bpa_shd.g_old_rec.bpa_attribute20;
488: End If;
489: If (p_rec.bpa_attribute21 = hr_api.g_varchar2) then
490: p_rec.bpa_attribute21:=
491: per_bpa_shd.g_old_rec.bpa_attribute21;
492: End If;
493: If (p_rec.bpa_attribute22 = hr_api.g_varchar2) then
494: p_rec.bpa_attribute22:=
495: per_bpa_shd.g_old_rec.bpa_attribute22;
491: per_bpa_shd.g_old_rec.bpa_attribute21;
492: End If;
493: If (p_rec.bpa_attribute22 = hr_api.g_varchar2) then
494: p_rec.bpa_attribute22:=
495: per_bpa_shd.g_old_rec.bpa_attribute22;
496: End If;
497: If (p_rec.bpa_attribute23 = hr_api.g_varchar2) then
498: p_rec.bpa_attribute23:=
499: per_bpa_shd.g_old_rec.bpa_attribute23;
495: per_bpa_shd.g_old_rec.bpa_attribute22;
496: End If;
497: If (p_rec.bpa_attribute23 = hr_api.g_varchar2) then
498: p_rec.bpa_attribute23:=
499: per_bpa_shd.g_old_rec.bpa_attribute23;
500: End If;
501: If (p_rec.bpa_attribute24 = hr_api.g_varchar2) then
502: p_rec.bpa_attribute24:=
503: per_bpa_shd.g_old_rec.bpa_attribute24;
499: per_bpa_shd.g_old_rec.bpa_attribute23;
500: End If;
501: If (p_rec.bpa_attribute24 = hr_api.g_varchar2) then
502: p_rec.bpa_attribute24:=
503: per_bpa_shd.g_old_rec.bpa_attribute24;
504: End If;
505: If (p_rec.bpa_attribute25 = hr_api.g_varchar2) then
506: p_rec.bpa_attribute25:=
507: per_bpa_shd.g_old_rec.bpa_attribute25;
503: per_bpa_shd.g_old_rec.bpa_attribute24;
504: End If;
505: If (p_rec.bpa_attribute25 = hr_api.g_varchar2) then
506: p_rec.bpa_attribute25:=
507: per_bpa_shd.g_old_rec.bpa_attribute25;
508: End If;
509: If (p_rec.bpa_attribute26 = hr_api.g_varchar2) then
510: p_rec.bpa_attribute26:=
511: per_bpa_shd.g_old_rec.bpa_attribute26;
507: per_bpa_shd.g_old_rec.bpa_attribute25;
508: End If;
509: If (p_rec.bpa_attribute26 = hr_api.g_varchar2) then
510: p_rec.bpa_attribute26:=
511: per_bpa_shd.g_old_rec.bpa_attribute26;
512: End If;
513: If (p_rec.bpa_attribute27 = hr_api.g_varchar2) then
514: p_rec.bpa_attribute27:=
515: per_bpa_shd.g_old_rec.bpa_attribute27;
511: per_bpa_shd.g_old_rec.bpa_attribute26;
512: End If;
513: If (p_rec.bpa_attribute27 = hr_api.g_varchar2) then
514: p_rec.bpa_attribute27:=
515: per_bpa_shd.g_old_rec.bpa_attribute27;
516: End If;
517: If (p_rec.bpa_attribute28 = hr_api.g_varchar2) then
518: p_rec.bpa_attribute28:=
519: per_bpa_shd.g_old_rec.bpa_attribute28;
515: per_bpa_shd.g_old_rec.bpa_attribute27;
516: End If;
517: If (p_rec.bpa_attribute28 = hr_api.g_varchar2) then
518: p_rec.bpa_attribute28:=
519: per_bpa_shd.g_old_rec.bpa_attribute28;
520: End If;
521: If (p_rec.bpa_attribute29 = hr_api.g_varchar2) then
522: p_rec.bpa_attribute29:=
523: per_bpa_shd.g_old_rec.bpa_attribute29;
519: per_bpa_shd.g_old_rec.bpa_attribute28;
520: End If;
521: If (p_rec.bpa_attribute29 = hr_api.g_varchar2) then
522: p_rec.bpa_attribute29:=
523: per_bpa_shd.g_old_rec.bpa_attribute29;
524: End If;
525: If (p_rec.bpa_attribute30 = hr_api.g_varchar2) then
526: p_rec.bpa_attribute30:=
527: per_bpa_shd.g_old_rec.bpa_attribute30;
523: per_bpa_shd.g_old_rec.bpa_attribute29;
524: End If;
525: If (p_rec.bpa_attribute30 = hr_api.g_varchar2) then
526: p_rec.bpa_attribute30:=
527: per_bpa_shd.g_old_rec.bpa_attribute30;
528: End If;
529: --
530: hr_utility.set_location(' Leaving:'||l_proc, 10);
531: --
535: -- |---------------------------------< upd >----------------------------------|
536: -- ----------------------------------------------------------------------------
537: Procedure upd
538: (p_effective_date in date
539: ,p_rec in out nocopy per_bpa_shd.g_rec_type
540: ) is
541: --
542: l_proc varchar2(72) := g_package||'upd';
543: --
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: -- We must lock the row which we need to update.
548: --
549: per_bpa_shd.lck
550: (p_rec.processed_assignment_id
551: ,p_rec.object_version_number
552: );
553: --
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,
619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2
620: ) is
621: --
622: l_rec per_bpa_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'upd';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
628: -- Call conversion function to turn arguments into the
629: -- l_rec structure.
630: --
631: l_rec :=
632: per_bpa_shd.convert_args
633: (p_processed_assignment_id,
634: hr_api.g_number,
635: hr_api.g_number,
636: p_object_version_number,