52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy pqh_cpd_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72);
60: --
66: --
67: -- Increment the object version
68: p_rec.object_version_number := p_rec.object_version_number + 1;
69: --
70: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Update the pqh_corps_definitions Row
73: --
74: update pqh_corps_definitions
129: ,probation_period = p_rec.probation_period
130: ,probation_units = p_rec.probation_units
131: where corps_definition_id = p_rec.corps_definition_id;
132: --
133: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
134: --
135: if g_debug then
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: end if;
138: --
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
143: pqh_cpd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
143: pqh_cpd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
143: pqh_cpd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
153: pqh_cpd_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
153: pqh_cpd_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
152: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
153: pqh_cpd_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End update_dml;
159: --
160: -- ----------------------------------------------------------------------------
189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure pre_update
193: (p_rec in pqh_cpd_shd.g_rec_type
194: ) is
195: --
196: l_proc varchar2(72);
197: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure post_update
242: (p_effective_date in date
243: ,p_rec in pqh_cpd_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72);
247: --
364: => p_rec.probation_period
365: ,p_probation_units
366: => p_rec.probation_units
367: ,p_business_group_id_o
368: => pqh_cpd_shd.g_old_rec.business_group_id
369: ,p_name_o
370: => pqh_cpd_shd.g_old_rec.name
371: ,p_status_cd_o
372: => pqh_cpd_shd.g_old_rec.status_cd
366: => p_rec.probation_units
367: ,p_business_group_id_o
368: => pqh_cpd_shd.g_old_rec.business_group_id
369: ,p_name_o
370: => pqh_cpd_shd.g_old_rec.name
371: ,p_status_cd_o
372: => pqh_cpd_shd.g_old_rec.status_cd
373: ,p_retirement_age_o
374: => pqh_cpd_shd.g_old_rec.retirement_age
368: => pqh_cpd_shd.g_old_rec.business_group_id
369: ,p_name_o
370: => pqh_cpd_shd.g_old_rec.name
371: ,p_status_cd_o
372: => pqh_cpd_shd.g_old_rec.status_cd
373: ,p_retirement_age_o
374: => pqh_cpd_shd.g_old_rec.retirement_age
375: ,p_category_cd_o
376: => pqh_cpd_shd.g_old_rec.category_cd
370: => pqh_cpd_shd.g_old_rec.name
371: ,p_status_cd_o
372: => pqh_cpd_shd.g_old_rec.status_cd
373: ,p_retirement_age_o
374: => pqh_cpd_shd.g_old_rec.retirement_age
375: ,p_category_cd_o
376: => pqh_cpd_shd.g_old_rec.category_cd
377: ,p_recruitment_end_date_o
378: => pqh_cpd_shd.g_old_rec.recruitment_end_date
372: => pqh_cpd_shd.g_old_rec.status_cd
373: ,p_retirement_age_o
374: => pqh_cpd_shd.g_old_rec.retirement_age
375: ,p_category_cd_o
376: => pqh_cpd_shd.g_old_rec.category_cd
377: ,p_recruitment_end_date_o
378: => pqh_cpd_shd.g_old_rec.recruitment_end_date
379: ,p_corps_type_cd_o
380: => pqh_cpd_shd.g_old_rec.corps_type_cd
374: => pqh_cpd_shd.g_old_rec.retirement_age
375: ,p_category_cd_o
376: => pqh_cpd_shd.g_old_rec.category_cd
377: ,p_recruitment_end_date_o
378: => pqh_cpd_shd.g_old_rec.recruitment_end_date
379: ,p_corps_type_cd_o
380: => pqh_cpd_shd.g_old_rec.corps_type_cd
381: ,p_starting_grade_step_id_o
382: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
376: => pqh_cpd_shd.g_old_rec.category_cd
377: ,p_recruitment_end_date_o
378: => pqh_cpd_shd.g_old_rec.recruitment_end_date
379: ,p_corps_type_cd_o
380: => pqh_cpd_shd.g_old_rec.corps_type_cd
381: ,p_starting_grade_step_id_o
382: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
383: ,p_task_desc_o
384: => pqh_cpd_shd.g_old_rec.task_desc
378: => pqh_cpd_shd.g_old_rec.recruitment_end_date
379: ,p_corps_type_cd_o
380: => pqh_cpd_shd.g_old_rec.corps_type_cd
381: ,p_starting_grade_step_id_o
382: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
383: ,p_task_desc_o
384: => pqh_cpd_shd.g_old_rec.task_desc
385: ,p_secondment_threshold_o
386: => pqh_cpd_shd.g_old_rec.secondment_threshold
380: => pqh_cpd_shd.g_old_rec.corps_type_cd
381: ,p_starting_grade_step_id_o
382: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
383: ,p_task_desc_o
384: => pqh_cpd_shd.g_old_rec.task_desc
385: ,p_secondment_threshold_o
386: => pqh_cpd_shd.g_old_rec.secondment_threshold
387: ,p_normal_hours_o
388: => pqh_cpd_shd.g_old_rec.normal_hours
382: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
383: ,p_task_desc_o
384: => pqh_cpd_shd.g_old_rec.task_desc
385: ,p_secondment_threshold_o
386: => pqh_cpd_shd.g_old_rec.secondment_threshold
387: ,p_normal_hours_o
388: => pqh_cpd_shd.g_old_rec.normal_hours
389: ,p_normal_hours_frequency_o
390: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
384: => pqh_cpd_shd.g_old_rec.task_desc
385: ,p_secondment_threshold_o
386: => pqh_cpd_shd.g_old_rec.secondment_threshold
387: ,p_normal_hours_o
388: => pqh_cpd_shd.g_old_rec.normal_hours
389: ,p_normal_hours_frequency_o
390: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
391: ,p_minimum_hours_o
392: => pqh_cpd_shd.g_old_rec.minimum_hours
386: => pqh_cpd_shd.g_old_rec.secondment_threshold
387: ,p_normal_hours_o
388: => pqh_cpd_shd.g_old_rec.normal_hours
389: ,p_normal_hours_frequency_o
390: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
391: ,p_minimum_hours_o
392: => pqh_cpd_shd.g_old_rec.minimum_hours
393: ,p_minimum_hours_frequency_o
394: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
388: => pqh_cpd_shd.g_old_rec.normal_hours
389: ,p_normal_hours_frequency_o
390: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
391: ,p_minimum_hours_o
392: => pqh_cpd_shd.g_old_rec.minimum_hours
393: ,p_minimum_hours_frequency_o
394: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
395: ,p_attribute1_o
396: => pqh_cpd_shd.g_old_rec.attribute1
390: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
391: ,p_minimum_hours_o
392: => pqh_cpd_shd.g_old_rec.minimum_hours
393: ,p_minimum_hours_frequency_o
394: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
395: ,p_attribute1_o
396: => pqh_cpd_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => pqh_cpd_shd.g_old_rec.attribute2
392: => pqh_cpd_shd.g_old_rec.minimum_hours
393: ,p_minimum_hours_frequency_o
394: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
395: ,p_attribute1_o
396: => pqh_cpd_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => pqh_cpd_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => pqh_cpd_shd.g_old_rec.attribute3
394: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
395: ,p_attribute1_o
396: => pqh_cpd_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => pqh_cpd_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => pqh_cpd_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => pqh_cpd_shd.g_old_rec.attribute4
396: => pqh_cpd_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => pqh_cpd_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => pqh_cpd_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => pqh_cpd_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => pqh_cpd_shd.g_old_rec.attribute5
398: => pqh_cpd_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => pqh_cpd_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => pqh_cpd_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => pqh_cpd_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => pqh_cpd_shd.g_old_rec.attribute6
400: => pqh_cpd_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => pqh_cpd_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => pqh_cpd_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => pqh_cpd_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => pqh_cpd_shd.g_old_rec.attribute7
402: => pqh_cpd_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => pqh_cpd_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => pqh_cpd_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => pqh_cpd_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => pqh_cpd_shd.g_old_rec.attribute8
404: => pqh_cpd_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => pqh_cpd_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => pqh_cpd_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => pqh_cpd_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => pqh_cpd_shd.g_old_rec.attribute9
406: => pqh_cpd_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => pqh_cpd_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => pqh_cpd_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => pqh_cpd_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => pqh_cpd_shd.g_old_rec.attribute10
408: => pqh_cpd_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => pqh_cpd_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => pqh_cpd_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => pqh_cpd_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => pqh_cpd_shd.g_old_rec.attribute11
410: => pqh_cpd_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => pqh_cpd_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => pqh_cpd_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => pqh_cpd_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => pqh_cpd_shd.g_old_rec.attribute12
412: => pqh_cpd_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => pqh_cpd_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => pqh_cpd_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => pqh_cpd_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => pqh_cpd_shd.g_old_rec.attribute13
414: => pqh_cpd_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => pqh_cpd_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => pqh_cpd_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => pqh_cpd_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => pqh_cpd_shd.g_old_rec.attribute14
416: => pqh_cpd_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => pqh_cpd_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => pqh_cpd_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => pqh_cpd_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => pqh_cpd_shd.g_old_rec.attribute15
418: => pqh_cpd_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => pqh_cpd_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => pqh_cpd_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => pqh_cpd_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => pqh_cpd_shd.g_old_rec.attribute16
420: => pqh_cpd_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => pqh_cpd_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => pqh_cpd_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => pqh_cpd_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => pqh_cpd_shd.g_old_rec.attribute17
422: => pqh_cpd_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => pqh_cpd_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => pqh_cpd_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => pqh_cpd_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => pqh_cpd_shd.g_old_rec.attribute18
424: => pqh_cpd_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => pqh_cpd_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => pqh_cpd_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => pqh_cpd_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => pqh_cpd_shd.g_old_rec.attribute19
426: => pqh_cpd_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => pqh_cpd_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => pqh_cpd_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => pqh_cpd_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => pqh_cpd_shd.g_old_rec.attribute20
428: => pqh_cpd_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => pqh_cpd_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => pqh_cpd_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => pqh_cpd_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => pqh_cpd_shd.g_old_rec.attribute21
430: => pqh_cpd_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => pqh_cpd_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => pqh_cpd_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => pqh_cpd_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => pqh_cpd_shd.g_old_rec.attribute22
432: => pqh_cpd_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => pqh_cpd_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => pqh_cpd_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => pqh_cpd_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => pqh_cpd_shd.g_old_rec.attribute23
434: => pqh_cpd_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => pqh_cpd_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => pqh_cpd_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => pqh_cpd_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => pqh_cpd_shd.g_old_rec.attribute24
436: => pqh_cpd_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => pqh_cpd_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => pqh_cpd_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => pqh_cpd_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => pqh_cpd_shd.g_old_rec.attribute25
438: => pqh_cpd_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => pqh_cpd_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => pqh_cpd_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => pqh_cpd_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => pqh_cpd_shd.g_old_rec.attribute26
440: => pqh_cpd_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => pqh_cpd_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => pqh_cpd_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => pqh_cpd_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => pqh_cpd_shd.g_old_rec.attribute27
442: => pqh_cpd_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => pqh_cpd_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => pqh_cpd_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => pqh_cpd_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => pqh_cpd_shd.g_old_rec.attribute28
444: => pqh_cpd_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => pqh_cpd_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => pqh_cpd_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => pqh_cpd_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => pqh_cpd_shd.g_old_rec.attribute29
446: => pqh_cpd_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => pqh_cpd_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => pqh_cpd_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => pqh_cpd_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => pqh_cpd_shd.g_old_rec.attribute30
448: => pqh_cpd_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => pqh_cpd_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => pqh_cpd_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => pqh_cpd_shd.g_old_rec.attribute30
455: ,p_attribute_category_o
456: => pqh_cpd_shd.g_old_rec.attribute_category
450: => pqh_cpd_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => pqh_cpd_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => pqh_cpd_shd.g_old_rec.attribute30
455: ,p_attribute_category_o
456: => pqh_cpd_shd.g_old_rec.attribute_category
457: ,p_object_version_number_o
458: => pqh_cpd_shd.g_old_rec.object_version_number
452: => pqh_cpd_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => pqh_cpd_shd.g_old_rec.attribute30
455: ,p_attribute_category_o
456: => pqh_cpd_shd.g_old_rec.attribute_category
457: ,p_object_version_number_o
458: => pqh_cpd_shd.g_old_rec.object_version_number
459: ,p_type_of_ps_o
460: => pqh_cpd_shd.g_old_rec.type_of_ps
454: => pqh_cpd_shd.g_old_rec.attribute30
455: ,p_attribute_category_o
456: => pqh_cpd_shd.g_old_rec.attribute_category
457: ,p_object_version_number_o
458: => pqh_cpd_shd.g_old_rec.object_version_number
459: ,p_type_of_ps_o
460: => pqh_cpd_shd.g_old_rec.type_of_ps
461: ,p_date_from_o
462: => pqh_cpd_shd.g_old_rec.date_from
456: => pqh_cpd_shd.g_old_rec.attribute_category
457: ,p_object_version_number_o
458: => pqh_cpd_shd.g_old_rec.object_version_number
459: ,p_type_of_ps_o
460: => pqh_cpd_shd.g_old_rec.type_of_ps
461: ,p_date_from_o
462: => pqh_cpd_shd.g_old_rec.date_from
463: ,p_date_to_o
464: => pqh_cpd_shd.g_old_rec.date_to
458: => pqh_cpd_shd.g_old_rec.object_version_number
459: ,p_type_of_ps_o
460: => pqh_cpd_shd.g_old_rec.type_of_ps
461: ,p_date_from_o
462: => pqh_cpd_shd.g_old_rec.date_from
463: ,p_date_to_o
464: => pqh_cpd_shd.g_old_rec.date_to
465: ,p_primary_prof_field_id_o
466: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
460: => pqh_cpd_shd.g_old_rec.type_of_ps
461: ,p_date_from_o
462: => pqh_cpd_shd.g_old_rec.date_from
463: ,p_date_to_o
464: => pqh_cpd_shd.g_old_rec.date_to
465: ,p_primary_prof_field_id_o
466: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
467: ,p_starting_grade_id_o
468: => pqh_cpd_shd.g_old_rec.starting_grade_id
462: => pqh_cpd_shd.g_old_rec.date_from
463: ,p_date_to_o
464: => pqh_cpd_shd.g_old_rec.date_to
465: ,p_primary_prof_field_id_o
466: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
467: ,p_starting_grade_id_o
468: => pqh_cpd_shd.g_old_rec.starting_grade_id
469: ,p_ben_pgm_id_o
470: => pqh_cpd_shd.g_old_rec.ben_pgm_id
464: => pqh_cpd_shd.g_old_rec.date_to
465: ,p_primary_prof_field_id_o
466: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
467: ,p_starting_grade_id_o
468: => pqh_cpd_shd.g_old_rec.starting_grade_id
469: ,p_ben_pgm_id_o
470: => pqh_cpd_shd.g_old_rec.ben_pgm_id
471: ,p_probation_period_o
472: => pqh_cpd_shd.g_old_rec.probation_period
466: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
467: ,p_starting_grade_id_o
468: => pqh_cpd_shd.g_old_rec.starting_grade_id
469: ,p_ben_pgm_id_o
470: => pqh_cpd_shd.g_old_rec.ben_pgm_id
471: ,p_probation_period_o
472: => pqh_cpd_shd.g_old_rec.probation_period
473: ,p_probation_units_o
474: => pqh_cpd_shd.g_old_rec.probation_units
468: => pqh_cpd_shd.g_old_rec.starting_grade_id
469: ,p_ben_pgm_id_o
470: => pqh_cpd_shd.g_old_rec.ben_pgm_id
471: ,p_probation_period_o
472: => pqh_cpd_shd.g_old_rec.probation_period
473: ,p_probation_units_o
474: => pqh_cpd_shd.g_old_rec.probation_units
475: );
476: --
470: => pqh_cpd_shd.g_old_rec.ben_pgm_id
471: ,p_probation_period_o
472: => pqh_cpd_shd.g_old_rec.probation_period
473: ,p_probation_units_o
474: => pqh_cpd_shd.g_old_rec.probation_units
475: );
476: --
477: exception
478: --
532: --
533: -- {End Of Comments}
534: -- ----------------------------------------------------------------------------
535: Procedure convert_defs
536: (p_rec in out nocopy pqh_cpd_shd.g_rec_type
537: ) is
538: --
539: Begin
540: --
544: -- is being used then we must set to the 'current' argument value.
545: --
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: pqh_cpd_shd.g_old_rec.business_group_id;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: pqh_cpd_shd.g_old_rec.name;
548: pqh_cpd_shd.g_old_rec.business_group_id;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: pqh_cpd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.status_cd = hr_api.g_varchar2) then
555: p_rec.status_cd :=
556: pqh_cpd_shd.g_old_rec.status_cd;
552: pqh_cpd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.status_cd = hr_api.g_varchar2) then
555: p_rec.status_cd :=
556: pqh_cpd_shd.g_old_rec.status_cd;
557: End If;
558: If (p_rec.retirement_age = hr_api.g_number) then
559: p_rec.retirement_age :=
560: pqh_cpd_shd.g_old_rec.retirement_age;
556: pqh_cpd_shd.g_old_rec.status_cd;
557: End If;
558: If (p_rec.retirement_age = hr_api.g_number) then
559: p_rec.retirement_age :=
560: pqh_cpd_shd.g_old_rec.retirement_age;
561: End If;
562: If (p_rec.category_cd = hr_api.g_varchar2) then
563: p_rec.category_cd :=
564: pqh_cpd_shd.g_old_rec.category_cd;
560: pqh_cpd_shd.g_old_rec.retirement_age;
561: End If;
562: If (p_rec.category_cd = hr_api.g_varchar2) then
563: p_rec.category_cd :=
564: pqh_cpd_shd.g_old_rec.category_cd;
565: End If;
566: If (p_rec.recruitment_end_date = hr_api.g_date) then
567: p_rec.recruitment_end_date :=
568: pqh_cpd_shd.g_old_rec.recruitment_end_date;
564: pqh_cpd_shd.g_old_rec.category_cd;
565: End If;
566: If (p_rec.recruitment_end_date = hr_api.g_date) then
567: p_rec.recruitment_end_date :=
568: pqh_cpd_shd.g_old_rec.recruitment_end_date;
569: End If;
570: If (p_rec.corps_type_cd = hr_api.g_varchar2) then
571: p_rec.corps_type_cd :=
572: pqh_cpd_shd.g_old_rec.corps_type_cd;
568: pqh_cpd_shd.g_old_rec.recruitment_end_date;
569: End If;
570: If (p_rec.corps_type_cd = hr_api.g_varchar2) then
571: p_rec.corps_type_cd :=
572: pqh_cpd_shd.g_old_rec.corps_type_cd;
573: End If;
574: If (p_rec.starting_grade_step_id = hr_api.g_number) then
575: p_rec.starting_grade_step_id :=
576: pqh_cpd_shd.g_old_rec.starting_grade_step_id;
572: pqh_cpd_shd.g_old_rec.corps_type_cd;
573: End If;
574: If (p_rec.starting_grade_step_id = hr_api.g_number) then
575: p_rec.starting_grade_step_id :=
576: pqh_cpd_shd.g_old_rec.starting_grade_step_id;
577: End If;
578: If (p_rec.task_desc = hr_api.g_varchar2) then
579: p_rec.task_desc :=
580: pqh_cpd_shd.g_old_rec.task_desc;
576: pqh_cpd_shd.g_old_rec.starting_grade_step_id;
577: End If;
578: If (p_rec.task_desc = hr_api.g_varchar2) then
579: p_rec.task_desc :=
580: pqh_cpd_shd.g_old_rec.task_desc;
581: End If;
582: If (p_rec.secondment_threshold = hr_api.g_number) then
583: p_rec.secondment_threshold :=
584: pqh_cpd_shd.g_old_rec.secondment_threshold;
580: pqh_cpd_shd.g_old_rec.task_desc;
581: End If;
582: If (p_rec.secondment_threshold = hr_api.g_number) then
583: p_rec.secondment_threshold :=
584: pqh_cpd_shd.g_old_rec.secondment_threshold;
585: End If;
586: If (p_rec.normal_hours = hr_api.g_number) then
587: p_rec.normal_hours :=
588: pqh_cpd_shd.g_old_rec.normal_hours;
584: pqh_cpd_shd.g_old_rec.secondment_threshold;
585: End If;
586: If (p_rec.normal_hours = hr_api.g_number) then
587: p_rec.normal_hours :=
588: pqh_cpd_shd.g_old_rec.normal_hours;
589: End If;
590: If (p_rec.normal_hours_frequency = hr_api.g_varchar2) then
591: p_rec.normal_hours_frequency :=
592: pqh_cpd_shd.g_old_rec.normal_hours_frequency;
588: pqh_cpd_shd.g_old_rec.normal_hours;
589: End If;
590: If (p_rec.normal_hours_frequency = hr_api.g_varchar2) then
591: p_rec.normal_hours_frequency :=
592: pqh_cpd_shd.g_old_rec.normal_hours_frequency;
593: End If;
594: If (p_rec.minimum_hours = hr_api.g_number) then
595: p_rec.minimum_hours :=
596: pqh_cpd_shd.g_old_rec.minimum_hours;
592: pqh_cpd_shd.g_old_rec.normal_hours_frequency;
593: End If;
594: If (p_rec.minimum_hours = hr_api.g_number) then
595: p_rec.minimum_hours :=
596: pqh_cpd_shd.g_old_rec.minimum_hours;
597: End If;
598: If (p_rec.minimum_hours_frequency = hr_api.g_varchar2) then
599: p_rec.minimum_hours_frequency :=
600: pqh_cpd_shd.g_old_rec.minimum_hours_frequency;
596: pqh_cpd_shd.g_old_rec.minimum_hours;
597: End If;
598: If (p_rec.minimum_hours_frequency = hr_api.g_varchar2) then
599: p_rec.minimum_hours_frequency :=
600: pqh_cpd_shd.g_old_rec.minimum_hours_frequency;
601: End If;
602: If (p_rec.attribute1 = hr_api.g_varchar2) then
603: p_rec.attribute1 :=
604: pqh_cpd_shd.g_old_rec.attribute1;
600: pqh_cpd_shd.g_old_rec.minimum_hours_frequency;
601: End If;
602: If (p_rec.attribute1 = hr_api.g_varchar2) then
603: p_rec.attribute1 :=
604: pqh_cpd_shd.g_old_rec.attribute1;
605: End If;
606: If (p_rec.attribute2 = hr_api.g_varchar2) then
607: p_rec.attribute2 :=
608: pqh_cpd_shd.g_old_rec.attribute2;
604: pqh_cpd_shd.g_old_rec.attribute1;
605: End If;
606: If (p_rec.attribute2 = hr_api.g_varchar2) then
607: p_rec.attribute2 :=
608: pqh_cpd_shd.g_old_rec.attribute2;
609: End If;
610: If (p_rec.attribute3 = hr_api.g_varchar2) then
611: p_rec.attribute3 :=
612: pqh_cpd_shd.g_old_rec.attribute3;
608: pqh_cpd_shd.g_old_rec.attribute2;
609: End If;
610: If (p_rec.attribute3 = hr_api.g_varchar2) then
611: p_rec.attribute3 :=
612: pqh_cpd_shd.g_old_rec.attribute3;
613: End If;
614: If (p_rec.attribute4 = hr_api.g_varchar2) then
615: p_rec.attribute4 :=
616: pqh_cpd_shd.g_old_rec.attribute4;
612: pqh_cpd_shd.g_old_rec.attribute3;
613: End If;
614: If (p_rec.attribute4 = hr_api.g_varchar2) then
615: p_rec.attribute4 :=
616: pqh_cpd_shd.g_old_rec.attribute4;
617: End If;
618: If (p_rec.attribute5 = hr_api.g_varchar2) then
619: p_rec.attribute5 :=
620: pqh_cpd_shd.g_old_rec.attribute5;
616: pqh_cpd_shd.g_old_rec.attribute4;
617: End If;
618: If (p_rec.attribute5 = hr_api.g_varchar2) then
619: p_rec.attribute5 :=
620: pqh_cpd_shd.g_old_rec.attribute5;
621: End If;
622: If (p_rec.attribute6 = hr_api.g_varchar2) then
623: p_rec.attribute6 :=
624: pqh_cpd_shd.g_old_rec.attribute6;
620: pqh_cpd_shd.g_old_rec.attribute5;
621: End If;
622: If (p_rec.attribute6 = hr_api.g_varchar2) then
623: p_rec.attribute6 :=
624: pqh_cpd_shd.g_old_rec.attribute6;
625: End If;
626: If (p_rec.attribute7 = hr_api.g_varchar2) then
627: p_rec.attribute7 :=
628: pqh_cpd_shd.g_old_rec.attribute7;
624: pqh_cpd_shd.g_old_rec.attribute6;
625: End If;
626: If (p_rec.attribute7 = hr_api.g_varchar2) then
627: p_rec.attribute7 :=
628: pqh_cpd_shd.g_old_rec.attribute7;
629: End If;
630: If (p_rec.attribute8 = hr_api.g_varchar2) then
631: p_rec.attribute8 :=
632: pqh_cpd_shd.g_old_rec.attribute8;
628: pqh_cpd_shd.g_old_rec.attribute7;
629: End If;
630: If (p_rec.attribute8 = hr_api.g_varchar2) then
631: p_rec.attribute8 :=
632: pqh_cpd_shd.g_old_rec.attribute8;
633: End If;
634: If (p_rec.attribute9 = hr_api.g_varchar2) then
635: p_rec.attribute9 :=
636: pqh_cpd_shd.g_old_rec.attribute9;
632: pqh_cpd_shd.g_old_rec.attribute8;
633: End If;
634: If (p_rec.attribute9 = hr_api.g_varchar2) then
635: p_rec.attribute9 :=
636: pqh_cpd_shd.g_old_rec.attribute9;
637: End If;
638: If (p_rec.attribute10 = hr_api.g_varchar2) then
639: p_rec.attribute10 :=
640: pqh_cpd_shd.g_old_rec.attribute10;
636: pqh_cpd_shd.g_old_rec.attribute9;
637: End If;
638: If (p_rec.attribute10 = hr_api.g_varchar2) then
639: p_rec.attribute10 :=
640: pqh_cpd_shd.g_old_rec.attribute10;
641: End If;
642: If (p_rec.attribute11 = hr_api.g_varchar2) then
643: p_rec.attribute11 :=
644: pqh_cpd_shd.g_old_rec.attribute11;
640: pqh_cpd_shd.g_old_rec.attribute10;
641: End If;
642: If (p_rec.attribute11 = hr_api.g_varchar2) then
643: p_rec.attribute11 :=
644: pqh_cpd_shd.g_old_rec.attribute11;
645: End If;
646: If (p_rec.attribute12 = hr_api.g_varchar2) then
647: p_rec.attribute12 :=
648: pqh_cpd_shd.g_old_rec.attribute12;
644: pqh_cpd_shd.g_old_rec.attribute11;
645: End If;
646: If (p_rec.attribute12 = hr_api.g_varchar2) then
647: p_rec.attribute12 :=
648: pqh_cpd_shd.g_old_rec.attribute12;
649: End If;
650: If (p_rec.attribute13 = hr_api.g_varchar2) then
651: p_rec.attribute13 :=
652: pqh_cpd_shd.g_old_rec.attribute13;
648: pqh_cpd_shd.g_old_rec.attribute12;
649: End If;
650: If (p_rec.attribute13 = hr_api.g_varchar2) then
651: p_rec.attribute13 :=
652: pqh_cpd_shd.g_old_rec.attribute13;
653: End If;
654: If (p_rec.attribute14 = hr_api.g_varchar2) then
655: p_rec.attribute14 :=
656: pqh_cpd_shd.g_old_rec.attribute14;
652: pqh_cpd_shd.g_old_rec.attribute13;
653: End If;
654: If (p_rec.attribute14 = hr_api.g_varchar2) then
655: p_rec.attribute14 :=
656: pqh_cpd_shd.g_old_rec.attribute14;
657: End If;
658: If (p_rec.attribute15 = hr_api.g_varchar2) then
659: p_rec.attribute15 :=
660: pqh_cpd_shd.g_old_rec.attribute15;
656: pqh_cpd_shd.g_old_rec.attribute14;
657: End If;
658: If (p_rec.attribute15 = hr_api.g_varchar2) then
659: p_rec.attribute15 :=
660: pqh_cpd_shd.g_old_rec.attribute15;
661: End If;
662: If (p_rec.attribute16 = hr_api.g_varchar2) then
663: p_rec.attribute16 :=
664: pqh_cpd_shd.g_old_rec.attribute16;
660: pqh_cpd_shd.g_old_rec.attribute15;
661: End If;
662: If (p_rec.attribute16 = hr_api.g_varchar2) then
663: p_rec.attribute16 :=
664: pqh_cpd_shd.g_old_rec.attribute16;
665: End If;
666: If (p_rec.attribute17 = hr_api.g_varchar2) then
667: p_rec.attribute17 :=
668: pqh_cpd_shd.g_old_rec.attribute17;
664: pqh_cpd_shd.g_old_rec.attribute16;
665: End If;
666: If (p_rec.attribute17 = hr_api.g_varchar2) then
667: p_rec.attribute17 :=
668: pqh_cpd_shd.g_old_rec.attribute17;
669: End If;
670: If (p_rec.attribute18 = hr_api.g_varchar2) then
671: p_rec.attribute18 :=
672: pqh_cpd_shd.g_old_rec.attribute18;
668: pqh_cpd_shd.g_old_rec.attribute17;
669: End If;
670: If (p_rec.attribute18 = hr_api.g_varchar2) then
671: p_rec.attribute18 :=
672: pqh_cpd_shd.g_old_rec.attribute18;
673: End If;
674: If (p_rec.attribute19 = hr_api.g_varchar2) then
675: p_rec.attribute19 :=
676: pqh_cpd_shd.g_old_rec.attribute19;
672: pqh_cpd_shd.g_old_rec.attribute18;
673: End If;
674: If (p_rec.attribute19 = hr_api.g_varchar2) then
675: p_rec.attribute19 :=
676: pqh_cpd_shd.g_old_rec.attribute19;
677: End If;
678: If (p_rec.attribute20 = hr_api.g_varchar2) then
679: p_rec.attribute20 :=
680: pqh_cpd_shd.g_old_rec.attribute20;
676: pqh_cpd_shd.g_old_rec.attribute19;
677: End If;
678: If (p_rec.attribute20 = hr_api.g_varchar2) then
679: p_rec.attribute20 :=
680: pqh_cpd_shd.g_old_rec.attribute20;
681: End If;
682: If (p_rec.attribute21 = hr_api.g_varchar2) then
683: p_rec.attribute21 :=
684: pqh_cpd_shd.g_old_rec.attribute21;
680: pqh_cpd_shd.g_old_rec.attribute20;
681: End If;
682: If (p_rec.attribute21 = hr_api.g_varchar2) then
683: p_rec.attribute21 :=
684: pqh_cpd_shd.g_old_rec.attribute21;
685: End If;
686: If (p_rec.attribute22 = hr_api.g_varchar2) then
687: p_rec.attribute22 :=
688: pqh_cpd_shd.g_old_rec.attribute22;
684: pqh_cpd_shd.g_old_rec.attribute21;
685: End If;
686: If (p_rec.attribute22 = hr_api.g_varchar2) then
687: p_rec.attribute22 :=
688: pqh_cpd_shd.g_old_rec.attribute22;
689: End If;
690: If (p_rec.attribute23 = hr_api.g_varchar2) then
691: p_rec.attribute23 :=
692: pqh_cpd_shd.g_old_rec.attribute23;
688: pqh_cpd_shd.g_old_rec.attribute22;
689: End If;
690: If (p_rec.attribute23 = hr_api.g_varchar2) then
691: p_rec.attribute23 :=
692: pqh_cpd_shd.g_old_rec.attribute23;
693: End If;
694: If (p_rec.attribute24 = hr_api.g_varchar2) then
695: p_rec.attribute24 :=
696: pqh_cpd_shd.g_old_rec.attribute24;
692: pqh_cpd_shd.g_old_rec.attribute23;
693: End If;
694: If (p_rec.attribute24 = hr_api.g_varchar2) then
695: p_rec.attribute24 :=
696: pqh_cpd_shd.g_old_rec.attribute24;
697: End If;
698: If (p_rec.attribute25 = hr_api.g_varchar2) then
699: p_rec.attribute25 :=
700: pqh_cpd_shd.g_old_rec.attribute25;
696: pqh_cpd_shd.g_old_rec.attribute24;
697: End If;
698: If (p_rec.attribute25 = hr_api.g_varchar2) then
699: p_rec.attribute25 :=
700: pqh_cpd_shd.g_old_rec.attribute25;
701: End If;
702: If (p_rec.attribute26 = hr_api.g_varchar2) then
703: p_rec.attribute26 :=
704: pqh_cpd_shd.g_old_rec.attribute26;
700: pqh_cpd_shd.g_old_rec.attribute25;
701: End If;
702: If (p_rec.attribute26 = hr_api.g_varchar2) then
703: p_rec.attribute26 :=
704: pqh_cpd_shd.g_old_rec.attribute26;
705: End If;
706: If (p_rec.attribute27 = hr_api.g_varchar2) then
707: p_rec.attribute27 :=
708: pqh_cpd_shd.g_old_rec.attribute27;
704: pqh_cpd_shd.g_old_rec.attribute26;
705: End If;
706: If (p_rec.attribute27 = hr_api.g_varchar2) then
707: p_rec.attribute27 :=
708: pqh_cpd_shd.g_old_rec.attribute27;
709: End If;
710: If (p_rec.attribute28 = hr_api.g_varchar2) then
711: p_rec.attribute28 :=
712: pqh_cpd_shd.g_old_rec.attribute28;
708: pqh_cpd_shd.g_old_rec.attribute27;
709: End If;
710: If (p_rec.attribute28 = hr_api.g_varchar2) then
711: p_rec.attribute28 :=
712: pqh_cpd_shd.g_old_rec.attribute28;
713: End If;
714: If (p_rec.attribute29 = hr_api.g_varchar2) then
715: p_rec.attribute29 :=
716: pqh_cpd_shd.g_old_rec.attribute29;
712: pqh_cpd_shd.g_old_rec.attribute28;
713: End If;
714: If (p_rec.attribute29 = hr_api.g_varchar2) then
715: p_rec.attribute29 :=
716: pqh_cpd_shd.g_old_rec.attribute29;
717: End If;
718: If (p_rec.attribute30 = hr_api.g_varchar2) then
719: p_rec.attribute30 :=
720: pqh_cpd_shd.g_old_rec.attribute30;
716: pqh_cpd_shd.g_old_rec.attribute29;
717: End If;
718: If (p_rec.attribute30 = hr_api.g_varchar2) then
719: p_rec.attribute30 :=
720: pqh_cpd_shd.g_old_rec.attribute30;
721: End If;
722: If (p_rec.attribute_category = hr_api.g_varchar2) then
723: p_rec.attribute_category :=
724: pqh_cpd_shd.g_old_rec.attribute_category;
720: pqh_cpd_shd.g_old_rec.attribute30;
721: End If;
722: If (p_rec.attribute_category = hr_api.g_varchar2) then
723: p_rec.attribute_category :=
724: pqh_cpd_shd.g_old_rec.attribute_category;
725: End If;
726: If (p_rec.type_of_ps = hr_api.g_varchar2) then
727: p_rec.type_of_ps :=
728: pqh_cpd_shd.g_old_rec.type_of_ps;
724: pqh_cpd_shd.g_old_rec.attribute_category;
725: End If;
726: If (p_rec.type_of_ps = hr_api.g_varchar2) then
727: p_rec.type_of_ps :=
728: pqh_cpd_shd.g_old_rec.type_of_ps;
729: End If;
730: If (p_rec.date_from = hr_api.g_date) then
731: p_rec.date_from :=
732: pqh_cpd_shd.g_old_rec.date_from;
728: pqh_cpd_shd.g_old_rec.type_of_ps;
729: End If;
730: If (p_rec.date_from = hr_api.g_date) then
731: p_rec.date_from :=
732: pqh_cpd_shd.g_old_rec.date_from;
733: End If;
734: If (p_rec.date_to = hr_api.g_date) then
735: p_rec.date_to :=
736: pqh_cpd_shd.g_old_rec.date_to;
732: pqh_cpd_shd.g_old_rec.date_from;
733: End If;
734: If (p_rec.date_to = hr_api.g_date) then
735: p_rec.date_to :=
736: pqh_cpd_shd.g_old_rec.date_to;
737: End If;
738: If (p_rec.primary_prof_field_id = hr_api.g_number) then
739: p_rec.primary_prof_field_id :=
740: pqh_cpd_shd.g_old_rec.primary_prof_field_id;
736: pqh_cpd_shd.g_old_rec.date_to;
737: End If;
738: If (p_rec.primary_prof_field_id = hr_api.g_number) then
739: p_rec.primary_prof_field_id :=
740: pqh_cpd_shd.g_old_rec.primary_prof_field_id;
741: End If;
742: If (p_rec.starting_grade_id = hr_api.g_number) then
743: p_rec.starting_grade_id :=
744: pqh_cpd_shd.g_old_rec.starting_grade_id;
740: pqh_cpd_shd.g_old_rec.primary_prof_field_id;
741: End If;
742: If (p_rec.starting_grade_id = hr_api.g_number) then
743: p_rec.starting_grade_id :=
744: pqh_cpd_shd.g_old_rec.starting_grade_id;
745: End If;
746: If (p_rec.ben_pgm_id = hr_api.g_number) then
747: p_rec.ben_pgm_id :=
748: pqh_cpd_shd.g_old_rec.ben_pgm_id;
744: pqh_cpd_shd.g_old_rec.starting_grade_id;
745: End If;
746: If (p_rec.ben_pgm_id = hr_api.g_number) then
747: p_rec.ben_pgm_id :=
748: pqh_cpd_shd.g_old_rec.ben_pgm_id;
749: End If;
750: If (p_rec.probation_period = hr_api.g_number) then
751: p_rec.probation_period :=
752: pqh_cpd_shd.g_old_rec.probation_period;
748: pqh_cpd_shd.g_old_rec.ben_pgm_id;
749: End If;
750: If (p_rec.probation_period = hr_api.g_number) then
751: p_rec.probation_period :=
752: pqh_cpd_shd.g_old_rec.probation_period;
753: End If;
754: If (p_rec.probation_units = hr_api.g_varchar2) then
755: p_rec.probation_units :=
756: pqh_cpd_shd.g_old_rec.probation_units;
752: pqh_cpd_shd.g_old_rec.probation_period;
753: End If;
754: If (p_rec.probation_units = hr_api.g_varchar2) then
755: p_rec.probation_units :=
756: pqh_cpd_shd.g_old_rec.probation_units;
757: End If;
758: --
759: End convert_defs;
760: --
762: -- |---------------------------------< upd >----------------------------------|
763: -- ----------------------------------------------------------------------------
764: Procedure upd
765: (p_effective_date in date
766: ,p_rec in out nocopy pqh_cpd_shd.g_rec_type
767: ) is
768: --
769: l_proc varchar2(72);
770: --
775: end if;
776: --
777: -- We must lock the row which we need to update.
778: --
779: pqh_cpd_shd.lck
780: (p_rec.corps_definition_id
781: ,p_rec.object_version_number
782: );
783: --
876: ,p_probation_period in number default hr_api.g_number
877: ,p_probation_units in varchar2 default hr_api.g_varchar2
878: ) is
879: --
880: l_rec pqh_cpd_shd.g_rec_type;
881: l_proc varchar2(72);
882: --
883: Begin
884: if g_debug then
890: -- Call conversion function to turn arguments into the
891: -- l_rec structure.
892: --
893: l_rec :=
894: pqh_cpd_shd.convert_args
895: (p_corps_definition_id
896: ,p_business_group_id
897: ,p_name
898: ,p_status_cd