APPS.OKL_SPLIT_ASSET_COMP_PUB SQL Statements

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

Line: 98

   PROCEDURE update_split_asset_comp(
     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_asdv_tbl                     IN advv_tbl_type,
     x_asdv_tbl                     OUT NOCOPY advv_tbl_type)
     IS

     l_api_version     CONSTANT NUMBER       := 1.0;

Line: 109

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

Line: 113

  SAVEPOINT update_split_asset_comp_pub;

Line: 135

    OKL_SPLIT_ASSET_COMP_PVT.update_split_asset_comp(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_asdv_tbl,
                            x_asdv_tbl);

Line: 158

    ROLLBACK TO update_split_asset_comp_pub;

Line: 165

    ROLLBACK TO update_split_asset_comp_pub;

Line: 172

	ROLLBACK TO update_split_asset_comp_pub;

Line: 184

   END update_split_asset_comp;

Line: 187

   PROCEDURE delete_split_asset_comp(
     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_asdv_tbl                     IN advv_tbl_type)
     IS

     l_api_version     CONSTANT NUMBER       := 1.0;

Line: 197

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

Line: 201

  SAVEPOINT delete_split_asset_comp_pub;

Line: 223

    OKL_SPLIT_ASSET_COMP_PVT.delete_split_asset_comp(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_asdv_tbl);

Line: 245

    ROLLBACK TO delete_split_asset_comp_pub;

Line: 252

    ROLLBACK TO delete_split_asset_comp_pub;

Line: 259

	ROLLBACK TO delete_split_asset_comp_pub;

Line: 271

   END delete_split_asset_comp;