eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AR_RAXGLA_XMLP_PKG

Source


1 PACKAGE AR_RAXGLA_XMLP_PKG AS
2 /* $Header: RAXGLAS.pls 120.0 2007/12/27 14:19:54 abraghun noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SORT_BY VARCHAR2(50);
6 
7   P_START_GL_DATE DATE;
8 
9   P_END_GL_DATE DATE;
10 
11   P_CURRENCY_CODE VARCHAR2(32767);
12 
13   P_COMPANY_START VARCHAR2(50);
14 
15   P_COMPANY_END VARCHAR2(50);
16 
17   P_GL_ACCOUNT_TYPE VARCHAR2(32767);
18 
19   P_POSTING_STATUS VARCHAR2(32767);
20 
21   P_WHERE_1 VARCHAR2(200):=' ';
22 
23   P_SELECT_1 VARCHAR2(1000) := 'NULL,NULL';
24 
25   P_WHERE_GL_TYPE VARCHAR2(200):=' ';
26 
27   P_COAID NUMBER;
28 
29   LP_COMPANY_START VARCHAR2(500):=' ';
30 
31   LP_COMPANY_END VARCHAR2(500):=' ';
32 
33   ACCT_FLEX_ALL_SEG_SEL VARCHAR2(500):=' ';
34 
35   ACCT_FLEX_BAL_SEG_SEL VARCHAR2(500):=' ';
36 
37   ACCT_FLEX_ACCT_SEG_SEL VARCHAR2(500):=' ';
38 
39   ACCT_FLEX_ALL_SEG_OB VARCHAR2(500):=' ';
40 
41   ACCT_FLEX_ACCT_SEG_OB VARCHAR2(500):=' ';
42 
43   ACCT_FLEX_BAL_SEG_OB VARCHAR2(500):=' ';
44 
45   P_GLDATE_LOW DATE;
46 
47   P_GLDATE_HIGH DATE;
48 
49   LP_START_GL_DATE VARCHAR2(500):=' ';
50 
51   LP_END_GL_DATE VARCHAR2(500):=' ';
52 
53   P_REPORT_BY_LINE VARCHAR2(32767);
54 
55   P_LINE_NUMBER VARCHAR2(5000) := 'to_char(lines.line_number)';
56 
57   P_LINE_NUMBER_ORDER VARCHAR2(5000) := 'null';
58 
59   P_TRX_DATE_HIGH DATE;
60 
61   P_TRX_DATE_LOW DATE;
62 
63   LP_TRX_DATE_LOW VARCHAR2(200):=' ';
64 
65   LP_TRX_DATE_HIGH VARCHAR2(200):=' ';
66 
67   LP_TRX_TYPE_LOW VARCHAR2(200):=' ';
68 
69   P_TRX_TYPE_LOW VARCHAR2(200);
70 
71   P_TRX_TYPE_HIGH VARCHAR2(200);
72 
73   LP_TRX_TYPE_HIGH VARCHAR2(200):=' ';
74 
75   P_TRX_NUMBER_LOW VARCHAR2(200);
76 
77   P_TRX_NUMBER_HIGH VARCHAR2(200);
78 
79   LP_TRX_NUMBER_LOW VARCHAR2(200):=' ';
80 
81   P_CUSTOMER_LOW VARCHAR2(200);
82 
83   LP_TRX_NUMBER_HIGH VARCHAR2(200):=' ';
84 
85   P_CUSTOMER_HIGH VARCHAR2(200);
86 
87   LP_CUSTOMER_LOW VARCHAR2(200):=' ';
88 
89   LP_CUSTOMER_HIGH VARCHAR2(200):=' ';
90 
91   LP_CUSTOMER_NUMBER_HIGH VARCHAR2(200):=' ';
92 
93   LP_CUSTOMER_NUMBER_LOW VARCHAR2(200):=' ';
94 
95   P_CUSTOMER_NUMBER_HIGH VARCHAR2(100);
96 
97   P_CUSTOMER_NUMBER_LOW VARCHAR2(100);
98 
99   P_REPORTING_ENTITY_ID NUMBER;
100 
101   P_REPORTING_ENTITY_NAME VARCHAR2(200);
102 
103   P_REPORTING_LEVEL VARCHAR2(30);
104 
105   P_REPORTING_LEVEL_NAME VARCHAR2(30);
106 
107   P_ORG_WHERE_LINES VARCHAR2(2000):=' ';
108 
109   P_ORG_WHERE_TRX VARCHAR2(2000):=' ';
110 
111   P_ORG_WHERE_LINK_LINE VARCHAR2(2000):=' ';
112 
113   P_ORG_WHERE_C VARCHAR2(2000):=' ';
114 
115   P_ORG_WHERE_GL_DIST VARCHAR2(2000):=' ';
116 
117   P_CA_ORG_ID NUMBER;
118 
119   P_CA_SET_OF_BOOKS_ID NUMBER;
120 
121   P_ZERO_ROUND VARCHAR2(1);
122 
123   LP_ZERO_ROUND VARCHAR2(2000):=' ';
124 
125   CUST_NAME VARCHAR2(50);
126 
127   CUST_DR NUMBER;
128 
129   CUST_CR NUMBER;
130 
131   D_CUST_DR VARCHAR2(14);
132 
133   D_CUST_CR VARCHAR2(14);
134 
135   CUST_CURR VARCHAR2(15);
136 
137   P_ORG_WHERE_PARAM VARCHAR2(4000);
138 
139   ACCT_BAL_APROMPT VARCHAR2(80);
140 
141   RP_COMPANY_NAME VARCHAR2(50);
142 
143   RP_REPORT_NAME VARCHAR2(80);
144 
145   RP_DATA_FOUND VARCHAR2(3);
146 
147   RP_REPORT_SUBTITLE VARCHAR2(60);
148 
149   GSUM_CURR_CR_AMT VARCHAR2(16);
150 
151   GSUM_CURR_DR_AMT VARCHAR2(16);
152 
153   C_CURR_CODE_REV VARCHAR2(32767) := 'USD';
154 
155   RP_REPORT_BY_LINE_MEANING VARCHAR2(80);
156 
157   C_DATA_FOUND_FLAG VARCHAR2(32767) := 'N';
158 
159   RP_MESSAGE VARCHAR2(2000);
160 
161   CP_ACC_MESSAGE VARCHAR2(2000);
162 
163   FUNCTION BEFOREREPORT RETURN BOOLEAN;
164 
165   FUNCTION AFTERREPORT RETURN BOOLEAN;
166 
167   FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
168 
169   FUNCTION REPORT_SUBTITLEFORMULA RETURN VARCHAR2;
170 
171   FUNCTION C_SUM_TEXTFORMULA RETURN VARCHAR2;
172 
173   FUNCTION FILTER_NULL RETURN BOOLEAN;
174 
175   FUNCTION SET_CURR_CODE_REVFORMULA(CURRENCY_CODE_REV IN VARCHAR2) RETURN VARCHAR2;
176 
177   FUNCTION C_REPORT_BY_LINE_MEANINGFORMUL RETURN VARCHAR2;
178 
179   FUNCTION AFTERPFORM RETURN BOOLEAN;
180 
181   FUNCTION LINE_NUMBER_DISPLAYFORMULA(LINE_NUMBER IN VARCHAR2) RETURN VARCHAR2;
182 
183   FUNCTION OUT_OF_BALANCEFORMULA(SUM_CURR_CR_AMT_SEG_REV IN NUMBER
184                                 ,SUM_CURR_DR_AMT_SEG_REV IN NUMBER) RETURN VARCHAR2;
185 
186   FUNCTION C_POSTING_STATUS_MEANINGFORMUL RETURN VARCHAR2;
187 
188   FUNCTION C_GL_ACCOUNT_TYPE_MEANINGFORMU RETURN VARCHAR2;
189 
190   FUNCTION C_ORDER_BY_MEANINGFORMULA RETURN VARCHAR2;
191 
192   FUNCTION BEFOREPFORM RETURN BOOLEAN;
193 
194   FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
195 
196   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
197 
198   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
199 
200   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
201 
202   FUNCTION RP_REPORT_SUBTITLE_P RETURN VARCHAR2;
203 
204   FUNCTION GSUM_CURR_CR_AMT_P RETURN VARCHAR2;
205 
206   FUNCTION GSUM_CURR_DR_AMT_P RETURN VARCHAR2;
207 
208   FUNCTION C_CURR_CODE_REV_P RETURN VARCHAR2;
209 
210   FUNCTION RP_REPORT_BY_LINE_MEANING_P RETURN VARCHAR2;
211 
212   FUNCTION C_DATA_FOUND_FLAG_P RETURN VARCHAR2;
213 
214   FUNCTION RP_MESSAGE_P RETURN VARCHAR2;
215 
216   FUNCTION CP_ACC_MESSAGE_P RETURN VARCHAR2;
217 
218 END AR_RAXGLA_XMLP_PKG;
219