DBA Data[Home] [Help]

APPS.OKL_SYSTEM_PARAMS_ALL_PUB SQL Statements

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

Line: 13

  PROCEDURE insert_system_parameters(
    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_sypv_rec                     IN sypv_rec_type,
    x_sypv_rec                     OUT NOCOPY sypv_rec_type) IS
    l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
Line: 23

     SAVEPOINT insert_row_trx;
Line: 24

     OKL_SYP_PVT.insert_row(
                    p_api_version    => p_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_sypv_rec       => p_sypv_rec,
                    x_sypv_rec       => x_sypv_rec);
Line: 41

      ROLLBACK TO insert_row_trx;
Line: 47

      ROLLBACK TO insert_row_trx;
Line: 53

      ROLLBACK TO insert_row_trx;
Line: 55

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
Line: 59

  END insert_system_parameters;
Line: 70

  PROCEDURE insert_system_parameters(
    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_sypv_tbl                     IN sypv_tbl_type,
    x_sypv_tbl                     OUT NOCOPY sypv_tbl_type) IS
    l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
Line: 80

     SAVEPOINT insert_row_trx;
Line: 81

     OKL_SYP_PVT.insert_row(
                    p_api_version    => p_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_sypv_tbl       => p_sypv_tbl,
                    x_sypv_tbl       => x_sypv_tbl);
Line: 98

      ROLLBACK TO insert_row_trx;
Line: 104

      ROLLBACK TO insert_row_trx;
Line: 110

      ROLLBACK TO insert_row_trx;
Line: 112

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
Line: 116

  END insert_system_parameters;
Line: 237

  PROCEDURE update_system_parameters(
    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_sypv_rec                     IN sypv_rec_type,
    x_sypv_rec                     OUT NOCOPY sypv_rec_type) IS
    l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
Line: 247

     SAVEPOINT update_row_trx;
Line: 248

     OKL_SYP_PVT.update_row(
                    p_api_version    => p_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_sypv_rec       => p_sypv_rec,
                    x_sypv_rec       => x_sypv_rec);
Line: 265

      ROLLBACK TO update_row_trx;
Line: 271

      ROLLBACK TO update_row_trx;
Line: 277

      ROLLBACK TO update_row_trx;
Line: 279

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
Line: 283

  END update_system_parameters;
Line: 294

  PROCEDURE update_system_parameters(
    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_sypv_tbl                     IN sypv_tbl_type,
    x_sypv_tbl                     OUT NOCOPY sypv_tbl_type) IS
    l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
Line: 304

     SAVEPOINT update_row_trx;
Line: 305

     OKL_SYP_PVT.update_row(
                    p_api_version    => p_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_sypv_tbl       => p_sypv_tbl,
                    x_sypv_tbl       => x_sypv_tbl);
Line: 322

      ROLLBACK TO update_row_trx;
Line: 328

      ROLLBACK TO update_row_trx;
Line: 334

      ROLLBACK TO update_row_trx;
Line: 336

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
Line: 340

  END update_system_parameters;
Line: 351

  PROCEDURE delete_system_parameters(
    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_sypv_rec                     IN sypv_rec_type) IS
    l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
Line: 360

     SAVEPOINT delete_row_trx;
Line: 361

     OKL_SYP_PVT.delete_row(
                    p_api_version    => p_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_sypv_rec       => p_sypv_rec);
Line: 377

      ROLLBACK TO delete_row_trx;
Line: 383

      ROLLBACK TO delete_row_trx;
Line: 389

      ROLLBACK TO delete_row_trx;
Line: 391

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
Line: 395

  END delete_system_parameters;
Line: 406

  PROCEDURE delete_system_parameters(
    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_sypv_tbl                     IN sypv_tbl_type) IS
    l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
Line: 415

     SAVEPOINT delete_row_trx;
Line: 416

     OKL_SYP_PVT.delete_row(
                    p_api_version    => p_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_sypv_tbl       => p_sypv_tbl);
Line: 432

      ROLLBACK TO delete_row_trx;
Line: 438

      ROLLBACK TO delete_row_trx;
Line: 444

      ROLLBACK TO delete_row_trx;
Line: 446

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
Line: 450

  END delete_system_parameters;
Line: 579

  CURSOR C IS SELECT item_inv_org_id      ,
  		             rpt_prod_book_type_code	,
  		             asst_add_book_type_code	,
  		             ccard_remittance_id
             FROM okl_system_params_all
  	         WHERE org_id = l_org_id ;