144: INDEX BY BINARY_INTEGER;
145: ---------------------------------------------------------------------------
146: -- GLOBAL MESSAGE CONSTANTS
147: ---------------------------------------------------------------------------
148: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
149: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
145: ---------------------------------------------------------------------------
146: -- GLOBAL MESSAGE CONSTANTS
147: ---------------------------------------------------------------------------
148: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
149: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
146: -- GLOBAL MESSAGE CONSTANTS
147: ---------------------------------------------------------------------------
148: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
149: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
147: ---------------------------------------------------------------------------
148: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
149: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
148: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
149: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
149: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
157: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
150: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
157: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
158: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
151: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
157: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
158: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
159: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
152: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
157: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
158: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
159: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
160: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
153: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
157: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
158: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
159: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
160: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
161:
167: ---------------------------------------------------------------------------
168: -- GLOBAL VARIABLES
169: ---------------------------------------------------------------------------
170: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RXL_PVT';
171: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
172: ---------------------------------------------------------------------------
173: -- Procedures and Functions
174: ---------------------------------------------------------------------------
175:
178: PROCEDURE api_copy;
179: PROCEDURE add_language;
180: PROCEDURE insert_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_rxlv_rec IN rxlv_rec_type,
186: p_rxlv_rec IN rxlv_rec_type,
187: x_rxlv_rec OUT NOCOPY rxlv_rec_type);
188: PROCEDURE insert_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_rxlv_tbl IN rxlv_tbl_type,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_rxlv_tbl IN rxlv_tbl_type,
195: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type,
196: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
197: PROCEDURE insert_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
195: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type,
196: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
197: PROCEDURE insert_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_rxlv_tbl IN rxlv_tbl_type,
203: p_rxlv_tbl IN rxlv_tbl_type,
204: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type);
205: PROCEDURE lock_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_rxlv_rec IN rxlv_rec_type);
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_rxlv_rec IN rxlv_rec_type);
212: PROCEDURE lock_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_rxlv_tbl IN rxlv_tbl_type,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_rxlv_tbl IN rxlv_tbl_type,
219: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
220: PROCEDURE lock_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,
218: p_rxlv_tbl IN rxlv_tbl_type,
219: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
220: PROCEDURE lock_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_rxlv_tbl IN rxlv_tbl_type);
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_rxlv_tbl IN rxlv_tbl_type);
227: PROCEDURE update_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_rxlv_rec IN rxlv_rec_type,
233: p_rxlv_rec IN rxlv_rec_type,
234: x_rxlv_rec OUT NOCOPY rxlv_rec_type);
235: PROCEDURE update_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_rxlv_tbl IN rxlv_tbl_type,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: p_rxlv_tbl IN rxlv_tbl_type,
242: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type,
243: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
244: PROCEDURE update_row(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
242: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type,
243: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
244: PROCEDURE update_row(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_rxlv_tbl IN rxlv_tbl_type,
250: p_rxlv_tbl IN rxlv_tbl_type,
251: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type);
252: PROCEDURE delete_row(
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_rxlv_rec IN rxlv_rec_type);
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_rxlv_rec IN rxlv_rec_type);
259: PROCEDURE delete_row(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_rxlv_tbl IN rxlv_tbl_type,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_rxlv_tbl IN rxlv_tbl_type,
266: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
267: PROCEDURE delete_row(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
270: x_return_status OUT NOCOPY VARCHAR2,
265: p_rxlv_tbl IN rxlv_tbl_type,
266: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
267: PROCEDURE delete_row(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_rxlv_tbl IN rxlv_tbl_type);
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_rxlv_tbl IN rxlv_tbl_type);
274: PROCEDURE validate_row(
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,
280: p_rxlv_rec IN rxlv_rec_type);
279: x_msg_data OUT NOCOPY VARCHAR2,
280: p_rxlv_rec IN rxlv_rec_type);
281: PROCEDURE validate_row(
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_rxlv_tbl IN rxlv_tbl_type,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_rxlv_tbl IN rxlv_tbl_type,
288: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
289: PROCEDURE validate_row(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
287: p_rxlv_tbl IN rxlv_tbl_type,
288: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
289: PROCEDURE validate_row(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_rxlv_tbl IN rxlv_tbl_type);
295: p_rxlv_tbl IN rxlv_tbl_type);
296: -- Added for Bug# 6268782 : PRASJAIN
297: PROCEDURE insert_row(
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_rxl_rec IN rxl_rec_type,