APPS.IEU_DIAGNOSTICS_PVT dependencies on DBMS_UTILITY

Line 1750: t1 := DBMS_UTILITY.GET_TIME;

1746:
1747: l_medias := IEU_DIAG_STRING_NST();
1748: l_total_time := 0;
1749:
1750: t1 := DBMS_UTILITY.GET_TIME;
1751:
1752: Check_User_Resp(x_return_status, x_msg_count, x_msg_data,
1753: p_user_name, p_responsibility, l_user_id, l_responsibility_id, l_application_id);
1754:

Line 1755: t2 := DBMS_UTILITY.GET_TIME;

1751:
1752: Check_User_Resp(x_return_status, x_msg_count, x_msg_data,
1753: p_user_name, p_responsibility, l_user_id, l_responsibility_id, l_application_id);
1754:
1755: t2 := DBMS_UTILITY.GET_TIME;
1756:
1757: x_user_ver_time := (t2 -t1)*10;
1758: --DBMS_OUTPUT.put_line('verified userid and resp values, time taken - '|| x_user_ver_time);
1759:

Line 1790: t1 := DBMS_UTILITY.GET_TIME;

1786: FOR c_rec in c_eproc LOOP
1787:
1788: BEGIN
1789:
1790: t1 := DBMS_UTILITY.GET_TIME;
1791:
1792: --get the details of a node
1793: /* SELECT lu.MEANING into l_vnode_label
1794: from IEU_UWQ_SEL_ENUMERATORS u, FND_LOOKUP_VALUES lu

Line 1819: t1 := DBMS_UTILITY.GET_TIME;

1815: --starting time
1816: enum_status := 'S';
1817:
1818:
1819: t1 := DBMS_UTILITY.GET_TIME;
1820: --DBMS_OUTPUT.put_line('after select enum id==='||c_rec.SEL_ENUM_ID);
1821: --DBMS_OUTPUT.put_line('start time== '||t1);
1822:
1823:

Line 2005: t2 := DBMS_UTILITY.GET_TIME;

2001: END;
2002:
2003: --end time
2004:
2005: t2 := DBMS_UTILITY.GET_TIME;
2006: l_time_spent := (t2 - t1)*10;
2007:
2008: --DBMS_OUTPUT.put_line('node - '||l_time_spent);
2009:

Line 2027: temp1 := DBMS_UTILITY.GET_TIME;

2023:
2024: END LOOP;
2025:
2026: --
2027: temp1 := DBMS_UTILITY.GET_TIME;
2028:
2029: begin
2030: select
2031: rownum

Line 2115: temp2 := DBMS_UTILITY.GET_TIME;

2111: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2112: x_msg_data := x_msg_data || ',' || l_msg_data;
2113: END LOOP;
2114:
2115: temp2 := DBMS_UTILITY.GET_TIME;
2116:
2117: x_etime_grand_total := l_total_time ;
2118:
2119: --DBMS_OUTPUT.put_line('final total time ='|| x_etime_grand_total);

Line 2726: t1 := DBMS_UTILITY.GET_TIME;

2722: FOR node in c_nodes
2723: LOOP
2724:
2725: refresh_status := 'S';--Succeeded
2726: t1 := DBMS_UTILITY.GET_TIME;
2727: --DBMS_OUTPUT.put_line('start time== '||t1);
2728:
2729: begin
2730: null;

Line 2770: t2 := DBMS_UTILITY.GET_TIME;

2766: Refresh_Node(node.node_id, node.node_pid, node.sel_enum_id, node.where_clause,
2767: node.res_cat_enum_flag, node.refresh_view_name, node.refresh_view_sum_col,
2768: node.sel_rt_node_id, l_count, l_resource_id, node.view_name, node.node_label, l_invalid_rproc);
2769:
2770: t2 := DBMS_UTILITY.GET_TIME;
2771: --DBMS_OUTPUT.put_line('end time=== '||t2);
2772: l_time_spent := (t2 - t1)*10;
2773: --DBMS_OUTPUT.put_line('Difference***-- '||l_time_spent);
2774: l_rtotal_time := l_rtotal_time + l_time_spent;

Line 2841: t1 := DBMS_UTILITY.GET_TIME;

2837: fetch c_media_nodes
2838: into l_sel_rt_node_id,l_node_id, l_node_pid, l_where_clause, l_sel_enum_id,
2839: l_refresh_view_name,l_refresh_view_sum_col, l_res_cat_enum_flag, l_view_name, l_node_label, l_node_weight;
2840:
2841: t1 := DBMS_UTILITY.GET_TIME;
2842: --DBMS_OUTPUT.put_line('start time== '||t1);
2843:
2844: if c_media_nodes%NOTFOUND then
2845: null;

Line 2884: t2 := DBMS_UTILITY.GET_TIME;

2880: Refresh_Node(l_node_id, l_node_pid, l_sel_enum_id, l_where_clause,
2881: l_res_cat_enum_flag, l_refresh_view_name, l_refresh_view_sum_col,
2882: l_sel_rt_node_id, l_count, l_resource_id,l_view_name, l_node_label, l_invalid_rproc);
2883:
2884: t2 := DBMS_UTILITY.GET_TIME;
2885: --DBMS_OUTPUT.put_line('end time=== '||t2);
2886: l_time_spent := (t2 - t1)*10;
2887: --DBMS_OUTPUT.put_line('Difference***-- '||l_time_spent);
2888: l_rtotal_time := l_rtotal_time + l_time_spent;