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.OKL_TXL_ITM_INSTS_PUB dependencies on OKC_API

Line 14: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

10: -- Parameters :
11: -- Version : 1.0
12: -- End of comments
13: PROCEDURE create_txl_itm_insts(p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15: x_return_status OUT NOCOPY VARCHAR2,
16: x_msg_count OUT NOCOPY NUMBER,
17: x_msg_data OUT NOCOPY VARCHAR2,
18: p_iipv_rec IN iipv_rec_type,

Line 93: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

89: -- End of comments
90:
91: PROCEDURE create_txl_itm_insts(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_iipv_tbl IN iipv_tbl_type,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: -- Parameters :
155: -- Version : 1.0
156: -- End of comments
157: PROCEDURE update_txl_itm_insts(p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_iipv_rec IN iipv_rec_type,

Line 237: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

233: -- End of comments
234:
235: PROCEDURE update_txl_itm_insts(
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: p_iipv_tbl IN iipv_tbl_type,

Line 302: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

298: -- Parameters :
299: -- Version : 1.0
300: -- End of comments
301: PROCEDURE delete_txl_itm_insts(p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_iipv_rec IN iipv_rec_type) IS

Line 378: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

374: -- End of comments
375:
376: PROCEDURE delete_txl_itm_insts(
377: p_api_version IN NUMBER,
378: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
379: x_return_status OUT NOCOPY VARCHAR2,
380: x_msg_count OUT NOCOPY NUMBER,
381: x_msg_data OUT NOCOPY VARCHAR2,
382: p_iipv_tbl IN iipv_tbl_type) IS

Line 442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

438: -- Parameters :
439: -- Version : 1.0
440: -- End of comments
441: PROCEDURE validate_txl_itm_insts(p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
443: x_return_status OUT NOCOPY VARCHAR2,
444: x_msg_count OUT NOCOPY NUMBER,
445: x_msg_data OUT NOCOPY VARCHAR2,
446: p_iipv_rec IN iipv_rec_type) IS

Line 518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

514: -- End of comments
515:
516: PROCEDURE validate_txl_itm_insts(
517: p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,
521: x_msg_data OUT NOCOPY VARCHAR2,
522: p_iipv_tbl IN iipv_tbl_type) IS

Line 582: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

578: -- Parameters :
579: -- Version : 1.0
580: -- End of comments
581: PROCEDURE lock_txl_itm_insts(p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,
586: p_iipv_rec IN iipv_rec_type) IS

Line 653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

649: -- End of comments
650:
651: PROCEDURE lock_txl_itm_insts(
652: p_api_version IN NUMBER,
653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
654: x_return_status OUT NOCOPY VARCHAR2,
655: x_msg_count OUT NOCOPY NUMBER,
656: x_msg_data OUT NOCOPY VARCHAR2,
657: p_iipv_tbl IN iipv_tbl_type) IS

Line 737: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

733: -- End of comments
734:
735: PROCEDURE reset_item_srl_number(
736: p_api_version IN NUMBER,
737: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
738: x_return_status OUT NOCOPY VARCHAR2,
739: x_msg_count OUT NOCOPY NUMBER,
740: x_msg_data OUT NOCOPY VARCHAR2,
741: p_chr_id IN NUMBER,

Line 754: l_return_status := OKC_API.START_ACTIVITY (l_api_name

750: x_return_status := OKL_API.G_RET_STS_SUCCESS;
751:
752: -- Call start_activity to create savepoint, check compatibility
753: -- and initialize message list
754: l_return_status := OKC_API.START_ACTIVITY (l_api_name
755: ,p_init_msg_list
756: ,'_PUB'
757: ,x_return_status);
758: -- Check if activity started successfully

Line 759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

755: ,p_init_msg_list
756: ,'_PUB'
757: ,x_return_status);
758: -- Check if activity started successfully
759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
762: RAISE OKC_API.G_EXCEPTION_ERROR;
763: END IF;

Line 760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

756: ,'_PUB'
757: ,x_return_status);
758: -- Check if activity started successfully
759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
762: RAISE OKC_API.G_EXCEPTION_ERROR;
763: END IF;
764:

Line 761: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

757: ,x_return_status);
758: -- Check if activity started successfully
759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
762: RAISE OKC_API.G_EXCEPTION_ERROR;
763: END IF;
764:
765: okl_txl_itm_insts_pvt.reset_item_srl_number (

Line 762: RAISE OKC_API.G_EXCEPTION_ERROR;

758: -- Check if activity started successfully
759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
762: RAISE OKC_API.G_EXCEPTION_ERROR;
763: END IF;
764:
765: okl_txl_itm_insts_pvt.reset_item_srl_number (
766: p_api_version => p_api_version,

Line 775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

771: p_chr_id => p_chr_id,
772: p_asset_line_id => p_asset_line_id
773: );
774:
775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;

Line 776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

772: p_asset_line_id => p_asset_line_id
773: );
774:
775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780:

Line 777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

773: );
774:
775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780:
781: OKC_API.END_ACTIVITY (x_msg_count

Line 778: RAISE OKC_API.G_EXCEPTION_ERROR;

774:
775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780:
781: OKC_API.END_ACTIVITY (x_msg_count
782: ,x_msg_data );

Line 781: OKC_API.END_ACTIVITY (x_msg_count

777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780:
781: OKC_API.END_ACTIVITY (x_msg_count
782: ,x_msg_data );
783:
784: EXCEPTION
785:

Line 786: WHEN OKC_API.G_EXCEPTION_ERROR THEN

782: ,x_msg_data );
783:
784: EXCEPTION
785:
786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS
788: (l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',

Line 787: x_return_status := OKC_API.HANDLE_EXCEPTIONS

783:
784: EXCEPTION
785:
786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS
788: (l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,

Line 790: 'OKC_API.G_RET_STS_ERROR',

786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS
788: (l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,
792: x_msg_data,
793: '_PUB');
794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,
792: x_msg_data,
793: '_PUB');
794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
796: (l_api_name,
797: G_PKG_NAME,
798: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

791: x_msg_count,
792: x_msg_data,
793: '_PUB');
794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
796: (l_api_name,
797: G_PKG_NAME,
798: 'OKC_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count,

Line 798: 'OKC_API.G_RET_STS_UNEXP_ERROR',

794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
796: (l_api_name,
797: G_PKG_NAME,
798: 'OKC_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count,
800: x_msg_data,
801: '_PUB');
802: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 802: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

798: 'OKC_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count,
800: x_msg_data,
801: '_PUB');
802: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
803: (l_api_name,
804: G_PKG_NAME,
805: 'OTHERS',
806: x_msg_count,