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.

[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_QSL_PVT

Line 11036: l_strm_elements_tbl OKL_QSL_PVT.qsl_tbl_type;

11032:
11033: l_return_status VARCHAR2(1):= G_RET_STS_SUCCESS;
11034: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'delete_quote_streams';
11035: l_api_version CONSTANT NUMBER DEFAULT 1.0;
11036: l_strm_elements_tbl OKL_QSL_PVT.qsl_tbl_type;
11037: l_streams_tbl OKL_QSH_PVT.qsh_tbl_type;
11038: p_index NUMBER;
11039:
11040: CURSOR get_strm_elements_csr IS

Line 11075: OKL_QSL_PVT.delete_row(p_api_version => p_api_version,

11071: l_strm_elements_tbl(p_index).quote_strm_element_id := strm_element_rec.QUOTE_STRM_ELEMENT_ID;
11072: p_index := p_index + 1;
11073: END LOOP;
11074: IF(l_strm_elements_tbl.COUNT > 0) THEN
11075: OKL_QSL_PVT.delete_row(p_api_version => p_api_version,
11076: p_init_msg_list => p_init_msg_list,
11077: x_return_status => l_return_status,
11078: x_msg_count => x_msg_count,
11079: x_msg_data => x_msg_data,

Line 11174: l_stm_element_rec OKL_QSL_PVT.qsl_rec_type;

11170: l_api_version CONSTANT NUMBER DEFAULT 1.0;
11171: l_sel_amount NUMBER;
11172: l_stream_rec OKL_QSH_PVT.qsh_rec_type;
11173: x_stream_rec OKL_QSH_PVT.qsh_rec_type;
11174: l_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11175: x_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11176: l_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11177: x_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11178: p_index NUMBER;

Line 11175: x_stm_element_rec OKL_QSL_PVT.qsl_rec_type;

11171: l_sel_amount NUMBER;
11172: l_stream_rec OKL_QSH_PVT.qsh_rec_type;
11173: x_stream_rec OKL_QSH_PVT.qsh_rec_type;
11174: l_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11175: x_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11176: l_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11177: x_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11178: p_index NUMBER;
11179: l_product_type VARCHAR2(30);

Line 11176: l_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;

11172: l_stream_rec OKL_QSH_PVT.qsh_rec_type;
11173: x_stream_rec OKL_QSH_PVT.qsh_rec_type;
11174: l_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11175: x_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11176: l_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11177: x_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11178: p_index NUMBER;
11179: l_product_type VARCHAR2(30);
11180:

Line 11177: x_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;

11173: x_stream_rec OKL_QSH_PVT.qsh_rec_type;
11174: l_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11175: x_stm_element_rec OKL_QSL_PVT.qsl_rec_type;
11176: l_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11177: x_stm_element_tbl OKL_QSL_PVT.qsl_tbl_type;
11178: p_index NUMBER;
11179: l_product_type VARCHAR2(30);
11180:
11181: CURSOR get_quote_details_csr IS

Line 11323: 'Before Calling the API OKL_QSL_PVT.insertv_tbl ' );

11319: END LOOP;
11320: END IF;
11321: --Inserting the stream elements
11322: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11323: 'Before Calling the API OKL_QSL_PVT.insertv_tbl ' );
11324: OKL_QSL_PVT.insert_row(p_api_version => p_api_version,
11325: p_init_msg_list => p_init_msg_list,
11326: x_return_status => l_return_status,
11327: x_msg_count => x_msg_count,

Line 11324: OKL_QSL_PVT.insert_row(p_api_version => p_api_version,

11320: END IF;
11321: --Inserting the stream elements
11322: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11323: 'Before Calling the API OKL_QSL_PVT.insertv_tbl ' );
11324: OKL_QSL_PVT.insert_row(p_api_version => p_api_version,
11325: p_init_msg_list => p_init_msg_list,
11326: x_return_status => l_return_status,
11327: x_msg_count => x_msg_count,
11328: x_msg_data => x_msg_data,

Line 11333: 'After Calling the API OKL_QSL_PVT.insertv_tbl x_return_status=' || l_return_status );

11329: p_qsl_tbl => l_stm_element_tbl,
11330: x_qsl_tbl => x_stm_element_tbl
11331: );
11332: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11333: 'After Calling the API OKL_QSL_PVT.insertv_tbl x_return_status=' || l_return_status );
11334: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11336: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
11337: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 11398: 'Before executing the API OKL_QSL_PVT.insert_row. ' );

11394: l_stm_element_rec.stream_element_date := l_pricing_param_tbl(k).residual_inflows(m).cf_date;
11395: l_stm_element_rec.amount := l_sel_amount;
11396: --Inserting the stream element
11397: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11398: 'Before executing the API OKL_QSL_PVT.insert_row. ' );
11399: OKL_QSL_PVT.insert_row(p_api_version => p_api_version,
11400: p_init_msg_list => p_init_msg_list,
11401: x_return_status => l_return_status,
11402: x_msg_count => x_msg_count,

Line 11399: OKL_QSL_PVT.insert_row(p_api_version => p_api_version,

11395: l_stm_element_rec.amount := l_sel_amount;
11396: --Inserting the stream element
11397: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11398: 'Before executing the API OKL_QSL_PVT.insert_row. ' );
11399: OKL_QSL_PVT.insert_row(p_api_version => p_api_version,
11400: p_init_msg_list => p_init_msg_list,
11401: x_return_status => l_return_status,
11402: x_msg_count => x_msg_count,
11403: x_msg_data => x_msg_data,

Line 11408: 'After executing the API OKL_QSL_PVT.insert_row. x_return_status=' || l_return_status );

11404: p_qsl_rec => l_stm_element_rec,
11405: x_qsl_rec => x_stm_element_rec
11406: );
11407: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11408: 'After executing the API OKL_QSL_PVT.insert_row. x_return_status=' || l_return_status );
11409: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11411: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
11412: RAISE OKL_API.G_EXCEPTION_ERROR;