[Home] [Help]
PACKAGE: APPS.JL_JLZZFIJR_XMLP_PKG
Source
1 PACKAGE JL_JLZZFIJR_XMLP_PKG AS
2 /* $Header: JLZZFIJRS.pls 120.1 2007/12/25 16:54:17 dwkrishn noship $ */
3 P_BOOK VARCHAR2(32767);
4
5 P_PERIOD VARCHAR2(32767);
6
7 P_ASSET_CATEGORY VARCHAR2(32767);
8
9 P_ASSET_TYPE VARCHAR2(32767);
10
11 P_CATEGORY_ID NUMBER;
12
13 P_CONC_REQUEST_ID NUMBER;
14
15 P_MIN_PRECISION NUMBER := 2;
16
17 P_END_OF_REPORT VARCHAR2(30);
18
19 P_NO_DATA_FOUND VARCHAR2(30);
20
21 P_CA_SET_OF_BOOKS_ID NUMBER;
22
23 LP_CURRENCY_CODE VARCHAR2(32767);
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_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_FA_DEPRN_PERIODS VARCHAR2(50) := 'fa_deprn_periods';
46
47 CP_CAT_CORP_COST VARCHAR2(17);
48
49 CP_CAT_ADJ_COST_PER VARCHAR2(16);
50
51 CP_CAT_ADJ_COST VARCHAR2(17);
52
53 CP_CAT_CORP_DEPR_RESERVE VARCHAR2(17);
54
55 CP_CAT_DEPR_RESERVE_ADJ_PER VARCHAR2(17);
56
57 CP_CAT_ADJ_DEPRN_RESERVE VARCHAR2(17);
58
59 CP_CAT_CORP_YTD_DEPRN_EXPENSE VARCHAR2(17);
60
61 CP_CAT_YTD_DEPRN_EXPENSE_ADJ_P VARCHAR2(17);
62
63 CP_CAT_ADJ_YTD_DEPRN_EXPENSE VARCHAR2(17);
64
65 CP_ASSET_CORP_COST VARCHAR2(17);
66
67 CP_ASSET_ADJ_COST_PER VARCHAR2(16);
68
69 CP_ASSET_ADJ_COST VARCHAR2(17);
70
71 CP_ASSET_CORP_DEPR_RESERVE VARCHAR2(17);
72
73 CP_ASSET_DEPR_RESERVE_ADJ_PER VARCHAR2(17);
74
75 CP_ASSET_ADJ_DEPRN_RESERVE VARCHAR2(17);
76
77 CP_ASSET_CORP_YTD_DEPRN_EXPENS VARCHAR2(17);
78
79 CP_ASSET_YTD_DEPR_EXPN_ADJ_PER VARCHAR2(17);
80
81 CP_ASSET_YTD_DEPRN_EXPENSE VARCHAR2(17);
82
83 BOOK_CLASS VARCHAR2(15);
84
85 DISTRIBUTION_SOURCE_BOOK VARCHAR2(15);
86
87 CP_REPORT_NAME VARCHAR2(2000);
88
89 CP_COMPANY_NAME VARCHAR2(80);
90
91 CURRENCY_CODE VARCHAR2(15);
92
93 CP_PARAM_CURRENCY VARCHAR2(20);
94
95 FUNCTION BEFOREREPORT RETURN BOOLEAN;
96
97 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
98
99 FUNCTION BOOKFORMULA RETURN VARCHAR2;
100
101 FUNCTION AFTERREPORT RETURN BOOLEAN;
102
103 FUNCTION PERIOD_PCFORMULA RETURN NUMBER;
104
105 FUNCTION DEPR_RESERVE_ADJ_PERFORMULA(ASSET_ID IN NUMBER
106 ,PERIOD_PC IN NUMBER) RETURN NUMBER;
107
108 FUNCTION DEPR_EXPENSE_ADJ_PERFORMULA(ASSET_ID IN NUMBER
109 ,PERIOD_PC IN NUMBER) RETURN NUMBER;
110
111 FUNCTION CP_CAT_CORP_COST_P RETURN VARCHAR2;
112
113 FUNCTION CP_CAT_ADJ_COST_PER_P RETURN VARCHAR2;
114
115 FUNCTION CP_CAT_ADJ_COST_P RETURN VARCHAR2;
116
117 FUNCTION CP_CAT_CORP_DEPR_RESERVE_P RETURN VARCHAR2;
118
119 FUNCTION CP_CAT_DEPR_RESERVE_ADJ_PER_P RETURN VARCHAR2;
120
121 FUNCTION CP_CAT_ADJ_DEPRN_RESERVE_P RETURN VARCHAR2;
122
123 FUNCTION CP_CAT_CORP_YTD_DEPRN_EXPE_p RETURN VARCHAR2;
124
125 FUNCTION CP_CAT_YTD_DEPRN_EXPENSE_ADJ_ RETURN VARCHAR2;
126
127 FUNCTION CP_CAT_ADJ_YTD_DEPRN_EXPENSE_P RETURN VARCHAR2;
128
129 FUNCTION CP_ASSET_CORP_COST_P RETURN VARCHAR2;
130
131 FUNCTION CP_ASSET_ADJ_COST_PER_P RETURN VARCHAR2;
132
133 FUNCTION CP_ASSET_ADJ_COST_P RETURN VARCHAR2;
134
135 FUNCTION CP_ASSET_CORP_DEPR_RESERVE_P RETURN VARCHAR2;
136
137 FUNCTION CP_ASSET_DEPR_RESERVE_ADJ_P RETURN VARCHAR2;
138
139 FUNCTION CP_ASSET_ADJ_DEPRN_RESERVE_P RETURN VARCHAR2;
140
141 FUNCTION CP_ASSET_CORP_YTD_DEPRN_EXPEN RETURN VARCHAR2;
142
143 FUNCTION CP_ASSET_YTD_DEPR_EXPN_ADJ_PE RETURN VARCHAR2;
144
145 FUNCTION CP_ASSET_YTD_DEPRN_EXPENSE_P RETURN VARCHAR2;
146
147 FUNCTION BOOK_CLASS_P RETURN VARCHAR2;
148
149 FUNCTION DISTRIBUTION_SOURCE_BOOK_P RETURN VARCHAR2;
150
151 FUNCTION CP_REPORT_NAME_P RETURN VARCHAR2;
152
153 FUNCTION CP_COMPANY_NAME_P RETURN VARCHAR2;
154
155 FUNCTION CURRENCY_CODE_P RETURN VARCHAR2;
156
157 FUNCTION CP_PARAM_CURRENCY_P RETURN VARCHAR2;
158
159 END JL_JLZZFIJR_XMLP_PKG;
160
161