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_B

Line 32: l_owner_code jtf_tasks_b.owner_type_code%TYPE;

28: ) IS
29: l_wf_process_id NUMBER;
30: l_itemkey wf_item_activity_statuses.item_key%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 ;

Line 33: l_owner_id jtf_tasks_b.owner_id%TYPE;

29: l_wf_process_id NUMBER;
30: l_itemkey wf_item_activity_statuses.item_key%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 ;

Line 34: l_task_number jtf_tasks_b.task_number%TYPE;

30: l_itemkey wf_item_activity_statuses.item_key%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 ;

Line 38: l_task_status_id jtf_tasks_b.task_status_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;
42: source_text VARCHAR2(200);

Line 39: l_task_type_id jtf_tasks_b.task_type_id%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;
42: source_text VARCHAR2(200);
43: l_errname varchar2(60);

Line 40: l_task_priority_id jtf_tasks_b.task_priority_id%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;
42: source_text VARCHAR2(200);
43: l_errname varchar2(60);
44: l_errmsg varchar2(2000);

Line 90: from jtf_tasks_b where task_id = p_task_id ;

86:
87: select task_status_id, task_priority_id , task_type_id, task_number
88: into l_task_status_id, l_task_priority_id , l_task_type_id,
89: l_task_number
90: from jtf_tasks_b where task_id = p_task_id ;
91:
92: SELECT name
93: INTO l_task_type_name
94: FROM jtf_task_types_vl

Line 262: l_planned_effort jtf_tasks_b.planned_effort % type;

258: and sr_attribute_code = p_sr_ea_attr_code);
259: --
260: -- Cursor to get planned effort and UOM
261: l_rule jtf_task_types_b.rule % type;
262: l_planned_effort jtf_tasks_b.planned_effort % type;
263: l_planned_effort_uom jtf_tasks_b.planned_effort_uom % type;
264: l_workflow jtf_task_types_b.workflow % type;
265: l_workflow_type jtf_task_types_b.workflow_type % type;
266: cursor c_planned_effort is

Line 263: l_planned_effort_uom jtf_tasks_b.planned_effort_uom % type;

259: --
260: -- Cursor to get planned effort and UOM
261: l_rule jtf_task_types_b.rule % type;
262: l_planned_effort jtf_tasks_b.planned_effort % type;
263: l_planned_effort_uom jtf_tasks_b.planned_effort_uom % type;
264: l_workflow jtf_task_types_b.workflow % type;
265: l_workflow_type jtf_task_types_b.workflow_type % type;
266: cursor c_planned_effort is
267: select planned_effort, planned_effort_uom, rule, workflow, nvl(workflow_type,'JTFTASK')

Line 276: l_task_status_id jtf_tasks_b.task_status_id % type;

272: ;
273: --
274: -- cursor to task attributes
275: l_tsk_typ_attr_dep_id cug_sr_task_type_dets_b.tsk_typ_attr_dep_id % type;
276: l_task_status_id jtf_tasks_b.task_status_id % type;
277: l_task_priority_id jtf_tasks_b.task_priority_id % type;
278: l_task_name jtf_tasks_tl.task_name % type;
279: l_task_desc jtf_tasks_tl.description % type;
280: l_publish_flag jtf_tasks_b.publish_flag % type;

Line 277: l_task_priority_id jtf_tasks_b.task_priority_id % type;

273: --
274: -- cursor to task attributes
275: l_tsk_typ_attr_dep_id cug_sr_task_type_dets_b.tsk_typ_attr_dep_id % type;
276: l_task_status_id jtf_tasks_b.task_status_id % type;
277: l_task_priority_id jtf_tasks_b.task_priority_id % type;
278: l_task_name jtf_tasks_tl.task_name % type;
279: l_task_desc jtf_tasks_tl.description % type;
280: l_publish_flag jtf_tasks_b.publish_flag % type;
281: l_private_flag jtf_tasks_b.private_flag % type;

Line 280: l_publish_flag jtf_tasks_b.publish_flag % type;

276: l_task_status_id jtf_tasks_b.task_status_id % type;
277: l_task_priority_id jtf_tasks_b.task_priority_id % type;
278: l_task_name jtf_tasks_tl.task_name % type;
279: l_task_desc jtf_tasks_tl.description % type;
280: l_publish_flag jtf_tasks_b.publish_flag % type;
281: l_private_flag jtf_tasks_b.private_flag % type;
282: CURSOR c_task_attributes IS
283: SELECT
284: task_status_id

Line 281: l_private_flag jtf_tasks_b.private_flag % type;

277: l_task_priority_id jtf_tasks_b.task_priority_id % type;
278: l_task_name jtf_tasks_tl.task_name % type;
279: l_task_desc jtf_tasks_tl.description % type;
280: l_publish_flag jtf_tasks_b.publish_flag % type;
281: l_private_flag jtf_tasks_b.private_flag % type;
282: CURSOR c_task_attributes IS
283: SELECT
284: task_status_id
285: , task_priority_id

Line 688: l_task_id jtf_tasks_b.task_id % type;

684: x_field_service_Task_created OUT NOCOPY varchar2) is
685: l_task_rec_tbl ea_task_table_type;
686: l_task_attr_rec cs_sr_task_autoassign_pkg.Sr_Task_rec_type;
687: l_indx number;
688: l_task_id jtf_tasks_b.task_id % type;
689: l_login_id jtf_notes_b.last_update_login % type;
690: l_user_id jtf_notes_b.last_updated_by % type;
691: l_obj_version cs_incidents_all_b.object_version_number % type;
692: l_owner_type cs_incidents_all_b.resource_type % type;

Line 698: l_task_owner_type jtf_tasks_b.owner_type_code % type;

694: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
695: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
696: l_group_type varchar2(50);
697: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;
698: l_task_owner_type jtf_tasks_b.owner_type_code % type;
699: l_task_owner_id jtf_tasks_b.owner_id%type;
700: l_location_id cs_incidents_all_b.incident_location_id % type;
701: l_dummy varchar2(80);
702: l_address_id NUMBER;

Line 699: l_task_owner_id jtf_tasks_b.owner_id%type;

695: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
696: l_group_type varchar2(50);
697: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;
698: l_task_owner_type jtf_tasks_b.owner_type_code % type;
699: l_task_owner_id jtf_tasks_b.owner_id%type;
700: l_location_id cs_incidents_all_b.incident_location_id % type;
701: l_dummy varchar2(80);
702: l_address_id NUMBER;
703: l_customer_id NUMBER := p_sr_rec.customer_id;