DBA Data[Home] [Help]

PACKAGE: APPS.JA_JAINCVAT_XMLP_PKG

Source


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