[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
--p_lsm_id IN NUMBER,
p_tld_id IN NUMBER, -- 5897792
p_credit_amount IN NUMBER,
p_credit_sty_id IN NUMBER DEFAULT NULL,
p_credit_desc IN VARCHAR2 DEFAULT NULL,
p_credit_date IN DATE DEFAULT SYSDATE,
p_try_id IN NUMBER DEFAULT NULL,
p_transaction_source IN VARCHAR2 DEFAULT NULL, -- 5897792
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
x_tai_id OUT NOCOPY NUMBER,
x_taiv_rec OUT NOCOPY taiv_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
lx_tai_id NUMBER;
SAVEPOINT insert_request;
okl_credit_memo_pvt.insert_request(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
--p_lsm_id => p_lsm_id,
p_tld_id => p_tld_id, -- 5897792
p_credit_amount => p_credit_amount,
p_credit_sty_id => p_credit_sty_id,
p_credit_desc => p_credit_desc,
p_credit_date => p_credit_date,
p_try_id => p_try_id,
p_transaction_source => p_transaction_source, -- 5897792
p_source_trx_number => p_source_trx_number,
x_tai_id => x_tai_id,
x_taiv_rec => x_taiv_rec,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
ROLLBACK TO insert_request;
ROLLBACK TO insert_request;
ROLLBACK TO insert_request;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
END insert_request;
PROCEDURE insert_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
--p_lsm_id IN NUMBER,
p_tld_id IN NUMBER, -- 5897792
p_credit_amount IN NUMBER,
p_credit_sty_id IN NUMBER,
p_credit_desc IN VARCHAR2,
p_credit_date IN DATE DEFAULT SYSDATE,
p_try_id IN NUMBER,
p_transaction_source IN VARCHAR2 DEFAULT NULL, -- 5897792
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
x_tai_id OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
lx_taiv_rec taiv_rec_type;
insert_request(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
--p_lsm_id => p_lsm_id,
p_tld_id => p_tld_id, -- 5897792
p_credit_amount => p_credit_amount,
p_credit_sty_id => p_credit_sty_id,
p_credit_desc => p_credit_desc,
p_credit_date => p_credit_date,
p_try_id => p_try_id,
p_transaction_source => p_transaction_source, -- 5897792
p_source_trx_number => p_source_trx_number,
x_tai_id => x_tai_id,
x_taiv_rec => lx_taiv_rec,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
END insert_request;
PROCEDURE insert_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_credit_list IN credit_tbl,
p_transaction_source IN VARCHAR2 DEFAULT NULL, -- 5897792
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
x_taiv_tbl OUT NOCOPY taiv_tbl_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_return_status VARCHAR2(1);
SAVEPOINT insert_request;
okl_credit_memo_pvt.insert_request(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_credit_list => p_credit_list,
p_transaction_source => p_transaction_source, -- 5897792
p_source_trx_number => p_source_trx_number,
x_taiv_tbl => x_taiv_tbl,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
ROLLBACK TO insert_request;
ROLLBACK TO insert_request;
ROLLBACK TO insert_request;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
END insert_request;
PROCEDURE insert_on_acc_cm_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
--p_lsm_id IN NUMBER,
p_tld_id IN NUMBER, -- 5897792
p_credit_amount IN NUMBER,
p_credit_sty_id IN NUMBER DEFAULT NULL,
p_credit_desc IN VARCHAR2 DEFAULT NULL,
p_credit_date IN DATE DEFAULT SYSDATE,
p_try_id IN NUMBER DEFAULT NULL,
p_transaction_source IN VARCHAR2 DEFAULT NULL, -- 5897792
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
x_tai_id OUT NOCOPY NUMBER,
x_taiv_rec OUT NOCOPY taiv_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
lx_tai_id NUMBER;
SAVEPOINT insert_request;
okl_credit_memo_pvt.insert_on_acc_cm_request(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
--p_lsm_id => p_lsm_id,
p_tld_id => p_tld_id, -- 5897792
p_credit_amount => p_credit_amount,
p_credit_sty_id => p_credit_sty_id,
p_credit_desc => p_credit_desc,
p_credit_date => p_credit_date,
p_try_id => p_try_id,
p_transaction_source => p_transaction_source, -- 5897792
p_source_trx_number => p_source_trx_number,
x_tai_id => x_tai_id,
x_taiv_rec => x_taiv_rec,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
ROLLBACK TO insert_request;
ROLLBACK TO insert_request;
ROLLBACK TO insert_request;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
END insert_on_acc_cm_request;