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_VR_DOCUMENT_PVT dependencies on OKL_STREAMS_PUB

Line 149: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

145: l_msg_count NUMBER;
146: l_msg_data VARCHAR2(2000);
147: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
148: l_stream_exists VARCHAR2(1) := '?';
149: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
150: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
151: l_selv_rec Okl_Streams_Pub.selv_rec_type;
152: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
153: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;

Line 150: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

146: l_msg_data VARCHAR2(2000);
147: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
148: l_stream_exists VARCHAR2(1) := '?';
149: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
150: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
151: l_selv_rec Okl_Streams_Pub.selv_rec_type;
152: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
153: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
154: r_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;

Line 151: l_selv_rec Okl_Streams_Pub.selv_rec_type;

147: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
148: l_stream_exists VARCHAR2(1) := '?';
149: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
150: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
151: l_selv_rec Okl_Streams_Pub.selv_rec_type;
152: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
153: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
154: r_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
155: l_def_desc CONSTANT VARCHAR2(80) := 'Variable Interest Stream Billing';

Line 152: lx_selv_rec Okl_Streams_Pub.selv_rec_type;

148: l_stream_exists VARCHAR2(1) := '?';
149: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
150: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
151: l_selv_rec Okl_Streams_Pub.selv_rec_type;
152: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
153: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
154: r_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
155: l_def_desc CONSTANT VARCHAR2(80) := 'Variable Interest Stream Billing';
156: l_final_status CONSTANT VARCHAR2(30) := 'SUBMITTED';

Line 314: l_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;

310:
311: -- Bug 5964482 dpsingh for AE signature Uptake end
312: l_legal_entity_id NUMBER;
313: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
314: l_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
315: lx_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
316: l_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
318:

Line 315: lx_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;

311: -- Bug 5964482 dpsingh for AE signature Uptake end
312: l_legal_entity_id NUMBER;
313: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
314: l_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
315: lx_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
316: l_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
318:
319:

Line 316: l_rep_selv_rec Okl_Streams_Pub.selv_rec_type;

312: l_legal_entity_id NUMBER;
313: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
314: l_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
315: lx_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
316: l_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
318:
319:
320: BEGIN

Line 317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;

313: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
314: l_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
315: lx_rep_stmv_rec Okl_Streams_Pub.stmv_rec_type;
316: l_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
318:
319:
320: BEGIN
321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');

Line 394: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');

