APPS.JTF_TASK_WORKFLOW_PKG dependencies on JTF_TASKS_B

Line 201: l_owner_code jtf_tasks_b.owner_type_code%TYPE;

197: l_new_assigned_user_name fnd_user.user_name%TYPE;
198: l_owner_user_name fnd_user.user_name%TYPE;
199: l_task_name jtf_tasks_tl.task_name%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 ;

Line 202: l_owner_id jtf_tasks_b.owner_id%TYPE;

198: l_owner_user_name fnd_user.user_name%TYPE;
199: l_task_name jtf_tasks_tl.task_name%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 ;

Line 203: l_task_number jtf_tasks_b.task_number%TYPE;

199: l_task_name jtf_tasks_tl.task_name%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;

Line 330: from jtf_tasks_b a,

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
330: from jtf_tasks_b a,
331: jtf_task_statuses_tl b,
332: jtf_task_priorities_tl c,
333: jtf_task_types_tl d
334: where a.task_id = p_task_id

Line 734: l_owner_code jtf_tasks_b.owner_type_code%TYPE;

730: l_wf_process_id NUMBER;
731: l_itemkey wf_item_activity_statuses.item_key%TYPE;
732: l_task_name jtf_tasks_tl.task_name%TYPE;
733: l_description jtf_tasks_tl.description%TYPE;
734: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
735: l_owner_id jtf_tasks_b.owner_id%TYPE;
736: l_aborted_by_user_name fnd_user.user_name%TYPE;
737: l_task_owner_name fnd_user.user_name%TYPE;
738: l_context VARCHAR2(100);

Line 735: l_owner_id jtf_tasks_b.owner_id%TYPE;

731: l_itemkey wf_item_activity_statuses.item_key%TYPE;
732: l_task_name jtf_tasks_tl.task_name%TYPE;
733: l_description jtf_tasks_tl.description%TYPE;
734: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
735: l_owner_id jtf_tasks_b.owner_id%TYPE;
736: l_aborted_by_user_name fnd_user.user_name%TYPE;
737: l_task_owner_name fnd_user.user_name%TYPE;
738: l_context VARCHAR2(100);
739: l_notification_id NUMBER;