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_TXD_ASSETS_PUB dependencies on OKC_API

Line 13: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9: -- Version : 1.0
10: -- End of comments
11: PROCEDURE create_txd_asset_def(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,
17: p_adpv_rec IN adpv_rec_type,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88: -- End of comments
89:
90: PROCEDURE create_txd_asset_def(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_adpv_tbl IN adpv_tbl_type,

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153: -- Version : 1.0
154: -- End of comments
155: PROCEDURE update_txd_asset_Def(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_adpv_rec IN adpv_rec_type,

Line 164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_adpv_rec IN adpv_rec_type,
162: x_adpv_rec OUT NOCOPY adpv_rec_type) IS
163: l_adpv_rec adpv_rec_type;
164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
165: l_api_name CONSTANT VARCHAR2(30) := 'update_txd_asset_Def';
166: l_api_version CONSTANT NUMBER := 1;
167: BEGIN
168: savepoint update_txd_asset_Def_pub;

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: -- Version : 1.0
232: -- End of comments
233: PROCEDURE update_txd_asset_Def(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_adpv_tbl IN adpv_tbl_type,

Line 242: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_adpv_tbl IN adpv_tbl_type,
240: x_adpv_tbl OUT NOCOPY adpv_tbl_type) IS
241: i NUMBER := 0;
242: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
243: BEGIN
244: x_return_status := OKC_API.G_RET_STS_SUCCESS;
245: IF p_adpv_tbl.COUNT > 0 THEN
246: i := p_adpv_tbl.FIRST;

Line 244: x_return_status := OKC_API.G_RET_STS_SUCCESS;

240: x_adpv_tbl OUT NOCOPY adpv_tbl_type) IS
241: i NUMBER := 0;
242: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
243: BEGIN
244: x_return_status := OKC_API.G_RET_STS_SUCCESS;
245: IF p_adpv_tbl.COUNT > 0 THEN
246: i := p_adpv_tbl.FIRST;
247: LOOP
248: update_txd_asset_Def(

Line 298: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

294: -- Version : 1.0
295: -- End of comments
296: PROCEDURE delete_txd_asset_Def(
297: p_api_version IN NUMBER,
298: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_adpv_rec IN adpv_rec_type) IS

Line 305: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_adpv_rec IN adpv_rec_type) IS
303:
304: l_adpv_rec adpv_rec_type;
305: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
306: l_api_name CONSTANT VARCHAR2(30) := 'delete_txd_asset_Def';
307: l_api_version CONSTANT NUMBER := 1;
308: BEGIN
309: savepoint delete_txd_asset_Def_pub;

Line 373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

369: -- Version : 1.0
370: -- End of comments
371: PROCEDURE delete_txd_asset_Def(
372: p_api_version IN NUMBER,
373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2,
377: p_adpv_tbl IN adpv_tbl_type) IS

Line 379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2,
377: p_adpv_tbl IN adpv_tbl_type) IS
378: i NUMBER := 0;
379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
380: BEGIN
381: x_return_status := OKC_API.G_RET_STS_SUCCESS;
382: IF p_adpv_tbl.COUNT > 0 THEN
383: i := p_adpv_tbl.FIRST;

Line 381: x_return_status := OKC_API.G_RET_STS_SUCCESS;

377: p_adpv_tbl IN adpv_tbl_type) IS
378: i NUMBER := 0;
379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
380: BEGIN
381: x_return_status := OKC_API.G_RET_STS_SUCCESS;
382: IF p_adpv_tbl.COUNT > 0 THEN
383: i := p_adpv_tbl.FIRST;
384: LOOP
385: delete_txd_asset_Def(

Line 392: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

388: x_return_status => l_return_status,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_adpv_rec => p_adpv_tbl(i));
392: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
394: x_return_status := l_return_status;
395: raise G_EXCEPTION_HALT_VALIDATION;
396: ELSE

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

389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_adpv_rec => p_adpv_tbl(i));
392: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
394: x_return_status := l_return_status;
395: raise G_EXCEPTION_HALT_VALIDATION;
396: ELSE
397: x_return_status := l_return_status;

Line 434: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

430: -- Version : 1.0
431: -- End of comments
432: procedure lock_txd_asset_Def(
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_msg_count OUT NOCOPY NUMBER,
437: x_msg_data OUT NOCOPY VARCHAR2,
438: p_adpv_rec IN adpv_rec_type) IS

Line 440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

436: x_msg_count OUT NOCOPY NUMBER,
437: x_msg_data OUT NOCOPY VARCHAR2,
438: p_adpv_rec IN adpv_rec_type) IS
439: l_adpv_rec adpv_rec_type;
440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
441: l_api_name CONSTANT VARCHAR2(30) := 'lock_txd_asset_Def';
442: l_api_version CONSTANT NUMBER := 1;
443: BEGIN
444: savepoint lock_txd_asset_Def_pub;

