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.GL_GLWACCTR_XMLP_PKG

Source


1 PACKAGE GL_GLWACCTR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLWACCTRS.pls 120.1 2008/01/09 07:27:46 vijranga noship $ */
3 	P_LEDGER_ID	number;
4 	P_CURRENCY	varchar2(15);
5 	P_START_DATE	varchar2(32767);
6 	P_END_DATE	varchar2(32767);
7 	P_STATUS	varchar2(32767);
8 	P_DOC_ID	number;
9 	P_DOC_VALUE	number;
10 	P_COA	number;
11 	C_PARAM_START_DATE varchar2(20);
12 	C_PARAM_END_DATE varchar2(20);
13 	C_DATE_FORMAT varchar2(20);
14 	P_AFF_FROM	varchar2(800);
15 	P_AFF_TO	varchar2(800);
16 	P_AMOUNT_FROM	number;
17 	P_AMOUNT_TO	number;
18 	P_SUB_DOC_ID	varchar2(40);
19 	P_SUB_DOC_VALUE	varchar2(40);
20 	P_CONTRA_ACCT	varchar2(25);
21 	P_CONC_REQUEST_ID	number;
22 	P_PAGEBREAK	varchar2(25);
23 	P_SEC_SEG_NUM	varchar2(5);
24 	P_ACTUAL_FLAG	varchar2(1);
25 	P_ACCESS_SET_ID	number;
26 	P_DEBUG	varchar2(5);
27 	P_AMT_FLAG	varchar2(5);
28 	P_CONTRA_FLAG	varchar2(32767);
29 	P_SOURCE	varchar2(50);
30 	P_CATEGORY	varchar2(25);
31 	P_BATCH_NAME	varchar2(100);
32 	P_BAL_SEG_VAL	varchar2(25);
33 	P_START_DOC_VALUE	varchar2(255);
34 	P_END_DOC_VALUE	number;
35 	P_JOURNALS_LINE_FLAG	varchar2(32767);
36 	P_PERIOD_NAME	varchar2(30);
37 	P_LAST_UPDATED_BY	number;
38 	P_REPORT_NAME	varchar2(100);
39 	P_START_UPDATE_DATE	varchar2(32767);
40 	P_LAST_UPDATE_DATE	varchar2(32767);
41 	P_END_UPDATE_DATE	varchar2(32767);
42 	P_PERF_FROM_CLUASE	varchar2(40);
43 	ACCESS_SET_NAME	varchar2(30);
44 	PARAM_CURRENCY_CODE	varchar2(20);
45 	CHART_OF_ACCOUNTS_ID	number;
46 	PARAM_START_DATE	date;
47 	PARAM_END_DATE	date;
48 	PARAM_DOC_SEQ_VALUE	number;
49 	PARAM_AMOUNT_LOW	number;
50 	PARAM_AMOUNT_HIGH	number;
51 	PARAM_SUB_DOC_SEQ_VALUE	number;
52 	SELECT_ACCT_SEGMENT	varchar2(30) := 'cc.segment3' ;
53 	SELECT_BAL_SEGMENT	varchar2(30) := 'cc.segment1' ;
54 	PARAM_SEC_SEG_NAME	varchar2(240);
55 	PARAM_POSTING_STATUS	varchar2(80);
56 	NO_CONTRA_ACCOUNT	varchar2(20);
57 	P_ACC_SEGMENT_WHERE	varchar2(1200);
58 	P_CURRENCY_WHERE	varchar2(200);
59 	P_SEC_SEGMENT_WHERE	varchar2(200);
60 	P_DAS_WHERE	varchar2(600);
61 	SELECT_ACCOUNT	varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10
62 	|| ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n''
63 	|| SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
64 	SELECT_SECONDARY_SEGMENT	varchar2(30) := 'NULL' ;
65 	P_POSTING_STATUS	varchar2(500);
66 	P_HEADER_POSTING_STATUS	varchar2(500);
67 	P_SOURCE_WHERE	varchar2(200);
68 	P_BATCH_WHERE	varchar2(500);
69 	P_CATEGORY_WHERE	varchar2(500);
70 	P_BAL_WHERE	varchar2(500);
71 	P_DOC_ID_WHERE	varchar2(500);
72 	P_DOC_VAL_WHERE	varchar2(500);
73 	P_SUB_DOC_ID_WHERE	varchar2(500);
74 	P_SUB_DOC_VAL_WHERE	varchar2(500);
75 	P_NOT_ZERO_LINE_WHERE	varchar2(500);
76 	P_CONTRA_ACCOUNT_WHERE	varchar2(2000);
77 	P_CONTRA_ACCOUNT	varchar2(255);
78 	P_PERIOD_WHERE	varchar2(2000);
79 	P_JOURNAL_DATE_WHERE	varchar2(2000);
80 	P_JOURNAL_DATE_WHERE_2	varchar2(2000);
81 	P_USE_DATE_COL	varchar2(500);
82 	P_JOURNAL_FROM_CLAUSE	varchar2(4000);
83 	P_JOURNAL_WHERE_CLAUSE	varchar2(2000);
84 	PARAM_SOURCE	varchar2(30);
85 	PARAM_CATEGORY	varchar2(30);
86 	PARAM_BATCH_NAME	varchar2(100);
87 	PARAM_LAST_UPDATED_BY	varchar2(100);
88 	PARAM_BALANCING_SEGMENT	varchar2(30);
89 	PARAM_PERIOD_NAME	varchar2(15);
90 	PARAM_BASIS	varchar2(80);
91 	PARAM_DOC_SEQ_NAME	varchar2(30);
92 	PARAM_ACCT_FROM	varchar2(800);
93 	PARAM_ACCT_TO	varchar2(800);
94 	PARAM_AMT_FLAG	varchar2(80);
95 	PARAM_SUB_DOC_SEQ_NAME	varchar2(30);
96 	PARAM_CONTRA_ACCT	varchar2(30);
97 	PARAM_LEDGER_NAME	varchar2(30);
98 	PARAM_START_DOC_SEQ_VALUE	number;
99 	PARAM_END_DOC_SEQ_VALUE	number;
100 	H_SET_OF_BOOKS_ID	number;
101 	BAL_SEG_NAME_DSP	varchar2(240);
102 	ACCT_SEG_NAME_DSP	varchar2(240);
103 	SELECT_COST_CTR_SEGMENT	varchar2(30) := 'NULL' ;
104 	H_START_DATE	date;
105 	H_END_DATE	date;
106 	PREV_BAL_SEG_VAL	varchar2(20) := 'N' ;
107 	P_LEDGER_WHERE	varchar2(1000);
108 	P_LEDGER_FROM	varchar2(250);
109 	PREV_ACCT_SEG_VAL	varchar2(52) := 'N' ;
110 	PREV_SEC_SEG_VAL	varchar2(20) := '0' ;
111 	PREV_LED_ID	number := 0 ;
112 	PREV_LINE_BAL	number := 0 ;
113 	PREV_GL_BAL	number := 0 ;
114 	P_AFF_WHERE	varchar2(2000);
115 	P_AMOUNT_WHERE	varchar2(1000);
116 	P_AFF_WHERE_JRL	varchar2(4000);
117 	P_ACC_SEGMENT_SELECT	varchar2(2000);
118 	P_JOURNAL_UPD_DATE_WHERE	varchar2(1000);
119 	H_START_UPDATE_DATE	date;
120 	H_END_UPDATE_DATE	date;
121 	P_JOURNAL_LAST_UPD_WHERE	varchar2(400);
122 	P_JOURNAL_DATE_WHERE_3	varchar2(500);
123 	P_HINT_CLAUSE	varchar2(1000);
124 	P_PERF_FROM	varchar2(3000) := 'GL_LEDGERS LGR,        GL_JE_BATCHES   GLB,         GL_JE_HEADERS   GLH,         GL_JE_SOURCES          GJS,         GL_JE_CATEGORIES         GJC,         GL_JE_LINES    GLL,
125 		GL_DAILY_CONVERSION_TYPES      DCT,         FND_DOCUMENT_SEQUENCES  DOCSEQ,          FND_DOCUMENT_SEQUENCES  SUBDOCSEQ,         GL_CODE_COMBINATIONS CC,         FND_USER    FU' ;
126 	P_ACTUAL_TYPE_WHERE	varchar2(500);
127 	function AfterReport return boolean  ;
128 	PROCEDURE SET_DATE_FORMAT  ;
129 	function CF_1Formula return Char  ;
130 	function H_START_PERIOD_DATEFormula return DATE  ;
131 	function H_START_PERIOD_NAMEFormula return Char  ;
132 	function NO_CONTRA_ACCOUNTFormula return Char  ;
133 	function tax_typeformula(TAX_TYPE_CODE in varchar2) return char  ;
134 	function approval_statusformula(APPROVAL_STATUS_CODE in varchar2) return char  ;
135 	function batch_statusformula(BATCH_STATUS_CODE in varchar2) return char  ;
136 	function batch_typeformula(ACTUAL_FLAG in varchar2) return char  ;
137 	function budget_ctrl_statusformula(BUD_CONTROL_STATUS in varchar2) return char  ;
138 	function jrnl_typeformula(AVERAGE_JOURNAL_FLAG in varchar2) return char  ;
139 	function tax_statusformula(TAX_STATUS_CODE in varchar2) return char  ;
140 	function budget_nameformula(BUDGET_VERSION_ID in number) return char  ;
141 	function encumbrance_typeformula(ENCUMBRANCE_TYPE_ID in number) return char  ;
142 	function tax_codeformula(TAX_CODE_ID in number, TAX_TYPE_CODE in varchar2) return char  ;
143 	function contra_acct_valueformula(HDR_ID in number, SUB_DOC_SEQ_ID in number, SUB_DOC_SEQ_VAL in number, ACCOUNTED_DR in number, ACCOUNTED_CR in number) return char  ;
144 	function cf_line_balanceformula(BAL_SEG_VAL in varchar2, ACCT_SEG_VAL in varchar2, ADDITIONAL_SEGMENT_VALUE in varchar2, LEDGER_ID in number, BATCH_STATUS_CODE in varchar2) return number  ;
145 	function cf_gl_balanceformula(BAL_SEG_VAL in varchar2, ACCT_SEG_VAL in varchar2, ADDITIONAL_SEGMENT_VALUE in varchar2, LEDGER_ID in number, BATCH_STATUS_CODE in varchar2) return number  ;
146 	function begin_balanceformula(CF_LINE_BALANCE in number, CF_GL_BALANCE in number) return number  ;
147 	Function ACCESS_SET_NAME_p return varchar2;
148 	Function PARAM_CURRENCY_CODE_p return varchar2;
149 	Function CHART_OF_ACCOUNTS_ID_p return number;
150 	Function PARAM_START_DATE_p return date;
151 	Function PARAM_END_DATE_p return date;
152 	Function PARAM_DOC_SEQ_VALUE_p return number;
153 	Function PARAM_AMOUNT_LOW_p return number;
154 	Function PARAM_AMOUNT_HIGH_p return number;
155 	Function PARAM_SUB_DOC_SEQ_VALUE_p return number;
156 	Function SELECT_ACCT_SEGMENT_p return varchar2;
157 	Function SELECT_BAL_SEGMENT_p return varchar2;
158 	Function PARAM_SEC_SEG_NAME_p return varchar2;
159 	Function PARAM_POSTING_STATUS_p return varchar2;
160 	Function NO_CONTRA_ACCOUNT_p return varchar2;
161 	Function P_ACC_SEGMENT_WHERE_p return varchar2;
162 	Function P_CURRENCY_WHERE_p return varchar2;
163 	Function P_SEC_SEGMENT_WHERE_p return varchar2;
164 	Function P_DAS_WHERE_p return varchar2;
165 	Function SELECT_ACCOUNT_p return varchar2;
166 	Function SELECT_SECONDARY_SEGMENT_p return varchar2;
167 	Function P_POSTING_STATUS_p return varchar2;
168 	Function P_HEADER_POSTING_STATUS_p return varchar2;
169 	Function P_SOURCE_WHERE_p return varchar2;
170 	Function P_BATCH_WHERE_p return varchar2;
171 	Function P_CATEGORY_WHERE_p return varchar2;
172 	Function P_BAL_WHERE_p return varchar2;
173 	Function P_DOC_ID_WHERE_p return varchar2;
174 	Function P_DOC_VAL_WHERE_p return varchar2;
175 	Function P_SUB_DOC_ID_WHERE_p return varchar2;
176 	Function P_SUB_DOC_VAL_WHERE_p return varchar2;
177 	Function P_NOT_ZERO_LINE_WHERE_p return varchar2;
178 	Function P_CONTRA_ACCOUNT_WHERE_p return varchar2;
179 	Function P_CONTRA_ACCOUNT_p return varchar2;
180 	Function P_PERIOD_WHERE_p return varchar2;
181 	Function P_JOURNAL_DATE_WHERE_p return varchar2;
182 	Function P_JOURNAL_DATE_WHERE_2_p return varchar2;
183 	Function P_USE_DATE_COL_p return varchar2;
184 	Function P_JOURNAL_FROM_CLAUSE_p return varchar2;
185 	Function P_JOURNAL_WHERE_CLAUSE_p return varchar2;
186 	Function PARAM_SOURCE_p return varchar2;
187 	Function PARAM_CATEGORY_p return varchar2;
188 	Function PARAM_BATCH_NAME_p return varchar2;
189 	Function PARAM_LAST_UPDATED_BY_p return varchar2;
190 	Function PARAM_BALANCING_SEGMENT_p return varchar2;
191 	Function PARAM_PERIOD_NAME_p return varchar2;
192 	Function PARAM_BASIS_p return varchar2;
193 	Function PARAM_DOC_SEQ_NAME_p return varchar2;
194 	Function PARAM_ACCT_FROM_p return varchar2;
195 	Function PARAM_ACCT_TO_p return varchar2;
196 	Function PARAM_AMT_FLAG_p return varchar2;
197 	Function PARAM_SUB_DOC_SEQ_NAME_p return varchar2;
198 	Function PARAM_CONTRA_ACCT_p return varchar2;
199 	Function PARAM_LEDGER_NAME_p return varchar2;
200 	Function PARAM_START_DOC_SEQ_VALUE_p return number;
201 	Function PARAM_END_DOC_SEQ_VALUE_p return number;
202 	Function H_SET_OF_BOOKS_ID_p return number;
203 	Function BAL_SEG_NAME_DSP_p return varchar2;
204 	Function ACCT_SEG_NAME_DSP_p return varchar2;
205 	Function SELECT_COST_CTR_SEGMENT_p return varchar2;
206 	Function H_START_DATE_p return date;
207 	Function H_END_DATE_p return date;
208 	Function PREV_BAL_SEG_VAL_p return varchar2;
209 	Function P_LEDGER_WHERE_p return varchar2;
210 	Function P_LEDGER_FROM_p return varchar2;
211 	Function PREV_ACCT_SEG_VAL_p return varchar2;
212 	Function PREV_SEC_SEG_VAL_p return varchar2;
213 	Function PREV_LED_ID_p return number;
214 	Function PREV_LINE_BAL_p return number;
215 	Function PREV_GL_BAL_p return number;
216 	Function P_AFF_WHERE_p return varchar2;
217 	Function P_AMOUNT_WHERE_p return varchar2;
218 	Function P_AFF_WHERE_JRL_p return varchar2;
219 	Function P_ACC_SEGMENT_SELECT_p return varchar2;
220 	Function P_JOURNAL_UPD_DATE_WHERE_p return varchar2;
221 	Function H_START_UPDATE_DATE_p return date;
222 	Function H_END_UPDATE_DATE_p return date;
223 	Function P_JOURNAL_LAST_UPD_WHERE_p return varchar2;
224 	Function P_JOURNAL_DATE_WHERE_3_p return varchar2;
225 	Function P_HINT_CLAUSE_p return varchar2;
226 	Function P_PERF_FROM_p return varchar2;
227 	Function P_ACTUAL_TYPE_WHERE_p return varchar2;
228 	FUNCTION BEFOREREPORT RETURN BOOLEAN;
229 END GL_GLWACCTR_XMLP_PKG;
230 
231