[Home] [Help]
PACKAGE: APPS.FA_LEASE_SCHEDULE_PVT
Source
1 PACKAGE FA_LEASE_SCHEDULE_PVT AS
2 /* $Header: FAVLSCS.pls 120.2 2005/06/29 15:17:15 bridgway noship $ */
3 --
4 -- API name : FA_LEASE_SCHEDULE_PVT
5 -- Type : Public
6 -- Pre-reqs : None.
7 -- Function/Procedure : These Functions/Procedures will be used to support
8 -- public API's
9 --
10 ----------------------------------------------------
11 -- CHECK FOR PAYMENT SCHEDULE NAME
12 ----------------------------------------------------
13 FUNCTION CHECK_PAYMENT_SCHEDULE (
14 P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
15 p_log_level_rec in fa_api_types.log_level_rec_type default null
16 ) RETURN BOOLEAN;
17
18 ----------------------------------------------------
19 -- CHECK FOR CURRENCY CODE
20 ----------------------------------------------------
21 FUNCTION CHECK_CURRENCY_CODE(
22 P_CURRENCY_CODE IN FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE,
23 p_log_level_rec in fa_api_types.log_level_rec_type default null
24 ) RETURN BOOLEAN;
25
26 ----------------------------------------------------
27 -- CHECK FOR LEASE FREQUENCY
28 ----------------------------------------------------
29 FUNCTION CHECK_LEASE_FREQUENCY(
30 P_FREQUENCY IN FA_LEASE_SCHEDULES.FREQUENCY%TYPE,
31 p_log_level_rec in fa_api_types.log_level_rec_type default null
32 ) RETURN BOOLEAN;
33
34
35 ----------------------------------------------------
36 -- CHECK FOR START DATE
37 ----------------------------------------------------
38 FUNCTION CHECK_START_DATE (
39 P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
40 P_LEASE_INCEPTION_DATE IN DATE,
41 P_MONTHS_PER_PERIOD IN NUMBER,
42 p_log_level_rec in fa_api_types.log_level_rec_type default null
43 ) RETURN BOOLEAN;
44
45 ----------------------------------------------------
46 -- CHECK FOR PAYMENT AMOUNT
47 ----------------------------------------------------
48 FUNCTION CHECK_PAYMENT_AMOUNT(
49 P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
50 p_log_level_rec in fa_api_types.log_level_rec_type default null
51 ) RETURN BOOLEAN;
52
53 ----------------------------------------------------
54 -- CHECK FOR NUMBER OF PAYMENTS
55 ----------------------------------------------------
56 FUNCTION CHECK_NO_OF_PAYMENTS (
57 P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
58 p_log_level_rec in fa_api_types.log_level_rec_type default null
59 ) RETURN BOOLEAN;
60
61 ----------------------------------------------------
62 -- CHECK FOR LEASE PAYMENT TYPE
63 ----------------------------------------------------
64 FUNCTION CHECK_PERIODS (
65 P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
66 p_log_level_rec in fa_api_types.log_level_rec_type default null
67 ) RETURN BOOLEAN;
68
69 ----------------------------------------------------
70 -- CALCULATE END DATE
71 ----------------------------------------------------
72 FUNCTION CALC_END_DATE (
73 P_NUMBER_OF_PAYMENTS IN NUMBER,
74 P_MONTHS_PER_PERIOD IN NUMBER,
75 P_START_DATE IN DATE,
76 p_log_level_rec in fa_api_types.log_level_rec_type default null
77 ) RETURN DATE;
78
79 ----------------------------------------------------
80 -- VALIDATE SCHEDULE ID
81 ----------------------------------------------------
82 FUNCTION VALIDATE_SCHEDULE_ID (
83 P_PAYMENT_SCHEDULE_ID IN NUMBER,
84 X_MONTHS_PER_PERIOD OUT NOCOPY NUMBER,
85 X_CURRENCY_PRECISION OUT NOCOPY NUMBER,
86 X_PERIODS_PER_YEAR OUT NOCOPY NUMBER ,
87 p_log_level_rec in fa_api_types.log_level_rec_type default null
88 ) RETURN BOOLEAN;
89
90 ----------------------------------------------------
91 -- CALCULATE INTEREST
92 ----------------------------------------------------
93 FUNCTION CALCULATE_INTEREST (
94 P_PRINCIPAL IN NUMBER,
95 P_RATE_PER_PERIOD IN NUMBER,
96 P_NUM_PERIODS IN NUMBER,
97 p_log_level_rec in fa_api_types.log_level_rec_type default null
98 ) RETURN NUMBER;
99
100 ----------------------------------------------------
101 -- DO MINIMUM OF TWO NUMBERS
102 ----------------------------------------------------
103 FUNCTION AMINIMUM2(
104 P_X IN NUMBER,
105 P_Y IN NUMBER,
106 p_log_level_rec in fa_api_types.log_level_rec_type default null
107 ) RETURN NUMBER;
108
109 ----------------------------------------------------
110 -- DO MINIMUM OF THREE NUMBERS
111 ----------------------------------------------------
112 FUNCTION AMINIMUM3(
113 P_X IN NUMBER,
114 P_Y IN NUMBER,
115 P_Z IN NUMBER,
116 p_log_level_rec in fa_api_types.log_level_rec_type default null
117 ) RETURN NUMBER;
118
119 ----------------------------------------------------
120 -- DO LUMP SUM CALCULATIONS
121 ----------------------------------------------------
122 FUNCTION LUMP_SUM(
123 P_PAYMENT_AMOUNT IN NUMBER,
124 P_NUMBER_PAYMENTS IN NUMBER,
125 P_INTEREST_RATE IN NUMBER,
126 P_CURRENCY_PRECISION IN NUMBER ,
127 p_log_level_rec in fa_api_types.log_level_rec_type default null
128 ) RETURN NUMBER;
129
130 ----------------------------------------------------
131 -- DO ORDINARY ANNUITY CALCULATIONS
132 ----------------------------------------------------
133 FUNCTION ORDINARY_ANNUITY(
134 P_PAYMENT_AMOUNT IN NUMBER,
135 P_NUMBER_PAYMENTS IN NUMBER,
136 P_INTEREST_RATE IN NUMBER,
137 P_CURRENCY_PRECISION IN NUMBER ,
138 p_log_level_rec in fa_api_types.log_level_rec_type default null
139 ) RETURN NUMBER;
140
141 ----------------------------------------------------
142 -- DO ANNUITY DUE CALCULATIONS
143 ----------------------------------------------------
144 FUNCTION ANNUITY_DUE(
145 P_PAYMENT_AMOUNT IN NUMBER,
146 P_NUMBER_PAYMENTS IN NUMBER,
147 P_INTEREST_RATE IN NUMBER,
148 P_CURRENCY_PRECISION IN NUMBER ,
149 p_log_level_rec in fa_api_types.log_level_rec_type default null
150 ) RETURN NUMBER;
151
152 ----------------------------------------------------
153 -- DO PRESENT VALUE CALCULATIONS
154 ----------------------------------------------------
155 PROCEDURE PRESENT_VALUE_CALC(
156 P_PAYMENT_SCHEDULE_ID IN NUMBER,
157 P_MONTHS_PER_PERIOD IN NUMBER,
158 P_INTEREST_PER_PERIOD IN NUMBER,
159 P_CURRENCY_PRECISION IN NUMBER,
160 p_log_level_rec in fa_api_types.log_level_rec_type default null);
161
162 ----------------------------------------------------
163 -- VALIDATE PAYMENT DETAILS
164 ----------------------------------------------------
165 FUNCTION VALIDATE_PAYMENTS (
166 PX_LEASE_SCHEDULES_REC IN OUT NOCOPY FA_API_TYPES.LEASE_SCHEDULES_REC_TYPE,
167 P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
168 P_MONTHS_PER_PERIOD OUT NOCOPY NUMBER,
169 p_log_level_rec in fa_api_types.log_level_rec_type default null)
170 RETURN BOOLEAN;
171
172 ----------------------------------------------------
173 -- AMORTIZE CALCULATIONS
174 ----------------------------------------------------
175 FUNCTION AMORTIZE(
176 P_PAYMENT_SCHEDULE_ID IN NUMBER,
177 P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
178 p_log_level_rec in fa_api_types.log_level_rec_type default null)
179 RETURN BOOLEAN;
180 END FA_LEASE_SCHEDULE_PVT;