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_CONTRACT_REBOOK_PVT dependencies on DUAL

Line 761: 'INVESTOR_RESIDUAL_BUYBACK','INVESTOR_RESIDUAL_DISB_BASIS','INVESTOR_RESIDUAL_PAY',

757: 'INVESTOR_INTEREST_INCOME','INVESTOR_INTEREST_PAYABLE','INVESTOR_LATE_FEE_PAYABLE',
758: 'INVESTOR_LATE_INTEREST_PAY','INVESTOR_PAYABLE','INVESTOR_PRETAX_INCOME',
759: 'INVESTOR_PRINCIPAL_PAYABLE','INVESTOR_RECEIVABLE','INVESTOR_RENTAL_ACCRUAL',
760: 'INVESTOR_RENT_BUYBACK','INVESTOR_RENT_DISB_BASIS','INVESTOR_RENT_PAYABLE',
761: 'INVESTOR_RESIDUAL_BUYBACK','INVESTOR_RESIDUAL_DISB_BASIS','INVESTOR_RESIDUAL_PAY',
762: 'INVESTOR_VARIABLE_INTEREST','PV_RENT_SECURITIZED','PV_RV_SECURITIZED'))THEN
763:
764: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
765: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Ignore Investor Stream Line ID: '||deleted_streams_rec.orig_stm_id);

Line 4633: -- Sync 1. Adjust Residual Value

4629: ------------------------------------------------------------------------------
4630: -- PROCEDURE sync_line_values
4631: --
4632: -- This procedure synchronizes Rebook and Original Contract Line Values
4633: -- Sync 1. Adjust Residual Value
4634: -- 2. Adjust Cost
4635: --
4636: -- Calls:
4637: -- Called By:

Line 4820: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;

4816: IF (rebook_line_rec.orig_system_id1 IS NOT NULL) THEN -- Old Line, Update
4817:
4818: l_clev_tbl(i).id := rebook_line_rec.orig_system_id1;
4819: l_klev_tbl(i).id := rebook_line_rec.orig_system_id1;
4820: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;
4821: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;
4822: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;
4823: l_klev_tbl(i).oec := rebook_line_rec.oec;
4824: l_klev_tbl(i).capital_amount := rebook_line_rec.capital_amount;

Line 4821: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;

4817:
4818: l_clev_tbl(i).id := rebook_line_rec.orig_system_id1;
4819: l_klev_tbl(i).id := rebook_line_rec.orig_system_id1;
4820: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;
4821: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;
4822: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;
4823: l_klev_tbl(i).oec := rebook_line_rec.oec;
4824: l_klev_tbl(i).capital_amount := rebook_line_rec.capital_amount;
4825:

Line 4822: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;

4818: l_clev_tbl(i).id := rebook_line_rec.orig_system_id1;
4819: l_klev_tbl(i).id := rebook_line_rec.orig_system_id1;
4820: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;
4821: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;
4822: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;
4823: l_klev_tbl(i).oec := rebook_line_rec.oec;
4824: l_klev_tbl(i).capital_amount := rebook_line_rec.capital_amount;
4825:
4826: -- sjalasut, added for rebook change control enhancement. START

Line 5469: -- 1. Adjust Residual Value

5465: RAISE OKC_API.G_EXCEPTION_ERROR;
5466: END IF;
5467:
5468: --
5469: -- 1. Adjust Residual Value
5470: -- 2. Adjust Cost
5471: --
5472: sync_line_values(
5473: x_return_status => x_return_status,

Line 6530: FROM DUAL;

6526: --**********************************************************
6527: -- Get Sequence Number to generate Contract Number
6528: SELECT okl_rbk_seq.NEXTVAL
6529: INTO l_seq_no
6530: FROM DUAL;
6531:
6532: -- Get Contract Number from Original Contract
6533: OPEN orig_csr(p_from_chr_id);
6534: FETCH orig_csr INTO l_orig_contract_number, l_orig_sts_code;--:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |

Line 8635: FROM dual;

8631: i NUMBER;
8632:
8633: CURSOR l_trx_num_csr IS
8634: SELECT OKL_SIF_SEQ.NEXTVAL
8635: FROM dual;
8636:
8637: l_transaction_number NUMBER;
8638:
8639: CURSOR old_disb_adj_stm_csr(p_chr_id NUMBER,