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_PRICING_UTILS_PVT dependencies on OKL_QSH_PVT

Line 11037: l_streams_tbl OKL_QSH_PVT.qsh_tbl_type;

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
11041: SELECT QTE_SEL.QUOTE_STRM_ELEMENT_ID

Line 11096: OKL_QSH_PVT.delete_row(p_api_version => p_api_version,

11092: l_streams_tbl(p_index).quote_stream_id := strm_rec.QUOTE_STREAM_ID;
11093: p_index := p_index + 1;
11094: END LOOP;
11095: IF(l_streams_tbl.COUNT > 0) THEN
11096: OKL_QSH_PVT.delete_row(p_api_version => p_api_version,
11097: p_init_msg_list => p_init_msg_list,
11098: x_return_status => l_return_status,
11099: x_msg_count => x_msg_count,
11100: x_msg_data => x_msg_data,

Line 11172: l_stream_rec OKL_QSH_PVT.qsh_rec_type;

11168: l_residual_count NUMBER;
11169: l_residual_amt NUMBER;
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;

Line 11173: x_stream_rec OKL_QSH_PVT.qsh_rec_type;

11169: l_residual_amt NUMBER;
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;

Line 11288: 'Before Calling the API OKL_QSH_PVT.insert_row ' );

11284: l_stream_rec.link_asset_id := l_pricing_param_tbl(k).link_asset_id; --Added by bkatraga for bug 7410991
11285:
11286: l_stream_rec.say_code := 'CURR';
11287: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11288: 'Before Calling the API OKL_QSH_PVT.insert_row ' );
11289: --Inserting the stream header
11290: OKL_QSH_PVT.insert_row(p_api_version => p_api_version,
11291: p_init_msg_list => p_init_msg_list,
11292: x_return_status => l_return_status,

Line 11290: OKL_QSH_PVT.insert_row(p_api_version => p_api_version,

11286: l_stream_rec.say_code := 'CURR';
11287: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11288: 'Before Calling the API OKL_QSH_PVT.insert_row ' );
11289: --Inserting the stream header
11290: OKL_QSH_PVT.insert_row(p_api_version => p_api_version,
11291: p_init_msg_list => p_init_msg_list,
11292: x_return_status => l_return_status,
11293: x_msg_count => x_msg_count,
11294: x_msg_data => x_msg_data,

Line 11299: 'After Calling the API OKL_QSH_PVT.insert_row ' || l_return_status );

11295: p_qsh_rec => l_stream_rec,
11296: x_qsh_rec => x_stream_rec
11297: );
11298: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11299: 'After Calling the API OKL_QSH_PVT.insert_row ' || l_return_status );
11300: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
11303: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 11364: 'Before executing the API OKL_QSH_PVT.insert_row ' );

11360: l_stream_rec.sty_id := l_residual_sty_id;
11361: l_stream_rec.say_code := 'CURR';
11362: --Inserting the residual stream header
11363: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11364: 'Before executing the API OKL_QSH_PVT.insert_row ' );
11365: OKL_QSH_PVT.insert_row(p_api_version => p_api_version,
11366: p_init_msg_list => p_init_msg_list,
11367: x_return_status => l_return_status,
11368: x_msg_count => x_msg_count,

Line 11365: OKL_QSH_PVT.insert_row(p_api_version => p_api_version,

11361: l_stream_rec.say_code := 'CURR';
11362: --Inserting the residual stream header
11363: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11364: 'Before executing the API OKL_QSH_PVT.insert_row ' );
11365: OKL_QSH_PVT.insert_row(p_api_version => p_api_version,
11366: p_init_msg_list => p_init_msg_list,
11367: x_return_status => l_return_status,
11368: x_msg_count => x_msg_count,
11369: x_msg_data => x_msg_data,

Line 11374: 'After executing the API OKL_QSH_PVT.insert_row. x_return_status=' || l_return_status );

11370: p_qsh_rec => l_stream_rec,
11371: x_qsh_rec => x_stream_rec
11372: );
11373: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11374: 'After executing the API OKL_QSH_PVT.insert_row. x_return_status=' || l_return_status );
11375: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11377: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
11378: RAISE OKL_API.G_EXCEPTION_ERROR;