DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on DBMS_UTILITY

Line 2015: l_start_time := DBMS_UTILITY.GET_TIME;

2011:
2012: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2013: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(+)');
2014: END IF;
2015: l_start_time := DBMS_UTILITY.GET_TIME;
2016:
2017: -- get the select and from clauses of the query
2018: Get_Basic_Item_Load_Query(p_load_level, l_itm_stmt);
2019:

Line 2114: l_end_time := DBMS_UTILITY.GET_TIME;

2110: ELSE
2111: x_model_bundle_flag := FND_API.G_FALSE;
2112: END IF;
2113:
2114: l_end_time := DBMS_UTILITY.GET_TIME;
2115: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2116: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2117: END IF;
2118: --end API body

Line 2224: l_start_time := DBMS_UTILITY.GET_TIME;

2220: BEGIN
2221: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2222: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(+), item ='||p_itmid);
2223: END IF;
2224: l_start_time := DBMS_UTILITY.GET_TIME;
2225:
2226: --don't convert model_id=-1 here
2227: --IF p_model_id = -1 THEN
2228: --l_model_id := FND_API.G_MISS_NUM;

Line 2326: l_end_time := DBMS_UTILITY.GET_TIME;

2322: x_line_index_tbl => x_line_index_tbl,
2323: x_return_status => x_return_status,
2324: x_return_status_text=> x_return_status_text);
2325:
2326: l_end_time := DBMS_UTILITY.GET_TIME;
2327: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');
2329: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2330: END IF;

Line 2405: l_start_time := DBMS_UTILITY.GET_TIME;

2401:
2402: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2403: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(+)');
2404: END IF;
2405: l_start_time := DBMS_UTILITY.GET_TIME;
2406: -- load item inventory info
2407: FETCH_ITEM(
2408: p_api_version,
2409: p_init_msg_list,

Line 2446: l_end_time := DBMS_UTILITY.GET_TIME;

2442: x_return_status => x_price_status_code,
2443: x_return_status_text => x_price_status_text);
2444: END IF;
2445:
2446: l_end_time := DBMS_UTILITY.GET_TIME;
2447: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2448: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2449: END IF;
2450: --end API body

Line 2550: l_start_time := DBMS_UTILITY.GET_TIME;

2546:
2547: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2548: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(+)');
2549: END IF;
2550: l_start_time := DBMS_UTILITY.GET_TIME;
2551:
2552: -- get the select and from clauses of the query
2553: l_itmid_tbl := JTF_NUMBER_TABLE();
2554:

Line 2657: l_end_time := DBMS_UTILITY.GET_TIME;

2653: x_model_bundle_flag_tbl(l_table_index) := FND_API.G_FALSE;
2654: END IF;
2655: END LOOP;
2656:
2657: l_end_time := DBMS_UTILITY.GET_TIME;
2658: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2659: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2660: END IF;
2661: --end API body

Line 2727: l_start_time := DBMS_UTILITY.GET_TIME;

2723: BEGIN
2724: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2725: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2726: END IF;
2727: l_start_time := DBMS_UTILITY.GET_TIME;
2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2729: l_model_id_tbl := JTF_NUMBER_TABLE();
2730: idx := 1;
2731: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2843: l_end_time := DBMS_UTILITY.GET_TIME;

2839: x_return_status => x_return_status,
2840: x_return_status_text=> x_return_status_text);
2841:
2842:
2843: l_end_time := DBMS_UTILITY.GET_TIME;
2844: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2845: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':pricing done');
2846: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2847: END IF;

Line 2922: l_start_time := DBMS_UTILITY.GET_TIME;

2918: -- load inv info
2919: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2920: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading inventory info...');
2921: END IF;
2922: l_start_time := DBMS_UTILITY.GET_TIME;
2923: FETCH_ITEMS(p_load_level =>p_load_level,
2924: p_itmid_tbl =>p_itmid_tbl,
2925: p_partnum_tbl =>p_partnum_tbl,
2926: p_organization_id =>p_organization_id,

Line 2962: l_end_time := DBMS_UTILITY.GET_TIME;

2958: --end API body
2959:
2960: -- standard call to get message count and if count is 1, get message info.
2961: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2962: l_end_time := DBMS_UTILITY.GET_TIME;
2963: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2964: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2965: END IF;
2966: