[Home] [Help]
PACKAGE: APPS.JE_JEFIASDR_XMLP_PKG
Source
1 PACKAGE JE_JEFIASDR_XMLP_PKG AS
2 /* $Header: JEFIASDRS.pls 120.2 2008/01/08 10:05:37 vijranga noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_SET_OF_BOOKS_ID VARCHAR2(15);
6
7 P_TAX_BOOK VARCHAR2(30);
8
9 P_PERIOD_NAME VARCHAR2(15);
10
11 P_REPORT_TYPE VARCHAR2(30);
12
13 P_AS_NUM_HIGH VARCHAR2(40);
14
15 P_AS_NUM_LOW VARCHAR2(40);
16
17 C_ACCT_FLEX_STRUCT NUMBER;
18
19 C_ACCT_FLEX_BAL_SEG VARCHAR2(240);
20
21 C_SET_OF_BOOKS_ID NUMBER;
22
23 C_SOB_NAME VARCHAR2(50);
24
25 C_CAT_FLEX_STRUCT NUMBER;
26
27 C_ASSET_KEY_STRUCT NUMBER;
28
29 C_BOOK_TYPE_CODE VARCHAR2(32767);
30
31 C_DISTRIBUTION_SOURCE_BOOK VARCHAR2(15);
32
33 C_CURRENCY_CODE VARCHAR2(30);
34
35 C_PRECISION NUMBER;
36
37 C_COST_COMPANY VARCHAR2(200);
38
39 P_CATEGORY_FLEX_FROM VARCHAR2(60);
40
41 P_CATEGORY_FLEX_TO VARCHAR2(60);
42
43 C_WHERE_CAT_FLEX VARCHAR2(240);
44
45 C_MAJOR_CATEGORY VARCHAR2(600);
46
47 C_ALL_CATEGORY VARCHAR2(200);
48
49 C_COST_ACCOUNT VARCHAR2(100);
50
51 C_REPORT_DATE VARCHAR2(32767);
52
53 C_START_DATE DATE;
54
55 C_CLOSE_DATE DATE;
56
57 C_FISCAL_YEAR VARCHAR2(32767);
58
59 C_START_COUNTER NUMBER;
60
61 C_END_COUNTER NUMBER;
62
63 C_FROM_OPEN_DATE DATE;
64
65 C_FROM_CLOSE_DATE DATE;
66
67 C_FROM_COUNTER NUMBER;
68
69 C_CALENDAR_OPEN_DATE DATE;
70
71 C_CALENDAR_CLOSE_DATE DATE;
72
73 C_FROM_FISCAL_YEAR VARCHAR2(4);
74
75 C_TO_COUNTER NUMBER;
76
77 C_TO_OPEN_DATE DATE;
78
79 C_TO_CLOSE_DATE DATE;
80
81 C_TO_FISCAL_YEAR VARCHAR2(4);
82
83 C_COST_ACCT_DESC VARCHAR2(50);
84
85 C_ASSET_WHERE VARCHAR2(240);
86
87 C_TIME_TO_CLOSE_DATE DATE;
88
89 C_CORP_FROM_COUNTER NUMBER;
90
91 C_CORP_TO_COUNTER NUMBER;
92
93 C_CORP_CALENDAR_OPEN_DATE DATE;
94
95 C_CORP_CALENDAR_CLOSE_DATE DATE;
96
97 C_CORP_TO_OPEN_DATE DATE;
98
99 C_CORP_TO_CLOSE_DATE DATE;
100
101 C_CORP_TIME_TO_CLOSE_DATE DATE;
102
103 P_DEBUG_SWITCH VARCHAR2(1);
104
105 C_DISTRIBUTION_CORP_BOOK VARCHAR2(40);
106
107 STRUCT_NUM VARCHAR2(15) := '101';
108
109 SET_OF_BOOKS_NAME VARCHAR2(30);
110
111 SELECT_ALL VARCHAR2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10
112 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n''
113 || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
114
115 WHERE_FLEX VARCHAR2(4000) := 'CC.SEGMENT11 BETWEEN ''00'' and ''11''';
116
117 ORDERBY_ACCT VARCHAR2(30) := 'CC.SEGMENT10';
118
119 PRECISION NUMBER := 0;
120
121 FUNC_CURRENCY VARCHAR2(25);
122
123 C_BOOK_CLASS VARCHAR2(32);
124
125 C_ACCOUNT_FLEX_ID NUMBER;
126
127 CP_CLOSE_DATE DATE;
128
129 CP_LASTYR_BEGIN_PERIOD_COUNTER NUMBER;
130
131 CP_REPORT_NAME VARCHAR2(80);
132
133 CP_FROM_FISCAL_YEAR VARCHAR2(32767);
134
135 CP_PERIOD_NAME VARCHAR2(20);
136
137 CP_TAX_BOOK VARCHAR2(50);
138
139 CP_DISTRIBUTION_CORP_BOOK VARCHAR2(50);
140
141 CP_CURRENCY_CODE VARCHAR2(20);
142
143 CP_SOB_NAME VARCHAR2(50);
144
145 CP_CALENDAR_OPEN_DATE VARCHAR2(20);
146
147 CP_CALENDAR_CLOSE_DATE VARCHAR2(20);
148
149 CP_REPORT_TYPE VARCHAR2(20);
150
151 FUNCTION BEFOREREPORT RETURN BOOLEAN;
152
153 FUNCTION C_COST_ACCT_DESCFORMULA(COST_ACCOUNT IN VARCHAR2) RETURN VARCHAR2;
154
155 FUNCTION CF_ASSET_CLOSE_NBVFORMULA(CF_ASS_INITIAL_NBV_ADJUSTED IN NUMBER
156 ,CF_ASS_TAX_ADDITIONS IN NUMBER
157 ,CS_ASS_TAX_RETIREMENT IN NUMBER
158 ,A1_1 IN NUMBER
159 ,CF_ASS_DEF_DP IN NUMBER) RETURN NUMBER;
160
161 FUNCTION AFTERREPORT RETURN BOOLEAN;
162
163 FUNCTION AFTERPFORM RETURN BOOLEAN;
164
165 PROCEDURE GET_THE_ACCT_DESC(P_ACCOUNT IN VARCHAR2
166 ,P_DESCR OUT NOCOPY VARCHAR2);
167
168 FUNCTION CF_F_CAT_CORP_GAINFORMULA(CS_F_CAT_CORP_SALES_PROCEEDS IN NUMBER
169 ,CS_F_CAT_RETIREMENT IN NUMBER) RETURN NUMBER;
170
171 FUNCTION CF_F_ASSET_COST_ENDFORMULA(CS_F_CAT_CORP_COST IN NUMBER
172 ,CS_F_CAT_CORP_ADDITION IN NUMBER
173 ,CS_F_CAT_CORP_RETIREMENT IN NUMBER) RETURN NUMBER;
174
175 FUNCTION CF_F_CAT_CORP_DEPRN_RESERVEFOR(CS_F_CAT_CORP_DEPRN_RESERVE IN NUMBER
176 ,CF_F_CAT_CP_YTD IN NUMBER
177 ,CS_F_CAT_CORP_RET_RESERVE IN NUMBER) RETURN NUMBER;
178
179 FUNCTION CF_F_CAT_NBV_STARTFORMULA(CS_F_CAT_CORP_COST IN NUMBER
180 ,CS_F_CAT_CORP_DEPRN_RESERVE IN NUMBER) RETURN NUMBER;
181
182 FUNCTION CF_F_CAT_NBV_ENDFORMULA(CF_F_CAT_ASSET_COST_END IN NUMBER
183 ,CF_F_CAT_CORP_DEPRN_RESERVE IN NUMBER) RETURN NUMBER;
184
185 FUNCTION CF_F_CAT_CORP_DEPN_RESERVEFORM(CS_F_CAT_TAX_DEPRN_RESERVE IN NUMBER
186 ,CS_F_CAT_CORP_DEPRN_RESERVE IN NUMBER) RETURN NUMBER;
187
188 FUNCTION CF_F_CAT_DEF_DEPRN_YTDFORMULA(CF_F_CAT_TAX_YTD_DEP IN NUMBER
189 ,CF_F_CAT_CP_YTD IN NUMBER) RETURN NUMBER;
190
191 FUNCTION CF_F_CAT_DEFERRED_DEPRNFORMULA(CF_F_CAT_CORP_DEPN_RESERVE IN NUMBER
192 ,CF_F_CAT_DEF_DEPRN_YTD IN NUMBER
193 ,CS_F_CAT_CORP_RET_RESERVE IN NUMBER) RETURN NUMBER;
194
195 FUNCTION CF_F_CAT_RETIREMENTSFORMULA(CS_F_CAT_CORP_SALES_PROCEEDS IN NUMBER
196 ,CS_F_CAT_CORP_NBV_RETIRED IN NUMBER) RETURN NUMBER;
197
198 FUNCTION CF_ASS_TAX_ADDITIONSFORMULA(CS_ASS_TAX_ADDITIONS IN NUMBER) RETURN NUMBER;
199
200 FUNCTION CF_ASS_CORP_ADDITIONSFORMULA(CS_ASS_CORP_ADDITIONS IN NUMBER) RETURN NUMBER;
201
202 FUNCTION CF_ASS_DEF_DPFORMULA(CS_ASS_TAX_DEPRN IN NUMBER
203 ,A1_1 IN NUMBER
204 ,CS_ASS_THIS_FISADJ IN NUMBER) RETURN NUMBER;
205
206 FUNCTION CF_F_CAT_CP_YTDFORMULA(CS_F_CAT_CORP_YTD_DEPRN IN NUMBER) RETURN NUMBER;
207
208 FUNCTION CF_F_CAT_TAX_YTD_DEPFORMULA(CS_F_CAT_TAX_YTD_DEPRN IN NUMBER
209 ,CS_F_CAT_TAX_RESERVE_RETIRED IN NUMBER) RETURN NUMBER;
210
211 FUNCTION CF_F_CAT_RETIRE_DIFFFORMULA(CS_F_CAT_CORP_RET_RESERVE IN NUMBER
212 ,CS_F_CAT_TAX_RESERVE_RETIRED IN NUMBER) RETURN NUMBER;
213
214 FUNCTION CF_1FORMULA0029(CF_F_CAT_CORP_DEPN_RESERVE IN NUMBER
215 ,CS_CAT_DEF_DEPRN IN NUMBER
216 ,CF_F_CAT_RETIRE_DIFF IN NUMBER) RETURN NUMBER;
217
218 FUNCTION CF_ASS_INITIAL_NBV_ADJUSTEDFOR(ASSET_NUMBER IN VARCHAR2
219 ,CAT_ID IN NUMBER
220 ,ENABLED_FLAG IN VARCHAR2
221 ,INITIAL_NBV IN NUMBER
222 ,CS_ASS_FISCAL_ADJUSTMENT IN NUMBER) RETURN NUMBER;
223
224 FUNCTION CF_ASS_TAX_DP_RESERVE_ADJUSTED(TAX_DP_RESERVE IN NUMBER
225 ,CS_ASS_FISCAL_ADJUSTMENT IN NUMBER) RETURN NUMBER;
226
227 FUNCTION CF_REPORT_DATEFORMULA RETURN CHAR;
228
229 FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
230
231 FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
232
233 FUNCTION SELECT_ALL_P RETURN VARCHAR2;
234
235 FUNCTION WHERE_FLEX_P RETURN VARCHAR2;
236
237 FUNCTION ORDERBY_ACCT_P RETURN VARCHAR2;
238
239 FUNCTION PRECISION_P RETURN NUMBER;
240
241 FUNCTION FUNC_CURRENCY_P RETURN VARCHAR2;
242
243 FUNCTION C_BOOK_CLASS_P RETURN VARCHAR2;
244
245 FUNCTION C_ACCOUNT_FLEX_ID_P RETURN NUMBER;
246
247 FUNCTION CP_CLOSE_DATE_P RETURN DATE;
248
249 FUNCTION CP_LASTYR_BEGIN_PERIOD_COUNTE RETURN NUMBER;
250
251 FUNCTION CP_REPORT_NAME_P RETURN VARCHAR2;
252
253 FUNCTION CP_FROM_FISCAL_YEAR_P RETURN VARCHAR2;
254
255 FUNCTION CP_PERIOD_NAME_P RETURN VARCHAR2;
256
257 FUNCTION CP_TAX_BOOK_P RETURN VARCHAR2;
258
259 FUNCTION CP_DISTRIBUTION_CORP_BOOK_P RETURN VARCHAR2;
260
261 FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
262
263 FUNCTION CP_SOB_NAME_P RETURN VARCHAR2;
264
265 FUNCTION CP_CALENDAR_OPEN_DATE_P RETURN VARCHAR2;
266
267 FUNCTION CP_CALENDAR_CLOSE_DATE_P RETURN VARCHAR2;
268
269 FUNCTION CP_REPORT_TYPE_P RETURN VARCHAR2;
270
271 END JE_JEFIASDR_XMLP_PKG;
272
273
274