DBA Data[Home] [Help]

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 690: l_obj_version cs_incidents_all_b.object_version_number % type;

686: l_indx number;
687: l_task_id jtf_tasks_b.task_id % type;
688: l_login_id jtf_notes_b.last_update_login % type;
689: l_user_id jtf_notes_b.last_updated_by % type;
690: l_obj_version cs_incidents_all_b.object_version_number % type;
691: l_owner_type cs_incidents_all_b.resource_type % type;
692: l_owner_id cs_incidents_all_b.incident_owner_id % type;
693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;

Line 691: l_owner_type cs_incidents_all_b.resource_type % type;

687: l_task_id jtf_tasks_b.task_id % type;
688: l_login_id jtf_notes_b.last_update_login % type;
689: l_user_id jtf_notes_b.last_updated_by % type;
690: l_obj_version cs_incidents_all_b.object_version_number % type;
691: l_owner_type cs_incidents_all_b.resource_type % type;
692: l_owner_id cs_incidents_all_b.incident_owner_id % type;
693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
695: l_group_type varchar2(50);

Line 692: l_owner_id cs_incidents_all_b.incident_owner_id % type;

688: l_login_id jtf_notes_b.last_update_login % type;
689: l_user_id jtf_notes_b.last_updated_by % type;
690: l_obj_version cs_incidents_all_b.object_version_number % type;
691: l_owner_type cs_incidents_all_b.resource_type % type;
692: l_owner_id cs_incidents_all_b.incident_owner_id % type;
693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
695: l_group_type varchar2(50);
696: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;

Line 693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;

689: l_user_id jtf_notes_b.last_updated_by % type;
690: l_obj_version cs_incidents_all_b.object_version_number % type;
691: l_owner_type cs_incidents_all_b.resource_type % type;
692: l_owner_id cs_incidents_all_b.incident_owner_id % type;
693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
695: l_group_type varchar2(50);
696: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;
697: l_task_owner_type jtf_tasks_b.owner_type_code % type;

Line 694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;

690: l_obj_version cs_incidents_all_b.object_version_number % type;
691: l_owner_type cs_incidents_all_b.resource_type % type;
692: l_owner_id cs_incidents_all_b.incident_owner_id % type;
693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
695: l_group_type varchar2(50);
696: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;
697: l_task_owner_type jtf_tasks_b.owner_type_code % type;
698: l_task_owner_id jtf_tasks_b.owner_id%type;

Line 699: l_location_id cs_incidents_all_b.incident_location_id % type;

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

Line 1140: l_incident_number cs_incidents_all_b.incident_number % type;

1136: l_note_type jtf_notes_b.note_type % type;
1137: l_login_id jtf_notes_b.last_update_login % type;
1138: l_user_id jtf_notes_b.last_updated_by % type;
1139: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1140: l_incident_number cs_incidents_all_b.incident_number % type;
1141: cursor c_sr is
1142: select * from cs_incidents_all_b
1143: where incident_id = p_request_id;
1144: begin

Line 1142: select * from cs_incidents_all_b

1138: l_user_id jtf_notes_b.last_updated_by % type;
1139: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1140: l_incident_number cs_incidents_all_b.incident_number % type;
1141: cursor c_sr is
1142: select * from cs_incidents_all_b
1143: where incident_id = p_request_id;
1144: begin
1145: l_prof_value := fnd_profile.value('AUTO GENERATE TASKS ON SR CREATE');
1146: if (l_prof_value = 'Task type Attribute configuration' or 1 =1) then