[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_succession_plan (
p_validate IN BOOLEAN DEFAULT FALSE,
p_succession_plan_id IN NUMBER,
p_person_id IN NUMBER DEFAULT hr_api.g_number,
p_position_id IN NUMBER DEFAULT hr_api.g_number,
p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
p_start_date IN DATE DEFAULT hr_api.g_date,
p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_end_date IN DATE DEFAULT hr_api.g_date,
p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_effective_date IN DATE,
p_job_id IN NUMBER DEFAULT hr_api.g_number,
p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
p_person_rank IN NUMBER DEFAULT hr_api.g_number,
p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
p_object_version_number IN OUT NOCOPY NUMBER
)
IS
--
-- Declare cursors and local variables
--
l_succession_plan_id per_succession_planning.succession_plan_id%TYPE;
l_proc VARCHAR2 (72) := g_package || 'update_succession_plan';
SAVEPOINT update_succession_plan;
per_succession_plan_bk2.update_succession_plan_b
(p_person_id => p_person_id,
p_position_id => p_position_id,
p_business_group_id => p_business_group_id,
p_start_date => l_start_date,
p_time_scale => p_time_scale,
p_end_date => l_end_date,
p_available_for_promotion => p_available_for_promotion,
p_manager_comments => p_manager_comments,
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
p_effective_date => l_effective_date,
p_job_id => p_job_id,
p_successee_person_id => p_successee_person_id,
p_person_rank => p_person_rank,
p_performance => p_performance,
p_plan_status => p_plan_status,
p_readiness_percentage => p_readiness_percentage,
p_succession_plan_id => p_succession_plan_id,
p_object_version_number => p_object_version_number
);
hr_api.cannot_find_prog_unit_error (p_module_name => 'update_succession_plan',
p_hook_type => 'BP'
);
hr_utility.set_location ('Entering:' || 'PER_SUCCESSION_PLAN_BK1.update_succession_plan_a',
60);
per_succession_plan_bk2.update_succession_plan_a
(p_person_id => p_person_id,
p_position_id => p_position_id,
p_business_group_id => p_business_group_id,
p_start_date => l_start_date,
p_time_scale => p_time_scale,
p_end_date => l_end_date,
p_available_for_promotion => p_available_for_promotion,
p_manager_comments => p_manager_comments,
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
p_effective_date => l_effective_date,
p_job_id => p_job_id,
p_successee_person_id => p_successee_person_id,
p_person_rank => p_person_rank,
p_performance => p_performance,
p_plan_status => p_plan_status,
p_readiness_percentage => p_readiness_percentage,
p_succession_plan_id => l_succession_plan_id,
p_object_version_number => l_object_version_number
);
hr_api.cannot_find_prog_unit_error (p_module_name => 'update_succession_plan',
p_hook_type => 'AP'
);
ROLLBACK TO update_succession_plan;
ROLLBACK TO update_succession_plan;
END update_succession_plan;
PROCEDURE delete_succession_plan (
p_validate IN BOOLEAN DEFAULT FALSE,
p_succession_plan_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
--
-- Declare cursors and local variables
--
--
--
l_proc VARCHAR2 (72) := g_package || 'delete_succession_plan';
SAVEPOINT delete_succession_plan;
per_succession_plan_bk3.delete_succession_plan_b
(p_succession_plan_id => p_succession_plan_id,
p_object_version_number => p_object_version_number
);
hr_api.cannot_find_prog_unit_error (p_module_name => 'delete_succession_plan',
p_hook_type => 'BP'
);
per_succession_plan_bk3.delete_succession_plan_a
(p_succession_plan_id => p_succession_plan_id,
p_object_version_number => p_object_version_number
);
hr_api.cannot_find_prog_unit_error (p_module_name => 'delete_succession_plan',
p_hook_type => 'AP'
);
ROLLBACK TO delete_succession_plan;
ROLLBACK TO delete_succession_plan;
END delete_succession_plan;