PACKAGE: APPS.JL_JLMXFGLR_XMLP_PKG

Source

1 PACKAGE JL_JLMXFGLR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLMXFGLRS.pls 120.1 2007/12/25 16:52:46 dwkrishn noship $ */
3   P_BOOK_TYPE_CODE VARCHAR2(15);
4 
5   P_END_OF_REPORT VARCHAR2(21);
6 
7   P_NO_DATA_FOUND VARCHAR2(21);
8 
9   P_CONC_REQUEST_ID NUMBER := 0;
10 
11   P_CURR_FY NUMBER;
12 
13   FY_START_DATE VARCHAR2(40);
14 
15   FY_END_DATE VARCHAR2(40);
16 
17   P_INCLUDE_DPIS VARCHAR2(32767);
18 
19   P_INCLUDE_RET VARCHAR2(32767);
20 
21   P_CA_SET_OF_BOOKS_ID NUMBER;
22 
23   LP_CURRENCY_CODE VARCHAR2(15);
24 
25   P_CA_ORG_ID VARCHAR2(15);
26 
27   P_MRCSOBTYPE VARCHAR2(10) := 'P';
28 
29   LP_FA_RETIREMENTS VARCHAR2(50);
30 
31   LP_FA_DEPRN_SUMMARY VARCHAR2(50) := 'fa_deprn_summary';
32 
33   LP_FA_DEPRN_PERIODS VARCHAR2(50) := 'fa_deprn_periods';
34 
35   LP_FA_DEPRN_DETAIL VARCHAR2(50) := 'fa_deprn_detail';
36 
37   LP_FA_DEFERRED_DEPRN VARCHAR2(50);
38 
39   LP_FA_BOOK_CONTROLS VARCHAR2(50) := 'fa_book_controls';
40 
41   LP_FA_BOOKS VARCHAR2(50) := 'fa_books';
42 
43   LP_FA_ASSET_INVOICES VARCHAR2(50);
44 
45   LP_FA_ADJUSTMENTS VARCHAR2(50) := 'fa_adjustments';
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_CURR_FISCAL_YR NUMBER;
58 
59   C_CURR_PERIOD_COUNTER NUMBER;
60 
61   C_LAST_PERIOD_COUNTER NUMBER;
62 
63   C_RATIO_PRECISION NUMBER;
64 
65   C_MIN_PERIOD_COUNTER NUMBER;
66 
67   C_MAX_PERIOD_COUNTER NUMBER;
68 
69   C_FISCAL_START_DATE DATE;
70 
71   C_FISCAL_END_DATE DATE;
72 
73   FUNCTION BEFOREREPORT RETURN BOOLEAN;
74 
75   PROCEDURE GET_BASE_CURR_DATA;
76 
77   FUNCTION AFTERREPORT RETURN BOOLEAN;
78 
79   FUNCTION C_PRICE_INDEXFORMULA(ASSET_CATEGORY 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                                        ,RETIREMENT_ID IN NUMBER
91                                        ,ORIGINAL_COST IN NUMBER) RETURN NUMBER;
92 
93   FUNCTION C_ADJ_NBVFORMULA(ORIGINAL_COST IN NUMBER
94                            ,C_ACCUM_DEPRN_CURR_YR IN NUMBER
95                            ,C_ACCUM_DEPRN_PREV_YR IN NUMBER
96                            ,C_CORR_FACTOR IN NUMBER) RETURN NUMBER;
97 
98   FUNCTION C_NBVFORMULA(ASSET_ID IN NUMBER
99                        ,TRANSACTION_HEADER_ID IN NUMBER
100                        ,PERIOD_COUNTER IN NUMBER
101                        ,RETIREMENT_ID IN NUMBER
102                        ,ORIGINAL_COST IN NUMBER) RETURN NUMBER;
103 
104   FUNCTION C_ACCUM_DEPRN_CURR_YRFORMULA(C_NBV IN NUMBER
105                                        ,C_ACCUM_DEPRN_PREV_YR IN NUMBER) RETURN NUMBER;
106 
107   FUNCTION C_INDEX_VALUE_HALF_PERIODFORMU(ACQDATE IN DATE
108                                          ,DATE_RETIRED IN DATE
109                                          ,C_PRICE_INDEX IN NUMBER) RETURN NUMBER;
110 
111   PROCEDURE CUSTOM_INIT;
112 
113   FUNCTION C_GAIN_LOSSFORMULA(C_ADJ_NBV IN NUMBER
114                              ,C_PROC_SALE IN NUMBER) RETURN NUMBER;
115 
116   FUNCTION C_RET_DATEFORMULA RETURN DATE;
117 
118   FUNCTION C_PROC_SALEFORMULA(PROCEEDS_OF_SALE IN NUMBER) RETURN NUMBER;
119 
120   PROCEDURE RAISE_ORA_ERR;
121 
122   PROCEDURE RAISE_ERR(MSGNAME IN VARCHAR2
123                      ,ABORT_FLAG IN VARCHAR2);
124 
125   FUNCTION CF_1FORMULA RETURN CHAR;
126 
127   FUNCTION CF_INCLUDE_RETFORMULA RETURN CHAR;
128 
129   FUNCTION AFTERPFORM RETURN BOOLEAN;
130 
131   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
132 
133   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
134 
135   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
136 
137   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
138 
139   FUNCTION C_ORGANIZATION_NAME_P RETURN VARCHAR2;
140 
141   FUNCTION C_CURR_FISCAL_YR_P RETURN NUMBER;
142 
143   FUNCTION C_CURR_PERIOD_COUNTER_P RETURN NUMBER;
144 
145   FUNCTION C_LAST_PERIOD_COUNTER_P RETURN NUMBER;
146 
147   FUNCTION C_RATIO_PRECISION_P RETURN NUMBER;
148 
149   FUNCTION C_MIN_PERIOD_COUNTER_P RETURN NUMBER;
150 
151   FUNCTION C_MAX_PERIOD_COUNTER_P RETURN NUMBER;
152 
153   FUNCTION C_FISCAL_START_DATE_P RETURN DATE;
154 
155   FUNCTION C_FISCAL_END_DATE_P RETURN DATE;
156 
157   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
158                     ,NAME IN VARCHAR2);
159 
160   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
161                      ,VALUE IN VARCHAR2
162                      ,TRANSLATE IN BOOLEAN);
163 
164   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
165 
166   PROCEDURE CLEAR;
167 
168   FUNCTION GET_STRING(APPIN IN VARCHAR2
169                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
170 
171   FUNCTION GET_NUMBER(APPIN IN VARCHAR2
172                      ,NAMEIN IN VARCHAR2) RETURN NUMBER;
173 
174   FUNCTION GET RETURN VARCHAR2;
175 
176   FUNCTION GET_ENCODED RETURN VARCHAR2;
177 
178   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
179                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
180                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
181 
182   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
183 
184   PROCEDURE RAISE_ERROR;
185 
186 END JL_JLMXFGLR_XMLP_PKG;
187 
188