[Home] [Help]
PACKAGE: APPS.JTFB_TEMP_BIN_PKG
Source
1 package jtfb_temp_bin_pkg as
2 /* $Header: jtfbbins.pls 120.1 2005/07/02 02:32:50 appldev ship $ */
3 --
4 --
5 /*****************************************************************************/
6 -- Start Of Comments
7 --
8 -- Name
9 -- jtfb_temp_bin_pkg
10 --
11 -- Purpose
12 -- This package provides an API to the JTFB_TEMP_BIN 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 g_pkg_name constant varchar2(30) := 'jtfb_temp_bin_pkg';
35 --
36 -- End of Global Package Globals
37 --
38 --
39 /*****************************************************************************/
40 -- Start Of Comments
41 --
42 -- Name : insert_row
43 -- Type : Public
44 -- Function:
45 -- Insert a new record into the temporary table, JTFB_TEMP_BIN
46 --
47 -- Pre-Reqs:
48 -- None.
49 --
50 -- Parameters:
51 -- x_rowid
52 -- in out NOCOPY varchar2
53 -- x_bin_code
54 -- in varchar2
55 -- x_rowno
56 -- in number
57 -- x_col1
58 -- in varchar2
59 -- x_col2
60 -- in varchar2
61 -- x_col3
62 -- in varchar2
63 -- x_col4
64 -- in varchar2
65 -- x_col5
66 -- in varchar2
67 -- x_col6
68 -- in varchar2
69 -- x_col7
70 -- in varchar2
71 -- x_col8
72 -- in varchar2
73 -- x_col9
74 -- in varchar2
75 -- x_col10
76 -- in varchar2
77 -- x_col11
78 -- in varchar2
79 -- x_col12
80 -- in varchar2
81 -- x_col13
82 -- in varchar2
83 -- x_col14
84 -- in varchar2
85 -- x_col15
86 -- in varchar2
87 -- x_col16
88 -- in varchar2
89 --
90 -- Notes:
91 -- None.
92 --
93 -- End Of Comments
94 procedure insert_row(
95 x_rowid in out NOCOPY varchar2
96 , x_bin_code in varchar2
97 , x_rowno in number default null
98 , x_col1 in varchar2 default null
99 , x_col2 in varchar2 default null
100 , x_col3 in varchar2 default null
101 , x_col4 in varchar2 default null
102 , x_col5 in varchar2 default null
103 , x_col6 in varchar2 default null
104 , x_col7 in varchar2 default null
105 , x_col8 in varchar2 default null
106 , x_col9 in varchar2 default null
107 , x_col10 in varchar2 default null
108 , x_col11 in varchar2 default null
109 , x_col12 in varchar2 default null
110 , x_col13 in varchar2 default null
111 , x_col14 in varchar2 default null
112 , x_col15 in varchar2 default null
113 , x_col16 in varchar2 default null
114 );
115 --
116 --
117 /*****************************************************************************/
118 -- Start Of Comments
119 --
120 -- Name : lock_row
121 -- Type : Public
122 -- Function:
123 -- Locks a row in the temporary table, JTFB_TEMP_BIN
124 --
125 -- Pre-Reqs:
126 -- None.
127 --
128 -- Parameters:
129 -- x_bin_code
130 -- in varchar2
131 -- x_rowno
132 -- in number
133 -- x_col1
134 -- in varchar2
135 -- x_col2
136 -- in varchar2
137 -- x_col3
138 -- in varchar2
139 -- x_col4
140 -- in varchar2
141 -- x_col5
142 -- in varchar2
143 -- x_col6
144 -- in varchar2
145 -- x_col7
146 -- in varchar2
147 -- x_col8
148 -- in varchar2
149 -- x_col9
150 -- in varchar2
151 -- x_col10
152 -- in varchar2
153 -- x_col11
154 -- in varchar2
155 -- x_col12
156 -- in varchar2
157 -- x_col13
158 -- in varchar2
159 -- x_col14
160 -- in varchar2
161 -- x_col15
162 -- in varchar2
163 -- x_col16
164 -- in varchar2
165 --
166 -- Notes:
167 -- None.
168 --
169 -- End Of Comments
170 procedure lock_row(
171 x_bin_code in varchar2
172 , x_rowno in number
173 , x_col1 in varchar2
174 , x_col2 in varchar2
175 , x_col3 in varchar2
176 , x_col4 in varchar2
177 , x_col5 in varchar2
178 , x_col6 in varchar2
179 , x_col7 in varchar2
180 , x_col8 in varchar2
181 , x_col9 in varchar2
182 , x_col10 in varchar2
183 , x_col11 in varchar2
184 , x_col12 in varchar2
185 , x_col13 in varchar2
186 , x_col14 in varchar2
187 , x_col15 in varchar2
188 , x_col16 in varchar2
189 );
190 --
191 --
192 /*****************************************************************************/
193 -- Start Of Comments
194 --
195 -- Name : update_row
196 -- Type : Public
197 -- Function:
198 -- Updates a row in the temporary table, JTFB_TEMP_BIN
199 --
200 -- Pre-Reqs:
201 -- None.
202 --
203 -- Parameters:
204 -- x_bin_code
205 -- in varchar2
206 -- x_rowno
207 -- in number
208 -- x_col1
209 -- in varchar2
210 -- x_col2
211 -- in varchar2
212 -- x_col3
213 -- in varchar2
214 -- x_col4
215 -- in varchar2
216 -- x_col5
217 -- in varchar2
218 -- x_col6
219 -- in varchar2
220 -- x_col7
221 -- in varchar2
222 -- x_col8
223 -- in varchar2
224 -- x_col9
225 -- in varchar2
226 -- x_col10
227 -- in varchar2
228 -- x_col11
229 -- in varchar2
230 -- x_col12
231 -- in varchar2
232 -- x_col13
233 -- in varchar2
234 -- x_col14
235 -- in varchar2
236 -- x_col15
237 -- in varchar2
238 -- x_col16
239 -- in varchar2
240 --
241 -- Notes:
242 -- None.
243 --
244 -- End Of Comments
245 procedure update_row(
246 x_bin_code in varchar2
247 , x_rowno in number
248 , x_col1 in varchar2
249 , x_col2 in varchar2
250 , x_col3 in varchar2
251 , x_col4 in varchar2
252 , x_col5 in varchar2
253 , x_col6 in varchar2
254 , x_col7 in varchar2
255 , x_col8 in varchar2
256 , x_col9 in varchar2
257 , x_col10 in varchar2
258 , x_col11 in varchar2
259 , x_col12 in varchar2
260 , x_col13 in varchar2
261 , x_col14 in varchar2
262 , x_col15 in varchar2
263 , x_col16 in varchar2
264 );
265 --
266 --
267 /*****************************************************************************/
268 -- Start Of Comments
269 --
270 -- Name : delete_row
271 -- Type : Public
272 -- Function:
273 -- Deletes a row from the temporary table, JTFB_TEMP_BIN
274 --
275 -- Pre-Reqs:
276 -- None.
277 --
278 -- Parameters:
279 -- x_bin_code
280 -- in varchar2
281 --
282 -- Notes:
283 -- None.
284 --
285 -- End Of Comments
286 procedure delete_row(
287 x_bin_code in varchar2
288 );
289 --
290 --
291 end jtfb_temp_bin_pkg;