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