[Home] [Help]
PACKAGE: APPS.JA_JAINMCEN_XMLP_PKG
Source
1 PACKAGE JA_JAINMCEN_XMLP_PKG 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