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: 53

  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: 72

            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: 105

    END insert_row;
Line: 107

  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: 147

       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: 203

    END insert_row;
Line: 328

  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: 347

            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: 380

    END update_row;
Line: 382

  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: 422

       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: 478

    END update_row;
Line: 481

  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: 498

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

    END delete_row;
Line: 532

  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: 571

       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: 626

    END delete_row;
Line: 789

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

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

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

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

       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: 891

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

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