APPS.OE_BULK_TAX_UTIL dependencies on V$TIMER

Line 210: SELECT hsecs INTO l_start_time from v$timer;

206: oe_debug_pub.add( 'before calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION');
207: oe_debug_pub.add( 'OE_Bulk_Order_PVT.G_LINE_REC.org_id('||l_index||') :'||OE_Bulk_Order_PVT.G_LINE_REC.org_id(l_index) );
208: END IF;
209:
210: SELECT hsecs INTO l_start_time from v$timer;
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),

Line 233: SELECT hsecs INTO l_end_time from v$timer;

229:
230:
231:
232:
233: SELECT hsecs INTO l_end_time from v$timer;
234:
235: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in GET_DEFAULT_TAX_CLASSIFICATION is (sec) '||((l_end_time-l_start_time)/100));
236:
237: IF l_debug_level > 0 THEN

Line 288: SELECT hsecs INTO l_start_time from v$timer;

284:
285: END;
286: END IF; --end of IF tax_code is NULL
287:
288: SELECT hsecs INTO l_start_time from v$timer;
289:
290: --bug7685103
291: --This validation will be done in OEBLLINB.pls
292: /* -- Validating Tax Information

Line 334: SELECT hsecs INTO l_end_time from v$timer;

330:
331: END IF;
332:
333:
334: SELECT hsecs INTO l_end_time from v$timer;
335:
336: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent validating tax information is (sec) '||((l_end_time-l_start_time)/100));
337:
338: EXCEPTION

Line 1345: SELECT hsecs INTO l_start_time from v$timer;

1341:
1342:
1343: IF l_debug_level > 0 THEN
1344: oe_debug_pub.add('tax_line 11' , 1);
1345: SELECT hsecs INTO l_start_time from v$timer;
1346: END IF;
1347:
1348: l_call_tax := 'Y';
1349: */

Line 1359: SELECT hsecs INTO l_start_time from v$timer;

1355: l_transaction_rec.trx_id := OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index);
1356: l_transaction_rec.internal_organization_id := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
1357:
1358:
1359: SELECT hsecs INTO l_start_time from v$timer;
1360:
1361: IF l_call_tax = 'Y' THEN --Call ZX api only if there is atleast one eligible line to be taxed
1362: oe_debug_pub.add( ' Call zx_api_pub.calculate_tax ',1);
1363:

Line 1378: SELECT hsecs INTO l_end_time from v$timer;

1374: p_data_transfer_mode => 'PLS',
1375: x_doc_level_recalc_flag => l_doc_level_recalc_flag);
1376: END IF;
1377:
1378: SELECT hsecs INTO l_end_time from v$timer;
1379:
1380: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in zx_api_pub.calculate_tax is (sec) '||((l_end_time-l_start_time)/100));
1381:
1382: IF l_debug_level > 0 THEN

Line 1592: SELECT hsecs INTO l_start_time from v$timer;

1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.INSERT_TAX_RECORDS' ) ;
1590: END IF;
1591:
1592: SELECT hsecs INTO l_start_time from v$timer;
1593:
1594:
1595:
1596: begin

Line 1644: SELECT hsecs INTO l_end_time from v$timer;

1640: , G_LINE_ADJ_REC.tax_rate_id(i) --bug7685103
1641: );
1642:
1643:
1644: SELECT hsecs INTO l_end_time from v$timer;
1645:
1646: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent inserting adjustment records is (sec) '||((l_end_time-l_start_time)/100));
1647:
1648: --Need to Update TAX_VALUE on oe_order_lines_all if in post insert mode.