eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_CONTRACT_PVT dependencies on OKE_CLE_PVT

Line 239: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,

235: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
240: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS
241:
242: l_cle_rec OKE_CLE_PVT.cle_rec_type := p_cle_rec;
243: BEGIN

Line 240: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS

236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
240: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS
241:
242: l_cle_rec OKE_CLE_PVT.cle_rec_type := p_cle_rec;
243: BEGIN
244: -- initialize return status

Line 242: l_cle_rec OKE_CLE_PVT.cle_rec_type := p_cle_rec;

238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
240: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS
241:
242: l_cle_rec OKE_CLE_PVT.cle_rec_type := p_cle_rec;
243: BEGIN
244: -- initialize return status
245: x_return_status := OKE_API.G_RET_STS_SUCCESS;
246:

Line 249: OKE_CLE_PVT.Insert_Row(

245: x_return_status := OKE_API.G_RET_STS_SUCCESS;
246:
247:
248:
249: OKE_CLE_PVT.Insert_Row(
250: p_api_version => p_api_version,
251: p_init_msg_list => p_init_msg_list,
252: x_return_status => x_return_status,
253: x_msg_count => x_msg_count,

Line 266: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,

262: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
267: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS
268:
269: BEGIN
270:

Line 267: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS

263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
267: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS
268:
269: BEGIN
270:
271: OKE_CLE_PVT.Insert_Row(

Line 271: OKE_CLE_PVT.Insert_Row(

267: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS
268:
269: BEGIN
270:
271: OKE_CLE_PVT.Insert_Row(
272:
273: p_api_version => p_api_version,
274: p_init_msg_list => p_init_msg_list,
275: x_return_status => x_return_status,

Line 289: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,

285: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_cle_rec IN OKE_CLE_PVT.cle_rec_type,
290: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS
291:
292: BEGIN
293:

Line 290: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS

286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
290: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type) IS
291:
292: BEGIN
293:
294:

Line 296: OKE_CLE_PVT.Update_Row(

292: BEGIN
293:
294:
295:
296: OKE_CLE_PVT.Update_Row(
297: p_api_version => p_api_version,
298: p_init_msg_list => p_init_msg_list,
299: x_return_status => x_return_status,
300: x_msg_count => x_msg_count,

Line 326: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,

322: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
326: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
327: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS
328:
329: BEGIN
330: OKE_CLE_PVT.Update_Row(

Line 327: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS

323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
326: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
327: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS
328:
329: BEGIN
330: OKE_CLE_PVT.Update_Row(
331: p_api_version => p_api_version,

Line 330: OKE_CLE_PVT.Update_Row(

326: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
327: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type) IS
328:
329: BEGIN
330: OKE_CLE_PVT.Update_Row(
331: p_api_version => p_api_version,
332: p_init_msg_list => p_init_msg_list,
333: x_return_status => x_return_status,
334: x_msg_count => x_msg_count,

Line 346: p_cle_rec IN OKE_CLE_PVT.cle_rec_type) IS

342: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
343: x_return_status OUT NOCOPY VARCHAR2,
344: x_msg_count OUT NOCOPY NUMBER,
345: x_msg_data OUT NOCOPY VARCHAR2,
346: p_cle_rec IN OKE_CLE_PVT.cle_rec_type) IS
347:
348: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
349: l_chr_id NUMBER;
350: l_dummy_val NUMBER;

Line 364: OKE_CLE_PVT.delete_row(

360:
361: -- delete only if there are no detail records
362: IF (l_dummy_val = 0) THEN
363:
364: OKE_CLE_PVT.delete_row(
365: p_api_version => p_api_version,
366: p_init_msg_list => p_init_msg_list,
367: x_return_status => x_return_status,
368: x_msg_count => x_msg_count,

Line 404: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type) IS

400: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
401: x_return_status OUT NOCOPY VARCHAR2,
402: x_msg_count OUT NOCOPY NUMBER,
403: x_msg_data OUT NOCOPY VARCHAR2,
404: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type) IS
405:
406: BEGIN
407: OKE_CLE_PVT.Delete_Row(
408: p_api_version => p_api_version,

Line 407: OKE_CLE_PVT.Delete_Row(

403: x_msg_data OUT NOCOPY VARCHAR2,
404: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type) IS
405:
406: BEGIN
407: OKE_CLE_PVT.Delete_Row(
408: p_api_version => p_api_version,
409: p_init_msg_list => p_init_msg_list,
410: x_return_status => x_return_status,
411: x_msg_count => x_msg_count,

Line 454: l_cle_tbl_in OKE_CLE_PVT.cle_tbl_type;

450: FROM Okc_K_Lines_b
451: WHERE cle_Id=P_Parent_Id;
452:
453: n NUMBER:=0;
454: l_cle_tbl_in OKE_CLE_PVT.cle_tbl_type;
455: l_cle_tbl_tmp OKE_CLE_PVT.cle_tbl_type;
456:
457: l_api_version CONSTANT NUMBER := 1.0;
458: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';

Line 455: l_cle_tbl_tmp OKE_CLE_PVT.cle_tbl_type;

451: WHERE cle_Id=P_Parent_Id;
452:
453: n NUMBER:=0;
454: l_cle_tbl_in OKE_CLE_PVT.cle_tbl_type;
455: l_cle_tbl_tmp OKE_CLE_PVT.cle_tbl_type;
456:
457: l_api_version CONSTANT NUMBER := 1.0;
458: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';
459: l_return_status VARCHAR2(1);

Line 656: p_cle_rec IN OKE_CLE_PVT.cle_rec_type) IS

652: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2,
656: p_cle_rec IN OKE_CLE_PVT.cle_rec_type) IS
657:
658: BEGIN
659: OKE_CLE_PVT.Validate_Row(
660: p_api_version => p_api_version,

Line 659: OKE_CLE_PVT.Validate_Row(

655: x_msg_data OUT NOCOPY VARCHAR2,
656: p_cle_rec IN OKE_CLE_PVT.cle_rec_type) IS
657:
658: BEGIN
659: OKE_CLE_PVT.Validate_Row(
660: p_api_version => p_api_version,
661: p_init_msg_list => p_init_msg_list,
662: x_return_status => x_return_status,
663: x_msg_count => x_msg_count,

Line 674: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type) IS

670: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_msg_count OUT NOCOPY NUMBER,
673: x_msg_data OUT NOCOPY VARCHAR2,
674: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type) IS
675:
676: BEGIN
677: OKE_CLE_PVT.Validate_Row(
678: p_api_version => p_api_version,

Line 677: OKE_CLE_PVT.Validate_Row(

673: x_msg_data OUT NOCOPY VARCHAR2,
674: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type) IS
675:
676: BEGIN
677: OKE_CLE_PVT.Validate_Row(
678: p_api_version => p_api_version,
679: p_init_msg_list => p_init_msg_list,
680: x_return_status => x_return_status,
681: x_msg_count => x_msg_count,