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 STANDARD

Line 1: PACKAGE BODY OKE_STANDARD_NOTES_PUB AS

1: PACKAGE BODY OKE_STANDARD_NOTES_PUB AS
2: /* $Header: OKEPNOTB.pls 115.11 2002/11/20 20:46:10 who ship $ */
3: g_api_type CONSTANT VARCHAR2(4) := '_PUB';
4:
5: PROCEDURE create_standard_note(

Line 5: PROCEDURE create_standard_note(

1: PACKAGE BODY OKE_STANDARD_NOTES_PUB AS
2: /* $Header: OKEPNOTB.pls 115.11 2002/11/20 20:46:10 who ship $ */
3: g_api_type CONSTANT VARCHAR2(4) := '_PUB';
4:
5: PROCEDURE create_standard_note(
6: p_api_version IN NUMBER,
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,

Line 17: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';

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;
20: l_line_number VARCHAR2(120);
21:

Line 91: END create_standard_note;

87: x_msg_count => x_msg_count,
88: x_msg_data => x_msg_data,
89: p_api_type => g_api_type);
90:
91: END create_standard_note;
92:
93:
94:
95: PROCEDURE create_standard_note(

Line 95: PROCEDURE create_standard_note(

91: END create_standard_note;
92:
93:
94:
95: PROCEDURE create_standard_note(
96: p_api_version IN NUMBER,
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,

Line 104: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';

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;
107: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
108: i NUMBER;

Line 175: END create_standard_note;

171: x_msg_count => x_msg_count,
172: x_msg_data => x_msg_data,
173: p_api_type => g_api_type);
174:
175: END create_standard_note;
176:
177: PROCEDURE update_standard_note(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 177: PROCEDURE update_standard_note(

173: p_api_type => g_api_type);
174:
175: END create_standard_note;
176:
177: PROCEDURE update_standard_note(
178: p_api_version IN NUMBER,
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,

Line 186: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';

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;
189: BEGIN
190: -- call START_ACTIVITY to create savepoint, check compatibility

Line 258: END update_standard_note;

254: x_msg_count => x_msg_count,
255: x_msg_data => x_msg_data,
256: p_api_type => g_api_type);
257:
258: END update_standard_note;
259:
260:
261: PROCEDURE update_standard_note(
262: p_api_version IN NUMBER,

Line 261: PROCEDURE update_standard_note(

257:
258: END update_standard_note;
259:
260:
261: PROCEDURE update_standard_note(
262: p_api_version IN NUMBER,
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,

Line 270: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';

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;
273: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
274: i NUMBER;

Line 344: END update_standard_note;

340: x_msg_count => x_msg_count,
341: x_msg_data => x_msg_data,
342: p_api_type => g_api_type);
343:
344: END update_standard_note;
345:
346:
347:
348: PROCEDURE validate_standard_note(

Line 348: PROCEDURE validate_standard_note(

344: END update_standard_note;
345:
346:
347:
348: PROCEDURE validate_standard_note(
349: p_api_version IN NUMBER,
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,

Line 357: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';

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:
361: BEGIN

Line 431: END validate_standard_note;

427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => g_api_type);
430:
431: END validate_standard_note;
432:
433: PROCEDURE validate_standard_note(
434: p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 433: PROCEDURE validate_standard_note(

429: p_api_type => g_api_type);
430:
431: END validate_standard_note;
432:
433: PROCEDURE validate_standard_note(
434: p_api_version IN NUMBER,
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,

Line 441: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';

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;
444: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
445: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 514: END validate_standard_note;

510: x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data,
512: p_api_type => g_api_type);
513:
514: END validate_standard_note;
515:
516:
517:
518:

Line 519: PROCEDURE delete_standard_note(

515:
516:
517:
518:
519: PROCEDURE delete_standard_note(
520:
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
523: x_return_status OUT NOCOPY VARCHAR2,

Line 529: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';

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
533: -- call START_ACTIVITY to create savepoint, check compatibility

Line 601: END delete_standard_note;

597: x_msg_count => x_msg_count,
598: x_msg_data => x_msg_data,
599: p_api_type => g_api_type);
600:
601: END delete_standard_note;
602:
603: PROCEDURE delete_standard_note(
604: p_api_version IN NUMBER,
605: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 603: PROCEDURE delete_standard_note(

599: p_api_type => g_api_type);
600:
601: END delete_standard_note;
602:
603: PROCEDURE delete_standard_note(
604: p_api_version IN NUMBER,
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,

Line 611: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';

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;
614: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
615: i NUMBER;

Line 682: END delete_standard_note;

678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data,
680: p_api_type => g_api_type);
681:
682: END delete_standard_note;
683:
684: PROCEDURE delete_standard_note(
685:
686: p_api_version IN NUMBER,

Line 684: PROCEDURE delete_standard_note(

680: p_api_type => g_api_type);
681:
682: END delete_standard_note;
683:
684: PROCEDURE delete_standard_note(
685:
686: p_api_version IN NUMBER,
687: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
688: x_return_status OUT NOCOPY VARCHAR2,

Line 694: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';

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;
698: l_check_num2 NUMBER;

Line 719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B

715: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
716: raise OKE_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
720: WHERE STANDARD_NOTES_ID = p_note_id;
721:
722: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
723: WHERE STANDARD_NOTES_ID = p_note_id;

Line 720: WHERE STANDARD_NOTES_ID = p_note_id;

716: raise OKE_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
720: WHERE STANDARD_NOTES_ID = p_note_id;
721:
722: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
723: WHERE STANDARD_NOTES_ID = p_note_id;
724:

Line 722: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL

718:
719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
720: WHERE STANDARD_NOTES_ID = p_note_id;
721:
722: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
723: WHERE STANDARD_NOTES_ID = p_note_id;
724:
725: If(l_check_num1<1)OR(l_check_num2<1) then
726: raise OKE_API.G_EXCEPTION_ERROR;

Line 723: WHERE STANDARD_NOTES_ID = p_note_id;

719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
720: WHERE STANDARD_NOTES_ID = p_note_id;
721:
722: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
723: WHERE STANDARD_NOTES_ID = p_note_id;
724:
725: If(l_check_num1<1)OR(l_check_num2<1) then
726: raise OKE_API.G_EXCEPTION_ERROR;
727: End If;

Line 729: l_note_rec.STANDARD_NOTES_ID := p_note_id;

725: If(l_check_num1<1)OR(l_check_num2<1) then
726: raise OKE_API.G_EXCEPTION_ERROR;
727: End If;
728:
729: l_note_rec.STANDARD_NOTES_ID := p_note_id;
730:
731: -- call complex api
732:
733: OKE_NOTE_PVT.delete_row(

Line 779: END delete_standard_note;

775: x_msg_count => x_msg_count,
776: x_msg_data => x_msg_data,
777: p_api_type => g_api_type);
778:
779: END delete_standard_note;
780:
781:
782:
783: PROCEDURE delete_standard_note(

Line 783: PROCEDURE delete_standard_note(

779: END delete_standard_note;
780:
781:
782:
783: PROCEDURE delete_standard_note(
784:
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
787: x_return_status OUT NOCOPY VARCHAR2,

Line 795: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';

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;
799: l_check_num2 NUMBER;

Line 891: END delete_standard_note;

887: x_msg_count => x_msg_count,
888: x_msg_data => x_msg_data,
889: p_api_type => g_api_type);
890:
891: END delete_standard_note;
892:
893:
894: PROCEDURE copy_standard_note(
895: p_api_version IN NUMBER,

Line 894: PROCEDURE copy_standard_note(

890:
891: END delete_standard_note;
892:
893:
894: PROCEDURE copy_standard_note(
895: p_api_version IN NUMBER,
896: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,

Line 911: l_api_name CONSTANT VARCHAR2(30) := 'COPY_STANDARD_NOTE';

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;
915:

Line 921: b.STANDARD_NOTES_ID ,

917:
918:
919: CURSOR note_del_csr (p_id IN NUMBER) IS
920: SELECT unique
921: b.STANDARD_NOTES_ID ,
922: b.CREATION_DATE ,
923: b.CREATED_BY ,
924: b.LAST_UPDATE_DATE ,
925: b.LAST_UPDATED_BY ,

Line 954: FROM OKE_K_STANDARD_NOTES_VL b

950: b.DESCRIPTION ,
951: b.NAME ,
952: b.TEXT ,
953: b.default_flag
954: FROM OKE_K_STANDARD_NOTES_VL b
955: WHERE b.DELIVERABLE_ID = p_id
956: AND b.LINE_ID IS NULL;
957:
958: CURSOR note_cle_csr (p_id IN NUMBER) IS

Line 960: b.STANDARD_NOTES_ID ,

956: AND b.LINE_ID IS NULL;
957:
958: CURSOR note_cle_csr (p_id IN NUMBER) IS
959: SELECT unique
960: b.STANDARD_NOTES_ID ,
961: b.CREATION_DATE ,
962: b.CREATED_BY ,
963: b.LAST_UPDATE_DATE ,
964: b.LAST_UPDATED_BY ,

Line 991: FROM OKE_K_STANDARD_NOTES_VL B

987: b.DESCRIPTION ,
988: b.NAME ,
989: b.TEXT ,
990: b.default_flag
991: FROM OKE_K_STANDARD_NOTES_VL B
992: WHERE b.LINE_ID = p_id
993: AND b.DELIVERABLE_ID IS NULL;
994:
995: CURSOR note_hdr_csr (p_id IN NUMBER) IS

Line 997: b.STANDARD_NOTES_ID ,

993: AND b.DELIVERABLE_ID IS NULL;
994:
995: CURSOR note_hdr_csr (p_id IN NUMBER) IS
996: SELECT unique
997: b.STANDARD_NOTES_ID ,
998: b.CREATION_DATE ,
999: b.CREATED_BY ,
1000: b.LAST_UPDATE_DATE ,
1001: b.LAST_UPDATED_BY ,

Line 1028: FROM OKE_K_STANDARD_NOTES_VL B

1024: b.DESCRIPTION ,
1025: b.NAME ,
1026: b.TEXT ,
1027: b.default_flag
1028: FROM OKE_K_STANDARD_NOTES_VL B
1029: WHERE b.HEADER_ID = p_id
1030: AND b.DELIVERABLE_ID IS NULL AND b.LINE_ID IS NULL;
1031:
1032: BEGIN

Line 1061: l_note_rec.STANDARD_NOTES_ID ,

1057:
1058: OPEN note_hdr_csr (p_from_hdr_id);
1059: LOOP
1060: FETCH note_hdr_csr INTO
1061: l_note_rec.STANDARD_NOTES_ID ,
1062: l_note_rec.CREATION_DATE ,
1063: l_note_rec.CREATED_BY ,
1064: l_note_rec.LAST_UPDATE_DATE ,
1065: l_note_rec.LAST_UPDATED_BY ,

Line 1146: l_note_rec.STANDARD_NOTES_ID ,

1142:
1143: OPEN note_cle_csr (p_from_cle_id);
1144: LOOP
1145: FETCH note_cle_csr INTO
1146: l_note_rec.STANDARD_NOTES_ID ,
1147: l_note_rec.CREATION_DATE ,
1148: l_note_rec.CREATED_BY ,
1149: l_note_rec.LAST_UPDATE_DATE ,
1150: l_note_rec.LAST_UPDATED_BY ,

Line 1232: l_note_rec.STANDARD_NOTES_ID ,

1228:
1229: OPEN note_del_csr (p_from_del_id);
1230: LOOP
1231: FETCH note_del_csr INTO
1232: l_note_rec.STANDARD_NOTES_ID ,
1233: l_note_rec.CREATION_DATE ,
1234: l_note_rec.CREATED_BY ,
1235: l_note_rec.LAST_UPDATE_DATE ,
1236: l_note_rec.LAST_UPDATED_BY ,

Line 1340: END copy_standard_note;

1336: x_msg_count => x_msg_count,
1337: x_msg_data => x_msg_data,
1338: p_api_type => g_api_type);
1339:
1340: END copy_standard_note;
1341:
1342:
1343: PROCEDURE lock_standard_note(
1344: p_api_version IN NUMBER,

Line 1343: PROCEDURE lock_standard_note(

1339:
1340: END copy_standard_note;
1341:
1342:
1343: PROCEDURE lock_standard_note(
1344: p_api_version IN NUMBER,
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,

Line 1353: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';

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';
1354: l_api_version CONSTANT NUMBER := 1.0;
1355: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1356:
1357: BEGIN

Line 1419: END lock_standard_note;

1415: x_msg_count => x_msg_count,
1416: x_msg_data => x_msg_data,
1417: p_api_type => g_api_type);
1418:
1419: END lock_standard_note;
1420:
1421: PROCEDURE lock_standard_note(
1422: p_api_version IN NUMBER,
1423: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 1421: PROCEDURE lock_standard_note(

1417: p_api_type => g_api_type);
1418:
1419: END lock_standard_note;
1420:
1421: PROCEDURE lock_standard_note(
1422: p_api_version IN NUMBER,
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,

Line 1429: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';

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;
1432: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1433: i NUMBER;

Line 1515: END lock_standard_note;

1511: x_msg_count => x_msg_count,
1512: x_msg_data => x_msg_data,
1513: p_api_type => g_api_type);
1514:
1515: END lock_standard_note;
1516:
1517: END OKE_STANDARD_NOTES_PUB;
1518:

Line 1517: END OKE_STANDARD_NOTES_PUB;

1513: p_api_type => g_api_type);
1514:
1515: END lock_standard_note;
1516:
1517: END OKE_STANDARD_NOTES_PUB;
1518: