APPS.PQH_FR_STAT_SIT_RULES_API SQL Statements

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

Line: 192

procedure update_stat_situation_rule
  (p_validate                      in     boolean  default false
  ,p_effective_date               in     date      default sysdate
  ,p_stat_situation_rule_id       in     number
  ,p_object_version_number        in out nocopy number
  ,p_statutory_situation_id       in     number    default hr_api.g_number
  ,p_processing_sequence          in     number    default hr_api.g_number
  ,p_txn_category_attribute_id    in     number    default hr_api.g_number
  ,p_from_value                   in     varchar2  default hr_api.g_varchar2
  ,p_to_value                     in     varchar2  default hr_api.g_varchar2
  ,p_enabled_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_required_flag                in     varchar2  default hr_api.g_varchar2
  ,p_exclude_flag                 in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 211

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

Line: 226

  savepoint UPDATE_STAT_SITUATION_RULE;

Line: 244

       pqh_fr_stat_sit_rules_bk2.update_stat_situation_rule_b
      (    p_effective_date              =>      l_effective_date
	  ,p_statutory_situation_id      =>      p_statutory_situation_id
	  ,p_processing_sequence         =>      p_processing_sequence
	  ,p_txn_category_attribute_id   =>      p_txn_category_attribute_id
	  ,p_from_value                  =>      p_from_value
	  ,p_to_value                    =>      p_to_value
	  ,p_enabled_flag                =>      p_enabled_flag
	  ,p_required_flag               =>      p_required_flag
	  ,p_exclude_flag                =>      p_exclude_flag
	  ,p_stat_situation_rule_id      =>      p_stat_situation_rule_id
	  ,p_object_version_number       =>      p_object_version_number

      );

Line: 261

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

Line: 287

     pqh_fr_stat_sit_rules_bk2.update_stat_situation_rule_a
         (    p_effective_date           =>      l_effective_date
   	  ,p_statutory_situation_id      =>      p_statutory_situation_id
   	  ,p_processing_sequence         =>      p_processing_sequence
   	  ,p_txn_category_attribute_id   =>      p_txn_category_attribute_id
   	  ,p_from_value                  =>      p_from_value
   	  ,p_to_value                    =>      p_to_value
   	  ,p_enabled_flag                =>      p_enabled_flag
   	  ,p_required_flag               =>      p_required_flag
   	  ,p_exclude_flag                =>      p_exclude_flag
   	  ,p_stat_situation_rule_id      =>      p_stat_situation_rule_id
   	  ,p_object_version_number       =>      p_object_version_number

      );

Line: 304

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

Line: 332

    rollback to UPDATE_STAT_SITUATION_RULE;

Line: 350

    rollback to UPDATE_STAT_SITUATION_RULE;

Line: 359

end UPDATE_STAT_SITUATION_RULE;

Line: 366

  procedure delete_stat_situation_rule
  (p_validate                      in     boolean  default false
  ,p_stat_situation_rule_id               in     number
  ,p_object_version_number                in     number
  ) is

  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_statutory_situation';

Line: 388

  savepoint DELETE_STAT_SITUATION_RULE;

Line: 396

       pqh_fr_stat_sit_rules_bk3.delete_stat_situation_rule_b
      (  p_stat_situation_rule_id       =>   p_stat_situation_rule_id
	,p_object_version_number	=>   p_object_version_number
      );

Line: 404

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

Line: 425

       pqh_fr_stat_sit_rules_bk3.delete_stat_situation_rule_a
           (  p_stat_situation_rule_id       =>   p_stat_situation_rule_id
     	     ,p_object_version_number	     =>   p_object_version_number
     	    );

Line: 432

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

Line: 458

    rollback to DELETE_STAT_SITUATION_RULE;

Line: 476

    rollback to DELETE_STAT_SITUATION_RULE;

Line: 486

end DELETE_STAT_SITUATION_RULE;