[Home] [Help]
PACKAGE: APPS.OKC_PROCESS_PUB
Source
1 package okc_process_pub as
2 /* $Header: OKCPPDFS.pls 120.0 2005/05/26 09:28:34 appldev noship $ */
3
4 -- complex entity object subtype definitions
5 subtype pdfv_rec_type is okc_process_pvt.pdfv_rec_type;
6 subtype pdfv_tbl_type is okc_process_pvt.pdfv_tbl_type;
7 subtype pdpv_rec_type is okc_process_pvt.pdpv_rec_type;
8 subtype pdpv_tbl_type is okc_process_pvt.pdpv_tbl_type;
9
10 ---------------------------------------------------------------------------------------
11 -- GLOBAL VARIABLES
12 ---------------------------------------------------------------------------------------
13 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PROCESS_PUB';
14 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18
19 g_pdfv_rec okc_process_pvt.pdfv_rec_type;
20 g_pdfv_tbl okc_process_pvt.pdfv_tbl_type;
21 g_pdpv_rec okc_process_pvt.pdpv_rec_type;
22 g_pdpv_tbl okc_process_pvt.pdpv_tbl_type;
23 ---------------------------------------------------------------------------------------
24 --Global Exception
25 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
26
27 --Public procedure declarations
28
29 PROCEDURE add_language;
30
31 --Object type procedure for insert
32 PROCEDURE create_process_def(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_pdfv_rec IN pdfv_rec_type,
39 p_pdpv_tbl IN pdpv_tbl_type,
40 x_pdfv_rec OUT NOCOPY pdfv_rec_type,
41 x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
42
43 --Object type procedure for update
44 PROCEDURE update_process_def(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_pdfv_rec IN pdfv_rec_type,
51 p_pdpv_tbl IN pdpv_tbl_type,
52 x_pdfv_rec OUT NOCOPY pdfv_rec_type,
53 x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
54
55 --Object type procedure for validate
56 PROCEDURE validate_process_def(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_pdfv_rec IN pdfv_rec_type,
63 p_pdpv_tbl IN pdpv_tbl_type);
64
65 --Procedures for Process Definitions
66
67 PROCEDURE create_proc_def(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_pdfv_tbl IN pdfv_tbl_type,
74 x_pdfv_tbl OUT NOCOPY pdfv_tbl_type);
75
76 PROCEDURE create_proc_def(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_pdfv_rec IN pdfv_rec_type,
83 x_pdfv_rec OUT NOCOPY pdfv_rec_type);
84
85 PROCEDURE lock_proc_def(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_pdfv_tbl IN pdfv_tbl_type);
92
93 PROCEDURE lock_proc_def(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_pdfv_rec IN pdfv_rec_type);
100
101 PROCEDURE update_proc_def(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_pdfv_tbl IN pdfv_tbl_type,
108 x_pdfv_tbl OUT NOCOPY pdfv_tbl_type);
109
110 PROCEDURE update_proc_def(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_pdfv_rec IN pdfv_rec_type,
117 x_pdfv_rec OUT NOCOPY pdfv_rec_type);
118
119 PROCEDURE delete_proc_def(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_pdfv_tbl IN pdfv_tbl_type);
126
127 PROCEDURE delete_proc_def(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_pdfv_rec IN pdfv_rec_type);
134
135 PROCEDURE validate_proc_def(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_pdfv_tbl IN pdfv_tbl_type);
142
143 PROCEDURE validate_proc_def(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_pdfv_rec IN pdfv_rec_type);
150
151 --Procedures for Process Definition Parameters
152
153 PROCEDURE create_proc_def_parms(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_pdpv_tbl IN pdpv_tbl_type,
160 x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
161
162 PROCEDURE create_proc_def_parms(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_pdpv_rec IN pdpv_rec_type,
169 x_pdpv_rec OUT NOCOPY pdpv_rec_type);
170
171 PROCEDURE lock_proc_def_parms(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_pdpv_tbl IN pdpv_tbl_type);
178
179 PROCEDURE lock_proc_def_parms(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_pdpv_rec IN pdpv_rec_type);
186
187 PROCEDURE update_proc_def_parms(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_pdpv_tbl IN pdpv_tbl_type,
194 x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
195
196 PROCEDURE update_proc_def_parms(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_pdpv_rec IN pdpv_rec_type,
203 x_pdpv_rec OUT NOCOPY pdpv_rec_type);
204
205 PROCEDURE delete_proc_def_parms(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_pdpv_rec IN pdpv_rec_type);
212
213 PROCEDURE delete_proc_def_parms(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_pdpv_tbl IN pdpv_tbl_type);
220
221 PROCEDURE validate_proc_def_parms(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_pdpv_tbl IN pdpv_tbl_type);
228
229 PROCEDURE validate_proc_def_parms(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_pdpv_rec IN pdpv_rec_type);
236
237 PROCEDURE validate_dbnames(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_wf_proc IN VARCHAR2,
244 p_wf_name IN VARCHAR2,
245 p_package IN VARCHAR2,
246 p_procedure IN VARCHAR2);
247
248 END okc_process_pub;