eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEC_AGREEMENT_WF dependencies on OKL_POOLS

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 305: CURSOR c_fetch_pool_number_csr(p_pool_id OKL_POOLS.ID%TYPE)

301: FROM okc_k_headers_v chrv
302: WHERE chrv.id = p_agreement_id;
303:
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 ;

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 424: p_token1_value => 'OKL_POOLS.NUMBER');

420: IF c_fetch_pool_number_csr%NOTFOUND THEN
421: OKL_API.set_message(p_app_name => G_APP_NAME,
422: p_msg_name => G_NO_MATCHING_RECORD,
423: p_token1 => G_COL_NAME_TOKEN,
424: p_token1_value => 'OKL_POOLS.NUMBER');
425: RAISE OKL_API.G_EXCEPTION_ERROR;
426: END IF;
427: CLOSE c_fetch_pool_number_csr ;
428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 610: CURSOR l_okl_add_contracts_csr(p_inv_agrmnt_id OKC_K_HEADERS_V.ID%TYPE, p_pool_id OKL_POOLS.ID%TYPE,p_pool_trans_id IN NUMBER)

606: ---------------------------------------------------------------------------
607: FUNCTION compile_msg_for_add_req(p_inv_agrmnt_id IN NUMBER, p_pool_id IN NUMBER,p_pool_trans_id IN NUMBER)
608: RETURN VARCHAR2
609: IS
610: CURSOR l_okl_add_contracts_csr(p_inv_agrmnt_id OKC_K_HEADERS_V.ID%TYPE, p_pool_id OKL_POOLS.ID%TYPE,p_pool_trans_id IN NUMBER)
611: IS
612: SELECT OPA.POOL_NUMBER
613: , OKC.CONTRACT_NUMBER AGREEMENT_NUMBER
614: , FND_REASON.MEANING TRANSACTION_REASON

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 1182: l_pool_id okl_pools.ID%TYPE;

1178: funcmode IN VARCHAR2,
1179: resultout OUT NOCOPY VARCHAR2 )
1180: IS
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';

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

Line 1310: l_pool_id okl_pools.ID%TYPE;

1306:
1307: l_key VARCHAR2(240);
1308: l_process VARCHAR2(30);
1309: l_item_type VARCHAR2(10) ;
1310: l_pool_id okl_pools.ID%TYPE;
1311: l_pool_number okl_pools.pool_number%TYPE;
1312: l_pool_trans_id okl_pool_transactions.ID%TYPE;
1313: l_agreement_id VARCHAR2(240);
1314: l_agreement_number okc_k_headers_v.contract_number%TYPE;

Line 1311: l_pool_number okl_pools.pool_number%TYPE;

1307: l_key VARCHAR2(240);
1308: l_process VARCHAR2(30);
1309: l_item_type VARCHAR2(10) ;
1310: l_pool_id okl_pools.ID%TYPE;
1311: l_pool_number okl_pools.pool_number%TYPE;
1312: l_pool_trans_id okl_pool_transactions.ID%TYPE;
1313: l_agreement_id VARCHAR2(240);
1314: l_agreement_number okc_k_headers_v.contract_number%TYPE;
1315: l_requester VARCHAR2(240);