1 PACKAGE OKL_VARIABLE_INT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRVIUS.pls 120.4.12020000.3 2012/08/28 16:01:34 racheruv ship $ */
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 --Bug# 13447258
44 p_kle_id IN NUMBER DEFAULT NULL,
45 p_from_date IN DATE,
46 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
47
48 --returns interest paid for a date range
49 FUNCTION get_interest_paid(
50 x_return_status OUT NOCOPY VARCHAR2,
51 p_khr_id IN NUMBER,
52 --Bug# 13447258
53 p_kle_id IN NUMBER DEFAULT NULL,
54 p_from_date IN DATE,
55 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
56
57 --returns principal balance on a contract for a loan as of a given date
58 FUNCTION get_principal_bal(
59 x_return_status OUT NOCOPY VARCHAR2,
60 p_khr_id IN NUMBER,
61 p_kle_id IN NUMBER,
62 p_date IN DATE) RETURN NUMBER;
63
64 --Returns an indicator Y/N if the interest rate has changed
65 FUNCTION get_interest_rate_change_flag(
66 x_return_status OUT NOCOPY VARCHAR2,
67 p_khr_id IN NUMBER) RETURN VARCHAR2;
68
69 --Returns effective interest rate as of a given date
70 FUNCTION get_effective_int_rate(
71 x_return_status OUT NOCOPY VARCHAR2,
72 p_khr_id IN NUMBER,
73 p_effective_date IN DATE) RETURN NUMBER;
74
75 --Returns Interest due but not billed as of a given date for a Loan
76 FUNCTION get_interest_due_unbilled(
77 x_return_status OUT NOCOPY VARCHAR2,
78 p_khr_id IN NUMBER,
79 p_effective_date IN DATE) RETURN NUMBER;
80
81 --Returns Principal Billed for a loan contract
82 FUNCTION get_principal_billed(
83 x_return_status OUT NOCOPY VARCHAR2,
84 p_khr_id IN NUMBER,
85 p_kle_id IN NUMBER,
86 p_from_date IN DATE,
87 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
88
89 --Returns principal paid for a loan contract for a date range
90 FUNCTION get_principal_paid(
91 x_return_status OUT NOCOPY VARCHAR2,
92 p_khr_id IN NUMBER,
93 p_kle_id IN NUMBER,
94 p_from_date IN DATE,
95 p_to_date IN DATE DEFAULT SYSDATE) RETURN NUMBER;
96
97 --Returns Float Factor Billing Amount for a float factor contract as of a given date
98 FUNCTION get_float_factor_billed(
99 x_return_status OUT NOCOPY VARCHAR2,
100 p_khr_id IN NUMBER,
101 p_effective_date IN DATE) RETURN NUMBER;
102
103 --Returns Loan Payment Billed for a loan contract with a revenue recognition method of Actual
104 FUNCTION get_loan_payment_billed(
105 x_return_status OUT NOCOPY VARCHAR2,
106 p_khr_id IN NUMBER,
107 p_effective_date IN DATE) RETURN NUMBER;
108
109 --Returns Loan Payment Received for a loan contract with a revenue recognition method of Actual
110 FUNCTION get_loan_payment_paid(
111 x_return_status OUT NOCOPY VARCHAR2,
112 p_khr_id IN NUMBER,
113 p_effective_date IN DATE) RETURN NUMBER;
114
115 --Returns Excess Loan Payment Received for a loan contract with a revenue recognition method of Actual
116 FUNCTION get_excess_loan_payment(
117 x_return_status OUT NOCOPY VARCHAR2,
118 p_khr_id IN NUMBER) RETURN NUMBER;
119
120 --Returns the date last interim interest calculated for variable rate contract
121 FUNCTION get_last_interim_int_calc_date(
122 x_return_status OUT NOCOPY VARCHAR2,
123 p_khr_id IN NUMBER) RETURN DATE;
124
125 --Returns the last scheduled interest calculation date prior to the Termination Date
126 FUNCTION get_last_sch_int_calc_date(
127 x_return_status OUT NOCOPY VARCHAR2,
128 p_khr_id IN NUMBER,
129 p_effective_date IN DATE) RETURN DATE;
130
131 --Returns invoice information table
132 PROCEDURE get_open_invoices(
133 x_return_status OUT NOCOPY VARCHAR2,
134 p_khr_id IN NUMBER,
135 x_invoice_tbl OUT NOCOPY invoice_info_tbl_type);
136
137 --Added by bkatraga for bug 11924386
138 PROCEDURE check_principal_stream(
139 p_khr_id IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_prin_stream_flag OUT NOCOPY NUMBER);
142
143 --Bug# 13146882
144 PROCEDURE check_accounting_setups(
145 p_chr_id IN NUMBER,
146 p_transaction_type IN VARCHAR2,
147 p_transaction_date IN DATE,
148 x_return_status OUT NOCOPY VARCHAR2);
149
150 --Bug# 13447258
151 PROCEDURE check_vr_asset_level_upgrade(
152 p_khr_id IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2);
154
155
156 END OKL_VARIABLE_INT_UTIL_PVT;