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