APPS.GHR_PDC_API SQL Statements

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

Line: 155

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 NOCOPY number)

IS
l_proc varchar2(72);

Line: 172

l_proc := g_package||'Update_pdc';

Line: 180

   SAVEPOINT update_pdc;

Line: 185

	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: 199

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

Line: 243

	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: 257

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

Line: 287

	ROLLBACK to update_pdc;

Line: 291

           rollback to update_pdc;

Line: 297

end update_pdc;

Line: 299

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) ;

Line: 311

l_proc := g_package||'Delete_pdc';

Line: 314

   SAVEPOINT delete_pdc;

Line: 319

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

Line: 326

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

Line: 363

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

Line: 370

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

Line: 394

	ROLLBACK to delete_pdc;

Line: 397

           rollback to delete_pdc;

Line: 402

end delete_pdc;