81: function get_total_time(ssid number,
82: prd varchar2,
83: pname varchar2)
84: return varchar2 is
85: TYPE job_name IS TABLE OF ad_task_timing.job_name%TYPE;
86: TYPE start_time IS TABLE OF ad_task_timing.start_time%TYPE;
87: TYPE end_time IS TABLE OF ad_task_timing.end_time%TYPE;
88:
89: l_job_name job_name;
82: prd varchar2,
83: pname varchar2)
84: return varchar2 is
85: TYPE job_name IS TABLE OF ad_task_timing.job_name%TYPE;
86: TYPE start_time IS TABLE OF ad_task_timing.start_time%TYPE;
87: TYPE end_time IS TABLE OF ad_task_timing.end_time%TYPE;
88:
89: l_job_name job_name;
90: l_start_time start_time;
83: pname varchar2)
84: return varchar2 is
85: TYPE job_name IS TABLE OF ad_task_timing.job_name%TYPE;
86: TYPE start_time IS TABLE OF ad_task_timing.start_time%TYPE;
87: TYPE end_time IS TABLE OF ad_task_timing.end_time%TYPE;
88:
89: l_job_name job_name;
90: l_start_time start_time;
91: l_end_time end_time;
103: end_time
104: BULK COLLECT INTO l_job_name,
105: l_start_time,
106: l_end_time
107: FROM ad_task_timing
108: WHERE session_id=ssid
109: AND phase_name=pname
110: AND (product=prd OR
111: (product='java' AND ((arguments like '%fullpath:'||prd||':%') OR
119: end_time
120: BULK COLLECT INTO l_job_name,
121: l_start_time,
122: l_end_time
123: FROM ad_task_timing
124: WHERE session_id=ssid
125: AND phase_name=pname
126: AND prd=NVL(DECODE(product,
127: 'java',