1 PACKAGE xla_reverse_events_pvt_pkg AUTHID CURRENT_USER AS
2 -- $Header: xlavrevevt.pkh 120.2 2011/03/11 13:33:26 vgopiset noship $
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | FILENAME |
9 | xlavrevevt.pkh |
10 | |
11 | PACKAGE NAME |
12 | xla_reverse_events_pvt_pkg |
13 | |
14 | DESCRIPTION |
15 | This is a XLA private package, which contains all the APIs |
16 | required for processing BULK Reversal of ACCOUNTED Events. |
17 | |
18 | |
19 | HISTORY |
20 | VGOPISET 10-NOV-2010 Created. |
21 | VGOPISET 08-MAR-2011 Changes for Batch wise processing even for|
22 | Delete_Incomplete_Reversal |
23 +===========================================================================*/
24
25 -------------------------------------------------------------------------------
26 -- Event Reversal Accounting routines
27 -------------------------------------------------------------------------------
28
29 --+==========================================================================+
30 --| PUBLIC PROCEDURE |
31 --| Create_Reversal_Accounting |
32 --| Would need the following parameters as input |
33 --| i)P_APPLICATION_ID : Application ID of the subledger from which |
34 --| accounting needs to be Reversed. |
35 --| ii)P_BATCH_CODE : Batch Code of List of the Events for which |
36 --| accounting needs to be Reversed. |
37 --| iii)P_LEDGER_ID : Ledger ID of the Transaction to which Events |
38 --| belongs to |
39 --| iv)P_BUDGETARY_CONTROL_FLAG: Default Value of "N". This determines |
40 --| whether Encumbrance Accounting is required. |
41 --| v)p_gl_transfer_flag : Pass "N" when accounting not be transferred |
42 --| to General Ledger."Y" when accounting to be|
43 --| eligible for Transfer to GL, via "Transfer |
44 --| Journal Entries to GL" concurrent program |
45 --| vi)P_BATCH_COMMIT_SIZE: Minimum Batch Commit Size is 2000. Pass value |
46 --| when more no of events need to be processed |
47 --| vii)x_return_status : S is SUCCESS , E is Error , U is Unexpected |
48 --| Error |
49 --+==========================================================================+
50 PROCEDURE create_reversal_accounting( p_application_id IN NUMBER
51 , p_batch_code IN VARCHAR2
52 , p_ledger_id IN NUMBER
53 , p_budgetary_control_flag IN VARCHAR2 DEFAULT 'N'
54 , p_gl_transfer_flag IN VARCHAR2 DEFAULT 'Y'
55 , p_batch_commit_size IN NUMBER
56 , x_return_status OUT NOCOPY VARCHAR2
57 ) ;
58
59 --+==========================================================================+
60 --| PUBLIC PROCEDURE |
61 --| Delete_Incomplete_Reversal |
62 --| Would need the following parameters as input |
63 --| i)P_APPLICATION_ID : Application ID of the subledger from which |
64 --| accounting needs to be Reversed. |
65 --| ii)P_BATCH_CODE : Batch Code of List of the Events for which |
66 --| accounting needs to be Reversed. |
67 --| iii)P_LEDGER_ID : Ledger ID of the Transaction to which Events |
68 --| belongs to |
69 --| iv)P_DELETE_FLAG : DEFAULT of "N". Determines whether ERRORED rows|
70 --| need to be DELETE from the INTERFACE Table after|
71 --| the invalid accounting is deleted. |
72 --| v)P_BATCH_COMMIT_SIZE: Minimum Batch Commit Size is 2000. Pass value |
73 --| when more no of events need to be processed |
74 --| vi)x_return_status : S is SUCCESS , E is Error , U is Unexpected |
75 --| Error |
76 --+==========================================================================+
77 PROCEDURE delete_incomplete_reversal( p_application_id IN NUMBER
78 , p_batch_code IN VARCHAR2
79 , p_ledger_id IN NUMBER
80 , p_delete_flag IN VARCHAR2 DEFAULT 'N'
81 , p_batch_commit_size IN NUMBER
82 , x_return_status OUT NOCOPY VARCHAR2
83 ) ;
84
85
86 END xla_reverse_events_pvt_pkg;