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 1512: SELECT hsecs INTO l_start_time FROM v$timer;

1508: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1509: l_transaction_rec.event_type_code := 'CREATE';
1510: l_transaction_rec.trx_id := OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index);
1511: l_transaction_rec.internal_organization_id := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
1512: SELECT hsecs INTO l_start_time FROM v$timer;
1513: IF l_call_tax = 'Y' THEN --Call ZX api only if there is atleast one eligible line to be taxed
1514: oe_debug_pub.add( ' Call zx_api_pub.calculate_tax ',1);
1515: zx_api_pub.calculate_tax( p_api_version => 1.0,
1516: p_init_msg_list => FND_API.G_TRUE,

Line 1527: SELECT hsecs INTO l_end_time FROM v$timer;

1523: p_quote_flag => 'Y',
1524: p_data_transfer_mode => 'PLS',
1525: x_doc_level_recalc_flag => l_doc_level_recalc_flag);
1526: END IF;
1527: SELECT hsecs INTO l_end_time FROM v$timer;
1528: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in zx_api_pub.calculate_tax is (sec) '||((l_end_time-l_start_time)/100));
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add('Message returned by tax API ZX_API_PUB.calculate_tax: '||l_msg_count,2);
1531: END IF;

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

1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.INSERT_TAX_RECORDS' ) ;
1749: END IF;
1750:
1751: SELECT hsecs INTO l_start_time from v$timer;
1752:
1753:
1754:
1755: begin

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

1802:
1803: );
1804:
1805:
1806: SELECT hsecs INTO l_end_time from v$timer;
1807:
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent inserting adjustment records is (sec) '||((l_end_time-l_start_time)/100));
1809:
1810: --Need to Update TAX_VALUE on oe_order_lines_all if in post insert mode.