eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_PVT SQL Statements

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

Line: 95


    okl_sub_pvt.insert_row(
      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: 205


    okl_sub_pvt.insert_row(
	 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: 253


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: 274


   SELECT subsidy_pool_id
     FROM okl_subsidies_b
    WHERE id = p_subv_rec.id;

Line: 305


  okl_sub_pvt.update_row(
    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: 375


END update_subsidy;

Line: 377


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: 413


    okl_sub_pvt.update_row(
	 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: 458


END update_subsidy;

Line: 461


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: 496


    okl_sub_pvt.delete_row(
	 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: 540


END delete_subsidy;

Line: 543


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: 578


    okl_sub_pvt.delete_row(
	 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: 622


END delete_subsidy;

Line: 988


    okl_suc_pvt.insert_row(
	 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: 1073


    okl_suc_pvt.insert_row(
	 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: 1121


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: 1157


    okl_suc_pvt.update_row(
	 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: 1202


END update_subsidy_criteria;

Line: 1204


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: 1240


    okl_suc_pvt.update_row(
	 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: 1285


END update_subsidy_criteria;

Line: 1288


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: 1323


    okl_suc_pvt.delete_row(
	 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: 1367


END delete_subsidy_criteria;

Line: 1370


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: 1405


    okl_suc_pvt.delete_row(
	 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: 1449


END delete_subsidy_criteria;