APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_BOOK_CONTROLLER_TRX

Line 321: -- Initialize records in okl_book_controller_trx table

317: l_PassStatus := 'COMPLETE';
318: END IF;
319: gboomina commenting for Bug Bug 6476425 - end */
320:
321: -- Initialize records in okl_book_controller_trx table
322: okl_book_controller_pvt.init_book_controller_trx
323: (p_api_version => p_api_version,
324: p_init_msg_list => p_init_msg_list,
325: x_return_status => x_return_status,

Line 1811: FROM okl_book_controller_trx

1807:
1808: --Cursor to check existence of contract trx records
1809: CURSOR c_book_ctrl_trx (p_khr_id IN NUMBER) IS
1810: SELECT 'Y'
1811: FROM okl_book_controller_trx
1812: WHERE khr_id = p_khr_id
1813: AND progress_status = 'PENDING'
1814: AND NVL (active_flag, 'N') = 'N';
1815:

Line 4839: l_upfront_tax_prog_sts okl_book_controller_trx.progress_status%TYPE;

4835: l_mass_rbk_khr VARCHAR2 (1) := '?';
4836: l_orig_khr_id NUMBER;
4837: l_transaction_id NUMBER;
4838: l_rebook_date DATE;
4839: l_upfront_tax_prog_sts okl_book_controller_trx.progress_status%TYPE;
4840:
4841: --Bug# 6512668
4842: CURSOR sys_param_csr IS
4843: SELECT NVL (tax_upfront_yn, 'N')