PACKAGE: APPS.CE_CEXCLEAR_XMLP_PKG

Source

1 PACKAGE CE_CEXCLEAR_XMLP_PKG AS
2 /* $Header: CEXCLEARS.pls 120.0 2007/12/28 07:54:09 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_BATCH_OR_TRX VARCHAR2(1);
12 
13   P_CONC_REQUEST_ID NUMBER := 0;
14 
15   P_ORDER_BY VARCHAR2(32767);
16 
17   P_BANK_BRANCH NUMBER;
18 
19   P_DATE_FROM DATE;
20 
21   P_DATE_TO DATE;
22 
23   P_ORG_ID VARCHAR2(40);
24 
25   P_LEGAL_ENTITY_ID VARCHAR2(40);
26 
27   P_BG_ORG_ID VARCHAR2(40);
28 
29   C_BATCH_AMOUNT NUMBER;
30 
31   C_BATCH_BANK_ACCOUNT_AMOUNT NUMBER;
32 
33   C_BATCH_CLEARED_AMOUNT NUMBER;
34 
35   C_THE_END VARCHAR2(1) := 'N';
36 
37   C_BANK_ACCOUNT_NAME VARCHAR2(100);
38 
39   C_BANK_ACCOUNT_NUM VARCHAR2(38);
40 
41   C_BANK_NAME VARCHAR2(60);
42 
43   C_BANK_BRANCH_NAME VARCHAR2(60);
44 
45   C_BANK_CURRENCY_CODE VARCHAR2(15) := 'USD';
46 
47   C_TRANSACTION_TYPE VARCHAR2(80);
48 
49   C_RECEIPT_TRANSLATION VARCHAR2(80);
50 
51   C_AMOUNT_WIDTH NUMBER;
52 
53   C_COMPANY_NAME_HEADER VARCHAR2(80);
54 
55   FUNCTION BEFOREREPORT RETURN BOOLEAN;
56 
57   FUNCTION AFTERREPORT RETURN BOOLEAN;
58 
59   FUNCTION G_TRANSACTION_TYPEGROUPFILTER(BANK_ACCOUNT_NUM IN VARCHAR2) RETURN BOOLEAN;
60 
61   FUNCTION C_AMOUNTFORMULA(AMOUNT IN NUMBER
62                           ,TYPE IN VARCHAR2
63                           ,BATCH_NUMBER IN VARCHAR2
64                           ,BATCH_ID_1 IN NUMBER) RETURN NUMBER;
65 
66   FUNCTION C_BANK_ACCOUNT_AMOUNTFORMULA(ACCOUNT_AMOUNT IN NUMBER) RETURN NUMBER;
67 
68   FUNCTION C_GRAND_CLEARED_AMOUNTFORMULA(TYPE IN VARCHAR2
69                                         ,C_SUM_AMOUNT IN NUMBER
70                                         ,C_SUM_BATCH_AMOUNT 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_ORDER_BYVALIDTRIGGER RETURN BOOLEAN;
77 
78   FUNCTION C_BATCH_AMOUNT_P RETURN NUMBER;
79 
80   FUNCTION C_BATCH_BANK_ACCOUNT_AMOUNT_P RETURN NUMBER;
81 
82   FUNCTION C_BATCH_CLEARED_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   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
105                     ,NAME IN VARCHAR2);
106 
107 /*  PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
108                      ,VALUE IN VARCHAR2
109                      ,TRANSLATE IN BOOLEAN);
110 
111   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
112 
113   PROCEDURE CLEAR;
114 
115   FUNCTION GET_STRING(APPIN IN VARCHAR2
116                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;*/
117 
118   FUNCTION GET RETURN VARCHAR2;
119 
120  /* FUNCTION GET_ENCODED RETURN VARCHAR2;
121 
122   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
123                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
124                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
125 
126   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
127 
128   PROCEDURE RAISE_ERROR;
129 
130   PROCEDURE SET_101;
131 
132   PROCEDURE SET_200;
133 
134   PROCEDURE SET_222;
135 
136   PROCEDURE SET_801;
137 
138   PROCEDURE SET_260;
139 
140   PROCEDURE SET_999;
141 
142   PROCEDURE SET_ALL;
143 
144   PROCEDURE UNSET_101;
145 
146   PROCEDURE UNSET_200;
147 
148   PROCEDURE UNSET_222;
149 
150   PROCEDURE UNSET_260;
151 
152   PROCEDURE UNSET_999;
153 
154   PROCEDURE UNSET_ALL;
155 
156   FUNCTION GET_101 RETURN NUMBER;
157 
158   FUNCTION GET_200 RETURN NUMBER;
159 
160   FUNCTION GET_222 RETURN NUMBER;
161 
162   FUNCTION GET_260 RETURN NUMBER;
163 
164   FUNCTION GET_999 RETURN NUMBER;
165 
166   PROCEDURE SET_INVERSE_RATE(INVERSE_RATE IN VARCHAR2);
167 
168   FUNCTION GET_INVERSE_RATE RETURN VARCHAR2;
169 
170   FUNCTION GET_VAT_TAX_ID RETURN NUMBER;
171 
172   FUNCTION CONVERT_AMOUNT_TOLERANCE(AMOUNT_TO_CONVERT IN NUMBER) RETURN NUMBER;
173 
174   FUNCTION VALIDATE_PAYMENT_METHOD RETURN BOOLEAN;
175 
176   FUNCTION TRX_VALIDATION(NO_OF_CURRENCIES IN NUMBER) RETURN BOOLEAN;
177 
178   PROCEDURE CALC_ACTUAL_TOLERANCE;
179 
180   PROCEDURE MATCH_PROCESS;
181 
182   PROCEDURE LOCK_TRANSACTION(X_RECONCILE_FLAG IN VARCHAR2
183                             ,X_CALL_MODE IN VARCHAR2
184                             ,X_TRX_TYPE IN VARCHAR2
185                             ,X_CLEARING_TRX_TYPE IN VARCHAR2
186                             ,X_TRX_ROWID IN VARCHAR2
187                             ,X_BATCH_BA_AMOUNT IN NUMBER);
188 
189   PROCEDURE DEBUG(LINE IN VARCHAR2);
190 
191   PROCEDURE ENABLE_DEBUG;
192 
193   PROCEDURE DISABLE_DEBUG;
194 
195   FUNCTION GET_WINDOW_SESSION_TITLE RETURN VARCHAR2;
196 
197   FUNCTION GET_EFFECTIVE_DATE(P_BANK_ACCOUNT_ID IN NUMBER
198                              ,P_TRX_CODE IN VARCHAR2
199                              ,P_RECEIPT_DATE IN DATE) RETURN DATE;*/
200 
201   PROCEDURE INIT_SECURITY;
202 
203 END CE_CEXCLEAR_XMLP_PKG;
204