DBA Data[Home] [Help]

PACKAGE: APPS.OKC_OPER_INST_PVT

Source


1 PACKAGE OKC_OPER_INST_PVT AS
2 /* $Header: OKCCCOPS.pls 120.0 2005/05/25 19:10:15 appldev noship $ */
3 
4   subtype copv_rec_type is OKC_COP_PVT.copv_rec_type;
5   subtype copv_tbl_type is OKC_COP_PVT.copv_tbl_type;
6   subtype oiev_rec_type is OKC_OIE_PVT.oiev_rec_type;
7   subtype oiev_tbl_type is OKC_OIE_PVT.oiev_tbl_type;
8   subtype olev_rec_type is OKC_OLE_PVT.olev_rec_type;
9   subtype olev_tbl_type is OKC_OLE_PVT.olev_tbl_type;
10   subtype mrdv_rec_type is OKC_MRD_PVT.mrdv_rec_type;
11   subtype mrdv_tbl_type is OKC_MRD_PVT.mrdv_tbl_type;
12 
13 
14   ---------------------------------------------------------------------------
15   -- GLOBAL VARIABLES
16   ---------------------------------------------------------------------------
17   G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKC_OPER_INST_PVT';
18   ---------------------------------------------------------------------------
19 
20   PROCEDURE Create_Class_Operation (
21     p_api_version                  IN NUMBER,
22     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
23     x_return_status                OUT NOCOPY VARCHAR2,
24     x_msg_count                    OUT NOCOPY NUMBER,
25     x_msg_data                     OUT NOCOPY VARCHAR2,
26     p_copv_rec                     IN  OKC_COP_PVT.copv_rec_type,
27     x_copv_rec                     OUT NOCOPY  OKC_COP_PVT.copv_rec_type);
28 
29   PROCEDURE Create_Class_Operation (
30     p_api_version                  IN NUMBER,
31     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
32     x_return_status                OUT NOCOPY VARCHAR2,
33     x_msg_count                    OUT NOCOPY NUMBER,
34     x_msg_data                     OUT NOCOPY VARCHAR2,
35     p_copv_tbl                     IN OKC_COP_PVT.copv_tbl_type,
36     x_copv_tbl                     OUT NOCOPY OKC_COP_PVT.copv_tbl_type);
37 
38   PROCEDURE Update_Class_Operation (
39     p_api_version                  IN NUMBER,
40     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41     x_return_status                OUT NOCOPY VARCHAR2,
42     x_msg_count                    OUT NOCOPY NUMBER,
43     x_msg_data                     OUT NOCOPY VARCHAR2,
44     p_copv_rec                     IN OKC_COP_PVT.copv_rec_type,
45     x_copv_rec                     OUT NOCOPY OKC_COP_PVT.copv_rec_type);
46 
47   PROCEDURE Update_Class_Operation(
48     p_api_version                  IN NUMBER,
49     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50     x_return_status                OUT NOCOPY VARCHAR2,
51     x_msg_count                    OUT NOCOPY NUMBER,
52     x_msg_data                     OUT NOCOPY VARCHAR2,
53     p_copv_tbl                     IN OKC_COP_PVT.copv_tbl_type,
54     x_copv_tbl                     OUT NOCOPY OKC_COP_PVT.copv_tbl_type);
55 
56   PROCEDURE Delete_Class_Operation (
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_copv_rec                     IN OKC_COP_PVT.copv_rec_type);
63 
64   PROCEDURE Delete_Class_Operation (
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_copv_tbl                     IN OKC_COP_PVT.copv_tbl_type);
71 
72   PROCEDURE Lock_Class_Operation (
73     p_api_version                  IN NUMBER,
74     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75     x_return_status                OUT NOCOPY VARCHAR2,
76     x_msg_count                    OUT NOCOPY NUMBER,
77     x_msg_data                     OUT NOCOPY VARCHAR2,
78     p_copv_rec                     IN OKC_COP_PVT.copv_rec_type);
79 
80   PROCEDURE Lock_Class_Operation (
81     p_api_version                  IN NUMBER,
82     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83     x_return_status                OUT NOCOPY VARCHAR2,
84     x_msg_count                    OUT NOCOPY NUMBER,
85     x_msg_data                     OUT NOCOPY VARCHAR2,
86     p_copv_tbl                     IN OKC_COP_PVT.copv_tbl_type);
87 
88   PROCEDURE Validate_Class_Operation (
89     p_api_version                  IN NUMBER,
90     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91     x_return_status                OUT NOCOPY VARCHAR2,
92     x_msg_count                    OUT NOCOPY NUMBER,
93     x_msg_data                     OUT NOCOPY VARCHAR2,
94     p_copv_rec                     IN OKC_COP_PVT.copv_rec_type);
95 
96   PROCEDURE Validate_Class_Operation(
97     p_api_version                  IN NUMBER,
98     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99     x_return_status                OUT NOCOPY VARCHAR2,
100     x_msg_count                    OUT NOCOPY NUMBER,
101     x_msg_data                     OUT NOCOPY VARCHAR2,
102     p_copv_tbl                     IN OKC_COP_PVT.copv_tbl_type);
103 
104   PROCEDURE Create_Operation_Instance (
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_oiev_rec                     IN  OKC_OIE_PVT.oiev_rec_type,
111     x_oiev_rec                     OUT NOCOPY  OKC_OIE_PVT.oiev_rec_type);
112 
113   PROCEDURE Create_Operation_Instance (
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_oiev_tbl                     IN OKC_OIE_PVT.oiev_tbl_type,
120     x_oiev_tbl                     OUT NOCOPY OKC_OIE_PVT.oiev_tbl_type);
121 
122   PROCEDURE Update_Operation_Instance(
123     p_api_version                  IN NUMBER,
124     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125     x_return_status                OUT NOCOPY VARCHAR2,
126     x_msg_count                    OUT NOCOPY NUMBER,
127     x_msg_data                     OUT NOCOPY VARCHAR2,
128     p_oiev_rec                     IN OKC_OIE_PVT.oiev_rec_type,
129     x_oiev_rec                     OUT NOCOPY OKC_OIE_PVT.oiev_rec_type);
130 
131   PROCEDURE Update_Operation_Instance(
132     p_api_version                  IN NUMBER,
133     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134     x_return_status                OUT NOCOPY VARCHAR2,
135     x_msg_count                    OUT NOCOPY NUMBER,
136     x_msg_data                     OUT NOCOPY VARCHAR2,
137     p_oiev_tbl                     IN OKC_OIE_PVT.oiev_tbl_type,
138     x_oiev_tbl                     OUT NOCOPY OKC_OIE_PVT.oiev_tbl_type);
139 
140   PROCEDURE Delete_Operation_Instance(
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_oiev_rec                     IN OKC_OIE_PVT.oiev_rec_type);
147 
148   PROCEDURE Delete_Operation_Instance(
149     p_api_version                  IN NUMBER,
150     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151     x_return_status                OUT NOCOPY VARCHAR2,
152     x_msg_count                    OUT NOCOPY NUMBER,
153     x_msg_data                     OUT NOCOPY VARCHAR2,
154     p_oiev_tbl                     IN OKC_OIE_PVT.oiev_tbl_type);
155 
156   PROCEDURE Lock_Operation_Instance(
157     p_api_version                  IN NUMBER,
158     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159     x_return_status                OUT NOCOPY VARCHAR2,
160     x_msg_count                    OUT NOCOPY NUMBER,
161     x_msg_data                     OUT NOCOPY VARCHAR2,
162     p_oiev_rec                     IN OKC_OIE_PVT.oiev_rec_type);
163 
164   PROCEDURE Lock_Operation_Instance(
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_oiev_tbl                     IN OKC_OIE_PVT.oiev_tbl_type);
171 
172   PROCEDURE Validate_Operation_Instance(
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_oiev_rec                     IN OKC_OIE_PVT.oiev_rec_type);
179 
180   PROCEDURE Validate_Operation_Instance(
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_oiev_tbl                     IN OKC_OIE_PVT.oiev_tbl_type);
187 
188   PROCEDURE Create_Operation_Line (
189     p_api_version                  IN NUMBER,
190     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191     x_return_status                OUT NOCOPY VARCHAR2,
192     x_msg_count                    OUT NOCOPY NUMBER,
193     x_msg_data                     OUT NOCOPY VARCHAR2,
194     p_olev_rec                     IN  OKC_OLE_PVT.olev_rec_type,
195     x_olev_rec                     OUT NOCOPY  OKC_OLE_PVT.olev_rec_type);
196 
197   PROCEDURE Create_Operation_Line (
198     p_api_version                  IN NUMBER,
199     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200     x_return_status                OUT NOCOPY VARCHAR2,
201     x_msg_count                    OUT NOCOPY NUMBER,
202     x_msg_data                     OUT NOCOPY VARCHAR2,
203     p_olev_tbl                     IN OKC_OLE_PVT.olev_tbl_type,
204     x_olev_tbl                     OUT NOCOPY OKC_OLE_PVT.olev_tbl_type);
205 
206   PROCEDURE Update_Operation_Line(
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_olev_rec                     IN OKC_OLE_PVT.olev_rec_type,
213     x_olev_rec                     OUT NOCOPY OKC_OLE_PVT.olev_rec_type);
214 
215   PROCEDURE Update_Operation_Line(
216     p_api_version                  IN NUMBER,
217     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218     x_return_status                OUT NOCOPY VARCHAR2,
219     x_msg_count                    OUT NOCOPY NUMBER,
220     x_msg_data                     OUT NOCOPY VARCHAR2,
221     p_olev_tbl                     IN OKC_OLE_PVT.olev_tbl_type,
222     x_olev_tbl                     OUT NOCOPY OKC_OLE_PVT.olev_tbl_type);
223 
224   PROCEDURE Delete_Operation_Line(
225     p_api_version                  IN NUMBER,
226     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227     x_return_status                OUT NOCOPY VARCHAR2,
228     x_msg_count                    OUT NOCOPY NUMBER,
229     x_msg_data                     OUT NOCOPY VARCHAR2,
230     p_olev_rec                     IN OKC_OLE_PVT.olev_rec_type);
231 
232   PROCEDURE Delete_Operation_Line(
233     p_api_version                  IN NUMBER,
234     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
235     x_return_status                OUT NOCOPY VARCHAR2,
236     x_msg_count                    OUT NOCOPY NUMBER,
237     x_msg_data                     OUT NOCOPY VARCHAR2,
238     p_olev_tbl                     IN OKC_OLE_PVT.olev_tbl_type);
239 
240   PROCEDURE Lock_Operation_Line(
241     p_api_version                  IN NUMBER,
242     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243     x_return_status                OUT NOCOPY VARCHAR2,
244     x_msg_count                    OUT NOCOPY NUMBER,
245     x_msg_data                     OUT NOCOPY VARCHAR2,
246     p_olev_rec                     IN OKC_OLE_PVT.olev_rec_type);
247 
248   PROCEDURE Lock_Operation_Line(
249     p_api_version                  IN NUMBER,
250     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251     x_return_status                OUT NOCOPY VARCHAR2,
252     x_msg_count                    OUT NOCOPY NUMBER,
253     x_msg_data                     OUT NOCOPY VARCHAR2,
254     p_olev_tbl                     IN OKC_OLE_PVT.olev_tbl_type);
255 
256   PROCEDURE Validate_Operation_Line(
257     p_api_version                  IN NUMBER,
258     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259     x_return_status                OUT NOCOPY VARCHAR2,
260     x_msg_count                    OUT NOCOPY NUMBER,
261     x_msg_data                     OUT NOCOPY VARCHAR2,
262     p_olev_rec                     IN OKC_OLE_PVT.olev_rec_type);
263 
264   PROCEDURE Validate_Operation_Line(
265     p_api_version                  IN NUMBER,
266     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267     x_return_status                OUT NOCOPY VARCHAR2,
268     x_msg_count                    OUT NOCOPY NUMBER,
269     x_msg_data                     OUT NOCOPY VARCHAR2,
270     p_olev_tbl                     IN OKC_OLE_PVT.olev_tbl_type);
271 
272  PROCEDURE Create_Masschange_Dtls (
273     p_api_version                  IN NUMBER,
274     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
275     x_return_status                OUT NOCOPY VARCHAR2,
276     x_msg_count                    OUT NOCOPY NUMBER,
277     x_msg_data                     OUT NOCOPY VARCHAR2,
278     p_mrdv_rec                     IN  OKC_MRD_PVT.mrdv_rec_type,
279     x_mrdv_rec                     OUT NOCOPY  OKC_MRD_PVT.mrdv_rec_type);
280 
281   PROCEDURE Create_Masschange_Dtls (
282     p_api_version                  IN NUMBER,
283     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284     x_return_status                OUT NOCOPY VARCHAR2,
285     x_msg_count                    OUT NOCOPY NUMBER,
286     x_msg_data                     OUT NOCOPY VARCHAR2,
287     p_mrdv_tbl                     IN OKC_MRD_PVT.mrdv_tbl_type,
288     x_mrdv_tbl                     OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type);
289 
290   PROCEDURE Update_Masschange_Dtls (
291     p_api_version                  IN NUMBER,
292     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293     x_return_status                OUT NOCOPY VARCHAR2,
294     x_msg_count                    OUT NOCOPY NUMBER,
295     x_msg_data                     OUT NOCOPY VARCHAR2,
296     p_mrdv_rec                     IN OKC_MRD_PVT.mrdv_rec_type,
297     x_mrdv_rec                     OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type);
298 
299   PROCEDURE Update_Masschange_Dtls(
300     p_api_version                  IN NUMBER,
301     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302     x_return_status                OUT NOCOPY VARCHAR2,
303     x_msg_count                    OUT NOCOPY NUMBER,
304     x_msg_data                     OUT NOCOPY VARCHAR2,
305     p_mrdv_tbl                     IN OKC_MRD_PVT.mrdv_tbl_type,
306     x_mrdv_tbl                     OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type);
307 
308   PROCEDURE Delete_Masschange_Dtls (
309     p_api_version                  IN NUMBER,
310     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311     x_return_status                OUT NOCOPY VARCHAR2,
312     x_msg_count                    OUT NOCOPY NUMBER,
313     x_msg_data                     OUT NOCOPY VARCHAR2,
314     p_mrdv_rec                     IN OKC_MRD_PVT.mrdv_rec_type);
315 
316   PROCEDURE Delete_Masschange_Dtls (
317     p_api_version                  IN NUMBER,
318     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
319     x_return_status                OUT NOCOPY VARCHAR2,
320     x_msg_count                    OUT NOCOPY NUMBER,
321     x_msg_data                     OUT NOCOPY VARCHAR2,
322     p_mrdv_tbl                     IN OKC_MRD_PVT.mrdv_tbl_type);
323 
324   PROCEDURE Lock_Masschange_Dtls (
325     p_api_version                  IN NUMBER,
326     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327     x_return_status                OUT NOCOPY VARCHAR2,
328     x_msg_count                    OUT NOCOPY NUMBER,
329     x_msg_data                     OUT NOCOPY VARCHAR2,
330     p_mrdv_rec                     IN OKC_MRD_PVT.mrdv_rec_type);
331 
332   PROCEDURE Lock_Masschange_Dtls (
333     p_api_version                  IN NUMBER,
334     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
335     x_return_status                OUT NOCOPY VARCHAR2,
336     x_msg_count                    OUT NOCOPY NUMBER,
337     x_msg_data                     OUT NOCOPY VARCHAR2,
338     p_mrdv_tbl                     IN OKC_MRD_PVT.mrdv_tbl_type);
339 
340   PROCEDURE Validate_Masschange_Dtls (
341     p_api_version                  IN NUMBER,
342     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
343     x_return_status                OUT NOCOPY VARCHAR2,
344     x_msg_count                    OUT NOCOPY NUMBER,
345     x_msg_data                     OUT NOCOPY VARCHAR2,
346     p_mrdv_rec                     IN OKC_MRD_PVT.mrdv_rec_type);
347 
348   PROCEDURE Validate_Masschange_Dtls(
349     p_api_version                  IN NUMBER,
350     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
351     x_return_status                OUT NOCOPY VARCHAR2,
352     x_msg_count                    OUT NOCOPY NUMBER,
353     x_msg_data                     OUT NOCOPY VARCHAR2,
354     p_mrdv_tbl                     IN OKC_MRD_PVT.mrdv_tbl_type);
355 END OKC_OPER_INST_PVT;