APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENT_STATUSES

Line 824: FROM CS_INCIDENT_STATUSES_VL

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

Line 1502: cs_incident_statuses_vl b

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

Line 5119: FROM CS_INCIDENT_STATUSES_VL

5115: END IF;
5116:
5117: SELECT name
5118: INTO l_request_status_temp
5119: FROM CS_INCIDENT_STATUSES_VL
5120: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
5121:
5122: IF (l_request_status = l_request_status_temp) THEN
5123: WF_ENGINE.SetItemAttrNumber(

Line 5346: FROM cs_incident_statuses status, cs_incidents_all_b inc

5342:
5343: CURSOR sel_close_flag_csr(lv_incident_id IN NUMBER) IS
5344: SELECT nvl(status.close_flag,'N'),
5345: inc.incident_status_id
5346: FROM cs_incident_statuses status, cs_incidents_all_b inc
5347: WHERE inc.incident_id = lv_incident_id
5348: AND inc.incident_status_id = status.incident_status_id;
5349:
5350: BEGIN

Line 5428: FROM cs_incident_statuses status

5424: l_close_flag := 'Y';
5425: ELSE
5426: SELECT nvl(status.close_flag,'N')
5427: INTO l_close_flag
5428: FROM cs_incident_statuses status
5429: WHERE status.incident_status_id = l_subject_status_id;
5430: END IF;
5431:
5432: IF (l_close_flag = 'Y') THEN

Line 5611: FROM cs_incident_statuses status

5607: l_service_request_rec.status_id := l_subject_status_id;
5608:
5609: SELECT nvl(status.close_flag,'N')
5610: INTO l_close_flag
5611: FROM cs_incident_statuses status
5612: WHERE status.incident_status_id = l_subject_status_id;
5613:
5614: IF (l_close_flag = 'Y') THEN
5615: l_service_request_rec.closed_date := sysdate;

Line 6312: CS_INCIDENT_STATUSES_VL STATUS,

6308: --CS_INCIDENT_TYPES_VL TYPE,
6309: CS_INCIDENT_TYPES_TL TYPE,
6310: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
6311: CS_INCIDENT_SEVERITIES_TL SEVERITY,
6312: CS_INCIDENT_STATUSES_VL STATUS,
6313: --CS_INCIDENT_URGENCIES_VL URGENCY,
6314: CS_INCIDENT_URGENCIES_TL URGENCY,
6315: HZ_PARTIES RA2,
6316: CS_LOOKUPS CSLKUP,