[Home] [Help]
PACKAGE: APPS.FA_LEASE_PVT
Source
1 PACKAGE FA_LEASE_PVT AS
2 /* $Header: FAVLEAS.pls 120.2 2005/06/29 15:17:04 bridgway noship $ */
3 --
4 -- API name : FA_LEASE_PVT
5 -- Type : Private
6 -- Pre-reqs : None.
7 -- Function : To validate Create Lease and Update Lease API parameters.
8 --
9
10 --------------------------------
11 -- CHECK FOR LESSOR_ID
12 --------------------------------
13 FUNCTION CHECK_LESSOR_ID (
14 P_VENDOR_ID IN PO_VENDORS.VENDOR_ID%TYPE,
15 p_log_level_rec in fa_api_types.log_level_rec_type default null
16 ) RETURN BOOLEAN;
17
18 --------------------------------
19 -- CHECK FOR LESSOR_NAME
20 --------------------------------
21 FUNCTION CHECK_LESSOR_NAME (
22 P_VENDOR_NAME IN PO_VENDORS.VENDOR_NAME%TYPE,
23 X_VENDOR_ID OUT NOCOPY PO_VENDORS.VENDOR_ID%TYPE,
24 p_log_level_rec in fa_api_types.log_level_rec_type default null
25 ) RETURN BOOLEAN;
26 ----------------------------------
27 -- CHECK FOR PAYMENT SCHEDULE ID
28 ----------------------------------
29 FUNCTION CHECK_PAYMENT_SCHEDULE_ID (
30 P_PAYMENT_SCHEDULE_ID IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,
31 p_log_level_rec in fa_api_types.log_level_rec_type default null
32 ) RETURN BOOLEAN;
33
34 ------------------------------------
35 -- CHECK FOR PAYMENT SCHEDULE NAME
36 ------------------------------------
37 FUNCTION CHECK_PAYMENT_SCHEDULE_NAME (
38 P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
39 X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,
40 p_log_level_rec in fa_api_types.log_level_rec_type default null
41 ) RETURN BOOLEAN;
42
43 --------------------------------
44 -- CHECK FOR PAYMENT TERMS ID
45 --------------------------------
46 FUNCTION CHECK_TERMS_ID (
47 P_TERMS_ID IN AP_TERMS.TERM_ID%TYPE,
48 p_log_level_rec in fa_api_types.log_level_rec_type default null
49 ) RETURN BOOLEAN;
50
51 --------------------------------
52 -- CHECK FOR PAYMENT TERMS
53 --------------------------------
54 FUNCTION CHECK_PAYMENT_TERMS (
55 P_PAYMENT_TERMS IN AP_TERMS.NAME%TYPE,
56 X_TERMS_ID OUT NOCOPY AP_TERMS.TERM_ID%TYPE,
57 p_log_level_rec in fa_api_types.log_level_rec_type default null
58 ) RETURN BOOLEAN;
59
60 --------------------------------
61 -- CHECK FOR LESSOR SITE ID
62 --------------------------------
63 FUNCTION CHECK_LESSOR_SITE_ID (
64 P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
65 P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
66 X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
67 X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER,
68 p_log_level_rec in fa_api_types.log_level_rec_type default null
69 ) RETURN BOOLEAN;
70
71 --------------------------------
72 -- CHECK FOR LESSOR SITE CODE
73 --------------------------------
74 FUNCTION CHECK_LESSOR_SITE_CODE (
75 P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
76 P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
77 P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
78 X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
79 X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
80 p_log_level_rec in fa_api_types.log_level_rec_type default null
81 ) RETURN BOOLEAN;
82
83 ------------------------------------
84 -- CHECK FOR CODE COMBINATION ID
85 ------------------------------------
86 FUNCTION CHECK_DIST_CODE_COMBINATION_ID(
87 P_DIST_CODE_COMBINATION_ID IN GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE,
88 P_COA_ID IN GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID%TYPE,
89 p_log_level_rec in fa_api_types.log_level_rec_type default null
90 ) RETURN BOOLEAN;
91
92 --------------------------------------------------------------------------------
93 -- CHECK FOR CODE COMBINATION, IF DYNAMIC INSERT IS ON IF NOT FOUND INSERT ONE
94 --------------------------------------------------------------------------------
95 FUNCTION CHECK_CODE_COMBINATION (
96 P_CON_CODE_COMBINATION IN VARCHAR2,
97 P_COA_ID IN GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID%TYPE,
98 X_CODE_COMBINATION_ID OUT NOCOPY GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE,
99 p_log_level_rec in fa_api_types.log_level_rec_type default null
100
101 ) RETURN BOOLEAN;
102
103 -------------------------------------------------
104 -- CHECK FOR LEASE NUMBER AND LESSOR COMBINATION
105 -------------------------------------------------
106 FUNCTION CHECK_LEASE_LESSOR_COMBINATION (
107 P_LESSOR_ID IN NUMBER,
108 P_LEASE_NUMBER IN VARCHAR2,
109 p_log_level_rec in fa_api_types.log_level_rec_type default null
110 ) RETURN BOOLEAN;
111
112 --------------------------------
113 -- CHECK FOR CURRENCY CODE
114 --------------------------------
115 FUNCTION CHECK_CURRENCY_CODE (
116 P_CURRENCY_CODE IN VARCHAR2,
117 P_PAYMENT_SCHEDULE_ID IN NUMBER,
118 p_log_level_rec in fa_api_types.log_level_rec_type default null
119 ) RETURN BOOLEAN;
120
121 --------------------------------
122 -- CHECK FOR LEASE TYPE
123 --------------------------------
124 FUNCTION CHECK_LEASE_TYPE(
125 P_LEASE_TYPE IN VARCHAR2,
126 p_log_level_rec in fa_api_types.log_level_rec_type default null
127 ) RETURN BOOLEAN;
128
129 ------------------------------------
130 --VALIDATE LESSOTR THAT IT EXISTS
131 ------------------------------------
132 FUNCTION VALIDATE_LESSOR
133 (P_VENDOR_ID IN NUMBER,
134 P_VENDOR_NAME IN VARCHAR2,
135 X_VENDOR_ID OUT NOCOPY NUMBER,
136 p_log_level_rec in fa_api_types.log_level_rec_type default null
137 ) RETURN BOOLEAN;
138
139 --------------------------------
140 -- GET LEASE_ID
141 --------------------------------
142 FUNCTION GET_LEASE_ID
143 (P_LESSOR_ID IN NUMBER,
144 P_LEASE_NUMBER IN VARCHAR2,
145 X_LEASE_ID OUT NOCOPY NUMBER,
146 p_log_level_rec in fa_api_types.log_level_rec_type default null
147 ) RETURN BOOLEAN;
148
149 --------------------------------
150 -- VALIDATE LEASE_ID
151 --------------------------------
152 FUNCTION VALIDATE_LEASE_ID
153 (P_LEASE_ID IN NUMBER,
154 p_log_level_rec in fa_api_types.log_level_rec_type default null
155 ) RETURN BOOLEAN;
156
157 -------------------------------------------------------------------------------
158 -- CHECK IF LEASE INFORMATION CAN BE UPDATED AND NOT ASSOCIATED WITH ANY ASSET
159 -------------------------------------------------------------------------------
160 FUNCTION CHECK_LEASE_UPDATE
161 (P_LEASE_ID IN NUMBER,
162 p_log_level_rec in fa_api_types.log_level_rec_type default null)
163 RETURN VARCHAR2;
164
165 --------------------------------------------------
166 -- CHECK IF LEASE, LESSOR COMBINATION
167 --------------------------------------------------
168 FUNCTION VALIDATE_LEASE_LESSOR
169 (P_LEASE_ID IN NUMBER,
170 P_LESSOR_ID IN NUMBER,
171 P_LESSOR_SITE_ID IN NUMBER,
172 P_LESSOR_SITE_ORG_ID IN NUMBER,
173 p_log_level_rec in fa_api_types.log_level_rec_type default null
174 ) RETURN BOOLEAN;
175
176 -------------------------------------------
177 -- VALIDATE CREATE LEASE PARAMETERS
178 -------------------------------------------
179 FUNCTION VALIDATION_CREATE_LEASE (
180 PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
181 p_log_level_rec in fa_api_types.log_level_rec_type default null
182 ) RETURN BOOLEAN;
183
184 --------------------------------------------
185 -- VALIDATE UPDATE LEASE PARAMETERS
186 ---------------------------------------------
187 FUNCTION VALIDATION_UPDATE_LEASE (
188 PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
189 X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2,
190 p_log_level_rec in fa_api_types.log_level_rec_type default null
191 ) RETURN BOOLEAN;
192
193 --------------------------------------------
194 -- UPDATE LEASE DATA
195 ---------------------------------------------
196
197 PROCEDURE UPDATE_ROW(
198 X_ROWID IN VARCHAR2 DEFAULT NULL,
199 X_LEASE_ID IN NUMBER,
200 X_LESSOR_ID IN NUMBER,
201 X_LESSOR_SITE_ID IN NUMBER,
202 X_DESCRIPTION IN VARCHAR2,
203 X_LAST_UPDATE_DATE IN DATE,
204 X_LAST_UPDATED_BY IN NUMBER,
205 X_ATTRIBUTE1 IN VARCHAR2,
206 X_ATTRIBUTE2 IN VARCHAR2,
207 X_ATTRIBUTE3 IN VARCHAR2,
208 X_ATTRIBUTE4 IN VARCHAR2,
209 X_ATTRIBUTE5 IN VARCHAR2,
210 X_ATTRIBUTE6 IN VARCHAR2,
211 X_ATTRIBUTE7 IN VARCHAR2,
212 X_ATTRIBUTE8 IN VARCHAR2,
213 X_ATTRIBUTE9 IN VARCHAR2,
214 X_ATTRIBUTE10 IN VARCHAR2,
215 X_ATTRIBUTE11 IN VARCHAR2,
216 X_ATTRIBUTE12 IN VARCHAR2,
217 X_ATTRIBUTE13 IN VARCHAR2,
218 X_ATTRIBUTE14 IN VARCHAR2,
219 X_ATTRIBUTE15 IN VARCHAR2,
220 X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2,
221 p_log_level_rec in fa_api_types.log_level_rec_type default null);
222
223 END FA_LEASE_PVT;