1 PACKAGE BODY ASG_SERVICE_ACC AS
2 /* $Header: asgacctb.pls 120.1 2005/08/12 02:41:21 saradhak noship $ */
3
4 /* MRAAP, 26-NOV-2001: this package has been replaced by CSF_ACCESS_PKG */
5 PROCEDURE run_command
6 ( p_command IN VARCHAR2
7 )
8 IS
9 BEGIN
10 NULL;
11 END run_command;
12
13 FUNCTION IsExisting
14 ( x_acc IN varchar2
15 , x_pk IN varchar2
16 , x_pk_id IN number
17 , x_server_id IN number
18 ) RETURN NUMBER
19 IS
20 BEGIN
21 NULL;
22 END IsExisting;
23
24 PROCEDURE InsertAcc
25 ( x_acc IN varchar2
26 , x_pk IN varchar2
27 , x_pk_id IN number
28 , x_server_id IN number
29 )
30 IS
31 BEGIN
32 NULL;
33 END InsertAcc;
34
35 FUNCTION UpdateAcc
36 ( x_acc IN varchar2
37 , x_pk IN varchar2
38 , x_pk_id IN number
39 , x_server_id IN number
40 , x_op IN varchar2
41 ) RETURN NUMBER
42 IS
43 BEGIN
44 NULL;
45 END UpdateAcc;
46
47 FUNCTION IsMobileUser
48 ( x_resource_id IN NUMBER
49 ) RETURN NUMBER
50 IS
51 BEGIN
52 NULL;
53 END IsMobileUser;
54
55 FUNCTION GetServerId
56 ( x_resource_id IN NUMBER
57 , x_server_id OUT NOCOPY NUMBER
58 ) RETURN NUMBER
59 IS
60 BEGIN
61 NULL;
62 END GetServerId;
63
64 PROCEDURE UpdateAccesses_Partyid
65 ( x_party_id IN number
66 , x_server_id IN number
67 , x_op IN varchar2
68 )
69 IS
70 BEGIN
71 NULL;
72 END UpdateAccesses_Partyid;
73
74 PROCEDURE UpdateAccesses_Incidentid
75 ( x_incident_id IN number
76 , x_server_id IN number
77 , x_op IN varchar2
78 )
79 IS
80 BEGIN
81 NULL;
82 END UpdateAccesses_Incidentid;
83
84 PROCEDURE UpdateAccesses_Taskid
85 ( x_task_id IN number
86 , x_server_id IN number
87 , x_op IN varchar2
88 )
89 IS
90 BEGIN
91 NULL;
92 END UpdateAccesses_Taskid;
93
94 PROCEDURE UpdateMobileUserAcc
95 ( x_resource_id in number
96 , x_server_id in number
97 , x_op in varchar2
98 )
99 IS
100 BEGIN
101 NULL;
102 END UpdateMobileUserAcc;
103
104 PROCEDURE INCIDENT_PRE_UPDATE
105 ( x_return_status OUT NOCOPY varchar2
106 )
107 IS
108 BEGIN
109 x_return_status := 'S';
110 END INCIDENT_PRE_UPDATE;
111
112 PROCEDURE INCIDENT_POST_UPDATE
113 ( x_return_status OUT NOCOPY varchar2
114 )
115 IS
116 BEGIN
117 x_return_status := 'S';
118 END INCIDENT_POST_UPDATE;
119
120 PROCEDURE TASKS_POST_INSERT
121 ( x_return_status OUT NOCOPY varchar2
122 )
123 IS
124 BEGIN
125 x_return_status := 'S';
126 END TASKS_POST_INSERT;
127
128 PROCEDURE TASKS_PRE_UPDATE
129 ( x_return_status OUT NOCOPY varchar2
130 )
131 IS
132 BEGIN
133 x_return_status := 'S';
134 END TASKS_PRE_UPDATE;
135
136 PROCEDURE TASK_ASSIGN_POST_INSERT
137 ( x_return_status OUT NOCOPY varchar2
138 )
139 IS
140 BEGIN
141 x_return_status :='S';
142 END TASK_ASSIGN_POST_INSERT;
143
144 PROCEDURE TASK_ASSIGN_PRE_UPDATE
145 ( x_return_status OUT NOCOPY varchar2
146 )
147 IS
148 BEGIN
149 x_return_status := 'S';
150 END TASK_ASSIGN_PRE_UPDATE;
151
152 PROCEDURE TASK_ASSIGN_PRE_DELETE
153 ( x_return_status OUT NOCOPY varchar2
154 )
155 IS
156 BEGIN
157 x_return_status :='S';
158 END TASK_ASSIGN_PRE_DELETE;
159
160 PROCEDURE INCIDENT_TRIGGER_HANDLER
161 ( INCIDENT_ID NUMBER
162 , o_CUSTOMER_ID NUMBER
163 , n_CUSTOMER_ID number
164 , Trigger_Mode VARCHAR2
165 )
166 IS
167 BEGIN
168 NULL;
169 END INCIDENT_TRIGGER_HANDLER;
170
171 PROCEDURE Tasks_Trigger_Handler
172 ( o_TASK_ID NUMBER
173 , o_SOURCE_OBJECT_ID NUMBER
174 , o_SOURCE_OBJECT_NAME VARCHAR2
175 , o_source_object_type_code VARCHAR2
176 , n_TASK_ID NUMBER
177 , n_SOURCE_OBJECT_ID NUMBER
178 , n_SOURCE_OBJECT_NAME VARCHAR2
179 , n_source_object_type_code VARCHAR2
180 , Trigger_Mode VARCHAR2
181 )
182 IS
183 BEGIN
184 NULL;
185 END Tasks_Trigger_Handler;
186
187 PROCEDURE Task_Assign_Trigger_Handler
188 ( o_TASK_ASSIGNMENT_ID NUMBER
189 , o_TASK_ID NUMBER
190 , o_RESOURCE_ID NUMBER
191 , n_TASK_ASSIGNMENT_ID NUMBER
192 , n_TASK_ID NUMBER
193 , n_RESOURCE_ID NUMBER
194 , Trigger_Mode VARCHAR2
195 )
196 IS
197 BEGIN
198 NULL;
199 END Task_Assign_Trigger_Handler;
200
201 PROCEDURE SR_CONTACT_TRIGGER_HANDLER
202 ( x_incident_id number
203 , x_op VARCHAR2
204 )
205 IS
206 BEGIN
207 NULL;
208 END SR_CONTACT_TRIGGER_HANDLER;
209
210 END ASG_SERVICE_ACC;