DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PROD_OPTNS_PUB SQL Statements

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

Line: 155

  PROCEDURE update_contract_option(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_cspv_rec      IN         cspv_rec_type,
                                 x_cspv_rec      OUT NOCOPY cspv_rec_type) IS

    l_cspv_rec                           cspv_rec_type;
Line: 165

    l_api_name                  CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_OPTION';
Line: 168

    savepoint update_contract_option_pub;
Line: 187

    OKL_CONTRACT_PROD_OPTNS_PVT.update_contract_option(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_cspv_rec      => l_cspv_rec,
                                            x_cspv_rec      => x_cspv_rec);
Line: 206

		ROLLBACK  TO update_contract_option_pub;
Line: 211

		ROLLBACK  TO update_contract_option_pub;
Line: 216

		ROLLBACK  TO update_contract_option_pub;
Line: 218

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_contract_option_pub');
Line: 222

  END update_contract_option;
Line: 233

  PROCEDURE update_contract_option(
    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_cspv_tbl                     IN cspv_tbl_type,
    x_cspv_tbl                     OUT NOCOPY cspv_tbl_type) IS
    i                              NUMBER := 0;
Line: 248

        update_contract_option(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_cspv_rec      => p_cspv_tbl(i),
                             x_cspv_rec      => x_cspv_tbl(i));
Line: 273

    ROLLBACK  TO update_contract_option_pub;
Line: 278

    ROLLBACK  TO update_contract_option_pub;
Line: 283

    ROLLBACK  TO update_contract_option_pub;
Line: 285

    FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_contract_option_pub');
Line: 289

  END update_contract_option;
Line: 299

  PROCEDURE delete_contract_option(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_cspv_rec      IN         cspv_rec_type) IS

    l_cspv_rec                           cspv_rec_type;
Line: 308

    l_api_name                  CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_OPTION';
Line: 311

    savepoint delete_contract_option_pub;
Line: 330

    OKL_CONTRACT_PROD_OPTNS_PVT.delete_contract_option(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_cspv_rec      => l_cspv_rec);
Line: 347

		ROLLBACK  TO delete_contract_option_pub;
Line: 352

		ROLLBACK  TO delete_contract_option_pub;
Line: 357

		ROLLBACK  TO delete_contract_option_pub;
Line: 359

		FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_contract_option_pub');
Line: 363

  END delete_contract_option;
Line: 374

  PROCEDURE delete_contract_option(
    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_cspv_tbl                     IN cspv_tbl_type) IS
    i                              NUMBER := 0;
Line: 388

        delete_contract_option(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_cspv_rec      => p_cspv_tbl(i));
Line: 412

    ROLLBACK  TO delete_contract_option_pub;
Line: 417

    ROLLBACK  TO delete_contract_option_pub;
Line: 422

    ROLLBACK  TO delete_contract_option_pub;
Line: 424

    FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_contract_option_pub');
Line: 428

  END delete_contract_option;