DBA Data[Home] [Help]

APPS.OKL_AM_SHIPPING_INSTR_PUB SQL Statements

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

Line: 185

PROCEDURE update_shipping_instr(
    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_rasv_rec                      IN  rasv_rec_type,
    x_rasv_rec                      OUT NOCOPY rasv_rec_type) IS

l_api_version NUMBER ;
Line: 204

SAVEPOINT shipping_instr_update;
Line: 219

okl_am_shipping_instr_pvt.update_shipping_instr(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_rasv_rec
                             ,lx_rasv_rec);
Line: 250

      ROLLBACK TO shipping_instr_update;
Line: 258

      ROLLBACK TO shipping_instr_update;
Line: 266

      ROLLBACK TO shipping_instr_update;
Line: 270

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_SHIPPING_INSTR_PUB','update_shipping_instr');
Line: 274

END update_shipping_instr;
Line: 276

PROCEDURE update_shipping_instr(
    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_rasv_tbl                      IN  rasv_tbl_type,
    x_rasv_tbl                      OUT NOCOPY rasv_tbl_type) IS

l_api_version NUMBER;
Line: 295

SAVEPOINT shipping_instr_update;
Line: 309

okl_am_shipping_instr_pvt.update_shipping_instr(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_rasv_tbl
                             ,lx_rasv_tbl);
Line: 339

      ROLLBACK TO shipping_instr_update;
Line: 347

      ROLLBACK TO shipping_instr_update;
Line: 355

      ROLLBACK TO shipping_instr_update;
Line: 359

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_SHIPPING_INSTR_PUB','update_shipping_instr');
Line: 363

END update_shipping_instr;