1 PACKAGE JL_JLARPPFF_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLARPPFFS.pls 120.1 2007/12/25 16:34:24 dwkrishn noship $ */
3 P_DEBUG_SWITCH VARCHAR2(1);
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_MIN_PRECISION NUMBER;
8
9 P_SET_OF_BOOKS_ID NUMBER;
10
11 P_EXCLUDED_TRX_LETTER VARCHAR2(1);
12
13 P_GL_DATE_FROM DATE;
14
15 P_GL_DATE_TO DATE;
16
17 P_PER_TAX_TYPE_FROM VARCHAR2(25);
18
19 P_MUN_TAX_TYPE_FROM VARCHAR2(25);
20
21 P_PRO_TAX_TYPE_FROM VARCHAR2(25);
22
23 P_EXC_TAX_TYPE_TO VARCHAR2(25);
24
25 P_NON_TAXABLE_TAX_TYPE VARCHAR2(25);
26
27 P_PER_TAX_TYPE_TO VARCHAR2(25);
28
29 P_PRO_TAX_TYPE_TO VARCHAR2(25);
30
31 P_MUN_TAX_TYPE_TO VARCHAR2(25);
32
33 P_EXC_TAX_TYPE_FROM VARCHAR2(25);
34
35 P_VAT_TAX_TYPE VARCHAR2(25);
36
37 P_OTHER_FED_PER_FROM VARCHAR2(32767);
38
39 P_OTHER_FED_PER_TO VARCHAR2(32767);
40
41 P_LEGAL_ENTITY_ID NUMBER;
42
43 P_LEGAL_ENTITY_NAME VARCHAR2(240);
44
45 P_REPORTING_ENTITY_ID NUMBER;
46
47 P_REPORTING_LEVEL VARCHAR2(32767);
48
49 P_RETCODE VARCHAR2(32767);
50
51 P_ERRBUF VARCHAR2(2000);
52
53 C_COMPANY_NAME_HEADER VARCHAR2(50);
54
55 C_BASE_CURRENCY_CODE VARCHAR2(15);
56
57 C_BASE_PRECISION NUMBER;
58
59 C_BASE_MIN_ACCT_UNIT NUMBER;
60
61 C_BASE_DESCRIPTION VARCHAR2(240);
62
63 CP_COMP_TAX_ID VARCHAR2(11);
64
65 CP_REC_COUNT NUMBER := 1;
66
67 P_LOCATION_ID NUMBER;
68
69 CP_TOT_REC NUMBER := 0;
70
71 CP_NON_COUNT NUMBER;
72
73 PROCEDURE GET_BASE_CURR_DATA;
74
75 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
76
77 FUNCTION AFTERREPORT RETURN BOOLEAN;
78
79 FUNCTION FORMAT_CURRENCY(P_AMOUNT IN NUMBER) RETURN VARCHAR2;
80
81 FUNCTION CF_TOT_DOC_FFORMULA(CS_TOT_DOC_AMT IN NUMBER) RETURN VARCHAR2;
82
83 FUNCTION CF_TOT_NON_TAXABLE_AMTFORMULA(CS_NON_TAXABLE_AMT IN NUMBER) RETURN VARCHAR2;
84
85 FUNCTION CF_TOT_TAXABLE_AMTFORMULA(CS_TAXABLE_AMT IN NUMBER) RETURN CHAR;
86
87 FUNCTION CF_TOT_VAT_TAX_AMTFORMULA(CS_VAT_TAX_AMT IN NUMBER) RETURN VARCHAR2;
88
89 FUNCTION CF_TOT_VAT_PER_AMTFORMULA(CS_VAT_PER_AMT IN NUMBER) RETURN VARCHAR2;
90
91 FUNCTION CF_TOT_PRO_PER_AMTFORMULA(CS_PRO_PER_AMT IN NUMBER) RETURN CHAR;
92
93 FUNCTION CF_TOT_EXMPT_AMTFORMULA(CS_EXMPT_AMT IN NUMBER) RETURN VARCHAR2;
94
95 FUNCTION CF_TOT_MUN_PER_AMTFORMULA(CS_MUN_PER_AMT IN NUMBER) RETURN VARCHAR2;
96
97 FUNCTION CF_TOT_EXC_AMTFORMULA(CS_EXC_AMT IN NUMBER) RETURN VARCHAR2;
98
99 FUNCTION CF_REC_TYPE_2FORMULA(CF_TOT_REC IN NUMBER
100 ,CF_TOT_DOC_F IN VARCHAR2
101 ,CF_TOT_NON_TAXABLE_AMT IN VARCHAR2
102 ,CF_TOT_TAXABLE_AMT IN VARCHAR2
103 ,CF_TOT_VAT_TAX_AMT IN VARCHAR2
104 ,CF_TOT_EXMPT_AMT IN VARCHAR2
105 ,CF_TOT_VAT_PER_AMT IN VARCHAR2
106 ,CF_TOT_FED_PER_AMT IN VARCHAR2
107 ,CF_TOT_PRO_PER_AMT IN VARCHAR2
108 ,CF_TOT_MUN_PER_AMT IN VARCHAR2
109 ,CF_TOT_EXC_AMT IN VARCHAR2) RETURN VARCHAR2;
110
111 FUNCTION CF_BLANK_SUMFORMULA RETURN CHAR;
112
113 FUNCTION CF_TOT_DOC_AMT_NUMFORMULA(STATUS IN VARCHAR2
114 ,DOC_AMT_NON1 IN NUMBER) RETURN NUMBER;
115
116 FUNCTION CF_EXMPT_AMT_NUMFORMULA(STATUS IN VARCHAR2
117 ,EXMPT_AMT IN NUMBER) RETURN NUMBER;
118
119 FUNCTION CF_TAXABLE_AMT_NUMFORMULA(STATUS IN VARCHAR2
120 ,TAXABLE_AMT IN NUMBER) RETURN NUMBER;
121
122 FUNCTION CF_VAT_PER_AMT_NUMFORMULA(STATUS IN VARCHAR2
123 ,VAT_PER_AMT IN NUMBER) RETURN NUMBER;
124
125 FUNCTION CF_PRO_PER_AMT_NUMFORMULA(STATUS IN VARCHAR2
126 ,PRO_AMT IN NUMBER) RETURN NUMBER;
127
128 FUNCTION CF_MUN_PER_AMT_NUMFORMULA(STATUS IN VARCHAR2
129 ,MUN_AMT1 IN NUMBER) RETURN NUMBER;
130
131 FUNCTION CF_EXC_AMT_NUMFORMULA(STATUS IN VARCHAR2
132 ,EXCS_AMT IN NUMBER) RETURN NUMBER;
133
134 FUNCTION CF_TOT_DOC_AMTFORMULA(CF_TOT_DOC_AMT_NUM IN NUMBER) RETURN VARCHAR2;
135
136 FUNCTION CF_TAXABLE_AMTFORMULA(CF_TAXABLE_AMT_NUM IN NUMBER) RETURN VARCHAR2;
137
138 FUNCTION CF_VAT_TAX_AMT_NUMFORMULA(STATUS IN VARCHAR2
139 ,VAT_TAX_AMT1 IN NUMBER) RETURN NUMBER;
140
141 FUNCTION CF_VAT_TAX_AMTFORMULA(CF_VAT_TAX_AMT_NUM IN NUMBER) RETURN VARCHAR2;
142
143 FUNCTION CF_EXMPT_AMTFORMULA(CF_EXMPT_AMT_NUM IN NUMBER) RETURN VARCHAR2;
144
145 FUNCTION CF_FED_PER_AMTFORMULA(CF_VAT_PER_AMT_NUM IN NUMBER) RETURN VARCHAR2;
146
147 FUNCTION CF_PRO_PER_AMTFORMULA(CF_PRO_PER_AMT_NUM IN NUMBER) RETURN VARCHAR2;
148
149 FUNCTION CF_MUN_PER_AMTFORMULA(CF_MUN_PER_AMT_NUM IN NUMBER) RETURN VARCHAR2;
150
151 FUNCTION CF_VAT_RATEFORMULA(TAX_RATE IN NUMBER) RETURN VARCHAR2;
152
153 FUNCTION CF_VAT_RATE_QTYFORMULA(TRX_ID IN NUMBER) RETURN VARCHAR2;
154
155 FUNCTION CF_BLANK_CHRFORMULA RETURN VARCHAR2;
156
157 FUNCTION CF_REC_TYPE1FORMULA(NON_TAXABLE_AMOUNT1 IN NUMBER
158 ,CF_REC_COUNT IN NUMBER
159 ,STATUS IN VARCHAR2
160 ,DOC_DATE1 IN VARCHAR2
161 ,DGI_DOC_TYPE_CODE1 IN VARCHAR2
162 ,FISC_PRN1 IN VARCHAR2
163 ,CF_POINT_OF_SALE IN VARCHAR2
164 ,CF_DOC_NUM IN VARCHAR2
165 ,CUST_ISSUE_DTL1 IN VARCHAR2
166 ,CF_CUST_NUM_VALDIGIT IN VARCHAR2
167 ,SUPPLIER_DTL1 IN VARCHAR2
168 ,CAI_INFO1 IN VARCHAR2
169 ,TAX_RATE IN NUMBER
170 ,CF_TOT_DOC_AMT IN VARCHAR2
171 ,CF_EXMPT_AMT IN VARCHAR2
172 ,CF_VAT_PER_AMT IN VARCHAR2
173 ,CF_FED_PER_AMT IN VARCHAR2
174 ,CF_PRO_PER_AMT IN VARCHAR2
175 ,CF_MUN_PER_AMT IN VARCHAR2
176 ,CF_EXC_AMT IN VARCHAR2
177 ,SUP_VAT_REGN_STATUS_CODE1 IN VARCHAR2
178 ,CURRENCY_CODE1 IN VARCHAR2
179 ,CF_EXCHANGE_RATE IN VARCHAR2
180 ,CF_VAT_RATE_QTY IN VARCHAR2
181 ,DGI_TRANSACTION_CODE IN VARCHAR2
182 ,CF_TAXABLE_AMT IN VARCHAR2
183 ,CF_VAT_RATE IN VARCHAR2
184 ,CF_VAT_TAX_AMT IN VARCHAR2
185 ,CF_VAT_COUNT IN NUMBER
186 ,CF_DOC_AMT_CHR IN VARCHAR2
187 ,CF_NON_AMT_CHR IN VARCHAR2
188 ,CF_RATE_QTY IN VARCHAR2
189 ,CF_DGI_TRAN_CODE IN VARCHAR2) RETURN VARCHAR2;
190
191 FUNCTION CF_EXC_AMTFORMULA(CF_EXC_AMT_NUM IN NUMBER) RETURN CHAR;
192
193 FUNCTION BEFOREREPORT RETURN BOOLEAN;
194
195 FUNCTION CF_REC_COUNTFORMULA RETURN NUMBER;
196
197 FUNCTION CF_TOT_RECFORMULA RETURN NUMBER;
198
199 FUNCTION CF_VAT_AMTFORMULA(STATUS IN VARCHAR2
200 ,VAT_TAX_AMT1 IN NUMBER) RETURN NUMBER;
201
202 FUNCTION CF_FED_PER_AMT_NUMFORMULA0004(STATUS IN VARCHAR2
203 ,FED_PER_AMT IN NUMBER) RETURN NUMBER;
204
205 FUNCTION CF_FED_PER_AMTFORMULA0006(CF_FED_PER_AMT_NUM IN NUMBER) RETURN CHAR;
206
207 FUNCTION CF_TOT_FED_PER_AMTFORMULA(CS_FED_PER_AMOUNT IN NUMBER) RETURN CHAR;
208
209 FUNCTION POPULATE_TRL RETURN BOOLEAN;
210
211 FUNCTION CF_DOC_AMT_NONFORMULA(STATUS IN VARCHAR2
212 ,DOC_AMT_NON1 IN NUMBER) RETURN NUMBER;
213
214 FUNCTION CF_DOC_AMT_CHRFORMULA(CF_DOC_AMT_NON IN NUMBER) RETURN VARCHAR2;
215
216 FUNCTION CF_NON_BLANKFORMULA RETURN CHAR;
217
218 FUNCTION CF_NON_AMT_CHRFORMULA(NON_TAXABLE_AMOUNT1 IN NUMBER) RETURN CHAR;
219
220 FUNCTION CF_DGI_TRAN_CODEFORMULA(INVOICE_ID IN VARCHAR2) RETURN VARCHAR2;
221
222 FUNCTION CF_VAT_COUNTFORMULA(INVOICE_ID IN VARCHAR2) RETURN NUMBER;
223
224 FUNCTION CF_RATE_QTYFORMULA(INVOICE_ID IN VARCHAR2) RETURN VARCHAR2;
225
226 FUNCTION CF_EXEMPT_AMOUNTFORMULA(EXMPT_AMT IN NUMBER) RETURN NUMBER;
227
228 FUNCTION CF_VAT_PER_AMOUNTFORMULA(STATUS IN VARCHAR2
229 ,VAT_PER_AMT IN NUMBER) RETURN NUMBER;
230
231 FUNCTION CF_FED_PER_AMOUNTFORMULA(STATUS IN VARCHAR2
232 ,FED_PER_AMT IN NUMBER) RETURN NUMBER;
233
234 FUNCTION CF_MUN_AMOUNTFORMULA(STATUS IN VARCHAR2
235 ,MUN_AMT1 IN NUMBER) RETURN NUMBER;
236
237 FUNCTION CF_PRO_AMOUNTFORMULA(STATUS IN VARCHAR2
238 ,PRO_AMT IN NUMBER) RETURN NUMBER;
239
240 FUNCTION CF_EXCISE_AMOUNTFORMULA(STATUS IN VARCHAR2
241 ,EXCS_AMT IN NUMBER) RETURN NUMBER;
242
243 FUNCTION CF_NON_AMOUNTFORMULA(STATUS IN VARCHAR2
244 ,NON_TAXABLE_AMOUNT1 IN NUMBER) RETURN NUMBER;
245
246 FUNCTION CF_TOT_VAT_AMOUNTFORMULA(STATUS IN VARCHAR2
247 ,TOT_VAT1 IN NUMBER) RETURN NUMBER;
248
249 FUNCTION CF_CUST_NUM_VALDIGITFORMULA(CUSTOM_ISSUE_NUM1 IN VARCHAR2) RETURN VARCHAR2;
250
251 FUNCTION CF_FISCAL_PRINTERFORMULA RETURN CHAR;
252
253 FUNCTION CF_DOC_NUMFORMULA(INVOICE_ID IN VARCHAR2) RETURN CHAR;
254
255 FUNCTION CF_EXCHANGE_RATEFORMULA(EXCHANGE_RATE1 IN NUMBER) RETURN CHAR;
256
257 FUNCTION CF_POINT_OF_SALEFORMULA(INVOICE_ID IN VARCHAR2) RETURN CHAR;
258
259 FUNCTION CF_TOT_DOC_AMOUNTFORMULA RETURN NUMBER;
260
261 FUNCTION CP_TOT_RECFORMULA RETURN NUMBER;
262
263 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
264
265 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
266
267 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
268
269 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
270
271 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
272
273 FUNCTION CP_COMP_TAX_ID_P RETURN VARCHAR2;
274
275 FUNCTION CP_REC_COUNT_P RETURN NUMBER;
276
277 FUNCTION P_LOCATION_ID_P RETURN NUMBER;
278
279 FUNCTION CP_TOT_REC_P RETURN NUMBER;
280
281 FUNCTION CP_NON_COUNT_P RETURN NUMBER;
282
283 END JL_JLARPPFF_XMLP_PKG;
284
285