eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on JTF_TASKS_V

Line 16: -- used respective _vl tables instead of using jtf_tasks_vl

12: -- Date Name Desc
13: -- ------- -------- ------------------------------------------------------------
14: -- 01/06/06 smisra fixed bug 4871341
15: -- to get task priority, type and status names,
16: -- used respective _vl tables instead of using jtf_tasks_vl
17: -- This was to avoid excessive shared memory used by sql
18: -- -----------------------------------------------------------------------------
19: PROCEDURE start_task_workflow (p_task_id IN NUMBER,
20: p_tsk_typ_attr_dep_id IN NUMBER,

Line 35: l_task_status_name jtf_tasks_v.task_status%type ;

31: l_owner_user_name fnd_user.user_name%TYPE;
32: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
33: l_owner_id jtf_tasks_b.owner_id%TYPE;
34: l_task_number jtf_tasks_b.task_number%TYPE;
35: l_task_status_name jtf_tasks_v.task_status%type ;
36: l_task_type_name jtf_tasks_v.task_type%type ;
37: l_task_priority_name jtf_tasks_v.task_priority%type ;
38: l_task_status_id jtf_tasks_b.task_status_id%type ;
39: l_task_type_id jtf_tasks_b.task_type_id%type ;

Line 36: l_task_type_name jtf_tasks_v.task_type%type ;

32: l_owner_code jtf_tasks_b.owner_type_code%TYPE;
33: l_owner_id jtf_tasks_b.owner_id%TYPE;
34: l_task_number jtf_tasks_b.task_number%TYPE;
35: l_task_status_name jtf_tasks_v.task_status%type ;
36: l_task_type_name jtf_tasks_v.task_type%type ;
37: l_task_priority_name jtf_tasks_v.task_priority%type ;
38: l_task_status_id jtf_tasks_b.task_status_id%type ;
39: l_task_type_id jtf_tasks_b.task_type_id%type ;
40: l_task_priority_id jtf_tasks_b.task_priority_id%type ;

Line 37: l_task_priority_name jtf_tasks_v.task_priority%type ;

33: l_owner_id jtf_tasks_b.owner_id%TYPE;
34: l_task_number jtf_tasks_b.task_number%TYPE;
35: l_task_status_name jtf_tasks_v.task_status%type ;
36: l_task_type_name jtf_tasks_v.task_type%type ;
37: l_task_priority_name jtf_tasks_v.task_priority%type ;
38: l_task_status_id jtf_tasks_b.task_status_id%type ;
39: l_task_type_id jtf_tasks_b.task_type_id%type ;
40: l_task_priority_id jtf_tasks_b.task_priority_id%type ;
41: current_record NUMBER;

Line 1096: l_type jtf_tasks_v.task_type % type;

1092: --------------------------------------------------
1093: FUNCTION Are_task_Attributes_valid(p_task_type_id number,
1094: p_task_status_id number,
1095: p_task_priority_id number) return varchar2 is
1096: l_type jtf_tasks_v.task_type % type;
1097: l_status jtf_tasks_v.task_status % type;
1098: l_priority jtf_tasks_v.task_priority % type;
1099: l_type_id number;
1100: l_status_id number;

Line 1097: l_status jtf_tasks_v.task_status % type;

1093: FUNCTION Are_task_Attributes_valid(p_task_type_id number,
1094: p_task_status_id number,
1095: p_task_priority_id number) return varchar2 is
1096: l_type jtf_tasks_v.task_type % type;
1097: l_status jtf_tasks_v.task_status % type;
1098: l_priority jtf_tasks_v.task_priority % type;
1099: l_type_id number;
1100: l_status_id number;
1101: l_priority_id number;

Line 1098: l_priority jtf_tasks_v.task_priority % type;

1094: p_task_status_id number,
1095: p_task_priority_id number) return varchar2 is
1096: l_type jtf_tasks_v.task_type % type;
1097: l_status jtf_tasks_v.task_status % type;
1098: l_priority jtf_tasks_v.task_priority % type;
1099: l_type_id number;
1100: l_status_id number;
1101: l_priority_id number;
1102: x_return_status varchar2(10);