Line 504: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

500: -- Version : 1.0
501: -- End of comments
502: procedure lock_txd_asset_Def(
503: p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
505: x_return_status OUT NOCOPY VARCHAR2,
506: x_msg_count OUT NOCOPY NUMBER,
507: x_msg_data OUT NOCOPY VARCHAR2,
508: p_adpv_tbl IN adpv_tbl_type) IS

Line 510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

506: x_msg_count OUT NOCOPY NUMBER,
507: x_msg_data OUT NOCOPY VARCHAR2,
508: p_adpv_tbl IN adpv_tbl_type) IS
509: i NUMBER := 0;
510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
511: BEGIN
512: x_return_status := OKC_API.G_RET_STS_SUCCESS;
513: IF p_adpv_tbl.COUNT > 0 THEN
514: i := p_adpv_tbl.FIRST;

Line 512: x_return_status := OKC_API.G_RET_STS_SUCCESS;

508: p_adpv_tbl IN adpv_tbl_type) IS
509: i NUMBER := 0;
510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
511: BEGIN
512: x_return_status := OKC_API.G_RET_STS_SUCCESS;
513: IF p_adpv_tbl.COUNT > 0 THEN
514: i := p_adpv_tbl.FIRST;
515: LOOP
516: lock_txd_asset_Def(

Line 523: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

519: x_return_status => l_return_status,
520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,
522: p_adpv_rec => p_adpv_tbl(i));
523: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
525: x_return_status := l_return_status;
526: raise G_EXCEPTION_HALT_VALIDATION;
527: ELSE

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

520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,
522: p_adpv_rec => p_adpv_tbl(i));
523: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
525: x_return_status := l_return_status;
526: raise G_EXCEPTION_HALT_VALIDATION;
527: ELSE
528: x_return_status := l_return_status;

Line 566: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

562: -- Version : 1.0
563: -- End of comments
564: procedure validate_txd_asset_Def(
565: p_api_version IN NUMBER,
566: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
567: x_return_status OUT NOCOPY VARCHAR2,
568: x_msg_count OUT NOCOPY NUMBER,
569: x_msg_data OUT NOCOPY VARCHAR2,
570: p_adpv_rec IN adpv_rec_type) IS

Line 572: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

568: x_msg_count OUT NOCOPY NUMBER,
569: x_msg_data OUT NOCOPY VARCHAR2,
570: p_adpv_rec IN adpv_rec_type) IS
571: l_adpv_rec adpv_rec_type;
572: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
573: l_api_name CONSTANT VARCHAR2(30) := 'validate_txd_asset_Def';
574: l_api_version CONSTANT NUMBER := 1;
575: BEGIN
576: savepoint validate_txd_asset_Def_pub;

Line 641: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

637: -- Version : 1.0
638: -- End of comments
639: procedure validate_txd_asset_Def(
640: p_api_version IN NUMBER,
641: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_msg_count OUT NOCOPY NUMBER,
644: x_msg_data OUT NOCOPY VARCHAR2,
645: p_adpv_tbl IN adpv_tbl_type) IS

Line 647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

643: x_msg_count OUT NOCOPY NUMBER,
644: x_msg_data OUT NOCOPY VARCHAR2,
645: p_adpv_tbl IN adpv_tbl_type) IS
646: i NUMBER := 0;
647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
648: BEGIN
649: x_return_status := OKC_API.G_RET_STS_SUCCESS;
650: IF p_adpv_tbl.COUNT > 0 THEN
651: i := p_adpv_tbl.FIRST;

Line 649: x_return_status := OKC_API.G_RET_STS_SUCCESS;

645: p_adpv_tbl IN adpv_tbl_type) IS
646: i NUMBER := 0;
647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
648: BEGIN
649: x_return_status := OKC_API.G_RET_STS_SUCCESS;
650: IF p_adpv_tbl.COUNT > 0 THEN
651: i := p_adpv_tbl.FIRST;
652: LOOP
653: validate_txd_asset_Def(

Line 660: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

656: x_return_status => l_return_status,
657: x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data,
659: p_adpv_rec => p_adpv_tbl(i));
660: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: x_return_status := l_return_status;
663: raise G_EXCEPTION_HALT_VALIDATION;
664: ELSE

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

657: x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data,
659: p_adpv_rec => p_adpv_tbl(i));
660: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: x_return_status := l_return_status;
663: raise G_EXCEPTION_HALT_VALIDATION;
664: ELSE
665: x_return_status := l_return_status;