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_VARIABLE_INT_UTIL_PVT dependencies on OKL_VARIABLE_INT_UTIL_PVT

Line 1: PACKAGE BODY OKL_VARIABLE_INT_UTIL_PVT AS

1: PACKAGE BODY OKL_VARIABLE_INT_UTIL_PVT AS
2: /* $Header: OKLRVIUB.pls 120.31.12020000.4 2012/08/30 11:18:03 rpillay ship $ */
3: ------------------------------------------------------------------------------
4: -- Start of Comments
5: -- Created By: dkagrawa

Line 24: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_BILLED';

20: p_from_date IN DATE,
21: p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER IS
22:
23: l_debug_enabled VARCHAR2(1);
24: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_BILLED';
25: x_msg_count NUMBER;
26: x_msg_data VARCHAR2(2000);
27:
28: l_interest_billed NUMBER;

Line 113: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_PAID';

109: p_from_date IN DATE,
110: p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER IS
111:
112: l_debug_enabled VARCHAR2(1);
113: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_PAID';
114: x_msg_count NUMBER;
115: x_msg_data VARCHAR2(2000);
116:
117: l_interest_paid NUMBER;

Line 219: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_DUE';

215: l_api_version CONSTANT NUMBER := 1.0;
216: x_msg_count NUMBER;
217: x_msg_data VARCHAR2(2000);
218: l_debug_enabled VARCHAR2(1);
219: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_DUE';
220:
221: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
222: l_start_date DATE;
223: l_end_date DATE;

Line 468: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BAL';

464: l_api_version CONSTANT NUMBER := 1.0;
465: x_msg_count NUMBER;
466: x_msg_data VARCHAR2(2000);
467: l_debug_enabled VARCHAR2(1);
468: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BAL';
469:
470: l_start_date DATE;
471: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
472: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;

Line 701: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_PAID';

697: p_from_date IN DATE,
698: p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER IS
699:
700: l_debug_enabled VARCHAR2(1);
701: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_PAID';
702: x_msg_count NUMBER;
703: x_msg_data VARCHAR2(2000);
704:
705: l_principal_paid NUMBER;

Line 890: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_RATE_CHANGE_FLAG';

886: x_return_status OUT NOCOPY VARCHAR2,
887: p_khr_id IN NUMBER) RETURN VARCHAR2 IS
888:
889: l_debug_enabled VARCHAR2(1);
890: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_RATE_CHANGE_FLAG';
891: x_msg_count NUMBER;
892: x_msg_data VARCHAR2(2000);
893:
894: l_interest_rate_change_flag VARCHAR2(1);

Line 991: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EFFECTIVE_INT_RATE';

987: l_api_version CONSTANT NUMBER := 1.0;
988: x_msg_count NUMBER;
989: x_msg_data VARCHAR2(2000);
990: l_debug_enabled VARCHAR2(1);
991: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EFFECTIVE_INT_RATE';
992:
993: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
994: l_effective_int_rate NUMBER;
995: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;

Line 1089: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_DUE_UNBILLED';

1085: p_khr_id IN NUMBER,
1086: p_effective_date IN DATE) RETURN NUMBER IS
1087:
1088: l_debug_enabled VARCHAR2(1);
1089: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_DUE_UNBILLED';
1090: x_msg_count NUMBER;
1091: x_msg_data VARCHAR2(2000);
1092:
1093: l_interest_billed NUMBER;

Line 1191: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BILLED';

1187: p_from_date IN DATE,
1188: p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER IS
1189:
1190: l_debug_enabled VARCHAR2(1);
1191: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BILLED';
1192: x_msg_count NUMBER;
1193: x_msg_data VARCHAR2(2000);
1194:
1195: l_principal_billed NUMBER;

Line 1308: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_FLOAT_FACTOR_BILLED';

1304: p_khr_id IN NUMBER,
1305: p_effective_date IN DATE) RETURN NUMBER IS
1306:
1307: l_debug_enabled VARCHAR2(1);
1308: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_FLOAT_FACTOR_BILLED';
1309: x_msg_count NUMBER;
1310: x_msg_data VARCHAR2(2000);
1311:
1312: l_float_factor_billed NUMBER;

Line 1409: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LOAN_PAYMENT_BILLED';

1405: p_khr_id IN NUMBER,
1406: p_effective_date IN DATE) RETURN NUMBER IS
1407:
1408: l_debug_enabled VARCHAR2(1);
1409: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LOAN_PAYMENT_BILLED';
1410: x_msg_count NUMBER;
1411: x_msg_data VARCHAR2(2000);
1412:
1413: l_loan_payment_billed NUMBER;

Line 1511: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LOAN_PAYMENT_PAID';

1507: p_khr_id IN NUMBER,
1508: p_effective_date IN DATE) RETURN NUMBER IS
1509:
1510: l_debug_enabled VARCHAR2(1);
1511: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LOAN_PAYMENT_PAID';
1512: x_msg_count NUMBER;
1513: x_msg_data VARCHAR2(2000);
1514:
1515: l_loan_payment_paid NUMBER;

Line 1619: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EXCESS_LOAN_PAYMENT';

1615: x_return_status OUT NOCOPY VARCHAR2,
1616: p_khr_id IN NUMBER) RETURN NUMBER IS
1617:
1618: l_debug_enabled VARCHAR2(1);
1619: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EXCESS_LOAN_PAYMENT';
1620: x_msg_count NUMBER;
1621: x_msg_data VARCHAR2(2000);
1622:
1623: l_excess_loan_payment NUMBER;

Line 1694: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LAST_INTERIM_INT_CALC_DATE';

1690: x_return_status OUT NOCOPY VARCHAR2,
1691: p_khr_id IN NUMBER) RETURN DATE IS
1692:
1693: l_debug_enabled VARCHAR2(1);
1694: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LAST_INTERIM_INT_CALC_DATE';
1695: x_msg_count NUMBER;
1696: x_msg_data VARCHAR2(2000);
1697: l_last_interest_date DATE;
1698:

Line 1761: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LAST_SCH_INT_CALC_DATE';

1757: p_khr_id IN NUMBER,
1758: p_effective_date IN DATE) RETURN DATE IS
1759:
1760: l_debug_enabled VARCHAR2(1);
1761: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_LAST_SCH_INT_CALC_DATE';
1762: x_msg_count NUMBER;
1763: x_msg_data VARCHAR2(2000);
1764: x_no_data_found BOOLEAN;
1765: l_api_version CONSTANT NUMBER := 1.0;

Line 2110: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_OPEN_INVOICES';

2106: p_khr_id IN NUMBER,
2107: x_invoice_tbl OUT NOCOPY invoice_info_tbl_type) IS
2108:
2109: l_debug_enabled VARCHAR2(1);
2110: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_OPEN_INVOICES';
2111: x_msg_count NUMBER;
2112: x_msg_data VARCHAR2(2000);
2113:
2114: --Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007

Line 2566: END OKL_VARIABLE_INT_UTIL_PVT;

2562: --Bug# 13447258
2563:
2564: ------------------------------------------------------------------------------
2565:
2566: END OKL_VARIABLE_INT_UTIL_PVT;