DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on DBMS_UTILITY

Line 2383: l_sourcing_start_time := dbms_utility.get_time;

2379: IF l_debug = Fnd_Api.G_TRUE THEN
2380: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');
2381: END IF;
2382: --setting time
2383: l_sourcing_start_time := dbms_utility.get_time;
2384:
2385: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2386: -- 13638721
2387: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);

Line 2572: l_sourcing_end_time := dbms_utility.get_time;

2568: Oe_Debug_Pub.ADD('##### End Build Contexts #####');
2569:
2570: END IF;
2571: --setting time
2572: l_sourcing_end_time := dbms_utility.get_time;
2573: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
2574:
2575: IF l_debug = Fnd_Api.G_TRUE THEN
2576: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');

Line 2693: l_sourcing_start_time := dbms_utility.get_time;

2689:
2690: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2691:
2692: --setting time
2693: l_sourcing_start_time := dbms_utility.get_time;
2694:
2695: l_price_contexts_result_tbl.DELETE;
2696: l_qual_contexts_result_tbl.DELETE;
2697:

Line 3495: l_sourcing_end_time := dbms_utility.get_time;

3491: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');
3492:
3493: END IF;
3494: --setting time
3495: l_sourcing_end_time := dbms_utility.get_time;
3496: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
3497:
3498: IF l_debug = Fnd_Api.G_TRUE THEN
3499: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');