[Home] [Help]
PACKAGE: APPS.XLA_JELINES_RPT_PKG
Source
1 PACKAGE xla_jelines_rpt_pkg AS
2 -- $Header: xlarpjel.pkh 120.10.12010000.3 2008/11/07 12:52:58 krsankar ship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarpjel.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_jelines_rpt_pkg |
12 | |
13 | DESCRIPTION |
14 | Package specification. This provides XML extract for Journal Entry |
15 | Report |
16 | |
17 | HISTORY |
18 | 04/15/2005 V. Kumar Created |
19 | 06/30/2005 V. Kumar Bug 4311267 Added p_dummy_event_class |
20 | parameter to run report |
21 | 12/23/2005 V. Kumar Changed the package to use Data template |
22 | 03/28/06 V. Swapna Bug 5105786 : Change to the size of |
23 | the parameters. |
24 | 05/12/06 A. Wan 5162050 - add 10 custom param: 6-15 |
25 +===========================================================================*/
26
27
28 --
29 -- To be used in query as bind variable
30 --
31
32 p_resp_application_id NUMBER;
33 p_ledger_id NUMBER;
34 p_coa_id NUMBER;
35 p_ledger VARCHAR2(300);
36 p_legal_entity_id NUMBER;
37 p_legal_entity VARCHAR2(300);
38 p_trx_legal_entity_id NUMBER;
39 p_trx_legal_entity VARCHAR2(300);
40 p_period_from VARCHAR2(30);
41 p_period_to VARCHAR2(30);
42 p_gl_date_from DATE;
43 p_gl_date_to DATE;
44 p_creation_date_from DATE;
45 p_creation_date_to DATE;
46 p_transaction_date_from DATE;
47 p_transaction_date_to DATE;
48 p_je_status_code VARCHAR2(30);
49 p_je_status VARCHAR2(300);
50 p_posting_status_code VARCHAR2(30);
51 p_posting_status VARCHAR2(30);
52 p_je_source VARCHAR2(30);
53 p_je_source_name VARCHAR2(300);
54 p_process_category_rowid VARCHAR2(30);
55 p_process_category VARCHAR2(300);
56 p_dummy_event_class VARCHAR2(30);
57 p_event_class_rowid VARCHAR2(30);
58 p_event_class VARCHAR2(300);
59 p_transaction_view VARCHAR2(30);
60 p_acct_sequence_name VARCHAR2(240);
61 p_acct_sequence_version NUMBER;
62 p_acct_sequence_num_from NUMBER;
63 p_acct_sequence_num_to NUMBER;
64 p_rpt_sequence_name VARCHAR2(240);
65 p_rpt_sequence_version NUMBER;
66 p_rpt_sequence_num_from NUMBER;
67 p_rpt_sequence_num_to NUMBER;
68 p_doc_sequence_name VARCHAR2(240);
69 p_doc_sequence_num_from NUMBER;
70 p_doc_sequence_num_to NUMBER;
71 p_party_type_code VARCHAR2(30);
72 p_party_type VARCHAR2(300);
73 p_party_id NUMBER;
74 p_party_name VARCHAR2(360);
75 p_party_number_from NUMBER;
76 p_party_number_to NUMBER;
77 p_je_category VARCHAR2(30);
78 p_je_category_name VARCHAR2(300);
79 p_balance_type_code VARCHAR2(30);
80 p_balance_type VARCHAR2(300);
81 p_budget_version_id NUMBER;
82 p_budget_name VARCHAR2(300);
83 p_encumbrance_type_id NUMBER;
84 p_encumbrance_type VARCHAR2(300);
85 p_include_zero_amount_flag VARCHAR2(30);
86 p_include_zero_amount_lines VARCHAR2(30);
87 p_entered_currency VARCHAR2(30);
88 p_accounted_amount_from NUMBER;
89 p_accounted_amount_to NUMBER;
90 p_balancing_segment_from VARCHAR2(30);
91 p_balancing_segment_to VARCHAR2(30);
92 p_account_segment_from VARCHAR2(30);
93 p_account_segment_to VARCHAR2(30);
94 p_account_flexfield_from VARCHAR2(780);
95 p_account_flexfield_to VARCHAR2(780);
96 p_side_code VARCHAR2(30);
97 p_side VARCHAR2(300);
98 p_valuation_method VARCHAR2(30);
99 p_security_id_int_1 NUMBER;
100 p_security_id_int_2 NUMBER;
101 p_security_id_int_3 NUMBER;
102 p_security_id_char_1 VARCHAR2(30);
103 p_security_id_char_2 VARCHAR2(30);
104 p_security_id_char_3 VARCHAR2(30);
105 p_post_acct_program_rowid VARCHAR2(30);
106 p_post_accounting_program VARCHAR2(240);
107 p_user_trx_id_column_1 VARCHAR2(30);
108 p_user_trx_id_value_1 VARCHAR2(240);
109 p_user_trx_id_column_2 VARCHAR2(30);
110 p_user_trx_id_value_2 VARCHAR2(240);
111 p_user_trx_id_column_3 VARCHAR2(30);
112 p_user_trx_id_value_3 VARCHAR2(240);
113 p_user_trx_id_column_4 VARCHAR2(30);
114 p_user_trx_id_value_4 VARCHAR2(240);
115 p_user_trx_id_column_5 VARCHAR2(30);
116 p_user_trx_id_value_5 VARCHAR2(240);
117 p_gl_batch_name VARCHAR2(240);
118 p_include_user_trx_id_flag VARCHAR2(30);
119 p_include_user_trx_identifiers VARCHAR2(30);
120 p_include_tax_details_flag VARCHAR2(30);
121 p_include_tax_details VARCHAR2(30);
122 p_include_le_info_flag VARCHAR2(30);
123 p_ytd_carriedfwd_flag VARCHAR2(30);
124 p_ytd_carriedfwd_info VARCHAR2(30);
125 p_include_legal_entity_info VARCHAR2(240);
126 p_custom_parameter_1 VARCHAR2(240);
127 p_custom_parameter_2 VARCHAR2(240);
128 p_custom_parameter_3 VARCHAR2(240);
129 p_custom_parameter_4 VARCHAR2(240);
130 p_custom_parameter_5 VARCHAR2(240);
131 p_custom_parameter_6 VARCHAR2(240);
132 p_custom_parameter_7 VARCHAR2(240);
133 p_custom_parameter_8 VARCHAR2(240);
134 p_custom_parameter_9 VARCHAR2(240);
135 p_custom_parameter_10 VARCHAR2(240);
136 p_custom_parameter_11 VARCHAR2(240);
137 p_custom_parameter_12 VARCHAR2(240);
138 p_custom_parameter_13 VARCHAR2(240);
139 p_custom_parameter_14 VARCHAR2(240);
140 p_custom_parameter_15 VARCHAR2(240);
141 p_legal_audit_flag VARCHAR2(240);
142 p_fetch_from_gl VARCHAR2(10);
143 p_doc_seq_name VARCHAR2(240);
144
145 p_sla_legal_ent_col VARCHAR2(2000):=' ';
146 p_sla_legal_ent_from VARCHAR2(1000):=' ';
147 p_sla_legal_ent_join VARCHAR2(1000):=' ';
148 p_gl_legal_ent_col VARCHAR2(2000):=' ';
149 p_gl_legal_ent_from VARCHAR2(1000):=' ';
150 p_gl_legal_ent_join VARCHAR2(1000):=' ';
151 p_party_details VARCHAR2(4000):=' ';
152 p_party_details_col VARCHAR2(4000):=
153 ',TABLE1.party_number PARTY_NUMBER
154 ,TABLE1.party_name PARTY_NAME
155 ,TABLE1.party_site_number PARTY_SITE_NUMBER
156 ,TABLE1.party_site_name PARTY_SITE_NAME
157 ,TABLE1.party_type_taxpayer_id PARTY_TYPE_TAXPAYER_ID
158 ,TABLE1.party_tax_registration_number PARTY_TAX_REGISTRATION_NUMBER
159 ,TABLE1.party_site_tax_rgstn_number PARTY_SITE_TAX_RGSTN_NUMBER ';
160 p_gl_party_details VARCHAR2(2000) := ' ';
161 p_party_from VARCHAR2(240) := ' ';
162 p_party_join VARCHAR2(1000) := ' ';
163 p_sla_qualifier_segment VARCHAR2(4000) := ' ';
164 p_sla_seg_desc_from VARCHAR2(1000) := ' ';
165 p_sla_seg_desc_join VARCHAR2(1000) := ' ';
166 p_gl_qualifier_segment VARCHAR2(4000) := ' ';
167 p_gl_seg_desc_from VARCHAR2(1000) := ' ';
168 p_gl_seg_desc_join VARCHAR2(1000) := ' ';
169 p_trx_identifiers VARCHAR2(32000):= ' ';
170 p_gl_view VARCHAR2(1000) := ' ';
171 p_other_param_filter VARCHAR2(8000) := ' ';
172 p_gl_join VARCHAR2(1000) := ' ';
173 p_gl_columns VARCHAR2(1000) := ' ';
174 p_le_col VARCHAR2(4000) := ' ';
175 p_le_from VARCHAR2(2000) := ' ';
176 p_le_join VARCHAR2(2000) := ' ';
177 p_sla_col_1 VARCHAR2(8000) := ' ';
178 p_sla_col_2 VARCHAR2(8000) := ' ';
179 p_sla_col_3 VARCHAR2(8000) := ' ';
180 p_sla_from VARCHAR2(4000) := ' ';
181 p_sla_join VARCHAR2(4000) := ' ';
182 p_gl_col_1 VARCHAR2(8000) := ' ';
183 p_gl_col_2 VARCHAR2(8000) := ' ';
184 p_gl_from VARCHAR2(4000) := ' ';
185 p_gl_where VARCHAR2(4000) := ' ';
186 p_union_all VARCHAR2(30) := ' ';
187 p_trx_id_filter VARCHAR2(3000) := ' ';
188 p_tax_query VARCHAR2(32000);
189 p_ytd_carriedfwd VARCHAR2(32000);
190 p_created_query VARCHAR2(32000);
191 p_posted_query VARCHAR2(32000);
192 p_approved_query VARCHAR2(32000);
193 p_commercial_query VARCHAR2(32000);
194 p_vat_registration_query VARCHAR2(32000);
195
196 FUNCTION beforeReport RETURN BOOLEAN;
197
198 END xla_jelines_rpt_pkg;