PACKAGE: APPS.JA_JAINMCEN_XMLP_PKG

Source

1 PACKAGE JA_JAINMCEN_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINMCENS.pls 120.1 2007/12/25 16:23:22 dwkrishn noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_LOCATION_ID NUMBER;
6 
7   P_TRN_FROM_DATE DATE;
8 
9   P_TRN_TO_DATE DATE;
10 
11   P_ADDRESS_LINE_1 VARCHAR2(240);
12 
13   P_ADDRESS_LINE_2 VARCHAR2(240);
14 
15   P_ADDRESS_LINE_3 VARCHAR2(240);
16 
17   P_CIRCLE VARCHAR2(50);
18 
19   P_COLLECT VARCHAR2(50);
20 
21   P_DESCRIPTION VARCHAR2(240);
22 
23   P_EC_CODE VARCHAR2(50);
24 
25   P_ORGANIZATION_NAME VARCHAR2(240);
26 
27   P_RANGE VARCHAR2(50);
28 
29   P_DIVISION VARCHAR2(50);
30 
31   P_CONC_REQUEST_ID NUMBER;
32 
33   P_REGISTER_TYPE VARCHAR2(5);
34 
35   CP_SH_EDU NUMBER;
36 
37   CP_EDU NUMBER;
38 
39   CP_ADDLCVD NUMBER;
40 
41   CP_ADDL NUMBER;
42 
43   CP_SED NUMBER;
44 
45   CP_REPORT_TITLE VARCHAR2(400);
46 
47   CP_QUERY_COUNT NUMBER := 0;
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   FUNCTION CF_ASSESSABLE_VALUEFORMULA(RECEIPT_ID IN VARCHAR2
52                                      ,EXCISE_INVOICE_NO IN VARCHAR2
53                                      ,EXCISE_INVOICE_DATE IN DATE
54                                      ,ORGANIZATION_ID IN NUMBER
55                                      ,LOCATION_ID IN NUMBER) RETURN NUMBER;
56 
57   FUNCTION CF_DOCUMENT_TYPEFORMULA(VENDOR_ID IN NUMBER
58                                   ,RECEIPT_ID IN VARCHAR2
59                                   ,DOCUMENT_TYPE IN VARCHAR2) RETURN CHAR;
60 
61   FUNCTION CF_EC_CODEFORMULA(VENDOR_ID IN NUMBER
62                             ,VENDOR_SITE_ID IN NUMBER
63                             ,RECEIPT_ID IN VARCHAR2
64                             ,EC_CODE IN VARCHAR2) RETURN CHAR;
65 
66   FUNCTION CF_VENDOR_NAMEFORMULA(VENDOR_ID IN NUMBER
67                                 ,VENDOR_SITE_ID IN NUMBER
68                                 ,RECEIPT_ID IN VARCHAR2) RETURN CHAR;
69 
70   FUNCTION CF_VENDOR_TYPEFORMULA(VENDOR_ID IN NUMBER
71                                 ,VENDOR_SITE_ID IN NUMBER
72                                 ,RECEIPT_ID IN VARCHAR2
73                                 ,VENDOR_TYPE IN VARCHAR2) RETURN CHAR;
74 
75   FUNCTION CF_QTYFORMULA(RECEIPT_ID IN VARCHAR2
76                         ,REGISTER_ID IN NUMBER) RETURN NUMBER;
77 
78   FUNCTION CF_POP_COUNTFORMULA RETURN NUMBER;
79 
80   FUNCTION CF_ROUNDED_CENVAT_AMTFORMULA(EXCISE_INVOICE_NO IN VARCHAR2
81                                        ,EXCISE_INVOICE_DATE IN DATE
82                                        ,CENVAT IN NUMBER) RETURN NUMBER;
83 
84   FUNCTION CF_EDUCATION_CESSFORMULA(EXCISE_INVOICE_NO2 IN VARCHAR2
85                                    ,EXCISE_INVOICE_DATE2 IN DATE
86                                    ,REGISTER_ID IN NUMBER) RETURN NUMBER;
87 
88   FUNCTION CF_SEDFORMULA(SED IN NUMBER) RETURN NUMBER;
89 
90   FUNCTION CF_ADDLFORMULA(ADDITIONAL_DUTY IN NUMBER) RETURN NUMBER;
91 
92   FUNCTION AFTERREPORT RETURN BOOLEAN;
93 
94   FUNCTION CF_ADDLCVDFORMULA(ADDITIONAL_CVD IN NUMBER) RETURN NUMBER;
95 
96   FUNCTION CF_SH_EDUCATION_CESSFORMULA(EXCISE_INVOICE_NO IN VARCHAR2
97                                       ,EXCISE_INVOICE_DATE IN DATE
98                                       ,REGISTER_ID IN NUMBER) RETURN NUMBER;
99 
100   FUNCTION CP_SH_EDU_P RETURN NUMBER;
101 
102   FUNCTION CP_EDU_P RETURN NUMBER;
103 
104   FUNCTION CP_ADDLCVD_P RETURN NUMBER;
105 
106   FUNCTION CP_ADDL_P RETURN NUMBER;
107 
108   FUNCTION CP_SED_P RETURN NUMBER;
109 
110   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
111 
112   FUNCTION CP_QUERY_COUNT_P RETURN NUMBER;
113 
114   LV_TAX_TYPE_EXCISE CONSTANT VARCHAR2(15) DEFAULT 'Excise';
115 
116   LV_TAX_TYPE_EXC_ADDITIONAL CONSTANT VARCHAR2(15) DEFAULT 'Addl. Excise';
117 
118   LV_TAX_TYPE_EXC_OTHER CONSTANT VARCHAR2(15) DEFAULT 'Other Excise';
119 
120   LV_TAX_TYPE_CVD CONSTANT VARCHAR2(15) DEFAULT 'CVD';
121 
122   LV_TAX_TYPE_ADDITIONAL_CVD CONSTANT VARCHAR2(15) DEFAULT 'ADDITIONAL_CVD';
123 
124   LV_RCV_TRANSACTION_TYPE CONSTANT VARCHAR2(15) DEFAULT 'RECEIVE';
125 
126   LV_CRCT_TRANSACTION CONSTANT VARCHAR2(15) DEFAULT 'RECEIVE';
127 
128   LV_TAX_TYPE_EXC_EDU_CESS CONSTANT VARCHAR2(30) DEFAULT 'EXCISE_EDUCATION_CESS';
129 
130   LV_TAX_TYPE_CVD_EDU_CESS CONSTANT VARCHAR2(30) DEFAULT 'CVD_EDUCATION_CESS';
131 
132 END JA_JAINMCEN_XMLP_PKG;
133 
134 
135