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_AM_CONSOLIDATED_QTE_PVT dependencies on OKL_AM_REPURCHASE_ASSET_PUB

Line 1341: p_qtev_rec IN qtev_rec_type) RETURN OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type IS

1337: -- Version : 1.0
1338: --
1339: -- End of comments
1340: FUNCTION get_quotes_lines (
1341: p_qtev_rec IN qtev_rec_type) RETURN OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type IS
1342:
1343: -- Cursor to get quote details of quotes forming part of consolidated quote
1344: CURSOR get_qtes_lines_of_qte_csr (p_qte_id IN NUMBER) IS
1345: SELECT id

Line 1349: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;

1345: SELECT id
1346: FROM OKL_TXL_QUOTE_LINES_V
1347: WHERE qte_id = p_qte_id;
1348:
1349: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1350: i NUMBER;
1351: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_lines';
1352: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1353: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 1435: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;

1431:
1432: lp_cons_rec qtev_rec_type := p_cons_rec;
1433: lx_cons_rec qtev_rec_type;
1434:
1435: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1436: lx_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1437:
1438: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_consolidate_quote';
1439: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 1436: lx_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;

1432: lp_cons_rec qtev_rec_type := p_cons_rec;
1433: lx_cons_rec qtev_rec_type;
1434:
1435: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1436: lx_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1437:
1438: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_consolidate_quote';
1439: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1440: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 1593: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote');

1589: lp_tqlv_tbl := get_quotes_lines (
1590: p_qtev_rec => li_qtev_tbl(i));
1591:
1592: IF (is_debug_statement_on) THEN
1593: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote');
1594: END IF;
1595: -- Call terminate quote update api
1596: OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote(
1597: p_api_version => p_api_version,

Line 1596: OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote(

1592: IF (is_debug_statement_on) THEN
1593: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote');
1594: END IF;
1595: -- Call terminate quote update api
1596: OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote(
1597: p_api_version => p_api_version,
1598: p_init_msg_list => OKL_API.G_FALSE,
1599: x_return_status => l_return_status,
1600: x_msg_count => x_msg_count,

Line 1607: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote , return status: ' || l_return_status);

1603: p_tqlv_tbl => lp_tqlv_tbl,
1604: x_qtev_rec => lx_qtev_tbl(i),
1605: x_tqlv_tbl => lx_tqlv_tbl);
1606: IF (is_debug_statement_on) THEN
1607: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote , return status: ' || l_return_status);
1608: END IF;
1609:
1610: -- Throw exception if repurchase quote update failed
1611: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN