APPS.PQH_PSB_INTERFACE_API SQL Statements

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

Line: 55

procedure update_budget_version
  (
   p_validate                       in  boolean   default false
  ,p_budget_version_id              in  number
  ,p_budget_id                      in  number    default hr_api.g_number
  ,p_version_number                 in  number    default hr_api.g_number
  ,p_date_from                      in  date      default hr_api.g_date
  ,p_date_to                        in  date      default hr_api.g_date
  ,p_transfered_to_gl_flag          in  varchar2  default hr_api.g_varchar2
  ,p_gl_status                      in  varchar2  default hr_api.g_varchar2
  ,p_xfer_to_other_apps_cd          in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in  out nocopy number
  ,p_budget_unit1_value             in  number    default hr_api.g_number
  ,p_budget_unit2_value             in  number    default hr_api.g_number
  ,p_budget_unit3_value             in  number    default hr_api.g_number
  ,p_budget_unit1_available         in  number    default hr_api.g_number
  ,p_budget_unit2_available         in  number    default hr_api.g_number
  ,p_budget_unit3_available         in  number    default hr_api.g_number
  ,p_effective_date                 in  date
  ) is
  l_object_version_number number := p_object_version_number;

Line: 77

    pqh_budget_versions_api.update_budget_version
      (p_validate                 => p_validate,
       p_budget_version_id        => p_budget_version_id,
       p_budget_id                => p_budget_id,
       p_version_number           => p_version_number,
       p_date_from                => p_date_from,
       p_date_to                  => p_date_to,
       p_transfered_to_gl_flag    => p_transfered_to_gl_flag,
       p_gl_status	          => p_gl_status,
       p_xfer_to_other_apps_cd    => p_xfer_to_other_apps_cd,
       p_object_version_number    => p_object_version_number,
       p_budget_unit1_value       => p_budget_unit1_value,
       p_budget_unit2_value       => p_budget_unit2_value,
       p_budget_unit3_value       => p_budget_unit3_value,
       p_budget_unit1_available   => p_budget_unit1_available,
       p_budget_unit2_available   => p_budget_unit2_available,
       p_budget_unit3_available   => p_budget_unit3_available,
       p_effective_date           => p_effective_date
      );

Line: 99

end update_budget_version;

Line: 129

procedure update_budget_element
  (
   p_validate                       in  boolean   default false
  ,p_budget_element_id              in  number
  ,p_budget_set_id                  in  number    default hr_api.g_number
  ,p_element_type_id                in  number    default hr_api.g_number
  ,p_distribution_percentage        in  number    default hr_api.g_number
  ,p_object_version_number          in  out nocopy number
  ) is
  l_object_version_number number := p_object_version_number;

Line: 140

    pqh_budget_elements_api.update_budget_element
      (p_validate 		 => p_validate,
       p_budget_element_id 	 => p_budget_element_id,
       p_budget_set_id 		 => p_budget_set_id,
       p_element_type_id 	 => p_element_type_id,
       p_distribution_percentage => p_distribution_percentage,
       p_object_version_number   => p_object_version_number
      );

Line: 151

end update_budget_element;

Line: 191

procedure update_budget_fund_src
  (
   p_validate                       in  boolean   default false
  ,p_budget_fund_src_id             in  number
  ,p_budget_element_id              in  number    default hr_api.g_number
  ,p_cost_allocation_keyflex_id     in  number    default hr_api.g_number
  ,p_project_id                     in  number    default hr_api.g_number
  ,p_award_id                       in  number    default hr_api.g_number
  ,p_task_id                        in  number    default hr_api.g_number
  ,p_expenditure_type               in  varchar2  default hr_api.g_varchar2
  ,p_organization_id                in  number    default hr_api.g_number
  ,p_distribution_percentage        in  number    default hr_api.g_number
  ,p_object_version_number          in  out nocopy number
  ) is
  l_object_version_number number := p_object_version_number;

