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

Line 851: x_stmv_rec OUT NOCOPY OKL_STREAMS_PUB.stmv_rec_type,

847: p_init_msg_list IN VARCHAR2,
848: x_msg_count OUT NOCOPY NUMBER,
849: x_msg_data OUT NOCOPY VARCHAR2,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_stmv_rec OUT NOCOPY OKL_STREAMS_PUB.stmv_rec_type,
852: x_selv_tbl OUT NOCOPY OKL_STREAMS_PUB.selv_tbl_type
853: ) Is
854:
855: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

Line 852: x_selv_tbl OUT NOCOPY OKL_STREAMS_PUB.selv_tbl_type

848: x_msg_count OUT NOCOPY NUMBER,
849: x_msg_data OUT NOCOPY VARCHAR2,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_stmv_rec OUT NOCOPY OKL_STREAMS_PUB.stmv_rec_type,
852: x_selv_tbl OUT NOCOPY OKL_STREAMS_PUB.selv_tbl_type
853: ) Is
854:
855: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
856: l_api_name CONSTANT varchar2(30) := 'GENERATE_STUB_ELEMENT';

Line 861: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

857: l_api_version CONSTANT NUMBER := 1.0;
858:
859:
860: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
861: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
862: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
863: --avsingh :
864: lx_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
865: lx_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

Line 862: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

858:
859:
860: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
861: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
862: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
863: --avsingh :
864: lx_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
865: lx_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
866:

Line 864: lx_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

860: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
861: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
862: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
863: --avsingh :
864: lx_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
865: lx_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
866:
867:
868: l_sty_id NUMBER;

Line 865: lx_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

861: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
862: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
863: --avsingh :
864: lx_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
865: lx_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
866:
867:
868: l_sty_id NUMBER;
869:

Line 992: x_stmv_rec_rent OUT NOCOPY okl_streams_pub.stmv_rec_type,

988: p_payment_tbl IN okl_stream_generator_pvt.payment_tbl_type,
989: x_return_status OUT NOCOPY VARCHAR2,
990: x_msg_count OUT NOCOPY NUMBER,
991: x_msg_data OUT NOCOPY VARCHAR2,
992: x_stmv_rec_rent OUT NOCOPY okl_streams_pub.stmv_rec_type,
993: x_selv_tbl_rent OUT NOCOPY okl_streams_pub.selv_tbl_type,
994: x_stmv_rec_stub OUT NOCOPY okl_streams_pub.stmv_rec_type,
995: x_selv_tbl_stub OUT NOCOPY okl_streams_pub.selv_tbl_type,
996: x_payment_count OUT NOCOPY BINARY_INTEGER) IS

Line 993: x_selv_tbl_rent OUT NOCOPY okl_streams_pub.selv_tbl_type,

989: x_return_status OUT NOCOPY VARCHAR2,
990: x_msg_count OUT NOCOPY NUMBER,
991: x_msg_data OUT NOCOPY VARCHAR2,
992: x_stmv_rec_rent OUT NOCOPY okl_streams_pub.stmv_rec_type,
993: x_selv_tbl_rent OUT NOCOPY okl_streams_pub.selv_tbl_type,
994: x_stmv_rec_stub OUT NOCOPY okl_streams_pub.stmv_rec_type,
995: x_selv_tbl_stub OUT NOCOPY okl_streams_pub.selv_tbl_type,
996: x_payment_count OUT NOCOPY BINARY_INTEGER) IS
997:

Line 994: x_stmv_rec_stub OUT NOCOPY okl_streams_pub.stmv_rec_type,

990: x_msg_count OUT NOCOPY NUMBER,
991: x_msg_data OUT NOCOPY VARCHAR2,
992: x_stmv_rec_rent OUT NOCOPY okl_streams_pub.stmv_rec_type,
993: x_selv_tbl_rent OUT NOCOPY okl_streams_pub.selv_tbl_type,
994: x_stmv_rec_stub OUT NOCOPY okl_streams_pub.stmv_rec_type,
995: x_selv_tbl_stub OUT NOCOPY okl_streams_pub.selv_tbl_type,
996: x_payment_count OUT NOCOPY BINARY_INTEGER) IS
997:
998: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

Line 995: x_selv_tbl_stub OUT NOCOPY okl_streams_pub.selv_tbl_type,

991: x_msg_data OUT NOCOPY VARCHAR2,
992: x_stmv_rec_rent OUT NOCOPY okl_streams_pub.stmv_rec_type,
993: x_selv_tbl_rent OUT NOCOPY okl_streams_pub.selv_tbl_type,
994: x_stmv_rec_stub OUT NOCOPY okl_streams_pub.stmv_rec_type,
995: x_selv_tbl_stub OUT NOCOPY okl_streams_pub.selv_tbl_type,
996: x_payment_count OUT NOCOPY BINARY_INTEGER) IS
997:
998: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
999: l_api_name CONSTANT varchar2(30) := 'GENERATE_CASH_FLOWS';

Line 1032: l_selv_tbl okl_streams_pub.selv_tbl_type;

1028: l_interest_id NUMBER;
1029: l_prin_bal_id NUMBER;
1030: l_termination_id NUMBER;
1031:
1032: l_selv_tbl okl_streams_pub.selv_tbl_type;
1033: l_pt_tbl okl_streams_pub.selv_tbl_type;
1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1035:
1036: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 1033: l_pt_tbl okl_streams_pub.selv_tbl_type;

