PACKAGE: APPS.CE_CEXAVTRX_XMLP_PKG

Source

1 PACKAGE CE_CEXAVTRX_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CEXAVTRXS.pls 120.0 2007/12/28 07:53:39 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_ORG_ID NUMBER;
20 
21   P_LEGAL_ENTITY_ID NUMBER;
22 
23   P_BG_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(BANK_ACCOUNT_NUM IN VARCHAR2) RETURN BOOLEAN;
62 
63   FUNCTION C_AMOUNTFORMULA(AMOUNT IN NUMBER) RETURN NUMBER;
64 
65   FUNCTION C_BANK_ACCOUNT_AMOUNTFORMULA(TYPE IN VARCHAR2
66                                        ,ACCOUNT_AMOUNT IN NUMBER
67                                        ,BANK_ACCOUNT_AMOUNT IN NUMBER) RETURN NUMBER;
68 
69   FUNCTION C_ACCOUNT_AMOUNTFORMULA(ACCOUNT_AMOUNT IN NUMBER) RETURN NUMBER;
70 
71   FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN VARCHAR2;
72 
73   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
74 
75   FUNCTION P_SHOW_VOID_PAYMENT_FLAGVALIDT RETURN BOOLEAN;
76 
77   FUNCTION P_ORDER_BYVALIDTRIGGER RETURN BOOLEAN;
78 
79   FUNCTION C_BATCH_AMOUNT_P RETURN NUMBER;
80 
81   FUNCTION C_BATCH_BANK_ACCOUNT_AMOUNT_P RETURN NUMBER;
82 
83   FUNCTION C_THE_END_P RETURN VARCHAR2;
84 
85   FUNCTION C_BANK_ACCOUNT_NAME_P RETURN VARCHAR2;
86 
87   FUNCTION C_BANK_ACCOUNT_NUM_P RETURN VARCHAR2;
88 
89   FUNCTION C_BANK_NAME_P RETURN VARCHAR2;
90 
91   FUNCTION C_BANK_BRANCH_NAME_P RETURN VARCHAR2;
92 
93   FUNCTION C_BANK_CURRENCY_CODE_P RETURN VARCHAR2;
94 
95   FUNCTION C_TRANSACTION_TYPE_P RETURN VARCHAR2;
96 
97   FUNCTION C_RECEIPT_TRANSLATION_P RETURN VARCHAR2;
98 
99   FUNCTION C_AMOUNT_WIDTH_P RETURN NUMBER;
100 
101   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
102 
103   FUNCTION C_BANK_ACCOUNT_TYPE_P RETURN VARCHAR2;
104 
105   FUNCTION C_PRECISION_P RETURN NUMBER;
106 
107   FUNCTION C_BATCH_PAY_SQL_LEX_P RETURN VARCHAR2;
108 
109   FUNCTION C_BATCH_REC_SQL_LEX_P RETURN VARCHAR2;
110 
111   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
112                     ,NAME IN VARCHAR2);
113 
114   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
115                      ,VALUE IN VARCHAR2
116                      ,TRANSLATE IN NUMBER);
117 
118   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
119 
120   PROCEDURE CLEAR;
121 
122   FUNCTION GET_STRING(APPIN IN VARCHAR2
123                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
124 
125   FUNCTION GET RETURN VARCHAR2;
126 
127   FUNCTION GET_ENCODED RETURN VARCHAR2;
128 
129   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
130                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
131                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
132 
133   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
134 
135   PROCEDURE RAISE_ERROR;
136 
137   PROCEDURE SET_101;
138 
139   PROCEDURE SET_200;
140 
141   PROCEDURE SET_222;
142 
143   PROCEDURE SET_260;
144 
145   PROCEDURE SET_801;
146 
147   PROCEDURE SET_999;
148 
149   PROCEDURE SET_ALL;
150 
151   PROCEDURE UNSET_101;
152 
153   PROCEDURE UNSET_200;
154 
155   PROCEDURE UNSET_222;
156 
157   PROCEDURE UNSET_260;
158 
159   PROCEDURE UNSET_801;
160 
161   PROCEDURE UNSET_999;
162 
163   PROCEDURE UNSET_ALL;
164 
165   FUNCTION GET_101 RETURN NUMBER;
166 
167   FUNCTION GET_200 RETURN NUMBER;
168 
169   FUNCTION GET_222 RETURN NUMBER;
170 
171   FUNCTION GET_260 RETURN NUMBER;
172 
173   FUNCTION GET_801 RETURN NUMBER;
174 
175   FUNCTION GET_999 RETURN NUMBER;
176 
177   PROCEDURE SET_INVERSE_RATE(INVERSE_RATE IN VARCHAR2);
178 
179   FUNCTION GET_INVERSE_RATE RETURN VARCHAR2;
180 
181   FUNCTION GET_VAT_TAX_ID RETURN NUMBER;
182 
183   FUNCTION CONVERT_AMOUNT_TOLERANCE(AMOUNT_TO_CONVERT IN NUMBER) RETURN NUMBER;
184 
185   FUNCTION VALIDATE_PAYMENT_METHOD RETURN BOOLEAN;
186 
187   FUNCTION TRX_VALIDATION(NO_OF_CURRENCIES IN NUMBER) RETURN BOOLEAN;
188 
189   PROCEDURE CALC_ACTUAL_TOLERANCE;
190 
191   PROCEDURE MATCH_PROCESS;
192 
193   PROCEDURE LOCK_TRANSACTION(X_RECONCILE_FLAG IN VARCHAR2
194                             ,X_CALL_MODE IN VARCHAR2
195                             ,X_TRX_TYPE IN VARCHAR2
196                             ,X_CLEARING_TRX_TYPE IN VARCHAR2
197                             ,X_TRX_ROWID IN VARCHAR2
198                             ,X_BATCH_BA_AMOUNT IN NUMBER);
199 
200   PROCEDURE DEBUG(LINE IN VARCHAR2);
201 
202   PROCEDURE ENABLE_DEBUG;
203 
204   PROCEDURE DISABLE_DEBUG;
205 
206   FUNCTION GET_WINDOW_SESSION_TITLE(P_ORG_ID IN NUMBER := NULL
207                                    ,P_LEGAL_ENTITY_ID IN NUMBER := NULL) RETURN VARCHAR2;
208 
209   FUNCTION GET_EFFECTIVE_DATE(P_BANK_ACCOUNT_ID IN NUMBER
210                              ,P_TRX_CODE IN VARCHAR2
211                              ,P_RECEIPT_DATE IN DATE) RETURN DATE;
212 
213   PROCEDURE INIT_SECURITY;
214 
215 END CE_CEXAVTRX_XMLP_PKG;
216