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 OKC_K_HEADERS_V

Line 298: CURSOR c_fetch_ia_number_csr(p_agreement_id OKC_K_HEADERS_V.ID%TYPE)

294: p_pool_trans_id IN OKL_POOL_TRANSACTIONS.ID%TYPE)
295: IS
296:
297: -- Get Investor Agreement Details
298: CURSOR c_fetch_ia_number_csr(p_agreement_id OKC_K_HEADERS_V.ID%TYPE)
299: IS
300: SELECT chrv.contract_number
301: FROM okc_k_headers_v chrv
302: WHERE chrv.id = p_agreement_id;

Line 301: FROM okc_k_headers_v chrv

297: -- Get Investor Agreement Details
298: CURSOR c_fetch_ia_number_csr(p_agreement_id OKC_K_HEADERS_V.ID%TYPE)
299: IS
300: SELECT chrv.contract_number
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)

Line 342: l_agreement_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

338: l_event_name VARCHAR2(240);
339: l_application_id FND_APPLICATION.APPLICATION_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);

Line 343: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;

339: l_application_id FND_APPLICATION.APPLICATION_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;

Line 410: p_token1_value => 'OKC_K_HEADERS_V.ID');

406: IF c_fetch_ia_number_csr%NOTFOUND THEN
407: OKL_API.set_message(p_app_name => G_APP_NAME,
408: p_msg_name => G_NO_MATCHING_RECORD,
409: p_token1 => G_COL_NAME_TOKEN,
410: p_token1_value => 'OKC_K_HEADERS_V.ID');
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: CLOSE c_fetch_ia_number_csr;
414: 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 819: l_ia_number OKC_K_HEADERS_V.contract_number%TYPE;

815: WHERE user_id = p_user_id;
816:
817: l_api_name CONSTANT VARCHAR2(200) := 'get_add_khr_approver';
818: l_user_id VARCHAR2(200);
819: l_ia_number OKC_K_HEADERS_V.contract_number%TYPE;
820: l_return_status VARCHAR2(1);
821:
822: BEGIN
823: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 906: l_ia_number okc_k_headers_v.contract_number%TYPE;

902: l_parent_key VARCHAR2(240);
903: l_parent_type VARCHAR2(240);
904: l_result VARCHAR2(30);
905: l_api_name CONSTANT VARCHAR2(30) := 'Set_Add_Khr_Attributes';
906: l_ia_number okc_k_headers_v.contract_number%TYPE;
907:
908: BEGIN
909: SAVEPOINT set_atts;
910: IF (funcmode = 'RUN') THEN

Line 1007: l_pool_trans_id OKC_K_HEADERS_V.ID%TYPE;

1003: l_msg_count NUMBER;
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);

Line 1183: l_inv_agrmnt_id okc_k_headers_v.ID%TYPE;

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';
1187: l_pool_trans_id okl_pool_transactions.ID%TYPE;

Line 1184: l_inv_agrmnt_number okc_k_headers_v.contract_number%TYPE;

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';
1187: l_pool_trans_id okl_pool_transactions.ID%TYPE;
1188:

Line 1314: l_agreement_number okc_k_headers_v.contract_number%TYPE;

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);
1316: l_requester_id VARCHAR2(240);
1317: l_api_name CONSTANT VARCHAR2(30) := 'wf_add_khr_apprv_process';
1318: