[Home] [Help]
PACKAGE: APPS.XLA_ACCT_ANALYSIS_RPT_PKG
Source
1 PACKAGE XLA_ACCT_ANALYSIS_RPT_PKG AUTHID CURRENT_USER AS
2 -- $Header: xlarpaan.pkh 120.19 2011/07/26 10:53:07 vgopiset ship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarpaan.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_acct_analysis_rpt_pkg |
12 | |
13 | DESCRIPTION |
14 | Package specification.This provides XML extract for Account Analysis |
15 | Report. |
16 | |
17 | HISTORY |
18 | 07/20/2005 V. Kumar Created |
19 | 12/19/2005 V. Swapna Modifed the package to use data template |
20 | 12/27/2005 S. Swapna Added code to display TP information. |
21 | 06/02/2006 V. Kumar Added Custom Parameter |
22 | 16-Sep-2008 rajose bug#7386068 |
23 | Added parameter P_INCLUDE_ACCT_WITH_NO_ACT |
24 | to display accounts havng beginning bal and|
25 | no activity and p_begin_balance_union_all |
26 | to query such records |
27 | 20-Oct-2008 rajose bug#7489252 |
28 | Added parameter P_INC_ACCT_WITH_NO_ACT |
29 | to display in Account Analysis Report |
30 | 16-Feb-2009 nksurana Added new parameters to handle more than |
31 | 50 event classes per application for FSAH |
32 | 28-DEC-2009 rajose bug#9002134 to make Acct Analysis Rpt |
33 | queryable by source if source is provided |
34 | as input |
35 | 05-Jan-2010 nksurana Added new parameter p_tax_query to handle |
36 | the tax query in the package. |
37 | 23-Dec-2010 nksurana Added new variables to move the logic from |
38 | xml to pkb to make the xml reuasable and |
39 | improve performance. |
40 +===========================================================================*/
41
42 --
43 -- To be used in query as bind variable
44 --
45 P_RESP_APPLICATION_ID NUMBER;
46 P_LEDGER_ID NUMBER;
47 P_LEDGER VARCHAR2(300);
48 P_COA_ID NUMBER;
49 P_LEGAL_ENTITY_ID NUMBER;
50 P_LEGAL_ENTITY VARCHAR2(300);
51 P_PERIOD_FROM VARCHAR2(15);
52 P_PERIOD_TO VARCHAR2(15);
53 P_GL_DATE_FROM DATE;
54 P_GL_DATE_TO DATE;
55 P_BALANCE_TYPE_CODE VARCHAR2(1);
56 P_BALANCE_TYPE VARCHAR2(300);
57 P_DUMMY_BUDGET_VERSION VARCHAR2(300);
58 P_BUDGET_VERSION_ID NUMBER;
59 P_BUDGET_NAME VARCHAR2(300);
60 P_DUMMY_ENCUMBRANCE_TYPE VARCHAR2(300);
61 P_ENCUMBRANCE_TYPE_ID NUMBER;
62 P_ENCUMBRANCE_TYPE VARCHAR2(300);
63 P_BALANCE_SIDE_CODE VARCHAR2(300);
64 P_BALANCE_SIDE VARCHAR2(300);
65 P_BALANCE_AMOUNT_FROM NUMBER;
66 P_BALANCE_AMOUNT_TO NUMBER;
67 P_BALANCING_SEGMENT_FROM VARCHAR2(300);
68 P_BALANCING_SEGMENT_TO VARCHAR2(300);
69 P_ACCOUNT_SEGMENT_FROM VARCHAR2(80);
70 P_ACCOUNT_SEGMENT_TO VARCHAR2(80);
71 P_ACCOUNT_FLEXFIELD_FROM VARCHAR2(780);
72 P_ACCOUNT_FLEXFIELD_TO VARCHAR2(780);
73 P_INCLUDE_ZERO_AMOUNT_LINES VARCHAR2(1);
74 P_INCLUDE_ZERO_AMT_LINES VARCHAR2(20);
75 P_INCLUDE_USER_TRX_ID_FLAG VARCHAR2(1);
76 P_INCLUDE_USER_TRX_ID VARCHAR2(20);
77 P_INCLUDE_TAX_DETAILS_FLAG VARCHAR2(1);
78 P_INCLUDE_TAX_DETAILS VARCHAR2(20);
79 P_INCLUDE_LE_INFO_FLAG VARCHAR2(30);
80 P_INCLUDE_LEGAL_ENTITY VARCHAR2(30);
81 P_CUSTOM_PARAMETER_1 VARCHAR2(240);
82 P_CUSTOM_PARAMETER_2 VARCHAR2(240);
83 P_CUSTOM_PARAMETER_3 VARCHAR2(240);
84 P_CUSTOM_PARAMETER_4 VARCHAR2(240);
85 P_CUSTOM_PARAMETER_5 VARCHAR2(240);
86 P_CUSTOM_PARAMETER_6 VARCHAR2(240);
87 P_CUSTOM_PARAMETER_7 VARCHAR2(240);
88 P_CUSTOM_PARAMETER_8 VARCHAR2(240);
89 P_CUSTOM_PARAMETER_9 VARCHAR2(240);
90 P_CUSTOM_PARAMETER_10 VARCHAR2(240);
91 P_CUSTOM_PARAMETER_11 VARCHAR2(240);
92 P_CUSTOM_PARAMETER_12 VARCHAR2(240);
93 P_CUSTOM_PARAMETER_13 VARCHAR2(240);
94 P_CUSTOM_PARAMETER_14 VARCHAR2(240);
95 P_CUSTOM_PARAMETER_15 VARCHAR2(240);
96 /* 16-30 Custom Parameters added for bug12699905 */
97 P_CUSTOM_PARAMETER_16 VARCHAR2(240);
98 P_CUSTOM_PARAMETER_17 VARCHAR2(240);
99 P_CUSTOM_PARAMETER_18 VARCHAR2(240);
100 P_CUSTOM_PARAMETER_19 VARCHAR2(240);
101 P_CUSTOM_PARAMETER_20 VARCHAR2(240);
102 P_CUSTOM_PARAMETER_21 VARCHAR2(240);
103 P_CUSTOM_PARAMETER_22 VARCHAR2(240);
104 P_CUSTOM_PARAMETER_23 VARCHAR2(240);
105 P_CUSTOM_PARAMETER_24 VARCHAR2(240);
106 P_CUSTOM_PARAMETER_25 VARCHAR2(240);
107 P_CUSTOM_PARAMETER_26 VARCHAR2(240);
108 P_CUSTOM_PARAMETER_27 VARCHAR2(240);
109 P_CUSTOM_PARAMETER_28 VARCHAR2(240);
110 P_CUSTOM_PARAMETER_29 VARCHAR2(240);
111 P_CUSTOM_PARAMETER_30 VARCHAR2(240);
112 /* end of changes for bug12699905 */
113 P_INCLUDE_STAT_AMOUNT_LINES VARCHAR2(1);
114 P_INCLUDE_STAT_AMT_LINES VARCHAR2(20);
115 P_INCLUDE_ACCT_WITH_NO_ACT VARCHAR2(1); --bug#7386068
116 P_INC_ACCT_WITH_NO_ACT VARCHAR2(30); --bug#7489252
117
118
119 p_party_col VARCHAR2(2000):=',NULL,NULL,NULL,NULL,NULL,NULL';
120 p_party_tab VARCHAR2(2000):='';
121 p_party_join VARCHAR2(2000):='';
122 p_legal_ent_col VARCHAR2(2000):='';
123 p_legal_ent_from VARCHAR2(2000):='';
124 p_legal_ent_join VARCHAR2(2000):='';
125 p_qualifier_segment VARCHAR2(4000):='';
126 p_seg_desc_from VARCHAR2(2000):='';
127 p_seg_desc_join VARCHAR2(2000):='';
128 p_trx_identifiers VARCHAR2(32000):=',NULL';
129 p_sla_other_filter VARCHAR2(2000):='';
130 p_gl_other_filter VARCHAR2(2000):='';
131 p_party_columns VARCHAR2(4000):=' ';
132 p_ledger_filters VARCHAR2(4000):=' ';
133 p_begin_balance_union_all VARCHAR2(32000) := ' '; --bug#7386068
134
135 --bug#9002134
136 p_application_id NUMBER;
137 p_je_source_name VARCHAR2(300);
138 p_je_source_period VARCHAR2(32000) := ' ';
139 p_sla_application_id_filter VARCHAR2(4000):=' ';
140 p_gl_application_id_filter VARCHAR2(4000):=' ';
141 --bug#9002134
142
143 p_commercial_query VARCHAR2(32000);
144 p_vat_registration_query VARCHAR2(32000);
145 p_tax_query VARCHAR2(32000); --bug9011171,8762703
146
147 --Added for bug 7580995
148 p_trx_identifiers_1 VARCHAR2(32000):= ' ';
149 p_trx_identifiers_2 VARCHAR2(32000):= ' ';
150 p_trx_identifiers_3 VARCHAR2(32000):= ' ';
151 p_trx_identifiers_4 VARCHAR2(32000):= ' ';
152 p_trx_identifiers_5 VARCHAR2(32000):= ' ';
153
154 p_long_report VARCHAR2(2);
155
156 --bug 10425976
157 p_main_col_start VARCHAR2(32000):= ' ';
158 p_main_lgr_sgmt_col VARCHAR2(32000):= ' ';
159 p_main_le_col VARCHAR2(32000):= ' ';
160 p_main_col_end VARCHAR2(32000):= ' ';
161 p_sla_col_start VARCHAR2(32000):= ' ';
162 p_gt_lgr_sgmt_col VARCHAR2(32000):= ' ';
163 p_gt_le_col VARCHAR2(32000):= ' ';
164 p_sla_col_end VARCHAR2(32000):= ' ';
165 p_sla_from VARCHAR2(32000):= ' ';
166 p_sla_main_filter VARCHAR2(32000):= ' ';
167 p_union_all VARCHAR2(20):=' UNION ALL ';
168 p_gl_col_start VARCHAR2(32000):= ' ';
169 p_gl_col_end VARCHAR2(32000):= ' ';
170 p_gl_from VARCHAR2(32000):= ' ';
171 p_gl_main_filter VARCHAR2(32000):= ' ';
172 p_upg_gl_from VARCHAR2(32000):= ' ';
173 p_upg_gl_main_filter VARCHAR2(32000):= ' ';
174 p_order_by_clause VARCHAR2(4000):= ' ';
175
176 FUNCTION beforeReport RETURN BOOLEAN;
177
178
179 END XLA_ACCT_ANALYSIS_RPT_PKG;