1 PACKAGE CSL_CS_INCIDENTS_ALL_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: cslinacs.pls 115.5 2002/11/08 14:02:35 asiegers ship $ */
3
4 /*Normal create sr flow*/
5 G_FLOW_NORMAL CONSTANT NUMBER := 0;
6 /*Flow to create history service request*/
7 G_FLOW_HISTORY CONSTANT NUMBER := 1;
8 /*Flow to create sr created on mobile appl*/
9 G_FLOW_MOBILE_SR CONSTANT NUMBER := 2;
10
11
12 FUNCTION Replicate_Record
13 ( p_incident_id NUMBER
14 )
15 RETURN BOOLEAN;
16 /*** Function that checks if incident record should be replicated. Returns TRUE if it should ***/
17
18 FUNCTION Pre_Insert_Child
19 ( p_incident_id IN NUMBER
20 ,p_resource_id IN NUMBER
21 ,p_flow_type IN NUMBER DEFAULT G_FLOW_NORMAL
22 )
23 RETURN BOOLEAN;
24 /***
25 Public function that gets called when an incident needs to be inserted into ACC table.
26 Returns TRUE when record already was or has been inserted into ACC table.
27 ***/
28
29 PROCEDURE Post_Delete_Child
30 ( p_incident_id IN NUMBER
31 ,p_resource_id IN NUMBER
32 ,p_flow_type IN NUMBER DEFAULT G_FLOW_NORMAL
33 );
34 /***
35 Public procedure that gets called when an incident needs to be deleted from ACC table.
36 ***/
37
38 PROCEDURE PRE_INSERT_INCIDENT ( x_return_status OUT NOCOPY varchar2);
39 /* Called before incident Insert */
40
41 PROCEDURE POST_INSERT_INCIDENT ( x_return_status OUT NOCOPY varchar2);
42 /* Called after incident Insert */
43
44 PROCEDURE PRE_UPDATE_INCIDENT ( x_return_status OUT NOCOPY varchar2);
45 /* Called before incident Update */
46
47 PROCEDURE POST_UPDATE_INCIDENT ( x_return_status OUT NOCOPY varchar2);
48 /* Called after incident Update */
49
50 PROCEDURE PRE_DELETE_INCIDENT ( x_return_status OUT NOCOPY varchar2);
51 /* Called before incident Delete */
52
53 PROCEDURE POST_DELETE_INCIDENT ( x_return_status OUT NOCOPY varchar2);
54 /* Called after incident Delete */
55
56 PROCEDURE INSERT_ALL_ACC_RECORDS
57 ( p_resource_id IN NUMBER
58 , x_return_status OUT NOCOPY VARCHAR2 );
59 /* Called during user creation */
60
61 END CSL_CS_INCIDENTS_ALL_ACC_PKG;