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 CS_INCIDENTS_ALL_B

Line 691: l_obj_version cs_incidents_all_b.object_version_number % 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;
693: l_owner_id cs_incidents_all_b.incident_owner_id % 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;

Line 692: l_owner_type cs_incidents_all_b.resource_type % type;

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;
693: l_owner_id cs_incidents_all_b.incident_owner_id % 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);

Line 693: l_owner_id cs_incidents_all_b.incident_owner_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;
693: l_owner_id cs_incidents_all_b.incident_owner_id % 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 ;

Line 694: l_owner_group_id cs_incidents_all_b.owner_group_id % 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;
693: l_owner_id cs_incidents_all_b.incident_owner_id % 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;

Line 695: l_last_updated_by cs_incidents_all_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;
693: l_owner_id cs_incidents_all_b.incident_owner_id % 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;

Line 700: l_location_id cs_incidents_all_b.incident_location_id % 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;
704: l_task_assignment_id Number; --5686743

Line 1172: l_incident_number cs_incidents_all_b.incident_number % type;

1168: l_note_type jtf_notes_b.note_type % type;
1169: l_login_id jtf_notes_b.last_update_login % type;
1170: l_user_id jtf_notes_b.last_updated_by % type;
1171: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1172: l_incident_number cs_incidents_all_b.incident_number % type;
1173: cursor c_sr is
1174: select * from cs_incidents_all_b
1175: where incident_id = p_request_id;
1176: begin

Line 1174: select * from cs_incidents_all_b

1170: l_user_id jtf_notes_b.last_updated_by % type;
1171: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1172: l_incident_number cs_incidents_all_b.incident_number % type;
1173: cursor c_sr is
1174: select * from cs_incidents_all_b
1175: where incident_id = p_request_id;
1176: begin
1177: l_prof_value := fnd_profile.value('AUTO GENERATE TASKS ON SR CREATE');
1178: if (l_prof_value = 'Task type Attribute configuration' or 1 =1) then