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 120.1 2010/04/09 05:29:54 aveeraba 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 120.1 2010/04/09 05:29:54 aveeraba 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: --bug 9354391 modified line_number length to 150 as per table
21: l_line_number VARCHAR2(150);

Line 92: END create_standard_note;

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

Line 96: PROCEDURE create_standard_note(

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

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

101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_note_tbl IN oke_note_pvt.note_tbl_type,
103: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
104:
105: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
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;

Line 176: END create_standard_note;

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

Line 178: PROCEDURE update_standard_note(

174: p_api_type => g_api_type);
175:
176: END create_standard_note;
177:
178: PROCEDURE update_standard_note(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,

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

183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_note_rec IN oke_note_pvt.note_rec_type,
185: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
186:
187: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
188: l_api_version CONSTANT NUMBER := 1.0;
189: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
190: BEGIN
191: -- call START_ACTIVITY to create savepoint, check compatibility

Line 259: END update_standard_note;

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

Line 262: PROCEDURE update_standard_note(

258:
259: END update_standard_note;
260:
261:
262: PROCEDURE update_standard_note(
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,

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

267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_note_tbl IN oke_note_pvt.note_tbl_type,
269: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
270:
271: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
272: l_api_version CONSTANT NUMBER := 1.0;
273: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
274: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
275: i NUMBER;

Line 345: END update_standard_note;

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

Line 349: PROCEDURE validate_standard_note(

345: END update_standard_note;
346:
347:
348:
349: PROCEDURE validate_standard_note(
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,

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

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

Line 432: END validate_standard_note;

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

Line 434: PROCEDURE validate_standard_note(

430: p_api_type => g_api_type);
431:
432: END validate_standard_note;
433:
434: PROCEDURE validate_standard_note(
435: p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,

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

438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
441:
442: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
443:
444: l_api_version CONSTANT NUMBER := 1.0;
445: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
446: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 515: END validate_standard_note;

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

Line 520: PROCEDURE delete_standard_note(

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

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

526: x_msg_data OUT NOCOPY VARCHAR2,
527: p_note_rec IN oke_note_pvt.note_rec_type) IS
528:
529: l_note_rec oke_note_pvt.note_rec_type;
530: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
531: l_api_version CONSTANT NUMBER := 1.0;
532: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
533: BEGIN
534: -- call START_ACTIVITY to create savepoint, check compatibility

Line 602: END delete_standard_note;

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

Line 604: PROCEDURE delete_standard_note(

600: p_api_type => g_api_type);
601:
602: END delete_standard_note;
603:
604: PROCEDURE delete_standard_note(
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,

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

608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
611:
612: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
613: l_api_version CONSTANT NUMBER := 1.0;
614: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
615: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
616: i NUMBER;

Line 683: END delete_standard_note;

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

Line 685: PROCEDURE delete_standard_note(

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

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

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

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

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

Line 721: WHERE STANDARD_NOTES_ID = p_note_id;

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

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

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

Line 724: WHERE STANDARD_NOTES_ID = p_note_id;

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

Line 730: l_note_rec.STANDARD_NOTES_ID := p_note_id;

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

Line 780: END delete_standard_note;

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

Line 784: PROCEDURE delete_standard_note(

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

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

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

Line 892: END delete_standard_note;

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

Line 895: PROCEDURE copy_standard_note(

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

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

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

Line 922: b.STANDARD_NOTES_ID ,

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

Line 955: FROM OKE_K_STANDARD_NOTES_VL b

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

Line 961: b.STANDARD_NOTES_ID ,

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

Line 992: FROM OKE_K_STANDARD_NOTES_VL B

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

Line 998: b.STANDARD_NOTES_ID ,

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

Line 1029: FROM OKE_K_STANDARD_NOTES_VL B

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

Line 1062: l_note_rec.STANDARD_NOTES_ID ,

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

Line 1147: l_note_rec.STANDARD_NOTES_ID ,

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

Line 1233: l_note_rec.STANDARD_NOTES_ID ,

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

Line 1341: END copy_standard_note;

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

Line 1344: PROCEDURE lock_standard_note(

1340:
1341: END copy_standard_note;
1342:
1343:
1344: PROCEDURE lock_standard_note(
1345: p_api_version IN NUMBER,
1346: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1347: x_return_status OUT NOCOPY VARCHAR2,
1348: x_msg_count OUT NOCOPY NUMBER,

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

1350: p_note_rec IN OKE_NOTE_PVT.note_rec_type) IS
1351:
1352:
1353: l_del_rec oke_deliverable_pvt.del_rec_type;
1354: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';
1355: l_api_version CONSTANT NUMBER := 1.0;
1356: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1357:
1358: BEGIN

Line 1420: END lock_standard_note;

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

Line 1422: PROCEDURE lock_standard_note(

1418: p_api_type => g_api_type);
1419:
1420: END lock_standard_note;
1421:
1422: PROCEDURE lock_standard_note(
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1425: x_return_status OUT NOCOPY VARCHAR2,
1426: x_msg_count OUT NOCOPY NUMBER,

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

1426: x_msg_count OUT NOCOPY NUMBER,
1427: x_msg_data OUT NOCOPY VARCHAR2,
1428: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
1429:
1430: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';
1431: l_api_version CONSTANT NUMBER := 1.0;
1432: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1433: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1434: i NUMBER;

Line 1516: END lock_standard_note;

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

Line 1518: END OKE_STANDARD_NOTES_PUB;

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