APPS.OKL_CONTRACT_STATUS_PVT SQL Statements

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

Line: 46

     select 'Y'
     from   dual
     where  exists (
            select 'X' from okl_trx_contracts ktx
            where ktx.KHR_ID = chrId
                 and UPPER(ktx.TSU_CODE) = 'WORKING'
                 --rkuttiya added for 12.1.1 Multi GAAP
                 and ktx.representation_type = 'PRIMARY'
                 --
                 and UPPER(ktx.TCN_TYPE) = 'YIELDS');

Line: 89

    SELECT chr.template_yn,
           khr.template_type_code
    FROM   okc_k_headers_b chr,
           okl_k_headers khr
    WHERE  chr.id = p_chr_id
    AND    chr.id = khr.id;

Line: 224

    select a.ste_code okc_status,
           a.code     okl_status,
           b.template_yn template_yn,
           --Bug# 4502754
           c.template_type_code
    from   okc_statuses_v a,
           okc_k_headers_b b,
           okl_k_headers c
    where  a.code = b.sts_code
           and b.id = c.id
           and b.id = chrId;

Line: 237

    SELECT chr.SCS_CODE class,
           chr.STS_CODE okc_status
    FROM OKC_K_HEADERS_B chr,
         OKL_K_HEADERS khr
    WHERE chr.id = p_chr_id
          AND chr.id = khr.id;

Line: 245

    SELECT pdt.id           product_id
          ,pdt.name         product_name
          ,chr.sts_code     okl_status
    FROM   okl_products_v   pdt
          ,okl_k_headers  khr
          ,okc_k_headers_b  chr
    WHERE  1=1
    AND    khr.id = p_contract_id
    AND    khr.pdt_id = pdt.id
    AND    khr.id = chr.id;

Line: 365

  Procedure update_contract_status(
            p_api_version     IN  NUMBER,
            p_init_msg_list   IN  VARCHAR2,
            x_return_status   OUT NOCOPY VARCHAR2,
            x_msg_count       OUT NOCOPY NUMBER,
            x_msg_data        OUT NOCOPY VARCHAR2,
            p_khr_status      IN  VARCHAR2,
            p_chr_id          IN  VARCHAR2)  IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_STATUS';

Line: 409

    okl_contract_pub.update_contract_header(
                        p_api_version,
                        p_init_msg_list,
                        x_return_status,
                        x_msg_count,
                        x_msg_data,
                        OKL_API.G_FALSE,
                        p_chrv_rec,
                        p_khrv_rec,
                        x_chrv_rec,
                        x_khrv_rec);

Line: 421

      okl_okc_migration_pvt.update_contract_header(
                        p_api_version,
                        p_init_msg_list,
                        x_return_status,
                        x_msg_count,
                        x_msg_data,
                        OKL_API.G_FALSE,
                        p_chrv_rec,
                        x_chrv_rec);

Line: 468

  END update_contract_status;

Line: 489

SELECT STS_CODE,
       START_DATE,
       END_DATE,
       CURRENCY_CODE,
       SCS_CODE
FROM   OKC_K_HEADERS_B
WHERE  ID = p_chr_id;

Line: 505

SELECT STS_CODE,
       ID,
       START_DATE,
       END_DATE
FROM   OKC_K_LINES_B
WHERE  DNZ_CHR_ID = p_chr_id;

Line: 519

SELECT ste_code
FROM   OKC_STATUSES_B
WHERE  CODE = p_okl_sts
AND    nvl(START_DATE,sysdate) <= sysdate
AND    nvl(END_DATE, sysdate+1) > sysdate;

Line: 570

     OKL_OKC_MIGRATION_PVT. update_contract_line(
            p_api_version   => p_api_version,
            p_init_msg_list => p_init_msg_list,
            x_return_status => x_return_status,
            x_msg_count     => x_msg_count,
            x_msg_data      => x_msg_data,
            p_clev_rec      => l_clev_rec,
            x_clev_rec      => x_clev_rec);

Line: 757

    l_last_update_date  okc_k_lines_b.last_update_date%type;

Line: 758

    l_last_updated_by   okc_k_lines_b.last_updated_by%type;

Line: 759

    l_last_update_login okc_k_lines_b.last_update_login%type;

Line: 779

  select application_id into l_application_id
  from   fnd_application_vl
  where  application_short_name = 'OKL';

