PACKAGE: APPS.JA_JAINITCP_XMLP_PKG

Source

1 PACKAGE JA_JAINITCP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINITCPS.pls 120.1 2007/12/25 16:21:23 dwkrishn noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_SUPPLIER_ORG_TYPE VARCHAR2(25);
6   P_SUPPLIER_ORG_TYPE_T VARCHAR2(25);
7 
8   P_FROM_DATE DATE;
9   P_FROM_DATE_T DATE;
10 
11   P_TO_DATE DATE;
12   P_TO_DATE_T DATE;
13 
14   P_TDS_PAYMENT_TYPE VARCHAR2(25);
15 
16   F_ADDRS_LINE1 VARCHAR2(50);
17 
18   F_COUNTRY VARCHAR2(10);
19 
20   F_INTERNAL_ADDRS VARCHAR2(50);
21 
22   F_NAME VARCHAR2(30);
23 
24   F_TDS_PREFIX VARCHAR2(50);
25 
26   F_TDS_VENDOR VARCHAR2(32767);
27 
28   F_VENDOR_NAME VARCHAR2(50);
29 
30   P_FIN_YEAR VARCHAR2(40);
31 
32   P_CONC_REQUEST_ID NUMBER;
33 
34   P_ORG_TAN_NUM VARCHAR2(50);
35 
36   P_VENDOR_ID NUMBER;
37 
38   P_VENDOR_SITE_ID NUMBER;
39 
40   P_ORG_ID NUMBER;
41 
42   P_REPORTING_ENTITY_ID NUMBER;
43 
44   P_REPORTING_LEVEL VARCHAR2(30);
45 
46   P_ORG_WHERE VARCHAR2(2000);
47 
48   CP_CESS_AMOUNT NUMBER;
49 
50   CP_SURCHARGE_AMOUNT NUMBER;
51 
52   CP_TDS_AMOUNT NUMBER;
53 
54   CP_SH_CESS_AMOUNT NUMBER;
55 
56   FUNCTION BEFOREREPORT RETURN BOOLEAN;
57 
58   FUNCTION CF_GROSS_INV_AMTFORMULA(INVOICE_ID_V IN NUMBER
59                                   ,INVOICE_AMOUNT IN NUMBER) RETURN NUMBER;
60 
61   FUNCTION AFTERPFORM RETURN BOOLEAN;
62 
63   FUNCTION CF_VENDOR_SITE_ADDRESSFORMULA(VENDOR_SITE_ID_V IN NUMBER) RETURN CHAR;
64 
65   FUNCTION CF_ACCOUNTING_DATEFORMULA(INVOICE_ID_V IN NUMBER) RETURN DATE;
66 
67   FUNCTION CF_TDS_AMOUNTFORMULA(INVOICE_ID_V IN NUMBER
68                                ,TAX_RATE IN NUMBER
69                                ,SURCHARGE_RATE IN NUMBER
70                                ,INVOICE_AMOUNT IN NUMBER) RETURN NUMBER;
71 
72   FUNCTION CF_INVOICE_AMOUNTFORMULA(INVOICE_ID_V IN NUMBER
73                                    ,INVOICE_AMOUNT IN NUMBER) RETURN NUMBER;
74 
75   FUNCTION CF_TOT_TDS_TAX_AMOUNTFORMULA(TDS_INV_AMT IN NUMBER
76                                        ,SUR_AMT IN NUMBER) RETURN NUMBER;
77 
78   FUNCTION P_SUPPLIER_ORG_TYPEVALIDTRIGGE RETURN BOOLEAN;
79 
80   FUNCTION CF_PAN_NOFORMULA(VENDOR_ID IN NUMBER
81                            ,VENDOR_SITE_ID IN NUMBER) RETURN CHAR;
82 
83   FUNCTION GET_PAN_TAN(P_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE
84                       ,P_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE
85                       ,P_PAN_OR_TAN IN VARCHAR2) RETURN VARCHAR2;
86 
87   FUNCTION AFTERREPORT RETURN BOOLEAN;
88 
89   FUNCTION CF_AMOUNTSFORMULA(INVOICE_ID IN NUMBER
90                             ,TAX_ID IN NUMBER
91                             ,TOT_TAX_AMT IN NUMBER) RETURN NUMBER;
92 
93   FUNCTION CP_CESS_AMOUNT_P RETURN NUMBER;
94 
95   FUNCTION CP_SURCHARGE_AMOUNT_P RETURN NUMBER;
96 
97   FUNCTION CP_TDS_AMOUNT_P RETURN NUMBER;
98 
99   FUNCTION CP_SH_CESS_AMOUNT_P RETURN NUMBER;
100 
101 END JA_JAINITCP_XMLP_PKG;
102