1 PACKAGE JL_JLMXFISR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLMXFISRS.pls 120.1 2007/12/25 16:53:46 dwkrishn noship $ */
3 P_BOOK_TYPE_CODE VARCHAR2(40);
4
5 P_END_OF_REPORT VARCHAR2(21);
6
7 P_NO_DATA_FOUND VARCHAR2(21);
8
9 P_PROCESS_ID NUMBER;
10
11 P_CONC_REQUEST_ID NUMBER;
12
13 P_CURR_FY NUMBER;
14
15 P_INCLUDE_DPIS VARCHAR2(32767);
16
17 P_INCLUDE_RET VARCHAR2(32767);
18
19 P_INCLUDE_ZERO_NBV_ASSETS VARCHAR2(32767);
20
21 P_CA_SET_OF_BOOKS_ID NUMBER;
22
23 P_CURRENCY_CODE VARCHAR2(3);
24
25 P_MRCSOBTYPE VARCHAR2(10) := 'P';
26
27 LP_FA_RETIREMENTS VARCHAR2(50);
28
29 LP_FA_DEPRN_SUMMARY VARCHAR2(50) := 'fa_deprn_summary';
30
31 LP_FA_DEPRN_PERIODS VARCHAR2(50) := 'fa_deprn_periods';
32
33 LP_FA_DEPRN_DETAIL VARCHAR2(50) := 'fa_deprn_detail';
34
35 LP_FA_DEFERRED_DEPRN VARCHAR2(50);
36
37 LP_FA_BOOK_CONTROLS VARCHAR2(50) := 'fa_book_controls';
38
39 LP_FA_BOOKS VARCHAR2(50) := 'fa_books';
40
41 LP_FA_ASSET_INVOICES VARCHAR2(50);
42
43 LP_FA_ADJUSTMENTS VARCHAR2(50) := 'fa_adjustments';
44
45 LP_CURRENCY_CODE VARCHAR2(15);
46
47 C_BASE_CURRENCY_CODE VARCHAR2(15);
48
49 C_BASE_PRECISION NUMBER;
50
51 C_BASE_MIN_ACCT_UNIT NUMBER;
52
53 C_BASE_DESCRIPTION VARCHAR2(240);
54
55 C_ORGANIZATION_NAME VARCHAR2(30);
56
57 C_MAX_PERIOD_COUNTER NUMBER;
58
59 C_LAST_PERIOD_COUNTER NUMBER;
60
61 C_FISCAL_START_DATE DATE;
62
63 C_FISCAL_END_DATE DATE;
64
65 C_RATIO_PRECISION NUMBER;
66
67 C_MIN_PERIOD_COUNTER NUMBER;
68
69 CAT_FLEX_STRUCT NUMBER;
70
71 C_USER_ID NUMBER;
72
73 C_ALL_SEGS VARCHAR2(600) := '(segment1|| ''\n'' ||segment2|| ''\n'' ||segment3|| ''\n'' ||segment4|| ''\n'' ||segment5|| ''\n'' ||segment6|| ''\n'' ||segment7)';
74
75 PROCEDURE GET_BASE_CURR_DATA;
76
77 FUNCTION AFTERREPORT RETURN BOOLEAN;
78
79 FUNCTION C_PRICE_INDEXFORMULA(ASSET_CAT_ID IN NUMBER
80 ,ACQDATE IN DATE) RETURN NUMBER;
81
82 FUNCTION C_INDEX_VALUEFORMULA(C_PRICE_INDEX IN NUMBER
83 ,ACQDATE IN DATE) RETURN NUMBER;
84
85 FUNCTION C_CORR_FACTORFORMULA(C_INDEX_VALUE_HALF_PERIOD IN NUMBER
86 ,C_INDEX_VALUE IN NUMBER) RETURN NUMBER;
87
88 FUNCTION C_ACCUM_DEPRN_PREV_YRFORMULA(ASSET_ID IN NUMBER
89 ,PERIOD_COUNTER IN NUMBER
90 ,ORIGINAL_COST IN NUMBER
91 ,RETIREMENT_ID IN NUMBER) RETURN NUMBER;
92
93 FUNCTION C_ADJ_ACCUM_DEPRNFORMULA(C_ACCUM_DEPRN_CURR_YR IN NUMBER
94 ,C_CORR_FACTOR IN NUMBER
95 ,ASSET_ID IN NUMBER
96 ,TRANSACTION_HEADER_ID_IN IN NUMBER
97 ,TRANSACTION_HEADER_ID_OUT IN NUMBER
98 ,DESCRIPTION IN VARCHAR2
99 ,ASSET_CAT_ID IN NUMBER
100 ,ASSET_NUMBER IN VARCHAR2
101 ,ACQDATE IN DATE
102 ,PRORATE_DATE IN DATE
103 ,RETIREMENT_ID IN NUMBER
104 ,C_INDEX_VALUE IN NUMBER
105 ,ORIGINAL_COST IN NUMBER
106 ,C_ACCUM_DEPRN_PREV_YR IN NUMBER
107 ,PERIOD_COUNTER_FULLY_RESERVED IN NUMBER) RETURN NUMBER;
108
109 FUNCTION C_ACCUM_DEPRNFORMULA(STATUS IN VARCHAR2
110 ,TRANSACTION_HEADER_ID_OUT IN NUMBER
111 ,TRANSACTION_HEADER_ID_IN IN NUMBER
112 ,ASSET_ID IN NUMBER
113 ,PERIOD_COUNTER IN NUMBER
114 ,RETIREMENT_ID IN NUMBER
115 ,ORIGINAL_COST IN NUMBER) RETURN NUMBER;
116
117 FUNCTION C_ACCUM_DEPRN_CURR_YRFORMULA(C_ACCUM_DEPRN IN NUMBER
118 ,C_ACCUM_DEPRN_PREV_YR IN NUMBER) RETURN NUMBER;
119
120 FUNCTION C_INDEX_VALUE_HALF_PERIODFORMU(RETIREMENT_ID_1 IN NUMBER
121 ,ACQDATE IN DATE
122 ,C_PRICE_INDEX IN NUMBER) RETURN NUMBER;
123
124 PROCEDURE CUSTOM_INIT;
125
126 PROCEDURE RAISE_ERR(MSGNAME IN VARCHAR2
127 ,ABORT_FLAG IN VARCHAR2);
128
129 PROCEDURE RAISE_ORA_ERR;
130
131 PROCEDURE PRC_PREV_FISCAL_YEAR_DEPRN(P_ASSET_ID IN NUMBER
132 ,P_BOOK_TYPE_CODE IN VARCHAR
133 ,P_PERIOD_START IN NUMBER
134 ,P_PERIOD_END IN NUMBER
135 ,P_PERIOD_COUNTER IN NUMBER
136 ,P_COST_RETIRED IN NUMBER
137 ,P_RETIREMENT_ID IN NUMBER
138 ,P_ACC_DEPRN_PREV_FY OUT NOCOPY NUMBER);
139
140 PROCEDURE PRC_LIFE_TO_DATE_DEPRN(P_ASSET_ID IN NUMBER
141 ,P_BOOK_TYPE_CODE IN VARCHAR
142 ,P_TRANSACTION_HEADER_ID IN NUMBER
143 ,P_PERIOD_START IN NUMBER
144 ,P_PERIOD_END IN NUMBER
145 ,P_PERIOD_COUNTER IN NUMBER
146 ,P_RETIREMENT_ID IN NUMBER
147 ,P_COST_RETIRED IN NUMBER
148 ,P_ACC_DEPRN_LIFE_TD OUT NOCOPY NUMBER);
149
150 FUNCTION CF_RETIREMENT_DATE(RETIREMENT_ID_1 IN NUMBER) RETURN DATE;
151
152 FUNCTION CF_INCLUDE_DPISFORMULA RETURN CHAR;
153
154 function BeforeReport return boolean;
155
156 FUNCTION CF_INCLUDE_RETFORMULA RETURN CHAR;
157
158 FUNCTION CF_INCLUDE_ZERO_NVB_ASSETSFORM RETURN CHAR;
159
160 FUNCTION AFTERPFORM RETURN BOOLEAN;
161
162 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
163
164 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
165
166 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
167
168 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
169
170 FUNCTION C_ORGANIZATION_NAME_P RETURN VARCHAR2;
171
172 FUNCTION C_MAX_PERIOD_COUNTER_P RETURN NUMBER;
173
174 FUNCTION C_LAST_PERIOD_COUNTER_P RETURN NUMBER;
175
176 FUNCTION C_FISCAL_START_DATE_P RETURN DATE;
177
178 FUNCTION C_FISCAL_END_DATE_P RETURN DATE;
179
180 FUNCTION C_RATIO_PRECISION_P RETURN NUMBER;
181
182 FUNCTION C_MIN_PERIOD_COUNTER_P RETURN NUMBER;
183
184 FUNCTION CAT_FLEX_STRUCT_P RETURN NUMBER;
185
186 FUNCTION C_USER_ID_P RETURN NUMBER;
187
188 FUNCTION C_ALL_SEGS_P RETURN VARCHAR2;
189
190 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
191 ,NAME IN VARCHAR2);
192
193 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
194 ,VALUE IN VARCHAR2
195 ,TRANSLATE IN BOOLEAN);
196
197 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
198
199 PROCEDURE CLEAR;
200
201 FUNCTION GET_STRING(APPIN IN VARCHAR2
202 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
203
204 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
205 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
206
207 FUNCTION GET RETURN VARCHAR2;
208
209 FUNCTION GET_ENCODED RETURN VARCHAR2;
210
211 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
212 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
213 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
214
215 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
216
217 PROCEDURE RAISE_ERROR;
218
219 END JL_JLMXFISR_XMLP_PKG;
220
221
222