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 46: OKE_NOTE_PVT.Insert_Row(

42: l_note_rec := p_note_rec;
43:
44: -- call procedure in complex API
45:
46: OKE_NOTE_PVT.Insert_Row(
47: p_api_version => p_api_version,
48: p_init_msg_list => p_init_msg_list,
49: x_return_status => x_return_status,
50: x_msg_count => x_msg_count,

Line 102: p_note_tbl IN oke_note_pvt.note_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_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;

Line 103: x_note_tbl OUT NOCOPY oke_note_pvt.note_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_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;

Line 110: l_note_tbl oke_note_pvt.note_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_note_tbl oke_note_pvt.note_tbl_type;
111: BEGIN
112: -- call START_ACTIVITY to create savepoint, check compatibility
113: -- and initialize message list
114: l_return_status := OKE_API.START_ACTIVITY(

Line 130: OKE_NOTE_PVT.Insert_Row(

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

Line 184: p_note_rec IN oke_note_pvt.note_rec_type,

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,
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;

Line 185: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS

181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
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;

Line 212: OKE_NOTE_PVT.Update_Row(

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

Line 268: p_note_tbl IN oke_note_pvt.note_tbl_type,

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,
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;

Line 269: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS

265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
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;

Line 297: OKE_NOTE_PVT.Update_Row(

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

Line 355: p_note_rec IN oke_note_pvt.note_rec_type) IS

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,
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;

Line 357: l_note_rec oke_note_pvt.note_rec_type;

353: x_msg_count OUT NOCOPY NUMBER,
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:

Line 386: OKE_NOTE_PVT.Validate_Row(

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

Line 440: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

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,
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;

Line 448: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;

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;
447: i NUMBER;
448: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;
449: BEGIN
450: -- call START_ACTIVITY to create savepoint, check compatibility
451: -- and initialize message list
452: l_return_status := OKE_API.START_ACTIVITY(

Line 469: OKE_NOTE_PVT.Validate_Row(

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

Line 527: p_note_rec IN oke_note_pvt.note_rec_type) IS

523: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
524: x_return_status OUT NOCOPY VARCHAR2,
525: x_msg_count OUT NOCOPY NUMBER,
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;

Line 529: l_note_rec oke_note_pvt.note_rec_type;

525: x_msg_count OUT NOCOPY NUMBER,
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

Line 556: OKE_NOTE_PVT.delete_row(

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

Line 610: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

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,
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;

Line 637: OKE_NOTE_PVT.Delete_Row(

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

Line 694: l_note_rec oke_note_pvt.note_rec_type;

690: x_msg_count OUT NOCOPY NUMBER,
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;

Line 734: OKE_NOTE_PVT.delete_row(

730: l_note_rec.STANDARD_NOTES_ID := p_note_id;
731:
732: -- call complex api
733:
734: OKE_NOTE_PVT.delete_row(
735: p_api_version => p_api_version,
736: p_init_msg_list => p_init_msg_list,
737: x_return_status => x_return_status,
738: x_msg_count => x_msg_count,

Line 795: l_note_rec oke_note_pvt.note_rec_type;

791: p_hdr_id IN NUMBER,
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;

Line 822: OKE_NOTE_PVT.delete_row(

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

Line 832: OKE_NOTE_PVT.delete_row(

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

Line 842: OKE_NOTE_PVT.delete_row(

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

Line 910: l_note_tbl oke_note_pvt.note_tbl_type;

906: p_to_del_id IN NUMBER,
907: default_flag IN VARCHAR2
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;

Line 911: l_note_rec oke_note_pvt.note_rec_type;

907: default_flag IN VARCHAR2
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;

Line 917: x_note_tbl oke_note_pvt.note_tbl_type;

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:
917: x_note_tbl oke_note_pvt.note_tbl_type;
918:
919:
920: CURSOR note_del_csr (p_id IN NUMBER) IS
921: SELECT unique

Line 1122: OKE_NOTE_PVT.Insert_Row(

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

Line 1207: OKE_NOTE_PVT.Insert_Row(

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

Line 1291: OKE_NOTE_PVT.Insert_Row(

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

Line 1350: p_note_rec IN OKE_NOTE_PVT.note_rec_type) IS

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,
1349: x_msg_data OUT NOCOPY VARCHAR2,
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';

Line 1375: OKE_NOTE_PVT.Lock_Row(

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

Line 1428: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

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,
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;

Line 1458: OKE_NOTE_PVT.lock_row(

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