DBA Data[Home] [Help]

APPS.OKL_TEH_PVT dependencies on OKL_API

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

168: INDEX BY BINARY_INTEGER;
169: ---------------------------------------------------------------------------
170: -- GLOBAL MESSAGE CONSTANTS
171: ---------------------------------------------------------------------------
172: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
173: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

169: ---------------------------------------------------------------------------
170: -- GLOBAL MESSAGE CONSTANTS
171: ---------------------------------------------------------------------------
172: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
173: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

170: -- GLOBAL MESSAGE CONSTANTS
171: ---------------------------------------------------------------------------
172: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
173: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

171: ---------------------------------------------------------------------------
172: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
173: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

172: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
173: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

173: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
181: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

174: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
181: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
182: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

175: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
181: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
182: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
183: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

176: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
181: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
182: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
183: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
184: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

177: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
181: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
182: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
183: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
184: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
185:

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

191: ---------------------------------------------------------------------------
192: -- GLOBAL VARIABLES
193: ---------------------------------------------------------------------------
194: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TEH_PVT';
195: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
196: ---------------------------------------------------------------------------
197: -- Procedures and Functions
198: ---------------------------------------------------------------------------
199:

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

202: PROCEDURE api_copy;
203: PROCEDURE add_language;
204: PROCEDURE insert_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_tehv_rec IN tehv_rec_type,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

210: p_tehv_rec IN tehv_rec_type,
211: x_tehv_rec OUT NOCOPY tehv_rec_type);
212: PROCEDURE insert_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_tehv_tbl IN tehv_tbl_type,

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

216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_tehv_tbl IN tehv_tbl_type,
219: x_tehv_tbl OUT NOCOPY tehv_tbl_type,
220: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221: PROCEDURE insert_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

219: x_tehv_tbl OUT NOCOPY tehv_tbl_type,
220: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221: PROCEDURE insert_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_tehv_tbl IN tehv_tbl_type,

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

227: p_tehv_tbl IN tehv_tbl_type,
228: x_tehv_tbl OUT NOCOPY tehv_tbl_type);
229: PROCEDURE lock_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_tehv_rec IN tehv_rec_type);

Line 238: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_tehv_rec IN tehv_rec_type);
236: PROCEDURE lock_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_tehv_tbl IN tehv_tbl_type,

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

239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_tehv_tbl IN tehv_tbl_type,
243: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
244: PROCEDURE lock_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,

Line 246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

242: p_tehv_tbl IN tehv_tbl_type,
243: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
244: PROCEDURE lock_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_tehv_tbl IN tehv_tbl_type);

Line 253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_tehv_tbl IN tehv_tbl_type);
251: PROCEDURE update_row(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_tehv_rec IN tehv_rec_type,

Line 261: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

257: p_tehv_rec IN tehv_rec_type,
258: x_tehv_rec OUT NOCOPY tehv_rec_type);
259: PROCEDURE update_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_tehv_tbl IN tehv_tbl_type,

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

263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_tehv_tbl IN tehv_tbl_type,
266: x_tehv_tbl OUT NOCOPY tehv_tbl_type,
267: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
268: PROCEDURE update_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,

Line 270: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

266: x_tehv_tbl OUT NOCOPY tehv_tbl_type,
267: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
268: PROCEDURE update_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_tehv_tbl IN tehv_tbl_type,

Line 278: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

274: p_tehv_tbl IN tehv_tbl_type,
275: x_tehv_tbl OUT NOCOPY tehv_tbl_type);
276: PROCEDURE delete_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_tehv_rec IN tehv_rec_type);

Line 285: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_tehv_rec IN tehv_rec_type);
283: PROCEDURE delete_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_tehv_tbl IN tehv_tbl_type,

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

286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_tehv_tbl IN tehv_tbl_type,
290: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
291: PROCEDURE delete_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,

Line 293: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

289: p_tehv_tbl IN tehv_tbl_type,
290: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
291: PROCEDURE delete_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_tehv_tbl IN tehv_tbl_type);

Line 300: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_tehv_tbl IN tehv_tbl_type);
298: PROCEDURE validate_row(
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
304: p_tehv_rec IN tehv_rec_type);

Line 307: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

303: x_msg_data OUT NOCOPY VARCHAR2,
304: p_tehv_rec IN tehv_rec_type);
305: PROCEDURE validate_row(
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_tehv_tbl IN tehv_tbl_type,

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

308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_tehv_tbl IN tehv_tbl_type,
312: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
313: PROCEDURE validate_row(
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,

Line 315: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

311: p_tehv_tbl IN tehv_tbl_type,
312: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
313: PROCEDURE validate_row(
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_tehv_tbl IN tehv_tbl_type);

Line 323: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

319: p_tehv_tbl IN tehv_tbl_type);
320: -- Added : PRASJAIN : Bug# 6268782
321: PROCEDURE insert_row(
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_teh_rec IN teh_rec_type,