1 PACKAGE JA_JAINER1_XMLP_PKG AS
2 /* $Header: JAINER1S.pls 120.1 2007/12/25 16:18:02 dwkrishn noship $ */
3 P_LOCATION_ID NUMBER;
4
5 P_ORGANIZATION_ID NUMBER;
6
7 P_START_DATE DATE;
8
9 P_END_DATE DATE;
10
11 P_ORGANIZATION_NAME VARCHAR2(240);
12
13 P_OPERATING_UNIT NUMBER;
14
15 P_REGISTRATION_NUMBER VARCHAR2(240);
16
17 P_CONC_REQUEST_ID NUMBER;
18
19 P_GROUP_BY VARCHAR2(32767);
20
21 P_CITY VARCHAR2(75);
22
23 CP_AED_DUTY_PAYABLE NUMBER;
24
25 CP_CRDT_IMPORT_CAP_GOODS NUMBER;
26
27 CP_CRDT_IMPORT_INPUT NUMBER;
28
29 CP_CESS_CREDIT_AVLD NUMBER;
30
31 CP_SH_CESS_CREDIT_AVLD NUMBER;
32
33 CP_AED_ACC_CURRENT NUMBER;
34
35 FUNCTION CENVAT_BASIC_ED RETURN NUMBER;
36
37 FUNCTION CF_ORGANIZATION_NAMEFORMULA RETURN CHAR;
38
39 FUNCTION CF_EC_CODEFORMULA RETURN CHAR;
40
41 FUNCTION CF_CENVAT_DUTYFORMULA(CETSH IN VARCHAR2
42 ,INVENTORY_ITEM_ID IN NUMBER
43 ,UNITS IN VARCHAR2) RETURN NUMBER;
44
45 FUNCTION CF_ASSESSABLE_VALUEFORMULA0008(CF_RATE IN NUMBER
46 ,CF_DUTY_PAYABLE IN NUMBER) RETURN NUMBER;
47
48 FUNCTION CF_CENVAT_ACC_CURRENTFORMULA RETURN NUMBER;
49
50 FUNCTION CF_OTHER_ACC_CURRENTFORMULA RETURN NUMBER;
51
52 FUNCTION CF_CENVAT_ACC_CREDITFORMULA RETURN NUMBER;
53
54 FUNCTION CF_OTHER_ACC_CREDITFORMULA RETURN NUMBER;
55
56 FUNCTION CF_CENVAT_TOTALFORMULA(CF_CENVAT_ACC_CURRENT IN NUMBER
57 ,CF_CENVAT_ACC_CREDIT IN NUMBER) RETURN NUMBER;
58
59 FUNCTION CF_OTHER_TOTALFORMULA(CF_OTHER_ACC_CURRENT IN NUMBER
60 ,CF_OTHER_ACC_CREDIT IN NUMBER) RETURN NUMBER;
61
62 FUNCTION CF_OPENING_BALANCEFORMULA RETURN NUMBER;
63
64 FUNCTION CF_CLOSING_BALANCEFORMULA(CF_OPENING_BALANCE IN NUMBER
65 ,TOTAL_CREDIT_AVAILED IN NUMBER
66 ,CF_CR_UTILIZED IN NUMBER
67 ,CF_RTV_AMOUNT IN NUMBER) RETURN NUMBER;
68
69 FUNCTION CF_MONTHFORMULA RETURN VARCHAR2;
70
71 FUNCTION CF_CESS_EXCISE_INPUTFORMULA RETURN NUMBER;
72
73 FUNCTION CF_CESS_EXCISE_CAPFORMULA RETURN NUMBER;
74
75 FUNCTION CF_TAX_SERVICESFORMULA RETURN NUMBER;
76
77 FUNCTION CF_TAX_DUTY_GOODSFORMULA RETURN NUMBER;
78
79 FUNCTION CF_CESS_TAX_DUTY_GOODSFORMULA RETURN NUMBER;
80
81 FUNCTION CF_TAX_DUTY_SERVICESFORMULA RETURN NUMBER;
82
83 FUNCTION CF_CESS_TAX_DUTY_SERVICESFORMU RETURN NUMBER;
84
85 FUNCTION CF_CESS_OPENING_BLNCFORMULA RETURN NUMBER;
86
87 FUNCTION BEFOREREPORT RETURN BOOLEAN;
88
89 FUNCTION CF_SRVC_OPEN_BALNCFORMULA RETURN NUMBER;
90
91 FUNCTION CF_SRVC_CESS_OPNGFORMULA RETURN NUMBER;
92
93 FUNCTION CF_CLOSING_BLNC_STFORMULA(CF_SRVC_OPEN_BALNC IN NUMBER
94 ,CF_TOT_CR_AVAILED_ST IN NUMBER
95 ,CF_TAX_DUTY_GOODS IN NUMBER) RETURN NUMBER;
96
97 FUNCTION CF_TOT_CR_AVAILED_ECFORMULA(CF_CESS_EXCISE_INPUT IN NUMBER
98 ,CF_CESS_EXCISE_CAP IN NUMBER) RETURN NUMBER;
99
100 FUNCTION CF_TOT_CR_AVAILED_STFORMULA(CF_SRVC_OPEN_BALNC IN NUMBER
101 ,CF_TAX_SERVICES IN NUMBER) RETURN NUMBER;
102
103 FUNCTION CF_TOT_CR_AVAILED_SCFORMULA(CF_SRVC_CESS_OPNG IN NUMBER) RETURN NUMBER;
104
105 FUNCTION CF_CLOSING_BLNC_ECFORMULA(CF_CESS_OPENING_BLNC IN NUMBER
106 ,CF_TOT_CR_AVAILED_EC IN NUMBER
107 ,CF_CESS_UTIL_PAY_GOODS IN NUMBER
108 ,CF_CR_UTIL_INP_RM_CESS IN NUMBER) RETURN NUMBER;
109
110 FUNCTION CF_CLOSING_BLNC_SCFORMULA(CF_SRVC_CESS_OPNG IN NUMBER
111 ,CF_TOT_CR_AVAILED_SC IN NUMBER
112 ,CF_CESS_TAX_DUTY_GOODS IN NUMBER) RETURN NUMBER;
113
114 FUNCTION CF_1FORMULA(REGISTER IN VARCHAR2
115 ,INVENTORY_ITEM_ID IN NUMBER
116 ,CETSH IN VARCHAR2
117 ,UNITS IN VARCHAR2
118 ,EXCISE_DUTY_RATE IN NUMBER) RETURN NUMBER;
119
120 FUNCTION CF_QTY_CLEAREDFORMULA(REGISTER IN VARCHAR2
121 ,INVENTORY_ITEM_ID IN NUMBER
122 ,CETSH IN VARCHAR2
123 ,EXCISE_DUTY_RATE IN NUMBER
124 ,UNITS IN VARCHAR2) RETURN NUMBER;
125
126 FUNCTION CF_TR6_CHALLAN_AMNTFORMULA RETURN NUMBER;
127
128 FUNCTION CF_RATEFORMULA(CF_QTY_CLEARED IN NUMBER
129 ,EXCISE_DUTY_RATE IN NUMBER) RETURN NUMBER;
130
131 FUNCTION CF_DUTY_PAYABLEFORMULA(INVENTORY_ITEM_ID IN NUMBER
132 ,CETSH IN VARCHAR2
133 ,UNITS IN VARCHAR2
134 ,EXCISE_DUTY_RATE IN NUMBER
135 ,REGISTER IN VARCHAR2) RETURN NUMBER;
136
137 FUNCTION CF_OTHER_DUTIESFORMULA(INVENTORY_ITEM_ID IN NUMBER
138 ,CETSH IN VARCHAR2
139 ,UNITS IN VARCHAR2
140 ,EXCISE_DUTY_RATE IN NUMBER
141 ,REGISTER IN VARCHAR2) RETURN NUMBER;
142
143 FUNCTION CF_CESS_UTIL_PAY_GOODSFORMULA(CF_CR_UTIL_INP_RM_CESS IN NUMBER) RETURN NUMBER;
144
145 FUNCTION CF_ITEM_DESCRIPTION(INVENTORY_ITEM_ID IN NUMBER) RETURN CHAR;
146
147 FUNCTION CF_CREDIT_INPUT_MANF RETURN NUMBER;
148
149 FUNCTION CF_CREDIT_INPUT_I_II_STG RETURN NUMBER;
150
151 FUNCTION CF_CESS_EXCISE_INPUT_MANF RETURN NUMBER;
152
153 FUNCTION CF_CESS_EXCISE_INPUT_STG RETURN NUMBER;
154
155 FUNCTION CF_GET_CETSH(INVENTORY_ITEM_ID IN NUMBER
156 ,CETSH_SUB IN VARCHAR2) RETURN CHAR;
157
158 FUNCTION CF_CENVAT_TOTAL1(CF_CENVAT_ACC_CURRENT IN NUMBER
159 ,CF_CENVAT_CREDIT_UTILIZED IN NUMBER) RETURN NUMBER;
160
161 FUNCTION AFTERREPORT RETURN BOOLEAN;
162
163 FUNCTION CF_RTV_AMOUNTFORMULA RETURN NUMBER;
164
165 FUNCTION CF_CR_UTILIZEDFORMULA(CREDIT_UTILIZED IN NUMBER
166 ,CF_RTV_AMOUNT IN NUMBER) RETURN NUMBER;
167
168 FUNCTION CF_CR_UTIL_INP_RM_CESSFORMULA RETURN NUMBER;
169
170 FUNCTION CF_LTUFORMULA RETURN CHAR;
171
172 FUNCTION CF_CRDT_AVALIED_CAP_GOODSFORMU(CREDIT_AVAILED_ON_CAP_GOODS IN NUMBER) RETURN NUMBER;
173
174 FUNCTION CF_PLA_OPENING_BALANCEFORMULA RETURN NUMBER;
175
176 FUNCTION CF_PLA_TR6_CHALLAN_AMTFORMULA RETURN NUMBER;
177
178 FUNCTION CF_PLA_TOTALFORMULA(CF_PLA_OPENING_BALANCE IN NUMBER
179 ,CF_PLA_TR6_CHALLAN_AMT IN NUMBER) RETURN NUMBER;
180
181 FUNCTION CF_PLA_CLOSING_BALANCEFORMULA(CF_PLA_TOTAL IN NUMBER
182 ,CF_CENVAT_ACC_CURRENT IN NUMBER) RETURN NUMBER;
183
184 FUNCTION CF_AED_ACC_CREDITFORMULA RETURN NUMBER;
185
186 FUNCTION CF_AED_TOTALFORMULA(CF_AED_ACC_CREDIT IN NUMBER) RETURN NUMBER;
187
188 FUNCTION CF_CENVAT_CREDIT_UTILIZEDFORMU(CREDIT_UTILIZED IN NUMBER
189 ,CF_AED_ACC_CREDIT IN NUMBER) RETURN NUMBER;
190
191 FUNCTION CF_EXCISE_UOMFORMULA(ORGANIZATION_ID IN NUMBER
192 ,UNITS IN VARCHAR2) RETURN CHAR;
193
194 FUNCTION CF_SH_CESS_OPENING_BLNCFORMULA RETURN NUMBER;
195
196 FUNCTION CF_SH_CESS_EXCISE_INPUT_MANFFO RETURN NUMBER;
197
198 FUNCTION CF_SH_CESS_EXCISE_INPUT_STGFOR RETURN NUMBER;
199
200 FUNCTION CF_SH_CESS_EXCISE_CAPFORMULA RETURN NUMBER;
201
202 FUNCTION CF_TOT_CR_AVAILED_SH_ECFORMULA(CF_SH_CESS_EXCISE_INPUT IN NUMBER
203 ,CF_SH_CESS_EXCISE_CAP IN NUMBER) RETURN NUMBER;
204
205 FUNCTION CF_SH_CESS_EXCISE_INPUTFORMULA RETURN NUMBER;
206
207 FUNCTION CF_SH_CESS_UTIL_PAY_GOODSFORMU(CF_CR_UTIL_INP_RM_SH_CESS IN NUMBER) RETURN NUMBER;
208
209 FUNCTION CF_SRVC_SH_CESS_OPNGFORMULA RETURN NUMBER;
210
211 FUNCTION CF_CR_UTIL_INP_RM_SH_CESSFORMU RETURN NUMBER;
212
213 FUNCTION CF_CLOSING_BLNC_SH_ECFORMULA(CF_SH_CESS_OPENING_BLNC IN NUMBER
214 ,CF_TOT_CR_AVAILED_SH_EC IN NUMBER
215 ,CF_SH_CESS_UTIL_PAY_GOODS IN NUMBER
216 ,CF_CR_UTIL_INP_RM_SH_CESS IN NUMBER) RETURN NUMBER;
217
218 FUNCTION CF_CLOSING_BLNC_SH_SCFORMULA(CF_SRVC_SH_CESS_OPNG IN NUMBER
219 ,CF_TOT_CR_AVAILED_SH_SC IN NUMBER
220 ,CF_SH_CESS_TAX_DUTY_GOODS IN NUMBER) RETURN NUMBER;
221
222 FUNCTION CF_SH_CESS_TAX_DUTY_GOODSFORMU RETURN NUMBER;
223
224 FUNCTION CF_TOT_CR_AVAILED_SH_SCFORMULA(CF_SRVC_SH_CESS_OPNG IN NUMBER) RETURN NUMBER;
225
226 FUNCTION CF_OTHER_SH_ACC_CREDITFORMULA RETURN NUMBER;
227
228 FUNCTION CF_OTHER_SH_ACC_CURRENTFORMULA RETURN NUMBER;
229
230 FUNCTION CF_SH_OTHER_TOTALFORMULA(CF_OTHER_SH_ACC_CURRENT IN NUMBER
231 ,CF_OTHER_SH_ACC_CREDIT IN NUMBER) RETURN NUMBER;
232
233 FUNCTION CF_SH_OTHER_DUTIESFORMULA(INVENTORY_ITEM_ID IN NUMBER
234 ,CETSH IN VARCHAR2
235 ,UNITS IN VARCHAR2
236 ,EXCISE_DUTY_RATE IN NUMBER
237 ,REGISTER IN VARCHAR2) RETURN NUMBER;
238
239 FUNCTION CP_AED_DUTY_PAYABLE_P RETURN NUMBER;
240
241 FUNCTION CP_CRDT_IMPORT_CAP_GOODS_P RETURN NUMBER;
242
243 FUNCTION CP_CRDT_IMPORT_INPUT_P RETURN NUMBER;
244
245 FUNCTION CP_CESS_CREDIT_AVLD_P RETURN NUMBER;
246
247 FUNCTION CP_SH_CESS_CREDIT_AVLD_P RETURN NUMBER;
248
249 FUNCTION CP_AED_ACC_CURRENT_P RETURN NUMBER;
250
251 TAX_TYPE_SERVICE_EDU_CESS VARCHAR2(30) := 'SERVICE_EDUCATION_CESS';
252
253 TAX_TYPE_EXC_EDU_CESS VARCHAR2(30) := 'EXCISE_EDUCATION_CESS';
254
255 TAX_TYPE_CVD_EDU_CESS VARCHAR2(30) := 'CVD_EDUCATION_CESS';
256
257 TAX_TYPE_CUSTOMS_EDU_CESS VARCHAR2(30) := 'CUSTOMS_EDUCATION_CESS';
258
259 TAX_TYPE_TCS_CESS CONSTANT VARCHAR2(30) DEFAULT 'TCS_CESS';
260
261 TAX_TYPE_SH_EXC_EDU_CESS VARCHAR2(30) := 'EXCISE_SH_EDU_CESS';
262
263 TAX_TYPE_SH_CVD_EDU_CESS VARCHAR2(30) := 'CVD_SH_EDU_CESS';
264
265 TAX_TYPE_SH_CUSTOMS_EDU_CESS VARCHAR2(30) := 'CUSTOMS_SH_EDU_CESS';
266
267 TAX_TYPE_SH_SERVICE_EDU_CESS VARCHAR2(30) := 'SERVICE_SH_EDU_CESS';
268
269 TAX_TYPE_SH_TCS_EDU_CESS VARCHAR2(30) := 'TCS_SH_EDU_CESS';
270
271 END JA_JAINER1_XMLP_PKG;
272
273