51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_cpe_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
112: ota_cpe_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --
117: ota_cpe_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ota_cpe_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_update
162: (p_rec in ota_cpe_shd.g_rec_type
163: ) is
164: --
165: l_proc varchar2(72) := g_package||'pre_update';
166: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure post_update
206: (p_effective_date in date
207: ,p_rec in ota_cpe_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'post_update';
211: --
275: => p_rec.attribute20
276: ,p_expiration_date
277: => p_rec.expiration_date
278: ,p_cert_enrollment_id_o
279: => ota_cpe_shd.g_old_rec.cert_enrollment_id
280: ,p_object_version_number_o
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
277: => p_rec.expiration_date
278: ,p_cert_enrollment_id_o
279: => ota_cpe_shd.g_old_rec.cert_enrollment_id
280: ,p_object_version_number_o
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
279: => ota_cpe_shd.g_old_rec.cert_enrollment_id
280: ,p_object_version_number_o
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
332: ,p_attribute20_o
333: => ota_cpe_shd.g_old_rec.attribute20
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
332: ,p_attribute20_o
333: => ota_cpe_shd.g_old_rec.attribute20
334: ,p_expiration_date_o
335: => p_rec.expiration_date
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
332: ,p_attribute20_o
333: => ota_cpe_shd.g_old_rec.attribute20
334: ,p_expiration_date_o
335: => p_rec.expiration_date
336: );
337: --
391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: Procedure convert_defs
395: (p_rec in out nocopy ota_cpe_shd.g_rec_type
396: ) is
397: --
398: Begin
399: --
403: -- is being used then we must set to the 'current' argument value.
404: --
405: If (p_rec.cert_enrollment_id = hr_api.g_number) then
406: p_rec.cert_enrollment_id :=
407: ota_cpe_shd.g_old_rec.cert_enrollment_id;
408: End If;
409: If (p_rec.period_status_code = hr_api.g_varchar2) then
410: p_rec.period_status_code :=
411: ota_cpe_shd.g_old_rec.period_status_code;
407: ota_cpe_shd.g_old_rec.cert_enrollment_id;
408: End If;
409: If (p_rec.period_status_code = hr_api.g_varchar2) then
410: p_rec.period_status_code :=
411: ota_cpe_shd.g_old_rec.period_status_code;
412: End If;
413: If (p_rec.completion_date = hr_api.g_date) then
414: p_rec.completion_date :=
415: ota_cpe_shd.g_old_rec.completion_date;
411: ota_cpe_shd.g_old_rec.period_status_code;
412: End If;
413: If (p_rec.completion_date = hr_api.g_date) then
414: p_rec.completion_date :=
415: ota_cpe_shd.g_old_rec.completion_date;
416: End If;
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
418: p_rec.cert_period_start_date :=
419: ota_cpe_shd.g_old_rec.cert_period_start_date;
415: ota_cpe_shd.g_old_rec.completion_date;
416: End If;
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
418: p_rec.cert_period_start_date :=
419: ota_cpe_shd.g_old_rec.cert_period_start_date;
420: End If;
421: If (p_rec.cert_period_end_date = hr_api.g_date) then
422: p_rec.cert_period_end_date :=
423: ota_cpe_shd.g_old_rec.cert_period_end_date;
419: ota_cpe_shd.g_old_rec.cert_period_start_date;
420: End If;
421: If (p_rec.cert_period_end_date = hr_api.g_date) then
422: p_rec.cert_period_end_date :=
423: ota_cpe_shd.g_old_rec.cert_period_end_date;
424: End If;
425: If (p_rec.business_group_id = hr_api.g_number) then
426: p_rec.business_group_id :=
427: ota_cpe_shd.g_old_rec.business_group_id;
423: ota_cpe_shd.g_old_rec.cert_period_end_date;
424: End If;
425: If (p_rec.business_group_id = hr_api.g_number) then
426: p_rec.business_group_id :=
427: ota_cpe_shd.g_old_rec.business_group_id;
428: End If;
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
430: p_rec.attribute_category :=
431: ota_cpe_shd.g_old_rec.attribute_category;
427: ota_cpe_shd.g_old_rec.business_group_id;
428: End If;
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
430: p_rec.attribute_category :=
431: ota_cpe_shd.g_old_rec.attribute_category;
432: End If;
433: If (p_rec.attribute1 = hr_api.g_varchar2) then
434: p_rec.attribute1 :=
435: ota_cpe_shd.g_old_rec.attribute1;
431: ota_cpe_shd.g_old_rec.attribute_category;
432: End If;
433: If (p_rec.attribute1 = hr_api.g_varchar2) then
434: p_rec.attribute1 :=
435: ota_cpe_shd.g_old_rec.attribute1;
436: End If;
437: If (p_rec.attribute2 = hr_api.g_varchar2) then
438: p_rec.attribute2 :=
439: ota_cpe_shd.g_old_rec.attribute2;
435: ota_cpe_shd.g_old_rec.attribute1;
436: End If;
437: If (p_rec.attribute2 = hr_api.g_varchar2) then
438: p_rec.attribute2 :=
439: ota_cpe_shd.g_old_rec.attribute2;
440: End If;
441: If (p_rec.attribute3 = hr_api.g_varchar2) then
442: p_rec.attribute3 :=
443: ota_cpe_shd.g_old_rec.attribute3;
439: ota_cpe_shd.g_old_rec.attribute2;
440: End If;
441: If (p_rec.attribute3 = hr_api.g_varchar2) then
442: p_rec.attribute3 :=
443: ota_cpe_shd.g_old_rec.attribute3;
444: End If;
445: If (p_rec.attribute4 = hr_api.g_varchar2) then
446: p_rec.attribute4 :=
447: ota_cpe_shd.g_old_rec.attribute4;
443: ota_cpe_shd.g_old_rec.attribute3;
444: End If;
445: If (p_rec.attribute4 = hr_api.g_varchar2) then
446: p_rec.attribute4 :=
447: ota_cpe_shd.g_old_rec.attribute4;
448: End If;
449: If (p_rec.attribute5 = hr_api.g_varchar2) then
450: p_rec.attribute5 :=
451: ota_cpe_shd.g_old_rec.attribute5;
447: ota_cpe_shd.g_old_rec.attribute4;
448: End If;
449: If (p_rec.attribute5 = hr_api.g_varchar2) then
450: p_rec.attribute5 :=
451: ota_cpe_shd.g_old_rec.attribute5;
452: End If;
453: If (p_rec.attribute6 = hr_api.g_varchar2) then
454: p_rec.attribute6 :=
455: ota_cpe_shd.g_old_rec.attribute6;
451: ota_cpe_shd.g_old_rec.attribute5;
452: End If;
453: If (p_rec.attribute6 = hr_api.g_varchar2) then
454: p_rec.attribute6 :=
455: ota_cpe_shd.g_old_rec.attribute6;
456: End If;
457: If (p_rec.attribute7 = hr_api.g_varchar2) then
458: p_rec.attribute7 :=
459: ota_cpe_shd.g_old_rec.attribute7;
455: ota_cpe_shd.g_old_rec.attribute6;
456: End If;
457: If (p_rec.attribute7 = hr_api.g_varchar2) then
458: p_rec.attribute7 :=
459: ota_cpe_shd.g_old_rec.attribute7;
460: End If;
461: If (p_rec.attribute8 = hr_api.g_varchar2) then
462: p_rec.attribute8 :=
463: ota_cpe_shd.g_old_rec.attribute8;
459: ota_cpe_shd.g_old_rec.attribute7;
460: End If;
461: If (p_rec.attribute8 = hr_api.g_varchar2) then
462: p_rec.attribute8 :=
463: ota_cpe_shd.g_old_rec.attribute8;
464: End If;
465: If (p_rec.attribute9 = hr_api.g_varchar2) then
466: p_rec.attribute9 :=
467: ota_cpe_shd.g_old_rec.attribute9;
463: ota_cpe_shd.g_old_rec.attribute8;
464: End If;
465: If (p_rec.attribute9 = hr_api.g_varchar2) then
466: p_rec.attribute9 :=
467: ota_cpe_shd.g_old_rec.attribute9;
468: End If;
469: If (p_rec.attribute10 = hr_api.g_varchar2) then
470: p_rec.attribute10 :=
471: ota_cpe_shd.g_old_rec.attribute10;
467: ota_cpe_shd.g_old_rec.attribute9;
468: End If;
469: If (p_rec.attribute10 = hr_api.g_varchar2) then
470: p_rec.attribute10 :=
471: ota_cpe_shd.g_old_rec.attribute10;
472: End If;
473: If (p_rec.attribute11 = hr_api.g_varchar2) then
474: p_rec.attribute11 :=
475: ota_cpe_shd.g_old_rec.attribute11;
471: ota_cpe_shd.g_old_rec.attribute10;
472: End If;
473: If (p_rec.attribute11 = hr_api.g_varchar2) then
474: p_rec.attribute11 :=
475: ota_cpe_shd.g_old_rec.attribute11;
476: End If;
477: If (p_rec.attribute12 = hr_api.g_varchar2) then
478: p_rec.attribute12 :=
479: ota_cpe_shd.g_old_rec.attribute12;
475: ota_cpe_shd.g_old_rec.attribute11;
476: End If;
477: If (p_rec.attribute12 = hr_api.g_varchar2) then
478: p_rec.attribute12 :=
479: ota_cpe_shd.g_old_rec.attribute12;
480: End If;
481: If (p_rec.attribute13 = hr_api.g_varchar2) then
482: p_rec.attribute13 :=
483: ota_cpe_shd.g_old_rec.attribute13;
479: ota_cpe_shd.g_old_rec.attribute12;
480: End If;
481: If (p_rec.attribute13 = hr_api.g_varchar2) then
482: p_rec.attribute13 :=
483: ota_cpe_shd.g_old_rec.attribute13;
484: End If;
485: If (p_rec.attribute14 = hr_api.g_varchar2) then
486: p_rec.attribute14 :=
487: ota_cpe_shd.g_old_rec.attribute14;
483: ota_cpe_shd.g_old_rec.attribute13;
484: End If;
485: If (p_rec.attribute14 = hr_api.g_varchar2) then
486: p_rec.attribute14 :=
487: ota_cpe_shd.g_old_rec.attribute14;
488: End If;
489: If (p_rec.attribute15 = hr_api.g_varchar2) then
490: p_rec.attribute15 :=
491: ota_cpe_shd.g_old_rec.attribute15;
487: ota_cpe_shd.g_old_rec.attribute14;
488: End If;
489: If (p_rec.attribute15 = hr_api.g_varchar2) then
490: p_rec.attribute15 :=
491: ota_cpe_shd.g_old_rec.attribute15;
492: End If;
493: If (p_rec.attribute16 = hr_api.g_varchar2) then
494: p_rec.attribute16 :=
495: ota_cpe_shd.g_old_rec.attribute16;
491: ota_cpe_shd.g_old_rec.attribute15;
492: End If;
493: If (p_rec.attribute16 = hr_api.g_varchar2) then
494: p_rec.attribute16 :=
495: ota_cpe_shd.g_old_rec.attribute16;
496: End If;
497: If (p_rec.attribute17 = hr_api.g_varchar2) then
498: p_rec.attribute17 :=
499: ota_cpe_shd.g_old_rec.attribute17;
495: ota_cpe_shd.g_old_rec.attribute16;
496: End If;
497: If (p_rec.attribute17 = hr_api.g_varchar2) then
498: p_rec.attribute17 :=
499: ota_cpe_shd.g_old_rec.attribute17;
500: End If;
501: If (p_rec.attribute18 = hr_api.g_varchar2) then
502: p_rec.attribute18 :=
503: ota_cpe_shd.g_old_rec.attribute18;
499: ota_cpe_shd.g_old_rec.attribute17;
500: End If;
501: If (p_rec.attribute18 = hr_api.g_varchar2) then
502: p_rec.attribute18 :=
503: ota_cpe_shd.g_old_rec.attribute18;
504: End If;
505: If (p_rec.attribute19 = hr_api.g_varchar2) then
506: p_rec.attribute19 :=
507: ota_cpe_shd.g_old_rec.attribute19;
503: ota_cpe_shd.g_old_rec.attribute18;
504: End If;
505: If (p_rec.attribute19 = hr_api.g_varchar2) then
506: p_rec.attribute19 :=
507: ota_cpe_shd.g_old_rec.attribute19;
508: End If;
509: If (p_rec.attribute20 = hr_api.g_varchar2) then
510: p_rec.attribute20 :=
511: ota_cpe_shd.g_old_rec.attribute20;
507: ota_cpe_shd.g_old_rec.attribute19;
508: End If;
509: If (p_rec.attribute20 = hr_api.g_varchar2) then
510: p_rec.attribute20 :=
511: ota_cpe_shd.g_old_rec.attribute20;
512: End If;
513: If (p_rec.expiration_date = hr_api.g_date) then
514: p_rec.expiration_date :=
515: ota_cpe_shd.g_old_rec.expiration_date;
511: ota_cpe_shd.g_old_rec.attribute20;
512: End If;
513: If (p_rec.expiration_date = hr_api.g_date) then
514: p_rec.expiration_date :=
515: ota_cpe_shd.g_old_rec.expiration_date;
516: End If;
517: --
518: End convert_defs;
519: --
521: -- |---------------------------------< upd >----------------------------------|
522: -- ----------------------------------------------------------------------------
523: Procedure upd
524: (p_effective_date in date
525: ,p_rec in out nocopy ota_cpe_shd.g_rec_type
526: ) is
527: --
528: l_proc varchar2(72) := g_package||'upd';
529: --
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- We must lock the row which we need to update.
534: --
535: ota_cpe_shd.lck
536: (p_rec.cert_prd_enrollment_id
537: ,p_rec.object_version_number
538: );
539: --
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
609: ) is
610: --
611: l_rec ota_cpe_shd.g_rec_type;
612: l_proc varchar2(72) := g_package||'upd';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
617: -- Call conversion function to turn arguments into the
618: -- l_rec structure.
619: --
620: l_rec :=
621: ota_cpe_shd.convert_args
622: (p_cert_prd_enrollment_id
623: ,p_cert_enrollment_id
624: ,p_object_version_number
625: ,p_period_status_code