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 71: G_RESIDUAL_VALUE_INS_RGP CONSTANT VARCHAR2(10) := 'LARVIN';

67: G_QUOTE_COURTESY_COPY_RGP CONSTANT VARCHAR2(10) := 'AMQR9F';
68: G_QUOTE_RECEPIENT_RGP CONSTANT VARCHAR2(10) := 'AMQR1R';
69: G_RENEWAL_OPTIONS_RGP CONSTANT VARCHAR2(10) := 'LARNOP';
70: G_REPURCHASE_QTE_CALC_RGP CONSTANT VARCHAR2(10) := 'AMREPQ';
71: G_RESIDUAL_VALUE_INS_RGP CONSTANT VARCHAR2(10) := 'LARVIN';
72: G_SECURITY_DEPOSIT_RGP CONSTANT VARCHAR2(10) := 'LASDEP';
73: G_TAXES_AND_DUTIES_RGP CONSTANT VARCHAR2(10) := 'LAHDTX';
74: G_EARLY_TERM_QTE_CALC_RGP CONSTANT VARCHAR2(10) := 'AMTEWC';
75: G_END_OF_TERM_QTE_CALC_RGP CONSTANT VARCHAR2(10) := 'AMTFWC';

Line 790: 'INVESTOR_RESIDUAL_BUYBACK','INVESTOR_RESIDUAL_DISB_BASIS','INVESTOR_RESIDUAL_PAY',

786: 'INVESTOR_INTEREST_INCOME','INVESTOR_INTEREST_PAYABLE','INVESTOR_LATE_FEE_PAYABLE',
787: 'INVESTOR_LATE_INTEREST_PAY','INVESTOR_PAYABLE','INVESTOR_PRETAX_INCOME',
788: 'INVESTOR_PRINCIPAL_PAYABLE','INVESTOR_RECEIVABLE','INVESTOR_RENTAL_ACCRUAL',
789: 'INVESTOR_RENT_BUYBACK','INVESTOR_RENT_DISB_BASIS','INVESTOR_RENT_PAYABLE',
790: 'INVESTOR_RESIDUAL_BUYBACK','INVESTOR_RESIDUAL_DISB_BASIS','INVESTOR_RESIDUAL_PAY',
791: 'INVESTOR_VARIABLE_INTEREST','PV_RENT_SECURITIZED','PV_RV_SECURITIZED'))THEN
792:
793: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
794: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Ignore Investor Stream Line ID: '||deleted_streams_rec.orig_stm_id);

Line 5516: -- Sync 1. Adjust Residual Value

5512: ------------------------------------------------------------------------------
5513: -- PROCEDURE sync_line_values
5514: --
5515: -- This procedure synchronizes Rebook and Original Contract Line Values
5516: -- Sync 1. Adjust Residual Value
5517: -- 2. Adjust Cost
5518: --
5519: -- Calls:
5520: -- Called By:

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

5751: IF (rebook_line_rec.orig_system_id1 IS NOT NULL) THEN -- Old Line, Update
5752:
5753: l_clev_tbl(i).id := rebook_line_rec.orig_system_id1;
5754: l_klev_tbl(i).id := rebook_line_rec.orig_system_id1;
5755: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;
5756: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;
5757: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;
5758: l_klev_tbl(i).oec := rebook_line_rec.oec;
5759: l_klev_tbl(i).capital_amount := rebook_line_rec.capital_amount;

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

5752:
5753: l_clev_tbl(i).id := rebook_line_rec.orig_system_id1;
5754: l_klev_tbl(i).id := rebook_line_rec.orig_system_id1;
5755: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;
5756: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;
5757: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;
5758: l_klev_tbl(i).oec := rebook_line_rec.oec;
5759: l_klev_tbl(i).capital_amount := rebook_line_rec.capital_amount;
5760:

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

5753: l_clev_tbl(i).id := rebook_line_rec.orig_system_id1;
5754: l_klev_tbl(i).id := rebook_line_rec.orig_system_id1;
5755: l_klev_tbl(i).residual_percentage := rebook_line_rec.residual_percentage;
5756: l_klev_tbl(i).residual_value := rebook_line_rec.residual_value;
5757: l_klev_tbl(i).residual_grnty_amount := rebook_line_rec.residual_grnty_amount;
5758: l_klev_tbl(i).oec := rebook_line_rec.oec;
5759: l_klev_tbl(i).capital_amount := rebook_line_rec.capital_amount;
5760:
5761: -- sjalasut, added for rebook change control enhancement. START

Line 5770: l_klev_tbl(i).residual_code := rebook_line_rec.residual_code;

