[Home] [Help]
PACKAGE: APPS.LNS_TERMS_PUB
Source
1 PACKAGE LNS_TERMS_PUB AUTHID CURRENT_USER AS
2 /*$Header: LNS_TERMS_PUBP_S.pls 120.15.12020000.2 2012/07/19 21:00:20 scherkas ship $ */
3
4 TYPE loan_term_rec_type IS RECORD(
5 TERM_ID NUMBER,
6 LOAN_ID NUMBER,
7 DAY_COUNT_METHOD VARCHAR2(50),
8 BASED_ON_BALANCE VARCHAR2(30),
9 FIRST_RATE_CHANGE_DATE DATE,
10 NEXT_RATE_CHANGE_DATE DATE,
11 PERCENT_INCREASE NUMBER,
12 PERCENT_INCREASE_TERM VARCHAR2(30),
13 PAYMENT_APPLICATION_ORDER VARCHAR2(30),
14 PREPAY_PENALTY_FLAG VARCHAR2(1),
15 PREPAY_PENALTY_DATE DATE,
16 CEILING_RATE NUMBER,
17 FLOOR_RATE NUMBER,
18 DELINQUENCY_THRESHOLD_NUMBER NUMBER,
19 DELINQUENCY_THRESHOLD_AMOUNT NUMBER,
20 CALCULATION_METHOD VARCHAR2(30),
21 REAMORTIZE_UNDER_PAYMENT VARCHAR2(1),
22 REAMORTIZE_OVER_PAYMENT VARCHAR2(1),
23 REAMORTIZE_WITH_INTEREST VARCHAR2(1),
24 LOAN_PAYMENT_FREQUENCY VARCHAR2(30),
25 INTEREST_COMPOUNDING_FREQ VARCHAR2(30),
26 AMORTIZATION_FREQUENCY VARCHAR2(30),
27 NUMBER_GRACE_DAYS NUMBER,
28 RATE_TYPE VARCHAR2(30),
29 INDEX_NAME VARCHAR2(50),
30 ADJUSTMENT_FREQUENCY NUMBER,
31 ADJUSTMENT_FREQUENCY_TYPE VARCHAR2(30),
32 FIXED_RATE_PERIOD NUMBER,
33 FIXED_RATE_PERIOD_TYPE VARCHAR2(30),
34 FIRST_PAYMENT_DATE DATE,
35 NEXT_PAYMENT_DUE_DATE DATE,
36 OPEN_FIRST_PAYMENT_DATE DATE,
37 OPEN_PAYMENT_FREQUENCY VARCHAR2(30),
38 OPEN_NEXT_PAYMENT_DATE DATE,
39 LOCK_IN_DATE DATE,
40 LOCK_TO_DATE DATE,
41 RATE_CHANGE_FREQUENCY VARCHAR2(30),
42 INDEX_RATE_ID NUMBER,
43 PERCENT_INCREASE_LIFE NUMBER,
44 FIRST_PERCENT_INCREASE NUMBER,
45 OPEN_PERCENT_INCREASE NUMBER,
46 OPEN_PERCENT_INCREASE_LIFE NUMBER,
47 OPEN_FIRST_PERCENT_INCREASE NUMBER,
48 PMT_APPL_ORDER_SCOPE VARCHAR2(30),
49 OPEN_CEILING_RATE NUMBER,
50 OPEN_FLOOR_RATE NUMBER,
51 OPEN_INDEX_DATE DATE,
52 TERM_INDEX_DATE DATE,
53 OPEN_PROJECTED_RATE NUMBER,
54 TERM_PROJECTED_RATE NUMBER,
55 PAYMENT_CALC_METHOD VARCHAR2(30),
56 CUSTOM_CALC_METHOD VARCHAR2(30),
57 ORIG_PAY_CALC_METHOD VARCHAR2(30),
58 PRIN_FIRST_PAY_DATE DATE,
59 PRIN_PAYMENT_FREQUENCY VARCHAR2(30),
60 PENAL_INT_RATE NUMBER,
61 PENAL_INT_GRACE_DAYS NUMBER,
62 CALC_ADD_INT_UNPAID_PRIN VARCHAR2(1),
63 CALC_ADD_INT_UNPAID_INT VARCHAR2(1),
64 REAMORTIZE_ON_FUNDING VARCHAR2(30),
65 DEFAULT_THRESHOLD_AMOUNT NUMBER,
66 CUSTOM_SCHED_DESC VARCHAR2(100),
67 CAPITALIZE_INT VARCHAR2(1),
68 CALC_EARLY_PAY_CR VARCHAR2(1),
69 FLUCTUATE_EQ_PAY_AMOUNT VARCHAR2(1)
70 );
71 -------------------------------------------------------------------------
72
73 PROCEDURE create_term (
74 p_init_msg_list IN VARCHAR2,
75 p_loan_term_rec IN loan_term_rec_type,
76 x_term_id OUT NOCOPY NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE update_term (
83 p_init_msg_list IN VARCHAR2,
84 p_loan_term_rec IN loan_term_rec_type,
85 p_object_version_number IN OUT NOCOPY NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE validate_term (
92 p_init_msg_list IN VARCHAR2,
93 p_loan_term_rec IN loan_term_rec_type,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE get_loan_term_rec (
100 p_init_msg_list IN VARCHAR2,
101 p_term_id IN NUMBER,
102 x_loan_term_rec OUT NOCOPY loan_term_rec_type,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE default_delinquency_amount (
109 p_term_id IN NUMBER,
110 p_loan_id IN NUMBER,
111 p_object_version_number IN OUT NOCOPY NUMBER,
112 x_return_status IN OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2
115 );
116
117 PROCEDURE validate_rate_schedule(p_loan_id IN NUMBER
118 ,x_return_status IN OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE calculate_delinquency_amount(p_loan_id IN NUMBER,
124 p_delinq_amt IN OUT NOCOPY NUMBER,
125 x_return_status IN OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE default_threshold_amount (
131 p_term_id IN NUMBER,
132 p_loan_id IN NUMBER,
133 p_object_version_number IN OUT NOCOPY NUMBER,
134 x_return_status IN OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139 PROCEDURE calculate_default_amount(
140 p_delinquent_threshold_amt IN NUMBER,
141 p_default_threshold_amt IN OUT NOCOPY NUMBER,
142 x_return_status IN OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2
145 );
146
147
148 END LNS_TERMS_PUB;