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