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 50: OKE_FORM_PVT.Insert_Row(

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

Line 108: p_form_tbl IN oke_form_pvt.form_tbl_type,

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

Line 109: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS

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

Line 116: l_form_tbl oke_form_pvt.form_tbl_type;

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

Line 136: OKE_FORM_PVT.Insert_Row(

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

Line 190: p_form_rec IN oke_form_pvt.form_rec_type,

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

Line 191: x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS

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

Line 219: OKE_FORM_PVT.Update_Row(

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

Line 275: p_form_tbl IN oke_form_pvt.form_tbl_type,

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

Line 276: x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS

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

Line 308: OKE_FORM_PVT.Update_Row(

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

Line 366: p_form_rec IN oke_form_pvt.form_rec_type) IS

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

Line 368: l_form_rec oke_form_pvt.form_rec_type;

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

Line 397: OKE_FORM_PVT.Validate_Row(

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

Line 451: p_form_tbl IN oke_form_pvt.form_tbl_type) IS

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

Line 459: l_form_tbl oke_form_pvt.form_tbl_type := p_form_tbl;

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

Line 480: OKE_FORM_PVT.Validate_Row(

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

Line 538: p_form_rec IN oke_form_pvt.form_rec_type) IS

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

Line 540: l_form_rec oke_form_pvt.form_rec_type;

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

Line 567: OKE_FORM_PVT.delete_row(

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

Line 622: p_form_tbl IN oke_form_pvt.form_tbl_type) IS

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

Line 649: OKE_FORM_PVT.Delete_Row(

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

Line 709: l_form_rec oke_form_pvt.form_rec_type;

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

Line 736: OKE_FORM_PVT.delete_row(

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

Line 747: OKE_FORM_PVT.delete_row(

743: p_pfm_cd => p_pfm_cd);
744:
745:
746: Else
747: OKE_FORM_PVT.delete_row(
748: p_api_version => p_api_version,
749: p_init_msg_list => p_init_msg_list,
750: x_return_status => x_return_status,
751: x_msg_count => x_msg_count,

Line 814: l_form_tbl oke_form_pvt.form_tbl_type;

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

Line 815: l_form_rec oke_form_pvt.form_rec_type;

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

Line 821: x_form_tbl oke_form_pvt.form_tbl_type;

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

Line 974: OKE_FORM_PVT.Insert_Row(

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

Line 1052: OKE_FORM_PVT.Insert_Row(

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

Line 1111: p_form_rec IN OKE_FORM_PVT.form_rec_type) IS

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

Line 1135: OKE_FORM_PVT.Lock_Row(

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

Line 1188: p_form_tbl IN oke_form_pvt.form_tbl_type) IS

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

Line 1218: OKE_FORM_PVT.lock_row(

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