PACKAGE: APPS.CE_CEXAVBCH_XMLP_PKG

Source

1 PACKAGE CE_CEXAVBCH_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CEXAVBCHS.pls 120.0 2007/12/28 07:53:02 abraghun noship $ */
3   P_BANK_ACCOUNT NUMBER;
4 
5   P_TYPE VARCHAR2(40);
6 
7   P_DEBUG_MODE VARCHAR2(1);
8 
9   P_SQL_TRACE VARCHAR2(1);
10 
11   P_CONC_REQUEST_ID NUMBER := 0;
12 
13   P_ORDER_BY VARCHAR2(32767);
14 
15   P_SHOW_VOID_PAYMENT_FLAG VARCHAR2(1);
16 
17   P_SOURCE_VIEW VARCHAR2(50);
18 
19   P_QUERY_RECEIPTS VARCHAR2(32767) := 'N';
20 
21   P_QUERY_PAYMENTS VARCHAR2(32767) := 'N';
22 
23   P_ORG_ID VARCHAR2(40);
24 
25   C_BATCH_AMOUNT NUMBER;
26 
27   C_BATCH_BANK_ACCOUNT_AMOUNT NUMBER;
28 
29   C_THE_END VARCHAR2(1) := 'N';
30 
31   C_BANK_ACCOUNT_NAME VARCHAR2(80);
32 
33   C_BANK_ACCOUNT_NUM VARCHAR2(38);
34 
35   C_BANK_NAME VARCHAR2(60);
36 
37   C_BANK_BRANCH_NAME VARCHAR2(60);
38 
39   C_BANK_CURRENCY_CODE VARCHAR2(15);
40 
41   C_TRANSACTION_TYPE VARCHAR2(80);
42 
43   C_RECEIPT_TRANSLATION VARCHAR2(80);
44 
45   C_AMOUNT_WIDTH NUMBER;
46 
47   C_COMPANY_NAME_HEADER VARCHAR2(80);
48 
49   C_BANK_ACCOUNT_TYPE VARCHAR2(25);
50 
51   C_PRECISION NUMBER;
52 
53   C_BATCH_PAY_SQL_LEX VARCHAR2(3000);
54 
55   C_BATCH_REC_SQL_LEX VARCHAR2(3000);
56 
57   FUNCTION BEFOREREPORT RETURN BOOLEAN;
58 
59   FUNCTION AFTERREPORT RETURN BOOLEAN;
60 
61   FUNCTION G_TRANSACTION_TYPEGROUPFILTER(TYPE IN VARCHAR2) RETURN BOOLEAN;
62 
63   FUNCTION C_AMOUNTFORMULA(TYPE IN VARCHAR2
64                           ,BATCH_ID_1 IN NUMBER) RETURN NUMBER;
65 
66   FUNCTION C_BANK_ACCOUNT_AMOUNTFORMULA(TYPE IN VARCHAR2
67                                        ,BATCH_ID_1 IN NUMBER) RETURN NUMBER;
68 
69   FUNCTION C_ACCOUNT_AMOUNTFORMULA(TYPE IN VARCHAR2
70                                   ,BATCH_ID_1 IN NUMBER) RETURN NUMBER;
71 
72   FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN VARCHAR2;
73 
74   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
75 
76   FUNCTION P_SHOW_VOID_PAYMENT_FLAGVALIDT RETURN BOOLEAN;
77 
78   FUNCTION P_ORDER_BYVALIDTRIGGER RETURN BOOLEAN;
79 
80   FUNCTION C_BATCH_AMOUNT_P RETURN NUMBER;
81 
82   FUNCTION C_BATCH_BANK_ACCOUNT_AMOUNT_P RETURN NUMBER;
83 
84   FUNCTION C_THE_END_P RETURN VARCHAR2;
85 
86   FUNCTION C_BANK_ACCOUNT_NAME_P RETURN VARCHAR2;
87 
88   FUNCTION C_BANK_ACCOUNT_NUM_P RETURN VARCHAR2;
89 
90   FUNCTION C_BANK_NAME_P RETURN VARCHAR2;
91 
92   FUNCTION C_BANK_BRANCH_NAME_P RETURN VARCHAR2;
93 
94   FUNCTION C_BANK_CURRENCY_CODE_P RETURN VARCHAR2;
95 
96   FUNCTION C_TRANSACTION_TYPE_P RETURN VARCHAR2;
97 
98   FUNCTION C_RECEIPT_TRANSLATION_P RETURN VARCHAR2;
99 
100   FUNCTION C_AMOUNT_WIDTH_P RETURN NUMBER;
101 
102   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
103 
104   FUNCTION C_BANK_ACCOUNT_TYPE_P RETURN VARCHAR2;
105 
106   FUNCTION C_PRECISION_P RETURN NUMBER;
107 
108   FUNCTION C_BATCH_PAY_SQL_LEX_P RETURN VARCHAR2;
109 
110   FUNCTION C_BATCH_REC_SQL_LEX_P RETURN VARCHAR2;
111 
112   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
113                     ,NAME IN VARCHAR2);
114 		    PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
115 
116 
117   /*PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
118                      ,VALUE IN VARCHAR2
119                      ,TRANSLATE IN BOOLEAN);
120 
121   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
122 
123   PROCEDURE CLEAR;
124 
125   FUNCTION GET_STRING(APPIN IN VARCHAR2
126                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;*/
127 
128   FUNCTION GET RETURN VARCHAR2;
129 
130   /*FUNCTION GET_ENCODED RETURN VARCHAR2;
131 
132   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
133                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
134                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
135 
136   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
137 
138   PROCEDURE RAISE_ERROR;
139 
140   PROCEDURE SET_101;
141 
142   PROCEDURE SET_200;
143 
144   PROCEDURE SET_222;
145 
146   PROCEDURE SET_260;
147 
148   PROCEDURE SET_801;
149 
150   PROCEDURE SET_999;
151 
152   PROCEDURE SET_ALL;
153 
154   PROCEDURE UNSET_101;
155 
156   PROCEDURE UNSET_200;
157 
158   PROCEDURE UNSET_222;
159 
160   PROCEDURE UNSET_260;
161 
162   PROCEDURE UNSET_801;
163 
164   PROCEDURE UNSET_999;
165 
166   PROCEDURE UNSET_ALL;
167 
168   FUNCTION GET_101 RETURN NUMBER;
169 
170   FUNCTION GET_200 RETURN NUMBER;
171 
172   FUNCTION GET_222 RETURN NUMBER;
173 
174   FUNCTION GET_260 RETURN NUMBER;
175 
176   FUNCTION GET_801 RETURN NUMBER;
177 
178   FUNCTION GET_999 RETURN NUMBER;*/
179 
180 /*  PROCEDURE SET_INVERSE_RATE(INVERSE_RATE IN VARCHAR2);*/
181 
182   /*FUNCTION GET_INVERSE_RATE RETURN VARCHAR2;*/
183 
184  /* FUNCTION GET_VAT_TAX_ID RETURN NUMBER;*/
185 
186   /*FUNCTION CONVERT_AMOUNT_TOLERANCE(AMOUNT_TO_CONVERT IN NUMBER) RETURN NUMBER;*/
187 
188  /* FUNCTION VALIDATE_PAYMENT_METHOD RETURN BOOLEAN;*/
189 
190  /* FUNCTION TRX_VALIDATION(NO_OF_CURRENCIES IN NUMBER) RETURN BOOLEAN;*/
191 
192 /*  PROCEDURE CALC_ACTUAL_TOLERANCE;*/
193 
194   /*PROCEDURE MATCH_PROCESS;*/
195 
196 /*  PROCEDURE LOCK_TRANSACTION(X_RECONCILE_FLAG IN VARCHAR2
197                             ,X_CALL_MODE IN VARCHAR2
198                             ,X_TRX_TYPE IN VARCHAR2
199                             ,X_CLEARING_TRX_TYPE IN VARCHAR2
200                             ,X_TRX_ROWID IN VARCHAR2
201                             ,X_BATCH_BA_AMOUNT IN NUMBER);*?
202 
203   /*PROCEDURE DEBUG(LINE IN VARCHAR2);*/
204 
205  /* PROCEDURE ENABLE_DEBUG;*/
206 
207  /* PROCEDURE DISABLE_DEBUG;*/
208 
209 /*  FUNCTION GET_WINDOW_SESSION_TITLE RETURN VARCHAR2;*/
210 
211  /* FUNCTION GET_EFFECTIVE_DATE(P_BANK_ACCOUNT_ID IN NUMBER
212                              ,P_TRX_CODE IN VARCHAR2
213                              ,P_RECEIPT_DATE IN DATE) RETURN DATE;*/
214 
215   PROCEDURE INIT_SECURITY;
216 
217 END CE_CEXAVBCH_XMLP_PKG;
218