[Home] [Help]
PACKAGE: APPS.IGI_IGIIARPS_XMLP_PKG
Source
1 PACKAGE IGI_IGIIARPS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGIIARPSS.pls 120.0.12010000.1 2008/07/29 08:58:43 appldev ship $ */
3 P_BOOK_TYPE_CODE VARCHAR2(40);
4
5 INSERT_INFO_VAR NUMBER;
6
7 P_REVALUATION_ID NUMBER;
8
9 P_PERIOD_COUNTER NUMBER;
10
11 P_CONC_REQUEST_ID NUMBER;
12
13 CF_TOLERANCE_LEVEL NUMBER;
14
15 CF_B_REVAL_COST NUMBER;
16
17 CF_A_REVAL_COST NUMBER;
18
19 CF_ASSET_TOLERANCE VARCHAR2(32767);
20
21 ACCOUNTING_FLEX_STRUCTURE NUMBER;
22
23 CP_REP_FORMAT_DIFF NUMBER;
24
25 CP_CO_FORMAT_DIFF NUMBER;
26
27 CP_MC_FORMAT_DIFF NUMBER;
28
29 F_MINOR_CATEGORY VARCHAR2(30);
30
31 CP_MAJOR_CATEGORY VARCHAR2(30);
32
33 CP_CAT_FORMAT_DIFF NUMBER;
34
35 CP_COST_ACCT VARCHAR2(20) := '0000';
36
37 CP_REVAL_RES_ACCT VARCHAR2(20) := '0000';
38
39 CP_ACC_DEPRN_ACCT VARCHAR2(20) := '0000';
40
41 CP_OPERATING_ACCT VARCHAR2(20) := '0000';
42
43 CP_BACKLOG_ACCT VARCHAR2(20) := '0000';
44
45 CP_CC_FORMAT_DIFF NUMBER;
46
47 CP_A_FORMAT_DIFF NUMBER;
48
49 F_REVAL_RESERVE_DIFF NUMBER;
50
51 F_REVAL_COST_DIFF NUMBER;
52
53 F_OPERATING_ACCT_DIFF NUMBER;
54
55 F_ACC_DEPRN_DIFF NUMBER;
56
57 F_ACC_BACKLOG_DIFF NUMBER;
58
59 RP_REPORT_NAME VARCHAR2(240);
60
61 RP_COMPANY_NAME VARCHAR2(50);
62
63 CP_PERIOD_NAME VARCHAR2(15);
64
65 P_FISCAL_YEAR VARCHAR2(30);
66
67 P_BOOK VARCHAR2(15);
68
69 CP_CURR_CODE VARCHAR2(20) := 'USD';
70
71 CP_ACCOUNT_SEGMENT VARCHAR2(20) := '''cc.segment3''';
72
73 FUNCTION CF_PERIODNAMEFORMULA RETURN NUMBER;
74
75 FUNCTION BEFOREREPORT RETURN BOOLEAN;
76
77 FUNCTION MINOR_CATEGORYFORMULA RETURN VARCHAR2;
78
79 FUNCTION AFTERREPORT RETURN BOOLEAN;
80
81 FUNCTION CF_CALC_COMPANY_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN NUMBER;
82
83 FUNCTION CF_CURR_CODEFORMULA RETURN NUMBER;
84
85 FUNCTION CF_REPORT_NAMEFORMULA RETURN NUMBER;
86
87 FUNCTION CF_PERIOD_NAMEFORMULA RETURN NUMBER;
88
89 FUNCTION CF_REP_TOLERANCEFORMULA(S_REP_B_REVAL_COST IN NUMBER
90 ,S_REP_A_REVAL_COST IN NUMBER) RETURN VARCHAR2;
91
92 FUNCTION CALC_TOLERANCE_LEVELFORMULA RETURN NUMBER;
93
94 FUNCTION CF_CO_TOLERANCEFORMULA(S_CO_B_REVAL_COST IN NUMBER
95 ,S_CO_A_REVAL_COST IN NUMBER) RETURN CHAR;
96
97 FUNCTION CF_MC_TOLERANCEFORMULA(S_MC_B_REVAL_COST IN NUMBER
98 ,S_MC_A_REVAL_COST IN NUMBER) RETURN CHAR;
99
100 FUNCTION CF_CAT_TOLERANCEFORMULA(S_CAT_B_REVAL_COST IN NUMBER
101 ,S_CAT_A_REVAL_COST IN NUMBER) RETURN CHAR;
102
103 FUNCTION CF_CC_TOLERANCEFORMULA(S_CC_B_REVAL_COST IN NUMBER
104 ,S_CC_A_REVAL_COST IN NUMBER) RETURN CHAR;
105
106 FUNCTION CF_CALC_PLACEHOLDERSFORMULA RETURN NUMBER;
107
108 FUNCTION CF_MAJOR_CATFORMULA(MAJOR_CATEGORY IN VARCHAR2) RETURN NUMBER;
109
110 PROCEDURE INSERT_INFO;
111
112 FUNCTION DO_INSERTFORMULA RETURN NUMBER;
113
114 FUNCTION B_REVALUED_COSTFORMULA(BALANCE_TYPE IN VARCHAR2
115 ,REVALUED_COST IN NUMBER) RETURN NUMBER;
116
117 FUNCTION A_REVALUED_COSTFORMULA(BALANCE_TYPE IN VARCHAR2
118 ,REVALUED_COST IN NUMBER) RETURN NUMBER;
119
120 FUNCTION B_REVAL_RESERVEFORMULA(BALANCE_TYPE IN VARCHAR2
121 ,REVALUATION_RESERVE IN NUMBER) RETURN NUMBER;
122
123 FUNCTION A_REVAL_RESERVEFORMULA(BALANCE_TYPE IN VARCHAR2
124 ,REVALUATION_RESERVE IN NUMBER) RETURN NUMBER;
125
126 FUNCTION B_OPERATING_ACCTFORMULA(BALANCE_TYPE IN VARCHAR2
127 ,OPERATING_ACCT IN NUMBER) RETURN NUMBER;
128
129 FUNCTION A_OPERATING_ACCTFORMULA(BALANCE_TYPE IN VARCHAR2
130 ,OPERATING_ACCT IN NUMBER) RETURN NUMBER;
131
132 FUNCTION B_ACC_DEPRNFORMULA(BALANCE_TYPE IN VARCHAR2
133 ,ACCUMULATED_DEPRECIATION IN NUMBER) RETURN NUMBER;
134
135 FUNCTION A_ACC_DEPRNFORMULA(BALANCE_TYPE IN VARCHAR2
136 ,ACCUMULATED_DEPRECIATION IN NUMBER) RETURN NUMBER;
137
138 FUNCTION B_ACC_BLOGFORMULA(BALANCE_TYPE IN VARCHAR2
139 ,ACCUMULATED_BACKLOG IN NUMBER) RETURN NUMBER;
140
141 FUNCTION A_ACC_BLOGFORMULA(BALANCE_TYPE IN VARCHAR2
142 ,ACCUMULATED_BACKLOG IN NUMBER) RETURN NUMBER;
143
144 function CF_calc_acct_valueFormula(asset_category_id in number,cp_account_segment in VARCHAR2) return Number ;
145
146
147 FUNCTION ACCOUNTING_FLEX_STRUCTURE_P RETURN NUMBER;
148
149 FUNCTION CP_REP_FORMAT_DIFF_P RETURN NUMBER;
150
151 FUNCTION CP_CO_FORMAT_DIFF_P RETURN NUMBER;
152
153 FUNCTION CP_MC_FORMAT_DIFF_P RETURN NUMBER;
154
155 FUNCTION F_MINOR_CATEGORY_P RETURN VARCHAR2;
156
157 FUNCTION CP_MAJOR_CATEGORY_P RETURN VARCHAR2;
158
159 FUNCTION CP_CAT_FORMAT_DIFF_P RETURN NUMBER;
160
161 FUNCTION CP_COST_ACCT_P RETURN VARCHAR2;
162
163 FUNCTION CP_REVAL_RES_ACCT_P RETURN VARCHAR2;
164
165 FUNCTION CP_ACC_DEPRN_ACCT_P RETURN VARCHAR2;
166
167 FUNCTION CP_OPERATING_ACCT_P RETURN VARCHAR2;
168
169 FUNCTION CP_BACKLOG_ACCT_P RETURN VARCHAR2;
170
171 FUNCTION CP_CC_FORMAT_DIFF_P RETURN NUMBER;
172
173 FUNCTION CP_A_FORMAT_DIFF_P RETURN NUMBER;
174
175 FUNCTION F_REVAL_RESERVE_DIFF_P RETURN NUMBER;
176
177 FUNCTION F_REVAL_COST_DIFF_P RETURN NUMBER;
178
179 FUNCTION F_OPERATING_ACCT_DIFF_P RETURN NUMBER;
180
181 FUNCTION F_ACC_DEPRN_DIFF_P RETURN NUMBER;
182
183 FUNCTION F_ACC_BACKLOG_DIFF_P RETURN NUMBER;
184
185 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
186
187 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
188
189 FUNCTION CP_PERIOD_NAME_P RETURN VARCHAR2;
190
191 FUNCTION P_FISCAL_YEAR_P RETURN VARCHAR2;
192
193 FUNCTION P_BOOK_P RETURN VARCHAR2;
194
195 FUNCTION CP_CURR_CODE_P RETURN VARCHAR2;
196
197 FUNCTION CP_ACCOUNT_SEGMENT_P RETURN VARCHAR2;
198
199 END IGI_IGIIARPS_XMLP_PKG;