APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_POOL_TRANSACTIONS

Line 7509: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

7505:
7506: l_total_amount NUMBER := 0;
7507: l_khr_id NUMBER;
7508: l_sty_id NUMBER;
7509: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
7510:
7511: BEGIN
7512:
7513: --Validate additional parameters availability

Line 7633: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

7629: AND kleb.stream_type_subclass = p_sty_subclass;
7630:
7631: l_total_amount NUMBER := 0;
7632: l_total_percent NUMBER := 0;
7633: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
7634:
7635: BEGIN
7636:
7637: l_total_percent := 0;

Line 7873: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

7869: AND POC.STY_ID = STYS.ID
7870: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
7871: AND POC.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING);
7872:
7873: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
7874:
7875: BEGIN
7876: IF Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS.COUNT > 0 THEN
7877: FOR I IN OKL_EXECUTE_FORMULA_PUB.G_ADDITIONAL_PARAMETERS.FIRST..OKL_EXECUTE_FORMULA_PUB.G_ADDITIONAL_PARAMETERS.LAST

Line 7964: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

7960: CLEB.LSE_ID = LSEB.ID AND
7961: LSEB.LTY_CODE = 'INVESTMENT' AND
7962: CLEB.DNZ_CHR_ID = p_contract_id;
7963:
7964: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
7965:
7966: BEGIN
7967:
7968: IF Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS.COUNT > 0 THEN

Line 8097: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8093:
8094: l_total_percent NUMBER := 0;
8095: l_total_sec_amount NUMBER := 0;
8096: l_per_subclass_amount NUMBER := 0;
8097: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8098:
8099: BEGIN
8100:
8101: FOR l_khr_csr_rec IN l_khr_csr(p_contract_id)

Line 8888: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8884:
8885: l_unbill_rent_amount NUMBER := 0;
8886: l_undisb_rent_amount NUMBER := 0;
8887: l_result_amount NUMBER := 0;
8888: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8889:
8890: -- rmunjulu EDAT
8891: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
8892: SELECT trunc(qte.date_effective_from) date_effective_from

Line 9104: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

9100: AND pocb.khr_id = stm.khr_id
9101: AND pocb.kle_id = stm.kle_id
9102: AND pocb.sty_id = stm.sty_id;
9103:
9104: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
9105: l_residual_amount NUMBER := 0;
9106: l_result_amount NUMBER := 0;
9107: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
9108: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 9312: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

9308: l_undisb_interest_amount NUMBER := 0;
9309: l_undisb_ppd_amount NUMBER := 0;
9310: l_undisb_loan_amount NUMBER := 0;
9311: l_result_amount NUMBER := 0;
9312: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
9313:
9314: -- rmunjulu EDAT
9315: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
9316: SELECT trunc(qte.date_effective_from) date_effective_from