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