DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_BOOK_CONTROLLER_TRX

Line 415: -- Initialize records in okl_book_controller_trx table

411: l_PassStatus := 'COMPLETE';
412: END IF;
413: gboomina commenting for Bug Bug 6476425 - end */
414:
415: -- Initialize records in okl_book_controller_trx table
416: okl_book_controller_pvt.init_book_controller_trx
417: (p_api_version => p_api_version,
418: p_init_msg_list => p_init_msg_list,
419: x_return_status => x_return_status,

Line 2114: FROM okl_book_controller_trx

2110:
2111: --Cursor to check existence of contract trx records
2112: CURSOR c_book_ctrl_trx (p_khr_id IN NUMBER) IS
2113: SELECT 'Y'
2114: FROM okl_book_controller_trx
2115: WHERE khr_id = p_khr_id
2116: AND progress_status = 'PENDING'
2117: AND NVL (active_flag, 'N') = 'N';
2118:

Line 5307: l_upfront_tax_prog_sts okl_book_controller_trx.progress_status%TYPE;

5303: l_mass_rbk_khr VARCHAR2 (1) := '?';
5304: l_orig_khr_id NUMBER;
5305: l_transaction_id NUMBER;
5306: l_rebook_date DATE;
5307: l_upfront_tax_prog_sts okl_book_controller_trx.progress_status%TYPE;
5308:
5309: --Bug# 6512668
5310: CURSOR sys_param_csr IS
5311: SELECT NVL (tax_upfront_yn, 'N')