[Home] [Help]
PACKAGE: APPS.OKC_AQERRMSG_PUB
Source
1 package okc_aqerrmsg_pub AUTHID CURRENT_USER as
2 /* $Header: OKCPAQES.pls 120.0 2005/05/30 04:13:38 appldev noship $ */
3
4 subtype aqev_rec_type is okc_aqe_pvt.aqev_rec_type;
5 subtype aqev_tbl_type is okc_aqe_pvt.aqev_tbl_type;
6 subtype aqmv_rec_type is okc_aqm_pvt.aqmv_rec_type;
7 subtype aqmv_tbl_type is okc_aqm_pvt.aqmv_tbl_type;
8
9 ----------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AQERRMSG_PUB';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16
17 g_aqev_rec okc_aqe_pvt.aqev_rec_type;
18 g_aqev_tbl okc_aqe_pvt.aqev_tbl_type;
19 g_aqmv_rec okc_aqm_pvt.aqmv_rec_type;
20 g_aqmv_tbl okc_aqm_pvt.aqmv_tbl_type;
21 ----------------------------------------------------------------------------------
22 --Global Exception
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 ----------------------------------------------------------------------------------
25
26 --Object type procedure for insert
27 PROCEDURE create_err_msg(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_aqev_rec IN aqev_rec_type,
34 p_aqmv_tbl IN aqmv_tbl_type,
35 x_aqev_rec OUT NOCOPY aqev_rec_type,
36 x_aqmv_tbl OUT NOCOPY aqmv_tbl_type);
37
38 --Object type procedure for update
39 PROCEDURE update_err_msg(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_aqev_rec IN aqev_rec_type,
46 p_aqmv_tbl IN aqmv_tbl_type,
47 x_aqev_rec OUT NOCOPY aqev_rec_type,
48 x_aqmv_tbl OUT NOCOPY aqmv_tbl_type);
49
50 --Object type procedure for validate
51 PROCEDURE validate_err_msg(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_aqev_rec IN aqev_rec_type,
58 p_aqmv_tbl IN aqmv_tbl_type);
59
60 --Procedures for Errors
61 PROCEDURE create_err(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_aqev_tbl IN aqev_tbl_type,
68 x_aqev_tbl OUT NOCOPY aqev_tbl_type);
69
70 PROCEDURE create_err(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_aqev_rec IN aqev_rec_type,
77 x_aqev_rec OUT NOCOPY aqev_rec_type);
78
79 PROCEDURE lock_err(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_aqev_tbl IN aqev_tbl_type);
86
87 PROCEDURE lock_err(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_aqev_rec IN aqev_rec_type);
94
95 PROCEDURE update_err(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_aqev_tbl IN aqev_tbl_type,
102 x_aqev_tbl OUT NOCOPY aqev_tbl_type);
103
104 PROCEDURE update_err(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_aqev_rec IN aqev_rec_type,
111 x_aqev_rec OUT NOCOPY aqev_rec_type);
112
113 PROCEDURE delete_err(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_aqev_tbl IN aqev_tbl_type);
120
121 PROCEDURE delete_err(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_aqev_rec IN aqev_rec_type);
128
129 PROCEDURE validate_err(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_aqev_tbl IN aqev_tbl_type);
136
137 PROCEDURE validate_err(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_aqev_rec IN aqev_rec_type);
144
145 --Procedures for Messages
146 PROCEDURE create_msg(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_aqmv_tbl IN aqmv_tbl_type,
153 x_aqmv_tbl OUT NOCOPY aqmv_tbl_type);
154
155 PROCEDURE create_msg(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_aqmv_rec IN aqmv_rec_type,
162 x_aqmv_rec OUT NOCOPY aqmv_rec_type);
163
164 PROCEDURE lock_msg(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_aqmv_tbl IN aqmv_tbl_type);
171
172 PROCEDURE lock_msg(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_aqmv_rec IN aqmv_rec_type);
179
180 PROCEDURE update_msg(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_aqmv_tbl IN aqmv_tbl_type,
187 x_aqmv_tbl OUT NOCOPY aqmv_tbl_type);
188
189 PROCEDURE update_msg(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_aqmv_rec IN aqmv_rec_type,
196 x_aqmv_rec OUT NOCOPY aqmv_rec_type);
197
198 PROCEDURE delete_msg(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_aqmv_rec IN aqmv_rec_type);
205
206 PROCEDURE delete_msg(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_aqmv_tbl IN aqmv_tbl_type);
213
214 PROCEDURE validate_msg(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_aqmv_tbl IN aqmv_tbl_type);
221
222 PROCEDURE validate_msg(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_aqmv_rec IN aqmv_rec_type);
229
230 END okc_aqerrmsg_pub;