Line: 207

    pqh_budget_fund_srcs_api.update_budget_fund_src
      (p_validate                       =>  p_validate,
       p_budget_fund_src_id             =>  p_budget_fund_src_id ,
       p_budget_element_id              =>  p_budget_element_id,
       p_cost_allocation_keyflex_id     =>  p_cost_allocation_keyflex_id,
       p_project_id      	        =>  p_project_id,
       p_award_id        	        =>  p_award_id,
       p_task_id         	        =>  p_task_id,
       p_expenditure_type	        =>  p_expenditure_type,
       p_organization_id	        =>  p_organization_id,
       p_distribution_percentage        =>  p_distribution_percentage,
       p_object_version_number          =>  p_object_version_number
      );

Line: 223

end update_budget_fund_src;

Line: 277

procedure update_budget_period
  (
   p_validate                       in  boolean   default false
  ,p_budget_period_id               in  number
  ,p_budget_detail_id               in  number    default hr_api.g_number
  ,p_start_time_period_id           in  number    default hr_api.g_number
  ,p_end_time_period_id             in  number    default hr_api.g_number
  ,p_budget_unit1_percent           in  number    default hr_api.g_number
  ,p_budget_unit2_percent           in  number    default hr_api.g_number
  ,p_budget_unit3_percent           in  number    default hr_api.g_number
  ,p_budget_unit1_value             in  number    default hr_api.g_number
  ,p_budget_unit2_value             in  number    default hr_api.g_number
  ,p_budget_unit3_value             in  number    default hr_api.g_number
  ,p_budget_unit1_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit2_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit3_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit1_available         in  number    default hr_api.g_number
  ,p_budget_unit2_available         in  number    default hr_api.g_number
  ,p_budget_unit3_available         in  number    default hr_api.g_number
  ,p_object_version_number          in  out nocopy number
  ) is
  l_object_version_number number := p_object_version_number;

Line: 300

    pqh_budget_periods_api.update_budget_period
      (p_validate 			=> p_validate,
       p_budget_period_id 		=> p_budget_period_id,
       p_budget_detail_id 		=> p_budget_detail_id,
       p_start_time_period_id 		=> p_start_time_period_id,
       p_end_time_period_id 		=> p_end_time_period_id,
       p_budget_unit1_percent           => p_budget_unit1_percent,
       p_budget_unit2_percent           => p_budget_unit2_percent,
       p_budget_unit3_percent       	=> p_budget_unit3_percent,
       p_budget_unit1_value 		=> p_budget_unit1_value,
       p_budget_unit2_value 		=> p_budget_unit2_value,
       p_budget_unit3_value 		=> p_budget_unit3_value,
       p_budget_unit1_value_type_cd 	=> p_budget_unit1_value_type_cd,
       p_budget_unit2_value_type_cd 	=> p_budget_unit2_value_type_cd,
       p_budget_unit3_value_type_cd 	=> p_budget_unit3_value_type_cd,
       p_budget_unit1_available         => p_budget_unit1_available,
       p_budget_unit2_available         => p_budget_unit2_available,
       p_budget_unit3_available         => p_budget_unit3_available,
       p_object_version_number 		=> p_object_version_number
      );

Line: 323

end update_budget_period;

Line: 377

procedure update_budget_set
  (
   p_validate                       in  boolean   default false
  ,p_budget_set_id                  in  number
  ,p_dflt_budget_set_id             in  number    default hr_api.g_number
  ,p_budget_period_id               in  number    default hr_api.g_number
  ,p_budget_unit1_percent           in  number    default hr_api.g_number
  ,p_budget_unit2_percent           in  number    default hr_api.g_number
  ,p_budget_unit3_percent           in  number    default hr_api.g_number
  ,p_budget_unit1_value             in  number    default hr_api.g_number
  ,p_budget_unit2_value             in  number    default hr_api.g_number
  ,p_budget_unit3_value             in  number    default hr_api.g_number
  ,p_budget_unit1_available         in  number    default hr_api.g_number
  ,p_budget_unit2_available         in  number    default hr_api.g_number
  ,p_budget_unit3_available         in  number    default hr_api.g_number
  ,p_object_version_number          in  out nocopy number
  ,p_budget_unit1_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit2_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit3_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ) is
  l_object_version_number number := p_object_version_number;

