APPS.GHR_PDC_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 160

update_pdc(p_validate IN BOOLEAN default false,
	p_pd_classification_id  IN ghr_pd_classifications.pd_classification_id%TYPE,
	p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
	p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
        p_official_title  IN ghr_pd_classifications.official_title%TYPE,
	p_pay_plan   IN  ghr_pd_classifications.pay_plan%TYPE,
	p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
	p_grade_level	IN   ghr_pd_classifications.grade_level%TYPE,
	p_pdc_object_version_number IN out number)

IS

l_proc	varchar2(72) := g_package||'Update_pdc';

Line: 186

   SAVEPOINT update_pdc;

Line: 191

	ghr_pdc_bk2.update_pdc_b (
             p_pd_classification_id      =>  p_pd_classification_id,
             p_position_description_id   =>  p_position_description_id,
             p_class_grade_by            =>  p_class_grade_by,
             p_official_title            =>  p_official_title,
             p_pay_plan                  =>  p_pay_plan,
             p_occupational_code         =>  p_occupational_code,
             p_grade_level               =>  p_grade_level,
             p_pdc_object_version_number =>  p_pdc_object_version_number
	);

Line: 204

				(p_module_name	=> 'update_pdc',
				 p_hook_type	=> 'BP'
				);

Line: 248

	ghr_pdc_bk2.update_pdc_a	(
             p_pd_classification_id      =>  p_pd_classification_id,
             p_position_description_id   =>  p_position_description_id,
             p_class_grade_by            =>  p_class_grade_by,
             p_official_title            =>  p_official_title,
             p_pay_plan                  =>  p_pay_plan,
             p_occupational_code         =>  p_occupational_code,
             p_grade_level               =>  p_grade_level,
             p_pdc_object_version_number =>  l_object_version_number
	);

Line: 261

				(p_module_name	=> 'update_pdc',
				 p_hook_type	=> 'AP'
				);

Line: 291

	ROLLBACK to update_pdc;

Line: 294

           rollback to update_pdc;

Line: 299

end update_pdc;

Line: 301

PROCEDURE delete_pdc
(       p_validate IN BOOLEAN default false,
	p_pd_classification_id  IN ghr_pd_classifications.pd_classification_id%TYPE,
	p_pdc_object_version_number in  number)
IS

l_proc	varchar2(72) := g_package||'Delete_pdc';

Line: 316

   SAVEPOINT delete_pdc;

Line: 321

	ghr_pdc_bk3.delete_pdc_b	(
             p_pd_classification_id      =>  p_pd_classification_id,
             p_pdc_object_version_number =>  l_object_version_number
	);

Line: 328

				(p_module_name	=> 'delete_pdc',
				 p_hook_type	=> 'BP'
				);

Line: 365

	ghr_pdc_bk3.delete_pdc_a	(
             p_pd_classification_id      =>  p_pd_classification_id,
             p_pdc_object_version_number =>  l_object_version_number
	);

Line: 372

				(p_module_name	=> 'delete_pdc',
				 p_hook_type	=> 'AP'
				);

Line: 397

	ROLLBACK to delete_pdc;

Line: 400

           rollback to delete_pdc;

Line: 405

end delete_pdc;