DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_S

Line 13768: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;

13764: *******/
13765:
13766: IF l_request_id IS NULL THEN
13767: LOOP
13768: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;
13769: BEGIN
13770: SELECT incident_id INTO l_temp_id FROM cs_incidents_all_b
13771: WHERE incident_id = x_req_id;
13772: EXCEPTION

Line 14885: --CS_INCIDENTS_STATUSES and abort_workflow on close flag from

14881: END IF;
14882:
14883: --This part of the code should just check whether the status can be
14884: --updated.Also Aborting the workflow code is based on close flag from
14885: --CS_INCIDENTS_STATUSES and abort_workflow on close flag from
14886: --CS_INCIDENT_TYPES.
14887:
14888: -- This functionality is based on the change in the SR status
14889: -- Check if we need to abort the workflow process if the service