DBA Data[Home] [Help]

PACKAGE BODY: APPS.OKC_OPERATION_PUB

Source


1 Package Body OKC_OPERATION_PUB AS
2 /* $Header: OKCPOPNB.pls 120.0 2005/05/26 09:48:47 appldev noship $ */
3 	l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4 
5   PROCEDURE add_language IS
6   BEGIN
7     okc_operation_pvt.add_language;
8   END;
9 
10   PROCEDURE insert_operation(
11     p_api_version                  IN NUMBER,
12     p_init_msg_list                IN VARCHAR2 ,
13     x_return_status                OUT NOCOPY VARCHAR2,
14     x_msg_count                    OUT NOCOPY NUMBER,
15     x_msg_data                     OUT NOCOPY VARCHAR2,
16     p_opnv_rec                     IN opnv_rec_type,
17     x_opnv_rec                     OUT NOCOPY opnv_rec_type) IS
18   BEGIN
19     okc_operation_pvt.insert_operation(
20             p_api_version,
21             p_init_msg_list,
22             x_return_status,
23             x_msg_count,
24             x_msg_data,
25             p_opnv_rec,
26             x_opnv_rec);
27   END;
28 
29   PROCEDURE insert_operation(
30     p_api_version                  IN NUMBER,
31     p_init_msg_list                IN VARCHAR2 ,
32     x_return_status                OUT NOCOPY VARCHAR2,
33     x_msg_count                    OUT NOCOPY NUMBER,
34     x_msg_data                     OUT NOCOPY VARCHAR2,
35     p_opnv_tbl                     IN opnv_tbl_type,
36     x_opnv_tbl                     OUT NOCOPY opnv_tbl_type) IS
37   BEGIN
38     okc_operation_pvt.insert_operation(
39             p_api_version,
40             p_init_msg_list,
41             x_return_status,
42             x_msg_count,
43             x_msg_data,
44             p_opnv_tbl,
45             x_opnv_tbl);
46   END;
47 
48   PROCEDURE lock_operation(
49     p_api_version                  IN NUMBER,
50     p_init_msg_list                IN VARCHAR2 ,
51     x_return_status                OUT NOCOPY VARCHAR2,
52     x_msg_count                    OUT NOCOPY NUMBER,
53     x_msg_data                     OUT NOCOPY VARCHAR2,
54     p_opnv_rec                     IN opnv_rec_type) IS
55   BEGIN
56     okc_operation_pvt.lock_operation(
57             p_api_version,
58             p_init_msg_list,
59             x_return_status,
60             x_msg_count,
61             x_msg_data,
62             p_opnv_rec);
63   END;
64 
65   PROCEDURE lock_operation(
66     p_api_version                  IN NUMBER,
67     p_init_msg_list                IN VARCHAR2 ,
68     x_return_status                OUT NOCOPY VARCHAR2,
69     x_msg_count                    OUT NOCOPY NUMBER,
70     x_msg_data                     OUT NOCOPY VARCHAR2,
71     p_opnv_tbl                     IN opnv_tbl_type) IS
72   BEGIN
73     okc_operation_pvt.lock_operation(
74             p_api_version,
75             p_init_msg_list,
76             x_return_status,
77             x_msg_count,
78             x_msg_data,
79             p_opnv_tbl);
80   END;
81 
82   PROCEDURE update_operation(
83     p_api_version                  IN NUMBER,
84     p_init_msg_list                IN VARCHAR2 ,
85     x_return_status                OUT NOCOPY VARCHAR2,
86     x_msg_count                    OUT NOCOPY NUMBER,
87     x_msg_data                     OUT NOCOPY VARCHAR2,
88     p_opnv_rec                     IN opnv_rec_type,
89     x_opnv_rec                     OUT NOCOPY opnv_rec_type) IS
90   BEGIN
91     okc_operation_pvt.update_operation(
92             p_api_version,
93             p_init_msg_list,
94             x_return_status,
95             x_msg_count,
96             x_msg_data,
97             p_opnv_rec,
98             x_opnv_rec);
99   END;
100 
101   PROCEDURE update_operation(
102     p_api_version                  IN NUMBER,
103     p_init_msg_list                IN VARCHAR2 ,
104     x_return_status                OUT NOCOPY VARCHAR2,
105     x_msg_count                    OUT NOCOPY NUMBER,
106     x_msg_data                     OUT NOCOPY VARCHAR2,
107     p_opnv_tbl                     IN opnv_tbl_type,
108     x_opnv_tbl                     OUT NOCOPY opnv_tbl_type) IS
109   BEGIN
110     okc_operation_pvt.update_operation(
111             p_api_version,
112             p_init_msg_list,
113             x_return_status,
114             x_msg_count,
115             x_msg_data,
116             p_opnv_tbl,
117             x_opnv_tbl);
118   END;
119 
120   PROCEDURE delete_operation(
121     p_api_version                  IN NUMBER,
122     p_init_msg_list                IN VARCHAR2 ,
123     x_return_status                OUT NOCOPY VARCHAR2,
124     x_msg_count                    OUT NOCOPY NUMBER,
125     x_msg_data                     OUT NOCOPY VARCHAR2,
126     p_opnv_rec                     IN opnv_rec_type) IS
127   BEGIN
128     okc_operation_pvt.delete_operation(
129             p_api_version,
130             p_init_msg_list,
131             x_return_status,
132             x_msg_count,
133             x_msg_data,
134             p_opnv_rec);
135   END;
136 
137   PROCEDURE delete_operation(
138     p_api_version                  IN NUMBER,
139     p_init_msg_list                IN VARCHAR2 ,
140     x_return_status                OUT NOCOPY VARCHAR2,
141     x_msg_count                    OUT NOCOPY NUMBER,
142     x_msg_data                     OUT NOCOPY VARCHAR2,
143     p_opnv_tbl                     IN opnv_tbl_type) IS
144   BEGIN
145     okc_operation_pvt.delete_operation(
146             p_api_version,
147             p_init_msg_list,
148             x_return_status,
149             x_msg_count,
150             x_msg_data,
151             p_opnv_tbl);
152   END;
153 
154   PROCEDURE validate_operation(
155     p_api_version                  IN NUMBER,
156     p_init_msg_list                IN VARCHAR2 ,
157     x_return_status                OUT NOCOPY VARCHAR2,
158     x_msg_count                    OUT NOCOPY NUMBER,
159     x_msg_data                     OUT NOCOPY VARCHAR2,
160     p_opnv_rec                     IN opnv_rec_type) IS
161   BEGIN
162     okc_operation_pvt.validate_operation(
163             p_api_version,
164             p_init_msg_list,
165             x_return_status,
166             x_msg_count,
167             x_msg_data,
168             p_opnv_rec);
169   END;
170 
171   PROCEDURE validate_operation(
172     p_api_version                  IN NUMBER,
173     p_init_msg_list                IN VARCHAR2 ,
174     x_return_status                OUT NOCOPY VARCHAR2,
175     x_msg_count                    OUT NOCOPY NUMBER,
176     x_msg_data                     OUT NOCOPY VARCHAR2,
177     p_opnv_tbl                     IN opnv_tbl_type) IS
178   BEGIN
179     okc_operation_pvt.validate_operation(
180             p_api_version,
181             p_init_msg_list,
182             x_return_status,
183             x_msg_count,
184             x_msg_data,
185             p_opnv_tbl);
186   END;
187 
188 END OKC_OPERATION_PUB;