APPS.JTF_TASK_WORKFLOW_PKG dependencies on JTF_TASKS_V

Line 204: l_task_status_name jtf_tasks_v.task_status%type ;

200: l_description jtf_tasks_tl.description%TYPE;
201: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
202: l_owner_id jtf_tasks_b.owner_id%TYPE;
203: l_task_number jtf_tasks_b.task_number%TYPE;
204: l_task_status_name jtf_tasks_v.task_status%type ;
205: l_task_type_name jtf_tasks_v.task_type%type ;
206: l_task_priority_name jtf_tasks_v.task_priority%type ;
207: current_record NUMBER;
208: source_text VARCHAR2(200);

Line 205: l_task_type_name jtf_tasks_v.task_type%type ;

201: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
202: l_owner_id jtf_tasks_b.owner_id%TYPE;
203: l_task_number jtf_tasks_b.task_number%TYPE;
204: l_task_status_name jtf_tasks_v.task_status%type ;
205: l_task_type_name jtf_tasks_v.task_type%type ;
206: l_task_priority_name jtf_tasks_v.task_priority%type ;
207: current_record NUMBER;
208: source_text VARCHAR2(200);
209: l_errname varchar2(60);

Line 206: l_task_priority_name jtf_tasks_v.task_priority%type ;

202: l_owner_id jtf_tasks_b.owner_id%TYPE;
203: l_task_number jtf_tasks_b.task_number%TYPE;
204: l_task_status_name jtf_tasks_v.task_status%type ;
205: l_task_type_name jtf_tasks_v.task_type%type ;
206: l_task_priority_name jtf_tasks_v.task_priority%type ;
207: current_record NUMBER;
208: source_text VARCHAR2(200);
209: l_errname varchar2(60);
210: l_errmsg varchar2(2000);

Line 222: FROM jtf_tasks_v

218: -- Commented out by SBARAT on 23/02/2006 for bug# 5045559
219: /*CURSOR c_task_details
220: IS
221: SELECT task_name, description, owner_type_code owner_code, owner_id, task_number
222: FROM jtf_tasks_v
223: WHERE task_id = p_task_id;*/
224:
225: -- Added by SBARAT on 23/02/2006 for bug# 5045559
226: CURSOR c_task_details

Line 229: FROM jtf_tasks_vl a

225: -- Added by SBARAT on 23/02/2006 for bug# 5045559
226: CURSOR c_task_details
227: IS
228: SELECT a.task_name, a.description, a.owner_type_code owner_code, a.owner_id, a.task_number
229: FROM jtf_tasks_vl a
230: WHERE a.task_id = p_task_id
231: AND (a.deleted_flag <> 'Y' OR a.deleted_flag is null)
232: AND a.task_type_id <> 22;
233:

Line 325: from jtf_tasks_v where task_id = p_task_id ;*/

321:
322: -- Commented out by SBARAT on 23/02/2006 for bug# 5045559
323: /*select task_status, task_priority , task_type
324: into l_task_status_name, l_task_priority_name , l_task_type_name
325: from jtf_tasks_v where task_id = p_task_id ;*/
326:
327: -- Added by SBARAT on 23/02/2006 for bug# 5045559
328: select b.name task_status, c.name task_priority , d.name task_type
329: into l_task_status_name, l_task_priority_name , l_task_type_name

Line 724: FROM jtf_tasks_vl

720: IS
721: CURSOR c_task_details
722: IS
723: SELECT task_name, description, owner_type_code owner_code, owner_id
724: FROM jtf_tasks_vl
725: WHERE task_id = p_task_id;
726:
727: l_api_version CONSTANT NUMBER := 1.0;
728: l_api_name CONSTANT VARCHAR2(30)