DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_S

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

14900: *******/
14901:
14902: IF l_request_id IS NULL THEN
14903: LOOP
14904: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;
14905: BEGIN
14906: SELECT incident_id INTO l_temp_id FROM cs_incidents_all_b
14907: WHERE incident_id = x_req_id;
14908: EXCEPTION

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

16091: END IF;
16092:
16093: --This part of the code should just check whether the status can be
16094: --updated.Also Aborting the workflow code is based on close flag from
16095: --CS_INCIDENTS_STATUSES and abort_workflow on close flag from
16096: --CS_INCIDENT_TYPES.
16097:
16098: -- This functionality is based on the change in the SR status
16099: -- Check if we need to abort the workflow process if the service