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_STANDARD_NOTES_PUB dependencies on OKE_NOTE_PVT

Line 11: p_note_rec IN oke_note_pvt.note_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_note_rec IN oke_note_pvt.note_rec_type,
12: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
13:
14:
15: l_note_rec oke_note_pvt.note_rec_type;

Line 12: x_note_rec OUT NOCOPY oke_note_pvt.note_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_note_rec IN oke_note_pvt.note_rec_type,
12: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
13:
14:
15: l_note_rec oke_note_pvt.note_rec_type;
16:

Line 15: l_note_rec oke_note_pvt.note_rec_type;

11: p_note_rec IN oke_note_pvt.note_rec_type,
12: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
13:
14:
15: l_note_rec oke_note_pvt.note_rec_type;
16:
17: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
18: l_api_version CONSTANT NUMBER := 1.0;
19: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 45: OKE_NOTE_PVT.Insert_Row(

41: l_note_rec := p_note_rec;
42:
43: -- call procedure in complex API
44:
45: OKE_NOTE_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 101: p_note_tbl IN oke_note_pvt.note_tbl_type,

97: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_note_tbl IN oke_note_pvt.note_tbl_type,
102: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
103:
104: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
105: l_api_version CONSTANT NUMBER := 1.0;

Line 102: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS

98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_note_tbl IN oke_note_pvt.note_tbl_type,
102: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
103:
104: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
105: l_api_version CONSTANT NUMBER := 1.0;
106: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 109: l_note_tbl oke_note_pvt.note_tbl_type;

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

Line 129: OKE_NOTE_PVT.Insert_Row(

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

Line 183: p_note_rec IN oke_note_pvt.note_rec_type,

179: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_note_rec IN oke_note_pvt.note_rec_type,
184: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
185:
186: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
187: l_api_version CONSTANT NUMBER := 1.0;

Line 184: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS

180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_note_rec IN oke_note_pvt.note_rec_type,
184: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
185:
186: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
187: l_api_version CONSTANT NUMBER := 1.0;
188: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 211: OKE_NOTE_PVT.Update_Row(

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

Line 267: p_note_tbl IN oke_note_pvt.note_tbl_type,

263: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_note_tbl IN oke_note_pvt.note_tbl_type,
268: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
269:
270: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
271: l_api_version CONSTANT NUMBER := 1.0;

Line 268: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS

264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_note_tbl IN oke_note_pvt.note_tbl_type,
268: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
269:
270: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
271: l_api_version CONSTANT NUMBER := 1.0;
272: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 296: OKE_NOTE_PVT.Update_Row(

292: raise OKE_API.G_EXCEPTION_ERROR;
293:
294: End If;
295:
296: OKE_NOTE_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 354: p_note_rec IN oke_note_pvt.note_rec_type) IS

350: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_note_rec IN oke_note_pvt.note_rec_type) IS
355:
356: l_note_rec oke_note_pvt.note_rec_type;
357: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
358: l_api_version CONSTANT NUMBER := 1.0;

Line 356: l_note_rec oke_note_pvt.note_rec_type;

352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_note_rec IN oke_note_pvt.note_rec_type) IS
355:
356: l_note_rec oke_note_pvt.note_rec_type;
357: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
358: l_api_version CONSTANT NUMBER := 1.0;
359: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
360:

Line 385: OKE_NOTE_PVT.Validate_Row(

381: l_note_rec := p_note_rec;
382:
383: -- call complex API
384:
385: OKE_NOTE_PVT.Validate_Row(
386: p_api_version => p_api_version,
387: p_init_msg_list => p_init_msg_list,
388: x_return_status => x_return_status,
389: x_msg_count => x_msg_count,

Line 439: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

435: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2,
439: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
440:
441: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
442:
443: l_api_version CONSTANT NUMBER := 1.0;

Line 447: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;

443: l_api_version CONSTANT NUMBER := 1.0;
444: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
445: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
446: i NUMBER;
447: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;
448: BEGIN
449: -- call START_ACTIVITY to create savepoint, check compatibility
450: -- and initialize message list
451: l_return_status := OKE_API.START_ACTIVITY(

Line 468: OKE_NOTE_PVT.Validate_Row(

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

Line 526: p_note_rec IN oke_note_pvt.note_rec_type) IS

522: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
523: x_return_status OUT NOCOPY VARCHAR2,
524: x_msg_count OUT NOCOPY NUMBER,
525: x_msg_data OUT NOCOPY VARCHAR2,
526: p_note_rec IN oke_note_pvt.note_rec_type) IS
527:
528: l_note_rec oke_note_pvt.note_rec_type;
529: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
530: l_api_version CONSTANT NUMBER := 1.0;

Line 528: l_note_rec oke_note_pvt.note_rec_type;

524: x_msg_count OUT NOCOPY NUMBER,
525: x_msg_data OUT NOCOPY VARCHAR2,
526: p_note_rec IN oke_note_pvt.note_rec_type) IS
527:
528: l_note_rec oke_note_pvt.note_rec_type;
529: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
530: l_api_version CONSTANT NUMBER := 1.0;
531: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
532: BEGIN

Line 555: OKE_NOTE_PVT.delete_row(

551: l_note_rec := p_note_rec;
552:
553: -- call complex api
554:
555: OKE_NOTE_PVT.delete_row(
556: p_api_version => p_api_version,
557: p_init_msg_list => p_init_msg_list,
558: x_return_status => x_return_status,
559: x_msg_count => x_msg_count,

Line 609: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

605: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
606: x_return_status OUT NOCOPY VARCHAR2,
607: x_msg_count OUT NOCOPY NUMBER,
608: x_msg_data OUT NOCOPY VARCHAR2,
609: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
610:
611: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
612: l_api_version CONSTANT NUMBER := 1.0;
613: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 636: OKE_NOTE_PVT.Delete_Row(

632: raise OKE_API.G_EXCEPTION_ERROR;
633: End If;
634:
635:
636: OKE_NOTE_PVT.Delete_Row(
637: p_api_version => p_api_version,
638: p_init_msg_list => p_init_msg_list,
639: x_return_status => x_return_status,
640: x_msg_count => x_msg_count,

Line 693: l_note_rec oke_note_pvt.note_rec_type;

689: x_msg_count OUT NOCOPY NUMBER,
690: x_msg_data OUT NOCOPY VARCHAR2,
691: p_note_id IN NUMBER) IS
692:
693: l_note_rec oke_note_pvt.note_rec_type;
694: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
695: l_api_version CONSTANT NUMBER := 1.0;
696: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
697: l_check_num1 NUMBER;

Line 733: OKE_NOTE_PVT.delete_row(

729: l_note_rec.STANDARD_NOTES_ID := p_note_id;
730:
731: -- call complex api
732:
733: OKE_NOTE_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 794: l_note_rec oke_note_pvt.note_rec_type;

790: p_hdr_id IN NUMBER,
791: p_cle_id IN NUMBER,
792: p_del_id IN NUMBER ) IS
793:
794: l_note_rec oke_note_pvt.note_rec_type;
795: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
796: l_api_version CONSTANT NUMBER := 1.0;
797: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
798: l_check_num1 NUMBER;

Line 821: OKE_NOTE_PVT.delete_row(

817: raise OKE_API.G_EXCEPTION_ERROR;
818: End If;
819:
820: If (p_del_id IS NOT NULL) Then
821: OKE_NOTE_PVT.delete_row(
822: p_api_version => p_api_version,
823: p_init_msg_list => p_init_msg_list,
824: x_return_status => x_return_status,
825: x_msg_count => x_msg_count,

Line 831: OKE_NOTE_PVT.delete_row(

827: p_del_id => p_del_id);
828:
829:
830: ElsIf (p_cle_id IS NOT NULL) Then
831: OKE_NOTE_PVT.delete_row(
832: p_api_version => p_api_version,
833: p_init_msg_list => p_init_msg_list,
834: x_return_status => x_return_status,
835: x_msg_count => x_msg_count,

Line 841: OKE_NOTE_PVT.delete_row(

837: p_cle_id => p_cle_id);
838:
839:
840: ElsIf (p_hdr_id IS NOT NULL) Then
841: OKE_NOTE_PVT.delete_row(
842: p_api_version => p_api_version,
843: p_init_msg_list => p_init_msg_list,
844: x_return_status => x_return_status,
845: x_msg_count => x_msg_count,

Line 909: l_note_tbl oke_note_pvt.note_tbl_type;

905: p_to_del_id IN NUMBER,
906: default_flag IN VARCHAR2
907: ) IS
908:
909: l_note_tbl oke_note_pvt.note_tbl_type;
910: l_note_rec oke_note_pvt.note_rec_type;
911: l_api_name CONSTANT VARCHAR2(30) := 'COPY_STANDARD_NOTE';
912: l_api_version CONSTANT NUMBER := 1.0;
913: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 910: l_note_rec oke_note_pvt.note_rec_type;

906: default_flag IN VARCHAR2
907: ) IS
908:
909: l_note_tbl oke_note_pvt.note_tbl_type;
910: l_note_rec oke_note_pvt.note_rec_type;
911: l_api_name CONSTANT VARCHAR2(30) := 'COPY_STANDARD_NOTE';
912: l_api_version CONSTANT NUMBER := 1.0;
913: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
914: l_rec_num NUMBER:=0;

Line 916: x_note_tbl oke_note_pvt.note_tbl_type;

912: l_api_version CONSTANT NUMBER := 1.0;
913: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
914: l_rec_num NUMBER:=0;
915:
916: x_note_tbl oke_note_pvt.note_tbl_type;
917:
918:
919: CURSOR note_del_csr (p_id IN NUMBER) IS
920: SELECT unique

Line 1121: OKE_NOTE_PVT.Insert_Row(

1117:
1118: CLOSE note_hdr_csr;
1119:
1120:
1121: OKE_NOTE_PVT.Insert_Row(
1122: p_api_version => p_api_version,
1123: p_init_msg_list => p_init_msg_list,
1124: x_return_status => x_return_status,
1125: x_msg_count => x_msg_count,

Line 1206: OKE_NOTE_PVT.Insert_Row(

1202: END LOOP;
1203: CLOSE note_cle_csr;
1204:
1205:
1206: OKE_NOTE_PVT.Insert_Row(
1207: p_api_version => p_api_version,
1208: p_init_msg_list => p_init_msg_list,
1209: x_return_status => x_return_status,
1210: x_msg_count => x_msg_count,

Line 1290: OKE_NOTE_PVT.Insert_Row(

1286:
1287: END LOOP;
1288: CLOSE note_del_csr;
1289:
1290: OKE_NOTE_PVT.Insert_Row(
1291: p_api_version => p_api_version,
1292: p_init_msg_list => p_init_msg_list,
1293: x_return_status => x_return_status,
1294: x_msg_count => x_msg_count,

Line 1349: p_note_rec IN OKE_NOTE_PVT.note_rec_type) IS

1345: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1346: x_return_status OUT NOCOPY VARCHAR2,
1347: x_msg_count OUT NOCOPY NUMBER,
1348: x_msg_data OUT NOCOPY VARCHAR2,
1349: p_note_rec IN OKE_NOTE_PVT.note_rec_type) IS
1350:
1351:
1352: l_del_rec oke_deliverable_pvt.del_rec_type;
1353: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';

Line 1374: OKE_NOTE_PVT.Lock_Row(

1370: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1371: raise OKE_API.G_EXCEPTION_ERROR;
1372: End If;
1373:
1374: OKE_NOTE_PVT.Lock_Row(
1375: p_api_version => p_api_version,
1376: p_init_msg_list => p_init_msg_list,
1377: x_return_status => x_return_status,
1378: x_msg_count => x_msg_count,

Line 1427: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

1423: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1424: x_return_status OUT NOCOPY VARCHAR2,
1425: x_msg_count OUT NOCOPY NUMBER,
1426: x_msg_data OUT NOCOPY VARCHAR2,
1427: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
1428:
1429: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';
1430: l_api_version CONSTANT NUMBER := 1.0;
1431: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1457: OKE_NOTE_PVT.lock_row(

1453: If (p_note_tbl.COUNT > 0) Then
1454: i := p_note_tbl.FIRST;
1455: LOOP
1456: -- call procedure in complex API
1457: OKE_NOTE_PVT.lock_row(
1458: p_api_version => p_api_version,
1459: p_init_msg_list => p_init_msg_list,
1460: x_return_status => x_return_status,
1461: x_msg_count => x_msg_count,