[Home] [Help]
3496: */
3497: CURSOR get_pox_csr(p_pol_id NUMBER)
3498: IS
3499: SELECT POX.ID
3500: FROM OKL_POOL_TRANSACTIONS POX
3501: WHERE POX.POL_ID = p_pol_id
3502: AND POX.TRANSACTION_STATUS = 'APPROVED'
3503: AND POX.TRANSACTION_TYPE = 'ADD'
3504: AND POX.TRANSACTION_REASON = 'ADJUSTMENTS';
4042: x_msg_count OUT NOCOPY NUMBER,
4043: x_msg_data OUT NOCOPY VARCHAR2,
4044: p_agreement_id IN OKC_K_HEADERS_V.ID%TYPE,
4045: p_pool_id IN OKL_POOLS.ID%TYPE,
4046: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE)
4047: IS
4048: -- Get Pool Transaction Details
4049: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)
4050: IS
4048: -- Get Pool Transaction Details
4049: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)
4050: IS
4051: SELECT pox.id
4052: FROM okl_pool_transactions pox
4053: WHERE pox.pol_id = p_pool_id
4054: AND pox.TRANSACTION_STATUS IN (G_POOL_TRX_STATUS_NEW, G_POOL_TRX_STS_APPR_REJECTED, G_POOL_TRX_STATUS_INCOMPLETE);
4055:
4056: l_return_status VARCHAR2(3);
4059: l_key VARCHAR2(240);
4060: l_event_name VARCHAR2(240) := 'oracle.apps.okl.ia.approve_add_contracts_request';
4061: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;
4062: l_pool_id OKL_POOLS.ID%TYPE;
4063: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
4064: lp_poxv_rec poxv_rec_type;
4065: lx_poxv_rec poxv_rec_type;
4066: l_approval_process fnd_lookups.lookup_code%TYPE;
4067: l_msg_data VARCHAR2(2000);
4102: IF c_fetch_pool_trans_id_csr%NOTFOUND THEN
4103: OKL_API.set_message(p_app_name => G_APP_NAME,
4104: p_msg_name => G_NO_MATCHING_RECORD,
4105: p_token1 => G_COL_NAME_TOKEN,
4106: p_token1_value => 'OKL_POOL_TRANSACTIONS.ID');
4107: RAISE OKL_API.G_EXCEPTION_ERROR;
4108: END IF;
4109: CLOSE c_fetch_pool_trans_id_csr ;
4110:
4278:
4279: CURSOR get_pox_id_csr(p_pol_id NUMBER)
4280: IS
4281: SELECT ID
4282: FROM OKL_POOL_TRANSACTIONS
4283: WHERE pol_id = p_pol_id
4284: AND TRANSACTION_STATUS <> 'COMPLETE';
4285:
4286: