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_RELATED_ENTITIES_PUB dependencies on OKE_RLE_PVT

Line 13: p_rle_rec IN oke_rle_pvt.rle_rec_type,

9: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_rle_rec IN oke_rle_pvt.rle_rec_type,
14: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
15:
16:
17: l_rle_rec oke_rle_pvt.rle_rec_type;

Line 14: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS

10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_rle_rec IN oke_rle_pvt.rle_rec_type,
14: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
15:
16:
17: l_rle_rec oke_rle_pvt.rle_rec_type;
18:

Line 17: l_rle_rec oke_rle_pvt.rle_rec_type;

13: p_rle_rec IN oke_rle_pvt.rle_rec_type,
14: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
15:
16:
17: l_rle_rec oke_rle_pvt.rle_rec_type;
18:
19: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELATED_ENTITY';
20: l_api_version CONSTANT NUMBER := 1.0;
21: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 48: OKE_RLE_PVT.Insert_Row(

44: l_rle_rec := p_rle_rec;
45:
46: -- call procedure in complex API
47:
48: OKE_RLE_PVT.Insert_Row(
49: p_api_version => p_api_version,
50: p_init_msg_list => p_init_msg_list,
51: x_return_status => x_return_status,
52: x_msg_count => x_msg_count,

Line 104: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,

100: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,
105: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS
106:
107: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELATED_ENTITY';
108: l_api_version CONSTANT NUMBER := 1.0;

Line 105: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS

101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,
105: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS
106:
107: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELATED_ENTITY';
108: l_api_version CONSTANT NUMBER := 1.0;
109: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 112: l_rle_tbl oke_rle_pvt.rle_tbl_type;

108: l_api_version CONSTANT NUMBER := 1.0;
109: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
110: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
111: i NUMBER;
112: l_rle_tbl oke_rle_pvt.rle_tbl_type;
113: BEGIN
114: -- call START_ACTIVITY to create savepoint, check compatibility
115: -- and initialize message list
116: l_return_status := OKE_API.START_ACTIVITY(

Line 132: OKE_RLE_PVT.Insert_Row(

128: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
129: raise OKE_API.G_EXCEPTION_ERROR;
130: End If;
131:
132: OKE_RLE_PVT.Insert_Row(
133: p_api_version => p_api_version,
134: p_init_msg_list => p_init_msg_list,
135: x_return_status => x_return_status,
136: x_msg_count => x_msg_count,

Line 186: p_rle_rec IN oke_rle_pvt.rle_rec_type,

182: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_rle_rec IN oke_rle_pvt.rle_rec_type,
187: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
188:
189: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
190: l_api_version CONSTANT NUMBER := 1.0;

Line 187: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS

183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_rle_rec IN oke_rle_pvt.rle_rec_type,
187: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
188:
189: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
190: l_api_version CONSTANT NUMBER := 1.0;
191: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 214: OKE_RLE_PVT.Update_Row(

210: End If;
211:
212: -- call complex api
213:
214: OKE_RLE_PVT.Update_Row(
215: p_api_version => p_api_version,
216: p_init_msg_list => p_init_msg_list,
217: x_return_status => x_return_status,
218: x_msg_count => x_msg_count,

Line 270: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,

266: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,
271: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS
272:
273: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
274: l_api_version CONSTANT NUMBER := 1.0;

Line 271: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS

267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,
271: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS
272:
273: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
274: l_api_version CONSTANT NUMBER := 1.0;
275: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 299: OKE_RLE_PVT.Update_Row(

295: raise OKE_API.G_EXCEPTION_ERROR;
296:
297: End If;
298:
299: OKE_RLE_PVT.Update_Row(
300: p_api_version => p_api_version,
301: p_init_msg_list => p_init_msg_list,
302: x_return_status => x_return_status,
303: x_msg_count => x_msg_count,

Line 357: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS

353: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS
358:
359: l_rle_rec oke_rle_pvt.rle_rec_type;
360: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RELATED_ENTITY';
361: l_api_version CONSTANT NUMBER := 1.0;

Line 359: l_rle_rec oke_rle_pvt.rle_rec_type;

355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS
358:
359: l_rle_rec oke_rle_pvt.rle_rec_type;
360: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RELATED_ENTITY';
361: l_api_version CONSTANT NUMBER := 1.0;
362: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
363:

Line 388: OKE_RLE_PVT.Validate_Row(

384: l_rle_rec := p_rle_rec;
385:
386: -- call complex API
387:
388: OKE_RLE_PVT.Validate_Row(
389: p_api_version => p_api_version,
390: p_init_msg_list => p_init_msg_list,
391: x_return_status => x_return_status,
392: x_msg_count => x_msg_count,

Line 442: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

438: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
439: x_return_status OUT NOCOPY VARCHAR2,
440: x_msg_count OUT NOCOPY NUMBER,
441: x_msg_data OUT NOCOPY VARCHAR2,
442: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS
443:
444: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RELATED_ENTITY';
445:
446: l_api_version CONSTANT NUMBER := 1.0;

Line 450: l_rle_tbl oke_rle_pvt.rle_tbl_type := p_rle_tbl;

446: l_api_version CONSTANT NUMBER := 1.0;
447: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
448: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
449: i NUMBER;
450: l_rle_tbl oke_rle_pvt.rle_tbl_type := p_rle_tbl;
451: BEGIN
452: -- call START_ACTIVITY to create savepoint, check compatibility
453: -- and initialize message list
454: l_return_status := OKE_API.START_ACTIVITY(

Line 471: OKE_RLE_PVT.Validate_Row(

467: raise OKE_API.G_EXCEPTION_ERROR;
468: End If;
469:
470:
471: OKE_RLE_PVT.Validate_Row(
472: p_api_version => p_api_version,
473: p_init_msg_list => p_init_msg_list,
474: x_return_status => x_return_status,
475: x_msg_count => x_msg_count,

Line 529: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS

525: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
526: x_return_status OUT NOCOPY VARCHAR2,
527: x_msg_count OUT NOCOPY NUMBER,
528: x_msg_data OUT NOCOPY VARCHAR2,
529: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS
530:
531: l_rle_rec oke_rle_pvt.rle_rec_type;
532: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';
533: l_api_version CONSTANT NUMBER := 1.0;

Line 531: l_rle_rec oke_rle_pvt.rle_rec_type;

527: x_msg_count OUT NOCOPY NUMBER,
528: x_msg_data OUT NOCOPY VARCHAR2,
529: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS
530:
531: l_rle_rec oke_rle_pvt.rle_rec_type;
532: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';
533: l_api_version CONSTANT NUMBER := 1.0;
534: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
535: BEGIN

Line 558: OKE_RLE_PVT.delete_row(

554: l_rle_rec := p_rle_rec;
555:
556: -- call complex api
557:
558: OKE_RLE_PVT.delete_row(
559: p_api_version => p_api_version,
560: p_init_msg_list => p_init_msg_list,
561: x_return_status => x_return_status,
562: x_msg_count => x_msg_count,

Line 613: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

609: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
613: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS
614:
615: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';
616: l_api_version CONSTANT NUMBER := 1.0;
617: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 640: OKE_RLE_PVT.Delete_Row(

636: raise OKE_API.G_EXCEPTION_ERROR;
637: End If;
638:
639:
640: OKE_RLE_PVT.Delete_Row(
641: p_api_version => p_api_version,
642: p_init_msg_list => p_init_msg_list,
643: x_return_status => x_return_status,
644: x_msg_count => x_msg_count,

Line 697: p_rle_rec IN OKE_RLE_PVT.rle_rec_type) IS

693: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
694: x_return_status OUT NOCOPY VARCHAR2,
695: x_msg_count OUT NOCOPY NUMBER,
696: x_msg_data OUT NOCOPY VARCHAR2,
697: p_rle_rec IN OKE_RLE_PVT.rle_rec_type) IS
698:
699:
700: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_RELATED_ENTITY';
701: l_api_version CONSTANT NUMBER := 1.0;

Line 721: OKE_RLE_PVT.Lock_Row(

717: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
718: raise OKE_API.G_EXCEPTION_ERROR;
719: End If;
720:
721: OKE_RLE_PVT.Lock_Row(
722: p_api_version => p_api_version,
723: p_init_msg_list => p_init_msg_list,
724: x_return_status => x_return_status,
725: x_msg_count => x_msg_count,

Line 774: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

770: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
771: x_return_status OUT NOCOPY VARCHAR2,
772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,
774: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS
775:
776: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_RELATED_ENTITY';
777: l_api_version CONSTANT NUMBER := 1.0;
778: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 804: OKE_RLE_PVT.lock_row(

800: If (p_rle_tbl.COUNT > 0) Then
801: i := p_rle_tbl.FIRST;
802: LOOP
803: -- call procedure in complex API
804: OKE_RLE_PVT.lock_row(
805: p_api_version => p_api_version,
806: p_init_msg_list => p_init_msg_list,
807: x_return_status => x_return_status,
808: x_msg_count => x_msg_count,