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 47: OKE_RLE_PVT.Insert_Row(

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

Line 103: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,

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

Line 104: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS

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

Line 111: l_rle_tbl oke_rle_pvt.rle_tbl_type;

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

Line 131: OKE_RLE_PVT.Insert_Row(

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

Line 185: p_rle_rec IN oke_rle_pvt.rle_rec_type,

181: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_rle_rec IN oke_rle_pvt.rle_rec_type,
186: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
187:
188: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
189: l_api_version CONSTANT NUMBER := 1.0;

Line 186: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS

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

Line 213: OKE_RLE_PVT.Update_Row(

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

Line 269: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,

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

Line 270: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS

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

Line 298: OKE_RLE_PVT.Update_Row(

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

Line 356: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS

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

Line 358: l_rle_rec oke_rle_pvt.rle_rec_type;

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

Line 387: OKE_RLE_PVT.Validate_Row(

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

Line 441: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

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

Line 449: l_rle_tbl oke_rle_pvt.rle_tbl_type := p_rle_tbl;

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

Line 470: OKE_RLE_PVT.Validate_Row(

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

Line 528: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS

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

Line 530: l_rle_rec oke_rle_pvt.rle_rec_type;

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

Line 557: OKE_RLE_PVT.delete_row(

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

Line 612: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

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

Line 639: OKE_RLE_PVT.Delete_Row(

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

Line 696: p_rle_rec IN OKE_RLE_PVT.rle_rec_type) IS

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

Line 720: OKE_RLE_PVT.Lock_Row(

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

Line 773: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

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

Line 803: OKE_RLE_PVT.lock_row(

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