APPS.CS_SR_WORKITEM_PVT dependencies on CS_INCIDENTS_ALL_B

Line 40: l_owner_group_type cs_incidents_all_b.GROUP_TYPE%TYPE;

36: l_close_flag VARCHAR2(1);
37: l_API_ERROR EXCEPTION;
38:
39: l_owner_group_id NUMBER;
40: l_owner_group_type cs_incidents_all_b.GROUP_TYPE%TYPE;
41: l_individual_owner_id NUMBER;
42: l_individual_owner_type cs_incidents_all_b.RESOURCE_TYPE%TYPE;
43: l_responded_by_date DATE;
44: l_obligation_date DATE;

Line 42: l_individual_owner_type cs_incidents_all_b.RESOURCE_TYPE%TYPE;

38:
39: l_owner_group_id NUMBER;
40: l_owner_group_type cs_incidents_all_b.GROUP_TYPE%TYPE;
41: l_individual_owner_id NUMBER;
42: l_individual_owner_type cs_incidents_all_b.RESOURCE_TYPE%TYPE;
43: l_responded_by_date DATE;
44: l_obligation_date DATE;
45: l_expected_resolution_date DATE;
46: l_login_id NUMBER;

Line 306: l_resource_type cs_incidents_all_b.RESOURCE_TYPE%TYPE;

302: l_due_date DATE;
303: l_work_item_id NUMBER;
304:
305: l_owner_id NUMBER;
306: l_resource_type cs_incidents_all_b.RESOURCE_TYPE%TYPE;
307: l_owner_group_id NUMBER;
308: l_group_type cs_incidents_all_b.GROUP_TYPE%TYPE;
309: l_summary cs_incidents_all_tl.SUMMARY%TYPE;
310: l_customer_id NUMBER;

Line 308: l_group_type cs_incidents_all_b.GROUP_TYPE%TYPE;

304:
305: l_owner_id NUMBER;
306: l_resource_type cs_incidents_all_b.RESOURCE_TYPE%TYPE;
307: l_owner_group_id NUMBER;
308: l_group_type cs_incidents_all_b.GROUP_TYPE%TYPE;
309: l_summary cs_incidents_all_tl.SUMMARY%TYPE;
310: l_customer_id NUMBER;
311: l_priority cs_incident_severities_b.priority_code%TYPE;
312: l_new_status_id NUMBER;

Line 337: FROM cs_incidents_all_b

333: WHERE incident_status_id = l_status_id;
334:
335: CURSOR sel_incident_number_csr IS
336: SELECT incident_number
337: FROM cs_incidents_all_b
338: WHERE incident_id = p_incident_id;
339:
340:
341: BEGIN