390: ELSE
391: l_stmv_rec.comments := 'Variable Interest';
392: END IF;
393:
394: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
395:
396: Okl_Streams_Pub.create_streams(
397: p_api_version => p_api_version,
398: p_init_msg_list => p_init_msg_list,

Line 396: Okl_Streams_Pub.create_streams(

392: END IF;
393:
394: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
395:
396: Okl_Streams_Pub.create_streams(
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 413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');

409: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
410: END IF;
411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');
414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
416: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');
417: RAISE create_stream_invoice_failed;

Line 416: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');

412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');
414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
416: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');
417: RAISE create_stream_invoice_failed;
418: END IF;
419:
420: l_stream_created := OKL_API.G_TRUE;

Line 454: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');

450: l_selv_rec.comments := 'Variable Interest';
451: END IF;
452:
453:
454: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');
455:
456: Okl_Streams_Pub.create_stream_elements(
457: p_api_version => p_api_version,
458: p_init_msg_list => p_init_msg_list,

Line 456: Okl_Streams_Pub.create_stream_elements(

452:
453:
454: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');
455:
456: Okl_Streams_Pub.create_stream_elements(
457: p_api_version => p_api_version,
458: p_init_msg_list => p_init_msg_list,
459: x_return_status => x_return_status,
460: x_msg_count => x_msg_count,

Line 472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');

468: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
469: END IF;
470:
471: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
475: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');
476: RAISE create_stream_invoice_failed;

Line 475: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');

471: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
475: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');
476: RAISE create_stream_invoice_failed;
477: END IF;
478:
479: l_strm_element_created := OKL_API.G_TRUE;

Line 582: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');

578: l_rep_stmv_rec.date_current := sysdate;
579: l_rep_stmv_rec.purpose_code := 'REPORT';
580: l_rep_stmv_rec.comments := 'Variable Interest';
581:
582: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
583:
584: Okl_Streams_Pub.create_streams(
585: p_api_version => p_api_version,
586: p_init_msg_list => p_init_msg_list,

Line 584: Okl_Streams_Pub.create_streams(

580: l_rep_stmv_rec.comments := 'Variable Interest';
581:
582: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
583:
584: Okl_Streams_Pub.create_streams(
585: p_api_version => p_api_version,
586: p_init_msg_list => p_init_msg_list,
587: x_return_status => x_return_status,
588: x_msg_count => x_msg_count,

Line 600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');

596: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
597: END IF;
598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
602: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
603: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
604: RAISE create_stream_invoice_failed;

Line 603: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams for reporting streams');

599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
602: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
603: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
604: RAISE create_stream_invoice_failed;
605: END IF;
606:
607: l_rep_stream_created := OKL_API.G_TRUE;

Line 642: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS for reporting streams');

638:
639: l_rep_selv_rec.comments := 'Variable Interest';
640:
641:
642: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS for reporting streams');
643:
644: Okl_Streams_Pub.create_stream_elements(
645: p_api_version => p_api_version,
646: p_init_msg_list => p_init_msg_list,

Line 644: Okl_Streams_Pub.create_stream_elements(

640:
641:
642: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS for reporting streams');
643:
644: Okl_Streams_Pub.create_stream_elements(
645: p_api_version => p_api_version,
646: p_init_msg_list => p_init_msg_list,
647: x_return_status => x_return_status,
648: x_msg_count => x_msg_count,

Line 660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');

656: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
657: END IF;
658:
659: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
661: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
663: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
664: RAISE create_stream_invoice_failed;

Line 663: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');

659: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
661: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
663: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
664: RAISE create_stream_invoice_failed;
665: END IF;
666:
667: l_rep_strm_element_created := OKL_API.G_TRUE;

Line 1118: OKL_STREAMS_PUB.delete_stream_elements(

1114:
1115: -- Daily Interest calculation conc. program does not use savepoint. Delete the streams/Trx
1116: IF (p_process_flag = 'DAILY_INTEREST') THEN
1117: IF (l_strm_element_created = OKL_API.G_TRUE) THEN
1118: OKL_STREAMS_PUB.delete_stream_elements(
1119: p_api_version => 1.0,
1120: p_init_msg_list => OKC_API.G_FALSE,
1121: x_return_status => x_return_status,
1122: x_msg_count => x_msg_count,

Line 1127: OKL_STREAMS_PUB.delete_streams(

1123: x_msg_data => x_msg_data,
1124: p_selv_rec => lx_selv_rec);
1125: END IF;
1126: IF (l_stream_created = OKL_API.G_TRUE) THEN
1127: OKL_STREAMS_PUB.delete_streams(
1128: p_api_version => 1.0,
1129: p_init_msg_list => OKC_API.G_FALSE,
1130: x_return_status => x_return_status,
1131: x_msg_count => x_msg_count,

Line 1173: OKL_STREAMS_PUB.delete_stream_elements(

1169: END IF;
1170: -- Daily Interest calculation conc. program does not use savepoint. Delete the streams/Trx
1171: IF (p_process_flag = 'DAILY_INTEREST') THEN
1172: IF (l_strm_element_created = OKL_API.G_TRUE) THEN
1173: OKL_STREAMS_PUB.delete_stream_elements(
1174: p_api_version => 1.0,
1175: p_init_msg_list => OKC_API.G_FALSE,
1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,

Line 1182: OKL_STREAMS_PUB.delete_streams(

1178: x_msg_data => x_msg_data,
1179: p_selv_rec => lx_selv_rec);
1180: END IF;
1181: IF (l_stream_created = OKL_API.G_TRUE) THEN
1182: OKL_STREAMS_PUB.delete_streams(
1183: p_api_version => 1.0,
1184: p_init_msg_list => OKC_API.G_FALSE,
1185: x_return_status => x_return_status,
1186: x_msg_count => x_msg_count,