APPS.CS_INCIDENT_ACTIONS_PKG dependencies on CS_INCIDENT_ACTIONS

Line 1: PACKAGE BODY CS_INCIDENT_ACTIONS_PKG as

1: PACKAGE BODY CS_INCIDENT_ACTIONS_PKG as
2: /* $Header: csincab.pls 115.1 99/07/16 08:57:52 porting ship $ */
3:
4: /* ******* LOCAL PROCEDURES ******* */
5:

Line 71: CURSOR C IS SELECT rowid FROM cs_incident_actions

67: X_Attribute15 VARCHAR2 DEFAULT NULL,
68: X_Context VARCHAR2 DEFAULT NULL,
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

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 82: INSERT INTO cs_incident_actions(

78: FETCH C2 INTO X_Incident_Action_Id;
79: CLOSE C2;
80: END IF;
81:
82: INSERT INTO cs_incident_actions(
83: incident_action_id,
84: last_update_date,
85: last_updated_by,
86: creation_date,

Line 316: FROM cs_incident_actions

312: X_dispatcher_orig_syst_id NUMBER DEFAULT NULL,
313: X_dispatch_role_name VARCHAR2 DEFAULT NULL ) IS
314: CURSOR C IS
315: SELECT *
316: FROM cs_incident_actions
317: WHERE rowid = X_Rowid
318: FOR UPDATE of Incident_Action_Id NOWAIT;
319: Recinfo C%ROWTYPE;
320:

Line 487: UPDATE cs_incident_actions

483: ) IS
484:
485: BEGIN
486:
487: UPDATE cs_incident_actions
488: SET
489: incident_action_id = X_Incident_Action_Id,
490: last_update_date = trunc(sysdate),
491: last_updated_by = X_Last_Updated_By,

Line 717: FROM CS_INCIDENT_ACTIONS

713: BEGIN
714:
715: SELECT NVL(SUM(ACTUAL_TIME), 0)
716: INTO X_TOTAL
717: FROM CS_INCIDENT_ACTIONS
718: WHERE INCIDENT_ID = X_INCIDENT_ID;
719:
720: X_TOTAL_RTOT_DB := X_TOTAL;
721:

Line 724: END CS_INCIDENT_ACTIONS_PKG ;

720: X_TOTAL_RTOT_DB := X_TOTAL;
721:
722: END Select_Summary;
723:
724: END CS_INCIDENT_ACTIONS_PKG ;