1 PACKAGE cs_servicerequest_cuhk AS
2 /* $Header: cscsrs.pls 120.0 2006/02/09 17:06:02 spusegao noship $ */
3
4 /*****************************************************************************************
5 This is the Customer User Hook API.
6 The Customers can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9
10
11
12 /* Customer Procedure for pre processing in case of
13 create service request */
14
15 /*
16 PROCEDURE Create_ServiceRequest_Pre
17 (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
18 x_return_status OUT NOCOPY VARCHAR2
19 ); */
20
21 PROCEDURE Create_ServiceRequest_Pre
22 ( p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
24 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
25 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_resp_appl_id IN NUMBER DEFAULT NULL,
30 p_resp_id IN NUMBER DEFAULT NULL,
31 p_user_id IN NUMBER,
32 p_login_id IN NUMBER DEFAULT NULL,
33 p_org_id IN NUMBER DEFAULT NULL,
34 p_request_id IN NUMBER DEFAULT NULL,
35 p_request_number IN VARCHAR2 DEFAULT NULL,
36 p_invocation_mode IN VARCHAR2 := 'NORMAL',
37 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
38 p_notes IN CS_ServiceRequest_PVT.notes_table,
39 p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
40 x_request_id OUT NOCOPY NUMBER,
41 x_request_number OUT NOCOPY VARCHAR2,
42 x_interaction_id OUT NOCOPY NUMBER,
43 x_workflow_process_id OUT NOCOPY NUMBER
44 ) ;
45
46
47 /* Customer Procedure for post processing in case of
48 create service request */
49
50 /*
51 PROCEDURE Create_ServiceRequest_Post
52 (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
53 x_return_status OUT NOCOPY VARCHAR2
54 ); */
55
56
57 PROCEDURE Create_ServiceRequest_Post
58 ( p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
60 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
61 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_resp_appl_id IN NUMBER DEFAULT NULL,
66 p_resp_id IN NUMBER DEFAULT NULL,
67 p_user_id IN NUMBER,
68 p_login_id IN NUMBER DEFAULT NULL,
69 p_org_id IN NUMBER DEFAULT NULL,
70 p_request_id IN NUMBER DEFAULT NULL,
71 p_request_number IN VARCHAR2 DEFAULT NULL,
72 p_invocation_mode IN VARCHAR2 := 'NORMAL',
73 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
74 p_notes IN CS_ServiceRequest_PVT.notes_table,
75 p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
76 x_request_id OUT NOCOPY NUMBER,
77 x_request_number OUT NOCOPY VARCHAR2,
78 x_interaction_id OUT NOCOPY NUMBER,
79 x_workflow_process_id OUT NOCOPY NUMBER
80 );
81
82
83
84
85 /* Customer Procedure for pre processing in case of
86 update service request */
87
88 /*
89 PROCEDURE Update_ServiceRequest_Pre
90 ( p_request_id IN NUMBER,
91 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
92 x_return_status OUT NOCOPY VARCHAR2
93 ); */
94
95
96 PROCEDURE Update_ServiceRequest_Pre
97 ( p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
99 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
100 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_request_id IN NUMBER,
105 p_object_version_number IN NUMBER,
106 p_resp_appl_id IN NUMBER DEFAULT NULL,
107 p_resp_id IN NUMBER DEFAULT NULL,
108 p_last_updated_by IN NUMBER,
109 p_last_update_login IN NUMBER DEFAULT NULL,
110 p_last_update_date IN DATE,
111 p_invocation_mode IN VARCHAR2 := 'NORMAL',
112 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114 p_notes IN CS_ServiceRequest_PVT.notes_table,
115 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116 p_audit_comments IN VARCHAR2 DEFAULT NULL,
117 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
118 p_workflow_process_id IN NUMBER DEFAULT NULL,
119 x_workflow_process_id OUT NOCOPY NUMBER,
120 x_interaction_id OUT NOCOPY NUMBER
121 ) ;
122
123
124 /* Customer Procedure for post processing in case of
125 update service request */
126
127
128 /*
129 PROCEDURE Update_ServiceRequest_Post
130 ( p_request_id IN NUMBER,
131 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
132 x_return_status OUT NOCOPY VARCHAR2); */
133
134
135
136 PROCEDURE Update_ServiceRequest_Post
137 ( p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
139 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
140 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_request_id IN NUMBER,
145 p_object_version_number IN NUMBER,
146 p_resp_appl_id IN NUMBER DEFAULT NULL,
147 p_resp_id IN NUMBER DEFAULT NULL,
148 p_last_updated_by IN NUMBER,
149 p_last_update_login IN NUMBER DEFAULT NULL,
150 p_last_update_date IN DATE,
151 p_invocation_mode IN VARCHAR2 := 'NORMAL',
152 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154 p_notes IN CS_ServiceRequest_PVT.notes_table,
155 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156 p_audit_comments IN VARCHAR2 DEFAULT NULL,
157 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
158 p_workflow_process_id IN NUMBER DEFAULT NULL,
159 x_workflow_process_id OUT NOCOPY NUMBER,
160 x_interaction_id OUT NOCOPY NUMBER
161 ) ;
162
163
164
165
166 FUNCTION Ok_To_Generate_Msg
167 (p_request_id IN NUMBER,
168 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
169 RETURN BOOLEAN ;
170
171
172 FUNCTION Ok_To_Launch_Workflow
173 ( p_request_id IN NUMBER,
174 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
175 RETURN BOOLEAN ;
176
177 END cs_servicerequest_cuhk;