[Home] [Help]
PACKAGE: APPS.XLA_TP_BALANCE_RPT_PKG
Source
1 PACKAGE XLA_TP_BALANCE_RPT_PKG AUTHID CURRENT_USER AS
2 -- $Header: xlarptpb.pkh 120.19 2011/07/26 10:52:31 vgopiset ship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarptpb.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_tp_balance_rpt_pkg |
12 | |
13 | DESCRIPTION |
14 | Package specification.This provides XML extract for Third Party Balance|
15 | Report |
16 | |
17 | HISTORY |
18 | 07/20/2005 V. Kumar Created |
19 | 12/27/2005 V.Swapna Modified the package to use Data template |
20 | 04/26/2006 A. Wan 5162044 - add 10 custom_parameters 6-15 |
21 | 11/23/2010 N. K. Surana Added new parameters to introduce filter |
22 | based on zero amount balances. |
23 | 03/21/2011 SGULLAPE Bug :11825853 Added new parameter |
24 | P_PARTY_TYPE_VALUE which fetches the |
25 | meaning or translated value |
26 | for P_PARTY_TYPE. |
27 | |
28 +===========================================================================*/
29
30 --
31 -- To be used in query as bind variable
32 --
33 P_RESP_APPLICATION_ID NUMBER ;
34 P_LEDGER_ID NUMBER ;
35 P_LEDGER VARCHAR2(300);
36 P_COA_ID NUMBER;
37 P_JE_SOURCE_NAME VARCHAR2(240);
38 P_JE_SOURCE VARCHAR2(300);
39 P_LEGAL_ENTITY_ID NUMBER;
40 P_LEGAL_ENTITY VARCHAR2(300);
41 P_PERIOD_FROM VARCHAR2(30);
42 P_PERIOD_TO VARCHAR2(30);
43 P_GL_DATE_FROM DATE ;
44 P_GL_DATE_TO DATE ;
45 P_INCLUDE_DRAFT_ACTIVITY_FLAG VARCHAR2(1);
46 P_INCLUDE_DRAFT_ACTIVITY VARCHAR2(20);
47 P_BALANCE_SIDE_CODE VARCHAR2(80);
48 P_BALANCE_SIDE VARCHAR2(80);
49 P_BALANCE_AMOUNT_FROM NUMBER;
50 P_BALANCE_AMOUNT_TO NUMBER;
51 P_PARTY_TYPE VARCHAR2(30);
52 P_PARTY_TYPE_VALUE VARCHAR2(80); --Bug 11825853
53 P_PARTY_ID NUMBER;
54 P_THIRD_PARTY_NAME VARCHAR2(300);
55 P_DUMMY_PARTY VARCHAR2(300);
56 P_PARTY_SITE_ID NUMBER;
57 P_THIRD_PARTY_SITE VARCHAR2(300);
58 P_PARTY_NUMBER_FROM VARCHAR2(30); --Bug 8544794
59 P_PARTY_NUMBER_TO VARCHAR2(30); --Bug 8544794
60 P_BALANCING_SEGMENT_FROM VARCHAR2(25);
61 P_BALANCING_SEGMENT_TO VARCHAR2(25);
62 P_ACCOUNT_SEGMENT_FROM VARCHAR2(25);
63 P_ACCOUNT_SEGMENT_TO VARCHAR2(25);
64 P_ACCOUNTING_FLEXFIELD_FROM VARCHAR2(780);
65 P_ACCOUNTING_FLEXFIELD_TO VARCHAR2(780);
66 P_INCLUDE_ZERO_AMT_BAL_FLAG VARCHAR2(1); --bug 10177675
67 P_INCLUDE_ZERO_AMOUNT_BALANCES VARCHAR2(20); --bug 10177675
68 P_INCLUDE_ZERO_AMT_LINES_FLAG VARCHAR2(1);
69 P_INCLUDE_ZERO_AMOUNT_LINES VARCHAR2(20);
70 P_INCLUDE_USER_TRX_ID_FLAG VARCHAR2(1);
71 P_INCLUDE_USER_TRX_IDENTIFIERS VARCHAR2(20);
72 P_INCLUDE_TAX_DETAILS_FLAG VARCHAR2(1);
73 P_INCLUDE_TAX_DETAILS VARCHAR2(20);
74 P_INCLUDE_LE_INFO_FLAG VARCHAR2(30);
75 P_INCLUDE_LEGAL_ENTITY VARCHAR2(30);
76 P_CUSTOM_PARAMETER_1 VARCHAR2(240);
77 P_CUSTOM_PARAMETER_2 VARCHAR2(240);
78 P_CUSTOM_PARAMETER_3 VARCHAR2(240);
79 P_CUSTOM_PARAMETER_4 VARCHAR2(240);
80 P_CUSTOM_PARAMETER_5 VARCHAR2(240);
81 P_CUSTOM_PARAMETER_6 VARCHAR2(240);
82 P_CUSTOM_PARAMETER_7 VARCHAR2(240);
83 P_CUSTOM_PARAMETER_8 VARCHAR2(240);
84 P_CUSTOM_PARAMETER_9 VARCHAR2(240);
85 P_CUSTOM_PARAMETER_10 VARCHAR2(240);
86 P_CUSTOM_PARAMETER_11 VARCHAR2(240);
87 P_CUSTOM_PARAMETER_12 VARCHAR2(240);
88 P_CUSTOM_PARAMETER_13 VARCHAR2(240);
89 P_CUSTOM_PARAMETER_14 VARCHAR2(240);
90 P_CUSTOM_PARAMETER_15 VARCHAR2(240);
91 /* 16-30 Custom Parameters added for bug12699905 */
92 P_CUSTOM_PARAMETER_16 VARCHAR2(240);
93 P_CUSTOM_PARAMETER_17 VARCHAR2(240);
94 P_CUSTOM_PARAMETER_18 VARCHAR2(240);
95 P_CUSTOM_PARAMETER_19 VARCHAR2(240);
96 P_CUSTOM_PARAMETER_20 VARCHAR2(240);
97 P_CUSTOM_PARAMETER_21 VARCHAR2(240);
98 P_CUSTOM_PARAMETER_22 VARCHAR2(240);
99 P_CUSTOM_PARAMETER_23 VARCHAR2(240);
100 P_CUSTOM_PARAMETER_24 VARCHAR2(240);
101 P_CUSTOM_PARAMETER_25 VARCHAR2(240);
102 P_CUSTOM_PARAMETER_26 VARCHAR2(240);
103 P_CUSTOM_PARAMETER_27 VARCHAR2(240);
104 P_CUSTOM_PARAMETER_28 VARCHAR2(240);
105 P_CUSTOM_PARAMETER_29 VARCHAR2(240);
106 P_CUSTOM_PARAMETER_30 VARCHAR2(240);
107 /* end of changes for bug12699905 */
108
109 P_LANG VARCHAR2(80);
110 P_START_PERIOD_NUM NUMBER;
111 P_END_PERIOD_NUM NUMBER;
112 P_START_DATE DATE;
113 P_END_DATE DATE;
114
115 p_party_col VARCHAR2(2000):=' ';
116 p_party_tab VARCHAR2(1000):=' ';
117 p_party_join VARCHAR2(1000):=' ';
118 p_legal_ent_col VARCHAR2(2000):=' ';
119 p_legal_ent_from VARCHAR2(1000):=' ';
120 p_legal_ent_join VARCHAR2(1000):=' ';
121 p_qualifier_segment VARCHAR2(4000):=' ';
122 p_seg_desc_from VARCHAR2(1000):=' ';
123 p_seg_desc_join VARCHAR2(1000):=' ';
124 p_other_filter VARCHAR2(2000):=' ';
125 p_commercial_query VARCHAR2(32000);
126 p_vat_registration_query VARCHAR2(32000);
127 p_trx_identifiers VARCHAR2(32000):=',NULL';
128
129 --Added for bug 7580995
130 p_trx_identifiers_1 VARCHAR2(32000):= ' ';
131 p_trx_identifiers_2 VARCHAR2(32000):= ' ';
132 p_trx_identifiers_3 VARCHAR2(32000):= ' ';
133 p_trx_identifiers_4 VARCHAR2(32000):= ' ';
134 p_trx_identifiers_5 VARCHAR2(32000):= ' ';
135 --bug-11666797
136 p_bal_err_count NUMBER;
137
138
139
140 FUNCTION beforeReport RETURN BOOLEAN;
141
142 END XLA_TP_BALANCE_RPT_PKG;