1 PACKAGE XLA_ACCOUNTING_PKG AUTHID CURRENT_USER AS
2 -- $Header: xlaapeng.pkh 120.18.12010000.1 2008/07/29 09:58:58 appldev ship $
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_accounting_pkg |
10 | |
11 | DESCRIPTION |
12 | Package specification for the Accounting Program. |
13 | |
14 | HISTORY |
15 | 01/03/2003 S. Singhania Created |
16 | 01/06/2003 S. Singhania Added NOCOPY hint to the OUT parameters | |
17 | 08/05/2003 S. Singhania Added parameter P_ACCOUNTING_FLAG to |
18 | ACCOUNTING_PROGRAM_DOCUMENT |
19 | 10/14/2003 S. Singhania NOTE: THIS IS BASED ON xlaapeng.pkh 116.3|
20 | 10/14/2003 S. Singhania Made changes for source application: |
21 | - Added p_source_application_id to |
22 | ACCOUNTING_PROGRAM_BATCH |
23 | - Added routine EVENT_APPLICATION_CP |
24 | Added semicolon to the EXIT statement. |
25 | (Bug # 3165900) |
26 | 11/24/2003 S. Singhania Bug 3275659. |
27 | - Added 'p_report_request_id' param to |
28 | UNIT_PROCESSOR_BATCH |
29 | 12/19/2003 S. Singhania Modified specs for UNIT_PROCESSOR_BATCH |
30 | replaced obsolete p_program_run_id with|
31 | p_seq_enabled_flag parameter. This is |
32 | due to sequencing. |
33 | 01/26/2004 WSHEN remove 2 parameters from function |
34 | unit_processor_batch |
35 | p_extract_procedure |
36 | p_post_processing_procedure |
37 | 01/12/2006 V. Kumar Added parameter to unit_processor_batch |
38 | p_transfer_flag and p_gl_posting_flag |
39 | 08/31/2006 V. Swapna Bug: 5257343. Add a new parameter to |
40 | unit_processor_batch |
41 +===========================================================================*/
42
43 TYPE t_array_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
44 g_mpa_accrual_exists varchar2(1) := 'N';
45 g_message xla_queue_msg_type;
46 --
47 -- parametrers
48 --
49
50 g_application_id PLS_INTEGER;
51 g_ledger_id PLS_INTEGER;
52 g_process_category VARCHAR2(30);
53 g_end_date DATE;
54 g_accounting_flag VARCHAR2(1);
55 g_accounting_mode VARCHAR2(1);
56 g_error_only_flag VARCHAR2(1);
57 g_transfer_flag VARCHAR2(1);
58 g_gl_posting_flag VARCHAR2(1);
59 g_gl_batch_name VARCHAR2(240);
60 g_valuation_method VARCHAR2(30);
61 g_security_id_int_1 PLS_INTEGER;
62 g_security_id_int_2 PLS_INTEGER;
63 g_security_id_int_3 PLS_INTEGER;
64 g_security_id_char_1 VARCHAR2(30);
65 g_security_id_char_2 VARCHAR2(30);
66 g_security_id_char_3 VARCHAR2(30);
67
68 g_security_condition VARCHAR2(2000);
69 g_process_category_condition VARCHAR2(2000);
70 g_source_appl_condition VARCHAR2(2000);
71 g_report_request_id NUMBER;
72 g_parent_request_id NUMBER;
73
74 --
75 -- Bug 5056632
76 -- The following two arrays store ledger_id and corresponding group_id
77 -- for transfer to GL purpose
78 --
79 g_array_group_id xla_ae_journal_entry_pkg.t_array_Num;
80 g_array_ledger_id xla_ae_journal_entry_pkg.t_array_Num;
81
82
83 --============================================================================
84 --
85 --
86 --
87 --============================================================================
88 PROCEDURE accounting_program_batch
89 (p_source_application_id IN NUMBER
90 ,p_application_id IN NUMBER
91 ,p_ledger_id IN NUMBER
92 ,p_process_category IN VARCHAR2
93 ,p_end_date IN DATE
94 ,p_accounting_flag IN VARCHAR2
95 ,p_accounting_mode IN VARCHAR2
96 ,p_error_only_flag IN VARCHAR2
97 ,p_transfer_flag IN VARCHAR2
98 ,p_gl_posting_flag IN VARCHAR2
99 ,p_gl_batch_name IN VARCHAR2
100 ,p_valuation_method IN VARCHAR2
101 ,p_security_id_int_1 IN NUMBER
102 ,p_security_id_int_2 IN NUMBER
103 ,p_security_id_int_3 IN NUMBER
104 ,p_security_id_char_1 IN VARCHAR2
105 ,p_security_id_char_2 IN VARCHAR2
106 ,p_security_id_char_3 IN VARCHAR2
107 ,p_accounting_batch_id OUT NOCOPY NUMBER
108 ,p_errbuf OUT NOCOPY VARCHAR2
109 ,p_retcode OUT NOCOPY NUMBER);
110
111
112 --============================================================================
113 --
114 --
115 --
116 --============================================================================
117 PROCEDURE event_application_cp
118 (p_errbuf OUT NOCOPY VARCHAR2
119 ,p_retcode OUT NOCOPY NUMBER
120 ,p_source_application_id IN NUMBER
121 ,p_application_id IN NUMBER
122 ,p_ledger_id IN NUMBER
123 ,p_process_category IN VARCHAR2
124 ,p_end_date IN DATE
125 ,p_accounting_flag IN VARCHAR2
126 ,p_accounting_mode IN VARCHAR2
127 ,p_error_only_flag IN VARCHAR2
128 ,p_transfer_flag IN VARCHAR2
129 ,p_gl_posting_flag IN VARCHAR2
130 ,p_gl_batch_name IN VARCHAR2
131 ,p_accounting_batch_id IN NUMBER
132 ,p_report_request_id IN NUMBER
133 ,p_valuation_method IN VARCHAR2
134 ,p_security_id_int_1 IN NUMBER
135 ,p_security_id_int_2 IN NUMBER
136 ,p_security_id_int_3 IN NUMBER
137 ,p_security_id_char_1 IN VARCHAR2
138 ,p_security_id_char_2 IN VARCHAR2
139 ,p_security_id_char_3 IN VARCHAR2);
140
141
142 --============================================================================
143 --
144 --
145 --
146 --============================================================================
147 PROCEDURE accounting_program_document
148 (p_application_id IN INTEGER
149 ,p_entity_id IN NUMBER
150 ,p_accounting_flag IN VARCHAR2 DEFAULT 'Y'
151 ,p_accounting_mode IN VARCHAR2
152 ,p_gl_posting_flag IN VARCHAR2
153 ,p_offline_flag IN VARCHAR2
154 ,p_accounting_batch_id OUT NOCOPY NUMBER
155 ,p_errbuf OUT NOCOPY VARCHAR2
156 ,p_retcode OUT NOCOPY NUMBER);
157
158 --============================================================================
159 --
160 --
161 --
162 --============================================================================
163 PROCEDURE accounting_program_events
164 (p_application_id IN INTEGER
165 ,p_accounting_mode IN VARCHAR2
166 ,p_gl_posting_flag IN VARCHAR2
167 ,p_offline_flag IN VARCHAR2
168 ,p_accounting_batch_id IN OUT NOCOPY INTEGER
169 ,p_errbuf IN OUT NOCOPY VARCHAR2
170 ,p_retcode IN OUT NOCOPY INTEGER);
171
172
173 --============================================================================
174 --
175 --
176 --
177 --============================================================================
178 PROCEDURE unit_processor_batch
179 (p_errbuf OUT NOCOPY VARCHAR2
180 ,p_retcode OUT NOCOPY NUMBER
181 ,p_application_id IN NUMBER
182 ,p_ledger_id IN NUMBER
183 ,p_end_date IN VARCHAR2 -- Bug 5151844
184 ,p_accounting_mode IN VARCHAR2
185 ,p_error_only_flag IN VARCHAR2
186 ,p_accounting_batch_id IN NUMBER
187 ,p_parent_request_id IN NUMBER
188 ,p_report_request_id IN NUMBER
189 ,p_queue_name IN VARCHAR2
190 ,p_comp_queue_name IN VARCHAR2
191 ,p_error_limit IN NUMBER
192 ,p_seq_enabled_flag IN VARCHAR2
193 ,p_transfer_flag IN VARCHAR2
194 ,p_gl_posting_flag IN VARCHAR2
195 ,p_gl_batch_name IN VARCHAR2);
196
197 END xla_accounting_pkg; -- end of package spec.