[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT btc.trx_status_code
FROM OKL_TRX_CSH_BATCH_V btc
WHERE btc.id = cp_btc_id;
SELECT rct.id
FROM OKL_TRX_CSH_RECEIPT_V rct
WHERE rct.btc_id = cp_btc_id;
SELECT rca.id
FROM OKL_TXL_RCPT_APPS_V rca
WHERE rca.rct_id_details = cp_rct_id;
okl_trx_csh_batch_pub.delete_trx_csh_batch( p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_btcv_tbl => l_btcv_tbl
);
OKL_INCSH_PVT.delete_internal_trans(p_api_version => l_api_version ,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_rctv_tbl => l_rctv_tbl
);
OKL_INCSH_PVT.delete_internal_trans(p_api_version => l_api_version ,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_rcav_tbl => l_rcav_tbl
);