APPS.CS_SR_WF_DUP_CHK_PVT dependencies on CS_INCIDENTS_ALL_B

Line 18: FROM cs_incidents_all_b

14: l_incident_id NUMBER;
15:
16: CURSOR l_ServiceRequest_csr IS
17: SELECT sr_creation_channel
18: FROM cs_incidents_all_b
19: WHERE incident_id = l_incident_id;
20:
21: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
22:

Line 70: FROM cs_incidents_all_b

66: l_task_error_note varchar2(80);
67:
68: CURSOR l_ServiceRequest_csr IS
69: SELECT creation_date, last_update_date, object_version_number
70: FROM cs_incidents_all_b
71: WHERE incident_id = l_incident_id;
72:
73: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
74:

Line 149: FROM cs_incidents_all_b

145: l_duplicate_check_profile varchar2(80);
146:
147: CURSOR l_ServiceRequest_csr IS
148: SELECT creation_date, last_update_date
149: FROM cs_incidents_all_b
150: WHERE incident_id = l_incident_id;
151:
152: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
153:

Line 218: FROM cs_incidents_all_b

214: SELECT incident_id, incident_number, customer_id, inventory_item_id, customer_product_id,
215: current_serial_number, item_serial_number,
216: incident_type_id, incident_location_id,
217: incident_Address, incident_city, incident_state, incident_country, incident_postal_code
218: FROM cs_incidents_all_b
219: WHERE incident_id = l_incident_id;
220:
221: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
222:

Line 225: FROM cug_sr_type_dup_chk_info conf, cs_incidents_all_b inc

221: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
222:
223: CURSOR l_EA_Dup_Chk_csr IS
224: SELECT conf.sr_dup_check_flag
225: FROM cug_sr_type_dup_chk_info conf, cs_incidents_all_b inc
226: WHERE conf.incident_type_id = inc.incident_type_id
227: AND inc.incident_id = l_incident_id;
228:
229: CURSOR l_EA_Attr_csr IS

Line 425: l_incident_number CS_Incidents_All_B.incident_number%type;

421: l_counter NUMBER ;
422: l_auto_task_gen_attemped VARCHAR2(100);
423: l_note_type VARCHAR2(80);
424: l_field_service_task_created VARCHAR2(100);
425: l_incident_number CS_Incidents_All_B.incident_number%type;
426: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
427: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
428:
429: l_err VARCHAR2(4000);

Line 435: select * from cs_incidents_all_b

431: l_user_id jtf_notes_b.last_updated_by%TYPE;
432: l_note_id NUMBER;
433:
434: cursor l_incident_csr is
435: select * from cs_incidents_all_b
436: where incident_id = l_incident_id;
437: l_incident_rec l_incident_csr%ROWTYPE;
438:
439: CURSOR l_EA_Attr_csr IS

Line 998: FROM cug_sr_type_dup_chk_info maps, cs_incidents_all_b sr, jtf_rs_resource_extns emp

994: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
995:
996: CURSOR l_EA_Recipient_notify_csr IS
997: SELECT emp.source_id incident_owner_id
998: FROM cug_sr_type_dup_chk_info maps, cs_incidents_all_b sr, jtf_rs_resource_extns emp
999: WHERE maps.incident_type_id = sr.incident_type_id
1000: AND maps.resource_id = emp.resource_id
1001: AND sr.incident_id = l_incident_id;
1002:

Line 1135: FROM cs_incidents_all_b inc

1131: l_incident_id NUMBER;
1132:
1133: CURSOR l_ServiceRequest_csr IS
1134: SELECT incident_owner_id
1135: FROM cs_incidents_all_b inc
1136: WHERE incident_id = l_incident_id;
1137:
1138: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
1139: