APPS.PQH_RULE_SETS_API SQL Statements

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

Line: 194

procedure update_RULE_SET
  (p_validate                       in  boolean   default false
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_rule_set_id                    in  number
  ,p_rule_set_name                  in  varchar2  default hr_api.g_varchar2
  ,p_description		    in  varchar2  default hr_api.g_varchar2
  ,p_organization_structure_id      in  number    default hr_api.g_number
  ,p_organization_id                in  number    default hr_api.g_number
  ,p_referenced_rule_set_id         in  number    default hr_api.g_number
  ,p_rule_level_cd                  in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_short_name                     in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ,p_language_code                  in varchar2   default hr_api.userenv_lang
  ,p_rule_applicability		   in varchar2  default hr_api.g_varchar2
  ,p_rule_category		   in varchar2  default hr_api.g_varchar2
  ,p_starting_organization_id	   in number    default hr_api.g_number
  ,p_seeded_rule_flag		   in varchar2  default hr_api.g_varchar2
  ,p_status                        in varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_RULE_SET';

Line: 226

  savepoint update_RULE_SET;

Line: 240

    pqh_RULE_SETS_bk2.update_RULE_SET_b
      (
       p_business_group_id              =>  p_business_group_id
      ,p_rule_set_id                    =>  p_rule_set_id
      ,p_rule_set_name                  =>  p_rule_set_name
      ,p_description		        =>  p_description
      ,p_organization_structure_id      =>  p_organization_structure_id
      ,p_organization_id                =>  p_organization_id
      ,p_referenced_rule_set_id         =>  p_referenced_rule_set_id
      ,p_rule_level_cd                  =>  p_rule_level_cd
      ,p_object_version_number          =>  p_object_version_number
      ,p_short_name                     =>  p_short_name
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_rule_applicability    	        =>  p_rule_applicability
      ,p_rule_category		        =>  p_rule_category
      ,p_starting_organization_id       =>  p_starting_organization_id
      ,p_seeded_rule_flag	        =>  p_seeded_rule_flag
      ,p_status                         =>  p_status
      );

Line: 262

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

Line: 303

    pqh_RULE_SETS_bk2.update_RULE_SET_a
      (
       p_business_group_id              =>  p_business_group_id
      ,p_rule_set_id                    =>  p_rule_set_id
      ,p_rule_set_name                  =>  p_rule_set_name
      ,p_description		        =>  p_description
      ,p_organization_structure_id      =>  p_organization_structure_id
      ,p_organization_id                =>  p_organization_id
      ,p_referenced_rule_set_id         =>  p_referenced_rule_set_id
      ,p_rule_level_cd                  =>  p_rule_level_cd
      ,p_object_version_number          =>  l_object_version_number
      ,p_short_name                     =>  p_short_name
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_rule_applicability	        =>  p_rule_applicability
      ,p_rule_category		        =>  p_rule_category
      ,p_starting_organization_id       =>  p_starting_organization_id
      ,p_seeded_rule_flag	        =>  p_seeded_rule_flag
      ,p_status                         =>  p_status
      );

Line: 325

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

Line: 358

    ROLLBACK TO update_RULE_SET;

Line: 371

    ROLLBACK TO update_RULE_SET;

Line: 374

end update_RULE_SET;

Line: 379

procedure delete_RULE_SET
  (p_validate                       in  boolean  default false
  ,p_rule_set_id                    in  number
  ,p_object_version_number          in  number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_RULE_SET';

Line: 394

  select rule_attribute_id, object_version_number
  from pqh_rule_attributes where rule_set_id = p_rule_set_id;

Line: 403

  savepoint delete_RULE_SET;

Line: 416

    pqh_RULE_SETS_bk3.delete_RULE_SET_b
      (
       p_rule_set_id                    =>  p_rule_set_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 425

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

Line: 446

delete from pqh_rules where rule_set_id = p_rule_set_id;

Line: 464

    pqh_RULE_SETS_bk3.delete_RULE_SET_a
      (
       p_rule_set_id                    =>  p_rule_set_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 473

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

Line: 498

    ROLLBACK TO delete_RULE_SET;

Line: 509

    ROLLBACK TO delete_RULE_SET;

Line: 512

end delete_RULE_SET;