1 PACKAGE OKL_VARIABLE_INT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRVIUS.pls 120.2 2005/09/29 21:28:32 pjgomes noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7 TYPE invoice_info_rec_type IS RECORD (
8 remaining_amount NUMBER,
9 invoice_date DATE,
10 lsm_id NUMBER,
11 tld_id NUMBER,
12 receivables_invoice_id NUMBER);
13
14 TYPE invoice_info_tbl_type IS TABLE OF invoice_info_rec_type
15 INDEX BY BINARY_INTEGER;
16
17 ------------------------------------------------------------------------------
18 -- Global Variables
19 ------------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VARIABLE_INT_UTIL_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
23 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
26 G_INVALID_VALUE CONSTANT VARCHAR2(1000) := 'OKL_INVALID_VALUE';
27
28 ------------------------------------------------------------------------------
29 --Global Exception
30 ------------------------------------------------------------------------------
31 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32
33 --returns interest due for a date range
34 FUNCTION get_interest_due(
35 x_return_status OUT NOCOPY VARCHAR2,
36 p_khr_id IN NUMBER,
37 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
38
39 --returns interest billed for a date range
40 FUNCTION get_interest_billed(
41 x_return_status OUT NOCOPY VARCHAR2,
42 p_khr_id IN NUMBER,
43 p_from_date IN DATE,
44 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
45
46 --returns interest paid for a date range
47 FUNCTION get_interest_paid(
48 x_return_status OUT NOCOPY VARCHAR2,
49 p_khr_id IN NUMBER,
50 p_from_date IN DATE,
51 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
52
53 --returns principal balance on a contract for a loan as of a given date
54 FUNCTION get_principal_bal(
55 x_return_status OUT NOCOPY VARCHAR2,
56 p_khr_id IN NUMBER,
57 p_kle_id IN NUMBER,
58 p_date IN DATE) RETURN NUMBER;
59
60 --Returns an indicator Y/N if the interest rate has changed
61 FUNCTION get_interest_rate_change_flag(
62 x_return_status OUT NOCOPY VARCHAR2,
63 p_khr_id IN NUMBER) RETURN VARCHAR2;
64
65 --Returns effective interest rate as of a given date
66 FUNCTION get_effective_int_rate(
67 x_return_status OUT NOCOPY VARCHAR2,
68 p_khr_id IN NUMBER,
69 p_effective_date IN DATE) RETURN NUMBER;
70
71 --Returns Interest due but not billed as of a given date for a Loan
72 FUNCTION get_interest_due_unbilled(
73 x_return_status OUT NOCOPY VARCHAR2,
74 p_khr_id IN NUMBER,
75 p_effective_date IN DATE) RETURN NUMBER;
76
77 --Returns Principal Billed for a loan contract
78 FUNCTION get_principal_billed(
79 x_return_status OUT NOCOPY VARCHAR2,
80 p_khr_id IN NUMBER,
81 p_kle_id IN NUMBER,
82 p_from_date IN DATE,
83 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
84
85 --Returns principal paid for a loan contract for a date range
86 FUNCTION get_principal_paid(
87 x_return_status OUT NOCOPY VARCHAR2,
88 p_khr_id IN NUMBER,
89 p_kle_id IN NUMBER,
90 p_from_date IN DATE,
91 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
92
93 --Returns Float Factor Billing Amount for a float factor contract as of a given date
94 FUNCTION get_float_factor_billed(
95 x_return_status OUT NOCOPY VARCHAR2,
96 p_khr_id IN NUMBER,
97 p_effective_date IN DATE) RETURN NUMBER;
98
99 --Returns Loan Payment Billed for a loan contract with a revenue recognition method of Actual
100 FUNCTION get_loan_payment_billed(
101 x_return_status OUT NOCOPY VARCHAR2,
102 p_khr_id IN NUMBER,
103 p_effective_date IN DATE) RETURN NUMBER;
104
105 --Returns Loan Payment Received for a loan contract with a revenue recognition method of Actual
106 FUNCTION get_loan_payment_paid(
107 x_return_status OUT NOCOPY VARCHAR2,
108 p_khr_id IN NUMBER,
109 p_effective_date IN DATE) RETURN NUMBER;
110
111 --Returns Excess Loan Payment Received for a loan contract with a revenue recognition method of Actual
112 FUNCTION get_excess_loan_payment(
113 x_return_status OUT NOCOPY VARCHAR2,
114 p_khr_id IN NUMBER) RETURN NUMBER;
115
116 --Returns the date last interim interest calculated for variable rate contract
117 FUNCTION get_last_interim_int_calc_date(
118 x_return_status OUT NOCOPY VARCHAR2,
119 p_khr_id IN NUMBER) RETURN DATE;
120
121 --Returns the last scheduled interest calculation date prior to the Termination Date
122 FUNCTION get_last_sch_int_calc_date(
123 x_return_status OUT NOCOPY VARCHAR2,
124 p_khr_id IN NUMBER,
125 p_effective_date IN DATE) RETURN DATE;
126
127 --Returns invoice information table
128 PROCEDURE get_open_invoices(
129 x_return_status OUT NOCOPY VARCHAR2,
130 p_khr_id IN NUMBER,
131 x_invoice_tbl OUT NOCOPY invoice_info_tbl_type);
132
133
134 END OKL_VARIABLE_INT_UTIL_PVT;