APPS.OKL_CONTRACT_PROD_OPTNS_PVT SQL Statements

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

Line: 37

    okl_csp_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cspv_rec,
	    x_cspv_rec);

Line: 112

    okl_csp_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cspv_tbl,
	    x_cspv_tbl);

Line: 162

  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_api_name          CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_OPTION';

Line: 187

    okl_csp_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cspv_rec,
	    x_cspv_rec);

Line: 227

  END update_contract_option;

Line: 237

  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
    l_api_name          CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_OPTION';

Line: 262

    okl_csp_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cspv_tbl,
	    x_cspv_tbl);

Line: 302

  END update_contract_option;

Line: 312

  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_api_name          CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_OPTION';

Line: 336

    okl_csp_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cspv_rec);

Line: 375

  END delete_contract_option;

Line: 385

  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
    l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_OPTION';

Line: 409

    okl_csp_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cspv_tbl);

Line: 448

  END delete_contract_option;