51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_tmp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: hr_tmp_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: hr_tmp_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: hr_tmp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update
170: (p_rec in hr_tmp_shd.g_rec_type
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update
214: (p_effective_date in date
215: ,p_rec in hr_tmp_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --
299: => p_rec.attribute29
300: ,p_attribute30
301: => p_rec.attribute30
302: ,p_object_version_number_o
303: => hr_tmp_shd.g_old_rec.object_version_number
304: ,p_application_id_o
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
301: => p_rec.attribute30
302: ,p_object_version_number_o
303: => hr_tmp_shd.g_old_rec.object_version_number
304: ,p_application_id_o
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
303: => hr_tmp_shd.g_old_rec.object_version_number
304: ,p_application_id_o
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => hr_tmp_shd.g_old_rec.attribute1
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => hr_tmp_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => hr_tmp_shd.g_old_rec.attribute2
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => hr_tmp_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => hr_tmp_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => hr_tmp_shd.g_old_rec.attribute3
315: => hr_tmp_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => hr_tmp_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => hr_tmp_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => hr_tmp_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => hr_tmp_shd.g_old_rec.attribute4
317: => hr_tmp_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => hr_tmp_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => hr_tmp_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => hr_tmp_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => hr_tmp_shd.g_old_rec.attribute5
319: => hr_tmp_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => hr_tmp_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => hr_tmp_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => hr_tmp_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => hr_tmp_shd.g_old_rec.attribute6
321: => hr_tmp_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => hr_tmp_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => hr_tmp_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => hr_tmp_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => hr_tmp_shd.g_old_rec.attribute7
323: => hr_tmp_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => hr_tmp_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => hr_tmp_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => hr_tmp_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => hr_tmp_shd.g_old_rec.attribute8
325: => hr_tmp_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => hr_tmp_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => hr_tmp_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => hr_tmp_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => hr_tmp_shd.g_old_rec.attribute9
327: => hr_tmp_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => hr_tmp_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => hr_tmp_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => hr_tmp_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => hr_tmp_shd.g_old_rec.attribute10
329: => hr_tmp_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => hr_tmp_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => hr_tmp_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => hr_tmp_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => hr_tmp_shd.g_old_rec.attribute11
331: => hr_tmp_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => hr_tmp_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => hr_tmp_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => hr_tmp_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => hr_tmp_shd.g_old_rec.attribute12
333: => hr_tmp_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => hr_tmp_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => hr_tmp_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => hr_tmp_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => hr_tmp_shd.g_old_rec.attribute13
335: => hr_tmp_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => hr_tmp_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => hr_tmp_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => hr_tmp_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => hr_tmp_shd.g_old_rec.attribute14
337: => hr_tmp_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => hr_tmp_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => hr_tmp_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => hr_tmp_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => hr_tmp_shd.g_old_rec.attribute15
339: => hr_tmp_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => hr_tmp_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => hr_tmp_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => hr_tmp_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => hr_tmp_shd.g_old_rec.attribute16
341: => hr_tmp_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => hr_tmp_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => hr_tmp_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => hr_tmp_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => hr_tmp_shd.g_old_rec.attribute17
343: => hr_tmp_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => hr_tmp_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => hr_tmp_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => hr_tmp_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => hr_tmp_shd.g_old_rec.attribute18
345: => hr_tmp_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => hr_tmp_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => hr_tmp_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => hr_tmp_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => hr_tmp_shd.g_old_rec.attribute19
347: => hr_tmp_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => hr_tmp_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => hr_tmp_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
349: => hr_tmp_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => hr_tmp_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
351: => hr_tmp_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => hr_tmp_shd.g_old_rec.attribute30
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => hr_tmp_shd.g_old_rec.attribute30
376: );
377: --
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => hr_tmp_shd.g_old_rec.attribute30
376: );
377: --
378: exception
379: --
431: --
432: -- {End Of Comments}
433: -- ----------------------------------------------------------------------------
434: Procedure convert_defs
435: (p_rec in out nocopy hr_tmp_shd.g_rec_type
436: ) is
437: --
438: Begin
439: --
443: -- is being used then we must set to the 'current' argument value.
444: --
445: If (p_rec.application_id = hr_api.g_number) then
446: p_rec.application_id :=
447: hr_tmp_shd.g_old_rec.application_id;
448: End If;
449: If (p_rec.form_id = hr_api.g_number) then
450: p_rec.form_id :=
451: hr_tmp_shd.g_old_rec.form_id;
447: hr_tmp_shd.g_old_rec.application_id;
448: End If;
449: If (p_rec.form_id = hr_api.g_number) then
450: p_rec.form_id :=
451: hr_tmp_shd.g_old_rec.form_id;
452: End If;
453: If (p_rec.template_name = hr_api.g_varchar2) then
454: p_rec.template_name :=
455: hr_tmp_shd.g_old_rec.template_name;
451: hr_tmp_shd.g_old_rec.form_id;
452: End If;
453: If (p_rec.template_name = hr_api.g_varchar2) then
454: p_rec.template_name :=
455: hr_tmp_shd.g_old_rec.template_name;
456: End If;
457: If (p_rec.enabled_flag = hr_api.g_varchar2) then
458: p_rec.enabled_flag :=
459: hr_tmp_shd.g_old_rec.enabled_flag;
455: hr_tmp_shd.g_old_rec.template_name;
456: End If;
457: If (p_rec.enabled_flag = hr_api.g_varchar2) then
458: p_rec.enabled_flag :=
459: hr_tmp_shd.g_old_rec.enabled_flag;
460: End If;
461: If (p_rec.legislation_code = hr_api.g_varchar2) then
462: p_rec.legislation_code :=
463: hr_tmp_shd.g_old_rec.legislation_code;
459: hr_tmp_shd.g_old_rec.enabled_flag;
460: End If;
461: If (p_rec.legislation_code = hr_api.g_varchar2) then
462: p_rec.legislation_code :=
463: hr_tmp_shd.g_old_rec.legislation_code;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: hr_tmp_shd.g_old_rec.attribute_category;
463: hr_tmp_shd.g_old_rec.legislation_code;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: hr_tmp_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: hr_tmp_shd.g_old_rec.attribute1;
467: hr_tmp_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: hr_tmp_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: hr_tmp_shd.g_old_rec.attribute2;
471: hr_tmp_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: hr_tmp_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: hr_tmp_shd.g_old_rec.attribute3;
475: hr_tmp_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: hr_tmp_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: hr_tmp_shd.g_old_rec.attribute4;
479: hr_tmp_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: hr_tmp_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: hr_tmp_shd.g_old_rec.attribute5;
483: hr_tmp_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: hr_tmp_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: hr_tmp_shd.g_old_rec.attribute6;
487: hr_tmp_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: hr_tmp_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: hr_tmp_shd.g_old_rec.attribute7;
491: hr_tmp_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: hr_tmp_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: hr_tmp_shd.g_old_rec.attribute8;
495: hr_tmp_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: hr_tmp_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: hr_tmp_shd.g_old_rec.attribute9;
499: hr_tmp_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: hr_tmp_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: hr_tmp_shd.g_old_rec.attribute10;
503: hr_tmp_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: hr_tmp_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: hr_tmp_shd.g_old_rec.attribute11;
507: hr_tmp_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: hr_tmp_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: hr_tmp_shd.g_old_rec.attribute12;
511: hr_tmp_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: hr_tmp_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: hr_tmp_shd.g_old_rec.attribute13;
515: hr_tmp_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: hr_tmp_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: hr_tmp_shd.g_old_rec.attribute14;
519: hr_tmp_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: hr_tmp_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: hr_tmp_shd.g_old_rec.attribute15;
523: hr_tmp_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: hr_tmp_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: hr_tmp_shd.g_old_rec.attribute16;
527: hr_tmp_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: hr_tmp_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: hr_tmp_shd.g_old_rec.attribute17;
531: hr_tmp_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: hr_tmp_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: hr_tmp_shd.g_old_rec.attribute18;
535: hr_tmp_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: hr_tmp_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: hr_tmp_shd.g_old_rec.attribute19;
539: hr_tmp_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: hr_tmp_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: hr_tmp_shd.g_old_rec.attribute20;
543: hr_tmp_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: hr_tmp_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.attribute21 = hr_api.g_varchar2) then
550: p_rec.attribute21 :=
551: hr_tmp_shd.g_old_rec.attribute21;
547: hr_tmp_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.attribute21 = hr_api.g_varchar2) then
550: p_rec.attribute21 :=
551: hr_tmp_shd.g_old_rec.attribute21;
552: End If;
553: If (p_rec.attribute22 = hr_api.g_varchar2) then
554: p_rec.attribute22 :=
555: hr_tmp_shd.g_old_rec.attribute22;
551: hr_tmp_shd.g_old_rec.attribute21;
552: End If;
553: If (p_rec.attribute22 = hr_api.g_varchar2) then
554: p_rec.attribute22 :=
555: hr_tmp_shd.g_old_rec.attribute22;
556: End If;
557: If (p_rec.attribute23 = hr_api.g_varchar2) then
558: p_rec.attribute23 :=
559: hr_tmp_shd.g_old_rec.attribute23;
555: hr_tmp_shd.g_old_rec.attribute22;
556: End If;
557: If (p_rec.attribute23 = hr_api.g_varchar2) then
558: p_rec.attribute23 :=
559: hr_tmp_shd.g_old_rec.attribute23;
560: End If;
561: If (p_rec.attribute24 = hr_api.g_varchar2) then
562: p_rec.attribute24 :=
563: hr_tmp_shd.g_old_rec.attribute24;
559: hr_tmp_shd.g_old_rec.attribute23;
560: End If;
561: If (p_rec.attribute24 = hr_api.g_varchar2) then
562: p_rec.attribute24 :=
563: hr_tmp_shd.g_old_rec.attribute24;
564: End If;
565: If (p_rec.attribute25 = hr_api.g_varchar2) then
566: p_rec.attribute25 :=
567: hr_tmp_shd.g_old_rec.attribute25;
563: hr_tmp_shd.g_old_rec.attribute24;
564: End If;
565: If (p_rec.attribute25 = hr_api.g_varchar2) then
566: p_rec.attribute25 :=
567: hr_tmp_shd.g_old_rec.attribute25;
568: End If;
569: If (p_rec.attribute26 = hr_api.g_varchar2) then
570: p_rec.attribute26 :=
571: hr_tmp_shd.g_old_rec.attribute26;
567: hr_tmp_shd.g_old_rec.attribute25;
568: End If;
569: If (p_rec.attribute26 = hr_api.g_varchar2) then
570: p_rec.attribute26 :=
571: hr_tmp_shd.g_old_rec.attribute26;
572: End If;
573: If (p_rec.attribute27 = hr_api.g_varchar2) then
574: p_rec.attribute27 :=
575: hr_tmp_shd.g_old_rec.attribute27;
571: hr_tmp_shd.g_old_rec.attribute26;
572: End If;
573: If (p_rec.attribute27 = hr_api.g_varchar2) then
574: p_rec.attribute27 :=
575: hr_tmp_shd.g_old_rec.attribute27;
576: End If;
577: If (p_rec.attribute28 = hr_api.g_varchar2) then
578: p_rec.attribute28 :=
579: hr_tmp_shd.g_old_rec.attribute28;
575: hr_tmp_shd.g_old_rec.attribute27;
576: End If;
577: If (p_rec.attribute28 = hr_api.g_varchar2) then
578: p_rec.attribute28 :=
579: hr_tmp_shd.g_old_rec.attribute28;
580: End If;
581: If (p_rec.attribute29 = hr_api.g_varchar2) then
582: p_rec.attribute29 :=
583: hr_tmp_shd.g_old_rec.attribute29;
579: hr_tmp_shd.g_old_rec.attribute28;
580: End If;
581: If (p_rec.attribute29 = hr_api.g_varchar2) then
582: p_rec.attribute29 :=
583: hr_tmp_shd.g_old_rec.attribute29;
584: End If;
585: If (p_rec.attribute30 = hr_api.g_varchar2) then
586: p_rec.attribute30 :=
587: hr_tmp_shd.g_old_rec.attribute30;
583: hr_tmp_shd.g_old_rec.attribute29;
584: End If;
585: If (p_rec.attribute30 = hr_api.g_varchar2) then
586: p_rec.attribute30 :=
587: hr_tmp_shd.g_old_rec.attribute30;
588: End If;
589: --
590: End convert_defs;
591: --
593: -- |---------------------------------< upd >----------------------------------|
594: -- ----------------------------------------------------------------------------
595: Procedure upd
596: (p_effective_date in date
597: ,p_rec in out nocopy hr_tmp_shd.g_rec_type
598: ) is
599: --
600: l_proc varchar2(72) := g_package||'upd';
601: --
603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: -- We must lock the row which we need to update.
606: --
607: hr_tmp_shd.lck
608: (p_rec.form_template_id
609: ,p_rec.object_version_number
610: );
611: --
681: ,p_attribute29 in varchar2 default hr_api.g_varchar2
682: ,p_attribute30 in varchar2 default hr_api.g_varchar2
683: ) is
684: --
685: l_rec hr_tmp_shd.g_rec_type;
686: l_proc varchar2(72) := g_package||'upd';
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
691: -- Call conversion function to turn arguments into the
692: -- l_rec structure.
693: --
694: l_rec :=
695: hr_tmp_shd.convert_args
696: (p_form_template_id
697: ,p_object_version_number
698: ,p_application_id
699: ,p_form_id