[Home] [Help]
PACKAGE: APPS.GL_JE_HEADERS_PKG
Source
1 PACKAGE GL_JE_HEADERS_PKG as
2 /* $Header: glijhrvs.pls 120.10 2005/05/05 01:10:47 kvora ship $ */
3
4 --
5 -- Package
6 -- GL_JE_HEADERS_PKG
7 -- Purpose
8 -- To implement various data checking needed for the
9 -- gl_je_headers table
10 -- History
11 -- 12-27-93 S. J. Mueller Created
12 -- 01-11-94 D J Ogg Added routines check_unique, get_unique_id,
13 -- and default_reversal_period
14 --
15
16 --
17 -- Procedure
18 -- check_unique
19 -- Purpose
20 -- Checks to make sure that the name of the header
21 -- is unique within the batch.
22 -- History
23 -- 01-11-93 D. J. Ogg Created
24 -- Arguments
25 -- batch_id The ID of the batch
26 -- header_name The name of the header
27 -- row_id The row ID
28 -- Example
29 -- gl_je_headers_pkg.check_unique(2002, 'Testing', 'ABD02334');
30 -- Notes
31 --
32 PROCEDURE check_unique(batch_id NUMBER, header_name VARCHAR2,
33 row_id VARCHAR2);
34
35 --
36 -- Procedure
37 -- get_unique_id
38 -- Purpose
39 -- Gets a unique header id
40 -- History
41 -- 12-30-93 D. J. Ogg Created
42 -- Arguments
43 -- none
44 -- Example
45 -- bid := gl_je_headers_pkg.get_unique_id;
46 -- Notes
47 --
48 FUNCTION get_unique_id RETURN NUMBER;
49
50 --
51 -- Procedure
52 -- delete_headers
53 -- Purpose
54 -- Deletes all of the headers that belong to a given MassAllocation
55 -- batch.
56 -- History
57 -- 01-18-93 D. J. Ogg Created
58 -- Arguments
59 -- batch_id The ID of the MassAllocation batch
60 -- Example
61 -- gl_je_headers_pkg.delete_headers(1002);
62 -- Notes
63 --
64 PROCEDURE delete_headers(batch_id NUMBER);
65
66 --
67 -- Procedure
68 -- change_effective_date
69 -- Purpose
70 -- Changes the effective date for all of the headers within the batch
71 -- History
72 -- 30-MAY-1996 D J Ogg Created
73 -- Arguments
74 -- batch_id The ID of the batch
75 -- new_effective_date The new effective date
76 -- Example
77 -- gl_je_headers_pkg.change_effective_date(1002, '01-JAN-1992');
78 -- Notes
79 --
80 PROCEDURE change_effective_date(batch_id NUMBER,
81 new_effective_date DATE);
82
83 --
84 -- Procedure
85 -- calculate_totals
86 -- Purpose
87 -- Retotals the running totals for a batch
88 -- History
89 -- 01-24-94 D. J. Ogg Created
90 -- Arguments
91 -- batch_id The ID of the batch
92 -- running_total_dr The running total of debits
93 -- running_total_cr The running total of credits
94 -- running_total_accounted_dr The running total of accounted debits
95 -- running_total_accounted_cr The running total of accounted credits
96 -- Example
97 -- gl_je_lines_pkg.calculate_totals(1002, run_dr, run_cr, run_accdr,
98 -- run_acccr);
99 -- Notes
100 --
101 PROCEDURE calculate_totals( batch_id NUMBER,
102 running_total_dr IN OUT NOCOPY NUMBER,
103 running_total_cr IN OUT NOCOPY NUMBER,
104 running_total_accounted_dr IN OUT NOCOPY NUMBER,
105 running_total_accounted_cr IN OUT NOCOPY NUMBER
106 );
107
108 --
109 -- Procedure
110 -- change_period
111 -- Purpose
112 -- Runs in two modes. When called with no header ID, it
113 -- converts all of the journals within the current
114 -- batch to the new period. When called with a header
115 -- ID, it assumes the change period process failed
116 -- due to a bad journal, and you have gotten the
117 -- correct journal information from the customer.
118 -- It processes the given journal, using the given
119 -- conversion information, and all of the journals
120 -- after that journal. It assumes that all of the
121 -- journals before that journal have already been
122 -- processed.
123 -- History
124 -- 02-07-94 D. J. Ogg Created
125 -- Arguments
126 -- batch_id The ID of the batch whose period has changed.
127 -- period_name The new period name of the batch
128 -- effective_date The new effective date of the batch
129 -- user_id The ID of the user who changed the period
130 -- login_id The Login ID of the user who changed the period
131 -- header_id If provided, the ID of a bad journal
132 -- currency_code If provided, the override currency code for the
133 -- erroneous journal
134 -- conversion_date If provided, the override conversion date for
135 -- the erroneous journal
136 -- conversion_type If provided, the override conversion type for
137 -- the erroneous journal
138 -- conversion_rate If provided, the override conversion rate for
139 -- the erroneous journal
140 -- Returns
141 -- The ID of the next bad header, if it finds one.
142 -- Example
143 -- hid := gl_je_headers.change_period(2, 'USD', 'Test batch', 'JAN-91',
144 -- '15-JAN-91');
145 -- Notes
146 --
147 FUNCTION change_period(batch_id NUMBER,
148 period_name VARCHAR2,
149 effective_date DATE,
150 user_id NUMBER,
151 login_id NUMBER,
152 header_id NUMBER DEFAULT null,
153 currency_code VARCHAR2 DEFAULT null,
154 conversion_date DATE DEFAULT null,
155 conversion_type VARCHAR2 DEFAULT null,
156 conversion_rate NUMBER DEFAULT null
157 ) RETURN NUMBER;
158
159 --
160 -- Procedure
161 -- max_effective_date
162 -- Purpose
163 -- Returns the maximum effective date of an unreversed journal in
164 -- this batch
165 -- History
166 -- 16-FEB-96 D. J. Ogg Created
167 -- Arguments
168 -- batch_id The ID of the batch whose journals are to be
169 -- checked.
170 -- Example
171 -- eff_date := gl_je_headers.max_effective_date(1002)
172 -- Notes
173 --
174 FUNCTION max_effective_date(batch_id NUMBER) RETURN DATE;
175
176 --
177 -- Procedure
178 -- needs_tax
179 -- Purpose
180 -- Returns TRUE if some journal in the batch needs to be
181 -- taxed and FALSE otherwise
182 -- History
183 -- 16-FEB-96 D. J. Ogg Created
184 -- Arguments
185 -- batch_id The ID of the batch whose journals are to be
186 -- checked.
187 -- Example
188 -- IF(gl_je_headers.needs_tax(1002)) THEN
189 -- Notes
190 --
191 FUNCTION needs_tax(batch_id NUMBER) RETURN BOOLEAN;
192
193 --
194 -- Procedure
195 -- has_seqnum
196 -- Purpose
197 -- Returns TRUE if some journal in the batch has a sequence number
198 -- and FALSE otherwise
199 -- History
200 -- 15-SEP-96 D. J. Ogg Created
201 -- Arguments
202 -- batch_id The ID of the batch whose journals are to be
203 -- checked.
204 -- Example
205 -- IF(gl_je_headers.has_seqnum(1002)) THEN
206 -- Notes
207 --
208 FUNCTION has_seqnum(batch_id NUMBER) RETURN BOOLEAN;
209
210 --
211 -- Procedure
212 -- populate_fields
213 -- Purpose
214 -- Gets all of the data necessary post-query
215 -- History
216 -- 29-NOV-94 D. J. Ogg Created
217 -- Arguments
218 -- set_of_books_id The set of books containing the journal
219 -- je_source_name Source name to find translation for
220 -- user_je_source_name Translation of source name
221 -- frozen_source Are we allowed to change batches from this
222 -- source?
223 -- je_category_name Category name to find translation for
224 -- user_je_category_name Translation of category name
225 -- reversal_option_code S - Switch Dr/Cr, C - Change Sign
226 -- period_name Period name to get year, number, start and
227 -- end date for
228 -- start_date Start date of period
229 -- end_date End date of period
230 -- period_year Year of period
231 -- period_num Number of period
232 -- currency_conversion_type Conversion type to find translation for
233 -- user_currency_conv_type Translation of conversion type
234 -- budget_version_id Id of budget to get name of
235 -- budget_name Name of budget
236 -- encumbrance_type_id Id of encumbrance to get name of
237 -- encumbrance_type Name of encumbrance
238 -- accrual_rev_period_name Reversal Period name to get year, number,
239 -- start and end date for
240 -- accrual_rev_start_date Start date of reversal period
241 -- accrual_rev_end_date End date of reversal period
242 -- posting_acct_seq_version_id Posting sequence version information
243 -- posting_acct_seq_name Posting sequence name
244 -- close_acct_seq_version_id Posting sequence version information
245 -- close_acct_seq_name Posting sequence name
246 -- error_name Resulting error, if any
247 -- Notes
248 --
249 PROCEDURE populate_fields(ledger_id NUMBER,
250 ledger_name IN OUT NOCOPY VARCHAR2,
251 je_source_name VARCHAR2,
252 user_je_source_name IN OUT NOCOPY VARCHAR2,
253 frozen_source_flag IN OUT NOCOPY VARCHAR2,
254 je_category_name VARCHAR2,
255 user_je_category_name IN OUT NOCOPY VARCHAR2,
256 period_name VARCHAR2,
257 start_date IN OUT NOCOPY DATE,
258 end_date IN OUT NOCOPY DATE,
259 period_year IN OUT NOCOPY NUMBER,
260 period_num IN OUT NOCOPY NUMBER,
261 currency_conversion_type VARCHAR2,
262 user_currency_conv_type IN OUT NOCOPY VARCHAR2,
263 budget_version_id NUMBER,
264 budget_name IN OUT NOCOPY VARCHAR2,
265 encumbrance_type_id NUMBER,
266 encumbrance_type IN OUT NOCOPY VARCHAR2,
267 accrual_rev_period_name VARCHAR2,
268 accrual_rev_start_date IN OUT NOCOPY DATE,
269 accrual_rev_end_date IN OUT NOCOPY DATE,
270 posting_acct_seq_version_id NUMBER,
271 posting_acct_seq_name IN OUT NOCOPY VARCHAR2,
272 close_acct_seq_version_id NUMBER,
273 close_acct_seq_name IN OUT NOCOPY VARCHAR2,
274 error_name IN OUT NOCOPY VARCHAR2);
275
276 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
277 X_Je_Header_Id IN OUT NOCOPY NUMBER,
278 X_Last_Update_Date DATE,
279 X_Last_Updated_By NUMBER,
280 X_Ledger_Id NUMBER,
281 X_Je_Category VARCHAR2,
282 X_Je_Source VARCHAR2,
283 X_Period_Name VARCHAR2,
284 X_Name VARCHAR2,
285 X_Currency_Code VARCHAR2,
286 X_Status VARCHAR2,
287 X_Date_Created DATE,
288 X_Accrual_Rev_Flag VARCHAR2,
289 X_Multi_Bal_Seg_Flag VARCHAR2,
290 X_Actual_Flag VARCHAR2,
291 X_Default_Effective_Date DATE,
292 X_Conversion_Flag VARCHAR2,
293 X_Creation_Date DATE,
294 X_Created_By NUMBER,
295 X_Last_Update_Login NUMBER,
296 X_Encumbrance_Type_Id NUMBER,
297 X_Budget_Version_Id NUMBER,
298 X_Balanced_Je_Flag VARCHAR2,
299 X_Balancing_Segment_Value VARCHAR2,
300 X_Je_Batch_Id IN OUT NOCOPY NUMBER,
301 X_From_Recurring_Header_Id NUMBER,
302 X_Unique_Date VARCHAR2,
303 X_Earliest_Postable_Date DATE,
304 X_Posted_Date DATE,
305 X_Accrual_Rev_Effective_Date DATE,
306 X_Accrual_Rev_Period_Name VARCHAR2,
307 X_Accrual_Rev_Status VARCHAR2,
308 X_Accrual_Rev_Je_Header_Id NUMBER,
309 X_Accrual_Rev_Change_Sign_Flag VARCHAR2,
310 X_Description VARCHAR2,
311 X_Tax_Status_Code VARCHAR2,
312 X_Control_Total NUMBER,
313 X_Running_Total_Dr NUMBER,
314 X_Running_Total_Cr NUMBER,
315 X_Running_Total_Accounted_Dr NUMBER,
316 X_Running_Total_Accounted_Cr NUMBER,
317 X_Currency_Conversion_Rate NUMBER,
318 X_Currency_Conversion_Type VARCHAR2,
319 X_Currency_Conversion_Date DATE,
323 X_Attribute2 VARCHAR2,
320 X_External_Reference VARCHAR2,
321 X_Originating_Bal_Seg_Value VARCHAR2,
322 X_Attribute1 VARCHAR2,
324 X_Attribute3 VARCHAR2,
325 X_Attribute4 VARCHAR2,
326 X_Attribute5 VARCHAR2,
327 X_Attribute6 VARCHAR2,
328 X_Attribute7 VARCHAR2,
329 X_Attribute8 VARCHAR2,
330 X_Attribute9 VARCHAR2,
331 X_Attribute10 VARCHAR2,
332 X_Context VARCHAR2,
333 X_Ussgl_Transaction_Code VARCHAR2,
334 X_Context2 VARCHAR2,
335 X_Doc_Sequence_Id NUMBER,
336 X_Doc_Sequence_Value NUMBER,
337 X_Header_Mode VARCHAR2,
338 X_Batch_Row_Id IN OUT NOCOPY VARCHAR2,
339 X_Batch_Name VARCHAR2,
340 X_Chart_of_Accounts_ID NUMBER,
341 X_Period_Set_Name VARCHAR2,
342 X_Accounted_Period_Type VARCHAR2,
343 X_Batch_Status VARCHAR2,
344 X_Status_Verified VARCHAR2,
345 X_Batch_Default_Effective_Date DATE,
346 X_Batch_Posted_Date DATE,
347 X_Batch_Date_Created DATE,
348 X_Budgetary_Control_Status VARCHAR2,
349 X_Approval_Status_Code VARCHAR2,
350 X_Batch_Control_Total IN OUT NOCOPY NUMBER,
351 X_Batch_Running_Total_Dr IN OUT NOCOPY NUMBER,
352 X_Batch_Running_Total_Cr IN OUT NOCOPY NUMBER,
353 X_Average_Journal_Flag VARCHAR2,
354 X_Org_Id NUMBER,
355 X_Posting_Run_Id NUMBER,
356 X_Request_Id NUMBER,
357 X_Packet_Id NUMBER,
358 X_Unreservation_Packet_Id NUMBER,
359 X_Jgzz_Recon_Context VARCHAR2,
360 X_Jgzz_Recon_Ref VARCHAR2,
361 X_Reference_Date DATE
362 );
363
364 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
365 X_Je_Header_Id NUMBER,
366 X_Ledger_Id NUMBER,
367 X_Je_Category VARCHAR2,
368 X_Je_Source VARCHAR2,
369 X_Period_Name VARCHAR2,
370 X_Name VARCHAR2,
371 X_Currency_Code VARCHAR2,
372 X_Status VARCHAR2,
373 X_Date_Created DATE,
374 X_Accrual_Rev_Flag VARCHAR2,
375 X_Multi_Bal_Seg_Flag VARCHAR2,
376 X_Actual_Flag VARCHAR2,
377 X_Default_Effective_Date DATE,
378 X_Conversion_Flag VARCHAR2,
379 X_Encumbrance_Type_Id NUMBER,
380 X_Budget_Version_Id NUMBER,
381 X_Balanced_Je_Flag VARCHAR2,
382 X_Balancing_Segment_Value VARCHAR2,
383 X_Je_Batch_Id NUMBER,
384 X_From_Recurring_Header_Id NUMBER,
385 X_Unique_Date VARCHAR2,
386 X_Earliest_Postable_Date DATE,
387 X_Posted_Date DATE,
388 X_Accrual_Rev_Effective_Date DATE,
389 X_Accrual_Rev_Period_Name VARCHAR2,
390 X_Accrual_Rev_Status VARCHAR2,
391 X_Accrual_Rev_Je_Header_Id NUMBER,
392 X_Accrual_Rev_Change_Sign_Flag VARCHAR2,
393 X_Description VARCHAR2,
394 X_Tax_Status_Code VARCHAR2,
395 X_Control_Total NUMBER,
396 X_Running_Total_Dr NUMBER,
397 X_Running_Total_Cr NUMBER,
398 X_Running_Total_Accounted_Dr NUMBER,
399 X_Running_Total_Accounted_Cr NUMBER,
400 X_Currency_Conversion_Rate NUMBER,
401 X_Currency_Conversion_Type VARCHAR2,
402 X_Currency_Conversion_Date DATE,
403 X_External_Reference VARCHAR2,
404 X_Attribute1 VARCHAR2,
405 X_Attribute2 VARCHAR2,
406 X_Attribute3 VARCHAR2,
407 X_Attribute4 VARCHAR2,
408 X_Attribute5 VARCHAR2,
412 X_Attribute9 VARCHAR2,
409 X_Attribute6 VARCHAR2,
410 X_Attribute7 VARCHAR2,
411 X_Attribute8 VARCHAR2,
413 X_Attribute10 VARCHAR2,
414 X_Context VARCHAR2,
415 X_Ussgl_Transaction_Code VARCHAR2,
416 X_Context2 VARCHAR2,
417 X_Doc_Sequence_Id NUMBER,
418 X_Doc_Sequence_Value NUMBER
419 );
420
421 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
422 X_Je_Header_Id NUMBER,
423 X_Ledger_Id NUMBER,
424 X_Je_Category VARCHAR2,
425 X_Je_Source VARCHAR2,
426 X_Period_Name VARCHAR2,
427 X_Name VARCHAR2,
428 X_Currency_Code VARCHAR2,
429 X_Status VARCHAR2,
430 X_Date_Created DATE,
431 X_Accrual_Rev_Flag VARCHAR2,
432 X_Multi_Bal_Seg_Flag VARCHAR2,
433 X_Actual_Flag VARCHAR2,
434 X_Default_Effective_Date DATE,
435 X_Conversion_Flag VARCHAR2,
436 X_Encumbrance_Type_Id NUMBER,
437 X_Budget_Version_Id NUMBER,
438 X_Balanced_Je_Flag VARCHAR2,
439 X_Balancing_Segment_Value VARCHAR2,
440 X_Je_Batch_Id NUMBER,
441 X_From_Recurring_Header_Id NUMBER,
442 X_Unique_Date VARCHAR2,
443 X_Earliest_Postable_Date DATE,
444 X_Posted_Date DATE,
445 X_Accrual_Rev_Effective_Date DATE,
446 X_Accrual_Rev_Period_Name VARCHAR2,
447 X_Accrual_Rev_Status VARCHAR2,
448 X_Accrual_Rev_Je_Header_Id NUMBER,
449 X_Accrual_Rev_Change_Sign_Flag VARCHAR2,
450 X_Description VARCHAR2,
451 X_Tax_Status_Code VARCHAR2,
452 X_Control_Total NUMBER,
453 X_Running_Total_Dr NUMBER,
454 X_Running_Total_Cr NUMBER,
455 X_Running_Total_Accounted_Dr NUMBER,
456 X_Running_Total_Accounted_Cr NUMBER,
457 X_Currency_Conversion_Rate NUMBER,
458 X_Currency_Conversion_Type VARCHAR2,
459 X_Currency_Conversion_Date DATE,
460 X_External_Reference VARCHAR2,
461 X_Originating_Bal_Seg_Value VARCHAR2,
462 X_Attribute1 VARCHAR2,
463 X_Attribute2 VARCHAR2,
464 X_Attribute3 VARCHAR2,
465 X_Attribute4 VARCHAR2,
466 X_Attribute5 VARCHAR2,
467 X_Attribute6 VARCHAR2,
468 X_Attribute7 VARCHAR2,
469 X_Attribute8 VARCHAR2,
470 X_Attribute9 VARCHAR2,
471 X_Attribute10 VARCHAR2,
472 X_Context VARCHAR2,
473 X_Ussgl_Transaction_Code VARCHAR2,
474 X_Context2 VARCHAR2,
475 X_Doc_Sequence_Id NUMBER,
476 X_Doc_Sequence_Value NUMBER,
477 X_Header_Mode VARCHAR2,
478 X_Batch_Row_Id VARCHAR2,
479 X_Batch_Name VARCHAR2,
480 X_Chart_of_Accounts_ID NUMBER,
481 X_Period_Set_Name VARCHAR2,
482 X_Accounted_Period_Type VARCHAR2,
483 X_Batch_Status VARCHAR2,
484 X_Status_Verified VARCHAR2,
485 X_Batch_Default_Effective_Date DATE,
486 X_Batch_Posted_Date DATE,
487 X_Batch_Date_Created DATE,
488 X_Budgetary_Control_Status VARCHAR2,
489 X_Approval_Status_Code VARCHAR2,
490 X_Batch_Control_Total NUMBER,
491 X_Batch_Running_Total_Dr NUMBER,
492 X_Batch_Running_Total_Cr NUMBER,
493 X_Average_Journal_Flag VARCHAR2,
494 X_Posting_Run_Id NUMBER,
495 X_Request_Id NUMBER,
496 X_Packet_Id NUMBER,
497 X_Unreservation_Packet_Id NUMBER,
498 X_Verify_Request_Completed VARCHAR2,
502 );
499 X_Jgzz_Recon_Context VARCHAR2,
500 X_Jgzz_Recon_Ref VARCHAR2,
501 X_Reference_Date DATE
503
504 PROCEDURE Update_Row(X_Rowid VARCHAR2,
505 X_Je_Header_Id NUMBER,
506 X_Last_Update_Date DATE,
507 X_Last_Updated_By NUMBER,
508 X_Ledger_Id NUMBER,
509 X_Je_Category VARCHAR2,
510 X_Je_Source VARCHAR2,
511 X_Period_Name VARCHAR2,
512 X_Name VARCHAR2,
513 X_Currency_Code VARCHAR2,
514 X_Status VARCHAR2,
515 X_Date_Created DATE,
516 X_Accrual_Rev_Flag VARCHAR2,
517 X_Multi_Bal_Seg_Flag VARCHAR2,
518 X_Actual_Flag VARCHAR2,
519 X_Default_Effective_Date DATE,
520 X_Conversion_Flag VARCHAR2,
521 X_Last_Update_Login NUMBER,
522 X_Encumbrance_Type_Id NUMBER,
523 X_Budget_Version_Id NUMBER,
524 X_Balanced_Je_Flag VARCHAR2,
525 X_Balancing_Segment_Value VARCHAR2,
526 X_Je_Batch_Id NUMBER,
527 X_From_Recurring_Header_Id NUMBER,
528 X_Unique_Date VARCHAR2,
529 X_Earliest_Postable_Date DATE,
530 X_Posted_Date DATE,
531 X_Accrual_Rev_Effective_Date DATE,
532 X_Accrual_Rev_Period_Name VARCHAR2,
533 X_Accrual_Rev_Status VARCHAR2,
534 X_Accrual_Rev_Je_Header_Id NUMBER,
535 X_Accrual_Rev_Change_Sign_Flag VARCHAR2,
536 X_Description VARCHAR2,
537 X_Tax_Status_Code VARCHAR2,
538 X_Control_Total NUMBER,
539 X_Running_Total_Dr NUMBER,
540 X_Running_Total_Cr NUMBER,
541 X_Running_Total_Accounted_Dr NUMBER,
542 X_Running_Total_Accounted_Cr NUMBER,
543 X_Currency_Conversion_Rate NUMBER,
544 X_Currency_Conversion_Type VARCHAR2,
545 X_Currency_Conversion_Date DATE,
546 X_External_Reference VARCHAR2,
547 X_Attribute1 VARCHAR2,
548 X_Attribute2 VARCHAR2,
549 X_Attribute3 VARCHAR2,
550 X_Attribute4 VARCHAR2,
551 X_Attribute5 VARCHAR2,
552 X_Attribute6 VARCHAR2,
553 X_Attribute7 VARCHAR2,
554 X_Attribute8 VARCHAR2,
555 X_Attribute9 VARCHAR2,
556 X_Attribute10 VARCHAR2,
557 X_Context VARCHAR2,
558 X_Ussgl_Transaction_Code VARCHAR2,
559 X_Context2 VARCHAR2,
560 X_Doc_Sequence_Id NUMBER,
561 X_Doc_Sequence_Value NUMBER);
562
563 PROCEDURE Update_Row(X_Rowid VARCHAR2,
564 X_Je_Header_Id NUMBER,
565 X_Last_Update_Date DATE,
566 X_Last_Updated_By NUMBER,
567 X_Ledger_Id NUMBER,
568 X_Je_Category VARCHAR2,
569 X_Je_Source VARCHAR2,
570 X_Period_Name VARCHAR2,
571 X_Name VARCHAR2,
572 X_Currency_Code VARCHAR2,
573 X_Status VARCHAR2,
574 X_Date_Created DATE,
575 X_Accrual_Rev_Flag VARCHAR2,
576 X_Multi_Bal_Seg_Flag VARCHAR2,
577 X_Actual_Flag VARCHAR2,
578 X_Default_Effective_Date DATE,
579 X_Conversion_Flag VARCHAR2,
580 X_Last_Update_Login NUMBER,
581 X_Encumbrance_Type_Id NUMBER,
582 X_Budget_Version_Id NUMBER,
583 X_Balanced_Je_Flag VARCHAR2,
587 X_Unique_Date VARCHAR2,
584 X_Balancing_Segment_Value VARCHAR2,
585 X_Je_Batch_Id NUMBER,
586 X_From_Recurring_Header_Id NUMBER,
588 X_Earliest_Postable_Date DATE,
589 X_Posted_Date DATE,
590 X_Accrual_Rev_Effective_Date DATE,
591 X_Accrual_Rev_Period_Name VARCHAR2,
592 X_Accrual_Rev_Status VARCHAR2,
593 X_Accrual_Rev_Je_Header_Id NUMBER,
594 X_Accrual_Rev_Change_Sign_Flag VARCHAR2,
595 X_Description VARCHAR2,
596 X_Tax_Status_Code VARCHAR2,
597 X_Control_Total NUMBER,
598 X_Running_Total_Dr NUMBER,
599 X_Running_Total_Cr NUMBER,
600 X_Running_Total_Accounted_Dr NUMBER,
601 X_Running_Total_Accounted_Cr NUMBER,
602 X_Currency_Conversion_Rate NUMBER,
603 X_Currency_Conversion_Type VARCHAR2,
604 X_Currency_Conversion_Date DATE,
605 X_External_Reference VARCHAR2,
606 X_Originating_Bal_Seg_Value VARCHAR2,
607 X_Attribute1 VARCHAR2,
608 X_Attribute2 VARCHAR2,
609 X_Attribute3 VARCHAR2,
610 X_Attribute4 VARCHAR2,
611 X_Attribute5 VARCHAR2,
612 X_Attribute6 VARCHAR2,
613 X_Attribute7 VARCHAR2,
614 X_Attribute8 VARCHAR2,
615 X_Attribute9 VARCHAR2,
616 X_Attribute10 VARCHAR2,
617 X_Context VARCHAR2,
618 X_Ussgl_Transaction_Code VARCHAR2,
619 X_Context2 VARCHAR2,
620 X_Doc_Sequence_Id NUMBER,
621 X_Doc_Sequence_Value NUMBER,
622 X_Effective_Date_Changed VARCHAR2,
623 X_Header_Mode VARCHAR2,
624 X_Batch_Row_Id VARCHAR2,
625 X_Batch_Name VARCHAR2,
626 X_Chart_of_Accounts_ID NUMBER,
627 X_Period_Set_Name VARCHAR2,
628 X_Accounted_Period_Type VARCHAR2,
629 X_Batch_Status VARCHAR2,
630 X_Status_Verified VARCHAR2,
631 X_Batch_Default_Effective_Date DATE,
632 X_Batch_Posted_Date DATE,
633 X_Batch_Date_Created DATE,
634 X_Budgetary_Control_Status VARCHAR2,
635 X_Approval_Status_Code IN OUT NOCOPY VARCHAR2,
636 X_Batch_Control_Total IN OUT NOCOPY NUMBER,
637 X_Batch_Running_Total_Dr IN OUT NOCOPY NUMBER,
638 X_Batch_Running_Total_Cr IN OUT NOCOPY NUMBER,
639 X_Average_Journal_Flag VARCHAR2,
640 X_Posting_Run_Id NUMBER,
641 X_Request_Id NUMBER,
642 X_Packet_Id NUMBER,
643 X_Unreservation_Packet_Id NUMBER,
644 Update_Effective_Date_Flag VARCHAR2,
645 Update_Approval_Stat_Flag VARCHAR2,
646 X_Jgzz_Recon_Context VARCHAR2,
647 X_Jgzz_Recon_Ref VARCHAR2,
648 X_Reference_Date DATE
649 );
650
651 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
652 X_Je_Header_Id NUMBER,
653 X_Header_Mode VARCHAR2,
654 X_Batch_Row_Id VARCHAR2,
655 X_Je_Batch_Id NUMBER,
656 X_Ledger_Id NUMBER,
657 X_Actual_Flag VARCHAR2,
658 X_Period_Name VARCHAR2,
659 X_Batch_Name VARCHAR2,
660 X_Chart_of_Accounts_ID NUMBER,
661 X_Period_Set_Name VARCHAR2,
662 X_Accounted_Period_Type VARCHAR2,
663 X_Batch_Status VARCHAR2,
664 X_Status_Verified VARCHAR2,
665 X_Batch_Default_Effective_Date DATE,
666 X_Batch_Posted_Date DATE,
667 X_Batch_Date_Created DATE,
668 X_Budgetary_Control_Status VARCHAR2,
669 X_Approval_Status_Code IN OUT NOCOPY VARCHAR2,
670 X_Batch_Control_Total IN OUT NOCOPY NUMBER,
671 X_Batch_Running_Total_Dr IN OUT NOCOPY NUMBER,
672 X_Batch_Running_Total_Cr IN OUT NOCOPY NUMBER,
673 X_Average_Journal_Flag VARCHAR2,
674 X_Posting_Run_Id NUMBER,
675 X_Request_Id NUMBER,
676 X_Packet_Id NUMBER,
677 X_Unreservation_Packet_Id NUMBER,
678 X_Last_Updated_By NUMBER,
679 X_Last_Update_Login NUMBER);
680
681 END GL_JE_HEADERS_PKG;