APPS.OKL_SEC_AGREEMENT_WF dependencies on OKL_POOLS_ALL

Line 150: p_pool_id IN OKL_POOLS_ALL.ID%TYPE

146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_pool_trx_status IN OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE,
149: p_pool_trans_id IN OKL_POOL_TRANSACTIONS.ID%TYPE,
150: p_pool_id IN OKL_POOLS_ALL.ID%TYPE
151: ) IS
152:
153: l_api_name CONSTANT VARCHAR2(30) := 'l_change_add_req_status';
154: l_pool_trx_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE;

Line 156: l_pool_id OKL_POOLS_ALL.ID%TYPE;

152:
153: l_api_name CONSTANT VARCHAR2(30) := 'l_change_add_req_status';
154: l_pool_trx_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE;
155: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
156: l_pool_id OKL_POOLS_ALL.ID%TYPE;
157: lp_poxv_rec poxv_rec_type;
158: lx_poxv_rec poxv_rec_type;
159:
160: BEGIN

Line 293: p_pool_id IN OKL_POOLS_ALL.ID%TYPE,

289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,
292: p_agreement_id IN OKC_K_HEADERS_B.ID%TYPE,
293: p_pool_id IN OKL_POOLS_ALL.ID%TYPE,
294: p_pool_trans_id IN OKL_POOL_TRANSACTIONS.ID%TYPE)
295: IS
296:
297: -- Get Investor Agreement Details

Line 308: FROM okl_pools_all pol

304: -- Get Pool Details
305: CURSOR c_fetch_pool_number_csr(p_pool_id OKL_POOLS.ID%TYPE)
306: IS
307: SELECT pol.pool_number
308: FROM okl_pools_all pol
309: WHERE pol.id = p_pool_id ;
310:
311: -- Get the valid application id from FND
312: CURSOR c_get_app_id_csr

Line 344: l_pool_id OKL_POOLS_ALL.ID%TYPE;

340: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
341: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
342: l_agreement_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
343: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;
344: l_pool_id OKL_POOLS_ALL.ID%TYPE;
345: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
346: l_requester VARCHAR2(200);
347: l_pool_number OKL_POOLS_ALL.POOL_NUMBER%TYPE;
348: l_name VARCHAR2(200);

Line 347: l_pool_number OKL_POOLS_ALL.POOL_NUMBER%TYPE;

343: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;
344: l_pool_id OKL_POOLS_ALL.ID%TYPE;
345: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
346: l_requester VARCHAR2(200);
347: l_pool_number OKL_POOLS_ALL.POOL_NUMBER%TYPE;
348: l_name VARCHAR2(200);
349: l_requester_id VARCHAR2(200);
350: l_approval_option VARCHAR2(5);
351:

Line 624: ,OKL_POOLS_ALL OPA

620: ,OKL_POOL_TRANSACTIONS OPT
621: ,OKL_STRM_ELEMENTS STRM
622: ,FND_LOOKUPS FND
623: ,FND_LOOKUPS FND_REASON
624: ,OKL_POOLS_ALL OPA
625: ,OKC_K_HEADERS_ALL_B OKC
626: WHERE OPT.POL_ID = p_pool_id
627: AND OPT.TRANSACTION_REASON = 'ADJUSTMENTS'
628: AND OPT.TRANSACTION_TYPE = 'ADD'

Line 1008: l_pool_id OKL_POOLS_ALL.ID%TYPE;

1004: l_init_msg_list VARCHAR2(10);
1005: l_msg_data VARCHAR2(2000);
1006: l_api_name CONSTANT VARCHAR2(30) := 'update_add_khr_apprv_sts';
1007: l_pool_trans_id OKC_K_HEADERS_V.ID%TYPE;
1008: l_pool_id OKL_POOLS_ALL.ID%TYPE;
1009: l_approved_yn VARCHAR2(30);
1010: l_trx_number VARCHAR2(100);
1011: lv_approval_status_ame VARCHAR2(10);
1012:

Line 1185: l_pool_number okl_pools_all.pool_number%TYPE;

1181: l_approval_option VARCHAR2(5);
1182: l_pool_id okl_pools.ID%TYPE;
1183: l_inv_agrmnt_id okc_k_headers_v.ID%TYPE;
1184: l_inv_agrmnt_number okc_k_headers_v.contract_number%TYPE;
1185: l_pool_number okl_pools_all.pool_number%TYPE;
1186: l_api_name CONSTANT VARCHAR2(30) := 'check_add_apprv_process';
1187: l_pool_trans_id okl_pool_transactions.ID%TYPE;
1188:
1189: BEGIN