Line: 400

    pqh_budget_sets_api.update_budget_set
      (p_validate 			=> p_validate,
       p_budget_set_id 			=> p_budget_set_id,
       p_dflt_budget_set_id 		=> p_dflt_budget_set_id,
       p_budget_period_id 		=> p_budget_period_id,
       p_budget_unit1_percent           => p_budget_unit1_percent,
       p_budget_unit2_percent           => p_budget_unit2_percent,
       p_budget_unit3_percent       	=> p_budget_unit3_percent,
       p_budget_unit1_value 		=> p_budget_unit1_value,
       p_budget_unit2_value 		=> p_budget_unit2_value,
       p_budget_unit3_value 		=> p_budget_unit3_value,
       p_budget_unit1_available         => p_budget_unit1_available,
       p_budget_unit2_available         => p_budget_unit2_available,
       p_budget_unit3_available         => p_budget_unit3_available,
       p_budget_unit1_value_type_cd 	=> p_budget_unit1_value_type_cd,
       p_budget_unit2_value_type_cd 	=> p_budget_unit2_value_type_cd,
       p_budget_unit3_value_type_cd 	=> p_budget_unit3_value_type_cd,
       p_object_version_number 		=> p_object_version_number,
       p_effective_date 		=> p_effective_date
      );

Line: 423

end update_budget_set;

Line: 483

procedure update_budget_detail
  (
   p_validate                       in  boolean   default false
  ,p_budget_detail_id               in  number
  ,p_organization_id                in  number    default hr_api.g_number
  ,p_job_id                         in  number    default hr_api.g_number
  ,p_position_id                    in  number    default hr_api.g_number
  ,p_grade_id                       in  number    default hr_api.g_number
  ,p_budget_version_id              in  number    default hr_api.g_number
  ,p_budget_unit1_percent           in  number    default hr_api.g_number
  ,p_budget_unit1_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit1_value             in  number    default hr_api.g_number
  ,p_budget_unit1_available         in  number    default hr_api.g_number
  ,p_budget_unit2_percent           in  number    default hr_api.g_number
  ,p_budget_unit2_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit2_value             in  number    default hr_api.g_number
  ,p_budget_unit2_available         in  number    default hr_api.g_number
  ,p_budget_unit3_percent           in  number    default hr_api.g_number
  ,p_budget_unit3_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit3_value             in  number    default hr_api.g_number
  ,p_budget_unit3_available         in  number    default hr_api.g_number
  ,p_gl_status                      in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in  out nocopy number
  ) is
  l_object_version_number number := p_object_version_number;

Line: 509

    pqh_budget_details_api.update_budget_detail
      (p_validate 			=> p_validate,
       p_budget_detail_id 		=> p_budget_detail_id,
       p_organization_id 		=> p_organization_id,
       p_job_id 			=> p_job_id,
       p_position_id 			=> p_position_id,
       p_grade_id			=> p_grade_id,
       p_budget_version_id 		=> p_budget_version_id,
       p_budget_unit1_percent		=> p_budget_unit1_percent,
       p_budget_unit1_value_type_cd 	=> p_budget_unit1_value_type_cd,
       p_budget_unit1_value 		=> p_budget_unit1_value,
       p_budget_unit1_available		=> p_budget_unit1_available,
       p_budget_unit2_percent		=> p_budget_unit2_percent,
       p_budget_unit2_value_type_cd 	=> p_budget_unit2_value_type_cd,
       p_budget_unit2_value 		=> p_budget_unit2_value,
       p_budget_unit2_available		=> p_budget_unit2_available,
       p_budget_unit3_percent		=> p_budget_unit3_percent,
       p_budget_unit3_value_type_cd 	=> p_budget_unit3_value_type_cd,
       p_budget_unit3_value 		=> p_budget_unit3_value,
       p_budget_unit3_available		=> p_budget_unit3_available,
       p_gl_status			=> p_gl_status,
       p_object_version_number 		=> p_object_version_number
      );

Line: 535

end update_budget_detail;