APPS.OKL_OPEN_INTERFACE_PUB SQL Statements

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

Line: 7

PROCEDURE insert_pending_int(
     p_api_version              IN NUMBER,
     p_init_msg_list            IN VARCHAR2 DEFAULT okl_api.G_FALSE,
     p_contract_id              IN NUMBER,
     x_oinv_rec                 OUT NOCOPY oinv_rec_type,
     x_return_status            OUT NOCOPY VARCHAR2,
     x_msg_count                OUT NOCOPY NUMBER,
     x_msg_data                 OUT NOCOPY VARCHAR2) AS

l_api_version NUMBER ;

Line: 27

SAVEPOINT insert_pending_int;

Line: 40

okl_opi_pvt.insert_pending_int(
     p_api_version => l_api_version,
     p_init_msg_list => l_init_msg_list,
     p_contract_id => l_contract_id,
     x_oinv_rec => lx_oinv_rec,
     x_return_status => l_return_status,
     x_msg_count => l_msg_count,
     x_msg_data => l_msg_data);

Line: 71

      ROLLBACK TO insert_pending_int;

Line: 79

      ROLLBACK TO insert_pending_int;

Line: 87

      ROLLBACK TO insert_pending_int;

Line: 91

      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','insert_pending_int');

Line: 95

END insert_pending_int;

Line: 207

      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','insert_pending_int');