[Home] [Help]
PACKAGE: APPS.OKL_FXL_PVT
Source
1 PACKAGE OKL_FXL_PVT AS
2 /* $Header: OKLSFXLS.pls 120.3 2007/12/21 12:58:43 rajnisku noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_EXT_FA_LINE_SOURCES_V Record Spec
7 TYPE fxlv_rec_type IS RECORD (
8 line_extension_id NUMBER
9 ,header_extension_id NUMBER
10 ,source_id NUMBER
11 ,source_table OKL_EXT_FA_LINE_SOURCES_V.SOURCE_TABLE%TYPE
12 ,object_version_number NUMBER
13 ,fa_transaction_id NUMBER
14 ,asset_id NUMBER
15 ,kle_id NUMBER
16 ,asset_number OKL_EXT_FA_LINE_SOURCES_V.ASSET_NUMBER%TYPE
17 ,contract_line_number OKL_EXT_FA_LINE_SOURCES_V.CONTRACT_LINE_NUMBER%TYPE
18 ,asset_book_type_name OKL_EXT_FA_LINE_SOURCES_V.ASSET_BOOK_TYPE_NAME%TYPE
19 ,asset_vendor_name OKL_EXT_FA_LINE_SOURCES_V.ASSET_VENDOR_NAME%TYPE
20 ,installed_site_id NUMBER
21 ,line_attribute_category OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE_CATEGORY%TYPE
22 ,line_attribute1 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE1%TYPE
23 ,line_attribute2 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE2%TYPE
24 ,line_attribute3 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE3%TYPE
25 ,line_attribute4 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE4%TYPE
26 ,line_attribute5 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE5%TYPE
27 ,line_attribute6 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE6%TYPE
28 ,line_attribute7 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE7%TYPE
29 ,line_attribute8 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE8%TYPE
30 ,line_attribute9 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE9%TYPE
31 ,line_attribute10 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE10%TYPE
32 ,line_attribute11 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE11%TYPE
33 ,line_attribute12 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE12%TYPE
34 ,line_attribute13 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE13%TYPE
35 ,line_attribute14 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE14%TYPE
36 ,line_attribute15 OKL_EXT_FA_LINE_SOURCES_V.LINE_ATTRIBUTE15%TYPE
37 ,language OKL_EXT_FA_LINE_SOURCES_V.LANGUAGE%TYPE
38 ,inventory_org_name OKL_EXT_FA_LINE_SOURCES_V.INVENTORY_ORG_NAME%TYPE
39 ,trans_line_description OKL_EXT_FA_LINE_SOURCES_V.TRANS_LINE_DESCRIPTION%TYPE
40 ,created_by NUMBER
41 ,creation_date OKL_EXT_FA_LINE_SOURCES_V.CREATION_DATE%TYPE
42 ,last_updated_by NUMBER
43 ,last_update_date OKL_EXT_FA_LINE_SOURCES_V.LAST_UPDATE_DATE%TYPE
44 ,last_update_login NUMBER
45 ,inventory_org_code OKL_EXT_FA_LINE_SOURCES_V.INVENTORY_ORG_CODE%TYPE
46 ,asset_book_type_code OKL_EXT_FA_LINE_SOURCES_V.asset_book_type_code%TYPE
47 ,period_counter NUMBER
48 ,asset_vendor_id OKL_EXT_FA_LINE_SOURCES_V.ASSET_VENDOR_ID%TYPE
49 );
50
51 G_MISS_fxlv_rec fxlv_rec_type;
52 TYPE fxlv_tbl_type IS TABLE OF fxlv_rec_type
53 INDEX BY BINARY_INTEGER;
54 -- OKL_EXT_FA_LINE_SOURCES_B Record Spec
55 TYPE fxl_rec_type IS RECORD (
56 line_extension_id NUMBER
57 ,header_extension_id NUMBER
58 ,source_id NUMBER
59 ,source_table OKL_EXT_FA_LINE_SOURCES_B.SOURCE_TABLE%TYPE
60 ,object_version_number NUMBER
61 ,fa_transaction_id NUMBER
62 ,asset_id NUMBER
63 ,kle_id NUMBER
64 ,asset_number OKL_EXT_FA_LINE_SOURCES_B.ASSET_NUMBER%TYPE
65 ,contract_line_number OKL_EXT_FA_LINE_SOURCES_B.CONTRACT_LINE_NUMBER%TYPE
66 ,asset_book_type_name OKL_EXT_FA_LINE_SOURCES_B.ASSET_BOOK_TYPE_NAME%TYPE
67 ,asset_vendor_name OKL_EXT_FA_LINE_SOURCES_B.ASSET_VENDOR_NAME%TYPE
68 ,installed_site_id NUMBER
69 ,line_attribute_category OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE_CATEGORY%TYPE
70 ,line_attribute1 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE1%TYPE
71 ,line_attribute2 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE2%TYPE
72 ,line_attribute3 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE3%TYPE
73 ,line_attribute4 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE4%TYPE
74 ,line_attribute5 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE5%TYPE
75 ,line_attribute6 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE6%TYPE
76 ,line_attribute7 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE7%TYPE
77 ,line_attribute8 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE8%TYPE
78 ,line_attribute9 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE9%TYPE
79 ,line_attribute10 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE10%TYPE
80 ,line_attribute11 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE11%TYPE
81 ,line_attribute12 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE12%TYPE
82 ,line_attribute13 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE13%TYPE
83 ,line_attribute14 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE14%TYPE
84 ,line_attribute15 OKL_EXT_FA_LINE_SOURCES_B.LINE_ATTRIBUTE15%TYPE
85 ,created_by NUMBER
86 ,creation_date OKL_EXT_FA_LINE_SOURCES_B.CREATION_DATE%TYPE
87 ,last_updated_by NUMBER
88 ,last_update_date OKL_EXT_FA_LINE_SOURCES_B.LAST_UPDATE_DATE%TYPE
89 ,last_update_login NUMBER
90 ,inventory_org_code OKL_EXT_FA_LINE_SOURCES_B.INVENTORY_ORG_CODE%TYPE
91 ,asset_book_type_code OKL_EXT_FA_LINE_SOURCES_B.asset_book_type_code%TYPE
92 ,period_counter NUMBER
93 ,asset_vendor_id OKL_EXT_FA_LINE_SOURCES_B.ASSET_VENDOR_ID%TYPE);
94 G_MISS_fxl_rec fxl_rec_type;
95 TYPE fxl_tbl_type IS TABLE OF fxl_rec_type
96 INDEX BY BINARY_INTEGER;
97 -- OKL_EXT_FA_LINE_SOURCES_TL Record Spec
98 TYPE fxll_rec_type IS RECORD (
99 line_extension_id NUMBER
100 ,language OKL_EXT_FA_LINE_SOURCES_TL.LANGUAGE%TYPE
101 ,source_lang OKL_EXT_FA_LINE_SOURCES_TL.SOURCE_LANG%TYPE
102 ,sfwt_flag OKL_EXT_FA_LINE_SOURCES_TL.SFWT_FLAG%TYPE
103 ,inventory_org_name OKL_EXT_FA_LINE_SOURCES_TL.INVENTORY_ORG_NAME%TYPE
104 ,trans_line_description OKL_EXT_FA_LINE_SOURCES_TL.TRANS_LINE_DESCRIPTION%TYPE
105 ,created_by NUMBER
106 ,creation_date OKL_EXT_FA_LINE_SOURCES_TL.CREATION_DATE%TYPE
107 ,last_updated_by NUMBER
108 ,last_update_date OKL_EXT_FA_LINE_SOURCES_TL.LAST_UPDATE_DATE%TYPE
109 ,last_update_login NUMBER);
110 G_MISS_fxll_rec fxll_rec_type;
111 TYPE fxll_tbl_type IS TABLE OF fxll_rec_type
112 INDEX BY BINARY_INTEGER;
113 -- Start : PRASJAIN : Bug# 6268782
114 TYPE fxl_tbl_rec_type IS RECORD(
115 fxl_rec okl_fxl_pvt.fxl_rec_type
116 ,fxll_tbl okl_fxl_pvt.fxll_tbl_type
117 );
118 TYPE fxl_tbl_tbl_type IS TABLE OF fxl_tbl_rec_type
119 INDEX BY BINARY_INTEGER;
120 -- End : PRASJAIN : Bug# 6268782
121 ---------------------------------------------------------------------------
122 -- GLOBAL MESSAGE CONSTANTS
123 ---------------------------------------------------------------------------
124 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
125 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
126 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
127 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
128 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
129 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
130 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
131 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
132 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
133 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
134 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
135 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
136 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
137
138 ---------------------------------------------------------------------------
139 -- GLOBAL EXCEPTIONS
140 ---------------------------------------------------------------------------
141 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
142
143 ---------------------------------------------------------------------------
144 -- GLOBAL VARIABLES
145 ---------------------------------------------------------------------------
146 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FXL_PVT';
147 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
148 ---------------------------------------------------------------------------
149 -- Procedures and Functions
150 ---------------------------------------------------------------------------
151
152 PROCEDURE qc;
153 PROCEDURE change_version;
154 PROCEDURE api_copy;
155 PROCEDURE add_language;
156 PROCEDURE insert_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_fxlv_rec IN fxlv_rec_type,
163 x_fxlv_rec OUT NOCOPY fxlv_rec_type);
164 PROCEDURE insert_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_fxlv_tbl IN fxlv_tbl_type,
171 x_fxlv_tbl OUT NOCOPY fxlv_tbl_type,
172 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
173 PROCEDURE insert_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_fxlv_tbl IN fxlv_tbl_type,
180 x_fxlv_tbl OUT NOCOPY fxlv_tbl_type);
181 PROCEDURE lock_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_fxlv_rec IN fxlv_rec_type);
188 PROCEDURE lock_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_fxlv_tbl IN fxlv_tbl_type,
195 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
196 PROCEDURE lock_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_fxlv_tbl IN fxlv_tbl_type);
203 PROCEDURE update_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_fxlv_rec IN fxlv_rec_type,
210 x_fxlv_rec OUT NOCOPY fxlv_rec_type);
211 PROCEDURE update_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_fxlv_tbl IN fxlv_tbl_type,
218 x_fxlv_tbl OUT NOCOPY fxlv_tbl_type,
219 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
220 PROCEDURE update_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_fxlv_tbl IN fxlv_tbl_type,
227 x_fxlv_tbl OUT NOCOPY fxlv_tbl_type);
228 PROCEDURE delete_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_fxlv_rec IN fxlv_rec_type);
235 PROCEDURE delete_row(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_fxlv_tbl IN fxlv_tbl_type,
242 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
243 PROCEDURE delete_row(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_fxlv_tbl IN fxlv_tbl_type);
250 PROCEDURE validate_row(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_fxlv_rec IN fxlv_rec_type);
257 PROCEDURE validate_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_fxlv_tbl IN fxlv_tbl_type,
264 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
265 PROCEDURE validate_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_fxlv_tbl IN fxlv_tbl_type);
272 -- Added : Bug# 6268782 : PRASJAIN
273 PROCEDURE insert_row(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_fxl_rec IN fxl_rec_type,
280 p_fxll_tbl IN fxll_tbl_type,
281 x_fxl_rec OUT NOCOPY fxl_rec_type,
282 x_fxll_tbl OUT NOCOPY fxll_tbl_type);
283 END OKL_FXL_PVT;