[Home] [Help]
PACKAGE: APPS.FA_LEASE_PVT
Source
1 PACKAGE FA_LEASE_PVT AUTHID CURRENT_USER AS
2 /* $Header: FAVLEAS.pls 120.4 2009/05/08 21:15:26 glchen ship $ */
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 ) RETURN BOOLEAN;
101
102 -------------------------------------------------
103 -- CHECK FOR LEASE NUMBER AND LESSOR COMBINATION
104 -------------------------------------------------
105 FUNCTION CHECK_LEASE_LESSOR_COMBINATION (
106 P_LESSOR_ID IN NUMBER,
107 P_LEASE_NUMBER IN VARCHAR2
108 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
109
110 --------------------------------
111 -- CHECK FOR CURRENCY CODE
112 --------------------------------
113 FUNCTION CHECK_CURRENCY_CODE (
114 P_CURRENCY_CODE IN VARCHAR2,
115 P_PAYMENT_SCHEDULE_ID IN NUMBER
116 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
117
118 --------------------------------
119 -- CHECK FOR LEASE TYPE
120 --------------------------------
121 FUNCTION CHECK_LEASE_TYPE(
122 P_LEASE_TYPE IN VARCHAR2
123 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
124
125 ------------------------------------
126 --VALIDATE LESSOTR THAT IT EXISTS
127 ------------------------------------
128 FUNCTION VALIDATE_LESSOR
129 (P_VENDOR_ID IN NUMBER,
130 P_VENDOR_NAME IN VARCHAR2,
131 X_VENDOR_ID OUT NOCOPY NUMBER
132 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
133
134 --------------------------------
135 -- GET LEASE_ID
136 --------------------------------
137 FUNCTION GET_LEASE_ID
138 (P_LESSOR_ID IN NUMBER,
139 P_LEASE_NUMBER IN VARCHAR2,
140 X_LEASE_ID OUT NOCOPY NUMBER
141 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
142
143 --------------------------------
144 -- VALIDATE LEASE_ID
145 --------------------------------
146 FUNCTION VALIDATE_LEASE_ID
147 (P_LEASE_ID IN NUMBER
148 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
149
150 -------------------------------------------------------------------------------
151 -- CHECK IF LEASE INFORMATION CAN BE UPDATED AND NOT ASSOCIATED WITH ANY ASSET
152 -------------------------------------------------------------------------------
153 FUNCTION CHECK_LEASE_UPDATE
154 (P_LEASE_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
155 RETURN VARCHAR2;
156
157 --------------------------------------------------
158 -- CHECK IF LEASE, LESSOR COMBINATION
159 --------------------------------------------------
160 FUNCTION VALIDATE_LEASE_LESSOR
161 (P_LEASE_ID IN NUMBER,
162 P_LESSOR_ID IN NUMBER,
163 P_LESSOR_SITE_ID IN NUMBER,
164 P_LESSOR_SITE_ORG_ID IN NUMBER
165 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
166
167 -------------------------------------------
168 -- VALIDATE CREATE LEASE PARAMETERS
169 -------------------------------------------
170 FUNCTION VALIDATION_CREATE_LEASE (
171 PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE
172 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
173
174 --------------------------------------------
175 -- VALIDATE UPDATE LEASE PARAMETERS
176 ---------------------------------------------
177 FUNCTION VALIDATION_UPDATE_LEASE (
178 PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
179 X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2
180 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
181
182 --------------------------------------------
183 -- UPDATE LEASE DATA
184 ---------------------------------------------
185
186 PROCEDURE UPDATE_ROW(
187 X_ROWID IN VARCHAR2 DEFAULT NULL,
188 X_LEASE_ID IN NUMBER,
189 X_LESSOR_ID IN NUMBER,
190 X_LESSOR_SITE_ID IN NUMBER,
191 X_DESCRIPTION IN VARCHAR2,
192 X_LAST_UPDATE_DATE IN DATE,
193 X_LAST_UPDATED_BY IN NUMBER,
194 X_ATTRIBUTE1 IN VARCHAR2,
195 X_ATTRIBUTE2 IN VARCHAR2,
196 X_ATTRIBUTE3 IN VARCHAR2,
197 X_ATTRIBUTE4 IN VARCHAR2,
198 X_ATTRIBUTE5 IN VARCHAR2,
199 X_ATTRIBUTE6 IN VARCHAR2,
200 X_ATTRIBUTE7 IN VARCHAR2,
201 X_ATTRIBUTE8 IN VARCHAR2,
202 X_ATTRIBUTE9 IN VARCHAR2,
203 X_ATTRIBUTE10 IN VARCHAR2,
204 X_ATTRIBUTE11 IN VARCHAR2,
205 X_ATTRIBUTE12 IN VARCHAR2,
206 X_ATTRIBUTE13 IN VARCHAR2,
207 X_ATTRIBUTE14 IN VARCHAR2,
208 X_ATTRIBUTE15 IN VARCHAR2,
209 X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
210
211 END FA_LEASE_PVT;