APPS.GHR_DUTY_STATION_API SQL Statements

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

Line: 190

procedure update_duty_station
  (p_validate                      in     boolean  default false
  ,p_duty_station_id 	           in  number
  ,p_effective_start_date          out  nocopy date
  ,p_effective_end_date            out  nocopy date
  ,p_locality_pay_area_id          in  number
  ,p_leo_pay_area_code             in  varchar2 default hr_api.g_varchar2
  ,p_name                          in  varchar2 default hr_api.g_varchar2
  ,p_duty_station_code             in  varchar2
  ,p_msa_code                      in varchar2
  ,p_cmsa_code                     in varchar2
  ,p_state_or_country_code         in varchar2
  ,p_county_code                   in varchar2
  ,p_is_duty_station               in  varchar2 default hr_api.g_varchar2
  ,p_effective_date                in  date
  ,p_datetrack_update_mode	   in  varchar2
  ,p_object_version_number        IN out nocopy number
   )



is
  l_proc                varchar2(72) := g_package || 'update_duty_stations';

Line: 221

    savepoint update_duty_stations;

Line: 226

   ghr_duty_station_bk2.update_duty_station_b
                                (  p_duty_station_id	    =>  p_duty_station_id
				  ,p_effective_start_date   =>  p_effective_start_date
				  ,p_effective_end_date     =>  p_effective_end_date
				  ,p_locality_pay_area_id   =>  p_locality_pay_area_id
				  ,p_leo_pay_area_code      =>  p_leo_pay_area_code
				  ,p_name                   =>  p_name
				  ,p_duty_station_code      =>  p_duty_station_code
				  ,p_is_duty_station        =>  p_is_duty_station
				  ,p_effective_date         =>  p_effective_date
				  ,p_datetrack_update_mode  =>  p_datetrack_update_mode
				  ,p_object_version_number  =>  p_object_version_number
				);

Line: 243

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

Line: 271

				  ,p_datetrack_update_mode  =>  p_datetrack_update_mode
				  );

Line: 280

    ghr_duty_station_bk2.update_duty_station_a(
				   p_duty_station_id	    =>  p_duty_station_id
				  ,p_effective_start_date   =>  l_effective_start_date
				  ,p_effective_end_date     =>  l_effective_end_date
				  ,p_locality_pay_area_id   =>  p_locality_pay_area_id
				  ,p_leo_pay_area_code      =>  p_leo_pay_area_code
				  ,p_name                   =>  p_name
  				  ,p_duty_station_code      =>  p_duty_station_code
				  ,p_is_duty_station        =>  p_is_duty_station
   			          ,p_effective_date         =>  p_effective_date
				  ,p_datetrack_update_mode  =>  p_datetrack_update_mode
				  ,p_object_version_number  =>  l_object_version_number
				  );

Line: 297

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

Line: 320

    ROLLBACK TO update_duty_stations;

Line: 328

      ROLLBACK TO update_duty_stations;

Line: 332

end update_duty_station;

Line: 340

procedure delete_duty_station
  (p_validate                      in     boolean  default false
  ,p_duty_station_id               in     number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number         in     number
  ,p_effective_date                 in date
  ,p_datetrack_mode                 in varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_duty_station';

Line: 362

    savepoint delete_duty_station;

Line: 374

  	ghr_duty_station_bk3.delete_duty_station_b	(
              p_duty_station_id            => p_duty_station_id
             ,p_object_version_number   => p_object_version_number
		);

Line: 386

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

Line: 432

	ghr_duty_station_bk3.delete_duty_station_a	(
              p_duty_station_id            => p_duty_station_id
             ,p_object_version_number      => p_object_version_number
		);

Line: 444

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

Line: 468

    ROLLBACK TO delete_duty_station;

Line: 474

    ROLLBACK TO delete_duty_station;

Line: 477

end delete_duty_station;