1029: l_prin_bal_id NUMBER;
1030: l_termination_id NUMBER;
1031:
1032: l_selv_tbl okl_streams_pub.selv_tbl_type;
1033: l_pt_tbl okl_streams_pub.selv_tbl_type;
1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1035:
1036: l_stmv_rec okl_streams_pub.stmv_rec_type;
1037: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;

1030: l_termination_id NUMBER;
1031:
1032: l_selv_tbl okl_streams_pub.selv_tbl_type;
1033: l_pt_tbl okl_streams_pub.selv_tbl_type;
1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1035:
1036: l_stmv_rec okl_streams_pub.stmv_rec_type;
1037: l_pt_rec okl_streams_pub.stmv_rec_type;
1038: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 1036: l_stmv_rec okl_streams_pub.stmv_rec_type;

1032: l_selv_tbl okl_streams_pub.selv_tbl_type;
1033: l_pt_tbl okl_streams_pub.selv_tbl_type;
1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1035:
1036: l_stmv_rec okl_streams_pub.stmv_rec_type;
1037: l_pt_rec okl_streams_pub.stmv_rec_type;
1038: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1039:
1040: i BINARY_INTEGER := 0;

Line 1037: l_pt_rec okl_streams_pub.stmv_rec_type;

1033: l_pt_tbl okl_streams_pub.selv_tbl_type;
1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1035:
1036: l_stmv_rec okl_streams_pub.stmv_rec_type;
1037: l_pt_rec okl_streams_pub.stmv_rec_type;
1038: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1039:
1040: i BINARY_INTEGER := 0;
1041: j BINARY_INTEGER := 0;

Line 1038: lx_stmv_rec okl_streams_pub.stmv_rec_type;

1034: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1035:
1036: l_stmv_rec okl_streams_pub.stmv_rec_type;
1037: l_pt_rec okl_streams_pub.stmv_rec_type;
1038: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1039:
1040: i BINARY_INTEGER := 0;
1041: j BINARY_INTEGER := 0;
1042: l_ele_count BINARY_INTEGER := 0;

Line 1053: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;

1049: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'generate_cash_flows';
1050: l_se_id NUMBER;
1051:
1052: --avsingh
1053: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1054: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1055: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1056: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1057:

Line 1054: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;

1050: l_se_id NUMBER;
1051:
1052: --avsingh
1053: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1054: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1055: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1056: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1057:
1058:

Line 1055: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;

1051:
1052: --avsingh
1053: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1054: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1055: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1056: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1057:
1058:
1059:

Line 1056: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;

1052: --avsingh
1053: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1054: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1055: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1056: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1057:
1058:
1059:
1060: BEGIN

Line 1128: okl_streams_pub.create_streams(p_api_version => p_api_version,

1124: END IF;
1125:
1126: l_stmv_rec.purpose_code := 'FLOW';
1127:
1128: okl_streams_pub.create_streams(p_api_version => p_api_version,
1129: p_init_msg_list => p_init_msg_list,
1130: x_return_status => x_return_status,
1131: x_msg_count => x_msg_count,
1132: x_msg_data => x_msg_data,

Line 1229: okl_streams_pub.create_stream_elements(

1225:
1226: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1227: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'start date ' || l_selv_tbl(1).stream_element_date );
1228: END IF;
1229: okl_streams_pub.create_stream_elements(
1230: p_api_version => p_api_version,
1231: p_init_msg_list => p_init_msg_list,
1232: x_return_status => x_return_status,
1233: x_msg_count => x_msg_count,

Line 1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;

1344: l_start_date okc_k_lines_b.start_date%TYPE;
1345: l_end_date okc_k_lines_b.end_date%TYPE;
1346: i NUMBER;
1347:
1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1349: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1350: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1351: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1352:

Line 1349: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;

1345: l_end_date okc_k_lines_b.end_date%TYPE;
1346: i NUMBER;
1347:
1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1349: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1350: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1351: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1352:
1353: l_payment_count BINARY_INTEGER;

Line 1350: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;

1346: i NUMBER;
1347:
1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1349: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1350: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1351: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1352:
1353: l_payment_count BINARY_INTEGER;
1354: l_sty_id NUMBER;

Line 1351: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;

1347:
1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1349: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;
1350: l_stmv_rec_stub okl_streams_pub.stmv_rec_type;
1351: l_selv_tbl_stub okl_streams_pub.selv_tbl_type;
1352:
1353: l_payment_count BINARY_INTEGER;
1354: l_sty_id NUMBER;
1355: l_npv NUMBER;

Line 1461: okl_streams_pub.delete_streams(

1457: END LOOP;
1458: x_npv := l_npv;
1459:
1460: --delete streams created for this temporary calculation
1461: okl_streams_pub.delete_streams(
1462: p_api_version => p_api_version,
1463: p_init_msg_list => p_init_msg_list,
1464: x_return_status => x_return_status,
1465: x_msg_count => x_msg_count,

Line 1476: okl_streams_pub.delete_streams(

1472: RAISE OKL_API.G_EXCEPTION_ERROR;
1473: END IF;
1474:
1475:
1476: okl_streams_pub.delete_streams(
1477: p_api_version => p_api_version,
1478: p_init_msg_list => p_init_msg_list,
1479: x_return_status => x_return_status,
1480: x_msg_count => x_msg_count,