APPS.PAY_CNU_API SQL Statements

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

Line: 47

    select cnu.contribution_usage_id, cnu.object_version_number
      from   pay_fr_contribution_usages cnu
     where  cnu.group_code   = p_group_code
       and  cnu.process_type = p_process_type
       and  cnu.element_name = p_element_name
       and  cnu.contribution_usage_type = p_contribution_usage_type
       and  cnu.date_to is null
       and  cnu.date_from < p_date_from
       and (  nvl(p_business_group_id, -1)
            = nvl(cnu.business_group_id, -1)
           );

Line: 84

    pay_cnu_api.update_contribution_usage
    (p_validate                     => FALSE
    ,p_effective_date               => l_effective_date
    ,p_contribution_usage_id        => l_adj_cu_id
    ,p_date_to                      => l_date_from-1
    ,p_contribution_code            => p_contribution_code
    ,p_contribution_type            => p_contribution_type
    ,p_object_version_number        => l_adj_ovn
    ,p_code_rate_id                 => l_code_rate_id
    );

Line: 226

procedure update_contribution_usage
  (p_validate                     IN      boolean  default false
  ,p_effective_date               IN      date
  ,p_contribution_usage_id        IN      number
  ,p_date_to                      IN      date     default hr_api.g_date
  ,p_contribution_code            IN      varchar2
  ,p_contribution_type            IN      varchar2
  ,p_retro_contribution_code      IN      varchar2 default hr_api.g_varchar2
  ,p_object_version_number        IN OUT  nocopy number
  ,p_code_rate_id                 IN      varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Contribution Usage';

Line: 249

  savepoint UPDATE_CONTRIBUTION_USAGE;

Line: 260

    pay_cnu_api_bk2.update_contribution_usage_b
  (p_effective_date                 => l_effective_date
  ,p_contribution_usage_id          => p_contribution_usage_id
  ,p_object_version_number          => l_object_version_number
  ,p_date_to                        => l_date_to
  ,p_contribution_code              => p_contribution_code
  ,p_contribution_type              => p_contribution_type
  ,p_retro_contribution_code        => p_retro_contribution_code
  ,p_code_rate_id                   => p_code_rate_id
  );

Line: 273

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

Line: 297

  pay_cnu_api_bk2.update_contribution_usage_a
  (p_effective_date                 => l_effective_date
  ,p_contribution_usage_id          => p_contribution_usage_id
  ,p_object_version_number          => l_object_version_number
  ,p_date_to                        => l_date_to
  ,p_contribution_code              => p_contribution_code
  ,p_contribution_type              => p_contribution_type
  ,p_retro_contribution_code        => p_retro_contribution_code
  ,p_code_rate_id                   => p_code_rate_id
  );

Line: 310

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

Line: 331

    rollback to UPDATE_CONTRIBUTION_USAGE;

Line: 343

    rollback to UPDATE_CONTRIBUTION_USAGE;

Line: 351

end update_contribution_usage;

Line: 357

procedure delete_contribution_usage
  (p_validate                      in     boolean  default false
  ,p_contribution_usage_id         in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Contribution Usage';

Line: 372

  savepoint DELETE_CONTRIBUTION_USAGE;

Line: 380

    pay_cnu_api_bk3.delete_contribution_usage_b
  (p_contribution_usage_id       => p_contribution_usage_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 387

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

Line: 405

  pay_cnu_api_bk3.delete_contribution_usage_a
  (p_contribution_usage_id       => p_contribution_usage_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 412

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

Line: 433

    rollback to DELETE_CONTRIBUTION_USAGE;

Line: 444

    rollback to DELETE_CONTRIBUTION_USAGE;

Line: 447

end delete_contribution_usage;