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_K_PRINT_FORMS_PUB dependencies on OKE_FORM_PVT

Line 13: p_form_rec IN oke_form_pvt.form_rec_type,

9: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_form_rec IN oke_form_pvt.form_rec_type,
14: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS
15:
16:
17: l_form_rec oke_form_pvt.form_rec_type;

Line 14: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS

10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_form_rec IN oke_form_pvt.form_rec_type,
14: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS
15:
16:
17: l_form_rec oke_form_pvt.form_rec_type;
18:

Line 17: l_form_rec oke_form_pvt.form_rec_type;

13: p_form_rec IN oke_form_pvt.form_rec_type,
14: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS
15:
16:
17: l_form_rec oke_form_pvt.form_rec_type;
18:
19: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PRINT_FORM';
20: l_api_version CONSTANT NUMBER := 1.0;
21: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 49: OKE_FORM_PVT.Insert_Row(

45: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call forms pvt');
46:
47: -- call procedure in complex API
48:
49: OKE_FORM_PVT.Insert_Row(
50: p_api_version => p_api_version,
51: p_init_msg_list => p_init_msg_list,
52: x_return_status => x_return_status,
53: x_msg_count => x_msg_count,

Line 107: p_form_tbl IN oke_form_pvt.form_tbl_type,

103: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_form_tbl IN oke_form_pvt.form_tbl_type,
108: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS
109:
110: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PRINT_FORM';
111: l_api_version CONSTANT NUMBER := 1.0;

Line 108: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS

104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_form_tbl IN oke_form_pvt.form_tbl_type,
108: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS
109:
110: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PRINT_FORM';
111: l_api_version CONSTANT NUMBER := 1.0;
112: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 115: l_form_tbl oke_form_pvt.form_tbl_type;

111: l_api_version CONSTANT NUMBER := 1.0;
112: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
113: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
114: i NUMBER;
115: l_form_tbl oke_form_pvt.form_tbl_type;
116: BEGIN
117: -- call START_ACTIVITY to create savepoint, check compatibility
118: -- and initialize message list
119: l_return_status := OKE_API.START_ACTIVITY(

Line 135: OKE_FORM_PVT.Insert_Row(

131: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
132: raise OKE_API.G_EXCEPTION_ERROR;
133: End If;
134:
135: OKE_FORM_PVT.Insert_Row(
136: p_api_version => p_api_version,
137: p_init_msg_list => p_init_msg_list,
138: x_return_status => x_return_status,
139: x_msg_count => x_msg_count,

Line 189: p_form_rec IN oke_form_pvt.form_rec_type,

185: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_form_rec IN oke_form_pvt.form_rec_type,
190: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS
191:
192: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRINT_FORM';
193: l_api_version CONSTANT NUMBER := 1.0;

Line 190: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS

186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_form_rec IN oke_form_pvt.form_rec_type,
190: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS
191:
192: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRINT_FORM';
193: l_api_version CONSTANT NUMBER := 1.0;
194: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 218: OKE_FORM_PVT.Update_Row(

214: End If;
215:
216: -- call complex api
217: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'PUB.going to call pvt_update_row');
218: OKE_FORM_PVT.Update_Row(
219: p_api_version => p_api_version,
220: p_init_msg_list => p_init_msg_list,
221: x_return_status => x_return_status,
222: x_msg_count => x_msg_count,

Line 274: p_form_tbl IN oke_form_pvt.form_tbl_type,

270: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_form_tbl IN oke_form_pvt.form_tbl_type,
275: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS
276:
277: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRINT_FORM';
278: l_api_version CONSTANT NUMBER := 1.0;

Line 275: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS

271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_form_tbl IN oke_form_pvt.form_tbl_type,
275: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS
276:
277: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRINT_FORM';
278: l_api_version CONSTANT NUMBER := 1.0;
279: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 307: OKE_FORM_PVT.Update_Row(

303: End If;
304:
305: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'PUB.going to call PVT.update_row table version');
306:
307: OKE_FORM_PVT.Update_Row(
308: p_api_version => p_api_version,
309: p_init_msg_list => p_init_msg_list,
310: x_return_status => x_return_status,
311: x_msg_count => x_msg_count,

Line 365: p_form_rec IN oke_form_pvt.form_rec_type) IS

361: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY NUMBER,
364: x_msg_data OUT NOCOPY VARCHAR2,
365: p_form_rec IN oke_form_pvt.form_rec_type) IS
366:
367: l_form_rec oke_form_pvt.form_rec_type;
368: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PRINT_FORM';
369: l_api_version CONSTANT NUMBER := 1.0;

Line 367: l_form_rec oke_form_pvt.form_rec_type;

363: x_msg_count OUT NOCOPY NUMBER,
364: x_msg_data OUT NOCOPY VARCHAR2,
365: p_form_rec IN oke_form_pvt.form_rec_type) IS
366:
367: l_form_rec oke_form_pvt.form_rec_type;
368: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PRINT_FORM';
369: l_api_version CONSTANT NUMBER := 1.0;
370: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
371:

Line 396: OKE_FORM_PVT.Validate_Row(

392: l_form_rec := p_form_rec;
393:
394: -- call complex API
395:
396: OKE_FORM_PVT.Validate_Row(
397: p_api_version => p_api_version,
398: p_init_msg_list => p_init_msg_list,
399: x_return_status => x_return_status,
400: x_msg_count => x_msg_count,

Line 450: p_form_tbl IN oke_form_pvt.form_tbl_type) IS

446: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2,
450: p_form_tbl IN oke_form_pvt.form_tbl_type) IS
451:
452: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PRINT_FORM';
453:
454: l_api_version CONSTANT NUMBER := 1.0;

Line 458: l_form_tbl oke_form_pvt.form_tbl_type := p_form_tbl;

454: l_api_version CONSTANT NUMBER := 1.0;
455: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
456: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
457: i NUMBER;
458: l_form_tbl oke_form_pvt.form_tbl_type := p_form_tbl;
459: BEGIN
460: -- call START_ACTIVITY to create savepoint, check compatibility
461: -- and initialize message list
462: l_return_status := OKE_API.START_ACTIVITY(

Line 479: OKE_FORM_PVT.Validate_Row(

475: raise OKE_API.G_EXCEPTION_ERROR;
476: End If;
477:
478:
479: OKE_FORM_PVT.Validate_Row(
480: p_api_version => p_api_version,
481: p_init_msg_list => p_init_msg_list,
482: x_return_status => x_return_status,
483: x_msg_count => x_msg_count,

Line 537: p_form_rec IN oke_form_pvt.form_rec_type) IS

533: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: p_form_rec IN oke_form_pvt.form_rec_type) IS
538:
539: l_form_rec oke_form_pvt.form_rec_type;
540: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
541: l_api_version CONSTANT NUMBER := 1.0;

Line 539: l_form_rec oke_form_pvt.form_rec_type;

535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: p_form_rec IN oke_form_pvt.form_rec_type) IS
538:
539: l_form_rec oke_form_pvt.form_rec_type;
540: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
541: l_api_version CONSTANT NUMBER := 1.0;
542: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
543: BEGIN

Line 566: OKE_FORM_PVT.delete_row(

562: l_form_rec := p_form_rec;
563:
564: -- call complex api
565:
566: OKE_FORM_PVT.delete_row(
567: p_api_version => p_api_version,
568: p_init_msg_list => p_init_msg_list,
569: x_return_status => x_return_status,
570: x_msg_count => x_msg_count,

Line 621: p_form_tbl IN oke_form_pvt.form_tbl_type) IS

617: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
618: x_return_status OUT NOCOPY VARCHAR2,
619: x_msg_count OUT NOCOPY NUMBER,
620: x_msg_data OUT NOCOPY VARCHAR2,
621: p_form_tbl IN oke_form_pvt.form_tbl_type) IS
622:
623: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
624: l_api_version CONSTANT NUMBER := 1.0;
625: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 648: OKE_FORM_PVT.Delete_Row(

644: raise OKE_API.G_EXCEPTION_ERROR;
645: End If;
646:
647:
648: OKE_FORM_PVT.Delete_Row(
649: p_api_version => p_api_version,
650: p_init_msg_list => p_init_msg_list,
651: x_return_status => x_return_status,
652: x_msg_count => x_msg_count,

Line 708: l_form_rec oke_form_pvt.form_rec_type;

704: p_chr_id IN NUMBER,
705: p_cle_id IN NUMBER,
706: p_pfm_cd IN OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE ) IS
707:
708: l_form_rec oke_form_pvt.form_rec_type;
709: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
710: l_api_version CONSTANT NUMBER := 1.0;
711: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
712: l_check_num1 NUMBER;

Line 735: OKE_FORM_PVT.delete_row(

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

Line 746: OKE_FORM_PVT.delete_row(

742: p_pfm_cd => p_pfm_cd);
743:
744:
745: Else
746: OKE_FORM_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 813: l_form_tbl oke_form_pvt.form_tbl_type;

809: p_from_cle_id IN NUMBER,
810: p_to_cle_id IN NUMBER
811: ) IS
812:
813: l_form_tbl oke_form_pvt.form_tbl_type;
814: l_form_rec oke_form_pvt.form_rec_type;
815: l_api_name CONSTANT VARCHAR2(30) := 'COPY_PRINT_FORM';
816: l_api_version CONSTANT NUMBER := 1.0;
817: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 814: l_form_rec oke_form_pvt.form_rec_type;

810: p_to_cle_id IN NUMBER
811: ) IS
812:
813: l_form_tbl oke_form_pvt.form_tbl_type;
814: l_form_rec oke_form_pvt.form_rec_type;
815: l_api_name CONSTANT VARCHAR2(30) := 'COPY_PRINT_FORM';
816: l_api_version CONSTANT NUMBER := 1.0;
817: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
818: l_rec_num NUMBER:=0;

Line 820: x_form_tbl oke_form_pvt.form_tbl_type;

816: l_api_version CONSTANT NUMBER := 1.0;
817: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
818: l_rec_num NUMBER:=0;
819:
820: x_form_tbl oke_form_pvt.form_tbl_type;
821:
822: CURSOR form_cle_csr (p_id IN NUMBER) IS
823: SELECT
824: b.K_HEADER_ID ,

Line 973: OKE_FORM_PVT.Insert_Row(

969: END LOOP;
970: CLOSE form_chr_csr;
971:
972: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'print FORMS inserting std form');
973: OKE_FORM_PVT.Insert_Row(
974: p_api_version => p_api_version,
975: p_init_msg_list => p_init_msg_list,
976: x_return_status => x_return_status,
977: x_msg_count => x_msg_count,

Line 1051: OKE_FORM_PVT.Insert_Row(

1047: END LOOP;
1048: CLOSE form_cle_csr;
1049:
1050: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'print form inserting std form');
1051: OKE_FORM_PVT.Insert_Row(
1052: p_api_version => p_api_version,
1053: p_init_msg_list => p_init_msg_list,
1054: x_return_status => x_return_status,
1055: x_msg_count => x_msg_count,

Line 1110: p_form_rec IN OKE_FORM_PVT.form_rec_type) IS

1106: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1107: x_return_status OUT NOCOPY VARCHAR2,
1108: x_msg_count OUT NOCOPY NUMBER,
1109: x_msg_data OUT NOCOPY VARCHAR2,
1110: p_form_rec IN OKE_FORM_PVT.form_rec_type) IS
1111:
1112:
1113: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PRINT_FORM';
1114: l_api_version CONSTANT NUMBER := 1.0;

Line 1134: OKE_FORM_PVT.Lock_Row(

1130: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1131: raise OKE_API.G_EXCEPTION_ERROR;
1132: End If;
1133:
1134: OKE_FORM_PVT.Lock_Row(
1135: p_api_version => p_api_version,
1136: p_init_msg_list => p_init_msg_list,
1137: x_return_status => x_return_status,
1138: x_msg_count => x_msg_count,

Line 1187: p_form_tbl IN oke_form_pvt.form_tbl_type) IS

1183: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1184: x_return_status OUT NOCOPY VARCHAR2,
1185: x_msg_count OUT NOCOPY NUMBER,
1186: x_msg_data OUT NOCOPY VARCHAR2,
1187: p_form_tbl IN oke_form_pvt.form_tbl_type) IS
1188:
1189: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PRINT_FORM';
1190: l_api_version CONSTANT NUMBER := 1.0;
1191: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1217: OKE_FORM_PVT.lock_row(

1213: If (p_form_tbl.COUNT > 0) Then
1214: i := p_form_tbl.FIRST;
1215: LOOP
1216: -- call procedure in complex API
1217: OKE_FORM_PVT.lock_row(
1218: p_api_version => p_api_version,
1219: p_init_msg_list => p_init_msg_list,
1220: x_return_status => x_return_status,
1221: x_msg_count => x_msg_count,