APPS.IEX_OPEN_INTERFACE_PUB SQL Statements

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

Line: 27

PROCEDURE insert_pending(
     p_api_version              IN NUMBER,
     p_init_msg_list            IN VARCHAR2,
     p_object1_id1              IN VARCHAR2,
     p_object1_id2              IN VARCHAR2,
     p_jtot_object1_code        IN VARCHAR2,
     p_action                   IN VARCHAR2,
     p_status                   IN VARCHAR2,
     p_comments                 IN VARCHAR2,
     p_ext_agncy_id             IN NUMBER,
     p_review_date              IN DATE,
     p_recall_date              IN DATE,
     p_automatic_recall_flag    IN VARCHAR2,
     p_review_before_recall_flag    IN VARCHAR2,
     x_return_status            OUT NOCOPY VARCHAR2,
     x_msg_count                OUT NOCOPY NUMBER,
     x_msg_data                 OUT NOCOPY VARCHAR2) AS

l_api_version NUMBER ;

Line: 71

SAVEPOINT insert_pending;

Line: 111

  okl_open_interface_pub.insert_pending_int(
     p_api_version => l_api_version,
     p_init_msg_list => l_init_msg_list,
     p_contract_id => to_number(l_object1_id1),
     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: 146

iex_opi_pvt.insert_pending_hst(
     p_api_version => l_api_version,
     p_init_msg_list => l_init_msg_list,
     p_iohv_rec => lp_iohv_rec,
     x_iohv_rec => lx_iohv_rec,
     x_return_status => l_return_status,
     x_msg_count => l_msg_count,
     x_msg_data => l_msg_data);

Line: 173

      ROLLBACK TO insert_pending;

Line: 181

      ROLLBACK TO insert_pending;

Line: 189

      ROLLBACK TO insert_pending;

Line: 193

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

Line: 197

END insert_pending;