[Home] [Help]
PACKAGE: APPS.JL_JLARTSFF_XMLP_PKG
Source
1 PACKAGE JL_JLARTSFF_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLARTSFFS.pls 120.2 2008/01/11 07:52:53 abraghun 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_TRACE_SWITCH VARCHAR2(1);
12
13 P_FROM_DATE DATE;
14
15 P_TO_DATE DATE;
16
17 P_VAT VARCHAR2(32767);
18
19 P_VATADDL VARCHAR2(32767);
20
21 P_VATPERC VARCHAR2(32767);
22
23 P_MUN_TAX_REGIME VARCHAR2(32767);
24
25 P_PRO_TAX_REGIME VARCHAR2(32767);
26
27 P_EXCISE VARCHAR2(32767);
28
29 P_VATNOT VARCHAR2(32767);
30
31 P_VAT_NON_TAXABLE VARCHAR2(32767);
32
33 P_LEGAL_ENTITY_ID NUMBER;
34
35 P_LEGAL_ENTITY_NAME VARCHAR2(240);
36
37 P_REPORTING_ENTITY_ID NUMBER;
38
39 P_REPORTING_LEVEL VARCHAR2(32767);
40
41 P_RETCODE VARCHAR2(32767);
42
43 P_ERRBUF VARCHAR2(2000);
44
45 P_TAX_REGIME VARCHAR2(50);
46
47 C_COMPANY_NAME_HEADER VARCHAR2(50);
48
49 C_BASE_CURRENCY_CODE VARCHAR2(15);
50
51 C_BASE_PRECISION NUMBER;
52
53 C_BASE_MIN_ACCT_UNIT NUMBER;
54
55 C_BASE_DESCRIPTION VARCHAR2(240);
56
57 CP_COMP_TAX_ID VARCHAR2(30);
58
59 CP_REC_COUNT NUMBER := 1;
60
61 P_VAT_ID NUMBER;
62
63 P_VATADDL_ID NUMBER;
64
65 P_VATPERC_ID NUMBER;
66
67 P_EXC_ID NUMBER;
68
69 P_VATNOT_ID NUMBER;
70
71 P_NON_TAX_ID NUMBER;
72
73 CP_TOT NUMBER:=0;
74
75 CP_NON_TOT NUMBER := 0;
76
77 PROCEDURE GET_BASE_CURR_DATA;
78
79 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
80
81 FUNCTION BEFOREREPORT RETURN BOOLEAN;
82
83 FUNCTION AFTERREPORT RETURN BOOLEAN;
84
85 FUNCTION FORMAT_CURRENCY(P_AMOUNT IN NUMBER) RETURN VARCHAR2;
86
87 FUNCTION CF_TOT_DOC_FFORMULA(CS_TOT_DOC_AMT IN NUMBER) RETURN VARCHAR2;
88
89 FUNCTION CF_TOT_NON_TAXABLE_AMTFORMULA(CS_NON_TAXABLE_AMT IN NUMBER) RETURN VARCHAR2;
90
91 FUNCTION CF_TOT_TAXABLE_AMTFORMULA(CS_TAXABLE_AMT IN NUMBER) RETURN CHAR;
92
93 FUNCTION CF_TOT_VAT_TAX_AMTFORMULA(CS_VAT_TAX_AMT IN NUMBER) RETURN VARCHAR2;
94
95 FUNCTION CF_TOT_NOT_REG_TAX_AMTFORMULA(CS_NOT_REG_TAX_AMT IN NUMBER) RETURN CHAR;
96
97 FUNCTION CF_TOT_FED_PER_AMTFORMULA(CS_FED_PER_AMT IN NUMBER) RETURN VARCHAR2;
98
99 FUNCTION CF_TOT_PRO_PER_AMTFORMULA(CS_PRO_PER_AMT IN NUMBER) RETURN CHAR;
100
101 FUNCTION CF_TOT_EXMPT_AMTFORMULA(CS_EXMPT_AMT IN NUMBER) RETURN VARCHAR2;
102
103 FUNCTION CF_TOT_MUN_PER_AMTFORMULA(CS_MUN_PER_AMT IN NUMBER) RETURN VARCHAR2;
104
105 FUNCTION CF_TOT_EXC_AMTFORMULA(CS_EXC_AMT IN NUMBER) RETURN VARCHAR2;
106
107 FUNCTION CF_REC_TYPE_2FORMULA(CF_TOT_CNT IN NUMBER
108 ,CF_TOT_DOC_F IN VARCHAR2
109 ,CF_TOT_NON_TAXABLE_AMT IN VARCHAR2
110 ,CF_TOT_TAXABLE_AMT IN VARCHAR2
111 ,CF_TOT_VAT_TAX_AMT IN VARCHAR2
112 ,CF_TOT_NOT_REG_TAX_AMT IN VARCHAR2
113 ,CF_TOT_EXMPT_AMT IN VARCHAR2
114 ,CF_TOT_FED_PER_AMT IN VARCHAR2
115 ,CF_TOT_PRO_PER_AMT IN VARCHAR2
116 ,CF_TOT_MUN_PER_AMT IN VARCHAR2
117 ,CF_TOT_EXC_AMT IN VARCHAR2) RETURN VARCHAR2;
118
119 FUNCTION CF_BLANK_SUMFORMULA RETURN CHAR;
120
121 FUNCTION CF_TOT_CNTFORMULA RETURN NUMBER;
122
123 FUNCTION POPULATE_TRL RETURN BOOLEAN;
124
125 FUNCTION CF_DOC_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
126 ,DOC_AMT IN NUMBER) RETURN NUMBER;
127
128 FUNCTION CF_NON_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
129 ,NON_TXBL_AMT IN NUMBER) RETURN NUMBER;
130
131 FUNCTION CF_TAXABLE_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
132 ,TXBL_AMT IN NUMBER) RETURN NUMBER;
133
134 FUNCTION CF_VAT_TAX_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
135 ,VAT_AMOUNT IN NUMBER) RETURN NUMBER;
136
137 FUNCTION CF_NON_REG_TAX_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
138 ,NON_REG_AMT IN NUMBER) RETURN NUMBER;
139
140 FUNCTION CF_EXMPT_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
141 ,EXMPT_AMT IN NUMBER) RETURN NUMBER;
142
143 FUNCTION CF_FED_PER_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
144 ,FED_PERCEP_AMT IN NUMBER) RETURN NUMBER;
145
146 FUNCTION CF_PRO_PER_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
147 ,PROV_PRECEP_AMT IN NUMBER) RETURN NUMBER;
148
149 FUNCTION CF_MUN_PER_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
150 ,MUNIC_PERCEP_AMT IN NUMBER) RETURN NUMBER;
151
152 FUNCTION CF_EXC_AMT_NUMFORMULA(VOID_TRX IN VARCHAR2
153 ,EXCISE_AMT IN NUMBER) RETURN NUMBER;
154
155 FUNCTION CF_DOC_AMT_CHRFORMULA(DOC_AMT IN NUMBER) RETURN CHAR;
156
157 FUNCTION CF_NON_AMT_CHRFORMULA(NON_TXBL_AMT IN NUMBER) RETURN CHAR;
158
159 FUNCTION CF_TAXABLE_AMT_CHRFORMULA(TXBL_AMT IN NUMBER) RETURN CHAR;
160
161 FUNCTION CF_VAT_TAX_AMT_CHRFORMULA(VAT_AMOUNT IN NUMBER) RETURN CHAR;
162
163 FUNCTION CF_NON_REG_TAX_AMT_CHRFORMULA(NON_REG_AMT IN NUMBER) RETURN CHAR;
164
165 FUNCTION CF_EXMPT_AMT_CHRFORMULA(EXMPT_AMT IN NUMBER) RETURN CHAR;
166
167 FUNCTION CF_FED_PER_AMT_CHRFORMULA(FED_PERCEP_AMT IN NUMBER) RETURN CHAR;
168
169 FUNCTION CF_PRO_PER_AMT_CHRFORMULA(PROV_PRECEP_AMT IN NUMBER) RETURN CHAR;
170
171 FUNCTION CF_MUN_PER_AMT_CHRFORMULA(MUNIC_PERCEP_AMT IN NUMBER) RETURN CHAR;
172
173 FUNCTION CF_EXC_AMT_CHRFORMULA(EXCISE_AMT IN NUMBER) RETURN CHAR;
174
175 FUNCTION CF_EXCHANGE_RATEFORMULA(EXCHANGE_RATE IN NUMBER) RETURN CHAR;
176
177 FUNCTION CF_REC_COUNTFORMULA(CUSTOMER_TRX_ID IN NUMBER) RETURN NUMBER;
178
179 FUNCTION CF_VAT_NON_RECFORMULA(NON_TXBL_AMT IN NUMBER
180 ,VOID_TRX IN VARCHAR2
181 ,DOC_DATE IN VARCHAR2
182 ,DGI_CODES IN VARCHAR2
183 ,FISCAL_PRINTER IN VARCHAR2
184 ,STRING1 IN VARCHAR2
185 ,CAI_INFO IN VARCHAR2
186 ,DOC_VOID_DATE IN VARCHAR2
187 ,CF_REC_COUNT IN NUMBER
188 ,CF_DOC_AMT_CHR IN VARCHAR2
189 ,CF_NON_AMT_CHR IN VARCHAR2
190 ,CUST_VAT_REG_CODE IN VARCHAR2
191 ,CUR_CODE IN VARCHAR2
192 ,CF_EXCHANGE_RATE IN VARCHAR2
193 ,VAT_RATE_QTY IN NUMBER
194 ,DGI_TRX_CODE IN VARCHAR2
195 ,VAT_RATE IN NUMBER
196 ,CF_EXMPT_AMT_CHR IN VARCHAR2
197 ,CF_TAXABLE_AMT_CHR IN VARCHAR2
198 ,CF_VAT_RATE IN VARCHAR2
199 ,CF_VAT_TAX_AMT_CHR IN VARCHAR2
200 ,CF_NON_REG_TAX_AMT_CHR IN VARCHAR2
201 ,CF_FED_PER_AMT_CHR IN VARCHAR2
202 ,CF_PRO_PER_AMT_CHR IN VARCHAR2
203 ,CF_MUN_PER_AMT_CHR IN VARCHAR2
204 ,CF_EXC_AMT_CHR IN VARCHAR2) RETURN CHAR;
205
206 FUNCTION CF_BLANK_CHRFORMULA RETURN CHAR;
207
208 FUNCTION CP_REC_COUNTFORMULA RETURN NUMBER;
209
210 FUNCTION CF_VAT_RATEFORMULA(VAT_RATE IN NUMBER) RETURN CHAR;
211
212 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
213
214 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
215
216 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
217
218 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
219
220 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
221
222 FUNCTION CP_COMP_TAX_ID_P RETURN VARCHAR2;
223
224 FUNCTION CP_REC_COUNT_P RETURN NUMBER;
225
226 FUNCTION P_VAT_ID_P RETURN NUMBER;
227
228 FUNCTION P_VATADDL_ID_P RETURN NUMBER;
229
230 FUNCTION P_VATPERC_ID_P RETURN NUMBER;
231
232 FUNCTION P_EXC_ID_P RETURN NUMBER;
233
234 FUNCTION P_VATNOT_ID_P RETURN NUMBER;
235
236 FUNCTION P_NON_TAX_ID_P RETURN NUMBER;
237
238 FUNCTION CP_TOT_P RETURN NUMBER;
239
240 FUNCTION CP_NON_TOT_P RETURN NUMBER;
241
242 END JL_JLARTSFF_XMLP_PKG;
243
244