1 PACKAGE ARP_RECON_REP AUTHID CURRENT_USER AS
2 /* $Header: ARGLRECS.pls 120.2 2010/05/10 06:23:39 naneja ship $ */
3
4 /*=======================================================================+
5 | Package Global Constants
6 +=======================================================================*/
7
8 type var_t is record(
9 l_ar_system_parameters_all VARCHAR2(50),
10 l_ar_payment_schedules_all VARCHAR2(50),
11 l_ar_adjustments_all VARCHAR2(50),
12 l_ar_cash_receipt_history_all VARCHAR2(50),
13 l_ar_batches_all VARCHAR2(50),
14 l_ar_cash_receipts_all VARCHAR2(50),
15 l_ar_distributions_all VARCHAR2(50),
16 l_ra_customer_trx_all VARCHAR2(50),
17 l_ra_batches_all VARCHAR2(50),
18 l_ra_cust_trx_gl_dist_all VARCHAR2(50),
19 l_ar_misc_cash_dists_all VARCHAR2(50),
20 l_ar_rate_adjustments_all VARCHAR2(50),
21 l_ar_receivable_apps_all VARCHAR2(50),
22 g_reporting_level VARCHAR2(50),
23 g_reporting_entity_id NUMBER,
24 g_set_of_books_id NUMBER,
25 g_chart_of_accounts_id NUMBER,
26 g_gl_date_from DATE,
27 g_gl_date_to DATE,
28 g_period_name VARCHAR2(15),
29 g_posting_status VARCHAR2(15),
30 g_functional_currency VARCHAR2(15),
31 g_out_of_balance_only VARCHAR2(1),
32 g_max_gl_date DATE
33 );
34
35 var_tname var_t;
36
37 TYPE flex_table IS
38 table of FND_FLEX_VALUES.flex_value%TYPE
39 index by binary_integer;
40
41 detail flex_table;
42
43
44 /*========================================================================+
45 Function which returns the global variable g_reporting_level
46 ========================================================================+*/
47
48 FUNCTION get_reporting_level return VARCHAR2;
49
50 /*========================================================================+
51 Function which returns the global variable g_reporting_entity_id
52 ========================================================================*/
53
54 FUNCTION get_reporting_entity_id return NUMBER;
55
56 /*========================================================================+
57 Function which returns the global variable g_set_of_books_id
58 ========================================================================*/
59
60 FUNCTION get_set_of_books_id return NUMBER;
61
62 /*========================================================================+
63 Function which returns the global variable g_chart_of_accounts_id
64 ========================================================================*/
65
66 FUNCTION get_chart_of_accounts_id return NUMBER;
67
68 /*========================================================================+
69 Function which returns the global variable g_gl_date_from
70 ========================================================================*/
71
72 FUNCTION get_gl_date_from return DATE;
73
74 /*========================================================================+
75 Function which returns the global variable g_gl_date_to
76 ========================================================================*/
77
78 FUNCTION get_gl_date_to return DATE;
79
80 /*========================================================================+
81 Function which returns the global variable g_posting_status
82 ========================================================================*/
83
84 FUNCTION get_posting_status return VARCHAR2;
85
86 /*========================================================================+
87 Function which returns the maximum possible gl_date
88 ========================================================================*/
89
90 FUNCTION get_max_gl_date return DATE;
91
92 /*========================================================================+
93 Function which returns the period_name
94 ========================================================================*/
95
96 FUNCTION get_period_name return VARCHAR2;
97
98 /*========================================================================+
99 Function which returns the functional currency
100 ========================================================================*/
101
102 FUNCTION get_functional_currency return VARCHAR2;
103
104 /*========================================================================+
105 Function which returns the value of g_out_of_balance_only
106 ========================================================================*/
107
108 FUNCTION get_out_of_balance_only return VARCHAR2;
109
110 /*========================================================================+
111 | PUBLIC PROCEDURE GET_DETAIL_ACCOUNTS |
112 | |
113 | DESCRIPTION |
114 | |
115 | This procedure is used to generate the list of account segments to |
116 | be queried for a given summary account |
117 | |
118 | PSEUDO CODE/LOGIC |
119 | |
120 | PARAMETERS |
121 | |
122 | |
123 | KNOWN ISSUES |
124 | |
125 | NOTES |
126 | |
127 | |
128 | MODIFICATION HISTORY |
129 | Date Author Description of Changes |
130 | 16-NOV-2004 rkader Created |
131 | |
132 *=======================================================================*/
133
134 PROCEDURE get_detail_accounts(p_value_set_id IN NUMBER,
135 p_parent_value IN VARCHAR2,
136 p_code_combinations OUT NOCOPY VARCHAR2 );
137
138
139 /*========================================================================+
140 | PUBLIC PROCEDURE INIT |
141 | |
142 | DESCRIPTION |
143 | |
144 | This procedure is used to initialize the reporting context. This |
145 | procedure sets the table names to be used in the queries. |
146 | |
147 | PSEUDO CODE/LOGIC |
148 | |
149 | PARAMETERS |
150 | |
151 | |
152 | KNOWN ISSUES |
153 | |
154 | NOTES |
155 | |
156 | |
157 | MODIFICATION HISTORY |
158 | Date Author Description of Changes |
159 | 16-NOV-2004 rkader Created |
160 | |
161 *=======================================================================*/
162
163 PROCEDURE INIT(p_set_of_books_id IN NUMBER);
164
165 FUNCTION format_string(p_string varchar2) return varchar2;
166
167 PROCEDURE aradj_journal_load_xml (
168 p_reporting_level IN VARCHAR2,
169 p_reporting_entity_id IN NUMBER,
170 p_sob_id IN NUMBER,
171 p_coa_id IN NUMBER,
172 p_co_seg_low IN VARCHAR2,
173 p_co_seg_high IN VARCHAR2,
174 p_gl_date_from IN VARCHAR2,
175 p_gl_date_to IN VARCHAR2,
176 p_posting_status IN VARCHAR2,
177 p_gl_account_low IN VARCHAR2,
178 p_gl_account_high IN VARCHAR2,
179 p_summary_account IN NUMBER,
180 p_receivable_mode IN VARCHAR2,
181 p_result OUT NOCOPY CLOB) ;
182
183 PROCEDURE arunapp_journal_load_xml (
184 p_reporting_level IN VARCHAR2,
185 p_reporting_entity_id IN NUMBER,
186 p_sob_id IN NUMBER,
187 p_coa_id IN NUMBER,
188 p_co_seg_low IN VARCHAR2,
189 p_co_seg_high IN VARCHAR2,
190 p_gl_date_from IN VARCHAR2,
191 p_gl_date_to IN VARCHAR2,
192 p_posting_status IN VARCHAR2,
193 p_gl_account_low IN VARCHAR2,
194 p_gl_account_high IN VARCHAR2,
195 p_summary_account IN NUMBER,
196 p_receivable_mode IN VARCHAR2,
197 p_result OUT NOCOPY CLOB) ;
198
199 PROCEDURE arapp_journal_load_xml (
200 p_reporting_level IN VARCHAR2,
201 p_reporting_entity_id IN NUMBER,
202 p_sob_id IN NUMBER,
203 p_coa_id IN NUMBER,
204 p_co_seg_low IN VARCHAR2,
205 p_co_seg_high IN VARCHAR2,
206 p_gl_date_from IN VARCHAR2,
207 p_gl_date_to IN VARCHAR2,
208 p_posting_status IN VARCHAR2,
209 p_gl_account_low IN VARCHAR2,
210 p_gl_account_high IN VARCHAR2,
211 p_summary_account IN NUMBER,
212 p_receivable_mode IN VARCHAR2,
213 p_result OUT NOCOPY CLOB) ;
214
215 PROCEDURE arcm_journal_load_xml (
216 p_reporting_level IN VARCHAR2,
217 p_reporting_entity_id IN NUMBER,
218 p_sob_id IN NUMBER,
219 p_coa_id IN NUMBER,
220 p_co_seg_low IN VARCHAR2,
221 p_co_seg_high IN VARCHAR2,
222 p_gl_date_from IN VARCHAR2,
223 p_gl_date_to IN VARCHAR2,
224 p_posting_status IN VARCHAR2,
225 p_gl_account_low IN VARCHAR2,
226 p_gl_account_high IN VARCHAR2,
227 p_summary_account IN NUMBER,
228 p_receivable_mode IN VARCHAR2,
229 p_result OUT NOCOPY CLOB) ;
230
231 PROCEDURE arglrecon_load_xml(
232 p_reporting_level IN VARCHAR2,
233 p_reporting_entity_id IN NUMBER,
234 p_sob_id IN NUMBER,
235 p_coa_id IN NUMBER,
236 p_out_of_balance_only IN VARCHAR2,
237 p_co_seg_low IN VARCHAR2,
238 p_co_seg_high IN VARCHAR2,
239 p_period_name IN VARCHAR2,
240 p_gl_account_low IN VARCHAR2,
241 p_gl_account_high IN VARCHAR2,
242 p_summary_account IN VARCHAR2,
243 p_result OUT NOCOPY CLOB );
244
245 /*bug 9671956 added function to get description based passed value of account*/
246 FUNCTION get_description(
247 p_application_id in number,
248 p_id_flex_code in varchar2,
249 p_id_flex_num in number default NULL,
250 p_qualifier in varchar2,
251 p_data in varchar2) return varchar2;
252
253 END ARP_RECON_REP;