APPS.PQH_RULE_ATTRIBUTES_API SQL Statements

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

Line: 12

procedure Insert_Rule_Attribute
  (p_rule_set_id                    in     number
  ,p_attribute_code                 in     varchar2 default null
  ,p_operation_code                 in     varchar2 default null
  ,p_attribute_value                in     varchar2 default null
  ,p_rule_attribute_id                 out nocopy number
  ,p_object_version_number             out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 34

  savepoint Insert_Rule_Attribute;

Line: 40

   PQH_RULE_ATTRIBUTES_BK1.Insert_Rule_Attribute_b
   (p_rule_set_id                   => p_rule_set_id
  ,p_attribute_code                 => p_attribute_code
  ,p_operation_code                 => p_operation_code
  ,p_attribute_value                => p_attribute_value
  ,p_rule_attribute_id              => p_rule_attribute_id
  ,p_object_version_number          => p_object_version_number
   );

Line: 53

        (p_module_name => 'PQH_RULE_ATTRIBUTES_API.Insert_Rule_Attribute'
        ,p_hook_type   => 'BP'
        );

Line: 75

     PQH_RULE_ATTRIBUTES_BK1.Insert_Rule_Attribute_a
     (p_rule_set_id                   => p_rule_set_id
  ,p_attribute_code                 => p_attribute_code
  ,p_operation_code                 => p_operation_code
  ,p_attribute_value                => p_attribute_value
  ,p_rule_attribute_id              => p_rule_attribute_id
  ,p_object_version_number          => p_object_version_number);

Line: 86

        (p_module_name => 'PQH_RULE_ATTRIBUTES_API.Insert_Rule_Attribute'
        ,p_hook_type   => 'AP'
        );

Line: 114

    rollback to Insert_Rule_Attribute;

Line: 126

    rollback to Insert_Rule_Attribute;

Line: 129

end Insert_Rule_Attribute;

Line: 136

procedure Update_Rule_Attribute
  (p_rule_attribute_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_rule_set_id                  in     number    default hr_api.g_number
  ,p_attribute_code               in     varchar2  default hr_api.g_varchar2
  ,p_operation_code               in     varchar2  default hr_api.g_varchar2
  ,p_attribute_value              in     varchar2  default hr_api.g_varchar2
) Is

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

Line: 153

  savepoint Update_Rule_Attribute;

Line: 159

   PQH_RULE_ATTRIBUTES_BK2.Update_Rule_Attribute_b
  (p_rule_attribute_id            => p_rule_attribute_id
  ,p_object_version_number        => p_object_version_number
  ,p_rule_set_id                  => p_rule_set_id
  ,p_attribute_code               => p_attribute_code
  ,p_operation_code               => p_operation_code
  ,p_attribute_value              => p_attribute_value
  );

Line: 171

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

Line: 191

   PQH_RULE_ATTRIBUTES_BK2.Update_Rule_Attribute_a
  (p_rule_attribute_id            => p_rule_attribute_id
  ,p_object_version_number        => p_object_version_number
  ,p_rule_set_id                  => p_rule_set_id
  ,p_attribute_code               => p_attribute_code
  ,p_operation_code               => p_operation_code
  ,p_attribute_value              => p_attribute_value
);

Line: 203

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

Line: 227

    rollback to Update_Rule_Attribute;

Line: 239

    rollback to Update_Rule_Attribute;

Line: 242

end Update_Rule_Attribute;

Line: 248

procedure delete_Rule_Attribute
  (p_rule_attribute_id                    in     number
  ,p_object_version_number                in     number
  ) Is   --

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

Line: 262

  savepoint delete_Rule_Attribute;

Line: 267

  PQH_RULE_ATTRIBUTES_BK3.Delete_Rule_Attribute_b
  (p_rule_attribute_id                    => p_rule_attribute_id
  ,p_object_version_number                => p_object_version_number
  );

Line: 274

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

Line: 290

   PQH_RULE_ATTRIBUTES_BK3.Delete_Rule_Attribute_a
  (
p_rule_attribute_id                    => p_rule_attribute_id
  ,p_object_version_number                => p_object_version_number
  );

Line: 299

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

Line: 318

    rollback to delete_Rule_Attribute;

Line: 329

    rollback to delete_Rule_Attribute;

Line: 332

end delete_Rule_Attribute;