APPS.CS_SR_WORKITEM_PVT dependencies on CS_INCIDENT_STATUSES_B

Line 55: FROM cs_incident_statuses_b

51:
52: CURSOR sel_status_csr IS
53: SELECT decode(on_hold_flag, 'Y', 'SLEEP', 'OPEN') wi_status,
54: nvl(close_flag,'N')
55: FROM cs_incident_statuses_b
56: WHERE incident_status_id = p_sr_rec.status_id;
57:
58: cursor sel_sr_wi_csr is
59: select work_item_id

Line 296: l_old_close_flag cs_incident_statuses_b.close_flag%TYPE;

292: l_change_wi_attr VARCHAR2(1) := 'N';
293: l_change_wi_attr1 VARCHAR2(1) := 'N';
294: l_old_priority cs_incident_severities_b.priority_code%TYPE;
295: l_new_priority cs_incident_severities_b.priority_code%TYPE;
296: l_old_close_flag cs_incident_statuses_b.close_flag%TYPE;
297: l_new_close_flag cs_incident_statuses_b.close_flag%TYPE;
298: l_old_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
299: l_new_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
300: l_work_item_status VARCHAR2(25);

Line 297: l_new_close_flag cs_incident_statuses_b.close_flag%TYPE;

293: l_change_wi_attr1 VARCHAR2(1) := 'N';
294: l_old_priority cs_incident_severities_b.priority_code%TYPE;
295: l_new_priority cs_incident_severities_b.priority_code%TYPE;
296: l_old_close_flag cs_incident_statuses_b.close_flag%TYPE;
297: l_new_close_flag cs_incident_statuses_b.close_flag%TYPE;
298: l_old_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
299: l_new_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
300: l_work_item_status VARCHAR2(25);
301: l_incident_number VARCHAR2(64);

Line 298: l_old_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;

294: l_old_priority cs_incident_severities_b.priority_code%TYPE;
295: l_new_priority cs_incident_severities_b.priority_code%TYPE;
296: l_old_close_flag cs_incident_statuses_b.close_flag%TYPE;
297: l_new_close_flag cs_incident_statuses_b.close_flag%TYPE;
298: l_old_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
299: l_new_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
300: l_work_item_status VARCHAR2(25);
301: l_incident_number VARCHAR2(64);
302: l_due_date DATE;

Line 299: l_new_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;

295: l_new_priority cs_incident_severities_b.priority_code%TYPE;
296: l_old_close_flag cs_incident_statuses_b.close_flag%TYPE;
297: l_new_close_flag cs_incident_statuses_b.close_flag%TYPE;
298: l_old_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
299: l_new_on_hold_flag cs_incident_statuses_b.on_hold_flag%TYPE;
300: l_work_item_status VARCHAR2(25);
301: l_incident_number VARCHAR2(64);
302: l_due_date DATE;
303: l_work_item_id NUMBER;

Line 332: FROM cs_incident_statuses_b

328:
329: cursor sel_status_flags_csr(l_status_id IN NUMBER) IS
330: SELECT nvl(close_flag,'N'),
331: nvl(on_hold_flag,'N')
332: FROM cs_incident_statuses_b
333: WHERE incident_status_id = l_status_id;
334:
335: CURSOR sel_incident_number_csr IS
336: SELECT incident_number