PACKAGE: APPS.JL_JLMXFIMP_XMLP_PKG

Source

1 PACKAGE JL_JLMXFIMP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLMXFIMPS.pls 120.1 2007/12/25 16:53:16 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_FULLY_DEPRN_ASSETS VARCHAR2(32767);
20 
21   P_INCLUDE_ZERO_NBV_ASSETS VARCHAR2(32767);
22 
23   P_CA_SET_OF_BOOKS_ID NUMBER;
24 
25   LP_CURRENCY_CODE VARCHAR2(15);
26 
27   P_CA_ORG_ID VARCHAR2(15);
28 
29   function BeforeReport return boolean;
30 
31   P_MRCSOBTYPE VARCHAR2(10) := 'P';
32 
33   LP_FA_RETIREMENTS VARCHAR2(50);
34 
35   LP_FA_DEPRN_SUMMARY VARCHAR2(50) := 'fa_deprn_summary';
36 
37   LP_FA_DEPRN_PERIODS VARCHAR2(50) := 'fa_deprn_periods';
38 
39   LP_FA_DEFERRED_DEPRN VARCHAR2(50);
40 
41   LP_FA_BOOK_CONTROLS VARCHAR2(50) := 'fa_book_controls';
42 
43   LP_FA_BOOKS VARCHAR2(50) := 'fa_books';
44 
45   LP_FA_DEPRN_DETAIL VARCHAR2(50) := 'fa_deprn_detail';
46 
47   LP_FA_ASSET_INVOICES VARCHAR2(50);
48 
49   LP_FA_ADJUSTMENTS VARCHAR2(50) := 'fa_adjustments';
50 
51   C_BASE_CURRENCY_CODE VARCHAR2(15);
52 
53   C_BASE_PRECISION NUMBER;
54 
55   C_BASE_MIN_ACCT_UNIT NUMBER;
56 
57   C_BASE_DESCRIPTION VARCHAR2(240);
58 
59   C_ORGANIZATION_NAME VARCHAR2(30);
60 
61   C_CURR_FISCAL_YRX NUMBER;
62 
63   CAT_FLEX_STRUCT NUMBER;
64 
65   C_RATIO_PRECISION NUMBER;
66 
67   C_ALL_SEGS VARCHAR2(600) := '(segment1|| ''\n'' ||segment2|| ''\n'' ||segment3|| ''\n'' ||segment4|| ''\n'' ||segment5|| ''\n'' ||segment6|| ''\n'' ||segment7)';
68 
69   PERIODS_PER_FY NUMBER;
70 
71   MIN_PERIOD_COUNTER NUMBER;
72 
73   MAX_PERIOD_COUNTER NUMBER;
74 
75   C_INI_MID_YR DATE;
76 
77   C_END_MID_YR DATE;
78 
79   C_FISCAL_START_DATE DATE;
80 
81   C_FISCAL_END_DATE DATE;
82 
83   PROCEDURE GET_BASE_CURR_DATA;
84 
85   FUNCTION AFTERREPORT RETURN BOOLEAN;
86 
87   FUNCTION C_PRICE_INDEXFORMULA(ASSET_CATEGORY IN NUMBER
88                                ,ACQDATE IN DATE) RETURN NUMBER;
89 
90   FUNCTION C_INDEX_VALUE_JUNEFORMULA(C_PRICE_INDEX IN NUMBER) RETURN NUMBER;
91 
92   FUNCTION C_CORR_FACTORFORMULA(ACQDATE IN DATE
93                                ,C_INDEX_VALUE_JUNE IN NUMBER
94                                ,INPC IN NUMBER) RETURN NUMBER;
95 
96   FUNCTION C_ADJ_NBV_LESS_50PERFORMULA(C_ADJ_NBV_END_PREV_FY IN NUMBER
97                                       ,C_50PER_ADJ_DEPRN_CURR_FY IN NUMBER) RETURN NUMBER;
98 
99   FUNCTION C_ADJ_NBV_END_PREV_FYFORMULA(C_NBV_END_PREV_FY IN NUMBER
100                                        ,C_CORR_FACTOR IN NUMBER) RETURN NUMBER;
101 
102   FUNCTION C_50PER_ADJ_DEPRN_CURR_FYFORMU(ADJUSTED_DEPRN_CURRENT_FY IN NUMBER) RETURN NUMBER;
103 
104   FUNCTION C_IMPAC_BASE_VALUEFORMULA(ACQDATE IN DATE
105                                     ,RETIREMENT_ID_1 IN NUMBER
106                                     ,CF_RETIREMENT_DATE IN DATE
107                                     ,PERIOD_COUNTER_FULLY_RESERVED IN NUMBER
108                                     ,C_ADJ_NBV_LESS_50PER IN NUMBER) RETURN NUMBER;
109 
110   FUNCTION C_NBV_END_PREV_FYFORMULA(ORIGINAL_COST IN NUMBER
111                                    ,ACCUM_DEPRN_PREVIOUS_FY IN NUMBER) RETURN NUMBER;
112 
113   PROCEDURE CUSTOM_INIT;
114 
115   PROCEDURE RAISE_ORA_ERR;
116 
117   PROCEDURE RAISE_ERR(MSGNAME IN VARCHAR2
118                      ,ABORT_FLAG IN VARCHAR2);
119 
120   FUNCTION C_INDEX_VALUE_ACQFORMULA(C_PRICE_INDEX IN NUMBER
121                                    ,ACQDATE IN DATE) RETURN NUMBER;
122 
123   FUNCTION CF_RETIREMENT_DATE(RETIREMENT_ID_1 IN NUMBER) RETURN DATE;
124 
125   FUNCTION CF_INCLUDE_DPISFORMULA RETURN CHAR;
126 
127   FUNCTION CF_INCLUDE_RETFORMULA RETURN CHAR;
128 
129   FUNCTION CF_FULLY_DEPRN_ASSETFORMULA RETURN CHAR;
130 
131   FUNCTION CF_INCLUDE_ZERO_NBV_ASSETSFORM RETURN CHAR;
132 
133   FUNCTION AFTERPFORM RETURN BOOLEAN;
134 
135   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
136 
137   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
138 
139   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
140 
141   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
142 
143   FUNCTION C_ORGANIZATION_NAME_P RETURN VARCHAR2;
144 
145   FUNCTION C_CURR_FISCAL_YRX_P RETURN NUMBER;
146 
147   FUNCTION CAT_FLEX_STRUCT_P RETURN NUMBER;
148 
149   FUNCTION C_RATIO_PRECISION_P RETURN NUMBER;
150 
151   FUNCTION C_ALL_SEGS_P RETURN VARCHAR2;
152 
153   FUNCTION PERIODS_PER_FY_P RETURN NUMBER;
154 
155   FUNCTION MIN_PERIOD_COUNTER_P RETURN NUMBER;
156 
157   FUNCTION MAX_PERIOD_COUNTER_P RETURN NUMBER;
158 
159   FUNCTION C_INI_MID_YR_P RETURN DATE;
160 
161   FUNCTION C_END_MID_YR_P RETURN DATE;
162 
163   FUNCTION C_FISCAL_START_DATE_P RETURN DATE;
164 
165   FUNCTION C_FISCAL_END_DATE_P RETURN DATE;
166 
167   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
168                     ,NAME IN VARCHAR2);
169 
170   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
171                      ,VALUE IN VARCHAR2
172                      ,TRANSLATE IN BOOLEAN);
173 
174   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
175 
176   PROCEDURE CLEAR;
177 
178   FUNCTION GET_STRING(APPIN IN VARCHAR2
179                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
180 
181   FUNCTION GET_NUMBER(APPIN IN VARCHAR2
182                      ,NAMEIN IN VARCHAR2) RETURN NUMBER;
183 
184   FUNCTION GET RETURN VARCHAR2;
185 
186   FUNCTION GET_ENCODED RETURN VARCHAR2;
187 
188   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
189                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
190                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
191 
192   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
193 
194   PROCEDURE RAISE_ERROR;
195 
196 END JL_JLMXFIMP_XMLP_PKG;
197 
198