DBA Data[Home] [Help]

PACKAGE: APPS.OKC_OPER_INST_PUB

Source


1 PACKAGE OKC_OPER_INST_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPCOPS.pls 120.0 2005/05/25 19:09:36 appldev noship $ */
3 
4   subtype copv_rec_type is OKC_OPER_INST_PVT.copv_rec_type;
5   subtype copv_tbl_type is OKC_OPER_INST_PVT.copv_tbl_type;
6   subtype oiev_rec_type is OKC_OPER_INST_PVT.oiev_rec_type;
7   subtype oiev_tbl_type is OKC_OPER_INST_PVT.oiev_tbl_type;
8   subtype olev_rec_type is OKC_OPER_INST_PVT.olev_rec_type;
9   subtype olev_tbl_type is OKC_OPER_INST_PVT.olev_tbl_type;
10   subtype mrdv_rec_type is OKC_OPER_INST_PVT.mrdv_rec_type;
11   subtype mrdv_tbl_type is OKC_OPER_INST_PVT.mrdv_tbl_type;
12 
13   -- Global variables for user hooks
14   g_pkg_name		CONSTANT	VARCHAR2(200)	:= 'OKC_OPER_INST_PUB';
15   g_app_name		CONSTANT	VARCHAR2(3)	:= OKC_API.G_APP_NAME;
16 
17   g_copv_rec		copv_rec_type;
18   g_copv_tbl		copv_tbl_type;
19   g_oiev_rec		oiev_rec_type;
20   g_oiev_tbl		oiev_tbl_type;
21   g_olev_rec		olev_rec_type;
22   g_olev_tbl		olev_tbl_type;
23   g_mrdv_rec            mrdv_rec_type;
24   g_mrdv_tbl            mrdv_tbl_type;
25 
26   PROCEDURE Create_Class_Operation (
27     p_api_version                  IN NUMBER,
28     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29     x_return_status                OUT NOCOPY VARCHAR2,
30     x_msg_count                    OUT NOCOPY NUMBER,
31     x_msg_data                     OUT NOCOPY VARCHAR2,
32     p_copv_rec                     IN  copv_rec_type,
33     x_copv_rec                     OUT NOCOPY  copv_rec_type);
34 
35   PROCEDURE Create_Class_Operation (
36     p_api_version                  IN NUMBER,
37     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38     x_return_status                OUT NOCOPY VARCHAR2,
39     x_msg_count                    OUT NOCOPY NUMBER,
40     x_msg_data                     OUT NOCOPY VARCHAR2,
41     p_copv_tbl                     IN copv_tbl_type,
42     x_copv_tbl                     OUT NOCOPY copv_tbl_type);
43 
44   PROCEDURE Update_Class_Operation (
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_copv_rec                     IN copv_rec_type,
51     x_copv_rec                     OUT NOCOPY copv_rec_type);
52 
53   PROCEDURE Update_Class_Operation (
54     p_api_version                  IN NUMBER,
55     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56     x_return_status                OUT NOCOPY VARCHAR2,
57     x_msg_count                    OUT NOCOPY NUMBER,
58     x_msg_data                     OUT NOCOPY VARCHAR2,
59     p_copv_tbl                     IN copv_tbl_type,
60     x_copv_tbl                     OUT NOCOPY copv_tbl_type);
61 
62   PROCEDURE Delete_Class_Operation (
63     p_api_version                  IN NUMBER,
64     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65     x_return_status                OUT NOCOPY VARCHAR2,
66     x_msg_count                    OUT NOCOPY NUMBER,
67     x_msg_data                     OUT NOCOPY VARCHAR2,
68     p_copv_rec                     IN copv_rec_type);
69 
70   PROCEDURE Delete_Class_Operation (
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_copv_tbl                     IN copv_tbl_type);
77 
78   PROCEDURE Lock_Class_Operation (
79     p_api_version                  IN NUMBER,
80     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81     x_return_status                OUT NOCOPY VARCHAR2,
82     x_msg_count                    OUT NOCOPY NUMBER,
83     x_msg_data                     OUT NOCOPY VARCHAR2,
84     p_copv_rec                     IN copv_rec_type);
85 
86   PROCEDURE Lock_Class_Operation (
87     p_api_version                  IN NUMBER,
88     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89     x_return_status                OUT NOCOPY VARCHAR2,
90     x_msg_count                    OUT NOCOPY NUMBER,
91     x_msg_data                     OUT NOCOPY VARCHAR2,
92     p_copv_tbl                     IN copv_tbl_type);
93 
94   PROCEDURE Validate_Class_Operation (
95     p_api_version                  IN NUMBER,
96     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97     x_return_status                OUT NOCOPY VARCHAR2,
98     x_msg_count                    OUT NOCOPY NUMBER,
99     x_msg_data                     OUT NOCOPY VARCHAR2,
100     p_copv_rec                     IN copv_rec_type);
101 
102   PROCEDURE Validate_Class_Operation (
103     p_api_version                  IN NUMBER,
104     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105     x_return_status                OUT NOCOPY VARCHAR2,
106     x_msg_count                    OUT NOCOPY NUMBER,
107     x_msg_data                     OUT NOCOPY VARCHAR2,
108     p_copv_tbl                     IN copv_tbl_type);
109 
110   PROCEDURE Create_Operation_Instance (
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_oiev_rec                     IN  oiev_rec_type,
117     x_oiev_rec                     OUT NOCOPY  oiev_rec_type);
118 
119   PROCEDURE Create_Operation_Instance (
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_oiev_tbl                     IN oiev_tbl_type,
126     x_oiev_tbl                     OUT NOCOPY oiev_tbl_type);
127 
128   PROCEDURE Update_Operation_Instance (
129     p_api_version                  IN NUMBER,
130     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131     x_return_status                OUT NOCOPY VARCHAR2,
132     x_msg_count                    OUT NOCOPY NUMBER,
133     x_msg_data                     OUT NOCOPY VARCHAR2,
134     p_oiev_rec                     IN oiev_rec_type,
135     x_oiev_rec                     OUT NOCOPY oiev_rec_type);
136 
137   PROCEDURE Update_Operation_Instance (
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_oiev_tbl                     IN oiev_tbl_type,
144     x_oiev_tbl                     OUT NOCOPY oiev_tbl_type);
145 
146   PROCEDURE Delete_Operation_Instance (
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_oiev_rec                     IN oiev_rec_type);
153 
154   PROCEDURE Delete_Operation_Instance (
155     p_api_version                  IN NUMBER,
156     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157     x_return_status                OUT NOCOPY VARCHAR2,
158     x_msg_count                    OUT NOCOPY NUMBER,
159     x_msg_data                     OUT NOCOPY VARCHAR2,
160     p_oiev_tbl                     IN oiev_tbl_type);
161 
162   PROCEDURE Lock_Operation_Instance (
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_oiev_rec                     IN oiev_rec_type);
169 
170   PROCEDURE Lock_Operation_Instance (
171     p_api_version                  IN NUMBER,
172     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173     x_return_status                OUT NOCOPY VARCHAR2,
174     x_msg_count                    OUT NOCOPY NUMBER,
175     x_msg_data                     OUT NOCOPY VARCHAR2,
176     p_oiev_tbl                     IN oiev_tbl_type);
177 
178   PROCEDURE Validate_Operation_Instance (
179     p_api_version                  IN NUMBER,
180     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181     x_return_status                OUT NOCOPY VARCHAR2,
182     x_msg_count                    OUT NOCOPY NUMBER,
183     x_msg_data                     OUT NOCOPY VARCHAR2,
184     p_oiev_rec                     IN oiev_rec_type);
185 
186   PROCEDURE Validate_Operation_Instance (
187     p_api_version                  IN NUMBER,
188     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189     x_return_status                OUT NOCOPY VARCHAR2,
190     x_msg_count                    OUT NOCOPY NUMBER,
191     x_msg_data                     OUT NOCOPY VARCHAR2,
192     p_oiev_tbl                     IN oiev_tbl_type);
193 
194   PROCEDURE Create_Operation_Line (
195     p_api_version                  IN NUMBER,
196     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197     x_return_status                OUT NOCOPY VARCHAR2,
198     x_msg_count                    OUT NOCOPY NUMBER,
199     x_msg_data                     OUT NOCOPY VARCHAR2,
200     p_olev_rec                     IN  olev_rec_type,
201     x_olev_rec                     OUT NOCOPY  olev_rec_type);
202 
203   PROCEDURE Create_Operation_Line (
204     p_api_version                  IN NUMBER,
205     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206     x_return_status                OUT NOCOPY VARCHAR2,
207     x_msg_count                    OUT NOCOPY NUMBER,
208     x_msg_data                     OUT NOCOPY VARCHAR2,
209     p_olev_tbl                     IN olev_tbl_type,
210     x_olev_tbl                     OUT NOCOPY olev_tbl_type);
211 
212   PROCEDURE Update_Operation_Line (
213     p_api_version                  IN NUMBER,
214     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215     x_return_status                OUT NOCOPY VARCHAR2,
216     x_msg_count                    OUT NOCOPY NUMBER,
217     x_msg_data                     OUT NOCOPY VARCHAR2,
218     p_olev_rec                     IN olev_rec_type,
219     x_olev_rec                     OUT NOCOPY olev_rec_type);
220 
221   PROCEDURE Update_Operation_Line (
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_olev_tbl                     IN olev_tbl_type,
228     x_olev_tbl                     OUT NOCOPY olev_tbl_type);
229 
230   PROCEDURE Delete_Operation_Line (
231     p_api_version                  IN NUMBER,
232     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233     x_return_status                OUT NOCOPY VARCHAR2,
234     x_msg_count                    OUT NOCOPY NUMBER,
235     x_msg_data                     OUT NOCOPY VARCHAR2,
236     p_olev_rec                     IN olev_rec_type);
237 
238   PROCEDURE Delete_Operation_Line (
239     p_api_version                  IN NUMBER,
240     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
241     x_return_status                OUT NOCOPY VARCHAR2,
242     x_msg_count                    OUT NOCOPY NUMBER,
243     x_msg_data                     OUT NOCOPY VARCHAR2,
244     p_olev_tbl                     IN olev_tbl_type);
245 
246   PROCEDURE Lock_Operation_Line (
247     p_api_version                  IN NUMBER,
248     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
249     x_return_status                OUT NOCOPY VARCHAR2,
250     x_msg_count                    OUT NOCOPY NUMBER,
251     x_msg_data                     OUT NOCOPY VARCHAR2,
252     p_olev_rec                     IN olev_rec_type);
253 
254   PROCEDURE Lock_Operation_Line (
255     p_api_version                  IN NUMBER,
256     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
257     x_return_status                OUT NOCOPY VARCHAR2,
258     x_msg_count                    OUT NOCOPY NUMBER,
259     x_msg_data                     OUT NOCOPY VARCHAR2,
260     p_olev_tbl                     IN olev_tbl_type);
261 
262   PROCEDURE Validate_Operation_Line (
263     p_api_version                  IN NUMBER,
264     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
265     x_return_status                OUT NOCOPY VARCHAR2,
266     x_msg_count                    OUT NOCOPY NUMBER,
267     x_msg_data                     OUT NOCOPY VARCHAR2,
268     p_olev_rec                     IN olev_rec_type);
269 
270   PROCEDURE Validate_Operation_Line (
271     p_api_version                  IN NUMBER,
272     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273     x_return_status                OUT NOCOPY VARCHAR2,
274     x_msg_count                    OUT NOCOPY NUMBER,
275     x_msg_data                     OUT NOCOPY VARCHAR2,
276     p_olev_tbl                     IN olev_tbl_type);
277 
278   PROCEDURE Create_Masschange_Dtls (
279     p_api_version                  IN NUMBER,
280     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281     x_return_status                OUT NOCOPY VARCHAR2,
282     x_msg_count                    OUT NOCOPY NUMBER,
283     x_msg_data                     OUT NOCOPY VARCHAR2,
284     p_mrdv_rec                     IN  mrdv_rec_type,
285     x_mrdv_rec                     OUT NOCOPY  mrdv_rec_type);
286 
287   PROCEDURE Create_Masschange_Dtls (
288     p_api_version                  IN NUMBER,
289     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290     x_return_status                OUT NOCOPY VARCHAR2,
291     x_msg_count                    OUT NOCOPY NUMBER,
292     x_msg_data                     OUT NOCOPY VARCHAR2,
293     p_mrdv_tbl                     IN mrdv_tbl_type,
294     x_mrdv_tbl                     OUT NOCOPY mrdv_tbl_type);
295 
296   PROCEDURE Update_Masschange_Dtls (
297     p_api_version                  IN NUMBER,
298     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
299     x_return_status                OUT NOCOPY VARCHAR2,
300     x_msg_count                    OUT NOCOPY NUMBER,
301     x_msg_data                     OUT NOCOPY VARCHAR2,
302     p_mrdv_rec                     IN mrdv_rec_type,
303     x_mrdv_rec                     OUT NOCOPY mrdv_rec_type);
304 
305   PROCEDURE Update_Masschange_Dtls (
306     p_api_version                  IN NUMBER,
307     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
308     x_return_status                OUT NOCOPY VARCHAR2,
309     x_msg_count                    OUT NOCOPY NUMBER,
310     x_msg_data                     OUT NOCOPY VARCHAR2,
311     p_mrdv_tbl                     IN mrdv_tbl_type,
312     x_mrdv_tbl                     OUT NOCOPY mrdv_tbl_type);
313 
314   PROCEDURE Delete_Masschange_Dtls (
315     p_api_version                  IN NUMBER,
316     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
317     x_return_status                OUT NOCOPY VARCHAR2,
318     x_msg_count                    OUT NOCOPY NUMBER,
319     x_msg_data                     OUT NOCOPY VARCHAR2,
320     p_mrdv_rec                     IN mrdv_rec_type);
321 
322   PROCEDURE Delete_Masschange_Dtls (
323     p_api_version                  IN NUMBER,
324     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
325     x_return_status                OUT NOCOPY VARCHAR2,
326     x_msg_count                    OUT NOCOPY NUMBER,
327     x_msg_data                     OUT NOCOPY VARCHAR2,
328     p_mrdv_tbl                     IN mrdv_tbl_type);
329 
330   PROCEDURE Lock_Masschange_Dtls (
331     p_api_version                  IN NUMBER,
332     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333     x_return_status                OUT NOCOPY VARCHAR2,
334     x_msg_count                    OUT NOCOPY NUMBER,
335     x_msg_data                     OUT NOCOPY VARCHAR2,
336     p_mrdv_rec                     IN mrdv_rec_type);
337 
338   PROCEDURE Lock_Masschange_Dtls (
339     p_api_version                  IN NUMBER,
340     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
341     x_return_status                OUT NOCOPY VARCHAR2,
342     x_msg_count                    OUT NOCOPY NUMBER,
343     x_msg_data                     OUT NOCOPY VARCHAR2,
344     p_mrdv_tbl                     IN mrdv_tbl_type);
345 
346   PROCEDURE Validate_Masschange_Dtls (
347     p_api_version                  IN NUMBER,
348     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
349     x_return_status                OUT NOCOPY VARCHAR2,
350     x_msg_count                    OUT NOCOPY NUMBER,
351     x_msg_data                     OUT NOCOPY VARCHAR2,
352     p_mrdv_rec                     IN mrdv_rec_type);
353 
354   PROCEDURE Validate_Masschange_Dtls (
355     p_api_version                  IN NUMBER,
356     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
357     x_return_status                OUT NOCOPY VARCHAR2,
358     x_msg_count                    OUT NOCOPY NUMBER,
359     x_msg_data                     OUT NOCOPY VARCHAR2,
360     p_mrdv_tbl                     IN mrdv_tbl_type);
361 
362 END OKC_OPER_INST_PUB;