DBA Data[Home] [Help]

APPS.CS_INCIDENT_ACTIONS_PKG dependencies on CS_INCIDENTS_AUDIT

Line 168: /* Insert into cs_incidents_audit table that an action has been created */

164: Raise NO_DATA_FOUND;
165: end if;
166: CLOSE C;
167:
168: /* Insert into cs_incidents_audit table that an action has been created */
169: Register_New_Action_Inc_Audit (x_incident_action_id,
170: x_incident_id,
171: x_text,
172: x_created_by,

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 216: INSERT INTO CS_Incidents_Audit(

212: CLOSE C2;
213:
214: X_create_manual_Action := 'Y';
215:
216: INSERT INTO CS_Incidents_Audit(
217: incident_audit_id ,
218: incident_id ,
219: last_update_date ,
220: last_updated_by ,