[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_psu_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: --
129: pqh_psu_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqh_psu_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqh_psu_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: --
143: Raise;
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure pre_update
179: (p_rec in pqh_psu_shd.g_rec_type
180: ) is
181: --
182: l_proc varchar2(72) := g_package||'pre_update';
183: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure post_update
223: (p_effective_date in date
224: ,p_rec in pqh_psu_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'post_update';
228: --
326: => p_rec.attribute30
327: ,p_object_version_number
328: => p_rec.object_version_number
329: ,p_statutory_situation_id_o
330: => pqh_psu_shd.g_old_rec.statutory_situation_id
331: ,p_person_id_o
332: => pqh_psu_shd.g_old_rec.person_id
333: ,p_provisional_start_date_o
334: => pqh_psu_shd.g_old_rec.provisional_start_date
328: => p_rec.object_version_number
329: ,p_statutory_situation_id_o
330: => pqh_psu_shd.g_old_rec.statutory_situation_id
331: ,p_person_id_o
332: => pqh_psu_shd.g_old_rec.person_id
333: ,p_provisional_start_date_o
334: => pqh_psu_shd.g_old_rec.provisional_start_date
335: ,p_provisional_end_date_o
336: => pqh_psu_shd.g_old_rec.provisional_end_date
330: => pqh_psu_shd.g_old_rec.statutory_situation_id
331: ,p_person_id_o
332: => pqh_psu_shd.g_old_rec.person_id
333: ,p_provisional_start_date_o
334: => pqh_psu_shd.g_old_rec.provisional_start_date
335: ,p_provisional_end_date_o
336: => pqh_psu_shd.g_old_rec.provisional_end_date
337: ,p_actual_start_date_o
338: => pqh_psu_shd.g_old_rec.actual_start_date
332: => pqh_psu_shd.g_old_rec.person_id
333: ,p_provisional_start_date_o
334: => pqh_psu_shd.g_old_rec.provisional_start_date
335: ,p_provisional_end_date_o
336: => pqh_psu_shd.g_old_rec.provisional_end_date
337: ,p_actual_start_date_o
338: => pqh_psu_shd.g_old_rec.actual_start_date
339: ,p_actual_end_date_o
340: => pqh_psu_shd.g_old_rec.actual_end_date
334: => pqh_psu_shd.g_old_rec.provisional_start_date
335: ,p_provisional_end_date_o
336: => pqh_psu_shd.g_old_rec.provisional_end_date
337: ,p_actual_start_date_o
338: => pqh_psu_shd.g_old_rec.actual_start_date
339: ,p_actual_end_date_o
340: => pqh_psu_shd.g_old_rec.actual_end_date
341: ,p_approval_flag_o
342: => pqh_psu_shd.g_old_rec.approval_flag
336: => pqh_psu_shd.g_old_rec.provisional_end_date
337: ,p_actual_start_date_o
338: => pqh_psu_shd.g_old_rec.actual_start_date
339: ,p_actual_end_date_o
340: => pqh_psu_shd.g_old_rec.actual_end_date
341: ,p_approval_flag_o
342: => pqh_psu_shd.g_old_rec.approval_flag
343: ,p_comments_o
344: => pqh_psu_shd.g_old_rec.comments
338: => pqh_psu_shd.g_old_rec.actual_start_date
339: ,p_actual_end_date_o
340: => pqh_psu_shd.g_old_rec.actual_end_date
341: ,p_approval_flag_o
342: => pqh_psu_shd.g_old_rec.approval_flag
343: ,p_comments_o
344: => pqh_psu_shd.g_old_rec.comments
345: ,p_contact_person_id_o
346: => pqh_psu_shd.g_old_rec.contact_person_id
340: => pqh_psu_shd.g_old_rec.actual_end_date
341: ,p_approval_flag_o
342: => pqh_psu_shd.g_old_rec.approval_flag
343: ,p_comments_o
344: => pqh_psu_shd.g_old_rec.comments
345: ,p_contact_person_id_o
346: => pqh_psu_shd.g_old_rec.contact_person_id
347: ,p_contact_relationship_o
348: => pqh_psu_shd.g_old_rec.contact_relationship
342: => pqh_psu_shd.g_old_rec.approval_flag
343: ,p_comments_o
344: => pqh_psu_shd.g_old_rec.comments
345: ,p_contact_person_id_o
346: => pqh_psu_shd.g_old_rec.contact_person_id
347: ,p_contact_relationship_o
348: => pqh_psu_shd.g_old_rec.contact_relationship
349: ,p_external_organization_id_o
350: => pqh_psu_shd.g_old_rec.external_organization_id
344: => pqh_psu_shd.g_old_rec.comments
345: ,p_contact_person_id_o
346: => pqh_psu_shd.g_old_rec.contact_person_id
347: ,p_contact_relationship_o
348: => pqh_psu_shd.g_old_rec.contact_relationship
349: ,p_external_organization_id_o
350: => pqh_psu_shd.g_old_rec.external_organization_id
351: ,p_renewal_flag_o
352: => pqh_psu_shd.g_old_rec.renewal_flag
346: => pqh_psu_shd.g_old_rec.contact_person_id
347: ,p_contact_relationship_o
348: => pqh_psu_shd.g_old_rec.contact_relationship
349: ,p_external_organization_id_o
350: => pqh_psu_shd.g_old_rec.external_organization_id
351: ,p_renewal_flag_o
352: => pqh_psu_shd.g_old_rec.renewal_flag
353: ,p_renew_stat_situation_id_o
354: => pqh_psu_shd.g_old_rec.renew_stat_situation_id
348: => pqh_psu_shd.g_old_rec.contact_relationship
349: ,p_external_organization_id_o
350: => pqh_psu_shd.g_old_rec.external_organization_id
351: ,p_renewal_flag_o
352: => pqh_psu_shd.g_old_rec.renewal_flag
353: ,p_renew_stat_situation_id_o
354: => pqh_psu_shd.g_old_rec.renew_stat_situation_id
355: ,p_seconded_career_id_o
356: => pqh_psu_shd.g_old_rec.seconded_career_id
350: => pqh_psu_shd.g_old_rec.external_organization_id
351: ,p_renewal_flag_o
352: => pqh_psu_shd.g_old_rec.renewal_flag
353: ,p_renew_stat_situation_id_o
354: => pqh_psu_shd.g_old_rec.renew_stat_situation_id
355: ,p_seconded_career_id_o
356: => pqh_psu_shd.g_old_rec.seconded_career_id
357: ,p_attribute_category_o
358: => pqh_psu_shd.g_old_rec.attribute_category
352: => pqh_psu_shd.g_old_rec.renewal_flag
353: ,p_renew_stat_situation_id_o
354: => pqh_psu_shd.g_old_rec.renew_stat_situation_id
355: ,p_seconded_career_id_o
356: => pqh_psu_shd.g_old_rec.seconded_career_id
357: ,p_attribute_category_o
358: => pqh_psu_shd.g_old_rec.attribute_category
359: ,p_attribute1_o
360: => pqh_psu_shd.g_old_rec.attribute1
354: => pqh_psu_shd.g_old_rec.renew_stat_situation_id
355: ,p_seconded_career_id_o
356: => pqh_psu_shd.g_old_rec.seconded_career_id
357: ,p_attribute_category_o
358: => pqh_psu_shd.g_old_rec.attribute_category
359: ,p_attribute1_o
360: => pqh_psu_shd.g_old_rec.attribute1
361: ,p_attribute2_o
362: => pqh_psu_shd.g_old_rec.attribute2
356: => pqh_psu_shd.g_old_rec.seconded_career_id
357: ,p_attribute_category_o
358: => pqh_psu_shd.g_old_rec.attribute_category
359: ,p_attribute1_o
360: => pqh_psu_shd.g_old_rec.attribute1
361: ,p_attribute2_o
362: => pqh_psu_shd.g_old_rec.attribute2
363: ,p_attribute3_o
364: => pqh_psu_shd.g_old_rec.attribute3
358: => pqh_psu_shd.g_old_rec.attribute_category
359: ,p_attribute1_o
360: => pqh_psu_shd.g_old_rec.attribute1
361: ,p_attribute2_o
362: => pqh_psu_shd.g_old_rec.attribute2
363: ,p_attribute3_o
364: => pqh_psu_shd.g_old_rec.attribute3
365: ,p_attribute4_o
366: => pqh_psu_shd.g_old_rec.attribute4
360: => pqh_psu_shd.g_old_rec.attribute1
361: ,p_attribute2_o
362: => pqh_psu_shd.g_old_rec.attribute2
363: ,p_attribute3_o
364: => pqh_psu_shd.g_old_rec.attribute3
365: ,p_attribute4_o
366: => pqh_psu_shd.g_old_rec.attribute4
367: ,p_attribute5_o
368: => pqh_psu_shd.g_old_rec.attribute5
362: => pqh_psu_shd.g_old_rec.attribute2
363: ,p_attribute3_o
364: => pqh_psu_shd.g_old_rec.attribute3
365: ,p_attribute4_o
366: => pqh_psu_shd.g_old_rec.attribute4
367: ,p_attribute5_o
368: => pqh_psu_shd.g_old_rec.attribute5
369: ,p_attribute6_o
370: => pqh_psu_shd.g_old_rec.attribute6
364: => pqh_psu_shd.g_old_rec.attribute3
365: ,p_attribute4_o
366: => pqh_psu_shd.g_old_rec.attribute4
367: ,p_attribute5_o
368: => pqh_psu_shd.g_old_rec.attribute5
369: ,p_attribute6_o
370: => pqh_psu_shd.g_old_rec.attribute6
371: ,p_attribute7_o
372: => pqh_psu_shd.g_old_rec.attribute7
366: => pqh_psu_shd.g_old_rec.attribute4
367: ,p_attribute5_o
368: => pqh_psu_shd.g_old_rec.attribute5
369: ,p_attribute6_o
370: => pqh_psu_shd.g_old_rec.attribute6
371: ,p_attribute7_o
372: => pqh_psu_shd.g_old_rec.attribute7
373: ,p_attribute8_o
374: => pqh_psu_shd.g_old_rec.attribute8
368: => pqh_psu_shd.g_old_rec.attribute5
369: ,p_attribute6_o
370: => pqh_psu_shd.g_old_rec.attribute6
371: ,p_attribute7_o
372: => pqh_psu_shd.g_old_rec.attribute7
373: ,p_attribute8_o
374: => pqh_psu_shd.g_old_rec.attribute8
375: ,p_attribute9_o
376: => pqh_psu_shd.g_old_rec.attribute9
370: => pqh_psu_shd.g_old_rec.attribute6
371: ,p_attribute7_o
372: => pqh_psu_shd.g_old_rec.attribute7
373: ,p_attribute8_o
374: => pqh_psu_shd.g_old_rec.attribute8
375: ,p_attribute9_o
376: => pqh_psu_shd.g_old_rec.attribute9
377: ,p_attribute10_o
378: => pqh_psu_shd.g_old_rec.attribute10
372: => pqh_psu_shd.g_old_rec.attribute7
373: ,p_attribute8_o
374: => pqh_psu_shd.g_old_rec.attribute8
375: ,p_attribute9_o
376: => pqh_psu_shd.g_old_rec.attribute9
377: ,p_attribute10_o
378: => pqh_psu_shd.g_old_rec.attribute10
379: ,p_attribute11_o
380: => pqh_psu_shd.g_old_rec.attribute11
374: => pqh_psu_shd.g_old_rec.attribute8
375: ,p_attribute9_o
376: => pqh_psu_shd.g_old_rec.attribute9
377: ,p_attribute10_o
378: => pqh_psu_shd.g_old_rec.attribute10
379: ,p_attribute11_o
380: => pqh_psu_shd.g_old_rec.attribute11
381: ,p_attribute12_o
382: => pqh_psu_shd.g_old_rec.attribute12
376: => pqh_psu_shd.g_old_rec.attribute9
377: ,p_attribute10_o
378: => pqh_psu_shd.g_old_rec.attribute10
379: ,p_attribute11_o
380: => pqh_psu_shd.g_old_rec.attribute11
381: ,p_attribute12_o
382: => pqh_psu_shd.g_old_rec.attribute12
383: ,p_attribute13_o
384: => pqh_psu_shd.g_old_rec.attribute13
378: => pqh_psu_shd.g_old_rec.attribute10
379: ,p_attribute11_o
380: => pqh_psu_shd.g_old_rec.attribute11
381: ,p_attribute12_o
382: => pqh_psu_shd.g_old_rec.attribute12
383: ,p_attribute13_o
384: => pqh_psu_shd.g_old_rec.attribute13
385: ,p_attribute14_o
386: => pqh_psu_shd.g_old_rec.attribute14
380: => pqh_psu_shd.g_old_rec.attribute11
381: ,p_attribute12_o
382: => pqh_psu_shd.g_old_rec.attribute12
383: ,p_attribute13_o
384: => pqh_psu_shd.g_old_rec.attribute13
385: ,p_attribute14_o
386: => pqh_psu_shd.g_old_rec.attribute14
387: ,p_attribute15_o
388: => pqh_psu_shd.g_old_rec.attribute15
382: => pqh_psu_shd.g_old_rec.attribute12
383: ,p_attribute13_o
384: => pqh_psu_shd.g_old_rec.attribute13
385: ,p_attribute14_o
386: => pqh_psu_shd.g_old_rec.attribute14
387: ,p_attribute15_o
388: => pqh_psu_shd.g_old_rec.attribute15
389: ,p_attribute16_o
390: => pqh_psu_shd.g_old_rec.attribute16
384: => pqh_psu_shd.g_old_rec.attribute13
385: ,p_attribute14_o
386: => pqh_psu_shd.g_old_rec.attribute14
387: ,p_attribute15_o
388: => pqh_psu_shd.g_old_rec.attribute15
389: ,p_attribute16_o
390: => pqh_psu_shd.g_old_rec.attribute16
391: ,p_attribute17_o
392: => pqh_psu_shd.g_old_rec.attribute17
386: => pqh_psu_shd.g_old_rec.attribute14
387: ,p_attribute15_o
388: => pqh_psu_shd.g_old_rec.attribute15
389: ,p_attribute16_o
390: => pqh_psu_shd.g_old_rec.attribute16
391: ,p_attribute17_o
392: => pqh_psu_shd.g_old_rec.attribute17
393: ,p_attribute18_o
394: => pqh_psu_shd.g_old_rec.attribute18
388: => pqh_psu_shd.g_old_rec.attribute15
389: ,p_attribute16_o
390: => pqh_psu_shd.g_old_rec.attribute16
391: ,p_attribute17_o
392: => pqh_psu_shd.g_old_rec.attribute17
393: ,p_attribute18_o
394: => pqh_psu_shd.g_old_rec.attribute18
395: ,p_attribute19_o
396: => pqh_psu_shd.g_old_rec.attribute19
390: => pqh_psu_shd.g_old_rec.attribute16
391: ,p_attribute17_o
392: => pqh_psu_shd.g_old_rec.attribute17
393: ,p_attribute18_o
394: => pqh_psu_shd.g_old_rec.attribute18
395: ,p_attribute19_o
396: => pqh_psu_shd.g_old_rec.attribute19
397: ,p_attribute20_o
398: => pqh_psu_shd.g_old_rec.attribute20
392: => pqh_psu_shd.g_old_rec.attribute17
393: ,p_attribute18_o
394: => pqh_psu_shd.g_old_rec.attribute18
395: ,p_attribute19_o
396: => pqh_psu_shd.g_old_rec.attribute19
397: ,p_attribute20_o
398: => pqh_psu_shd.g_old_rec.attribute20
399: ,p_attribute21_o
400: => pqh_psu_shd.g_old_rec.attribute21
394: => pqh_psu_shd.g_old_rec.attribute18
395: ,p_attribute19_o
396: => pqh_psu_shd.g_old_rec.attribute19
397: ,p_attribute20_o
398: => pqh_psu_shd.g_old_rec.attribute20
399: ,p_attribute21_o
400: => pqh_psu_shd.g_old_rec.attribute21
401: ,p_attribute22_o
402: => pqh_psu_shd.g_old_rec.attribute22
396: => pqh_psu_shd.g_old_rec.attribute19
397: ,p_attribute20_o
398: => pqh_psu_shd.g_old_rec.attribute20
399: ,p_attribute21_o
400: => pqh_psu_shd.g_old_rec.attribute21
401: ,p_attribute22_o
402: => pqh_psu_shd.g_old_rec.attribute22
403: ,p_attribute23_o
404: => pqh_psu_shd.g_old_rec.attribute23
398: => pqh_psu_shd.g_old_rec.attribute20
399: ,p_attribute21_o
400: => pqh_psu_shd.g_old_rec.attribute21
401: ,p_attribute22_o
402: => pqh_psu_shd.g_old_rec.attribute22
403: ,p_attribute23_o
404: => pqh_psu_shd.g_old_rec.attribute23
405: ,p_attribute24_o
406: => pqh_psu_shd.g_old_rec.attribute24
400: => pqh_psu_shd.g_old_rec.attribute21
401: ,p_attribute22_o
402: => pqh_psu_shd.g_old_rec.attribute22
403: ,p_attribute23_o
404: => pqh_psu_shd.g_old_rec.attribute23
405: ,p_attribute24_o
406: => pqh_psu_shd.g_old_rec.attribute24
407: ,p_attribute25_o
408: => pqh_psu_shd.g_old_rec.attribute25
402: => pqh_psu_shd.g_old_rec.attribute22
403: ,p_attribute23_o
404: => pqh_psu_shd.g_old_rec.attribute23
405: ,p_attribute24_o
406: => pqh_psu_shd.g_old_rec.attribute24
407: ,p_attribute25_o
408: => pqh_psu_shd.g_old_rec.attribute25
409: ,p_attribute26_o
410: => pqh_psu_shd.g_old_rec.attribute26
404: => pqh_psu_shd.g_old_rec.attribute23
405: ,p_attribute24_o
406: => pqh_psu_shd.g_old_rec.attribute24
407: ,p_attribute25_o
408: => pqh_psu_shd.g_old_rec.attribute25
409: ,p_attribute26_o
410: => pqh_psu_shd.g_old_rec.attribute26
411: ,p_attribute27_o
412: => pqh_psu_shd.g_old_rec.attribute27
406: => pqh_psu_shd.g_old_rec.attribute24
407: ,p_attribute25_o
408: => pqh_psu_shd.g_old_rec.attribute25
409: ,p_attribute26_o
410: => pqh_psu_shd.g_old_rec.attribute26
411: ,p_attribute27_o
412: => pqh_psu_shd.g_old_rec.attribute27
413: ,p_attribute28_o
414: => pqh_psu_shd.g_old_rec.attribute28
408: => pqh_psu_shd.g_old_rec.attribute25
409: ,p_attribute26_o
410: => pqh_psu_shd.g_old_rec.attribute26
411: ,p_attribute27_o
412: => pqh_psu_shd.g_old_rec.attribute27
413: ,p_attribute28_o
414: => pqh_psu_shd.g_old_rec.attribute28
415: ,p_attribute29_o
416: => pqh_psu_shd.g_old_rec.attribute29
410: => pqh_psu_shd.g_old_rec.attribute26
411: ,p_attribute27_o
412: => pqh_psu_shd.g_old_rec.attribute27
413: ,p_attribute28_o
414: => pqh_psu_shd.g_old_rec.attribute28
415: ,p_attribute29_o
416: => pqh_psu_shd.g_old_rec.attribute29
417: ,p_attribute30_o
418: => pqh_psu_shd.g_old_rec.attribute30
412: => pqh_psu_shd.g_old_rec.attribute27
413: ,p_attribute28_o
414: => pqh_psu_shd.g_old_rec.attribute28
415: ,p_attribute29_o
416: => pqh_psu_shd.g_old_rec.attribute29
417: ,p_attribute30_o
418: => pqh_psu_shd.g_old_rec.attribute30
419: ,p_object_version_number_o
420: => pqh_psu_shd.g_old_rec.object_version_number
414: => pqh_psu_shd.g_old_rec.attribute28
415: ,p_attribute29_o
416: => pqh_psu_shd.g_old_rec.attribute29
417: ,p_attribute30_o
418: => pqh_psu_shd.g_old_rec.attribute30
419: ,p_object_version_number_o
420: => pqh_psu_shd.g_old_rec.object_version_number
421: );
422: --
416: => pqh_psu_shd.g_old_rec.attribute29
417: ,p_attribute30_o
418: => pqh_psu_shd.g_old_rec.attribute30
419: ,p_object_version_number_o
420: => pqh_psu_shd.g_old_rec.object_version_number
421: );
422: --
423: exception
424: --
476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure convert_defs
480: (p_rec in out nocopy pqh_psu_shd.g_rec_type
481: ) is
482: --
483: Begin
484: --
488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.statutory_situation_id = hr_api.g_number) then
491: p_rec.statutory_situation_id :=
492: pqh_psu_shd.g_old_rec.statutory_situation_id;
493: End If;
494: If (p_rec.person_id = hr_api.g_number) then
495: p_rec.person_id :=
496: pqh_psu_shd.g_old_rec.person_id;
492: pqh_psu_shd.g_old_rec.statutory_situation_id;
493: End If;
494: If (p_rec.person_id = hr_api.g_number) then
495: p_rec.person_id :=
496: pqh_psu_shd.g_old_rec.person_id;
497: End If;
498: If (p_rec.provisional_start_date = hr_api.g_date) then
499: p_rec.provisional_start_date :=
500: pqh_psu_shd.g_old_rec.provisional_start_date;
496: pqh_psu_shd.g_old_rec.person_id;
497: End If;
498: If (p_rec.provisional_start_date = hr_api.g_date) then
499: p_rec.provisional_start_date :=
500: pqh_psu_shd.g_old_rec.provisional_start_date;
501: End If;
502: If (p_rec.provisional_end_date = hr_api.g_date) then
503: p_rec.provisional_end_date :=
504: pqh_psu_shd.g_old_rec.provisional_end_date;
500: pqh_psu_shd.g_old_rec.provisional_start_date;
501: End If;
502: If (p_rec.provisional_end_date = hr_api.g_date) then
503: p_rec.provisional_end_date :=
504: pqh_psu_shd.g_old_rec.provisional_end_date;
505: End If;
506: If (p_rec.actual_start_date = hr_api.g_date) then
507: p_rec.actual_start_date :=
508: pqh_psu_shd.g_old_rec.actual_start_date;
504: pqh_psu_shd.g_old_rec.provisional_end_date;
505: End If;
506: If (p_rec.actual_start_date = hr_api.g_date) then
507: p_rec.actual_start_date :=
508: pqh_psu_shd.g_old_rec.actual_start_date;
509: End If;
510: If (p_rec.actual_end_date = hr_api.g_date) then
511: p_rec.actual_end_date :=
512: pqh_psu_shd.g_old_rec.actual_end_date;
508: pqh_psu_shd.g_old_rec.actual_start_date;
509: End If;
510: If (p_rec.actual_end_date = hr_api.g_date) then
511: p_rec.actual_end_date :=
512: pqh_psu_shd.g_old_rec.actual_end_date;
513: End If;
514: If (p_rec.approval_flag = hr_api.g_varchar2) then
515: p_rec.approval_flag :=
516: pqh_psu_shd.g_old_rec.approval_flag;
512: pqh_psu_shd.g_old_rec.actual_end_date;
513: End If;
514: If (p_rec.approval_flag = hr_api.g_varchar2) then
515: p_rec.approval_flag :=
516: pqh_psu_shd.g_old_rec.approval_flag;
517: End If;
518: If (p_rec.comments = hr_api.g_varchar2) then
519: p_rec.comments :=
520: pqh_psu_shd.g_old_rec.comments;
516: pqh_psu_shd.g_old_rec.approval_flag;
517: End If;
518: If (p_rec.comments = hr_api.g_varchar2) then
519: p_rec.comments :=
520: pqh_psu_shd.g_old_rec.comments;
521: End If;
522: If (p_rec.contact_person_id = hr_api.g_number) then
523: p_rec.contact_person_id :=
524: pqh_psu_shd.g_old_rec.contact_person_id;
520: pqh_psu_shd.g_old_rec.comments;
521: End If;
522: If (p_rec.contact_person_id = hr_api.g_number) then
523: p_rec.contact_person_id :=
524: pqh_psu_shd.g_old_rec.contact_person_id;
525: End If;
526: If (p_rec.contact_relationship = hr_api.g_varchar2) then
527: p_rec.contact_relationship :=
528: pqh_psu_shd.g_old_rec.contact_relationship;
524: pqh_psu_shd.g_old_rec.contact_person_id;
525: End If;
526: If (p_rec.contact_relationship = hr_api.g_varchar2) then
527: p_rec.contact_relationship :=
528: pqh_psu_shd.g_old_rec.contact_relationship;
529: End If;
530: If (p_rec.external_organization_id = hr_api.g_number) then
531: p_rec.external_organization_id :=
532: pqh_psu_shd.g_old_rec.external_organization_id;
528: pqh_psu_shd.g_old_rec.contact_relationship;
529: End If;
530: If (p_rec.external_organization_id = hr_api.g_number) then
531: p_rec.external_organization_id :=
532: pqh_psu_shd.g_old_rec.external_organization_id;
533: End If;
534: If (p_rec.renewal_flag = hr_api.g_varchar2) then
535: p_rec.renewal_flag :=
536: pqh_psu_shd.g_old_rec.renewal_flag;
532: pqh_psu_shd.g_old_rec.external_organization_id;
533: End If;
534: If (p_rec.renewal_flag = hr_api.g_varchar2) then
535: p_rec.renewal_flag :=
536: pqh_psu_shd.g_old_rec.renewal_flag;
537: End If;
538: If (p_rec.renew_stat_situation_id = hr_api.g_number) then
539: p_rec.renew_stat_situation_id :=
540: pqh_psu_shd.g_old_rec.renew_stat_situation_id;
536: pqh_psu_shd.g_old_rec.renewal_flag;
537: End If;
538: If (p_rec.renew_stat_situation_id = hr_api.g_number) then
539: p_rec.renew_stat_situation_id :=
540: pqh_psu_shd.g_old_rec.renew_stat_situation_id;
541: End If;
542: If (p_rec.seconded_career_id = hr_api.g_number) then
543: p_rec.seconded_career_id :=
544: pqh_psu_shd.g_old_rec.seconded_career_id;
540: pqh_psu_shd.g_old_rec.renew_stat_situation_id;
541: End If;
542: If (p_rec.seconded_career_id = hr_api.g_number) then
543: p_rec.seconded_career_id :=
544: pqh_psu_shd.g_old_rec.seconded_career_id;
545: End If;
546: If (p_rec.attribute_category = hr_api.g_varchar2) then
547: p_rec.attribute_category :=
548: pqh_psu_shd.g_old_rec.attribute_category;
544: pqh_psu_shd.g_old_rec.seconded_career_id;
545: End If;
546: If (p_rec.attribute_category = hr_api.g_varchar2) then
547: p_rec.attribute_category :=
548: pqh_psu_shd.g_old_rec.attribute_category;
549: End If;
550: If (p_rec.attribute1 = hr_api.g_varchar2) then
551: p_rec.attribute1 :=
552: pqh_psu_shd.g_old_rec.attribute1;
548: pqh_psu_shd.g_old_rec.attribute_category;
549: End If;
550: If (p_rec.attribute1 = hr_api.g_varchar2) then
551: p_rec.attribute1 :=
552: pqh_psu_shd.g_old_rec.attribute1;
553: End If;
554: If (p_rec.attribute2 = hr_api.g_varchar2) then
555: p_rec.attribute2 :=
556: pqh_psu_shd.g_old_rec.attribute2;
552: pqh_psu_shd.g_old_rec.attribute1;
553: End If;
554: If (p_rec.attribute2 = hr_api.g_varchar2) then
555: p_rec.attribute2 :=
556: pqh_psu_shd.g_old_rec.attribute2;
557: End If;
558: If (p_rec.attribute3 = hr_api.g_varchar2) then
559: p_rec.attribute3 :=
560: pqh_psu_shd.g_old_rec.attribute3;
556: pqh_psu_shd.g_old_rec.attribute2;
557: End If;
558: If (p_rec.attribute3 = hr_api.g_varchar2) then
559: p_rec.attribute3 :=
560: pqh_psu_shd.g_old_rec.attribute3;
561: End If;
562: If (p_rec.attribute4 = hr_api.g_varchar2) then
563: p_rec.attribute4 :=
564: pqh_psu_shd.g_old_rec.attribute4;
560: pqh_psu_shd.g_old_rec.attribute3;
561: End If;
562: If (p_rec.attribute4 = hr_api.g_varchar2) then
563: p_rec.attribute4 :=
564: pqh_psu_shd.g_old_rec.attribute4;
565: End If;
566: If (p_rec.attribute5 = hr_api.g_varchar2) then
567: p_rec.attribute5 :=
568: pqh_psu_shd.g_old_rec.attribute5;
564: pqh_psu_shd.g_old_rec.attribute4;
565: End If;
566: If (p_rec.attribute5 = hr_api.g_varchar2) then
567: p_rec.attribute5 :=
568: pqh_psu_shd.g_old_rec.attribute5;
569: End If;
570: If (p_rec.attribute6 = hr_api.g_varchar2) then
571: p_rec.attribute6 :=
572: pqh_psu_shd.g_old_rec.attribute6;
568: pqh_psu_shd.g_old_rec.attribute5;
569: End If;
570: If (p_rec.attribute6 = hr_api.g_varchar2) then
571: p_rec.attribute6 :=
572: pqh_psu_shd.g_old_rec.attribute6;
573: End If;
574: If (p_rec.attribute7 = hr_api.g_varchar2) then
575: p_rec.attribute7 :=
576: pqh_psu_shd.g_old_rec.attribute7;
572: pqh_psu_shd.g_old_rec.attribute6;
573: End If;
574: If (p_rec.attribute7 = hr_api.g_varchar2) then
575: p_rec.attribute7 :=
576: pqh_psu_shd.g_old_rec.attribute7;
577: End If;
578: If (p_rec.attribute8 = hr_api.g_varchar2) then
579: p_rec.attribute8 :=
580: pqh_psu_shd.g_old_rec.attribute8;
576: pqh_psu_shd.g_old_rec.attribute7;
577: End If;
578: If (p_rec.attribute8 = hr_api.g_varchar2) then
579: p_rec.attribute8 :=
580: pqh_psu_shd.g_old_rec.attribute8;
581: End If;
582: If (p_rec.attribute9 = hr_api.g_varchar2) then
583: p_rec.attribute9 :=
584: pqh_psu_shd.g_old_rec.attribute9;
580: pqh_psu_shd.g_old_rec.attribute8;
581: End If;
582: If (p_rec.attribute9 = hr_api.g_varchar2) then
583: p_rec.attribute9 :=
584: pqh_psu_shd.g_old_rec.attribute9;
585: End If;
586: If (p_rec.attribute10 = hr_api.g_varchar2) then
587: p_rec.attribute10 :=
588: pqh_psu_shd.g_old_rec.attribute10;
584: pqh_psu_shd.g_old_rec.attribute9;
585: End If;
586: If (p_rec.attribute10 = hr_api.g_varchar2) then
587: p_rec.attribute10 :=
588: pqh_psu_shd.g_old_rec.attribute10;
589: End If;
590: If (p_rec.attribute11 = hr_api.g_varchar2) then
591: p_rec.attribute11 :=
592: pqh_psu_shd.g_old_rec.attribute11;
588: pqh_psu_shd.g_old_rec.attribute10;
589: End If;
590: If (p_rec.attribute11 = hr_api.g_varchar2) then
591: p_rec.attribute11 :=
592: pqh_psu_shd.g_old_rec.attribute11;
593: End If;
594: If (p_rec.attribute12 = hr_api.g_varchar2) then
595: p_rec.attribute12 :=
596: pqh_psu_shd.g_old_rec.attribute12;
592: pqh_psu_shd.g_old_rec.attribute11;
593: End If;
594: If (p_rec.attribute12 = hr_api.g_varchar2) then
595: p_rec.attribute12 :=
596: pqh_psu_shd.g_old_rec.attribute12;
597: End If;
598: If (p_rec.attribute13 = hr_api.g_varchar2) then
599: p_rec.attribute13 :=
600: pqh_psu_shd.g_old_rec.attribute13;
596: pqh_psu_shd.g_old_rec.attribute12;
597: End If;
598: If (p_rec.attribute13 = hr_api.g_varchar2) then
599: p_rec.attribute13 :=
600: pqh_psu_shd.g_old_rec.attribute13;
601: End If;
602: If (p_rec.attribute14 = hr_api.g_varchar2) then
603: p_rec.attribute14 :=
604: pqh_psu_shd.g_old_rec.attribute14;
600: pqh_psu_shd.g_old_rec.attribute13;
601: End If;
602: If (p_rec.attribute14 = hr_api.g_varchar2) then
603: p_rec.attribute14 :=
604: pqh_psu_shd.g_old_rec.attribute14;
605: End If;
606: If (p_rec.attribute15 = hr_api.g_varchar2) then
607: p_rec.attribute15 :=
608: pqh_psu_shd.g_old_rec.attribute15;
604: pqh_psu_shd.g_old_rec.attribute14;
605: End If;
606: If (p_rec.attribute15 = hr_api.g_varchar2) then
607: p_rec.attribute15 :=
608: pqh_psu_shd.g_old_rec.attribute15;
609: End If;
610: If (p_rec.attribute16 = hr_api.g_varchar2) then
611: p_rec.attribute16 :=
612: pqh_psu_shd.g_old_rec.attribute16;
608: pqh_psu_shd.g_old_rec.attribute15;
609: End If;
610: If (p_rec.attribute16 = hr_api.g_varchar2) then
611: p_rec.attribute16 :=
612: pqh_psu_shd.g_old_rec.attribute16;
613: End If;
614: If (p_rec.attribute17 = hr_api.g_varchar2) then
615: p_rec.attribute17 :=
616: pqh_psu_shd.g_old_rec.attribute17;
612: pqh_psu_shd.g_old_rec.attribute16;
613: End If;
614: If (p_rec.attribute17 = hr_api.g_varchar2) then
615: p_rec.attribute17 :=
616: pqh_psu_shd.g_old_rec.attribute17;
617: End If;
618: If (p_rec.attribute18 = hr_api.g_varchar2) then
619: p_rec.attribute18 :=
620: pqh_psu_shd.g_old_rec.attribute18;
616: pqh_psu_shd.g_old_rec.attribute17;
617: End If;
618: If (p_rec.attribute18 = hr_api.g_varchar2) then
619: p_rec.attribute18 :=
620: pqh_psu_shd.g_old_rec.attribute18;
621: End If;
622: If (p_rec.attribute19 = hr_api.g_varchar2) then
623: p_rec.attribute19 :=
624: pqh_psu_shd.g_old_rec.attribute19;
620: pqh_psu_shd.g_old_rec.attribute18;
621: End If;
622: If (p_rec.attribute19 = hr_api.g_varchar2) then
623: p_rec.attribute19 :=
624: pqh_psu_shd.g_old_rec.attribute19;
625: End If;
626: If (p_rec.attribute20 = hr_api.g_varchar2) then
627: p_rec.attribute20 :=
628: pqh_psu_shd.g_old_rec.attribute20;
624: pqh_psu_shd.g_old_rec.attribute19;
625: End If;
626: If (p_rec.attribute20 = hr_api.g_varchar2) then
627: p_rec.attribute20 :=
628: pqh_psu_shd.g_old_rec.attribute20;
629: End If;
630: If (p_rec.attribute21 = hr_api.g_varchar2) then
631: p_rec.attribute21 :=
632: pqh_psu_shd.g_old_rec.attribute21;
628: pqh_psu_shd.g_old_rec.attribute20;
629: End If;
630: If (p_rec.attribute21 = hr_api.g_varchar2) then
631: p_rec.attribute21 :=
632: pqh_psu_shd.g_old_rec.attribute21;
633: End If;
634: If (p_rec.attribute22 = hr_api.g_varchar2) then
635: p_rec.attribute22 :=
636: pqh_psu_shd.g_old_rec.attribute22;
632: pqh_psu_shd.g_old_rec.attribute21;
633: End If;
634: If (p_rec.attribute22 = hr_api.g_varchar2) then
635: p_rec.attribute22 :=
636: pqh_psu_shd.g_old_rec.attribute22;
637: End If;
638: If (p_rec.attribute23 = hr_api.g_varchar2) then
639: p_rec.attribute23 :=
640: pqh_psu_shd.g_old_rec.attribute23;
636: pqh_psu_shd.g_old_rec.attribute22;
637: End If;
638: If (p_rec.attribute23 = hr_api.g_varchar2) then
639: p_rec.attribute23 :=
640: pqh_psu_shd.g_old_rec.attribute23;
641: End If;
642: If (p_rec.attribute24 = hr_api.g_varchar2) then
643: p_rec.attribute24 :=
644: pqh_psu_shd.g_old_rec.attribute24;
640: pqh_psu_shd.g_old_rec.attribute23;
641: End If;
642: If (p_rec.attribute24 = hr_api.g_varchar2) then
643: p_rec.attribute24 :=
644: pqh_psu_shd.g_old_rec.attribute24;
645: End If;
646: If (p_rec.attribute25 = hr_api.g_varchar2) then
647: p_rec.attribute25 :=
648: pqh_psu_shd.g_old_rec.attribute25;
644: pqh_psu_shd.g_old_rec.attribute24;
645: End If;
646: If (p_rec.attribute25 = hr_api.g_varchar2) then
647: p_rec.attribute25 :=
648: pqh_psu_shd.g_old_rec.attribute25;
649: End If;
650: If (p_rec.attribute26 = hr_api.g_varchar2) then
651: p_rec.attribute26 :=
652: pqh_psu_shd.g_old_rec.attribute26;
648: pqh_psu_shd.g_old_rec.attribute25;
649: End If;
650: If (p_rec.attribute26 = hr_api.g_varchar2) then
651: p_rec.attribute26 :=
652: pqh_psu_shd.g_old_rec.attribute26;
653: End If;
654: If (p_rec.attribute27 = hr_api.g_varchar2) then
655: p_rec.attribute27 :=
656: pqh_psu_shd.g_old_rec.attribute27;
652: pqh_psu_shd.g_old_rec.attribute26;
653: End If;
654: If (p_rec.attribute27 = hr_api.g_varchar2) then
655: p_rec.attribute27 :=
656: pqh_psu_shd.g_old_rec.attribute27;
657: End If;
658: If (p_rec.attribute28 = hr_api.g_varchar2) then
659: p_rec.attribute28 :=
660: pqh_psu_shd.g_old_rec.attribute28;
656: pqh_psu_shd.g_old_rec.attribute27;
657: End If;
658: If (p_rec.attribute28 = hr_api.g_varchar2) then
659: p_rec.attribute28 :=
660: pqh_psu_shd.g_old_rec.attribute28;
661: End If;
662: If (p_rec.attribute29 = hr_api.g_varchar2) then
663: p_rec.attribute29 :=
664: pqh_psu_shd.g_old_rec.attribute29;
660: pqh_psu_shd.g_old_rec.attribute28;
661: End If;
662: If (p_rec.attribute29 = hr_api.g_varchar2) then
663: p_rec.attribute29 :=
664: pqh_psu_shd.g_old_rec.attribute29;
665: End If;
666: If (p_rec.attribute30 = hr_api.g_varchar2) then
667: p_rec.attribute30 :=
668: pqh_psu_shd.g_old_rec.attribute30;
664: pqh_psu_shd.g_old_rec.attribute29;
665: End If;
666: If (p_rec.attribute30 = hr_api.g_varchar2) then
667: p_rec.attribute30 :=
668: pqh_psu_shd.g_old_rec.attribute30;
669: End If;
670: --
671: End convert_defs;
672: --
674: -- |---------------------------------< upd >----------------------------------|
675: -- ----------------------------------------------------------------------------
676: Procedure upd
677: (p_effective_date in date
678: ,p_rec in out nocopy pqh_psu_shd.g_rec_type
679: ) is
680: --
681: l_proc varchar2(72) := g_package||'upd';
682: --
684: hr_utility.set_location('Entering:'||l_proc, 5);
685: --
686: -- We must lock the row which we need to update.
687: --
688: pqh_psu_shd.lck
689: (p_rec.emp_stat_situation_id
690: ,p_rec.object_version_number
691: );
692: --
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2
778: ,p_attribute30 in varchar2 default hr_api.g_varchar2
779: ) is
780: --
781: l_rec pqh_psu_shd.g_rec_type;
782: l_proc varchar2(72) := g_package||'upd';
783: --
784: Begin
785: hr_utility.set_location('Entering:'||l_proc, 5);
787: -- Call conversion function to turn arguments into the
788: -- l_rec structure.
789: --
790: l_rec :=
791: pqh_psu_shd.convert_args
792: (p_emp_stat_situation_id
793: ,p_statutory_situation_id
794: ,p_person_id
795: ,p_provisional_start_date