DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on DBMS_UTILITY

Line 2016: l_start_time := DBMS_UTILITY.GET_TIME;

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

Line 2115: l_end_time := DBMS_UTILITY.GET_TIME;

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

Line 2225: l_start_time := DBMS_UTILITY.GET_TIME;

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

Line 2327: l_end_time := DBMS_UTILITY.GET_TIME;

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

Line 2406: l_start_time := DBMS_UTILITY.GET_TIME;

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

Line 2447: l_end_time := DBMS_UTILITY.GET_TIME;

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

Line 2551: l_start_time := DBMS_UTILITY.GET_TIME;

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

Line 2658: l_end_time := DBMS_UTILITY.GET_TIME;

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

Line 2728: l_start_time := DBMS_UTILITY.GET_TIME;

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

Line 2844: l_end_time := DBMS_UTILITY.GET_TIME;

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

Line 2923: l_start_time := DBMS_UTILITY.GET_TIME;

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

Line 2963: l_end_time := DBMS_UTILITY.GET_TIME;

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