1 PACKAGE cs_servicerequest_vert_hooks AUTHID CURRENT_USER AS
2 /* $Header: csvtsrs.pls 115.3 2000/05/19 16:22:18 pkm ship $ */
3 PROCEDURE create_servicerequest_post (
4 p_service_request_rec IN CS_SERVICEREQUEST_PVT.service_request_rec_type
5 );
6
7 PROCEDURE create_servicerequest_pre (
8 p_service_request_rec IN OUT CS_SERVICEREQUEST_PVT.service_request_rec_type
9 );
10
11 --
12 -- The request_date field in the service_request_rec_type will be ignored for update.
13 --
14 PROCEDURE update_servicerequest_post (
15 p_service_request_rec IN CS_SERVICEREQUEST_PVT.service_request_rec_type,
16 p_update_desc_flex IN VARCHAR2
17 );
18
19 PROCEDURE UPDATE_SERVICEREQUEST_PRE (
20 p_service_request_rec IN OUT CS_SERVICEREQUEST_PVT.service_request_rec_type,
21 p_update_desc_flex IN OUT VARCHAR2
22 );
23
24 PROCEDURE UPDATE_OWNER_POST (
25 P_OWNER_ID IN NUMBER,
26 P_RESOURCE_TYPE IN VARCHAR2,
27 P_AUDIT_COMMENTS IN VARCHAR2,
28 P_CALLED_BY_WORKFLOW IN VARCHAR2,
29 P_WORKFLOW_PROCESS_ID IN NUMBER,
30 P_COMMENTS IN VARCHAR2,
31 P_PUBLIC_COMMENT_FLAG IN VARCHAR2
32 );
33
34 PROCEDURE UPDATE_OWNER_PRE (
35 P_OWNER_ID IN OUT NUMBER,
36 P_RESOURCE_TYPE IN OUT VARCHAR2,
37 P_AUDIT_COMMENTS IN OUT VARCHAR2,
38 P_CALLED_BY_WORKFLOW IN OUT VARCHAR2,
39 P_WORKFLOW_PROCESS_ID IN OUT NUMBER,
40 P_COMMENTS IN OUT VARCHAR2,
41 P_PUBLIC_COMMENT_FLAG IN OUT VARCHAR2
42 );
43
44 PROCEDURE UPDATE_SEVERITY_POST (
45 P_SEVERITY_ID IN NUMBER,
46 P_SEVERITY IN VARCHAR2,
47 P_AUDIT_COMMENTS IN VARCHAR2,
48 P_COMMENTS IN VARCHAR2,
49 P_PUBLIC_COMMENT_FLAG IN VARCHAR2
50 );
51
52 PROCEDURE UPDATE_SEVERITY_PRE (
53 P_SEVERITY_ID IN OUT NUMBER,
54 P_SEVERITY IN OUT VARCHAR2,
55 P_AUDIT_COMMENTS IN OUT VARCHAR2,
56 P_COMMENTS IN OUT VARCHAR2,
57 P_PUBLIC_COMMENT_FLAG IN OUT VARCHAR2
58 );
59
60 PROCEDURE UPDATE_STATUS_POST (
61 P_STATUS_ID IN NUMBER,
62 P_STATUS IN VARCHAR2,
63 P_CLOSED_DATE IN DATE,
64 P_AUDIT_COMMENTS IN VARCHAR2,
65 P_CALLED_BY_WORKFLOW IN VARCHAR2,
66 P_WORKFLOW_PROCESS_ID IN NUMBER,
67 P_COMMENTS IN VARCHAR2,
68 P_PUBLIC_COMMENT_FLAG IN VARCHAR2
69 );
70
71 PROCEDURE UPDATE_STATUS_PRE (
72 P_STATUS_ID IN OUT NUMBER,
73 P_STATUS IN OUT VARCHAR2,
74 P_CLOSED_DATE IN OUT DATE,
75 P_AUDIT_COMMENTS IN OUT VARCHAR2,
76 P_CALLED_BY_WORKFLOW IN OUT VARCHAR2,
77 P_WORKFLOW_PROCESS_ID IN OUT NUMBER,
78 P_COMMENTS IN OUT VARCHAR2,
79 P_PUBLIC_COMMENT_FLAG IN OUT VARCHAR2
80 );
81
82 PROCEDURE UPDATE_URGENCY_POST (
83 P_URGENCY_ID IN NUMBER,
84 P_URGENCY IN VARCHAR2,
85 P_AUDIT_COMMENTS IN VARCHAR2,
86 P_COMMENTS IN VARCHAR2,
87 P_PUBLIC_COMMENT_FLAG IN VARCHAR2
88 );
89
90 PROCEDURE UPDATE_URGENCY_PRE (
91 P_URGENCY_ID IN OUT NUMBER,
92 P_URGENCY IN OUT VARCHAR2,
93 P_AUDIT_COMMENTS IN OUT VARCHAR2,
94 P_COMMENTS IN OUT VARCHAR2,
95 P_PUBLIC_COMMENT_FLAG IN OUT VARCHAR2
96 );
97
98 END cs_servicerequest_vert_hooks;