37: p_effective_date in date default hr_api.g_date
38: ) IS
39: l_proc VARCHAR2(80) := g_package||'import_succession_plan';
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
38: ) IS
39: l_proc VARCHAR2(80) := g_package||'import_succession_plan';
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
39: l_proc VARCHAR2(80) := g_package||'import_succession_plan';
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
50: hr_utility.set_location('INSERT Block '||l_proc,20);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
50: hr_utility.set_location('INSERT Block '||l_proc,20);
51: per_suc_ins.ins(
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
50: hr_utility.set_location('INSERT Block '||l_proc,20);
51: per_suc_ins.ins(
52: p_succession_plan_id => p_succession_plan_id
53: ,p_person_id => p_person_id
54: ,p_position_id => p_position_id
80: ,p_attribute18 => NULL
81: ,p_attribute19 => NULL
82: ,p_attribute20 => NULL
83: ,p_effective_date => TRUNC(SYSDATE));
84: hr_utility.set_location('INSERT Complete '||l_proc,30);
85: ELSE
86: hr_utility.set_location('UPDATE Block '||l_proc,40);
87: per_suc_upd.upd(
88: p_succession_plan_id => p_succession_plan_id
82: ,p_attribute20 => NULL
83: ,p_effective_date => TRUNC(SYSDATE));
84: hr_utility.set_location('INSERT Complete '||l_proc,30);
85: ELSE
86: hr_utility.set_location('UPDATE Block '||l_proc,40);
87: per_suc_upd.upd(
88: p_succession_plan_id => p_succession_plan_id
89: ,p_person_id => p_person_id
90: ,p_position_id => p_position_id
116: ,p_attribute18 => NULL
117: ,p_attribute19 => NULL
118: ,p_attribute20 => NULL
119: ,p_effective_date => TRUNC(SYSDATE));
120: hr_utility.set_location('UPDATE Complete '||l_proc,50);
121: END IF;
122: hr_utility.set_location('Leaving '||l_proc,60);
123: EXCEPTION
124: WHEN OTHERS THEN
118: ,p_attribute20 => NULL
119: ,p_effective_date => TRUNC(SYSDATE));
120: hr_utility.set_location('UPDATE Complete '||l_proc,50);
121: END IF;
122: hr_utility.set_location('Leaving '||l_proc,60);
123: EXCEPTION
124: WHEN OTHERS THEN
125: hr_utility.set_location('Error: '||l_proc,70);
126: RAISE;
121: END IF;
122: hr_utility.set_location('Leaving '||l_proc,60);
123: EXCEPTION
124: WHEN OTHERS THEN
125: hr_utility.set_location('Error: '||l_proc,70);
126: RAISE;
127: END import_succession_plan;
128: END per_succession_plan_utility;