[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_sip_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_sip_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_sp_successor_in_plan Row
69: --
70: update per_sp_successor_in_plan
127: ,contract_id = p_rec.contract_id
128: ,object_version_number = p_rec.object_version_number
129: where successor_in_plan_id = p_rec.successor_in_plan_id;
130: --
131: per_sip_shd.g_api_dml := false; -- Unset the api dml status
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: per_sip_shd.g_api_dml := false; -- Unset the api dml status
139: per_sip_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: per_sip_shd.g_api_dml := false; -- Unset the api dml status
139: per_sip_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: per_sip_shd.g_api_dml := false; -- Unset the api dml status
139: per_sip_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: per_sip_shd.g_api_dml := false; -- Unset the api dml status
144: per_sip_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: per_sip_shd.g_api_dml := false; -- Unset the api dml status
144: per_sip_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_sip_shd.g_api_dml := false; -- Unset the api dml status
144: per_sip_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_sip_shd.g_api_dml := false; -- Unset the api dml status
149: per_sip_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: per_sip_shd.g_api_dml := false; -- Unset the api dml status
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_sip_shd.g_api_dml := false; -- Unset the api dml status
149: per_sip_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: per_sip_shd.g_api_dml := false; -- Unset the api dml status
153: Raise;
148: per_sip_shd.g_api_dml := false; -- Unset the api dml status
149: per_sip_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: per_sip_shd.g_api_dml := false; -- Unset the api dml status
153: Raise;
154: End update_dml;
155: --
156: -- ----------------------------------------------------------------------------
185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure pre_update
189: (p_rec in per_sip_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'pre_update';
193: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure post_update
233: (p_effective_date in date
234: ,p_rec in per_sip_shd.g_rec_type
235: ) is
236: --
237: l_proc varchar2(72) := g_package||'post_update';
238: --
356: => p_rec.contract_id
357: ,p_object_version_number
358: => p_rec.object_version_number
359: ,p_plan_id_o
360: => per_sip_shd.g_old_rec.plan_id
361: ,p_successor_id_o
362: => per_sip_shd.g_old_rec.successor_id
363: ,p_business_group_id_o
364: => per_sip_shd.g_old_rec.business_group_id
358: => p_rec.object_version_number
359: ,p_plan_id_o
360: => per_sip_shd.g_old_rec.plan_id
361: ,p_successor_id_o
362: => per_sip_shd.g_old_rec.successor_id
363: ,p_business_group_id_o
364: => per_sip_shd.g_old_rec.business_group_id
365: ,p_status_o
366: => per_sip_shd.g_old_rec.status
360: => per_sip_shd.g_old_rec.plan_id
361: ,p_successor_id_o
362: => per_sip_shd.g_old_rec.successor_id
363: ,p_business_group_id_o
364: => per_sip_shd.g_old_rec.business_group_id
365: ,p_status_o
366: => per_sip_shd.g_old_rec.status
367: ,p_potential_o
368: => per_sip_shd.g_old_rec.potential
362: => per_sip_shd.g_old_rec.successor_id
363: ,p_business_group_id_o
364: => per_sip_shd.g_old_rec.business_group_id
365: ,p_status_o
366: => per_sip_shd.g_old_rec.status
367: ,p_potential_o
368: => per_sip_shd.g_old_rec.potential
369: ,p_performance_rating_o
370: => per_sip_shd.g_old_rec.performance_rating
364: => per_sip_shd.g_old_rec.business_group_id
365: ,p_status_o
366: => per_sip_shd.g_old_rec.status
367: ,p_potential_o
368: => per_sip_shd.g_old_rec.potential
369: ,p_performance_rating_o
370: => per_sip_shd.g_old_rec.performance_rating
371: ,p_risk_of_loss_o
372: => per_sip_shd.g_old_rec.risk_of_loss
366: => per_sip_shd.g_old_rec.status
367: ,p_potential_o
368: => per_sip_shd.g_old_rec.potential
369: ,p_performance_rating_o
370: => per_sip_shd.g_old_rec.performance_rating
371: ,p_risk_of_loss_o
372: => per_sip_shd.g_old_rec.risk_of_loss
373: ,p_impact_of_loss_o
374: => per_sip_shd.g_old_rec.impact_of_loss
368: => per_sip_shd.g_old_rec.potential
369: ,p_performance_rating_o
370: => per_sip_shd.g_old_rec.performance_rating
371: ,p_risk_of_loss_o
372: => per_sip_shd.g_old_rec.risk_of_loss
373: ,p_impact_of_loss_o
374: => per_sip_shd.g_old_rec.impact_of_loss
375: ,p_readiness_pct_o
376: => per_sip_shd.g_old_rec.readiness_pct
370: => per_sip_shd.g_old_rec.performance_rating
371: ,p_risk_of_loss_o
372: => per_sip_shd.g_old_rec.risk_of_loss
373: ,p_impact_of_loss_o
374: => per_sip_shd.g_old_rec.impact_of_loss
375: ,p_readiness_pct_o
376: => per_sip_shd.g_old_rec.readiness_pct
377: ,p_rank_o
378: => per_sip_shd.g_old_rec.rank
372: => per_sip_shd.g_old_rec.risk_of_loss
373: ,p_impact_of_loss_o
374: => per_sip_shd.g_old_rec.impact_of_loss
375: ,p_readiness_pct_o
376: => per_sip_shd.g_old_rec.readiness_pct
377: ,p_rank_o
378: => per_sip_shd.g_old_rec.rank
379: ,p_eligible_for_promotion_o
380: => per_sip_shd.g_old_rec.eligible_for_promotion
374: => per_sip_shd.g_old_rec.impact_of_loss
375: ,p_readiness_pct_o
376: => per_sip_shd.g_old_rec.readiness_pct
377: ,p_rank_o
378: => per_sip_shd.g_old_rec.rank
379: ,p_eligible_for_promotion_o
380: => per_sip_shd.g_old_rec.eligible_for_promotion
381: ,p_earliest_succession_date_o
382: => per_sip_shd.g_old_rec.earliest_succession_date
376: => per_sip_shd.g_old_rec.readiness_pct
377: ,p_rank_o
378: => per_sip_shd.g_old_rec.rank
379: ,p_eligible_for_promotion_o
380: => per_sip_shd.g_old_rec.eligible_for_promotion
381: ,p_earliest_succession_date_o
382: => per_sip_shd.g_old_rec.earliest_succession_date
383: ,p_latest_succession_date_o
384: => per_sip_shd.g_old_rec.latest_succession_date
378: => per_sip_shd.g_old_rec.rank
379: ,p_eligible_for_promotion_o
380: => per_sip_shd.g_old_rec.eligible_for_promotion
381: ,p_earliest_succession_date_o
382: => per_sip_shd.g_old_rec.earliest_succession_date
383: ,p_latest_succession_date_o
384: => per_sip_shd.g_old_rec.latest_succession_date
385: ,p_comments_o
386: => per_sip_shd.g_old_rec.comments
380: => per_sip_shd.g_old_rec.eligible_for_promotion
381: ,p_earliest_succession_date_o
382: => per_sip_shd.g_old_rec.earliest_succession_date
383: ,p_latest_succession_date_o
384: => per_sip_shd.g_old_rec.latest_succession_date
385: ,p_comments_o
386: => per_sip_shd.g_old_rec.comments
387: ,p_attribute_category_o
388: => per_sip_shd.g_old_rec.attribute_category
382: => per_sip_shd.g_old_rec.earliest_succession_date
383: ,p_latest_succession_date_o
384: => per_sip_shd.g_old_rec.latest_succession_date
385: ,p_comments_o
386: => per_sip_shd.g_old_rec.comments
387: ,p_attribute_category_o
388: => per_sip_shd.g_old_rec.attribute_category
389: ,p_attribute1_o
390: => per_sip_shd.g_old_rec.attribute1
384: => per_sip_shd.g_old_rec.latest_succession_date
385: ,p_comments_o
386: => per_sip_shd.g_old_rec.comments
387: ,p_attribute_category_o
388: => per_sip_shd.g_old_rec.attribute_category
389: ,p_attribute1_o
390: => per_sip_shd.g_old_rec.attribute1
391: ,p_attribute2_o
392: => per_sip_shd.g_old_rec.attribute2
386: => per_sip_shd.g_old_rec.comments
387: ,p_attribute_category_o
388: => per_sip_shd.g_old_rec.attribute_category
389: ,p_attribute1_o
390: => per_sip_shd.g_old_rec.attribute1
391: ,p_attribute2_o
392: => per_sip_shd.g_old_rec.attribute2
393: ,p_attribute3_o
394: => per_sip_shd.g_old_rec.attribute3
388: => per_sip_shd.g_old_rec.attribute_category
389: ,p_attribute1_o
390: => per_sip_shd.g_old_rec.attribute1
391: ,p_attribute2_o
392: => per_sip_shd.g_old_rec.attribute2
393: ,p_attribute3_o
394: => per_sip_shd.g_old_rec.attribute3
395: ,p_attribute4_o
396: => per_sip_shd.g_old_rec.attribute4
390: => per_sip_shd.g_old_rec.attribute1
391: ,p_attribute2_o
392: => per_sip_shd.g_old_rec.attribute2
393: ,p_attribute3_o
394: => per_sip_shd.g_old_rec.attribute3
395: ,p_attribute4_o
396: => per_sip_shd.g_old_rec.attribute4
397: ,p_attribute5_o
398: => per_sip_shd.g_old_rec.attribute5
392: => per_sip_shd.g_old_rec.attribute2
393: ,p_attribute3_o
394: => per_sip_shd.g_old_rec.attribute3
395: ,p_attribute4_o
396: => per_sip_shd.g_old_rec.attribute4
397: ,p_attribute5_o
398: => per_sip_shd.g_old_rec.attribute5
399: ,p_attribute6_o
400: => per_sip_shd.g_old_rec.attribute6
394: => per_sip_shd.g_old_rec.attribute3
395: ,p_attribute4_o
396: => per_sip_shd.g_old_rec.attribute4
397: ,p_attribute5_o
398: => per_sip_shd.g_old_rec.attribute5
399: ,p_attribute6_o
400: => per_sip_shd.g_old_rec.attribute6
401: ,p_attribute7_o
402: => per_sip_shd.g_old_rec.attribute7
396: => per_sip_shd.g_old_rec.attribute4
397: ,p_attribute5_o
398: => per_sip_shd.g_old_rec.attribute5
399: ,p_attribute6_o
400: => per_sip_shd.g_old_rec.attribute6
401: ,p_attribute7_o
402: => per_sip_shd.g_old_rec.attribute7
403: ,p_attribute8_o
404: => per_sip_shd.g_old_rec.attribute8
398: => per_sip_shd.g_old_rec.attribute5
399: ,p_attribute6_o
400: => per_sip_shd.g_old_rec.attribute6
401: ,p_attribute7_o
402: => per_sip_shd.g_old_rec.attribute7
403: ,p_attribute8_o
404: => per_sip_shd.g_old_rec.attribute8
405: ,p_attribute9_o
406: => per_sip_shd.g_old_rec.attribute9
400: => per_sip_shd.g_old_rec.attribute6
401: ,p_attribute7_o
402: => per_sip_shd.g_old_rec.attribute7
403: ,p_attribute8_o
404: => per_sip_shd.g_old_rec.attribute8
405: ,p_attribute9_o
406: => per_sip_shd.g_old_rec.attribute9
407: ,p_attribute10_o
408: => per_sip_shd.g_old_rec.attribute10
402: => per_sip_shd.g_old_rec.attribute7
403: ,p_attribute8_o
404: => per_sip_shd.g_old_rec.attribute8
405: ,p_attribute9_o
406: => per_sip_shd.g_old_rec.attribute9
407: ,p_attribute10_o
408: => per_sip_shd.g_old_rec.attribute10
409: ,p_attribute11_o
410: => per_sip_shd.g_old_rec.attribute11
404: => per_sip_shd.g_old_rec.attribute8
405: ,p_attribute9_o
406: => per_sip_shd.g_old_rec.attribute9
407: ,p_attribute10_o
408: => per_sip_shd.g_old_rec.attribute10
409: ,p_attribute11_o
410: => per_sip_shd.g_old_rec.attribute11
411: ,p_attribute12_o
412: => per_sip_shd.g_old_rec.attribute12
406: => per_sip_shd.g_old_rec.attribute9
407: ,p_attribute10_o
408: => per_sip_shd.g_old_rec.attribute10
409: ,p_attribute11_o
410: => per_sip_shd.g_old_rec.attribute11
411: ,p_attribute12_o
412: => per_sip_shd.g_old_rec.attribute12
413: ,p_attribute13_o
414: => per_sip_shd.g_old_rec.attribute13
408: => per_sip_shd.g_old_rec.attribute10
409: ,p_attribute11_o
410: => per_sip_shd.g_old_rec.attribute11
411: ,p_attribute12_o
412: => per_sip_shd.g_old_rec.attribute12
413: ,p_attribute13_o
414: => per_sip_shd.g_old_rec.attribute13
415: ,p_attribute14_o
416: => per_sip_shd.g_old_rec.attribute14
410: => per_sip_shd.g_old_rec.attribute11
411: ,p_attribute12_o
412: => per_sip_shd.g_old_rec.attribute12
413: ,p_attribute13_o
414: => per_sip_shd.g_old_rec.attribute13
415: ,p_attribute14_o
416: => per_sip_shd.g_old_rec.attribute14
417: ,p_attribute15_o
418: => per_sip_shd.g_old_rec.attribute15
412: => per_sip_shd.g_old_rec.attribute12
413: ,p_attribute13_o
414: => per_sip_shd.g_old_rec.attribute13
415: ,p_attribute14_o
416: => per_sip_shd.g_old_rec.attribute14
417: ,p_attribute15_o
418: => per_sip_shd.g_old_rec.attribute15
419: ,p_attribute16_o
420: => per_sip_shd.g_old_rec.attribute16
414: => per_sip_shd.g_old_rec.attribute13
415: ,p_attribute14_o
416: => per_sip_shd.g_old_rec.attribute14
417: ,p_attribute15_o
418: => per_sip_shd.g_old_rec.attribute15
419: ,p_attribute16_o
420: => per_sip_shd.g_old_rec.attribute16
421: ,p_attribute17_o
422: => per_sip_shd.g_old_rec.attribute17
416: => per_sip_shd.g_old_rec.attribute14
417: ,p_attribute15_o
418: => per_sip_shd.g_old_rec.attribute15
419: ,p_attribute16_o
420: => per_sip_shd.g_old_rec.attribute16
421: ,p_attribute17_o
422: => per_sip_shd.g_old_rec.attribute17
423: ,p_attribute18_o
424: => per_sip_shd.g_old_rec.attribute18
418: => per_sip_shd.g_old_rec.attribute15
419: ,p_attribute16_o
420: => per_sip_shd.g_old_rec.attribute16
421: ,p_attribute17_o
422: => per_sip_shd.g_old_rec.attribute17
423: ,p_attribute18_o
424: => per_sip_shd.g_old_rec.attribute18
425: ,p_attribute19_o
426: => per_sip_shd.g_old_rec.attribute19
420: => per_sip_shd.g_old_rec.attribute16
421: ,p_attribute17_o
422: => per_sip_shd.g_old_rec.attribute17
423: ,p_attribute18_o
424: => per_sip_shd.g_old_rec.attribute18
425: ,p_attribute19_o
426: => per_sip_shd.g_old_rec.attribute19
427: ,p_attribute20_o
428: => per_sip_shd.g_old_rec.attribute20
422: => per_sip_shd.g_old_rec.attribute17
423: ,p_attribute18_o
424: => per_sip_shd.g_old_rec.attribute18
425: ,p_attribute19_o
426: => per_sip_shd.g_old_rec.attribute19
427: ,p_attribute20_o
428: => per_sip_shd.g_old_rec.attribute20
429: ,p_planned_date_o
430: => per_sip_shd.g_old_rec.planned_date
424: => per_sip_shd.g_old_rec.attribute18
425: ,p_attribute19_o
426: => per_sip_shd.g_old_rec.attribute19
427: ,p_attribute20_o
428: => per_sip_shd.g_old_rec.attribute20
429: ,p_planned_date_o
430: => per_sip_shd.g_old_rec.planned_date
431: ,p_assignment_id_o
432: => per_sip_shd.g_old_rec.assignment_id
426: => per_sip_shd.g_old_rec.attribute19
427: ,p_attribute20_o
428: => per_sip_shd.g_old_rec.attribute20
429: ,p_planned_date_o
430: => per_sip_shd.g_old_rec.planned_date
431: ,p_assignment_id_o
432: => per_sip_shd.g_old_rec.assignment_id
433: ,p_supervisor_id_o
434: => per_sip_shd.g_old_rec.supervisor_id
428: => per_sip_shd.g_old_rec.attribute20
429: ,p_planned_date_o
430: => per_sip_shd.g_old_rec.planned_date
431: ,p_assignment_id_o
432: => per_sip_shd.g_old_rec.assignment_id
433: ,p_supervisor_id_o
434: => per_sip_shd.g_old_rec.supervisor_id
435: ,p_grade_id_o
436: => per_sip_shd.g_old_rec.grade_id
430: => per_sip_shd.g_old_rec.planned_date
431: ,p_assignment_id_o
432: => per_sip_shd.g_old_rec.assignment_id
433: ,p_supervisor_id_o
434: => per_sip_shd.g_old_rec.supervisor_id
435: ,p_grade_id_o
436: => per_sip_shd.g_old_rec.grade_id
437: ,p_grade_ladder_id_o
438: => per_sip_shd.g_old_rec.grade_ladder_id
432: => per_sip_shd.g_old_rec.assignment_id
433: ,p_supervisor_id_o
434: => per_sip_shd.g_old_rec.supervisor_id
435: ,p_grade_id_o
436: => per_sip_shd.g_old_rec.grade_id
437: ,p_grade_ladder_id_o
438: => per_sip_shd.g_old_rec.grade_ladder_id
439: ,p_grade_step_id_o
440: => per_sip_shd.g_old_rec.grade_step_id
434: => per_sip_shd.g_old_rec.supervisor_id
435: ,p_grade_id_o
436: => per_sip_shd.g_old_rec.grade_id
437: ,p_grade_ladder_id_o
438: => per_sip_shd.g_old_rec.grade_ladder_id
439: ,p_grade_step_id_o
440: => per_sip_shd.g_old_rec.grade_step_id
441: ,p_grade_point_id_o
442: => per_sip_shd.g_old_rec.grade_point_id
436: => per_sip_shd.g_old_rec.grade_id
437: ,p_grade_ladder_id_o
438: => per_sip_shd.g_old_rec.grade_ladder_id
439: ,p_grade_step_id_o
440: => per_sip_shd.g_old_rec.grade_step_id
441: ,p_grade_point_id_o
442: => per_sip_shd.g_old_rec.grade_point_id
443: ,p_position_id_o
444: => per_sip_shd.g_old_rec.position_id
438: => per_sip_shd.g_old_rec.grade_ladder_id
439: ,p_grade_step_id_o
440: => per_sip_shd.g_old_rec.grade_step_id
441: ,p_grade_point_id_o
442: => per_sip_shd.g_old_rec.grade_point_id
443: ,p_position_id_o
444: => per_sip_shd.g_old_rec.position_id
445: ,p_job_id_o
446: => per_sip_shd.g_old_rec.job_id
440: => per_sip_shd.g_old_rec.grade_step_id
441: ,p_grade_point_id_o
442: => per_sip_shd.g_old_rec.grade_point_id
443: ,p_position_id_o
444: => per_sip_shd.g_old_rec.position_id
445: ,p_job_id_o
446: => per_sip_shd.g_old_rec.job_id
447: ,p_assignment_status_type_id_o
448: => per_sip_shd.g_old_rec.assignment_status_type_id
442: => per_sip_shd.g_old_rec.grade_point_id
443: ,p_position_id_o
444: => per_sip_shd.g_old_rec.position_id
445: ,p_job_id_o
446: => per_sip_shd.g_old_rec.job_id
447: ,p_assignment_status_type_id_o
448: => per_sip_shd.g_old_rec.assignment_status_type_id
449: ,p_organization_id_o
450: => per_sip_shd.g_old_rec.organization_id
444: => per_sip_shd.g_old_rec.position_id
445: ,p_job_id_o
446: => per_sip_shd.g_old_rec.job_id
447: ,p_assignment_status_type_id_o
448: => per_sip_shd.g_old_rec.assignment_status_type_id
449: ,p_organization_id_o
450: => per_sip_shd.g_old_rec.organization_id
451: ,p_people_group_id_o
452: => per_sip_shd.g_old_rec.people_group_id
446: => per_sip_shd.g_old_rec.job_id
447: ,p_assignment_status_type_id_o
448: => per_sip_shd.g_old_rec.assignment_status_type_id
449: ,p_organization_id_o
450: => per_sip_shd.g_old_rec.organization_id
451: ,p_people_group_id_o
452: => per_sip_shd.g_old_rec.people_group_id
453: ,p_pay_basis_id_o
454: => per_sip_shd.g_old_rec.pay_basis_id
448: => per_sip_shd.g_old_rec.assignment_status_type_id
449: ,p_organization_id_o
450: => per_sip_shd.g_old_rec.organization_id
451: ,p_people_group_id_o
452: => per_sip_shd.g_old_rec.people_group_id
453: ,p_pay_basis_id_o
454: => per_sip_shd.g_old_rec.pay_basis_id
455: ,p_employee_category_o
456: => per_sip_shd.g_old_rec.employee_category
450: => per_sip_shd.g_old_rec.organization_id
451: ,p_people_group_id_o
452: => per_sip_shd.g_old_rec.people_group_id
453: ,p_pay_basis_id_o
454: => per_sip_shd.g_old_rec.pay_basis_id
455: ,p_employee_category_o
456: => per_sip_shd.g_old_rec.employee_category
457: ,p_bargaining_unit_code_o
458: => per_sip_shd.g_old_rec.bargaining_unit_code
452: => per_sip_shd.g_old_rec.people_group_id
453: ,p_pay_basis_id_o
454: => per_sip_shd.g_old_rec.pay_basis_id
455: ,p_employee_category_o
456: => per_sip_shd.g_old_rec.employee_category
457: ,p_bargaining_unit_code_o
458: => per_sip_shd.g_old_rec.bargaining_unit_code
459: ,p_labour_union_member_flag_o
460: => per_sip_shd.g_old_rec.labour_union_member_flag
454: => per_sip_shd.g_old_rec.pay_basis_id
455: ,p_employee_category_o
456: => per_sip_shd.g_old_rec.employee_category
457: ,p_bargaining_unit_code_o
458: => per_sip_shd.g_old_rec.bargaining_unit_code
459: ,p_labour_union_member_flag_o
460: => per_sip_shd.g_old_rec.labour_union_member_flag
461: ,p_collective_agreement_id_o
462: => per_sip_shd.g_old_rec.collective_agreement_id
456: => per_sip_shd.g_old_rec.employee_category
457: ,p_bargaining_unit_code_o
458: => per_sip_shd.g_old_rec.bargaining_unit_code
459: ,p_labour_union_member_flag_o
460: => per_sip_shd.g_old_rec.labour_union_member_flag
461: ,p_collective_agreement_id_o
462: => per_sip_shd.g_old_rec.collective_agreement_id
463: ,p_assignment_category_o
464: => per_sip_shd.g_old_rec.assignment_category
458: => per_sip_shd.g_old_rec.bargaining_unit_code
459: ,p_labour_union_member_flag_o
460: => per_sip_shd.g_old_rec.labour_union_member_flag
461: ,p_collective_agreement_id_o
462: => per_sip_shd.g_old_rec.collective_agreement_id
463: ,p_assignment_category_o
464: => per_sip_shd.g_old_rec.assignment_category
465: ,p_location_id_o
466: => per_sip_shd.g_old_rec.location_id
460: => per_sip_shd.g_old_rec.labour_union_member_flag
461: ,p_collective_agreement_id_o
462: => per_sip_shd.g_old_rec.collective_agreement_id
463: ,p_assignment_category_o
464: => per_sip_shd.g_old_rec.assignment_category
465: ,p_location_id_o
466: => per_sip_shd.g_old_rec.location_id
467: ,p_contract_id_o
468: => per_sip_shd.g_old_rec.contract_id
462: => per_sip_shd.g_old_rec.collective_agreement_id
463: ,p_assignment_category_o
464: => per_sip_shd.g_old_rec.assignment_category
465: ,p_location_id_o
466: => per_sip_shd.g_old_rec.location_id
467: ,p_contract_id_o
468: => per_sip_shd.g_old_rec.contract_id
469: ,p_object_version_number_o
470: => per_sip_shd.g_old_rec.object_version_number
464: => per_sip_shd.g_old_rec.assignment_category
465: ,p_location_id_o
466: => per_sip_shd.g_old_rec.location_id
467: ,p_contract_id_o
468: => per_sip_shd.g_old_rec.contract_id
469: ,p_object_version_number_o
470: => per_sip_shd.g_old_rec.object_version_number
471: );
472: --
466: => per_sip_shd.g_old_rec.location_id
467: ,p_contract_id_o
468: => per_sip_shd.g_old_rec.contract_id
469: ,p_object_version_number_o
470: => per_sip_shd.g_old_rec.object_version_number
471: );
472: --
473: exception
474: --
526: --
527: -- {End Of Comments}
528: -- ----------------------------------------------------------------------------
529: Procedure convert_defs
530: (p_rec in out nocopy per_sip_shd.g_rec_type
531: ) is
532: --
533: Begin
534: --
538: -- is being used then we must set to the 'current' argument value.
539: --
540: If (p_rec.plan_id = hr_api.g_number) then
541: p_rec.plan_id :=
542: per_sip_shd.g_old_rec.plan_id;
543: End If;
544: If (p_rec.successor_id = hr_api.g_number) then
545: p_rec.successor_id :=
546: per_sip_shd.g_old_rec.successor_id;
542: per_sip_shd.g_old_rec.plan_id;
543: End If;
544: If (p_rec.successor_id = hr_api.g_number) then
545: p_rec.successor_id :=
546: per_sip_shd.g_old_rec.successor_id;
547: End If;
548: If (p_rec.business_group_id = hr_api.g_number) then
549: p_rec.business_group_id :=
550: per_sip_shd.g_old_rec.business_group_id;
546: per_sip_shd.g_old_rec.successor_id;
547: End If;
548: If (p_rec.business_group_id = hr_api.g_number) then
549: p_rec.business_group_id :=
550: per_sip_shd.g_old_rec.business_group_id;
551: End If;
552: If (p_rec.status = hr_api.g_varchar2) then
553: p_rec.status :=
554: per_sip_shd.g_old_rec.status;
550: per_sip_shd.g_old_rec.business_group_id;
551: End If;
552: If (p_rec.status = hr_api.g_varchar2) then
553: p_rec.status :=
554: per_sip_shd.g_old_rec.status;
555: End If;
556: If (p_rec.potential = hr_api.g_varchar2) then
557: p_rec.potential :=
558: per_sip_shd.g_old_rec.potential;
554: per_sip_shd.g_old_rec.status;
555: End If;
556: If (p_rec.potential = hr_api.g_varchar2) then
557: p_rec.potential :=
558: per_sip_shd.g_old_rec.potential;
559: End If;
560: If (p_rec.performance_rating = hr_api.g_varchar2) then
561: p_rec.performance_rating :=
562: per_sip_shd.g_old_rec.performance_rating;
558: per_sip_shd.g_old_rec.potential;
559: End If;
560: If (p_rec.performance_rating = hr_api.g_varchar2) then
561: p_rec.performance_rating :=
562: per_sip_shd.g_old_rec.performance_rating;
563: End If;
564: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
565: p_rec.risk_of_loss :=
566: per_sip_shd.g_old_rec.risk_of_loss;
562: per_sip_shd.g_old_rec.performance_rating;
563: End If;
564: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
565: p_rec.risk_of_loss :=
566: per_sip_shd.g_old_rec.risk_of_loss;
567: End If;
568: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
569: p_rec.impact_of_loss :=
570: per_sip_shd.g_old_rec.impact_of_loss;
566: per_sip_shd.g_old_rec.risk_of_loss;
567: End If;
568: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
569: p_rec.impact_of_loss :=
570: per_sip_shd.g_old_rec.impact_of_loss;
571: End If;
572: If (p_rec.readiness_pct = hr_api.g_number) then
573: p_rec.readiness_pct :=
574: per_sip_shd.g_old_rec.readiness_pct;
570: per_sip_shd.g_old_rec.impact_of_loss;
571: End If;
572: If (p_rec.readiness_pct = hr_api.g_number) then
573: p_rec.readiness_pct :=
574: per_sip_shd.g_old_rec.readiness_pct;
575: End If;
576: If (p_rec.rank = hr_api.g_number) then
577: p_rec.rank :=
578: per_sip_shd.g_old_rec.rank;
574: per_sip_shd.g_old_rec.readiness_pct;
575: End If;
576: If (p_rec.rank = hr_api.g_number) then
577: p_rec.rank :=
578: per_sip_shd.g_old_rec.rank;
579: End If;
580: If (p_rec.eligible_for_promotion = hr_api.g_varchar2) then
581: p_rec.eligible_for_promotion :=
582: per_sip_shd.g_old_rec.eligible_for_promotion;
578: per_sip_shd.g_old_rec.rank;
579: End If;
580: If (p_rec.eligible_for_promotion = hr_api.g_varchar2) then
581: p_rec.eligible_for_promotion :=
582: per_sip_shd.g_old_rec.eligible_for_promotion;
583: End If;
584: If (p_rec.earliest_succession_date = hr_api.g_date) then
585: p_rec.earliest_succession_date :=
586: per_sip_shd.g_old_rec.earliest_succession_date;
582: per_sip_shd.g_old_rec.eligible_for_promotion;
583: End If;
584: If (p_rec.earliest_succession_date = hr_api.g_date) then
585: p_rec.earliest_succession_date :=
586: per_sip_shd.g_old_rec.earliest_succession_date;
587: End If;
588: If (p_rec.latest_succession_date = hr_api.g_date) then
589: p_rec.latest_succession_date :=
590: per_sip_shd.g_old_rec.latest_succession_date;
586: per_sip_shd.g_old_rec.earliest_succession_date;
587: End If;
588: If (p_rec.latest_succession_date = hr_api.g_date) then
589: p_rec.latest_succession_date :=
590: per_sip_shd.g_old_rec.latest_succession_date;
591: End If;
592: If (p_rec.comments = hr_api.g_varchar2) then
593: p_rec.comments :=
594: per_sip_shd.g_old_rec.comments;
590: per_sip_shd.g_old_rec.latest_succession_date;
591: End If;
592: If (p_rec.comments = hr_api.g_varchar2) then
593: p_rec.comments :=
594: per_sip_shd.g_old_rec.comments;
595: End If;
596: If (p_rec.attribute_category = hr_api.g_varchar2) then
597: p_rec.attribute_category :=
598: per_sip_shd.g_old_rec.attribute_category;
594: per_sip_shd.g_old_rec.comments;
595: End If;
596: If (p_rec.attribute_category = hr_api.g_varchar2) then
597: p_rec.attribute_category :=
598: per_sip_shd.g_old_rec.attribute_category;
599: End If;
600: If (p_rec.attribute1 = hr_api.g_varchar2) then
601: p_rec.attribute1 :=
602: per_sip_shd.g_old_rec.attribute1;
598: per_sip_shd.g_old_rec.attribute_category;
599: End If;
600: If (p_rec.attribute1 = hr_api.g_varchar2) then
601: p_rec.attribute1 :=
602: per_sip_shd.g_old_rec.attribute1;
603: End If;
604: If (p_rec.attribute2 = hr_api.g_varchar2) then
605: p_rec.attribute2 :=
606: per_sip_shd.g_old_rec.attribute2;
602: per_sip_shd.g_old_rec.attribute1;
603: End If;
604: If (p_rec.attribute2 = hr_api.g_varchar2) then
605: p_rec.attribute2 :=
606: per_sip_shd.g_old_rec.attribute2;
607: End If;
608: If (p_rec.attribute3 = hr_api.g_varchar2) then
609: p_rec.attribute3 :=
610: per_sip_shd.g_old_rec.attribute3;
606: per_sip_shd.g_old_rec.attribute2;
607: End If;
608: If (p_rec.attribute3 = hr_api.g_varchar2) then
609: p_rec.attribute3 :=
610: per_sip_shd.g_old_rec.attribute3;
611: End If;
612: If (p_rec.attribute4 = hr_api.g_varchar2) then
613: p_rec.attribute4 :=
614: per_sip_shd.g_old_rec.attribute4;
610: per_sip_shd.g_old_rec.attribute3;
611: End If;
612: If (p_rec.attribute4 = hr_api.g_varchar2) then
613: p_rec.attribute4 :=
614: per_sip_shd.g_old_rec.attribute4;
615: End If;
616: If (p_rec.attribute5 = hr_api.g_varchar2) then
617: p_rec.attribute5 :=
618: per_sip_shd.g_old_rec.attribute5;
614: per_sip_shd.g_old_rec.attribute4;
615: End If;
616: If (p_rec.attribute5 = hr_api.g_varchar2) then
617: p_rec.attribute5 :=
618: per_sip_shd.g_old_rec.attribute5;
619: End If;
620: If (p_rec.attribute6 = hr_api.g_varchar2) then
621: p_rec.attribute6 :=
622: per_sip_shd.g_old_rec.attribute6;
618: per_sip_shd.g_old_rec.attribute5;
619: End If;
620: If (p_rec.attribute6 = hr_api.g_varchar2) then
621: p_rec.attribute6 :=
622: per_sip_shd.g_old_rec.attribute6;
623: End If;
624: If (p_rec.attribute7 = hr_api.g_varchar2) then
625: p_rec.attribute7 :=
626: per_sip_shd.g_old_rec.attribute7;
622: per_sip_shd.g_old_rec.attribute6;
623: End If;
624: If (p_rec.attribute7 = hr_api.g_varchar2) then
625: p_rec.attribute7 :=
626: per_sip_shd.g_old_rec.attribute7;
627: End If;
628: If (p_rec.attribute8 = hr_api.g_varchar2) then
629: p_rec.attribute8 :=
630: per_sip_shd.g_old_rec.attribute8;
626: per_sip_shd.g_old_rec.attribute7;
627: End If;
628: If (p_rec.attribute8 = hr_api.g_varchar2) then
629: p_rec.attribute8 :=
630: per_sip_shd.g_old_rec.attribute8;
631: End If;
632: If (p_rec.attribute9 = hr_api.g_varchar2) then
633: p_rec.attribute9 :=
634: per_sip_shd.g_old_rec.attribute9;
630: per_sip_shd.g_old_rec.attribute8;
631: End If;
632: If (p_rec.attribute9 = hr_api.g_varchar2) then
633: p_rec.attribute9 :=
634: per_sip_shd.g_old_rec.attribute9;
635: End If;
636: If (p_rec.attribute10 = hr_api.g_varchar2) then
637: p_rec.attribute10 :=
638: per_sip_shd.g_old_rec.attribute10;
634: per_sip_shd.g_old_rec.attribute9;
635: End If;
636: If (p_rec.attribute10 = hr_api.g_varchar2) then
637: p_rec.attribute10 :=
638: per_sip_shd.g_old_rec.attribute10;
639: End If;
640: If (p_rec.attribute11 = hr_api.g_varchar2) then
641: p_rec.attribute11 :=
642: per_sip_shd.g_old_rec.attribute11;
638: per_sip_shd.g_old_rec.attribute10;
639: End If;
640: If (p_rec.attribute11 = hr_api.g_varchar2) then
641: p_rec.attribute11 :=
642: per_sip_shd.g_old_rec.attribute11;
643: End If;
644: If (p_rec.attribute12 = hr_api.g_varchar2) then
645: p_rec.attribute12 :=
646: per_sip_shd.g_old_rec.attribute12;
642: per_sip_shd.g_old_rec.attribute11;
643: End If;
644: If (p_rec.attribute12 = hr_api.g_varchar2) then
645: p_rec.attribute12 :=
646: per_sip_shd.g_old_rec.attribute12;
647: End If;
648: If (p_rec.attribute13 = hr_api.g_varchar2) then
649: p_rec.attribute13 :=
650: per_sip_shd.g_old_rec.attribute13;
646: per_sip_shd.g_old_rec.attribute12;
647: End If;
648: If (p_rec.attribute13 = hr_api.g_varchar2) then
649: p_rec.attribute13 :=
650: per_sip_shd.g_old_rec.attribute13;
651: End If;
652: If (p_rec.attribute14 = hr_api.g_varchar2) then
653: p_rec.attribute14 :=
654: per_sip_shd.g_old_rec.attribute14;
650: per_sip_shd.g_old_rec.attribute13;
651: End If;
652: If (p_rec.attribute14 = hr_api.g_varchar2) then
653: p_rec.attribute14 :=
654: per_sip_shd.g_old_rec.attribute14;
655: End If;
656: If (p_rec.attribute15 = hr_api.g_varchar2) then
657: p_rec.attribute15 :=
658: per_sip_shd.g_old_rec.attribute15;
654: per_sip_shd.g_old_rec.attribute14;
655: End If;
656: If (p_rec.attribute15 = hr_api.g_varchar2) then
657: p_rec.attribute15 :=
658: per_sip_shd.g_old_rec.attribute15;
659: End If;
660: If (p_rec.attribute16 = hr_api.g_varchar2) then
661: p_rec.attribute16 :=
662: per_sip_shd.g_old_rec.attribute16;
658: per_sip_shd.g_old_rec.attribute15;
659: End If;
660: If (p_rec.attribute16 = hr_api.g_varchar2) then
661: p_rec.attribute16 :=
662: per_sip_shd.g_old_rec.attribute16;
663: End If;
664: If (p_rec.attribute17 = hr_api.g_varchar2) then
665: p_rec.attribute17 :=
666: per_sip_shd.g_old_rec.attribute17;
662: per_sip_shd.g_old_rec.attribute16;
663: End If;
664: If (p_rec.attribute17 = hr_api.g_varchar2) then
665: p_rec.attribute17 :=
666: per_sip_shd.g_old_rec.attribute17;
667: End If;
668: If (p_rec.attribute18 = hr_api.g_varchar2) then
669: p_rec.attribute18 :=
670: per_sip_shd.g_old_rec.attribute18;
666: per_sip_shd.g_old_rec.attribute17;
667: End If;
668: If (p_rec.attribute18 = hr_api.g_varchar2) then
669: p_rec.attribute18 :=
670: per_sip_shd.g_old_rec.attribute18;
671: End If;
672: If (p_rec.attribute19 = hr_api.g_varchar2) then
673: p_rec.attribute19 :=
674: per_sip_shd.g_old_rec.attribute19;
670: per_sip_shd.g_old_rec.attribute18;
671: End If;
672: If (p_rec.attribute19 = hr_api.g_varchar2) then
673: p_rec.attribute19 :=
674: per_sip_shd.g_old_rec.attribute19;
675: End If;
676: If (p_rec.attribute20 = hr_api.g_varchar2) then
677: p_rec.attribute20 :=
678: per_sip_shd.g_old_rec.attribute20;
674: per_sip_shd.g_old_rec.attribute19;
675: End If;
676: If (p_rec.attribute20 = hr_api.g_varchar2) then
677: p_rec.attribute20 :=
678: per_sip_shd.g_old_rec.attribute20;
679: End If;
680: If (p_rec.planned_date = hr_api.g_date) then
681: p_rec.planned_date :=
682: per_sip_shd.g_old_rec.planned_date;
678: per_sip_shd.g_old_rec.attribute20;
679: End If;
680: If (p_rec.planned_date = hr_api.g_date) then
681: p_rec.planned_date :=
682: per_sip_shd.g_old_rec.planned_date;
683: End If;
684: If (p_rec.assignment_id = hr_api.g_number) then
685: p_rec.assignment_id :=
686: per_sip_shd.g_old_rec.assignment_id;
682: per_sip_shd.g_old_rec.planned_date;
683: End If;
684: If (p_rec.assignment_id = hr_api.g_number) then
685: p_rec.assignment_id :=
686: per_sip_shd.g_old_rec.assignment_id;
687: End If;
688: If (p_rec.supervisor_id = hr_api.g_number) then
689: p_rec.supervisor_id :=
690: per_sip_shd.g_old_rec.supervisor_id;
686: per_sip_shd.g_old_rec.assignment_id;
687: End If;
688: If (p_rec.supervisor_id = hr_api.g_number) then
689: p_rec.supervisor_id :=
690: per_sip_shd.g_old_rec.supervisor_id;
691: End If;
692: If (p_rec.grade_id = hr_api.g_number) then
693: p_rec.grade_id :=
694: per_sip_shd.g_old_rec.grade_id;
690: per_sip_shd.g_old_rec.supervisor_id;
691: End If;
692: If (p_rec.grade_id = hr_api.g_number) then
693: p_rec.grade_id :=
694: per_sip_shd.g_old_rec.grade_id;
695: End If;
696: If (p_rec.grade_ladder_id = hr_api.g_number) then
697: p_rec.grade_ladder_id :=
698: per_sip_shd.g_old_rec.grade_ladder_id;
694: per_sip_shd.g_old_rec.grade_id;
695: End If;
696: If (p_rec.grade_ladder_id = hr_api.g_number) then
697: p_rec.grade_ladder_id :=
698: per_sip_shd.g_old_rec.grade_ladder_id;
699: End If;
700: If (p_rec.grade_step_id = hr_api.g_number) then
701: p_rec.grade_step_id :=
702: per_sip_shd.g_old_rec.grade_step_id;
698: per_sip_shd.g_old_rec.grade_ladder_id;
699: End If;
700: If (p_rec.grade_step_id = hr_api.g_number) then
701: p_rec.grade_step_id :=
702: per_sip_shd.g_old_rec.grade_step_id;
703: End If;
704: If (p_rec.grade_point_id = hr_api.g_number) then
705: p_rec.grade_point_id :=
706: per_sip_shd.g_old_rec.grade_point_id;
702: per_sip_shd.g_old_rec.grade_step_id;
703: End If;
704: If (p_rec.grade_point_id = hr_api.g_number) then
705: p_rec.grade_point_id :=
706: per_sip_shd.g_old_rec.grade_point_id;
707: End If;
708: If (p_rec.position_id = hr_api.g_number) then
709: p_rec.position_id :=
710: per_sip_shd.g_old_rec.position_id;
706: per_sip_shd.g_old_rec.grade_point_id;
707: End If;
708: If (p_rec.position_id = hr_api.g_number) then
709: p_rec.position_id :=
710: per_sip_shd.g_old_rec.position_id;
711: End If;
712: If (p_rec.job_id = hr_api.g_number) then
713: p_rec.job_id :=
714: per_sip_shd.g_old_rec.job_id;
710: per_sip_shd.g_old_rec.position_id;
711: End If;
712: If (p_rec.job_id = hr_api.g_number) then
713: p_rec.job_id :=
714: per_sip_shd.g_old_rec.job_id;
715: End If;
716: If (p_rec.assignment_status_type_id = hr_api.g_number) then
717: p_rec.assignment_status_type_id :=
718: per_sip_shd.g_old_rec.assignment_status_type_id;
714: per_sip_shd.g_old_rec.job_id;
715: End If;
716: If (p_rec.assignment_status_type_id = hr_api.g_number) then
717: p_rec.assignment_status_type_id :=
718: per_sip_shd.g_old_rec.assignment_status_type_id;
719: End If;
720: If (p_rec.organization_id = hr_api.g_number) then
721: p_rec.organization_id :=
722: per_sip_shd.g_old_rec.organization_id;
718: per_sip_shd.g_old_rec.assignment_status_type_id;
719: End If;
720: If (p_rec.organization_id = hr_api.g_number) then
721: p_rec.organization_id :=
722: per_sip_shd.g_old_rec.organization_id;
723: End If;
724: If (p_rec.people_group_id = hr_api.g_number) then
725: p_rec.people_group_id :=
726: per_sip_shd.g_old_rec.people_group_id;
722: per_sip_shd.g_old_rec.organization_id;
723: End If;
724: If (p_rec.people_group_id = hr_api.g_number) then
725: p_rec.people_group_id :=
726: per_sip_shd.g_old_rec.people_group_id;
727: End If;
728: If (p_rec.pay_basis_id = hr_api.g_number) then
729: p_rec.pay_basis_id :=
730: per_sip_shd.g_old_rec.pay_basis_id;
726: per_sip_shd.g_old_rec.people_group_id;
727: End If;
728: If (p_rec.pay_basis_id = hr_api.g_number) then
729: p_rec.pay_basis_id :=
730: per_sip_shd.g_old_rec.pay_basis_id;
731: End If;
732: If (p_rec.employee_category = hr_api.g_varchar2) then
733: p_rec.employee_category :=
734: per_sip_shd.g_old_rec.employee_category;
730: per_sip_shd.g_old_rec.pay_basis_id;
731: End If;
732: If (p_rec.employee_category = hr_api.g_varchar2) then
733: p_rec.employee_category :=
734: per_sip_shd.g_old_rec.employee_category;
735: End If;
736: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
737: p_rec.bargaining_unit_code :=
738: per_sip_shd.g_old_rec.bargaining_unit_code;
734: per_sip_shd.g_old_rec.employee_category;
735: End If;
736: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
737: p_rec.bargaining_unit_code :=
738: per_sip_shd.g_old_rec.bargaining_unit_code;
739: End If;
740: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
741: p_rec.labour_union_member_flag :=
742: per_sip_shd.g_old_rec.labour_union_member_flag;
738: per_sip_shd.g_old_rec.bargaining_unit_code;
739: End If;
740: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
741: p_rec.labour_union_member_flag :=
742: per_sip_shd.g_old_rec.labour_union_member_flag;
743: End If;
744: If (p_rec.collective_agreement_id = hr_api.g_number) then
745: p_rec.collective_agreement_id :=
746: per_sip_shd.g_old_rec.collective_agreement_id;
742: per_sip_shd.g_old_rec.labour_union_member_flag;
743: End If;
744: If (p_rec.collective_agreement_id = hr_api.g_number) then
745: p_rec.collective_agreement_id :=
746: per_sip_shd.g_old_rec.collective_agreement_id;
747: End If;
748: If (p_rec.assignment_category = hr_api.g_varchar2) then
749: p_rec.assignment_category :=
750: per_sip_shd.g_old_rec.assignment_category;
746: per_sip_shd.g_old_rec.collective_agreement_id;
747: End If;
748: If (p_rec.assignment_category = hr_api.g_varchar2) then
749: p_rec.assignment_category :=
750: per_sip_shd.g_old_rec.assignment_category;
751: End If;
752: If (p_rec.location_id = hr_api.g_number) then
753: p_rec.location_id :=
754: per_sip_shd.g_old_rec.location_id;
750: per_sip_shd.g_old_rec.assignment_category;
751: End If;
752: If (p_rec.location_id = hr_api.g_number) then
753: p_rec.location_id :=
754: per_sip_shd.g_old_rec.location_id;
755: End If;
756: If (p_rec.contract_id = hr_api.g_number) then
757: p_rec.contract_id :=
758: per_sip_shd.g_old_rec.contract_id;
754: per_sip_shd.g_old_rec.location_id;
755: End If;
756: If (p_rec.contract_id = hr_api.g_number) then
757: p_rec.contract_id :=
758: per_sip_shd.g_old_rec.contract_id;
759: End If;
760: --
761: End convert_defs;
762: --
764: -- |---------------------------------< upd >----------------------------------|
765: -- ----------------------------------------------------------------------------
766: Procedure upd
767: (p_effective_date in date
768: ,p_rec in out nocopy per_sip_shd.g_rec_type
769: ) is
770: --
771: l_proc varchar2(72) := g_package||'upd';
772: --
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- We must lock the row which we need to update.
777: --
778: per_sip_shd.lck
779: (p_rec.successor_in_plan_id
780: ,p_rec.object_version_number
781: );
782: --
877: ,p_location_id in number default hr_api.g_number
878: ,p_contract_id in number default hr_api.g_number
879: ) is
880: --
881: l_rec per_sip_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'upd';
883: --
884: Begin
885: hr_utility.set_location('Entering:'||l_proc, 5);
887: -- Call conversion function to turn arguments into the
888: -- l_rec structure.
889: --
890: l_rec :=
891: per_sip_shd.convert_args
892: (p_successor_in_plan_id
893: ,p_plan_id
894: ,p_successor_id
895: ,p_business_group_id