APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_POOL_TRANSACTIONS

Line 8158: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8154:
8155: l_total_amount NUMBER := 0;
8156: l_khr_id NUMBER;
8157: l_sty_id NUMBER;
8158: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8159:
8160: BEGIN
8161:
8162: --Validate additional parameters availability

Line 8292: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8288: AND kleb.stream_type_subclass = p_sty_subclass;
8289:
8290: l_total_amount NUMBER := 0;
8291: l_total_percent NUMBER := 0;
8292: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8293:
8294: --Bug# 12557486
8295: l_rent_sty_purpose okl_strm_type_b.stream_type_purpose%TYPE := 'RENT';
8296: l_residual_sty_purpose okl_strm_type_b.stream_type_purpose%TYPE := 'RESIDUAL_VALUE';

Line 8547: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8543: AND POC.STY_ID = STYS.ID
8544: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
8545: AND POC.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING);
8546:
8547: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8548:
8549: BEGIN
8550: IF Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS.COUNT > 0 THEN
8551: FOR I IN OKL_EXECUTE_FORMULA_PUB.G_ADDITIONAL_PARAMETERS.FIRST..OKL_EXECUTE_FORMULA_PUB.G_ADDITIONAL_PARAMETERS.LAST

Line 8638: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8634: CLEB.LSE_ID = LSEB.ID AND
8635: LSEB.LTY_CODE = 'INVESTMENT' AND
8636: CLEB.DNZ_CHR_ID = p_contract_id;
8637:
8638: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8639:
8640: BEGIN
8641:
8642: IF Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS.COUNT > 0 THEN

Line 8771: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

8767:
8768: l_total_percent NUMBER := 0;
8769: l_total_sec_amount NUMBER := 0;
8770: l_per_subclass_amount NUMBER := 0;
8771: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
8772:
8773: BEGIN
8774:
8775: FOR l_khr_csr_rec IN l_khr_csr(p_contract_id)

Line 9740: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

9736:
9737: l_unbill_rent_amount NUMBER := 0;
9738: l_undisb_rent_amount NUMBER := 0;
9739: l_result_amount NUMBER := 0;
9740: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
9741:
9742: -- rmunjulu EDAT
9743: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
9744: SELECT trunc(qte.date_effective_from) date_effective_from

Line 9956: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

9952: AND pocb.khr_id = stm.khr_id
9953: AND pocb.kle_id = stm.kle_id
9954: AND pocb.sty_id = stm.sty_id;
9955:
9956: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
9957: l_residual_amount NUMBER := 0;
9958: l_result_amount NUMBER := 0;
9959: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
9960: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 10164: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;

10160: l_undisb_interest_amount NUMBER := 0;
10161: l_undisb_ppd_amount NUMBER := 0;
10162: l_undisb_loan_amount NUMBER := 0;
10163: l_result_amount NUMBER := 0;
10164: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
10165:
10166: -- rmunjulu EDAT
10167: CURSOR get_quote_date_csr (p_quote_id IN NUMBER) IS
10168: SELECT trunc(qte.date_effective_from) date_effective_from