5766: l_klev_tbl(i).capital_reduction := rebook_line_rec.capital_reduction;
5767: l_klev_tbl(i).capital_reduction_percent := rebook_line_rec.capital_reduction_percent;
5768: l_klev_tbl(i).down_payment_receiver_code := rebook_line_rec.down_payment_receiver_code;
5769: l_klev_tbl(i).capitalize_down_payment_yn := rebook_line_rec.capitalize_down_payment_yn;
5770: l_klev_tbl(i).residual_code := rebook_line_rec.residual_code;
5771:
5772: l_klev_tbl(i).manufacturer_name := rebook_line_rec.manufacturer_name;
5773: l_klev_tbl(i).model_number := rebook_line_rec.model_number;
5774: l_klev_tbl(i).year_of_manufacture := rebook_line_rec.year_of_manufacture;

Line 6518: G_RENEWAL_OPTIONS_RGP, G_REPURCHASE_QTE_CALC_RGP, G_RESIDUAL_VALUE_INS_RGP,

6514: G_COND_PARTIAL_TERM_QTE_RGP,G_CONTRACT_PORTFOLIO_RGP, G_EARLY_TERM_PUR_OPT_RGP,
6515: G_END_OF_TERM_PUR_OPT_RGP, G_EVERGREEN_ELIG_RGP, G_FACTORING_RGP,
6516: G_GAIN_LOSS_TERM_QTE_RGP, G_LATE_CHARGES_RGP, G_LATE_INTEREST_RGP,
6517: G_QUOTE_APPROVER_RGP, G_QUOTE_COURTESY_COPY_RGP, G_QUOTE_RECEPIENT_RGP,
6518: G_RENEWAL_OPTIONS_RGP, G_REPURCHASE_QTE_CALC_RGP, G_RESIDUAL_VALUE_INS_RGP,
6519: G_SECURITY_DEPOSIT_RGP, G_TAXES_AND_DUTIES_RGP, G_EARLY_TERM_QTE_CALC_RGP,
6520: G_END_OF_TERM_QTE_CALC_RGP, G_TERM_QUOTE_PROCESS_RGP, G_REBOOK_LIMIT_DATE_RGP,
6521: G_NON_NOTIFICATION_RGP, G_PRIVATE_ACTIVITY_BOND_RGP);
6522:

Line 6681: G_RENEWAL_OPTIONS_RGP, G_REPURCHASE_QTE_CALC_RGP, G_RESIDUAL_VALUE_INS_RGP,

6677: G_COND_PARTIAL_TERM_QTE_RGP,G_CONTRACT_PORTFOLIO_RGP, G_EARLY_TERM_PUR_OPT_RGP,
6678: G_END_OF_TERM_PUR_OPT_RGP, G_EVERGREEN_ELIG_RGP, G_FACTORING_RGP,
6679: G_GAIN_LOSS_TERM_QTE_RGP, G_LATE_CHARGES_RGP, G_LATE_INTEREST_RGP,
6680: G_QUOTE_APPROVER_RGP, G_QUOTE_COURTESY_COPY_RGP, G_QUOTE_RECEPIENT_RGP,
6681: G_RENEWAL_OPTIONS_RGP, G_REPURCHASE_QTE_CALC_RGP, G_RESIDUAL_VALUE_INS_RGP,
6682: G_SECURITY_DEPOSIT_RGP, G_TAXES_AND_DUTIES_RGP, G_EARLY_TERM_QTE_CALC_RGP,
6683: G_END_OF_TERM_QTE_CALC_RGP, G_TERM_QUOTE_PROCESS_RGP, G_REBOOK_LIMIT_DATE_RGP,
6684: G_NON_NOTIFICATION_RGP, G_PRIVATE_ACTIVITY_BOND_RGP)
6685: AND NOT EXISTS (SELECT 1

Line 7116: -- 1. Adjust Residual Value

7112: RAISE OKC_API.G_EXCEPTION_ERROR;
7113: END IF;
7114:
7115: --
7116: -- 1. Adjust Residual Value
7117: -- 2. Adjust Cost
7118: --
7119: sync_line_values(
7120: x_return_status => x_return_status,

Line 8199: FROM DUAL;

8195: --**********************************************************
8196: -- Get Sequence Number to generate Contract Number
8197: SELECT okl_rbk_seq.NEXTVAL
8198: INTO l_seq_no
8199: FROM DUAL;
8200:
8201: -- Get Contract Number from Original Contract
8202: OPEN orig_csr(p_from_chr_id);
8203: FETCH orig_csr INTO l_orig_contract_number, l_orig_sts_code;--:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |

Line 10309: FROM dual;

10305: i NUMBER;
10306:
10307: CURSOR l_trx_num_csr IS
10308: SELECT OKL_SIF_SEQ.NEXTVAL
10309: FROM dual;
10310:
10311: l_transaction_number NUMBER;
10312:
10313: CURSOR old_disb_adj_stm_csr(p_chr_id NUMBER,