1 PACKAGE JA_JAINCVAT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINCVATS.pls 120.1 2007/12/25 16:16:53 dwkrishn noship $ */
3 P_ORG_ID NUMBER;
4 P_ORGANIZATION_ID NUMBER;
5 P_LOCATION_ID NUMBER;
6 P_FROM_DATE DATE;
7 P_TO_DATE DATE;
8 P_CONC_REQUEST_ID NUMBER;
9 P_POST_THRU_DATE DATE;
10 CP_CENVAT_CREDIT_TAKEN NUMBER;
11 CP_DUTY_PAYABLE NUMBER;
12 CP_BALANCE_CESS NUMBER;
13 CP_BALANCE_CREDIT NUMBER;
14 CP_BALANCE_SH_CESS NUMBER;
15 CP_ADDITIONAL_CVD NUMBER;
16 CP_CESS_PAYABLE NUMBER;
17 CP_SH_CESS_PAYABLE NUMBER;
18 CP_CESS_CREDIT_TAKEN NUMBER;
19 CP_SH_CESS_CREDIT_TAKEN NUMBER;
20 FUNCTION CF_PERCENTFORMULA(CENVAT_CREDIT_TAKEN IN NUMBER
21 ,DUTY_PAYABLE IN NUMBER) RETURN NUMBER;
22 FUNCTION CF_ORGANIZATION_NAMEFORMULA RETURN CHAR;
23 FUNCTION CF_LOCATION_NAMEFORMULA RETURN CHAR;
24 FUNCTION BEFOREREPORT RETURN BOOLEAN;
25 FUNCTION CF_CESSFORMULA(REGISTER_ID IN NUMBER
26 ,EXCISE_INVOICE_NO IN VARCHAR2
27 ,BALANCE_CESS IN NUMBER) RETURN NUMBER;
28 FUNCTION CF_CENVAT_CREDIT_TAKENFORMULA(REGISTER_ID IN NUMBER
29 ,EXCISE_INVOICE_NO IN VARCHAR2
30 ,CENVAT_CREDIT_TAKEN IN NUMBER
31 ,ADDITIONAL_CVD IN NUMBER
32 ,BALANCE_CREDIT IN NUMBER) RETURN NUMBER;
33 FUNCTION AFTERREPORT RETURN BOOLEAN;
34 FUNCTION CF_SH_CESS_CREDIT_TAKENFORMULA(REGISTER_ID IN NUMBER
35 ,EXCISE_INVOICE_NO IN VARCHAR2) RETURN NUMBER;
36 FUNCTION CF_QUANTITYFORMULA(TRANSACTION_ID IN NUMBER
37 ,QUANTITY IN NUMBER
38 ,REFERENCE_NUM IN VARCHAR2
39 ,DUTY_PAYABLE IN NUMBER
40 ,CF_CENVAT_CREDIT_TAKEN IN NUMBER
41 ,CF_CESS_CREDIT_TAKEN IN NUMBER
42 ,CF_SH_CESS_CREDIT_TAKEN IN NUMBER) RETURN NUMBER;
43 FUNCTION CP_CENVAT_CREDIT_TAKEN_P RETURN NUMBER;
44 FUNCTION CP_DUTY_PAYABLE_P RETURN NUMBER;
45 FUNCTION CP_BALANCE_CESS_P RETURN NUMBER;
46 FUNCTION CP_BALANCE_CREDIT_P RETURN NUMBER;
47 FUNCTION CP_BALANCE_SH_CESS_P RETURN NUMBER;
48 FUNCTION CP_ADDITIONAL_CVD_P RETURN NUMBER;
49 FUNCTION CP_CESS_PAYABLE_P RETURN NUMBER;
50 FUNCTION CP_SH_CESS_PAYABLE_P RETURN NUMBER;
51 FUNCTION CP_CESS_CREDIT_TAKEN_P RETURN NUMBER;
52 FUNCTION CP_SH_CESS_CREDIT_TAKEN_P RETURN NUMBER;
53 END JA_JAINCVAT_XMLP_PKG;
54
55