DBA Data[Home] [Help]

APPS.OKS_REP_PUB SQL Statements

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

Line: 340

  PROCEDURE insert_row(
    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_repv_rec                     IN repv_rec_type,
    x_repv_rec                     OUT NOCOPY repv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 350

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 382

  oks_rep_pvt.insert_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_rec,
    x_repv_rec
    );
Line: 438

  END insert_row;
Line: 444

  PROCEDURE insert_row(
    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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

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

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 484

  oks_rep_pvt.insert_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_tbl,
    x_repv_tbl,
    gx_error_tbl
    );
Line: 541

  END insert_row;
Line: 547

  PROCEDURE insert_row(
    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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 557

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 585

  oks_rep_pvt.insert_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_tbl,
    x_repv_tbl
    );
Line: 641

  END insert_row;
Line: 941

  PROCEDURE update_row(
    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_repv_rec                     IN repv_rec_type,
    x_repv_rec                     OUT NOCOPY repv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 951

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 984

  oks_rep_pvt.update_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_rec,
    x_repv_rec
       );
Line: 1040

  END update_row;
Line: 1044

  PROCEDURE update_row(
    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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

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

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 1084

  oks_rep_pvt.update_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_tbl,
    x_repv_tbl,
    gx_error_tbl
       );
Line: 1141

  END update_row;
Line: 1148

  PROCEDURE update_row(
    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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1158

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 1186

  oks_rep_pvt.update_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_tbl,
    x_repv_tbl
       );
Line: 1242

  END update_row;
Line: 1248

  PROCEDURE delete_row(
    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_repv_rec                     IN repv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1257

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 1286

  oks_rep_pvt.delete_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_rec
       );
Line: 1341

  END delete_row;
Line: 1345

  PROCEDURE delete_row(
    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_repv_tbl                     IN repv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

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

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 1384

  oks_rep_pvt.delete_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_tbl,
    gx_error_tbl
       );
Line: 1440

  END delete_row;
Line: 1445

  PROCEDURE delete_row(
    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_repv_tbl                     IN repv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1454

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 1482

  oks_rep_pvt.delete_row(
    p_api_version ,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data ,
    g_repv_tbl
       );
Line: 1537

  END delete_row;