Line: 783

  l_last_update_date := sysdate;

Line: 784

  l_last_updated_by := fnd_global.user_id;

Line: 785

  l_last_update_login := fnd_global.login_id;

Line: 788

    update okc_k_lines_b
    set    sts_code = p_clev_sts_tbl(i),
           start_date = p_clev_start_date_tbl(i),
           end_date = p_clev_end_date_tbl(i),
           currency_code = p_clev_curr_code_tbl(i),
           program_application_id = l_application_id,
           program_update_date = sysdate,
           last_update_date = l_last_update_date,
           last_updated_by = l_last_updated_by,
           last_update_login = l_last_update_login
    where  ID = p_clev_id_tbl(i);

Line: 830

SELECT STS_CODE,
       START_DATE,
       END_DATE,
       CURRENCY_CODE,
       SCS_CODE
FROM   OKC_K_HEADERS_B
WHERE  ID = p_chr_id;

Line: 846

SELECT A.STS_CODE,
       A.ID,
       A.START_DATE,
       A.END_DATE
FROM   OKC_K_LINES_B A,
       OKC_STATUSES_B B
WHERE  A.DNZ_CHR_ID = p_chr_id
AND    A.STS_CODE = B.CODE
AND    B.STE_CODE not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line: 857

SELECT A.STS_CODE,
       A.ID,
       A.START_DATE,
       A.END_DATE
FROM   OKC_K_LINES_B A
WHERE  A.DNZ_CHR_ID = p_chr_id
AND    NOT EXISTS (select 'x' from OKC_STATUSES_B B where B.CODE = A.STS_CODE);

Line: 881

SELECT ste_code
FROM   OKC_STATUSES_B
WHERE  CODE = p_okl_sts
AND    nvl(START_DATE,sysdate) <= sysdate
AND    nvl(END_DATE, sysdate+1) > sysdate;

Line: 933

                l_kle_sts.DELETE;

Line: 934

                l_kle_id.DELETE;

Line: 935

                l_kle_start_date.DELETE;

Line: 936

                l_kle_end_date.DELETE;

Line: 1047

SELECT STS_CODE,
       START_DATE,
       END_DATE,
       CURRENCY_CODE,
       SCS_CODE,
       CONTRACT_NUMBER,
       TEMPLATE_YN --Bug#4728470
FROM   OKC_K_HEADERS_B
WHERE  ID = p_chr_id;

Line: 1069

SELECT ste_code
FROM   OKC_STATUSES_B
WHERE  CODE = p_okl_sts
AND    nvl(START_DATE,sysdate) <= sysdate
AND    nvl(END_DATE, sysdate+1) > sysdate;

Line: 1146

                           OKL_OKC_MIGRATION_PVT.update_contract_header(
                            p_api_version   => p_api_version,
                            p_init_msg_list => p_init_msg_list,
                            x_return_status => x_return_status,
                            x_msg_count     => x_msg_count,
                            x_msg_data      => x_msg_data,
                            p_chrv_rec      => l_chrv_rec,
                            x_chrv_rec      => x_chrv_rec);

Line: 1178

                           OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
                                         p_api_version     => p_api_version,
                                         p_init_msg_list   => p_init_msg_list,
                                         x_return_status   => x_return_status,
                                         x_msg_count       => x_msg_count,
                                         x_msg_data        => x_msg_data,
                                         p_khr_id          => p_chr_id,
                                         p_prog_short_name => NULL,
                                         p_conc_req_id     => NULL,
                                         p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);

Line: 1204

                                OKL_OKC_MIGRATION_PVT.update_contract_header(
                                 p_api_version   => p_api_version,
                                 p_init_msg_list => p_init_msg_list,
                                 x_return_status => x_return_status,
                                 x_msg_count     => x_msg_count,
                                 x_msg_data      => x_msg_data,
                                 p_chrv_rec      => l_chrv_rec,
                                 x_chrv_rec      => x_chrv_rec);

Line: 1235

                                 OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
                                               p_api_version     => p_api_version,
                                               p_init_msg_list   => p_init_msg_list,
                                               x_return_status   => x_return_status,
                                               x_msg_count       => x_msg_count,
                                               x_msg_data        => x_msg_data,
                                               p_khr_id          => p_chr_id,
                                               p_prog_short_name => NULL,
                                               p_conc_req_id     => NULL,
                                               p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);