DBA Data[Home] [Help]

APPS.CS_SR_WORKITEM_PVT dependencies on CS_INCIDENT_SEVERITIES_B

Line 294: l_old_priority cs_incident_severities_b.priority_code%TYPE;

290:
291: l_return_status VARCHAR2(1);
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;

Line 295: l_new_priority cs_incident_severities_b.priority_code%TYPE;

291: l_return_status VARCHAR2(1);
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;

Line 311: l_priority cs_incident_severities_b.priority_code%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;
313: l_new_severity_id NUMBER;
314: l_inc_responded_by_date DATE;
315: l_obligation_date DATE;

Line 806: l_new_priority_code cs_incident_severities_b.priority_code%TYPE;

802: X_Msg_Count OUT NOCOPY NUMBER,
803: X_Msg_Data OUT NOCOPY VARCHAR2) IS
804:
805:
806: l_new_priority_code cs_incident_severities_b.priority_code%TYPE;
807: l_old_priority_code cs_incident_severities_b.priority_code%TYPE;
808: l_inc_responded_by_date DATE;
809: l_obligation_date DATE;
810: l_exp_resolution_date DATE;

Line 807: l_old_priority_code cs_incident_severities_b.priority_code%TYPE;

803: X_Msg_Data OUT NOCOPY VARCHAR2) IS
804:
805:
806: l_new_priority_code cs_incident_severities_b.priority_code%TYPE;
807: l_old_priority_code cs_incident_severities_b.priority_code%TYPE;
808: l_inc_responded_by_date DATE;
809: l_obligation_date DATE;
810: l_exp_resolution_date DATE;
811:

Line 814: FROM cs_incident_severities_b

810: l_exp_resolution_date DATE;
811:
812: CURSOR c_get_priority_code (l_severity_id IN NUMBER) IS
813: SELECT priority_code
814: FROM cs_incident_severities_b
815: WHERE incident_severity_id = l_severity_id;
816:
817: BEGIN
818: