The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT OKL_BKG_CONTL_SEQ.NEXTVAL
FROM DUAL;
SELECT *
FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND NVL(active_flag,'N') = 'Y';
okl_bct_pvt.insert_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_bct_tbl => l_bct_tbl,
x_bct_tbl => lx_bct_tbl);
PROCEDURE update_book_ctrl_trx(
p_batch_num IN okl_book_controller_trx.batch_number%TYPE,
p_srl_num IN okl_book_controller_trx.processing_srl_number%TYPE,
p_prog_status IN okl_book_controller_trx.progress_status%TYPE,
p_request_id IN okl_book_controller_trx.conc_req_id%TYPE,
x_return_status OUT NOCOPY VARCHAR2) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_book_ctrl_trx';
FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:batch number is null in call to update okl_book_controller_trx');
FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:processing srl number is null in call to update okl_book_controller_trx');
okl_bct_pvt.update_row(
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_bct_rec => l_bct_rec,
x_bct_rec => x_bct_rec);
END update_book_ctrl_trx;
SELECT sts_code
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT '1'
FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND progress_status = 'PENDING'
AND prog_short_name = 'OKLBCTBK'
AND NVL(active_flag,'N') = 'N';
update_book_controller_trx(
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_khr_id => p_khr_id,
p_prog_short_name => l_program_name,
p_conc_req_id => NULL,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
update_book_ctrl_trx(
p_batch_num => p_batch_number,
p_srl_num => p_serial_num,
p_prog_status => 'ERROR',
p_request_id => null,
x_return_status => l_return_status);
update_book_controller_trx(
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_khr_id => p_khr_id,
p_prog_short_name => l_program_name,
p_conc_req_id => l_request_id,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);
update_book_ctrl_trx(
p_batch_num => p_batch_number,
p_srl_num => p_serial_num,
p_prog_status => 'RUNNING',
p_request_id => l_request_id,
x_return_status => l_return_status);
update_book_controller_trx(
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_khr_id => p_khr_id,
p_prog_short_name => l_program_name,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
update_book_ctrl_trx(
p_batch_num => p_batch_number,
p_srl_num => p_serial_num,
p_prog_status => 'ERROR',
p_request_id => null,
x_return_status => l_return_status);
update_book_controller_trx(
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_khr_id => p_khr_id,
p_prog_short_name => l_program_name,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
update_book_ctrl_trx(
p_batch_num => p_batch_number,
p_srl_num => p_serial_num,
p_prog_status => 'COMPLETE',
p_request_id => null,
x_return_status => l_return_status);
SELECT * FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND progress_status = 'PENDING'
AND nvl(active_flag,'N') = 'N'
ORDER BY processing_srl_number;
SELECT sts_code
FROM okc_k_headers_b
WHERE id = p_khr_id;
update_book_ctrl_trx(
p_batch_num => l_batch_number,
p_srl_num => each_ctrl_trx.processing_srl_number,
p_prog_status => 'ABANDONED',
p_request_id => null,
x_return_status => l_return_status);
SELECT * FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND progress_status = 'PENDING'
AND nvl(active_flag,'N') = 'N'
ORDER BY processing_srl_number;
SELECT NVL(qcl_id,1)
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = 'CP_SET_OUTCOME'
AND lookup_code = p_sts_code;
SELECT sis_code
FROM okl_stream_interfaces
WHERE transaction_number = p_trx_num;
SELECT sts_code
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT transaction_number, sis_code
FROM okl_stream_interfaces
WHERE khr_id = p_khr_id
AND date_processed =
(SELECT MAX(date_processed)
FROM okl_stream_interfaces
WHERE khr_id = p_khr_id
AND sis_code NOT IN ('PROCESS_COMPLETE','PROCESS_COMPLETE_ERRORS',
'PROCESSING_FAILED','TIME_OUT','PROCESS_ABORTED', 'SERVER_NA')
);
SELECT orig_system_source_code,
orig_system_id1
FROM okc_k_headers_v
WHERE id = p_khr_id;
SELECT 'Y'
FROM OKL_BOOK_CONTROLLER_TRX
WHERE khr_id = p_khr_id
AND NVL(active_flag,'N') = 'Y';
SELECT sts_code
FROM okc_k_headers_b
WHERE id = p_khr_id;
okl_bct_pvt.insert_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_bct_tbl => l_bct_tbl,
x_bct_tbl => lx_bct_tbl);
PROCEDURE update_book_controller_trx(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khr_id IN okc_k_headers_b.id%TYPE,
p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_book_controller_trx';
SELECT *
FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND prog_short_name = nvl(p_prog_short_name, prog_short_name)
AND NVL(active_flag,'N') = 'Y';
FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
okl_bct_pvt.update_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_bct_rec => l_bct_rec,
x_bct_rec => x_bct_rec);
FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');
FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');
FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - UNEXCP ERROR');
FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - OTHERS');
END update_book_controller_trx;
okl_contract_status_pub.update_contract_status(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => 'INCOMPLETE',
p_chr_id => p_khr_id);
okl_book_controller_pvt.update_book_controller_trx(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_khr_id,
p_prog_short_name => l_prog_short_name,
p_conc_req_id => NULL,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
SELECT progress_status
FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND prog_short_name = p_prog_short_name
AND NVL(active_flag,'N') = 'Y';
SELECT progress_status
FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND prog_short_name = p_prog_short_name
AND NVL(active_flag,'N') = 'Y';