1 PACKAGE gl_interface_pkg AS
2 /* $Header: glijiins.pls 120.7 2005/05/05 01:11:20 kvora ship $ */
3 --
4 -- Package
5 -- gl_interface_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_interface
8 -- History
9 -- 03-30-94 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- Get_Ledger_Column_Name
14 -- Purpose
15 -- Gets the name of the ledger column to be used
16 -- History
17 -- 14-OCT-2002 D. J. Ogg Created
18 -- Arguments
19 -- Itable Interface Table Name
20 --
21 FUNCTION Get_Ledger_Column_Name(
22 Itable VARCHAR2,
23 Resp_Id NUMBER,
24 Resp_Appl_Id NUMBER ) RETURN VARCHAR2;
25
26 --
27 -- Procedure
28 -- Get_Ledger_Id
29 -- Purpose
30 -- Gets the ledger id from an interface table
31 -- History
32 -- 14-OCT-2002 D. J. Ogg Created
33 -- Arguments
34 -- Itable Interface Table Name
35 -- Ledger_Column_Name Column that stores ledger_id
36 -- X_Rowid Row id to get id from
37 --
38 FUNCTION Get_Ledger_Id(
39 Itable VARCHAR2,
40 Ledger_Column_Name VARCHAR2,
41 X_Rowid VARCHAR2) RETURN NUMBER;
42
43 --
44 -- Procedure
45 -- Insert_Budget_Transfer_Row
46 -- Purpose
47 -- Inserts two new rows in gl_interface for the budget transfer
48 -- History
49 -- 03-30-94 D. J. Ogg Created
50 -- Arguments
51 -- X_From_Rowid The place to store the Row ID of the
52 -- from row
53 -- X_To_Rowid The place to store the Row ID of the
54 -- to row
55 -- X_Status The status of the new rows
56 -- X_Ledger_Id The ledger ID of the new rows
57 -- X_User_Je_Source_Name The source of the new rows (Transfer)
58 -- X_Group_Id The group ID of the new rows
59 -- X_User_Je_Category_Name The category of the new rows (Budget)
60 -- X_Budget_Version_Id The budget containing the transfered amts
61 -- X_Je_Batch_Name The batch name of the new rows
62 -- X_Currency_Code The currency of the transfered amts
63 -- X_From_Code_Combination_Id The code combination of the from row
64 -- X_To_Code_Combination_Id The code combination of the to row
65 -- X_Combination_Number The ID indicating the group of transfers
66 -- containing the new rows
67 -- X_Period_Name The period of the transfer
68 -- X_From_Entered_Dr The Debit amount transfered from the from
69 -- X_From_Entered_Cr The Credit amount transfered from the from
70 -- X_To_Entered_Dr The Debit amount transfered to the to
71 -- X_To_Entered_Cr The Credit amount transfered to the to
72 -- X_Date_Created The date on which the new rows were
73 -- created
74 -- X_Created_By The user id of the person who created the
75 -- new rows
76 --
77 PROCEDURE Insert_Budget_Transfer_Row(
78 X_From_Rowid IN OUT NOCOPY VARCHAR2,
79 X_To_Rowid IN OUT NOCOPY VARCHAR2,
80 X_Status VARCHAR2,
81 X_Ledger_Id NUMBER,
82 X_User_Je_Source_Name VARCHAR2,
83 X_Group_Id NUMBER,
84 X_User_Je_Category_Name VARCHAR2,
85 X_Budget_Version_Id NUMBER,
86 X_Je_Batch_Name VARCHAR2,
87 X_Currency_Code VARCHAR2,
88 X_From_Code_Combination_Id NUMBER,
89 X_To_Code_Combination_Id NUMBER,
90 X_Combination_Number NUMBER,
91 X_Period_Name VARCHAR2,
92 X_From_Entered_Dr NUMBER,
93 X_From_Entered_Cr NUMBER,
94 X_To_Entered_Dr NUMBER,
95 X_To_Entered_Cr NUMBER,
96 X_Date_Created DATE,
97 X_Created_By NUMBER);
98
99 --
100 -- Procedure
101 -- Update_Budget_Transfer_Row
102 -- Purpose
103 -- Updates the two rows in gl_interface that correspond to a single
104 -- budget transfer.
105 -- History
106 -- 03-30-94 D. J. Ogg Created
107 -- Arguments
108 -- X_From_Rowid The Row ID of the from row
109 -- X_To_Rowid The Row ID of the to row
110 -- X_Status The status of the rows
111 -- X_Ledger_Id The ledger ID of the rows
112 -- X_User_Je_Source_Name The source of the rows (Transfer)
113 -- X_Group_Id The group ID of the rows
114 -- X_User_Je_Category_Name The category of the rows (Budget)
115 -- X_Budget_Version_Id The budget containing the transfered amts
116 -- X_Je_Batch_Name The batch name of the rows
117 -- X_Currency_Code The currency of the transfered amts
118 -- X_From_Code_Combination_Id The code combination of the from row
119 -- X_To_Code_Combination_Id The code combination of the to row
120 -- X_Combination_Number The ID indicating the group of transfers
121 -- containing the rows
122 -- X_Period_Name The period of the transfer
123 -- X_From_Entered_Dr The Debit amount transfered from the from
124 -- X_From_Entered_Cr The Credit amount transfered from the from
125 -- X_To_Entered_Dr The Debit amount transfered to the to
126 -- X_To_Entered_Cr The Credit amount transfered to the to
127 -- X_Date_Created The date on which the rows were
128 -- created
129 -- X_Created_By The user id of the person who created the
130 -- rows
131 --
132 PROCEDURE Update_Budget_Transfer_Row(
133 X_From_Rowid VARCHAR2,
134 X_To_Rowid VARCHAR2,
135 X_Status VARCHAR2,
136 X_Ledger_Id NUMBER,
137 X_User_Je_Source_Name VARCHAR2,
138 X_Group_Id NUMBER,
139 X_User_Je_Category_Name VARCHAR2,
140 X_Budget_Version_Id NUMBER,
141 X_Je_Batch_Name VARCHAR2,
142 X_Currency_Code VARCHAR2,
143 X_From_Code_Combination_Id NUMBER,
144 X_To_Code_Combination_Id NUMBER,
145 X_Combination_Number NUMBER,
146 X_Period_Name VARCHAR2,
147 X_From_Entered_Dr NUMBER,
148 X_From_Entered_Cr NUMBER,
149 X_To_Entered_Dr NUMBER,
150 X_To_Entered_Cr NUMBER);
151
152 --
153 -- Procedure
154 -- Lock_Budget_Transfer_Row
155 -- Purpose
156 -- Locks the two rows in gl_interface that correspond to a single
157 -- budget transfer.
158 -- History
159 -- 03-30-94 D. J. Ogg Created
160 -- Arguments
161 -- X_From_Rowid The Row ID of the from row
162 -- X_To_Rowid The Row ID of the to row
163 -- X_Status The status of the new rows
164 -- X_Ledger_Id The ledger ID of the rows
165 -- X_User_Je_Source_Name The source of the rows (Transfer)
166 -- X_Group_Id The group ID of the rows
167 -- X_User_Je_Category_Name The category of the rows (Budget)
168 -- X_Budget_Version_Id The budget containing the transfered amts
169 -- X_Je_Batch_Name The batch name of the rows
170 -- X_Currency_Code The currency of the transfered amts
171 -- X_From_Code_Combination_Id The code combination of the from row
172 -- X_To_Code_Combination_Id The code combination of the to row
173 -- X_Combination_Number The ID indicating the group of transfers
174 -- containing the row
175 -- X_Period_Name The period of the transfer
176 -- X_From_Entered_Dr The Debit amount transfered from the from
177 -- X_From_Entered_Cr The Credit amount transfered from the from
178 -- X_To_Entered_Dr The Debit amount transfered from the from
179 -- X_To_Entered_Cr The Credit amount transfered from the from
180 --
181 PROCEDURE Lock_Budget_Transfer_Row(
182 X_From_Rowid VARCHAR2,
183 X_To_Rowid VARCHAR2,
184 X_Status VARCHAR2,
185 X_Ledger_Id NUMBER,
186 X_User_Je_Source_Name VARCHAR2,
187 X_Group_Id NUMBER,
188 X_User_Je_Category_Name VARCHAR2,
189 X_Budget_Version_Id NUMBER,
190 X_Je_Batch_Name VARCHAR2,
191 X_Currency_Code VARCHAR2,
192 X_From_Code_Combination_Id NUMBER,
193 X_To_Code_Combination_Id NUMBER,
194 X_Combination_Number NUMBER,
195 X_Period_Name VARCHAR2,
196 X_From_Entered_Dr NUMBER,
197 X_From_Entered_Cr NUMBER,
198 X_To_Entered_Dr NUMBER,
199 X_To_Entered_Cr NUMBER);
200
201 --
202 -- Procedure
203 -- Delete_Budget_Transfer_Row
204 -- Purpose
205 -- Deletes the two rows from gl_interface that correspond to a single
206 -- budget transfer.
207 -- History
208 -- 03-30-94 D. J. Ogg Created
209 -- Arguments
210 -- X_From_Rowid The Row ID of the from row
211 -- X_To_Rowid The Row ID of the to row
212 --
213 PROCEDURE Delete_Budget_Transfer_Row(
214 X_From_Rowid VARCHAR2,
215 X_To_Rowid VARCHAR2);
216
217 --
218 -- Procedure
219 -- delete_rows
220 -- Purpose
221 -- Deletes all of the journal import rows with this source,
222 -- group id, and batch id.
223 -- History
224 -- 06-08-94 D. J. Ogg Created
225 -- Arguments
226 -- x_ledger_id Gives the ledger ID
227 -- x_user_je_source_name The translated source name
228 -- x_group_id The group id to check
229 -- x_je_batch_id The batch id to delete
230 -- Example
231 -- gl_interface_pkg.delete_rows(2, 'Transfer', 5);
232 PROCEDURE delete_rows(x_ledger_id NUMBER,
233 x_user_je_source_name VARCHAR2,
234 x_group_id NUMBER DEFAULT NULL,
235 x_je_batch_id NUMBER DEFAULT NULL);
236
237 --
238 -- Procedure
239 -- exists_data
240 -- Purpose
241 -- Returns TRUE if there are rows in gl_interface with this
242 -- ledger id, user source name, and group id
243 -- History
244 -- 06-08-94 D. J. Ogg Created
245 -- Arguments
246 -- x_ledger_id Gives the ledger ID
247 -- x_user_je_source_name The translated source name
248 -- x_group_id The group id to check
249 -- Example
250 -- if (gl_interface_pkg.exists_data(2, 'Transfer', 5)) then
251 FUNCTION exists_data(x_ledger_id NUMBER,
252 x_user_je_source_name VARCHAR2,
253 x_group_id NUMBER DEFAULT NULL)
254 RETURN BOOLEAN;
255
256 procedure LOCK_ROW (
257 X_ROWID in VARCHAR2,
258 X_ITABLE in VARCHAR2,
259 X_STATUS in VARCHAR2,
260 X_LEDGER_ID in NUMBER,
261 X_ACCOUNTING_DATE in DATE,
262 X_CURRENCY_CODE in VARCHAR2,
263 X_DATE_CREATED in DATE,
264 X_CREATED_BY in NUMBER,
265 X_ACTUAL_FLAG in VARCHAR2,
266 X_USER_JE_CATEGORY_NAME in VARCHAR2,
267 X_USER_JE_SOURCE_NAME in VARCHAR2,
268 X_CURRENCY_CONVERSION_DATE in DATE,
269 X_ENCUMBRANCE_TYPE_ID in NUMBER,
270 X_BUDGET_VERSION_ID in NUMBER,
271 X_USER_CURRENCY_CONV_TYPE in VARCHAR2,
272 X_CURRENCY_CONVERSION_RATE in NUMBER,
273 X_AVERAGE_JOURNAL_FLAG in VARCHAR2,
274 X_SEGMENT1 in VARCHAR2,
275 X_SEGMENT2 in VARCHAR2,
276 X_SEGMENT3 in VARCHAR2,
277 X_SEGMENT4 in VARCHAR2,
278 X_SEGMENT5 in VARCHAR2,
279 X_SEGMENT6 in VARCHAR2,
280 X_SEGMENT7 in VARCHAR2,
281 X_SEGMENT8 in VARCHAR2,
282 X_SEGMENT9 in VARCHAR2,
283 X_SEGMENT10 in VARCHAR2,
284 X_SEGMENT11 in VARCHAR2,
285 X_SEGMENT12 in VARCHAR2,
286 X_SEGMENT13 in VARCHAR2,
287 X_SEGMENT14 in VARCHAR2,
288 X_SEGMENT15 in VARCHAR2,
289 X_SEGMENT16 in VARCHAR2,
290 X_SEGMENT17 in VARCHAR2,
291 X_SEGMENT18 in VARCHAR2,
292 X_SEGMENT19 in VARCHAR2,
293 X_SEGMENT20 in VARCHAR2,
294 X_SEGMENT21 in VARCHAR2,
295 X_SEGMENT22 in VARCHAR2,
296 X_SEGMENT23 in VARCHAR2,
297 X_SEGMENT24 in VARCHAR2,
298 X_SEGMENT25 in VARCHAR2,
299 X_SEGMENT26 in VARCHAR2,
300 X_SEGMENT27 in VARCHAR2,
301 X_SEGMENT28 in VARCHAR2,
302 X_SEGMENT29 in VARCHAR2,
303 X_SEGMENT30 in VARCHAR2,
304 X_ENTERED_DR in NUMBER,
305 X_ENTERED_CR in NUMBER,
306 X_ACCOUNTED_DR in NUMBER,
307 X_ACCOUNTED_CR in NUMBER,
308 X_REFERENCE1 in VARCHAR2,
309 X_REFERENCE2 in VARCHAR2,
310 X_REFERENCE3 in VARCHAR2,
311 X_REFERENCE4 in VARCHAR2,
312 X_REFERENCE5 in VARCHAR2,
313 X_REFERENCE6 in VARCHAR2,
314 X_REFERENCE7 in VARCHAR2,
315 X_REFERENCE8 in VARCHAR2,
316 X_REFERENCE9 in VARCHAR2,
317 X_REFERENCE10 in VARCHAR2,
318 X_REFERENCE11 in VARCHAR2,
319 X_REFERENCE12 in VARCHAR2,
320 X_REFERENCE13 in VARCHAR2,
321 X_REFERENCE14 in VARCHAR2,
322 X_REFERENCE15 in VARCHAR2,
323 X_REFERENCE16 in VARCHAR2,
324 X_REFERENCE17 in VARCHAR2,
325 X_REFERENCE18 in VARCHAR2,
326 X_REFERENCE19 in VARCHAR2,
327 X_REFERENCE20 in VARCHAR2,
328 X_REFERENCE21 in VARCHAR2,
329 X_REFERENCE22 in VARCHAR2,
330 X_REFERENCE23 in VARCHAR2,
334 X_REFERENCE27 in VARCHAR2,
331 X_REFERENCE24 in VARCHAR2,
332 X_REFERENCE25 in VARCHAR2,
333 X_REFERENCE26 in VARCHAR2,
335 X_REFERENCE28 in VARCHAR2,
336 X_REFERENCE29 in VARCHAR2,
337 X_REFERENCE30 in VARCHAR2,
338 X_PERIOD_NAME in VARCHAR2,
339 X_CODE_COMBINATION_ID in NUMBER,
340 X_STAT_AMOUNT in NUMBER,
341 X_GROUP_ID in NUMBER,
342 X_REQUEST_ID in NUMBER,
343 X_SUBLEDGER_DOC_SEQUENCE_ID in NUMBER,
344 X_SUBLEDGER_DOC_SEQUENCE_VALUE in NUMBER,
345 X_ATTRIBUTE1 in VARCHAR2,
346 X_ATTRIBUTE2 in VARCHAR2,
347 X_ATTRIBUTE3 in VARCHAR2,
348 X_ATTRIBUTE4 in VARCHAR2,
349 X_ATTRIBUTE5 in VARCHAR2,
350 X_ATTRIBUTE6 in VARCHAR2,
351 X_ATTRIBUTE7 in VARCHAR2,
352 X_ATTRIBUTE8 in VARCHAR2,
353 X_ATTRIBUTE9 in VARCHAR2,
354 X_ATTRIBUTE10 in VARCHAR2,
355 X_ATTRIBUTE11 in VARCHAR2,
356 X_ATTRIBUTE12 in VARCHAR2,
357 X_ATTRIBUTE13 in VARCHAR2,
358 X_ATTRIBUTE14 in VARCHAR2,
359 X_ATTRIBUTE15 in VARCHAR2,
360 X_ATTRIBUTE16 in VARCHAR2,
361 X_ATTRIBUTE17 in VARCHAR2,
362 X_ATTRIBUTE18 in VARCHAR2,
363 X_ATTRIBUTE19 in VARCHAR2,
364 X_ATTRIBUTE20 in VARCHAR2,
365 X_CONTEXT in VARCHAR2,
366 X_CONTEXT2 in VARCHAR2,
367 X_INVOICE_DATE in DATE,
368 X_TAX_CODE in VARCHAR2,
369 X_INVOICE_IDENTIFIER in VARCHAR2,
370 X_INVOICE_AMOUNT in NUMBER,
371 X_CONTEXT3 in VARCHAR2,
372 X_USSGL_TRANSACTION_CODE in VARCHAR2,
373 X_JGZZ_RECON_REF in VARCHAR2,
374 X_ORIGINATING_BAL_SEG_VALUE in VARCHAR2,
375 X_GL_SL_LINK_ID in NUMBER,
376 X_GL_SL_LINK_TABLE in VARCHAR2
377 );
378
379 procedure UPDATE_ROW (
380 X_ROWID in VARCHAR2,
381 X_ITABLE in VARCHAR2,
382 X_STATUS in VARCHAR2,
383 X_LEDGER_ID in NUMBER,
384 X_ACCOUNTING_DATE in DATE,
385 X_CURRENCY_CODE in VARCHAR2,
386 X_DATE_CREATED in DATE,
387 X_CREATED_BY in NUMBER,
388 X_ACTUAL_FLAG in VARCHAR2,
389 X_USER_JE_CATEGORY_NAME in VARCHAR2,
390 X_USER_JE_SOURCE_NAME in VARCHAR2,
391 X_CURRENCY_CONVERSION_DATE in DATE,
392 X_ENCUMBRANCE_TYPE_ID in NUMBER,
393 X_BUDGET_VERSION_ID in NUMBER,
394 X_USER_CURRENCY_CONV_TYPE in VARCHAR2,
395 X_CURRENCY_CONVERSION_RATE in NUMBER,
396 X_AVERAGE_JOURNAL_FLAG in VARCHAR2,
397 X_SEGMENT1 in VARCHAR2,
398 X_SEGMENT2 in VARCHAR2,
399 X_SEGMENT3 in VARCHAR2,
400 X_SEGMENT4 in VARCHAR2,
401 X_SEGMENT5 in VARCHAR2,
402 X_SEGMENT6 in VARCHAR2,
403 X_SEGMENT7 in VARCHAR2,
404 X_SEGMENT8 in VARCHAR2,
405 X_SEGMENT9 in VARCHAR2,
406 X_SEGMENT10 in VARCHAR2,
407 X_SEGMENT11 in VARCHAR2,
408 X_SEGMENT12 in VARCHAR2,
409 X_SEGMENT13 in VARCHAR2,
410 X_SEGMENT14 in VARCHAR2,
411 X_SEGMENT15 in VARCHAR2,
412 X_SEGMENT16 in VARCHAR2,
413 X_SEGMENT17 in VARCHAR2,
414 X_SEGMENT18 in VARCHAR2,
415 X_SEGMENT19 in VARCHAR2,
416 X_SEGMENT20 in VARCHAR2,
417 X_SEGMENT21 in VARCHAR2,
418 X_SEGMENT22 in VARCHAR2,
419 X_SEGMENT23 in VARCHAR2,
420 X_SEGMENT24 in VARCHAR2,
421 X_SEGMENT25 in VARCHAR2,
422 X_SEGMENT26 in VARCHAR2,
423 X_SEGMENT27 in VARCHAR2,
424 X_SEGMENT28 in VARCHAR2,
425 X_SEGMENT29 in VARCHAR2,
426 X_SEGMENT30 in VARCHAR2,
427 X_ENTERED_DR in NUMBER,
428 X_ENTERED_CR in NUMBER,
429 X_ACCOUNTED_DR in NUMBER,
430 X_ACCOUNTED_CR in NUMBER,
431 X_REFERENCE1 in VARCHAR2,
432 X_REFERENCE2 in VARCHAR2,
433 X_REFERENCE3 in VARCHAR2,
434 X_REFERENCE4 in VARCHAR2,
435 X_REFERENCE5 in VARCHAR2,
436 X_REFERENCE6 in VARCHAR2,
437 X_REFERENCE7 in VARCHAR2,
438 X_REFERENCE8 in VARCHAR2,
439 X_REFERENCE9 in VARCHAR2,
440 X_REFERENCE10 in VARCHAR2,
441 X_REFERENCE11 in VARCHAR2,
442 X_REFERENCE12 in VARCHAR2,
443 X_REFERENCE13 in VARCHAR2,
444 X_REFERENCE14 in VARCHAR2,
445 X_REFERENCE15 in VARCHAR2,
446 X_REFERENCE16 in VARCHAR2,
447 X_REFERENCE17 in VARCHAR2,
448 X_REFERENCE18 in VARCHAR2,
449 X_REFERENCE19 in VARCHAR2,
450 X_REFERENCE20 in VARCHAR2,
451 X_REFERENCE21 in VARCHAR2,
452 X_REFERENCE22 in VARCHAR2,
453 X_REFERENCE23 in VARCHAR2,
454 X_REFERENCE24 in VARCHAR2,
455 X_REFERENCE25 in VARCHAR2,
456 X_REFERENCE26 in VARCHAR2,
457 X_REFERENCE27 in VARCHAR2,
458 X_REFERENCE28 in VARCHAR2,
459 X_REFERENCE29 in VARCHAR2,
460 X_REFERENCE30 in VARCHAR2,
461 X_PERIOD_NAME in VARCHAR2,
462 X_CODE_COMBINATION_ID in NUMBER,
463 X_STAT_AMOUNT in NUMBER,
464 X_GROUP_ID in NUMBER,
465 X_REQUEST_ID in NUMBER,
466 X_SUBLEDGER_DOC_SEQUENCE_ID in NUMBER,
467 X_SUBLEDGER_DOC_SEQUENCE_VALUE in NUMBER,
468 X_ATTRIBUTE1 in VARCHAR2,
469 X_ATTRIBUTE2 in VARCHAR2,
470 X_ATTRIBUTE3 in VARCHAR2,
471 X_ATTRIBUTE4 in VARCHAR2,
472 X_ATTRIBUTE5 in VARCHAR2,
473 X_ATTRIBUTE6 in VARCHAR2,
474 X_ATTRIBUTE7 in VARCHAR2,
475 X_ATTRIBUTE8 in VARCHAR2,
476 X_ATTRIBUTE9 in VARCHAR2,
477 X_ATTRIBUTE10 in VARCHAR2,
478 X_ATTRIBUTE11 in VARCHAR2,
479 X_ATTRIBUTE12 in VARCHAR2,
480 X_ATTRIBUTE13 in VARCHAR2,
481 X_ATTRIBUTE14 in VARCHAR2,
482 X_ATTRIBUTE15 in VARCHAR2,
483 X_ATTRIBUTE16 in VARCHAR2,
484 X_ATTRIBUTE17 in VARCHAR2,
485 X_ATTRIBUTE18 in VARCHAR2,
486 X_ATTRIBUTE19 in VARCHAR2,
487 X_ATTRIBUTE20 in VARCHAR2,
488 X_CONTEXT in VARCHAR2,
489 X_CONTEXT2 in VARCHAR2,
490 X_INVOICE_DATE in DATE,
491 X_TAX_CODE in VARCHAR2,
492 X_INVOICE_IDENTIFIER in VARCHAR2,
493 X_INVOICE_AMOUNT in NUMBER,
494 X_CONTEXT3 in VARCHAR2,
495 X_USSGL_TRANSACTION_CODE in VARCHAR2,
496 X_JGZZ_RECON_REF in VARCHAR2,
497 X_ORIGINATING_BAL_SEG_VALUE in VARCHAR2,
498 X_GL_SL_LINK_ID in NUMBER,
499 X_GL_SL_LINK_TABLE in VARCHAR2
500 );
501
502 procedure DELETE_ROW (
503 X_ROWID in VARCHAR2,
504 X_ITABLE in VARCHAR2
505 );
506
507 END gl_interface_pkg;