eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_TRX_TYPES_PUB SQL Statements

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

Line: 4


  PROCEDURE insert_trx_types(
    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_tryv_rec                     IN  tryv_rec_type,
    x_tryv_rec                     OUT NOCOPY tryv_rec_type)

IS

l_api_version  NUMBER := 1.0;

Line: 19


     OKL_PROCESS_TRX_TYPES_PVT.insert_trx_types(p_api_version                  => l_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_tryv_rec                     => p_tryv_rec,
                                        x_tryv_rec                     => x_tryv_rec);

Line: 34


  PROCEDURE insert_trx_types(
    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_tryv_tbl                     IN  tryv_tbl_type,
    x_tryv_tbl                     OUT NOCOPY tryv_tbl_type)

IS

l_api_version  NUMBER := 1.0;

Line: 49


     OKL_PROCESS_TRX_TYPES_PVT.insert_trx_types(p_api_version                  => l_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_tryv_tbl                     => p_tryv_tbl,
                                        x_tryv_tbl                     => x_tryv_tbl);

Line: 63


  PROCEDURE update_trx_types(
    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_tryv_rec                     IN  tryv_rec_type,
    x_tryv_rec                     OUT NOCOPY tryv_rec_type)

IS

l_api_version  NUMBER := 1.0;

Line: 78


     OKL_PROCESS_TRX_TYPES_PVT.update_trx_types(p_api_version                  => l_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_tryv_rec                     => p_tryv_rec,
                                        x_tryv_rec                     => x_tryv_rec);

Line: 92


  PROCEDURE update_trx_types(
    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_tryv_tbl                     IN  tryv_tbl_type,
    x_tryv_tbl                     OUT NOCOPY tryv_tbl_type)

IS

l_api_version  NUMBER := 1.0;

Line: 108


     OKL_PROCESS_TRX_TYPES_PVT.update_trx_types(p_api_version                  => l_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_tryv_tbl                     => p_tryv_tbl,
                                        x_tryv_tbl                     => x_tryv_tbl);

Line: 121


  PROCEDURE delete_trx_types(
    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_tryv_rec                     IN  tryv_rec_type)

IS

l_api_version  NUMBER := 1.0;

Line: 135


     OKL_PROCESS_TRX_TYPES_PVT.delete_trx_types(p_api_version                  => l_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_tryv_rec                     => p_tryv_rec);

Line: 148


  PROCEDURE delete_trx_types(
    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_tryv_tbl                     IN  tryv_tbl_type)

IS

l_api_version  NUMBER := 1.0;

Line: 162


     OKL_PROCESS_TRX_TYPES_PVT.delete_trx_types(p_api_version                  => l_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_tryv_tbl                     => p_tryv_tbl);