[Home] [Help]
17016: l_locked_price_list_id NUMBER := NULL;
17017: l_locked_price_list_line_id NUMBER := NULL;
17018: l_trxn_extension_id NUMBER := NULL;
17019:
17020: lx_rail_rec OKS_TAX_UTIL_PVT.ra_rec_type;
17021:
17022: /*cgopinee bugfix for bug8826746*/
17023: cursor terminatedLSLines IS
17024: select
18948:
18949: ------------Re-compute TAX_AMOUNT for a subscription line if the line being copied is a cancelled line------------
18950: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
18951: FND_LOG.string(FND_LOG.level_statement
18952: ,l_module_name||'.OKS_TAX_UTIL_PVT.Get_Tax'
18953: ,' LSE ID and LINE TERMINATED FLAG : '||OKCOKSLinesRecTab.OkcB_LSE_ID(i)||':'||OKCOKSLinesRecTab.OkcB_LINE_TERMINATED_FLAG(i)
18954: );
18955: END IF;
18956:
18991: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
18992: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
18993: FND_LOG.string(FND_LOG.level_statement
18994: ,l_module_name
18995: ,'Before call to OKS_TAX_UTIL_PVT.Get_Tax '
18996: );
18997: END IF;
18998: END IF;
18999:
18996: );
18997: END IF;
18998: END IF;
18999:
19000: OKS_TAX_UTIL_PVT.Get_Tax
19001: ( p_api_version => p_api_version
19002: ,p_init_msg_list => p_init_msg_list
19003: ,p_chr_id => P_To_Chr_ID
19004: ,p_cle_id => OKCOKSLinesRecTab.OkcB_NewOkcLineID(i)
19009: );
19010: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19011: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19012: FND_LOG.string(FND_LOG.level_statement
19013: ,l_module_name||'.OKS_TAX_UTIL_PVT.Get_Tax'
19014: ,'After call to Get Tax API for line: x_return_status :'||l_return_status
19015: ||'Tax Amount '||lx_rail_rec.TAX_VALUE
19016: );
19017: END IF;
20174: l_locked_price_list_id NUMBER := NULL;
20175: l_locked_price_list_line_id NUMBER := NULL;
20176: l_trxn_extension_id NUMBER := NULL;
20177:
20178: lx_rail_rec OKS_TAX_UTIL_PVT.ra_rec_type;
20179: -- 03-Nov-2006 hkamdar. Bug# 5623498.
20180: CURSOR get_toplvl_uom(p_line_id IN NUMBER) IS
20181: SELECT OEL.PRICING_QUANTITY_UOM
20182: FROM OKC_K_LINES_B OKCLINE,
24252: --npalepu added on 06-NOV-2006 for bug # 5636927
24253: lx_rail_rec.AMOUNT := NULL;
24254: --end npalepu
24255:
24256: OKS_TAX_UTIL_PVT.Get_Tax
24257: ( p_api_version => p_api_version
24258: ,p_init_msg_list => p_init_msg_list
24259: ,p_chr_id => P_To_Chr_ID
24260: ,p_cle_id => OKCOKSLinesRecTab.OkcB_NewOkcLineID(i)
24284:
24285: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24286: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24287: FND_LOG.string(FND_LOG.level_statement
24288: ,l_module_name||'.OKS_TAX_UTIL_PVT.Get_Tax'
24289: ,'Error occured in Get Tax API for line: x_return_status :'||l_return_status
24290: );
24291: END IF;
24292: END IF;