1 PACKAGE JA_JAINVATR_XMLP_PKG AS
2 /* $Header: JAINVATRS.pls 120.1 2007/12/25 16:33:43 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER;
4
5 P_REGIME_TAXES VARCHAR2(4000);
6
7 P_ORGN_ID NUMBER;
8
9 P_LOCN_ID NUMBER;
10
11 P_FROM_DATE DATE;
12
13 P_TO_DATE DATE;
14
15 P_REGN_NO VARCHAR2(240);
16
17 P_REGIME VARCHAR2(240);
18
19 P_CAN_DATE_FROM VARCHAR2(240);
20
21 P_CAN_DATE_TO VARCHAR2(240);
22
23 FUNCTION BEFOREREPORT RETURN BOOLEAN;
24
25 FUNCTION CF_TURNOVER_ISO_SHIPMENTSFORMU(A_ORGANIZATION_ID IN NUMBER
26 ,A_LOCATION_ID IN NUMBER) RETURN NUMBER;
27
28 FUNCTION CF_TURNOVER_ISO_RECEIPTSFORMUL(A_ORGANIZATION_ID IN NUMBER
29 ,A_LOCATION_ID IN NUMBER) RETURN NUMBER;
30
31 FUNCTION CF_SALES_TOTAL_BASE_AMTFORMULA(CS_SALES_NEX_BASE_AMT IN NUMBER
32 ,CS_SALES_CST_BASE_AMT IN NUMBER
33 ,CS_SALES_EX_BASE_AMT IN NUMBER
34 ,CF_TURNOVER_ISO_SHIPMENTS IN NUMBER) RETURN NUMBER;
35
36 FUNCTION CF_SALES_TOTAL_TAX_AMTFORMULA(CS_SALES_NEX_TAX_AMT IN NUMBER
37 ,CS_SALES_CST_TAX_AMT IN NUMBER
38 ,CS_SALES_VATREV_TAX_AMT IN NUMBER) RETURN NUMBER;
39
40 FUNCTION CF_PUR_TOTAL_BASE_AMTFORMULA(CS_PUR_NCG_UNREG_BASE_AMT IN NUMBER
41 ,CS_PUR_NCG_REG_BASE_AMT IN NUMBER
42 ,CS_PUR_NCG_CST_BASE_AMT IN NUMBER
43 ,CF_TURNOVER_ISO_RECEIPTS IN NUMBER
44 ,CS_PUR_CG_BASE_AMT IN NUMBER) RETURN NUMBER;
45
46 FUNCTION CF_PUR_TOTAL_TAX_AMTFORMULA(CS_PUR_NCG_UNREG_TAX_AMT IN NUMBER
47 ,CS_PUR_NCG_REG_TAX_AMT IN NUMBER
48 ,CS_PUR_NCG_CST_TAX_AMT IN NUMBER
49 ,CS_PUR_CG_TAX_AMT IN NUMBER) RETURN NUMBER;
50
51 FUNCTION CF_PUR_CG_TOTAL_TAX_CLAIMEDFOR(A_ORGANIZATION_ID IN NUMBER
52 ,A_LOCATION_ID IN NUMBER) RETURN NUMBER;
53
54 FUNCTION CF_TAX_SUMMARYFORMULA(CF_SALES_TOTAL_TAX_AMT IN NUMBER
55 ,CF_INPUTTAX_CLAIMABLE IN NUMBER
56 ,CF_PUR_CG_TOTAL_TAX_CLAIMED IN NUMBER) RETURN NUMBER;
57
58 FUNCTION CF_INPUTTAX_CLAIMABLEFORMULA(CF_PUR_TOTAL_TAX_AMT IN NUMBER
59 ,CS_TAX_INTERSTATE_PUR IN NUMBER) RETURN NUMBER;
60
61 FUNCTION AFTERREPORT RETURN BOOLEAN;
62
63 END JA_JAINVATR_XMLP_PKG;
64
65