APPS.OKL_SUBSIDY_PUB SQL Statements

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

Line: 174

PROCEDURE update_subsidy(
    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_subv_rec                     IN  subv_rec_type,
    x_subv_rec                     OUT NOCOPY subv_rec_type) IS

    l_api_name		    CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY';

Line: 210

    okl_subsidy_pvt.update_subsidy(
	 p_api_version	    => p_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_subv_rec		    => l_subv_rec,
	 x_subv_rec		    => x_subv_rec);

Line: 255

END update_subsidy;

Line: 257

PROCEDURE update_subsidy(
    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_subv_tbl                     IN  subv_tbl_type,
    x_subv_tbl                     OUT NOCOPY subv_tbl_type) IS

    l_api_name		    CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY';

Line: 293

    okl_subsidy_pvt.update_subsidy(
	 p_api_version	    => p_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_subv_tbl		    => l_subv_tbl,
	 x_subv_tbl		    => x_subv_tbl);

Line: 338

END update_subsidy;

Line: 341

PROCEDURE delete_subsidy(
    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_subv_rec                     IN  subv_rec_type) IS

    l_api_name		    CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY';

Line: 376

    okl_subsidy_pvt.delete_subsidy(
	 p_api_version	    => p_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_subv_rec		    => l_subv_rec);

Line: 420

END delete_subsidy;

Line: 423

PROCEDURE delete_subsidy(
    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_subv_tbl                     IN  subv_tbl_type) Is

    l_api_name		    CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY';

Line: 458

    okl_subsidy_pvt.delete_subsidy(
	 p_api_version	    => p_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_subv_tbl		    => l_subv_tbl);

Line: 502

END delete_subsidy;

Line: 1001

PROCEDURE update_subsidy_criteria(
    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_sucv_rec                     IN  sucv_rec_type,
    x_sucv_rec                     OUT NOCOPY sucv_rec_type) IS

    l_api_name		    CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY_CRITERIA';

Line: 1037

    okl_subsidy_pvt.update_subsidy_criteria(
	 p_api_version	    => p_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_sucv_rec		    => l_sucv_rec,
	 x_sucv_rec		    => x_sucv_rec);

Line: 1082

END update_subsidy_criteria;

Line: 1084

PROCEDURE update_subsidy_criteria(
    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_sucv_tbl                     IN  sucv_tbl_type,
    x_sucv_tbl                     OUT NOCOPY sucv_tbl_type) IS

    l_api_name		    CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY_CRITERIA';

Line: 1120

    okl_subsidy_pvt.update_subsidy_criteria(
	 p_api_version	    => p_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_sucv_tbl		    => l_sucv_tbl,
	 x_sucv_tbl		    => x_sucv_tbl);

Line: 1165

END update_subsidy_criteria;

Line: 1168

PROCEDURE delete_subsidy_criteria(
    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_sucv_rec                     IN  sucv_rec_type) IS

    l_api_name		    CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY_CRITERIA';

Line: 1203

    okl_subsidy_pvt.delete_subsidy_criteria(
	 p_api_version	    => p_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_sucv_rec		    => l_sucv_rec);

Line: 1247

END delete_subsidy_criteria;

Line: 1250

PROCEDURE delete_subsidy_criteria(
    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_sucv_tbl                     IN  sucv_tbl_type) Is

    l_api_name		    CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY_CRITERIA';

Line: 1285

    okl_subsidy_pvt.delete_subsidy_criteria(
	 p_api_version	    => p_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_sucv_tbl		    => l_sucv_tbl);

Line: 1329

END delete_subsidy_criteria;