DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on DBMS_UTILITY

Line 2312: l_sourcing_start_time := dbms_utility.get_time;

2308: IF l_debug = Fnd_Api.G_TRUE THEN
2309: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');
2310: END IF;
2311: --setting time
2312: l_sourcing_start_time := dbms_utility.get_time;
2313:
2314: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2315:
2316: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

Line 2459: l_sourcing_end_time := dbms_utility.get_time;

2455: Oe_Debug_Pub.ADD('##### End Build Contexts #####');
2456:
2457: END IF;
2458: --setting time
2459: l_sourcing_end_time := dbms_utility.get_time;
2460: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
2461:
2462: IF l_debug = Fnd_Api.G_TRUE THEN
2463: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');

Line 2575: l_sourcing_start_time := dbms_utility.get_time;

2571:
2572: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2573:
2574: --setting time
2575: l_sourcing_start_time := dbms_utility.get_time;
2576:
2577: l_price_contexts_result_tbl.DELETE;
2578: l_qual_contexts_result_tbl.DELETE;
2579:

Line 3237: l_sourcing_end_time := dbms_utility.get_time;

3233: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');
3234:
3235: END IF;
3236: --setting time
3237: l_sourcing_end_time := dbms_utility.get_time;
3238: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
3239:
3240: IF l_debug = Fnd_Api.G_TRUE THEN
3241: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');