APPS.OKL_PAYMENT_APPLICATION_PUB SQL Statements

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

Line: 128

  PROCEDURE delete_payment(
                          p_api_version   IN  NUMBER,
                          p_init_msg_list IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                          x_return_status OUT NOCOPY VARCHAR2,
                          x_msg_count     OUT NOCOPY NUMBER,
                          x_msg_data      OUT NOCOPY VARCHAR2,
                          p_chr_id        IN  OKC_K_HEADERS_V.ID%TYPE,
                          p_rgp_id        IN  OKC_RULE_GROUPS_V.ID%TYPE,
                          p_rule_id       IN  OKC_RULES_V.ID%TYPE
                         ) IS
  l_api_name    CONSTANT VARCHAR2(30) := 'DELETE_PAYMENT';

Line: 167

      okl_payment_application_pvt.delete_payment(
                                                p_api_version => 1.0,
                                                p_init_msg_list => OKC_API.G_FALSE,
                                                x_return_status => x_return_status,
                                                x_msg_count     => x_msg_count,
                                                x_msg_data      => x_msg_data,
                                                p_chr_id        => p_chr_id,
                                                p_rgp_id        => p_rgp_id,
                                                p_rule_id       => p_rule_id
                                               );

Line: 225

  END delete_payment;