DBA Data[Home] [Help]

PACKAGE BODY: APPS.OKC_CLASS_PUB

Source


1 Package Body OKC_CLASS_PUB AS
2 /* $Header: OKCPCLSB.pls 120.0 2005/05/25 19:36:12 appldev noship $ */
3 	l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4 
5   PROCEDURE add_language IS
6   BEGIN
7     okc_class_pvt.add_language;
8   END;
9 
10   PROCEDURE insert_class(
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_clsv_rec                     IN clsv_rec_type,
17     x_clsv_rec                     OUT NOCOPY clsv_rec_type) IS
18   BEGIN
19     okc_class_pvt.insert_class(
20               p_api_version,
21               p_init_msg_list,
22               x_return_status,
23               x_msg_count,
24               x_msg_data,
25               p_clsv_rec,
26               x_clsv_rec);
27   END;
28 
29   PROCEDURE insert_class(
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_clsv_tbl                     IN clsv_tbl_type,
36     x_clsv_tbl                     OUT NOCOPY clsv_tbl_type) IS
37   BEGIN
38     okc_class_pvt.insert_class(
39               p_api_version,
40               p_init_msg_list,
41               x_return_status,
42               x_msg_count,
43               x_msg_data,
44               p_clsv_tbl,
45               x_clsv_tbl);
46   END;
47 
48   PROCEDURE lock_class(
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_clsv_rec                     IN clsv_rec_type) IS
55   BEGIN
56     okc_class_pvt.lock_class(
57               p_api_version,
58               p_init_msg_list,
59               x_return_status,
60               x_msg_count,
61               x_msg_data,
62               p_clsv_rec);
63   END;
64 
65   PROCEDURE lock_class(
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_clsv_tbl                     IN clsv_tbl_type) IS
72   BEGIN
73     okc_class_pvt.lock_class(
74               p_api_version,
75               p_init_msg_list,
76               x_return_status,
77               x_msg_count,
78               x_msg_data,
79               p_clsv_tbl);
80   END;
81 
82   PROCEDURE update_class(
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_clsv_rec                     IN clsv_rec_type,
89     x_clsv_rec                     OUT NOCOPY clsv_rec_type) IS
90   BEGIN
91     okc_class_pvt.update_class(
92               p_api_version,
93               p_init_msg_list,
94               x_return_status,
95               x_msg_count,
96               x_msg_data,
97               p_clsv_rec,
98               x_clsv_rec);
99   END;
100 
101   PROCEDURE update_class(
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_clsv_tbl                     IN clsv_tbl_type,
108     x_clsv_tbl                     OUT NOCOPY clsv_tbl_type) IS
109   BEGIN
110     okc_class_pvt.update_class(
111               p_api_version,
112               p_init_msg_list,
113               x_return_status,
114               x_msg_count,
115               x_msg_data,
116               p_clsv_tbl,
117               x_clsv_tbl);
118   END;
119 
120   PROCEDURE delete_class(
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_clsv_rec                     IN clsv_rec_type) IS
127   BEGIN
128     okc_class_pvt.delete_class(
129               p_api_version,
130               p_init_msg_list,
131               x_return_status,
132               x_msg_count,
133               x_msg_data,
134               p_clsv_rec);
135   END;
136 
137   PROCEDURE delete_class(
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_clsv_tbl                     IN clsv_tbl_type) IS
144   BEGIN
145     okc_class_pvt.delete_class(
146               p_api_version,
147               p_init_msg_list,
148               x_return_status,
149               x_msg_count,
150               x_msg_data,
151               p_clsv_tbl);
152   END;
153 
154   PROCEDURE validate_class(
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_clsv_rec                     IN clsv_rec_type) IS
161   BEGIN
162     okc_class_pvt.validate_class(
163               p_api_version,
164               p_init_msg_list,
165               x_return_status,
166               x_msg_count,
167               x_msg_data,
168               p_clsv_rec);
169   END;
170 
171   PROCEDURE validate_class(
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_clsv_tbl                     IN clsv_tbl_type) IS
178   BEGIN
179     okc_class_pvt.validate_class(
180               p_api_version,
181               p_init_msg_list,
182               x_return_status,
183               x_msg_count,
184               x_msg_data,
185               p_clsv_tbl);
186   END;
187 
188 END OKC_CLASS_PUB;