DBA Data[Home] [Help]

APPS.CS_INCIDENT_ACTIONS_PKG dependencies on DUAL

Line 73: CURSOR C2 IS SELECT cs_incident_actions_s.nextval FROM sys.dual;

69: X_OPEN_FLAG VARCHAR2 DEFAULT NULL ) IS
70:
71: CURSOR C IS SELECT rowid FROM cs_incident_actions
72: WHERE incident_action_id = X_Incident_Action_Id;
73: CURSOR C2 IS SELECT cs_incident_actions_s.nextval FROM sys.dual;
74:
75: BEGIN
76: IF (X_Incident_Action_Id IS NULL) THEN
77: OPEN C2;

Line 207: CURSOR C2 IS SELECT cs_incidents_audit_s1.nextval FROM sys.dual;

203: X1_Orig_Owner_Id NUMBER := NULL;
204: X1_Orig_resolution_date DATE := NULL;
205:
206:
207: CURSOR C2 IS SELECT cs_incidents_audit_s1.nextval FROM sys.dual;
208:
209: BEGIN
210: OPEN C2;
211: FETCH C2 INTO X_Incident_Audit_Id;

Line 591: CURSOR C2 IS SELECT cs_incident_action_audit_s.nextval FROM sys.dual;

587: l_Orig_Action_Status_ID NUMBER := NULL;
588: l_Orig_Action_Type_ID NUMBER := NULL;
589: l_Orig_Expected_Date Date := NULL;
590:
591: CURSOR C2 IS SELECT cs_incident_action_audit_s.nextval FROM sys.dual;
592:
593: BEGIN
594:
595: OPEN C2;