APPS.HXC_RESOURCE_RULES_API SQL Statements

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

Line: 204

procedure update_resource_rules
  (p_validate                      in     boolean  default false
  ,p_resource_rule_id              in     number
  ,p_object_version_number         in out nocopy number
  ,p_name                          in     varchar2
  ,p_business_group_id             in     number   default null
  ,p_legislation_code              in     varchar2 default null
  ,p_eligibility_criteria_type     in     varchar2
  ,p_eligibility_criteria_id       in     varchar2    default null
  ,p_pref_hierarchy_id             in     number
  ,p_rule_evaluation_order         in     number
  ,p_resource_type                 in     varchar2
  ,p_start_date                    in     date      default null
  ,p_end_date                      in     date      default null
  ,p_effective_date                in     date      default null
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 230

	l_proc := g_package||' update_resource_rules';

Line: 236

  savepoint update_resource_rules;

Line: 245

   hxc_resource_rules_bk_1.update_resource_rules_b
    (p_resource_rule_id          => p_resource_rule_id
    ,p_object_version_number     => p_object_version_number
    ,p_name                      => p_name
    ,p_business_group_id        => p_business_group_id
    ,p_legislation_code         => p_legislation_code
    ,p_eligibility_criteria_type => p_eligibility_criteria_type
    ,p_eligibility_criteria_id   => p_eligibility_criteria_id
    ,p_pref_hierarchy_id         => p_pref_hierarchy_id
    ,p_rule_evaluation_order     => p_rule_evaluation_order
    ,p_resource_type             => p_resource_type
    ,p_start_date                => p_start_date
    ,p_end_date                  => p_end_date
    ,p_effective_date            => p_effective_date
    );

Line: 263

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

Line: 307

   hxc_resource_rules_bk_1.update_resource_rules_a
    (p_resource_rule_id          => p_resource_rule_id
    ,p_object_version_number     => p_object_version_number
    ,p_name                      => p_name
    ,p_business_group_id        => p_business_group_id
    ,p_legislation_code         => p_legislation_code
    ,p_eligibility_criteria_type => p_eligibility_criteria_type
    ,p_eligibility_criteria_id   => p_eligibility_criteria_id
    ,p_pref_hierarchy_id         => p_pref_hierarchy_id
    ,p_rule_evaluation_order     => p_rule_evaluation_order
    ,p_resource_type             => p_resource_type
    ,p_start_date                => p_start_date
    ,p_end_date                  => p_end_date
    ,p_effective_date            => p_effective_date
    );

Line: 325

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

Line: 365

    ROLLBACK TO update_resource_rules;

Line: 384

    ROLLBACK TO update_resource_rules;

Line: 390

END update_resource_rules;

Line: 396

procedure delete_resource_rules
  (p_validate                       in  boolean  default false
  ,p_resource_rule_id               in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 411

	l_proc := g_package||'delete_resource_rules';

Line: 417

  savepoint delete_resource_rules;

Line: 427

         hxc_resource_rules_bk_1.delete_resource_rules_b
          (p_resource_rule_id      => p_resource_rule_id
          ,p_object_version_number => p_object_version_number
          );

Line: 434

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

Line: 459

         hxc_resource_rules_bk_1.delete_resource_rules_a
          (p_resource_rule_id       => p_resource_rule_id
          ,p_object_version_number  => p_object_version_number
          );

Line: 466

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

Line: 488

    ROLLBACK TO delete_resource_rules;

Line: 494

    ROLLBACK TO delete_resource_rules;

Line: 497

end delete_resource_rules;