[Home] [Help]
3479: */
3480: CURSOR get_pox_csr(p_pol_id NUMBER)
3481: IS
3482: SELECT POX.ID
3483: FROM OKL_POOL_TRANSACTIONS POX
3484: WHERE POX.POL_ID = p_pol_id
3485: AND POX.TRANSACTION_STATUS = 'APPROVED'
3486: AND POX.TRANSACTION_TYPE = 'ADD'
3487: AND POX.TRANSACTION_REASON = 'ADJUSTMENTS';
4025: x_msg_count OUT NOCOPY NUMBER,
4026: x_msg_data OUT NOCOPY VARCHAR2,
4027: p_agreement_id IN OKC_K_HEADERS_V.ID%TYPE,
4028: p_pool_id IN OKL_POOLS.ID%TYPE,
4029: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE)
4030: IS
4031: -- Get Pool Transaction Details
4032: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)
4033: IS
4031: -- Get Pool Transaction Details
4032: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)
4033: IS
4034: SELECT pox.id
4035: FROM okl_pool_transactions pox
4036: WHERE pox.pol_id = p_pool_id
4037: AND pox.TRANSACTION_STATUS IN (G_POOL_TRX_STATUS_NEW, G_POOL_TRX_STS_APPR_REJECTED, G_POOL_TRX_STATUS_INCOMPLETE);
4038:
4039: l_return_status VARCHAR2(3);
4042: l_key VARCHAR2(240);
4043: l_event_name VARCHAR2(240) := 'oracle.apps.okl.ia.approve_add_contracts_request';
4044: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;
4045: l_pool_id OKL_POOLS.ID%TYPE;
4046: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
4047: lp_poxv_rec poxv_rec_type;
4048: lx_poxv_rec poxv_rec_type;
4049: l_approval_process fnd_lookups.lookup_code%TYPE;
4050: l_msg_data VARCHAR2(2000);
4080: IF c_fetch_pool_trans_id_csr%NOTFOUND THEN
4081: OKL_API.set_message(p_app_name => G_APP_NAME,
4082: p_msg_name => G_NO_MATCHING_RECORD,
4083: p_token1 => G_COL_NAME_TOKEN,
4084: p_token1_value => 'OKL_POOL_TRANSACTIONS.ID');
4085: RAISE OKL_API.G_EXCEPTION_ERROR;
4086: END IF;
4087: CLOSE c_fetch_pool_trans_id_csr ;
4088:
4250:
4251: CURSOR get_pox_id_csr(p_pol_id NUMBER)
4252: IS
4253: SELECT ID
4254: FROM OKL_POOL_TRANSACTIONS
4255: WHERE pol_id = p_pol_id
4256: AND TRANSACTION_STATUS <> 'COMPLETE';
4257:
4258: