1 PACKAGE JA_JAINPLA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINPLAS.pls 120.1 2007/12/25 16:24:25 dwkrishn noship $ */
3 P_AED_OPEN_BAL NUMBER;
4
5 P_BED_OPEN_BAL NUMBER;
6
7 P_FIRST_REC VARCHAR2(1) := 'T';
8
9 P_LOCATION_ID NUMBER;
10
11 P_ORGANIZATION_ID NUMBER;
12
13 P_SED_OPEN_BAL NUMBER;
14
15 P_TRN_FROM_DATE DATE;
16
17 LP_TRN_FROM_DATE varchar2(30);
18
19 P_TRN_TO_DATE DATE;
20
21 LP_TRN_TO_DATE varchar2(30);
22
23 P_TOTAL_BASIC NUMBER;
24
25 P_TOTAL_ADDITIONAL NUMBER;
26
27 P_TOTAL_OTHER NUMBER;
28
29 P_DOC_NO VARCHAR2(32767);
30
31 P_DOC_DATE VARCHAR2(32767);
32
33 P_TR6NO VARCHAR2(50);
34
35 P_FISCAL_YEAR DATE;
36
37 P_MONTH VARCHAR2(3);
38
39 P_CONC_REQUEST_ID NUMBER;
40
41 P_EXCISE_CESS_OPEN_BAL NUMBER;
42
43 P_CVD_CESS_OPEN_BAL NUMBER;
44
45 P_FIRST_REC1 VARCHAR2(1) := 'T';
46
47 P_FIRST_REC2 VARCHAR2(1) := 'T';
48
49 CP_RND_BASIC_ED NUMBER:=0;
50
51 CP_RND_ADDL_ED NUMBER:=0;
52
53 CP_RND_OTHER_ED NUMBER:=0;
54
55 CP_RND_EDU_CESS NUMBER:=0;
56
57 CP_RND_CVD_CESS NUMBER:=0;
58
59 CP_RND_SHE_EDU_CESS NUMBER:=0;
60
61 CP_RND_SHE_CVD_CESS NUMBER:=0;
62
63 CP_BED_OPEN_BAL NUMBER;
64
65 CP_AED_OPEN_BAL NUMBER;
66
67 CP_SED_OPEN_BAL NUMBER;
68
69 CP_PAGE_NO NUMBER;
70
71 CP_EXCISE_CESS_OPEN_BAL NUMBER;
72
73 CP_CVD_CESS_OPEN_BAL NUMBER;
74
75 CP_CR_OPEN_BAL NUMBER;
76
77 CP_ADDITIONAL_OPEN_BAL NUMBER;
78
79 CP_OTHER_OPEN_BAL NUMBER;
80
81 CP_CESS_OPEN_BAL NUMBER;
82
83 CP_CESS_OPEN_BAL_CVD NUMBER;
84
85 FUNCTION CF_BED_CLOSE_BALFORMULA(CR_BASIC_ED IN NUMBER
86 ,DR_BASIC_ED IN NUMBER) RETURN NUMBER;
87
88 FUNCTION CF_AED_CLOSE_BALFORMULA(CR_ADDITIONAL_ED IN NUMBER
89 ,DR_ADDITIONAL_ED IN NUMBER) RETURN NUMBER;
90
91 FUNCTION CF_SED_CLOSE_BALFORMULA(CR_OTHER_ED IN NUMBER
92 ,DR_OTHER_ED IN NUMBER) RETURN NUMBER;
93
94 FUNCTION AFTERPFORM RETURN BOOLEAN;
95
96 FUNCTION CF_2FORMULA(ROUNDING_ID IN NUMBER
97 ,INVENTORY_ITEM_ID IN NUMBER
98 ,DR_INVOICE_NO IN VARCHAR2
99 ,CR_BASIC_ED IN NUMBER
100 ,CR_ADDITIONAL_ED IN NUMBER
101 ,CR_OTHER_ED IN NUMBER
102 ,TR6_CHALLAN_NO IN VARCHAR2
103 ,DR_BASIC_ED IN NUMBER
104 ,DR_ADDITIONAL_ED IN NUMBER
105 ,DR_OTHER_ED IN NUMBER) RETURN VARCHAR2;
106
107 FUNCTION CF_1FORMULA(ROUNDING_ID IN NUMBER
108 ,INVENTORY_ITEM_ID IN NUMBER
109 ,DR_INVOICE_DATE IN VARCHAR2
110 ,CR_BASIC_ED IN NUMBER
111 ,CR_ADDITIONAL_ED IN NUMBER
112 ,CR_OTHER_ED IN NUMBER
113 ,TR6_CHALLAN_DATE IN VARCHAR2
114 ,DR_BASIC_ED IN NUMBER
115 ,DR_ADDITIONAL_ED IN NUMBER
116 ,DR_OTHER_ED IN NUMBER) RETURN VARCHAR2;
117
118 FUNCTION CF_1FORMULA0031(TRANSACTION_ID IN NUMBER
119 ,ROUNDING_ID IN NUMBER
120 ,INVENTORY_ITEM_ID IN NUMBER
121 ,TR6_CHALLAN_DATE IN VARCHAR2
122 ,REMARKS IN VARCHAR2
123 ,DOC_DATE IN DATE
124 ,CR_BASIC_ED IN NUMBER
125 ,CR_ADDITIONAL_ED IN NUMBER
126 ,CR_OTHER_ED IN NUMBER
127 ,DR_BASIC_ED IN NUMBER
128 ,DR_ADDITIONAL_ED IN NUMBER
129 ,DR_OTHER_ED IN NUMBER) RETURN VARCHAR2;
130
131 FUNCTION CF_CETFORMULA(INVENTORY_ITEM_ID IN NUMBER) RETURN VARCHAR2;
132
133 FUNCTION CF_1FORMULA0032(VENDOR_ID IN NUMBER
134 ,VENDOR_SITE_ID IN NUMBER
135 ,VFLAG IN VARCHAR2) RETURN VARCHAR2;
136
137 FUNCTION AFTERREPORT RETURN BOOLEAN;
138
139 FUNCTION CF_FOLIOFORMULA(INVENTORY_ITEM_ID IN NUMBER
140 ,SLNO IN NUMBER) RETURN VARCHAR2;
141
142 FUNCTION CF_OPENING_BALFORMULA RETURN NUMBER;
143
144 FUNCTION CF_CR_OPEN_BALFORMULA RETURN NUMBER;
145
146 FUNCTION CF_ADDITIONAL_OPEN_BALFORMULA RETURN NUMBER;
147
148 FUNCTION CF_OTHER_OPEN_BALFORMULA RETURN NUMBER;
149
150 FUNCTION CF_ACK_RECD_DATEFORMULA(TRANSACTION_ID IN NUMBER
151 ,REGISTER_ID IN NUMBER
152 ,SLNO IN NUMBER
153 ,CREATION_DATE IN DATE) RETURN DATE;
154
155 FUNCTION CF_HDR_EC_CODEFORMULA RETURN CHAR;
156
157 FUNCTION BEFOREREPORT RETURN BOOLEAN;
158
159 FUNCTION CF_CESS_OPEN_BALFORMULA RETURN NUMBER;
160
161 FUNCTION CF_CESS_CLOSE_BALFORMULA1(REGISTER_ID IN NUMBER) RETURN NUMBER;
162
163 FUNCTION CF_CESS_CLOSE_BALFORMULA2(REGISTER_ID IN NUMBER) RETURN NUMBER;
164
165 FUNCTION CF_CR_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
166
167 FUNCTION CF_DB_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
168
169 FUNCTION CF_CR_CVD_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
170
171 FUNCTION CF_DB_CVD_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
172
173 FUNCTION CF_CVD_CESS_CLOS_BALFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
174
175 FUNCTION CF_CVD_CESS_OPEN_BALFORMULA RETURN NUMBER;
176
177 FUNCTION CF_ROUNDING_AMTSFORMULA(TRANSACTION_ID IN NUMBER
178 ,ROUNDING_ID IN NUMBER
179 ,DR_INVOICE_NO IN VARCHAR2) RETURN NUMBER;
180
181 FUNCTION CF_DR_BASIC_EDFORMULA(DR_BASIC_ED IN NUMBER) RETURN NUMBER;
182
183 FUNCTION CF_DR_ADDL_EDFORMULA(DR_ADDITIONAL_ED IN NUMBER) RETURN NUMBER;
184
185 FUNCTION CF_DR_OTHER_EDFORMULA(DR_OTHER_ED IN NUMBER) RETURN NUMBER;
186
187 PROCEDURE OPENING_BALANCE;
188
189 FUNCTION CP_RND_BASIC_ED_P RETURN NUMBER;
190
191 FUNCTION CP_RND_ADDL_ED_P RETURN NUMBER;
192
193 FUNCTION CP_RND_OTHER_ED_P RETURN NUMBER;
194
195 FUNCTION CP_RND_EDU_CESS_P RETURN NUMBER;
196
197 FUNCTION CP_RND_CVD_CESS_P RETURN NUMBER;
198
199 FUNCTION CP_RND_SHE_EDU_CESS_P RETURN NUMBER;
200
201 FUNCTION CP_RND_SHE_CVD_CESS_P RETURN NUMBER;
202
203 FUNCTION CP_BED_OPEN_BAL_P RETURN NUMBER;
204
205 FUNCTION CP_AED_OPEN_BAL_P RETURN NUMBER;
206
207 FUNCTION CP_SED_OPEN_BAL_P RETURN NUMBER;
208
209 FUNCTION CP_PAGE_NO_P RETURN NUMBER;
210
211 FUNCTION CP_EXCISE_CESS_OPEN_BAL_P RETURN NUMBER;
212
213 FUNCTION CP_CVD_CESS_OPEN_BAL_P RETURN NUMBER;
214
215 FUNCTION CP_CR_OPEN_BAL_P RETURN NUMBER;
216
217 FUNCTION CP_ADDITIONAL_OPEN_BAL_P RETURN NUMBER;
218
219 FUNCTION CP_OTHER_OPEN_BAL_P RETURN NUMBER;
220
221 FUNCTION CP_CESS_OPEN_BAL_P RETURN NUMBER;
222
223 FUNCTION CP_CESS_OPEN_BAL_CVD_P RETURN NUMBER;
224
225 LAST_PAGE_G VARCHAR2(1) := 'F';
226
227 LAST_PAGE NUMBER := 0;
228
229 VALIDATION_FLAG VARCHAR2(1) := 'N';
230
231 PREV_PAGE NUMBER := 0;
232
233 END JA_JAINPLA_XMLP_PKG;
234
235