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_TERMS_PUB dependencies on OKE_TERM_PVT

Line 11: p_term_rec IN oke_term_pvt.term_rec_type,

7: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_term_rec IN oke_term_pvt.term_rec_type,
12: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS
13:
14:
15: l_term_rec oke_term_pvt.term_rec_type;

Line 12: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS

8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_term_rec IN oke_term_pvt.term_rec_type,
12: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS
13:
14:
15: l_term_rec oke_term_pvt.term_rec_type;
16:

Line 15: l_term_rec oke_term_pvt.term_rec_type;

11: p_term_rec IN oke_term_pvt.term_rec_type,
12: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS
13:
14:
15: l_term_rec oke_term_pvt.term_rec_type;
16:
17: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TERM';
18: l_api_version CONSTANT NUMBER := 1.0;
19: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 45: OKE_TERM_PVT.Insert_Row(

41: l_term_rec := p_term_rec;
42:
43: -- call procedure in complex API
44:
45: OKE_TERM_PVT.Insert_Row(
46: p_api_version => p_api_version,
47: p_init_msg_list => p_init_msg_list,
48: x_return_status => x_return_status,
49: x_msg_count => x_msg_count,

Line 102: p_term_tbl IN oke_term_pvt.term_tbl_type,

98: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_term_tbl IN oke_term_pvt.term_tbl_type,
103: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS
104:
105: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TERM';
106: l_api_version CONSTANT NUMBER := 1.0;

Line 103: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS

99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_term_tbl IN oke_term_pvt.term_tbl_type,
103: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS
104:
105: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TERM';
106: l_api_version CONSTANT NUMBER := 1.0;
107: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 110: l_term_tbl oke_term_pvt.term_tbl_type;

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

Line 131: OKE_TERM_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_TERM_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 188: p_term_rec IN oke_term_pvt.term_rec_type,

184: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_term_rec IN oke_term_pvt.term_rec_type,
189: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS
190:
191: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
192: l_api_version CONSTANT NUMBER := 1.0;

Line 189: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS

185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_term_rec IN oke_term_pvt.term_rec_type,
189: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS
190:
191: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
192: l_api_version CONSTANT NUMBER := 1.0;
193: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 217: OKE_TERM_PVT.Update_Row(

213: End If;
214:
215: -- call complex api
216:
217: OKE_TERM_PVT.Update_Row(
218: p_api_version => p_api_version,
219: p_init_msg_list => p_init_msg_list,
220: x_return_status => x_return_status,
221: x_msg_count => x_msg_count,

Line 273: p_term_tbl IN oke_term_pvt.term_tbl_type,

269: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_term_tbl IN oke_term_pvt.term_tbl_type,
274: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS
275:
276: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
277: l_api_version CONSTANT NUMBER := 1.0;

Line 274: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS

270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_term_tbl IN oke_term_pvt.term_tbl_type,
274: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS
275:
276: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
277: l_api_version CONSTANT NUMBER := 1.0;
278: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 302: OKE_TERM_PVT.Update_Row(

298: raise OKE_API.G_EXCEPTION_ERROR;
299:
300: End If;
301:
302: OKE_TERM_PVT.Update_Row(
303: p_api_version => p_api_version,
304: p_init_msg_list => p_init_msg_list,
305: x_return_status => x_return_status,
306: x_msg_count => x_msg_count,

Line 360: p_term_rec IN oke_term_pvt.term_rec_type) IS

356: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
357: x_return_status OUT NOCOPY VARCHAR2,
358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: p_term_rec IN oke_term_pvt.term_rec_type) IS
361:
362: l_term_rec oke_term_pvt.term_rec_type;
363: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TERM';
364: l_api_version CONSTANT NUMBER := 1.0;

Line 362: l_term_rec oke_term_pvt.term_rec_type;

358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: p_term_rec IN oke_term_pvt.term_rec_type) IS
361:
362: l_term_rec oke_term_pvt.term_rec_type;
363: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TERM';
364: l_api_version CONSTANT NUMBER := 1.0;
365: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
366:

Line 391: OKE_TERM_PVT.Validate_Row(

387: l_term_rec := p_term_rec;
388:
389: -- call complex API
390:
391: OKE_TERM_PVT.Validate_Row(
392: p_api_version => p_api_version,
393: p_init_msg_list => p_init_msg_list,
394: x_return_status => x_return_status,
395: x_msg_count => x_msg_count,

Line 445: p_term_tbl IN oke_term_pvt.term_tbl_type) IS

441: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: p_term_tbl IN oke_term_pvt.term_tbl_type) IS
446:
447: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TERM';
448:
449: l_api_version CONSTANT NUMBER := 1.0;

Line 453: l_term_tbl oke_term_pvt.term_tbl_type := p_term_tbl;

449: l_api_version CONSTANT NUMBER := 1.0;
450: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
451: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
452: i NUMBER;
453: l_term_tbl oke_term_pvt.term_tbl_type := p_term_tbl;
454: BEGIN
455: -- call START_ACTIVITY to create savepoint, check compatibility
456: -- and initialize message list
457: l_return_status := OKE_API.START_ACTIVITY(

Line 474: OKE_TERM_PVT.Validate_Row(

470: raise OKE_API.G_EXCEPTION_ERROR;
471: End If;
472:
473:
474: OKE_TERM_PVT.Validate_Row(
475: p_api_version => p_api_version,
476: p_init_msg_list => p_init_msg_list,
477: x_return_status => x_return_status,
478: x_msg_count => x_msg_count,

Line 532: p_term_rec IN oke_term_pvt.term_rec_type) IS

528: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_term_rec IN oke_term_pvt.term_rec_type) IS
533:
534: l_term_rec oke_term_pvt.term_rec_type;
535: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
536: l_api_version CONSTANT NUMBER := 1.0;

Line 534: l_term_rec oke_term_pvt.term_rec_type;

530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_term_rec IN oke_term_pvt.term_rec_type) IS
533:
534: l_term_rec oke_term_pvt.term_rec_type;
535: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
536: l_api_version CONSTANT NUMBER := 1.0;
537: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
538: BEGIN

Line 562: OKE_TERM_PVT.delete_row(

558: l_term_rec := p_term_rec;
559:
560: -- call complex api
561:
562: OKE_TERM_PVT.delete_row(
563: p_api_version => p_api_version,
564: p_init_msg_list => p_init_msg_list,
565: x_return_status => x_return_status,
566: x_msg_count => x_msg_count,

Line 615: p_term_tbl IN oke_term_pvt.term_tbl_type) IS

611: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
612: x_return_status OUT NOCOPY VARCHAR2,
613: x_msg_count OUT NOCOPY NUMBER,
614: x_msg_data OUT NOCOPY VARCHAR2,
615: p_term_tbl IN oke_term_pvt.term_tbl_type) IS
616:
617: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
618: l_api_version CONSTANT NUMBER := 1.0;
619: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 643: OKE_TERM_PVT.Delete_Row(

639: raise OKE_API.G_EXCEPTION_ERROR;
640: End If;
641:
642:
643: OKE_TERM_PVT.Delete_Row(
644: p_api_version => p_api_version,
645: p_init_msg_list => p_init_msg_list,
646: x_return_status => x_return_status,
647: x_msg_count => x_msg_count,

Line 705: l_term_rec oke_term_pvt.term_rec_type;

701: p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,
702: p_trm_val_pk1 IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
703: p_trm_val_pk2 IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS
704:
705: l_term_rec oke_term_pvt.term_rec_type;
706: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
707: l_api_version CONSTANT NUMBER := 1.0;
708: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
709: l_check_num1 NUMBER;

Line 733: OKE_TERM_PVT.delete_row(

729: raise OKE_API.G_EXCEPTION_ERROR;
730: End If;
731:
732: If (p_cle_id IS NOT NULL) Then
733: OKE_TERM_PVT.delete_row(
734: p_api_version => p_api_version,
735: p_init_msg_list => p_init_msg_list,
736: x_return_status => x_return_status,
737: x_msg_count => x_msg_count,

Line 746: OKE_TERM_PVT.delete_row(

742: p_trm_val_pk2 => p_trm_val_pk2);
743:
744:
745: Else
746: OKE_TERM_PVT.delete_row(
747: p_api_version => p_api_version,
748: p_init_msg_list => p_init_msg_list,
749: x_return_status => x_return_status,
750: x_msg_count => x_msg_count,

Line 816: l_term_tbl oke_term_pvt.term_tbl_type;

812: p_to_cle_id IN NUMBER
813: ) IS
814:
815:
816: l_term_tbl oke_term_pvt.term_tbl_type;
817: l_term_rec oke_term_pvt.term_rec_type;
818: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TERM';
819: l_api_version CONSTANT NUMBER := 1.0;
820: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 817: l_term_rec oke_term_pvt.term_rec_type;

813: ) IS
814:
815:
816: l_term_tbl oke_term_pvt.term_tbl_type;
817: l_term_rec oke_term_pvt.term_rec_type;
818: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TERM';
819: l_api_version CONSTANT NUMBER := 1.0;
820: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
821: l_rec_num NUMBER:=0;

Line 823: x_term_tbl oke_term_pvt.term_tbl_type;

819: l_api_version CONSTANT NUMBER := 1.0;
820: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
821: l_rec_num NUMBER:=0;
822:
823: x_term_tbl oke_term_pvt.term_tbl_type;
824:
825: CURSOR term_cle_csr (p_id IN NUMBER) IS
826: SELECT
827: b.K_HEADER_ID ,

Line 969: OKE_TERM_PVT.Insert_Row(

965:
966: END LOOP;
967: CLOSE term_chr_csr;
968:
969: OKE_TERM_PVT.Insert_Row(
970: p_api_version => p_api_version,
971: p_init_msg_list => p_init_msg_list,
972: x_return_status => x_return_status,
973: x_msg_count => x_msg_count,

Line 1044: OKE_TERM_PVT.Insert_Row(

1040: END LOOP;
1041: CLOSE term_cle_csr;
1042:
1043:
1044: OKE_TERM_PVT.Insert_Row(
1045: p_api_version => p_api_version,
1046: p_init_msg_list => p_init_msg_list,
1047: x_return_status => x_return_status,
1048: x_msg_count => x_msg_count,

Line 1103: p_term_rec IN OKE_TERM_PVT.term_rec_type) IS

1099: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1100: x_return_status OUT NOCOPY VARCHAR2,
1101: x_msg_count OUT NOCOPY NUMBER,
1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_term_rec IN OKE_TERM_PVT.term_rec_type) IS
1104:
1105:
1106: l_del_rec oke_deliverable_pvt.del_rec_type;
1107: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TERM';

Line 1128: OKE_TERM_PVT.Lock_Row(

1124: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1125: raise OKE_API.G_EXCEPTION_ERROR;
1126: End If;
1127:
1128: OKE_TERM_PVT.Lock_Row(
1129: p_api_version => p_api_version,
1130: p_init_msg_list => p_init_msg_list,
1131: x_return_status => x_return_status,
1132: x_msg_count => x_msg_count,

Line 1181: p_term_tbl IN oke_term_pvt.term_tbl_type) IS

1177: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1178: x_return_status OUT NOCOPY VARCHAR2,
1179: x_msg_count OUT NOCOPY NUMBER,
1180: x_msg_data OUT NOCOPY VARCHAR2,
1181: p_term_tbl IN oke_term_pvt.term_tbl_type) IS
1182:
1183: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TERM';
1184: l_api_version CONSTANT NUMBER := 1.0;
1185: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1212: OKE_TERM_PVT.lock_row(

1208: If (p_term_tbl.COUNT > 0) Then
1209: i := p_term_tbl.FIRST;
1210: LOOP
1211: -- call procedure in complex API
1212: OKE_TERM_PVT.lock_row(
1213: p_api_version => p_api_version,
1214: p_init_msg_list => p_init_msg_list,
1215: x_return_status => x_return_status,
1216: x_msg_count => x_msg_count,