1 PACKAGE JA_JAIN23P2_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAIN23P2S.pls 120.1 2007/12/25 16:08:19 dwkrishn noship $ */
3 P_ORGANIZATION_ID NUMBER;
4 P_LOCATION_ID NUMBER;
5 P_TRN_FROM_DATE DATE;
6 P_OPEN_BAL NUMBER;
7 P_OPEN_BAL_OTH NUMBER;
8 P_TRN_TO_DATE DATE;
9 P_CLOSE_BAL NUMBER;
10 P_PREV_CLOSE_BAL NUMBER;
11 P_FIRST_REC VARCHAR2(1);
12 P_START_PAGE_NO NUMBER;
13 P_CONC_REQUEST_ID NUMBER;
14 P_QUERY_CONCAT VARCHAR2(1000);
15 P_REGISTER_TYPE VARCHAR2(1);
16 P_SELECTED_REGISTER_TYPE VARCHAR2(1000);
17 P_REPORT_SEQ_NO NUMBER := 0;
18 P_CVD_EDU_CESS_OP_BAL NUMBER;
19 P_EXC_EDU_CESS_OP_BAL NUMBER;
20 P_CVD_EDU_SH_CESS_OP_BAL NUMBER;
21 P_EXC_EDU_SH_CESS_OP_BAL NUMBER;
22 CP_ADDITIONAL_ROUNDING NUMBER := 0;
23 CP_ADDITIONALCVD_ROUNDING NUMBER := 0;
24 CP_OTHER_ROUNDING NUMBER := 0;
25 CP_ROUNDED_EXCISE_CESS NUMBER;
26 CP_ROUNDED_SH_EXCISE_CESS NUMBER;
27 CP_ROUNDED_CVD_CESS NUMBER;
28 CP_ROUNDED_SH_CVD_CESS NUMBER;
29 CP_RND_DR_BASIC_ED NUMBER;
30 CP_RND_DR_ADDL_ED NUMBER;
31 CP_RND_DR_ADDL_CVD NUMBER;
32 CP_RND_DR_OTHER_ED NUMBER;
33 CP_RND_DR_EXC_EDU_CESS NUMBER;
34 CP_RND_DR_SH_CVD_EDU_CESS NUMBER;
35 CP_RND_DR_CVD_EDU_CESS NUMBER;
36 CP_RND_DR_SH_EXC_EDU_CESS NUMBER;
37 CP_1 NUMBER;
38 C_NAME VARCHAR2(240);
39 C_DESCRIPTION VARCHAR2(240);
40 C_ADDRESS_LINE_1 VARCHAR2(240);
41 C_ADDRESS_LINE_2 VARCHAR2(240);
42 C_ADDRESS_LINE_3 VARCHAR2(240);
43 C_EC_CODE VARCHAR2(50);
44 C_EXCISECOMM VARCHAR2(50);
45 C_EXCISEDIVISION VARCHAR2(50);
46 C_EXCISECIRCLE VARCHAR2(50);
47 C_EXCISERANGE VARCHAR2(50);
48 CP_REPORT_TITLE VARCHAR2(50);
49 FUNCTION AFTERPFORM RETURN BOOLEAN;
50 FUNCTION BEFOREREPORT RETURN BOOLEAN;
51 FUNCTION CF_DIVISION_NOFORMULA(VENDOR_ID IN NUMBER
52 ,VENDOR_SITE_ID IN NUMBER
53 ,RECEIPT_ID IN VARCHAR2
54 ,DIVISION_NO IN VARCHAR2) RETURN CHAR;
55 FUNCTION CF_RANGE_NOFORMULA(VENDOR_ID IN NUMBER
56 ,VENDOR_SITE_ID IN NUMBER
57 ,RECEIPT_ID IN VARCHAR2
58 ,RANGE_NO IN VARCHAR2) RETURN CHAR;
59 FUNCTION CF_EC_CODE_SUPPFORMULA(VENDOR_ID IN NUMBER
60 ,VENDOR_SITE_ID IN NUMBER
61 ,CR_BASIC_ED IN NUMBER
62 ,CR_ADDITIONAL_ED IN NUMBER
63 ,CR_ADDITIONAL_CVD IN NUMBER
64 ,CR_OTHER_ED IN NUMBER
65 ,RECEIPT_ID IN VARCHAR2) RETURN VARCHAR2;
66 FUNCTION CF_EC_CODE_CUSTFORMULA(CUSTOMER_ID_1 IN NUMBER
67 ,CUSTOMER_SITE_ID IN NUMBER
68 ,DR_BASIC_ED IN NUMBER
69 ,DR_ADDITIONAL_ED IN NUMBER
70 ,DR_OTHER_ED IN NUMBER) RETURN VARCHAR2;
71 FUNCTION CF_SEQUENCE_NOFORMULA RETURN NUMBER;
72 FUNCTION CF_ROUNDING_AMOUNTFORMULA(TRANSACTION_ID IN NUMBER
73 ,EXCISE_INVOICE_NO IN VARCHAR2
74 ,EXCISE_INVOICE_DATE IN DATE
75 ,RECEIPT_ID IN VARCHAR2) RETURN NUMBER;
76 FUNCTION CF_CR_BASIC_EDFORMULA(CR_BASIC_ED IN NUMBER
77 ,CF_ROUNDING_AMOUNT IN NUMBER) RETURN NUMBER;
78 FUNCTION CF_RECEIPT_NUMFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
79 ,EXCISE_INVOICE_DATE_1 IN DATE
80 ,RECEIPT_ID IN VARCHAR2
81 ,TRANSACTION_ID IN NUMBER) RETURN VARCHAR2;
82 FUNCTION CF_FOLIO_PART_IFORMULA(P_EXCISE_INVOICE_NO IN VARCHAR2
83 ,P_EXCISE_INVOICE_DATE IN DATE) RETURN VARCHAR2;
84 FUNCTION CF_CLOSING_BALFORMULA(CS_CR_BASIC_ED IN NUMBER
85 ,CS_CR_ADDL_ED IN NUMBER
86 ,CS_CR_OTHER_ED IN NUMBER
87 ,CS_CR_ADDL_CVD IN NUMBER
88 ,CS_DR_BASIC_ED IN NUMBER
89 ,CS_DR_ADDL_N_OTH IN NUMBER
90 ,CS_DR_ADDL_CVD IN NUMBER) RETURN NUMBER;
91 FUNCTION CF_EXC_CLOSING_BALANCEFORMULA(CS_CR_EXCISE IN NUMBER
92 ,CS_DR_EXCISE IN NUMBER) RETURN NUMBER;
93 FUNCTION CF_CR_CVDFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
94 ,EXCISE_INVOICE_DATE_1 IN DATE
95 ,VENDOR_ID_1 IN NUMBER
96 ,VENDOR_SITE_ID_1 IN NUMBER
97 ,CUSTOMER_ID_1 IN NUMBER
98 ,CUSTOMER_SITE_ID_1 IN NUMBER) RETURN NUMBER;
99 FUNCTION CF_CR_EXCISEFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
100 ,EXCISE_INVOICE_DATE_1 IN DATE
101 ,VENDOR_ID_1 IN NUMBER
102 ,VENDOR_SITE_ID_1 IN NUMBER
103 ,CUSTOMER_ID_1 IN NUMBER
104 ,CUSTOMER_SITE_ID_1 IN NUMBER) RETURN NUMBER;
105 FUNCTION CF_DR_EXCISEFORMULA(OTHER_TAX_DEBIT IN NUMBER) RETURN NUMBER;
106 FUNCTION CF_DR_CVDFORMULA RETURN NUMBER;
107 FUNCTION CF_REGISTER_IDFORMULA(RECEIPT_ID IN VARCHAR2) RETURN NUMBER;
108 FUNCTION CF_CVD_CLOSING_BALFORMULA(CS_CR_CVD IN NUMBER
109 ,CS_DR_CVD IN NUMBER) RETURN NUMBER;
110 FUNCTION CF_OTHER_AMOUNTFORMULA(CR_OTHER_ED IN NUMBER) RETURN NUMBER;
111 FUNCTION CF_ADDITIONAL_AMOUNTFORMULA(CR_ADDITIONAL_ED IN NUMBER) RETURN NUMBER;
112 FUNCTION CF_DR_BASIC_EDFORMULA(DR_BASIC_ED IN NUMBER) RETURN NUMBER;
113 FUNCTION CF_DR_ADDL_N_OTH_EDFORMULA(DR_ADDL_N_OTH_ED IN NUMBER) RETURN NUMBER;
114 FUNCTION AFTERREPORT RETURN BOOLEAN;
115 FUNCTION CF_ADDITIONALCVD_AMOUNTFORMULA(CR_ADDITIONAL_CVD IN NUMBER) RETURN NUMBER;
116 FUNCTION CF_DR_ADDL_CVDFORMULA(DR_ADDITIONAL_CVD IN NUMBER) RETURN NUMBER;
117 FUNCTION CF_CR_SH_CVDFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
118 ,EXCISE_INVOICE_DATE_1 IN DATE
119 ,VENDOR_ID_1 IN NUMBER
120 ,VENDOR_SITE_ID_1 IN NUMBER
121 ,CUSTOMER_ID_1 IN NUMBER
122 ,CUSTOMER_SITE_ID_1 IN NUMBER
123 ,TRANSACTION_ID IN NUMBER) RETURN NUMBER;
124 FUNCTION CF_CR_SH_EXCISEFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
125 ,EXCISE_INVOICE_DATE_1 IN DATE
126 ,VENDOR_ID_1 IN NUMBER
127 ,VENDOR_SITE_ID_1 IN NUMBER
128 ,CUSTOMER_ID_1 IN NUMBER
129 ,CUSTOMER_SITE_ID_1 IN NUMBER
130 ,TRANSACTION_ID IN NUMBER) RETURN NUMBER;
131 FUNCTION CF_DR_SH_EXCISEFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
132 ,EXCISE_INVOICE_DATE_1 IN DATE
133 ,VENDOR_ID_1 IN NUMBER
134 ,VENDOR_SITE_ID_1 IN NUMBER
135 ,CUSTOMER_ID_1 IN NUMBER
136 ,CUSTOMER_SITE_ID_1 IN NUMBER
137 ,TRANSACTION_ID IN NUMBER) RETURN NUMBER;
138 FUNCTION CF_DR_SH_CVDFORMULA(EXCISE_INVOICE_NO_1 IN VARCHAR2
139 ,EXCISE_INVOICE_DATE_1 IN DATE
140 ,VENDOR_ID_1 IN NUMBER
141 ,VENDOR_SITE_ID_1 IN NUMBER
142 ,CUSTOMER_ID_1 IN NUMBER
143 ,CUSTOMER_SITE_ID_1 IN NUMBER
144 ,TRANSACTION_ID IN NUMBER) RETURN NUMBER;
145 FUNCTION CF_SH_CVD_CLOSING_BALANCEFORMU(CS_CR_SH_CVD IN NUMBER
146 ,CS_DR_SH_CVD IN NUMBER) RETURN NUMBER;
147 FUNCTION CF_SH_EXC_CLOSING_BALANCEFORMU(CS_CR_SH_EXCISE IN NUMBER
148 ,CS_DR_SH_EXCISE IN NUMBER) RETURN NUMBER;
149 FUNCTION CP_ADDITIONAL_ROUNDING_P RETURN NUMBER;
150 FUNCTION CP_ADDITIONALCVD_ROUNDING_P RETURN NUMBER;
151 FUNCTION CP_OTHER_ROUNDING_P RETURN NUMBER;
152 FUNCTION CP_ROUNDED_EXCISE_CESS_P RETURN NUMBER;
153 FUNCTION CP_ROUNDED_SH_EXCISE_CESS_P RETURN NUMBER;
154 FUNCTION CP_ROUNDED_CVD_CESS_P RETURN NUMBER;
155 FUNCTION CP_ROUNDED_SH_CVD_CESS_P RETURN NUMBER;
156 FUNCTION CP_RND_DR_BASIC_ED_P RETURN NUMBER;
157 FUNCTION CP_RND_DR_ADDL_ED_P RETURN NUMBER;
158 FUNCTION CP_RND_DR_ADDL_CVD_P RETURN NUMBER;
159 FUNCTION CP_RND_DR_OTHER_ED_P RETURN NUMBER;
160 FUNCTION CP_RND_DR_EXC_EDU_CESS_P RETURN NUMBER;
161 FUNCTION CP_RND_DR_SH_CVD_EDU_CESS_P RETURN NUMBER;
162 FUNCTION CP_RND_DR_CVD_EDU_CESS_P RETURN NUMBER;
163 FUNCTION CP_RND_DR_SH_EXC_EDU_CESS_P RETURN NUMBER;
164 FUNCTION CP_1_P RETURN NUMBER;
165 FUNCTION C_NAME_P RETURN VARCHAR2;
166 FUNCTION C_DESCRIPTION_P RETURN VARCHAR2;
167 FUNCTION C_ADDRESS_LINE_1_P RETURN VARCHAR2;
168 FUNCTION C_ADDRESS_LINE_2_P RETURN VARCHAR2;
169 FUNCTION C_ADDRESS_LINE_3_P RETURN VARCHAR2;
170 FUNCTION C_EC_CODE_P RETURN VARCHAR2;
171 FUNCTION C_EXCISECOMM_P RETURN VARCHAR2;
172 FUNCTION C_EXCISEDIVISION_P RETURN VARCHAR2;
173 FUNCTION C_EXCISECIRCLE_P RETURN VARCHAR2;
174 FUNCTION C_EXCISERANGE_P RETURN VARCHAR2;
175 FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
176 V_LAST_PAGE VARCHAR2(1) := 'F';
177 END JA_JAIN23P2_XMLP_PKG;
178