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