1 PACKAGE gl_bud_assign_range_pkg AS
2 /* $Header: glibdars.pls 120.8.12010000.1 2008/07/28 13:23:08 appldev ship $ */
3 --
4 -- Package
5 -- gl_bud_assign_range_pkg
6 -- Purpose
7 -- To create GL_BUD_ASSIGN_RANGE_PKG package.
8 -- History
9 -- 12.01.93 E. Rumanang Created
10 --
11
12 --
13 -- Procedure
14 -- is_funds_check_not_none
15 -- Purpose
16 -- Find the existence of funds_check_level_code not equals
17 -- to none. Return true if it found, or else return false.
18 -- History
19 -- 12.01.93 E. Rumanang Created
20 -- Arguments
21 -- x_set_of_books_id Set of books id to be checked.
22 -- Example
23 -- gl_bud_assign_range_pkg.is_funds_check_not_none( 123 );
24 -- Notes
25 --
26 FUNCTION is_funds_check_not_none(
27 x_ledger_id NUMBER ) RETURN BOOLEAN;
28
29 --
30 -- Procedure
31 -- check_unique
32 -- Purpose
33 -- Checks to make sure that the sequence number of the assignment range
34 -- is unique within that organization.
35 -- History
36 -- 12-03-93 D. J. Ogg Created
37 -- Arguments
38 -- org_id The ID of the budget organization
39 -- seq_num The sequence number
40 -- row_id The current rowid
41 -- Example
42 -- gl_bud_assign_range_pkg.check_unique(100, 10, 'ABD02334');
43 -- Notes
44 --
45 PROCEDURE check_unique(org_id NUMBER, seq_num NUMBER,
46 row_id VARCHAR2);
47
48 --
49 -- Procedure
50 -- lock_range
51 -- Purpose
52 -- Locks the row with the given range_id
53 -- History
54 -- 12-16-93 D. J. Ogg Created
55 -- Arguments
56 -- range_id The row to lock
57 -- Example
58 -- gl_bud_assign_range_pkg.lock_range(1000);
59 -- Notes
60 --
61 PROCEDURE lock_range(x_range_id NUMBER);
62
63 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
64 X_Budget_Entity_Id NUMBER,
65 X_Ledger_Id NUMBER,
66 X_Currency_Code VARCHAR2,
67 X_Entry_Code VARCHAR2,
68 X_Range_Id IN OUT NOCOPY NUMBER,
69 X_Status VARCHAR2,
70 X_Last_Update_Date DATE,
71 X_Created_By NUMBER,
72 X_Creation_Date DATE,
73 X_Last_Updated_By NUMBER,
74 X_Last_Update_Login NUMBER,
75 X_Sequence_Number NUMBER,
76 X_Segment1_Low VARCHAR2,
77 X_Segment1_High VARCHAR2,
78 X_Segment2_Low VARCHAR2,
79 X_Segment2_High VARCHAR2,
80 X_Segment3_Low VARCHAR2,
81 X_Segment3_High VARCHAR2,
82 X_Segment4_Low VARCHAR2,
83 X_Segment4_High VARCHAR2,
84 X_Segment5_Low VARCHAR2,
85 X_Segment5_High VARCHAR2,
86 X_Segment6_Low VARCHAR2,
87 X_Segment6_High VARCHAR2,
88 X_Segment7_Low VARCHAR2,
89 X_Segment7_High VARCHAR2,
90 X_Segment8_Low VARCHAR2,
91 X_Segment8_High VARCHAR2,
92 X_Segment9_Low VARCHAR2,
93 X_Segment9_High VARCHAR2,
94 X_Segment10_Low VARCHAR2,
95 X_Segment10_High VARCHAR2,
96 X_Segment11_Low VARCHAR2,
97 X_Segment11_High VARCHAR2,
98 X_Segment12_Low VARCHAR2,
99 X_Segment12_High VARCHAR2,
100 X_Segment13_Low VARCHAR2,
101 X_Segment13_High VARCHAR2,
102 X_Segment14_Low VARCHAR2,
103 X_Segment14_High VARCHAR2,
104 X_Segment15_Low VARCHAR2,
105 X_Segment15_High VARCHAR2,
106 X_Segment16_Low VARCHAR2,
107 X_Segment16_High VARCHAR2,
108 X_Segment17_Low VARCHAR2,
109 X_Segment17_High VARCHAR2,
110 X_Segment18_Low VARCHAR2,
111 X_Segment18_High VARCHAR2,
112 X_Segment19_Low VARCHAR2,
113 X_Segment19_High VARCHAR2,
114 X_Segment20_Low VARCHAR2,
115 X_Segment20_High VARCHAR2,
116 X_Segment21_Low VARCHAR2,
117 X_Segment21_High VARCHAR2,
118 X_Segment22_Low VARCHAR2,
119 X_Segment22_High VARCHAR2,
120 X_Segment23_Low VARCHAR2,
121 X_Segment23_High VARCHAR2,
122 X_Segment24_Low VARCHAR2,
123 X_Segment24_High VARCHAR2,
124 X_Segment25_Low VARCHAR2,
125 X_Segment25_High VARCHAR2,
126 X_Segment26_Low VARCHAR2,
127 X_Segment26_High VARCHAR2,
128 X_Segment27_Low VARCHAR2,
129 X_Segment27_High VARCHAR2,
130 X_Segment28_Low VARCHAR2,
131 X_Segment28_High VARCHAR2,
132 X_Segment29_Low VARCHAR2,
133 X_Segment29_High VARCHAR2,
134 X_Segment30_Low VARCHAR2,
135 X_Segment30_High VARCHAR2,
136 X_Context VARCHAR2,
137 X_Attribute1 VARCHAR2,
138 X_Attribute2 VARCHAR2,
139 X_Attribute3 VARCHAR2,
140 X_Attribute4 VARCHAR2,
141 X_Attribute5 VARCHAR2,
142 X_Attribute6 VARCHAR2,
143 X_Attribute7 VARCHAR2,
144 X_Attribute8 VARCHAR2,
145 X_Attribute9 VARCHAR2,
146 X_Attribute10 VARCHAR2,
147 X_Attribute11 VARCHAR2,
148 X_Attribute12 VARCHAR2,
149 X_Attribute13 VARCHAR2,
150 X_Attribute14 VARCHAR2,
151 X_Attribute15 VARCHAR2,
152 X_Chart_Of_Accounts_Id NUMBER
153 );
154
155 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
156 X_Budget_Entity_Id NUMBER,
157 X_Ledger_Id NUMBER,
158 X_Currency_Code VARCHAR2,
159 X_Entry_Code VARCHAR2,
160 X_Range_Id NUMBER,
161 X_Status VARCHAR2,
162 X_Sequence_Number NUMBER,
163 X_Segment1_Low VARCHAR2,
164 X_Segment1_High VARCHAR2,
165 X_Segment2_Low VARCHAR2,
166 X_Segment2_High VARCHAR2,
167 X_Segment3_Low VARCHAR2,
168 X_Segment3_High VARCHAR2,
169 X_Segment4_Low VARCHAR2,
170 X_Segment4_High VARCHAR2,
171 X_Segment5_Low VARCHAR2,
172 X_Segment5_High VARCHAR2,
173 X_Segment6_Low VARCHAR2,
174 X_Segment6_High VARCHAR2,
175 X_Segment7_Low VARCHAR2,
176 X_Segment7_High VARCHAR2,
177 X_Segment8_Low VARCHAR2,
178 X_Segment8_High VARCHAR2,
179 X_Segment9_Low VARCHAR2,
180 X_Segment9_High VARCHAR2,
181 X_Segment10_Low VARCHAR2,
182 X_Segment10_High VARCHAR2,
183 X_Segment11_Low VARCHAR2,
184 X_Segment11_High VARCHAR2,
185 X_Segment12_Low VARCHAR2,
186 X_Segment12_High VARCHAR2,
187 X_Segment13_Low VARCHAR2,
188 X_Segment13_High VARCHAR2,
189 X_Segment14_Low VARCHAR2,
190 X_Segment14_High VARCHAR2,
191 X_Segment15_Low VARCHAR2,
192 X_Segment15_High VARCHAR2,
193 X_Segment16_Low VARCHAR2,
194 X_Segment16_High VARCHAR2,
195 X_Segment17_Low VARCHAR2,
196 X_Segment17_High VARCHAR2,
197 X_Segment18_Low VARCHAR2,
198 X_Segment18_High VARCHAR2,
199 X_Segment19_Low VARCHAR2,
200 X_Segment19_High VARCHAR2,
201 X_Segment20_Low VARCHAR2,
202 X_Segment20_High VARCHAR2,
203 X_Segment21_Low VARCHAR2,
204 X_Segment21_High VARCHAR2,
205 X_Segment22_Low VARCHAR2,
206 X_Segment22_High VARCHAR2,
207 X_Segment23_Low VARCHAR2,
208 X_Segment23_High VARCHAR2,
209 X_Segment24_Low VARCHAR2,
210 X_Segment24_High VARCHAR2,
211 X_Segment25_Low VARCHAR2,
212 X_Segment25_High VARCHAR2,
213 X_Segment26_Low VARCHAR2,
214 X_Segment26_High VARCHAR2,
215 X_Segment27_Low VARCHAR2,
216 X_Segment27_High VARCHAR2,
217 X_Segment28_Low VARCHAR2,
218 X_Segment28_High VARCHAR2,
219 X_Segment29_Low VARCHAR2,
220 X_Segment29_High VARCHAR2,
221 X_Segment30_Low VARCHAR2,
222 X_Segment30_High VARCHAR2,
223 X_Context VARCHAR2,
224 X_Attribute1 VARCHAR2,
225 X_Attribute2 VARCHAR2,
226 X_Attribute3 VARCHAR2,
227 X_Attribute4 VARCHAR2,
228 X_Attribute5 VARCHAR2,
229 X_Attribute6 VARCHAR2,
230 X_Attribute7 VARCHAR2,
231 X_Attribute8 VARCHAR2,
232 X_Attribute9 VARCHAR2,
233 X_Attribute10 VARCHAR2,
234 X_Attribute11 VARCHAR2,
235 X_Attribute12 VARCHAR2,
236 X_Attribute13 VARCHAR2,
237 X_Attribute14 VARCHAR2,
238 X_Attribute15 VARCHAR2
239 );
240
241 PROCEDURE Update_Row(X_Rowid VARCHAR2,
242 X_Budget_Entity_Id NUMBER,
243 X_Ledger_Id NUMBER,
244 X_Currency_Code VARCHAR2,
245 X_Entry_Code VARCHAR2,
246 X_Range_Id NUMBER,
247 X_Status VARCHAR2,
248 X_Last_Update_Date DATE,
249 X_Last_Updated_By NUMBER,
250 X_Last_Update_Login NUMBER,
251 X_Sequence_Number NUMBER,
252 X_Segment1_Low VARCHAR2,
253 X_Segment1_High VARCHAR2,
254 X_Segment2_Low VARCHAR2,
255 X_Segment2_High VARCHAR2,
256 X_Segment3_Low VARCHAR2,
257 X_Segment3_High VARCHAR2,
258 X_Segment4_Low VARCHAR2,
259 X_Segment4_High VARCHAR2,
260 X_Segment5_Low VARCHAR2,
261 X_Segment5_High VARCHAR2,
262 X_Segment6_Low VARCHAR2,
263 X_Segment6_High VARCHAR2,
264 X_Segment7_Low VARCHAR2,
265 X_Segment7_High VARCHAR2,
266 X_Segment8_Low VARCHAR2,
267 X_Segment8_High VARCHAR2,
268 X_Segment9_Low VARCHAR2,
269 X_Segment9_High VARCHAR2,
270 X_Segment10_Low VARCHAR2,
271 X_Segment10_High VARCHAR2,
272 X_Segment11_Low VARCHAR2,
273 X_Segment11_High VARCHAR2,
274 X_Segment12_Low VARCHAR2,
275 X_Segment12_High VARCHAR2,
276 X_Segment13_Low VARCHAR2,
277 X_Segment13_High VARCHAR2,
278 X_Segment14_Low VARCHAR2,
279 X_Segment14_High VARCHAR2,
280 X_Segment15_Low VARCHAR2,
281 X_Segment15_High VARCHAR2,
282 X_Segment16_Low VARCHAR2,
286 X_Segment18_Low VARCHAR2,
283 X_Segment16_High VARCHAR2,
284 X_Segment17_Low VARCHAR2,
285 X_Segment17_High VARCHAR2,
287 X_Segment18_High VARCHAR2,
288 X_Segment19_Low VARCHAR2,
289 X_Segment19_High VARCHAR2,
290 X_Segment20_Low VARCHAR2,
291 X_Segment20_High VARCHAR2,
292 X_Segment21_Low VARCHAR2,
293 X_Segment21_High VARCHAR2,
294 X_Segment22_Low VARCHAR2,
295 X_Segment22_High VARCHAR2,
296 X_Segment23_Low VARCHAR2,
297 X_Segment23_High VARCHAR2,
298 X_Segment24_Low VARCHAR2,
299 X_Segment24_High VARCHAR2,
300 X_Segment25_Low VARCHAR2,
301 X_Segment25_High VARCHAR2,
302 X_Segment26_Low VARCHAR2,
303 X_Segment26_High VARCHAR2,
304 X_Segment27_Low VARCHAR2,
305 X_Segment27_High VARCHAR2,
306 X_Segment28_Low VARCHAR2,
307 X_Segment28_High VARCHAR2,
308 X_Segment29_Low VARCHAR2,
309 X_Segment29_High VARCHAR2,
310 X_Segment30_Low VARCHAR2,
311 X_Segment30_High VARCHAR2,
312 X_Context VARCHAR2,
313 X_Attribute1 VARCHAR2,
314 X_Attribute2 VARCHAR2,
315 X_Attribute3 VARCHAR2,
316 X_Attribute4 VARCHAR2,
317 X_Attribute5 VARCHAR2,
318 X_Attribute6 VARCHAR2,
319 X_Attribute7 VARCHAR2,
320 X_Attribute8 VARCHAR2,
321 X_Attribute9 VARCHAR2,
322 X_Attribute10 VARCHAR2,
323 X_Attribute11 VARCHAR2,
324 X_Attribute12 VARCHAR2,
325 X_Attribute13 VARCHAR2,
326 X_Attribute14 VARCHAR2,
327 X_Attribute15 VARCHAR2
328 );
329
330 PROCEDURE Delete_Row(X_Range_Id NUMBER, X_Rowid VARCHAR2);
331
332 --
333 -- Procedure
334 -- Insert_Range
335 -- Purpose
336 -- Inserts row into GL_BUDGET_ASSIGNMENT_RANGES.
337 -- Called by an iSpeed API.
338 -- History
339 -- 11-07-00 K Vora Created
340 --
341 PROCEDURE Insert_Range(
342 X_Rowid IN OUT NOCOPY VARCHAR2,
343 X_Budget_Entity_Id NUMBER,
344 X_Ledger_Id NUMBER,
345 X_Currency_Code VARCHAR2,
346 X_Entry_Code VARCHAR2,
347 X_Range_Id NUMBER,
348 X_Status VARCHAR2,
349 X_Last_Update_Date DATE,
350 X_Created_By NUMBER,
351 X_Creation_Date DATE,
352 X_Last_Updated_By NUMBER,
353 X_Last_Update_Login NUMBER,
354 X_Sequence_Number NUMBER,
355 X_Segment1_Low VARCHAR2,
356 X_Segment1_High VARCHAR2,
357 X_Segment2_Low VARCHAR2,
358 X_Segment2_High VARCHAR2,
359 X_Segment3_Low VARCHAR2,
360 X_Segment3_High VARCHAR2,
361 X_Segment4_Low VARCHAR2,
362 X_Segment4_High VARCHAR2,
363 X_Segment5_Low VARCHAR2,
364 X_Segment5_High VARCHAR2,
365 X_Segment6_Low VARCHAR2,
366 X_Segment6_High VARCHAR2,
367 X_Segment7_Low VARCHAR2,
368 X_Segment7_High VARCHAR2,
369 X_Segment8_Low VARCHAR2,
370 X_Segment8_High VARCHAR2,
371 X_Segment9_Low VARCHAR2,
372 X_Segment9_High VARCHAR2,
376 X_Segment11_High VARCHAR2,
373 X_Segment10_Low VARCHAR2,
374 X_Segment10_High VARCHAR2,
375 X_Segment11_Low VARCHAR2,
377 X_Segment12_Low VARCHAR2,
378 X_Segment12_High VARCHAR2,
379 X_Segment13_Low VARCHAR2,
380 X_Segment13_High VARCHAR2,
381 X_Segment14_Low VARCHAR2,
382 X_Segment14_High VARCHAR2,
383 X_Segment15_Low VARCHAR2,
384 X_Segment15_High VARCHAR2,
385 X_Segment16_Low VARCHAR2,
386 X_Segment16_High VARCHAR2,
387 X_Segment17_Low VARCHAR2,
388 X_Segment17_High VARCHAR2,
389 X_Segment18_Low VARCHAR2,
390 X_Segment18_High VARCHAR2,
391 X_Segment19_Low VARCHAR2,
392 X_Segment19_High VARCHAR2,
393 X_Segment20_Low VARCHAR2,
394 X_Segment20_High VARCHAR2,
395 X_Segment21_Low VARCHAR2,
396 X_Segment21_High VARCHAR2,
397 X_Segment22_Low VARCHAR2,
398 X_Segment22_High VARCHAR2,
399 X_Segment23_Low VARCHAR2,
400 X_Segment23_High VARCHAR2,
401 X_Segment24_Low VARCHAR2,
402 X_Segment24_High VARCHAR2,
403 X_Segment25_Low VARCHAR2,
404 X_Segment25_High VARCHAR2,
405 X_Segment26_Low VARCHAR2,
406 X_Segment26_High VARCHAR2,
407 X_Segment27_Low VARCHAR2,
408 X_Segment27_High VARCHAR2,
409 X_Segment28_Low VARCHAR2,
410 X_Segment28_High VARCHAR2,
411 X_Segment29_Low VARCHAR2,
412 X_Segment29_High VARCHAR2,
413 X_Segment30_Low VARCHAR2,
414 X_Segment30_High VARCHAR2,
415 X_Context VARCHAR2,
416 X_Attribute1 VARCHAR2,
417 X_Attribute2 VARCHAR2,
418 X_Attribute3 VARCHAR2,
419 X_Attribute4 VARCHAR2,
420 X_Attribute5 VARCHAR2,
421 X_Attribute6 VARCHAR2,
422 X_Attribute7 VARCHAR2,
423 X_Attribute8 VARCHAR2,
424 X_Attribute9 VARCHAR2,
425 X_Attribute10 VARCHAR2,
426 X_Attribute11 VARCHAR2,
427 X_Attribute12 VARCHAR2,
428 X_Attribute13 VARCHAR2,
429 X_Attribute14 VARCHAR2,
430 X_Attribute15 VARCHAR2
431 );
432
433 END gl_bud_assign_range_pkg;
|
|
|