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.

[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_SEEDED_FUNCTIONS_PVT

Line 1: PACKAGE BODY Okl_Seeded_Functions_Pvt AS

1: PACKAGE BODY Okl_Seeded_Functions_Pvt AS
2: /* $Header: OKLRSFFB.pls 120.141.12020000.9 2013/03/20 12:11:23 racheruv ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 1533: ln_addon_line_oec := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(

1529: p_dnz_chr_id => p_dnz_chr_id);
1530: FETCH c_addon_oec_calc INTO ln_addon_line_oec;
1531: CLOSE c_addon_oec_calc;
1532: */
1533: ln_addon_line_oec := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(
1534: p_contract_id => p_dnz_chr_id, p_contract_line_id => p_cle_id);
1535: -- DJANASWA change end 11/12/08
1536:
1537: ln_total_line_oec := NVL(ln_model_line_oec,0) + NVL(ln_addon_line_oec,0);

Line 7435: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value

7431: -- Start of Comments
7432: -- Created By: Punitharaj Devaraju (pdevaraj)
7433: -- Function Name: contract_net_investment
7434: -- Description: Get net investment for a contract.
7435: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value
7436: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents
7437: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income
7438: -- Parameters: contract id.
7439: -- Version: 1.0

Line 7436: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents

7432: -- Created By: Punitharaj Devaraju (pdevaraj)
7433: -- Function Name: contract_net_investment
7434: -- Description: Get net investment for a contract.
7435: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value
7436: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents
7437: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income
7438: -- Parameters: contract id.
7439: -- Version: 1.0
7440: -- End of Commnets

Line 7437: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income

7433: -- Function Name: contract_net_investment
7434: -- Description: Get net investment for a contract.
7435: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value
7436: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents
7437: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income
7438: -- Parameters: contract id.
7439: -- Version: 1.0
7440: -- End of Commnets
7441: -----------------------------------------------------------------------

Line 7461: l_residual := Okl_Seeded_Functions_Pvt.contract_residual_value(p_chr_id => p_chr_id, p_line_id => NULL);

7457:
7458: BEGIN
7459:
7460: -- Get Residual Value
7461: l_residual := Okl_Seeded_Functions_Pvt.contract_residual_value(p_chr_id => p_chr_id, p_line_id => NULL);
7462:
7463: -- Get Rent
7464: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);
7465:

Line 7464: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);

7460: -- Get Residual Value
7461: l_residual := Okl_Seeded_Functions_Pvt.contract_residual_value(p_chr_id => p_chr_id, p_line_id => NULL);
7462:
7463: -- Get Rent
7464: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);
7465:
7466: -- Get Rent
7467: l_income := Okl_Seeded_Functions_Pvt.contract_income(p_chr_id, NULL);
7468:

Line 7467: l_income := Okl_Seeded_Functions_Pvt.contract_income(p_chr_id, NULL);

7463: -- Get Rent
7464: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);
7465:
7466: -- Get Rent
7467: l_income := Okl_Seeded_Functions_Pvt.contract_income(p_chr_id, NULL);
7468:
7469: -- Calculate Net Investment
7470: l_net_investment := l_rent + l_residual - l_income;
7471:

Line 7588: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount

7584: -- Start of Comments
7585: -- Created By: Punitharaj Devaraju (pdevaraj)
7586: -- Function Name: contract_full_cure
7587: -- Description: Get full cure amount for a contract.
7588: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount
7589: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount
7590: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession
7591: -- Parameters: contract id.
7592: -- Version: 1.0

Line 7589: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount

7585: -- Created By: Punitharaj Devaraju (pdevaraj)
7586: -- Function Name: contract_full_cure
7587: -- Description: Get full cure amount for a contract.
7588: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount
7589: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount
7590: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession
7591: -- Parameters: contract id.
7592: -- Version: 1.0
7593: -- End of Commnets

Line 7590: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession

7586: -- Function Name: contract_full_cure
7587: -- Description: Get full cure amount for a contract.
7588: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount
7589: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount
7590: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession
7591: -- Parameters: contract id.
7592: -- Version: 1.0
7593: -- End of Commnets
7594: -----------------------------------------------------------------------

Line 7612: l_current_rent := Okl_Seeded_Functions_Pvt.contract_rent_amount(p_chr_id, NULL);

7608:
7609: BEGIN
7610:
7611: -- Get Current Rent
7612: l_current_rent := Okl_Seeded_Functions_Pvt.contract_rent_amount(p_chr_id, NULL);
7613:
7614: -- Get Cures in Possession
7615: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession
7616: (p_chr_id);

Line 7615: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession

7611: -- Get Current Rent
7612: l_current_rent := Okl_Seeded_Functions_Pvt.contract_rent_amount(p_chr_id, NULL);
7613:
7614: -- Get Cures in Possession
7615: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession
7616: (p_chr_id);
7617:
7618: l_outstanding_amount := Okl_Seeded_Functions_Pvt.contract_outstanding_amount
7619: ( p_chr_id

Line 7618: l_outstanding_amount := Okl_Seeded_Functions_Pvt.contract_outstanding_amount

7614: -- Get Cures in Possession
7615: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession
7616: (p_chr_id);
7617:
7618: l_outstanding_amount := Okl_Seeded_Functions_Pvt.contract_outstanding_amount
7619: ( p_chr_id
7620: ,NULL );
7621:
7622: l_full_cure := l_outstanding_amount -

Line 7674: l_net_investment := Okl_Seeded_Functions_Pvt.contract_net_investment

7670:
7671: BEGIN
7672:
7673: -- Get Net Investment
7674: l_net_investment := Okl_Seeded_Functions_Pvt.contract_net_investment
7675: (p_chr_id, NULL);
7676:
7677: -- Get Contract rate from rule
7678: l_return_status := okl_contract_info.get_rule_value

Line 13722: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_fee_line';

13718: l_date DATE;
13719: l_prin_bal_id NUMBER;
13720: l_balance NUMBER;
13721: l_return_status VARCHAR2(1);
13722: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_fee_line';
13723:
13724: CURSOR c_balance (p_sty_id NUMBER, p_date DATE) IS
13725: SELECT
13726: sel.amount

Line 13825: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_financed';

13821: AND cle.id = kle.id
13822: AND kle.fee_type = 'FINANCED';
13823:
13824: l_total_balance NUMBER := 0;
13825: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_financed';
13826:
13827: BEGIN
13828:
13829: FOR l_fin_fee IN c_fin_fees LOOP

Line 13873: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_rollover';

13869: AND cle.id = kle.id
13870: AND kle.fee_type = 'ROLLOVER';
13871:
13872: l_total_balance NUMBER := 0;
13873: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_rollover';
13874:
13875: BEGIN
13876:
13877: FOR l_fin_fee IN c_fin_fees LOOP

Line 15746: l_addon := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(

15742: p_dnz_chr_id => p_contract_id);
15743: FETCH c_addon INTO l_addon;
15744: CLOSE c_addon;
15745: */
15746: l_addon := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(
15747: p_contract_id => p_contract_id, p_contract_line_id => p_contract_line_id);
15748:
15749: -- DJANASWA change end 11/12/08
15750:

Line 16495: END Okl_Seeded_Functions_Pvt;

16491:
16492: END Total_Asset_Rollover_Fee_Amt;
16493:
16494:
16495: END Okl_Seeded_Functions_Pvt;