[Home] [Help]
PACKAGE: APPS.LNS_TERMS_PUB
Source
1 PACKAGE LNS_TERMS_PUB AS
2 /*$Header: LNS_TERMS_PUBP_S.pls 120.5.12010000.5 2008/12/31 14:02:00 gparuchu 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 );
63 -------------------------------------------------------------------------
64
65 PROCEDURE create_term (
66 p_init_msg_list IN VARCHAR2,
67 p_loan_term_rec IN loan_term_rec_type,
68 x_term_id OUT NOCOPY NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE update_term (
75 p_init_msg_list IN VARCHAR2,
76 p_loan_term_rec IN loan_term_rec_type,
77 p_object_version_number IN OUT NOCOPY NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE validate_term (
84 p_init_msg_list IN VARCHAR2,
85 p_loan_term_rec IN loan_term_rec_type,
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 get_loan_term_rec (
92 p_init_msg_list IN VARCHAR2,
93 p_term_id IN NUMBER,
94 x_loan_term_rec OUT NOCOPY loan_term_rec_type,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE default_delinquency_amount (
101 p_term_id IN NUMBER,
102 p_loan_id IN NUMBER,
103 p_object_version_number IN OUT NOCOPY NUMBER,
104 x_return_status IN OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109 PROCEDURE validate_rate_schedule(p_loan_id IN NUMBER
110 ,x_return_status IN OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2);
113
114 END LNS_TERMS_PUB;