DBA Data[Home] [Help]

APPS.IBE_PRICE_PVT dependencies on DBMS_UTILITY

Line 816: l_start_time := DBMS_UTILITY.GET_TIME;

812: ||',p_model_id='||p_model_id
813: ||',p_currency_code='||p_currency_code);
814: END IF;
815:
816: l_start_time := DBMS_UTILITY.GET_TIME;
817: GetPricesFromQP(
818: p_price_list_id => p_price_list_id,
819: p_party_id => p_party_id,
820: p_cust_account_id => p_cust_account_id,

Line 993: l_end_time := DBMS_UTILITY.GET_TIME;

989: END IF;
990: END LOOP;
991: --gzhang 08/08/2002, bug#2488246
992: --IBE_UTIL.Disable_Debug;
993: l_end_time := DBMS_UTILITY.GET_TIME;
994: --ZHGG_UTIL.debug(G_PKG_NAME||'.'||L_API||': end, elapsed time (s) ='||(l_end_time-l_start_time)/100);
995: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
996: IBE_UTIL.debug(G_PKG_NAME||'.'||L_API||': end, elapsed time (s) ='||(l_end_time-l_start_time)/100);
997: END IF;

Line 2134: l_t0 := DBMS_UTILITY.GET_TIME;

2130: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2131: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': QP Version'||QP_PREQ_GRP.GET_VERSION);
2132: END IF;
2133:
2134: l_t0 := DBMS_UTILITY.GET_TIME;
2135: IF p_price_list_id IS NOT NULL AND p_price_list_id <> FND_API.G_MISS_NUM THEN
2136: L_PRICE_LIST := p_price_list_id;
2137: END IF;
2138: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2393: l_ti := DBMS_UTILITY.GET_TIME;

2389: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2390: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': inserting request lines into QP temp table, total lines='||G_LINE_INDEX_TBL.count);
2391: END IF;
2392:
2393: l_ti := DBMS_UTILITY.GET_TIME;
2394: QP_PREQ_GRP.INSERT_LINES2
2395: (p_LINE_INDEX => G_LINE_INDEX_TBL,
2396: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
2397: p_PRICING_EFFECTIVE_DATE => G_PRICING_EFFECTIVE_DATE_TBL,

Line 2476: l_t1 := DBMS_UTILITY.GET_TIME;

2472: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2473: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': Calling pricing engine...');
2474: END IF;
2475:
2476: l_t1 := DBMS_UTILITY.GET_TIME;
2477: QP_PREQ_PUB.PRICE_REQUEST
2478: (p_control_rec => l_control_rec,
2479: x_return_status => x_return_status,
2480: x_return_status_text => x_return_status_text);

Line 2481: l_t2 := DBMS_UTILITY.GET_TIME;

2477: QP_PREQ_PUB.PRICE_REQUEST
2478: (p_control_rec => l_control_rec,
2479: x_return_status => x_return_status,
2480: x_return_status_text => x_return_status_text);
2481: l_t2 := DBMS_UTILITY.GET_TIME;
2482:
2483: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2484: ibe_util.debug(g_pkg_name||'.'||L_API||': Duration of Price Request Time(s) ='|| (l_t2-l_t1)/100);
2485: END IF;

Line 2543: l_start_time := DBMS_UTILITY.GET_TIME;

2539: l_curr_time NUMBER;
2540: BEGIN
2541: L_API := 'PRICE_REQUEST';
2542: --IBE_UTIL.debug(G_PKG_NAME||'.'||L_API||': begin');
2543: l_start_time := DBMS_UTILITY.GET_TIME;
2544: IF p_item_tbl IS NOT NULL AND p_uom_code_tbl IS NOT NULL AND p_line_quantity_tbl IS NOT NULL THEN
2545: l_total_lines := p_item_tbl.COUNT;
2546: --IBE_UTIL.debug(G_PKG_NAME||'.'||L_API||': total line items: '||l_total_lines);
2547: IF l_total_lines = p_uom_code_tbl.COUNT AND l_total_lines = p_line_quantity_tbl.COUNT THEN

Line 2554: l_curr_time := DBMS_UTILITY.GET_TIME;

2550: l_itmid_tbl(idx) := p_item_tbl(idx);
2551: l_uom_code_tbl(idx) := p_uom_code_tbl(idx);
2552: l_line_quantity_tbl(idx) := p_line_quantity_tbl(idx);
2553: END LOOP;
2554: l_curr_time := DBMS_UTILITY.GET_TIME;
2555: IF p_parentIndex_tbl IS NOT NULL AND p_childIndex_tbl IS NOT NULL THEN
2556: l_total_lines := p_parentIndex_tbl.count;
2557:
2558: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2597: l_curr_time := DBMS_UTILITY.GET_TIME;

2593: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2594: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api||':sending request...');
2595: END IF;
2596:
2597: l_curr_time := DBMS_UTILITY.GET_TIME;
2598: IBE_PRICE_PVT.PRICE_REQUEST(
2599: p_price_list_id => p_price_list_id,
2600: p_party_id => p_party_id,
2601: p_cust_account_id => p_cust_account_id,

Line 2616: l_curr_time := DBMS_UTILITY.GET_TIME;

2612: x_price_csr => x_price_csr,
2613: x_line_index_tbl=> x_line_index_tbl,
2614: x_return_status => x_return_status,
2615: x_return_status_text => x_return_status_text);
2616: l_curr_time := DBMS_UTILITY.GET_TIME;
2617:
2618: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2619: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api||':done, return status = '||x_return_status||': '||x_return_status_text);
2620: END IF;

Line 2652: l_end_time := DBMS_UTILITY.GET_TIME;

2648: END IF;
2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: x_return_status_text := 'invalid request lines - input table(s) is null';
2651: END IF;
2652: l_end_time := DBMS_UTILITY.GET_TIME;
2653:
2654: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2655: IBE_UTIL.debug(G_PKG_NAME||'.'||L_API||': end, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2656: END IF;