APPS.CUG_GENERIC_WF_PKG dependencies on JTF_TASKS_V

Line 1369: SELECT tsk.task_number, tsk.task_id, tsk.task_type_id, sts.name FROM JTF_TASKS_VL tsk, JTF_TASK_STATUSES_VL sts WHERE

1365:
1366: l_API_ERROR EXCEPTION;
1367:
1368: CURSOR c_SRTasks_csr IS
1369: SELECT tsk.task_number, tsk.task_id, tsk.task_type_id, sts.name FROM JTF_TASKS_VL tsk, JTF_TASK_STATUSES_VL sts WHERE
1370: tsk.task_status_id = sts.task_status_id and
1371: tsk.SOURCE_OBJECT_ID = l_request_id and
1372: tsk.source_object_type_code = 'SR';
1373: l_SRTasks_rec c_SRTasks_csr%ROWTYPE;

Line 1662: l_task_status_name jtf_tasks_v.task_status%type ;

1658: l_description jtf_tasks_tl.description%TYPE;
1659: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
1660: l_owner_id jtf_tasks_b.owner_id%TYPE;
1661: l_task_number jtf_tasks_b.task_number%TYPE;
1662: l_task_status_name jtf_tasks_v.task_status%type ;
1663: l_task_type_name jtf_tasks_v.task_type%type ;
1664: l_task_priority_name jtf_tasks_v.task_priority%type ;
1665: current_record NUMBER;
1666: source_text VARCHAR2(200);

Line 1663: l_task_type_name jtf_tasks_v.task_type%type ;

1659: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
1660: l_owner_id jtf_tasks_b.owner_id%TYPE;
1661: l_task_number jtf_tasks_b.task_number%TYPE;
1662: l_task_status_name jtf_tasks_v.task_status%type ;
1663: l_task_type_name jtf_tasks_v.task_type%type ;
1664: l_task_priority_name jtf_tasks_v.task_priority%type ;
1665: current_record NUMBER;
1666: source_text VARCHAR2(200);
1667: l_errname varchar2(60);

Line 1664: l_task_priority_name jtf_tasks_v.task_priority%type ;

1660: l_owner_id jtf_tasks_b.owner_id%TYPE;
1661: l_task_number jtf_tasks_b.task_number%TYPE;
1662: l_task_status_name jtf_tasks_v.task_status%type ;
1663: l_task_type_name jtf_tasks_v.task_type%type ;
1664: l_task_priority_name jtf_tasks_v.task_priority%type ;
1665: current_record NUMBER;
1666: source_text VARCHAR2(200);
1667: l_errname varchar2(60);
1668: l_errmsg varchar2(2000);

Line 1681: FROM jtf_tasks_v

1677: CURSOR c_task_details
1678: IS
1679: SELECT task_name, description, owner_type_code owner_code, owner_id, task_number
1680:
1681: FROM jtf_tasks_v
1682: WHERE task_id = p_task_id;
1683: BEGIN
1684:
1685:

Line 1754: from jtf_tasks_v where task_id = p_task_id ;

1750: );
1751:
1752: select task_status, task_priority , task_type
1753: into l_task_status_name, l_task_priority_name , l_task_type_name
1754: from jtf_tasks_v where task_id = p_task_id ;
1755:
1756:
1757: wf_engine.setitemattrtext (
1758: itemtype => 'JTFTASK',