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_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.125.12010000.7 2009/01/12 23:24:25 apaul 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 1288: ln_addon_line_oec := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(

1284: p_dnz_chr_id => p_dnz_chr_id);
1285: FETCH c_addon_oec_calc INTO ln_addon_line_oec;
1286: CLOSE c_addon_oec_calc;
1287: */
1288: ln_addon_line_oec := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(
1289: p_contract_id => p_dnz_chr_id, p_contract_line_id => p_cle_id);
1290: -- DJANASWA change end 11/12/08
1291:
1292: ln_total_line_oec := NVL(ln_model_line_oec,0) + NVL(ln_addon_line_oec,0);

Line 6837: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value

6833: -- Start of Comments
6834: -- Created By: Punitharaj Devaraju (pdevaraj)
6835: -- Function Name: contract_net_investment
6836: -- Description: Get net investment for a contract.
6837: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value
6838: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents
6839: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income
6840: -- Parameters: contract id.
6841: -- Version: 1.0

Line 6838: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents

6834: -- Created By: Punitharaj Devaraju (pdevaraj)
6835: -- Function Name: contract_net_investment
6836: -- Description: Get net investment for a contract.
6837: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value
6838: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents
6839: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income
6840: -- Parameters: contract id.
6841: -- Version: 1.0
6842: -- End of Commnets

Line 6839: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income

6835: -- Function Name: contract_net_investment
6836: -- Description: Get net investment for a contract.
6837: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_residual_value
6838: -- OKL_SEEDED_FUNCTIONS_PVT.contract_sum_of_rents
6839: -- OKL_SEEDED_FUNCTIONS_PVT.contract_income
6840: -- Parameters: contract id.
6841: -- Version: 1.0
6842: -- End of Commnets
6843: -----------------------------------------------------------------------

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

6859:
6860: BEGIN
6861:
6862: -- Get Residual Value
6863: l_residual := Okl_Seeded_Functions_Pvt.contract_residual_value(p_chr_id => p_chr_id, p_line_id => NULL);
6864:
6865: -- Get Rent
6866: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);
6867:

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

6862: -- Get Residual Value
6863: l_residual := Okl_Seeded_Functions_Pvt.contract_residual_value(p_chr_id => p_chr_id, p_line_id => NULL);
6864:
6865: -- Get Rent
6866: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);
6867:
6868: -- Get Rent
6869: l_income := Okl_Seeded_Functions_Pvt.contract_income(p_chr_id, NULL);
6870:

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

6865: -- Get Rent
6866: l_rent := Okl_Seeded_Functions_Pvt.contract_sum_of_rents(p_chr_id, NULL);
6867:
6868: -- Get Rent
6869: l_income := Okl_Seeded_Functions_Pvt.contract_income(p_chr_id, NULL);
6870:
6871: -- Calculate Net Investment
6872: l_net_investment := l_rent + l_residual - l_income;
6873:

Line 6990: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount

6986: -- Start of Comments
6987: -- Created By: Punitharaj Devaraju (pdevaraj)
6988: -- Function Name: contract_full_cure
6989: -- Description: Get full cure amount for a contract.
6990: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount
6991: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount
6992: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession
6993: -- Parameters: contract id.
6994: -- Version: 1.0

Line 6991: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount

6987: -- Created By: Punitharaj Devaraju (pdevaraj)
6988: -- Function Name: contract_full_cure
6989: -- Description: Get full cure amount for a contract.
6990: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount
6991: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount
6992: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession
6993: -- Parameters: contract id.
6994: -- Version: 1.0
6995: -- End of Commnets

Line 6992: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession

6988: -- Function Name: contract_full_cure
6989: -- Description: Get full cure amount for a contract.
6990: -- Dependencies: OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount
6991: -- OKL_SEEDED_FUNCTIONS_PVT.contract_outstanding_amount
6992: -- OKL_SEEDED_FUNCTIONS_PVT.contract_cures_in_possession
6993: -- Parameters: contract id.
6994: -- Version: 1.0
6995: -- End of Commnets
6996: -----------------------------------------------------------------------

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

7010:
7011: BEGIN
7012:
7013: -- Get Current Rent
7014: l_current_rent := Okl_Seeded_Functions_Pvt.contract_rent_amount(p_chr_id, NULL);
7015:
7016: -- Get Cures in Possession
7017: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession
7018: (p_chr_id);

Line 7017: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession

7013: -- Get Current Rent
7014: l_current_rent := Okl_Seeded_Functions_Pvt.contract_rent_amount(p_chr_id, NULL);
7015:
7016: -- Get Cures in Possession
7017: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession
7018: (p_chr_id);
7019:
7020: l_outstanding_amount := Okl_Seeded_Functions_Pvt.contract_outstanding_amount
7021: ( p_chr_id

Line 7020: l_outstanding_amount := Okl_Seeded_Functions_Pvt.contract_outstanding_amount

7016: -- Get Cures in Possession
7017: l_cures_in_possession := Okl_Seeded_Functions_Pvt.contract_cures_in_possession
7018: (p_chr_id);
7019:
7020: l_outstanding_amount := Okl_Seeded_Functions_Pvt.contract_outstanding_amount
7021: ( p_chr_id
7022: ,NULL );
7023:
7024: l_full_cure := l_outstanding_amount -

Line 7076: l_net_investment := Okl_Seeded_Functions_Pvt.contract_net_investment

7072:
7073: BEGIN
7074:
7075: -- Get Net Investment
7076: l_net_investment := Okl_Seeded_Functions_Pvt.contract_net_investment
7077: (p_chr_id, NULL);
7078:
7079: -- Get Contract rate from rule
7080: l_return_status := okl_contract_info.get_rule_value

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

12486: l_date DATE;
12487: l_prin_bal_id NUMBER;
12488: l_balance NUMBER;
12489: l_return_status VARCHAR2(1);
12490: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_fee_line';
12491:
12492: CURSOR c_balance (p_sty_id NUMBER, p_date DATE) IS
12493: SELECT
12494: sel.amount

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

12589: AND cle.id = kle.id
12590: AND kle.fee_type = 'FINANCED';
12591:
12592: l_total_balance NUMBER := 0;
12593: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_financed';
12594:
12595: BEGIN
12596:
12597: FOR l_fin_fee IN c_fin_fees LOOP

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

12637: AND cle.id = kle.id
12638: AND kle.fee_type = 'ROLLOVER';
12639:
12640: l_total_balance NUMBER := 0;
12641: l_prog_name VARCHAR2(61) := 'OKL_SEEDED_FUNCTIONS_PVT.principal_balance_rollover';
12642:
12643: BEGIN
12644:
12645: FOR l_fin_fee IN c_fin_fees LOOP

Line 14514: l_addon := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(

14510: p_dnz_chr_id => p_contract_id);
14511: FETCH c_addon INTO l_addon;
14512: CLOSE c_addon;
14513: */
14514: l_addon := Okl_Seeded_Functions_Pvt.total_asset_addon_cost(
14515: p_contract_id => p_contract_id, p_contract_line_id => p_contract_line_id);
14516:
14517: -- DJANASWA change end 11/12/08
14518:

Line 15263: END Okl_Seeded_Functions_Pvt;

15259:
15260: END Total_Asset_Rollover_Fee_Amt;
15261:
15262:
15263: END Okl_Seeded_Functions_Pvt;