DBA Data[Home] [Help]

APPS.OKL_PXH_PVT dependencies on OKL_API

Line 204: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

200: INDEX BY BINARY_INTEGER;
201: ---------------------------------------------------------------------------
202: -- GLOBAL MESSAGE CONSTANTS
203: ---------------------------------------------------------------------------
204: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

201: ---------------------------------------------------------------------------
202: -- GLOBAL MESSAGE CONSTANTS
203: ---------------------------------------------------------------------------
204: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

202: -- GLOBAL MESSAGE CONSTANTS
203: ---------------------------------------------------------------------------
204: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

203: ---------------------------------------------------------------------------
204: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

204: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

205: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
213: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

206: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
213: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
214: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

207: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
213: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
214: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
215: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

208: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
213: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
214: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
215: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
216: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 213: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

209: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
213: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
214: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
215: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
216: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
217:

Line 227: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

223: ---------------------------------------------------------------------------
224: -- GLOBAL VARIABLES
225: ---------------------------------------------------------------------------
226: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PXH_PVT';
227: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
228: ---------------------------------------------------------------------------
229: -- Procedures and Functions
230: ---------------------------------------------------------------------------
231:

Line 238: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

234: PROCEDURE api_copy;
235: PROCEDURE add_language;
236: PROCEDURE insert_row(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_pxhv_rec IN pxhv_rec_type,

Line 246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

242: p_pxhv_rec IN pxhv_rec_type,
243: x_pxhv_rec OUT NOCOPY pxhv_rec_type);
244: PROCEDURE insert_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_pxhv_tbl IN pxhv_tbl_type,

Line 252: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_pxhv_tbl IN pxhv_tbl_type,
251: x_pxhv_tbl OUT NOCOPY pxhv_tbl_type,
252: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
253: PROCEDURE insert_row(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
256: x_return_status OUT NOCOPY VARCHAR2,

Line 255: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

251: x_pxhv_tbl OUT NOCOPY pxhv_tbl_type,
252: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
253: PROCEDURE insert_row(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_pxhv_tbl IN pxhv_tbl_type,

Line 263: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

259: p_pxhv_tbl IN pxhv_tbl_type,
260: x_pxhv_tbl OUT NOCOPY pxhv_tbl_type);
261: PROCEDURE lock_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_pxhv_rec IN pxhv_rec_type);

Line 270: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_pxhv_rec IN pxhv_rec_type);
268: PROCEDURE lock_row(
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_pxhv_tbl IN pxhv_tbl_type,

Line 275: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_pxhv_tbl IN pxhv_tbl_type,
275: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
276: PROCEDURE lock_row(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
279: x_return_status OUT NOCOPY VARCHAR2,

Line 278: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

274: p_pxhv_tbl IN pxhv_tbl_type,
275: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
276: PROCEDURE lock_row(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_pxhv_tbl IN pxhv_tbl_type);

Line 285: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_pxhv_tbl IN pxhv_tbl_type);
283: PROCEDURE update_row(
284: p_api_version IN NUMBER,
285: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_pxhv_rec IN pxhv_rec_type,

Line 293: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

289: p_pxhv_rec IN pxhv_rec_type,
290: x_pxhv_rec OUT NOCOPY pxhv_rec_type);
291: PROCEDURE update_row(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_pxhv_tbl IN pxhv_tbl_type,

Line 299: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_pxhv_tbl IN pxhv_tbl_type,
298: x_pxhv_tbl OUT NOCOPY pxhv_tbl_type,
299: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
300: PROCEDURE update_row(
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
303: x_return_status OUT NOCOPY VARCHAR2,

Line 302: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

298: x_pxhv_tbl OUT NOCOPY pxhv_tbl_type,
299: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
300: PROCEDURE update_row(
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_pxhv_tbl IN pxhv_tbl_type,

Line 310: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

306: p_pxhv_tbl IN pxhv_tbl_type,
307: x_pxhv_tbl OUT NOCOPY pxhv_tbl_type);
308: PROCEDURE delete_row(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_pxhv_rec IN pxhv_rec_type);

Line 317: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_pxhv_rec IN pxhv_rec_type);
315: PROCEDURE delete_row(
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
321: p_pxhv_tbl IN pxhv_tbl_type,

Line 322: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
321: p_pxhv_tbl IN pxhv_tbl_type,
322: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
323: PROCEDURE delete_row(
324: p_api_version IN NUMBER,
325: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
326: x_return_status OUT NOCOPY VARCHAR2,

Line 325: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

321: p_pxhv_tbl IN pxhv_tbl_type,
322: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
323: PROCEDURE delete_row(
324: p_api_version IN NUMBER,
325: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2,
329: p_pxhv_tbl IN pxhv_tbl_type);

Line 332: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

328: x_msg_data OUT NOCOPY VARCHAR2,
329: p_pxhv_tbl IN pxhv_tbl_type);
330: PROCEDURE validate_row(
331: p_api_version IN NUMBER,
332: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_pxhv_rec IN pxhv_rec_type);

Line 339: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_pxhv_rec IN pxhv_rec_type);
337: PROCEDURE validate_row(
338: p_api_version IN NUMBER,
339: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_pxhv_tbl IN pxhv_tbl_type,

Line 344: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_pxhv_tbl IN pxhv_tbl_type,
344: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
345: PROCEDURE validate_row(
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
348: x_return_status OUT NOCOPY VARCHAR2,

Line 347: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

343: p_pxhv_tbl IN pxhv_tbl_type,
344: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
345: PROCEDURE validate_row(
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
348: x_return_status OUT NOCOPY VARCHAR2,
349: x_msg_count OUT NOCOPY NUMBER,
350: x_msg_data OUT NOCOPY VARCHAR2,
351: p_pxhv_tbl IN pxhv_tbl_type);

Line 355: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

351: p_pxhv_tbl IN pxhv_tbl_type);
352: -- Added for Bug# 6268782 : PRASJAIN
353: PROCEDURE insert_row(
354: p_api_version IN NUMBER,
355: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
358: x_msg_data OUT NOCOPY VARCHAR2,
359: p_pxh_rec IN pxh_rec_type,