[Home] [Help]
PACKAGE: APPS.XLA_ACCT_ANALYSIS_RPT_PKG
Source
1 PACKAGE XLA_ACCT_ANALYSIS_RPT_PKG AS
2 -- $Header: xlarpaan.pkh 120.12.12010000.2 2008/11/11 10:21:28 rajose 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 +===========================================================================*/
31
32 --
33 -- To be used in query as bind variable
34 --
35 P_RESP_APPLICATION_ID NUMBER;
36 P_LEDGER_ID NUMBER;
37 P_LEDGER VARCHAR2(300);
38 P_COA_ID NUMBER;
39 P_LEGAL_ENTITY_ID NUMBER;
40 P_LEGAL_ENTITY VARCHAR2(300);
41 P_PERIOD_FROM VARCHAR2(15);
42 P_PERIOD_TO VARCHAR2(15);
43 P_GL_DATE_FROM DATE;
44 P_GL_DATE_TO DATE;
45 P_BALANCE_TYPE_CODE VARCHAR2(1);
46 P_BALANCE_TYPE VARCHAR2(300);
47 P_DUMMY_BUDGET_VERSION VARCHAR2(300);
48 P_BUDGET_VERSION_ID NUMBER;
49 P_BUDGET_NAME VARCHAR2(300);
50 P_DUMMY_ENCUMBRANCE_TYPE VARCHAR2(300);
51 P_ENCUMBRANCE_TYPE_ID NUMBER;
52 P_ENCUMBRANCE_TYPE VARCHAR2(300);
53 P_BALANCE_SIDE_CODE VARCHAR2(300);
54 P_BALANCE_SIDE VARCHAR2(300);
55 P_BALANCE_AMOUNT_FROM NUMBER;
56 P_BALANCE_AMOUNT_TO NUMBER;
57 P_BALANCING_SEGMENT_FROM VARCHAR2(300);
58 P_BALANCING_SEGMENT_TO VARCHAR2(300);
59 P_ACCOUNT_SEGMENT_FROM VARCHAR2(80);
60 P_ACCOUNT_SEGMENT_TO VARCHAR2(80);
61 P_ACCOUNT_FLEXFIELD_FROM VARCHAR2(780);
62 P_ACCOUNT_FLEXFIELD_TO VARCHAR2(780);
63 P_INCLUDE_ZERO_AMOUNT_LINES VARCHAR2(1);
64 P_INCLUDE_ZERO_AMT_LINES VARCHAR2(20);
65 P_INCLUDE_USER_TRX_ID_FLAG VARCHAR2(1);
66 P_INCLUDE_USER_TRX_ID VARCHAR2(20);
67 P_INCLUDE_TAX_DETAILS_FLAG VARCHAR2(1);
68 P_INCLUDE_TAX_DETAILS VARCHAR2(20);
69 P_INCLUDE_LE_INFO_FLAG VARCHAR2(30);
70 P_INCLUDE_LEGAL_ENTITY VARCHAR2(30);
71 P_CUSTOM_PARAMETER_1 VARCHAR2(240);
72 P_CUSTOM_PARAMETER_2 VARCHAR2(240);
73 P_CUSTOM_PARAMETER_3 VARCHAR2(240);
74 P_CUSTOM_PARAMETER_4 VARCHAR2(240);
75 P_CUSTOM_PARAMETER_5 VARCHAR2(240);
76 P_CUSTOM_PARAMETER_6 VARCHAR2(240);
77 P_CUSTOM_PARAMETER_7 VARCHAR2(240);
78 P_CUSTOM_PARAMETER_8 VARCHAR2(240);
79 P_CUSTOM_PARAMETER_9 VARCHAR2(240);
80 P_CUSTOM_PARAMETER_10 VARCHAR2(240);
81 P_CUSTOM_PARAMETER_11 VARCHAR2(240);
82 P_CUSTOM_PARAMETER_12 VARCHAR2(240);
83 P_CUSTOM_PARAMETER_13 VARCHAR2(240);
84 P_CUSTOM_PARAMETER_14 VARCHAR2(240);
85 P_CUSTOM_PARAMETER_15 VARCHAR2(240);
86 P_INCLUDE_STAT_AMOUNT_LINES VARCHAR2(1);
87 P_INCLUDE_STAT_AMT_LINES VARCHAR2(20);
88 P_INCLUDE_ACCT_WITH_NO_ACT VARCHAR2(1); --bug#7386068
89 P_INC_ACCT_WITH_NO_ACT VARCHAR2(30); --bug#7489252
90
91
92 p_party_col VARCHAR2(2000):=',NULL,NULL,NULL,NULL,NULL,NULL';
93 p_party_tab VARCHAR2(2000):='';
94 p_party_join VARCHAR2(2000):='';
95 p_legal_ent_col VARCHAR2(2000):='';
96 p_legal_ent_from VARCHAR2(2000):='';
97 p_legal_ent_join VARCHAR2(2000):='';
98 p_qualifier_segment VARCHAR2(4000):='';
99 p_seg_desc_from VARCHAR2(2000):='';
100 p_seg_desc_join VARCHAR2(2000):='';
101 p_trx_identifiers VARCHAR2(32000):=',NULL';
102 p_sla_other_filter VARCHAR2(2000):='';
103 p_gl_other_filter VARCHAR2(2000):='';
104 p_party_columns VARCHAR2(4000):=' ';
105 p_ledger_filters VARCHAR2(4000):=' ';
106 p_commercial_query VARCHAR2(32000);
107 p_vat_registration_query VARCHAR2(32000);
108
109 p_begin_balance_union_all VARCHAR2(32000) := ' '; --bug#7386068
110
111 FUNCTION beforeReport RETURN BOOLEAN;
112
113
114 END XLA_ACCT_ANALYSIS_RPT_PKG;