[Home] [Help]
PACKAGE BODY: APPS.JTFB_TEMP_REPORT_PKG
Source
1 package body jtfb_temp_report_pkg as
2 /* $Header: jtfbrptb.pls 120.1 2005/07/02 00:32:59 appldev ship $ */
3 --
4 --
5 /*****************************************************************************/
6 -- Start Of Comments
7 --
8 -- Name
9 -- jtfb_temp_report_pkg
10 --
11 -- Purpose
12 -- This package provides an API to the JTFB_TEMP_REPORT table.
13 --
14 -- Functions
15 -- None
16 --
17 -- Procedures
18 -- insert_row
19 -- lock_row
20 -- update_row
21 -- delete_row
22 --
23 -- Notes
24 --
25 -- History
26 -- 09-MAY-2001, Elanchelvan Elango, Created
27 --
28 -- End of Comments
29
30
31 /*****************************************************************************/
32 -- Start of Package Globals
33 --
34 -- End of Global Package Globals
35 --
36 --
37 /*****************************************************************************/
38 -- Start of Private Methods Specification
39 --
40 --
41 /*****************************************************************************/
42 -- Start Of Comments
43 --
44 -- Name : write_message
45 -- Type : Private
46 -- Function:
47 -- This procedure writes message (typically debug)
48 --
49 -- Pre-Reqs:
50 --
51 -- Parameters:
52 -- p_message_text
53 -- in varchar2
54 -- This is the descriptive part of the message.
55 --
56 -- Notes:
57 --
58 -- End Of Comments
59 procedure write_message(
60 p_message_text in varchar2
61 );
62 --
63 -- End of Private Methods Specification
64 --
65 --
66 procedure write_message(
67 p_message_text in varchar2
68 ) is
69 begin
70 null;
71 --dbms_output.put_line(p_message_text);
72 exception
73 when others then
74 null;
75 --dbms_output.put_line(p_message_text);
76 end write_message;
77 --
78 --
79 procedure insert_row(
80 x_rowid in out NOCOPY varchar2
81 , x_report_code in varchar2
82 , x_rowno in number default null
83 , x_col1 in varchar2 default null
84 , x_col2 in varchar2 default null
85 , x_col3 in varchar2 default null
86 , x_col4 in varchar2 default null
87 , x_col5 in varchar2 default null
88 , x_col6 in varchar2 default null
89 , x_col7 in varchar2 default null
90 , x_col8 in varchar2 default null
91 , x_col9 in varchar2 default null
92 , x_col10 in varchar2 default null
93 , x_col11 in varchar2 default null
94 , x_col12 in varchar2 default null
95 , x_col13 in varchar2 default null
96 , x_col14 in varchar2 default null
97 , x_col15 in varchar2 default null
98 , x_col16 in varchar2 default null
99 , x_col17 in varchar2 default null
100 , x_col18 in varchar2 default null
101 , x_col19 in varchar2 default null
102 , x_col20 in varchar2 default null
103 , x_col21 in varchar2 default null
104 , x_col22 in varchar2 default null
105 , x_col23 in varchar2 default null
106 , x_col24 in varchar2 default null
107 , x_col25 in varchar2 default null
108 , x_col26 in varchar2 default null
109 , x_col27 in varchar2 default null
110 , x_col28 in varchar2 default null
111 , x_col29 in varchar2 default null
112 , x_col30 in varchar2 default null
113 , x_col31 in varchar2 default null
114 , x_col32 in varchar2 default null
115 , x_col33 in varchar2 default null
116 , x_col34 in varchar2 default null
117 , x_col35 in varchar2 default null
118 , x_col36 in varchar2 default null
119 , x_col37 in varchar2 default null
120 , x_col38 in varchar2 default null
121 , x_col39 in varchar2 default null
122 , x_col40 in varchar2 default null
123 ) is
124
125 l_method_name varchar2(80) := g_pkg_name || '.insert_row: ';
126
127 begin
128
129 insert into JTFB_TEMP_REPORT (
130 report_code
131 , rowno
132 , col1
133 , col2
134 , col3
135 , col4
136 , col5
137 , col6
138 , col7
139 , col8
140 , col9
141 , col10
142 , col11
143 , col12
144 , col13
145 , col14
146 , col15
147 , col16
148 , col17
149 , col18
150 , col19
151 , col20
152 , col21
153 , col22
154 , col23
155 , col24
156 , col25
157 , col26
158 , col27
159 , col28
160 , col29
161 , col30
162 , col31
163 , col32
164 , col33
165 , col34
166 , col35
167 , col36
168 , col37
169 , col38
170 , col39
171 , col40
172 ) values (
173 x_report_code
174 , x_rowno
175 , x_col1
176 , x_col2
177 , x_col3
178 , x_col4
179 , x_col5
180 , x_col6
181 , x_col7
182 , x_col8
183 , x_col9
184 , x_col10
185 , x_col11
186 , x_col12
187 , x_col13
188 , x_col14
189 , x_col15
190 , x_col16
191 , x_col17
192 , x_col18
193 , x_col19
194 , x_col20
195 , x_col21
196 , x_col22
197 , x_col23
198 , x_col24
199 , x_col25
200 , x_col26
201 , x_col27
202 , x_col28
203 , x_col29
204 , x_col30
205 , x_col31
206 , x_col32
207 , x_col33
208 , x_col34
209 , x_col35
210 , x_col36
211 , x_col37
212 , x_col38
213 , x_col39
214 , x_col40
215 );
216 exception
217 when others then
218 write_message(l_method_name || sqlerrm);
219 end insert_row;
220 --
221 --
222 procedure lock_row(
223 x_report_code in varchar2
224 , x_rowno in number default null
225 , x_col1 in varchar2 default null
226 , x_col2 in varchar2 default null
227 , x_col3 in varchar2 default null
228 , x_col4 in varchar2 default null
229 , x_col5 in varchar2 default null
230 , x_col6 in varchar2 default null
231 , x_col7 in varchar2 default null
232 , x_col8 in varchar2 default null
233 , x_col9 in varchar2 default null
234 , x_col10 in varchar2 default null
235 , x_col11 in varchar2 default null
236 , x_col12 in varchar2 default null
237 , x_col13 in varchar2 default null
238 , x_col14 in varchar2 default null
239 , x_col15 in varchar2 default null
240 , x_col16 in varchar2 default null
241 , x_col17 in varchar2 default null
242 , x_col18 in varchar2 default null
243 , x_col19 in varchar2 default null
244 , x_col20 in varchar2 default null
245 , x_col21 in varchar2 default null
246 , x_col22 in varchar2 default null
247 , x_col23 in varchar2 default null
248 , x_col24 in varchar2 default null
249 , x_col25 in varchar2 default null
250 , x_col26 in varchar2 default null
251 , x_col27 in varchar2 default null
252 , x_col28 in varchar2 default null
253 , x_col29 in varchar2 default null
254 , x_col30 in varchar2 default null
255 , x_col31 in varchar2 default null
256 , x_col32 in varchar2 default null
257 , x_col33 in varchar2 default null
258 , x_col34 in varchar2 default null
259 , x_col35 in varchar2 default null
260 , x_col36 in varchar2 default null
261 , x_col37 in varchar2 default null
262 , x_col38 in varchar2 default null
263 , x_col39 in varchar2 default null
264 , x_col40 in varchar2 default null
265 ) is
266
267 l_method_name varchar2(80) := g_pkg_name || '.lock_row: ';
268
269 begin
270 null;
271 exception
272 when others then
273 write_message(l_method_name || sqlerrm);
274 end lock_row;
275 --
276 --
277 procedure update_row(
278 x_report_code in varchar2
279 , x_rowno in number default null
280 , x_col1 in varchar2 default null
281 , x_col2 in varchar2 default null
282 , x_col3 in varchar2 default null
283 , x_col4 in varchar2 default null
284 , x_col5 in varchar2 default null
285 , x_col6 in varchar2 default null
286 , x_col7 in varchar2 default null
287 , x_col8 in varchar2 default null
288 , x_col9 in varchar2 default null
289 , x_col10 in varchar2 default null
290 , x_col11 in varchar2 default null
291 , x_col12 in varchar2 default null
292 , x_col13 in varchar2 default null
293 , x_col14 in varchar2 default null
294 , x_col15 in varchar2 default null
295 , x_col16 in varchar2 default null
296 , x_col17 in varchar2 default null
297 , x_col18 in varchar2 default null
298 , x_col19 in varchar2 default null
299 , x_col20 in varchar2 default null
300 , x_col21 in varchar2 default null
301 , x_col22 in varchar2 default null
302 , x_col23 in varchar2 default null
303 , x_col24 in varchar2 default null
304 , x_col25 in varchar2 default null
305 , x_col26 in varchar2 default null
306 , x_col27 in varchar2 default null
307 , x_col28 in varchar2 default null
308 , x_col29 in varchar2 default null
309 , x_col30 in varchar2 default null
310 , x_col31 in varchar2 default null
311 , x_col32 in varchar2 default null
312 , x_col33 in varchar2 default null
313 , x_col34 in varchar2 default null
314 , x_col35 in varchar2 default null
315 , x_col36 in varchar2 default null
316 , x_col37 in varchar2 default null
317 , x_col38 in varchar2 default null
318 , x_col39 in varchar2 default null
319 , x_col40 in varchar2 default null
320 ) is
321
322 l_method_name varchar2(80) := g_pkg_name || '.update_row: ';
323
324 begin
325 null;
326 exception
327 when others then
328 write_message(l_method_name || sqlerrm);
329 end update_row;
330 --
331 --
332 procedure delete_row(
333 x_report_code in varchar2
334 ) is
335
336 l_method_name varchar2(80) := g_pkg_name || '.delete_row: ';
337
338 begin
339 null;
340 exception
341 when others then
342 write_message(l_method_name || sqlerrm);
343 end delete_row;
344 --
345 --
346 end jtfb_temp_report_pkg;