DBA Data[Home] [Help]

APPS.OKL_PROCESS_TRX_TYPES_PVT SQL Statements

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

Line: 13

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

IS

l_api_version   NUMBER := 1.0;
Line: 26

l_api_name      VARCHAR2(30) := 'INSERT_TRX_TYPES';
Line: 58

    OKL_TRX_TYPES_PUB.insert_trx_types(p_api_version                  => l_api_version,
                                        p_init_msg_list                => p_init_msg_list,
                                        x_return_status                => l_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: 99

END insert_trx_types;
Line: 102

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

IS

l_api_version  	NUMBER := 1.0;
Line: 114

l_api_name      VARCHAR2(30) := 'INSERT_TRX_TYPES';
Line: 155

 OKL_TRX_TYPES_PUB.insert_trx_types(p_api_version                  => l_api_version,
                                        p_init_msg_list                => p_init_msg_list,
                                        x_return_status                => l_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: 197

END insert_trx_types;
Line: 205

FUNCTION Check_Update_Allowed (p_tryv_rec  IN  tryv_rec_type )
RETURN VARCHAR2
IS

    CURSOR try_lub_cur (l_id NUMBER) IS
    SELECT last_updated_by
    FROM   okl_trx_types_v
    WHERE id =  l_id;
Line: 215

    l_last_updated_by	okl_trx_types_v.last_updated_by%TYPE;
Line: 216

	l_update_allowed VARCHAR2(1) := 'Y';
Line: 221

      l_last_updated_by := try_lub_rec.last_updated_by;
Line: 224

    IF l_last_updated_by = 1 THEN
	l_update_allowed := 'N';
Line: 228

    RETURN l_update_allowed;
Line: 230

END Check_Update_Allowed;
Line: 233

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

IS

l_api_version  	 NUMBER := 1.0;
Line: 246

l_update_allowed VARCHAR2(1) := 'Y';
Line: 247

l_api_name       VARCHAR2(30) := 'UPDATE_TRX_TYPES';
Line: 282

    l_update_allowed :=  Check_Update_Allowed(p_tryv_rec);
Line: 284

    IF l_update_allowed = 'N' THEN
         OKC_API.SET_MESSAGE(p_app_name => 'OKL',
                             p_msg_name => 'OKL_NO_UPD_TRX_TYPE' );
Line: 291

     OKL_TRX_TYPES_PUB.update_trx_types(p_api_version                  => l_api_version,
                                        p_init_msg_list                => p_init_msg_list,
                                        x_return_status                => l_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: 333

END update_trx_types;
Line: 337

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

IS

l_api_version  		NUMBER := 1.0;
Line: 349

l_update_allowed	VARCHAR2(1) := 'Y';
Line: 351

l_api_name      	VARCHAR2(30) := 'UPDATE_TRX_TYPES';
Line: 388

	    l_update_allowed :=  Check_Update_Allowed(p_tryv_tbl(i));
Line: 390

	    IF l_update_allowed = 'N' THEN
	         OKC_API.SET_MESSAGE(p_app_name => 'OKL',
	                             p_msg_name => 'OKL_NO_UPD_TRX_TYPE' );
Line: 402

     OKL_TRX_TYPES_PUB.update_trx_types(p_api_version                  => l_api_version,
                                        p_init_msg_list                => p_init_msg_list,
                                        x_return_status                => l_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: 444

END update_trx_types;
Line: 447

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

IS

l_api_version  	NUMBER := 1.0;
Line: 458

l_api_name      VARCHAR2(30) := 'DELETE_TRX_TYPES';
Line: 480

  OKL_TRX_TYPES_PUB.delete_trx_types(p_api_version                  => l_api_version,
                                        p_init_msg_list                => p_init_msg_list,
                                        x_return_status                => l_return_status,
                                        x_msg_count                    => x_msg_count,
                                        x_msg_data                     => x_msg_data,
                                        p_tryv_rec                     => p_tryv_rec);
Line: 521

END delete_trx_types;
Line: 525

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

IS

l_api_version  NUMBER := 1.0;
Line: 536

l_api_name            VARCHAR2(30) := 'DELETE_TRX_TYPES';
Line: 558

  OKL_TRX_TYPES_PUB.delete_trx_types(p_api_version                  => l_api_version,
                                        p_init_msg_list                => p_init_msg_list,
                                        x_return_status                => l_return_status,
                                        x_msg_count                    => x_msg_count,
                                        x_msg_data                     => x_msg_data,
                                        p_tryv_tbl                     => p_tryv_tbl);
Line: 600

END delete_trx_types;