DBA Data[Home] [Help]

APPS.OKS_BILLING_PROFILES_PUB SQL Statements

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

Line: 14

    l_bpev_rec.last_updated_by			:= p_bpev_rec1.last_updated_by;
Line: 15

    l_bpev_rec.last_update_date			:= p_bpev_rec1.last_update_date;
Line: 16

    l_bpev_rec.last_update_login			:= p_bpev_rec1.last_update_login;
Line: 68

         SELECT contract.currency_code
         FROM okc_k_headers_b contract, okc_k_lines_b line
         WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
Line: 73

         SELECT contract.currency_code
         FROM okc_k_headers_b contract
         WHERE contract.id = p_chr_id;
Line: 355

  PROCEDURE insert_row(
    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_bpev_tbl                     IN bpev_tbl_type,
    x_bpev_tbl                     OUT NOCOPY bpev_tbl_type) IS

    l_return_status       VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 374

            insert_row(
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_bpev_tbl(i)
                       ,x_bpev_tbl(i));
Line: 407

    END insert_row;
Line: 409

  PROCEDURE insert_row(
    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_bpev_rec                     IN  bpev_rec_type,
    x_bpev_rec                     OUT NOCOPY bpev_rec_type) IS

    l_api_name            CONSTANT VARCHAR2(30) := 'insert_row';
Line: 449

       oks_billing_profiles_pvt.insert_row(p_api_version
                                        ,p_init_msg_list
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data
                                        ,l_bpev_rec
                                        ,x_bpev_rec);
Line: 505

    END insert_row;
Line: 630

  PROCEDURE update_row(
    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_bpev_tbl                     IN bpev_tbl_type,
    x_bpev_tbl                     OUT NOCOPY bpev_tbl_type) IS

    l_return_status       VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 649

            update_row(
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_bpev_tbl(i)
                       ,x_bpev_tbl(i));
Line: 682

    END update_row;
Line: 684

  PROCEDURE update_row(
    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_bpev_rec                     IN  bpev_rec_type,
    x_bpev_rec                     OUT NOCOPY bpev_rec_type) IS

    l_api_name            CONSTANT VARCHAR2(30) := 'update_row';
Line: 724

       oks_billing_profiles_pvt.update_row(p_api_version
                                        ,p_init_msg_list
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data
                                        ,l_bpev_rec
                                        ,x_bpev_rec);
Line: 780

    END update_row;
Line: 783

  PROCEDURE delete_row(
    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_bpev_tbl                     IN bpev_tbl_type) IS

    l_return_status       VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 800

            delete_row(
                        p_api_version
                       ,p_init_msg_list
                       ,l_return_status
                       ,x_msg_count
                       ,x_msg_data
                       ,p_bpev_tbl(i));
Line: 832

    END delete_row;
Line: 834

  PROCEDURE delete_row(
    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_bpev_rec                     IN  bpev_rec_type) IS

    l_api_name            CONSTANT VARCHAR2(30) := 'delete_row';
Line: 873

       oks_billing_profiles_pvt.delete_row(p_api_version
                                        ,p_init_msg_list
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data
                                        ,l_bpev_rec);
Line: 928

    END delete_row;
Line: 1091

         SELECT (f_target_qty - f_target_qty) INTO l_round_quantity FROM DUAL ;
Line: 1143

      l_p_tavv_tbl(1).last_updated_by   := NULL;
Line: 1144

      l_p_tavv_tbl(1).last_update_date  := TO_DATE(NULL);
Line: 1145

      l_p_tavv_tbl(1).last_update_login := NULL;
Line: 1178

       SELECT BILLING_LEVEL,
            BILLING_TYPE,
            INTERVAL,
            INTERFACE_OFFSET,
            INVOICE_OFFSET,
            INVOICE_OBJECT1_ID1,
--sum, jul,01
            ACCOUNT_OBJECT1_ID1
--sum, jul,01


       FROM   OKS_BILLING_PROFILES_V
       WHERE  ID = l_billing_profile_Id;
Line: 1193

       select uom_code
       from okc_time_code_units_v
       where tce_code='DAY'
       and quantity=1;
Line: 1200

       SELECT (nvl(line.price_negotiated,0) +  nvl(dtl.ubt_amount,0) +
                     nvl(dtl.credit_amount,0) +  nvl(dtl.suppressed_credit,0)) line_amt
       FROM okc_k_lines_b line, oks_k_lines_b dtl
       WHERE  line.id = dtl.cle_id AND line.Id = p_cle_id ;
Line: 1238

        select lse_id
        from okc_k_lines_b
        where id = p_cle_id
        and dnz_chr_id = p_chr_id;
Line: 1404

     l_sll_prorate_tbl.DELETE;