APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENT_STATUSES

Line 823: FROM CS_INCIDENT_STATUSES_VL

819: END IF;
820:
821: SELECT name
822: INTO l_request_status_temp
823: FROM CS_INCIDENT_STATUSES_VL
824: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
825:
826: IF (l_request_status_temp = l_request_status) THEN
827:

Line 1498: cs_incident_statuses_vl b

1494: -- 3. NTFY_LINK_TYPE
1495: CURSOR sel_linked_sr_details_csr IS
1496: SELECT a.summary, b.name
1497: FROM cs_incidents_all_vl a,
1498: cs_incident_statuses_vl b
1499: WHERE a.incident_status_id = b.incident_status_id AND
1500: a.incident_id = l_request_id;
1501:
1502: sel_linked_sr_details_rec sel_linked_sr_details_csr%ROWTYPE;

Line 5055: FROM CS_INCIDENT_STATUSES_VL

5051: END IF;
5052:
5053: SELECT name
5054: INTO l_request_status_temp
5055: FROM CS_INCIDENT_STATUSES_VL
5056: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
5057:
5058: IF (l_request_status = l_request_status_temp) THEN
5059: WF_ENGINE.SetItemAttrNumber(

Line 5282: FROM cs_incident_statuses status, cs_incidents_all_b inc

5278:
5279: CURSOR sel_close_flag_csr(lv_incident_id IN NUMBER) IS
5280: SELECT nvl(status.close_flag,'N'),
5281: inc.incident_status_id
5282: FROM cs_incident_statuses status, cs_incidents_all_b inc
5283: WHERE inc.incident_id = lv_incident_id
5284: AND inc.incident_status_id = status.incident_status_id;
5285:
5286: BEGIN

Line 5364: FROM cs_incident_statuses status

5360: l_close_flag := 'Y';
5361: ELSE
5362: SELECT nvl(status.close_flag,'N')
5363: INTO l_close_flag
5364: FROM cs_incident_statuses status
5365: WHERE status.incident_status_id = l_subject_status_id;
5366: END IF;
5367:
5368: IF (l_close_flag = 'Y') THEN

Line 5547: FROM cs_incident_statuses status

5543: l_service_request_rec.status_id := l_subject_status_id;
5544:
5545: SELECT nvl(status.close_flag,'N')
5546: INTO l_close_flag
5547: FROM cs_incident_statuses status
5548: WHERE status.incident_status_id = l_subject_status_id;
5549:
5550: IF (l_close_flag = 'Y') THEN
5551: l_service_request_rec.closed_date := sysdate;

Line 6248: CS_INCIDENT_STATUSES_VL STATUS,

6244: --CS_INCIDENT_TYPES_VL TYPE,
6245: CS_INCIDENT_TYPES_TL TYPE,
6246: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
6247: CS_INCIDENT_SEVERITIES_TL SEVERITY,
6248: CS_INCIDENT_STATUSES_VL STATUS,
6249: --CS_INCIDENT_URGENCIES_VL URGENCY,
6250: CS_INCIDENT_URGENCIES_TL URGENCY,
6251: HZ_PARTIES RA2,
6252: CS_LOOKUPS CSLKUP,