144: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
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:
145: x_return_status OUT NOCOPY VARCHAR2,
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';
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;
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;
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;
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:
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
298: CURSOR c_fetch_ia_number_csr(p_agreement_id OKC_K_HEADERS_V.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);
349: l_requester_id VARCHAR2(200);
616: , SUM(STRM.AMOUNT) STREAM_VALUE
617: , OPT.TRANSACTION_NUMBER
618: , OPT.TRANSACTION_DATE
619: FROM OKL_POOL_CONTENTS OPC
620: ,OKL_POOL_TRANSACTIONS OPT
621: ,OKL_STRM_ELEMENTS STRM
622: ,FND_LOOKUPS FND
623: ,FND_LOOKUPS FND_REASON
624: ,OKL_POOLS_ALL OPA
1133:
1134: l_message VARCHAR2(32000);
1135: l_inv_agrmnt_id NUMBER;
1136: l_pool_id NUMBER;
1137: l_pool_trans_id okl_pool_transactions.ID%TYPE;
1138: BEGIN
1139: l_inv_agrmnt_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1140: itemkey => document_id,
1141: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
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
1190: IF (funcmode = 'RUN') THEN
1191: l_approval_option := fnd_profile.value(G_IA_ADD_KHR_APPROVAL_PROCESS);
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);
1316: l_requester_id VARCHAR2(240);