PACKAGE: APPS.CE_CEPURGE_XMLP_PKG

Source

1 PACKAGE CE_CEPURGE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CEPURGES.pls 120.1 2008/01/07 21:21:46 abraghun noship $ */
3   P_BANK_ACCOUNT VARCHAR2(40);
4 
5   P_STATEMENT_DATE_FROM DATE;
6 
7   P_OPTION VARCHAR2(32767);
8 
9   P_OBJECTS VARCHAR2(32767);
10 
11   P_CONC_REQUEST_ID NUMBER := 0;
12 
13   P_DEBUG_MODE VARCHAR2(1);
14 
15   P_SQL_TRACE VARCHAR2(1);
16 
17   P_ACTION VARCHAR2(32767);
18 
19   P_BANK_BRANCH NUMBER;
20 
21   P_STATEMENT_DATE_TO DATE;
22 
23   P_STATEMENT_DATE_TO1 DATE;
24 
25   P_STATEMENT_DATE_FROM_1 varchar2(10);
26 
27    P_STATEMENT_DATE_TO_1 varchar2(10);
28 
29   P_STATEMENT_TYPE VARCHAR2(32767);
30 
31   P_HDR_INT_STATUS VARCHAR2(32767);
32 
33   P_LEGAL_ENTITY_ID NUMBER;
34 
35   P_ORG_ID NUMBER;
36 
37   C_ARCHIVE_INF_HEADERS NUMBER;
38 
39   C_ARCHIVE_INF_LINES NUMBER;
40 
41   C_ARCHIVE_STAT_HEADERS NUMBER;
42 
43   C_ARCHIVE_STAT_LINES NUMBER;
44 
45   C_ARCHIVE_STAT_REC NUMBER;
46 
47   C_ARCHIVE_STAT_ERRORS NUMBER;
48 
49   C_PURGE_INF_HEADERS NUMBER;
50 
51   C_PURGE_INF_LINES NUMBER;
52 
53   C_PURGE_STAT_HEADERS NUMBER;
54 
55   C_PURGE_STAT_LINES NUMBER;
56 
57   C_PURGE_STAT_REC NUMBER;
58 
59   C_PURGE_STAT_ERRORS NUMBER;
60 
61   C_BANK_NAME VARCHAR2(60);
62 
63   C_BANK_BRANCH_NAME VARCHAR2(60);
64 
65   C_BANK_ACCOUNT_NAME VARCHAR2(80);
66 
67   C_BANK_ACCOUNT_NUM VARCHAR2(40);
68 
69   C_CURRENCY_CODE VARCHAR2(15);
70 
71   C_SET_OF_BOOK VARCHAR2(80);
72 
73   C_ALL_TRANSLATION VARCHAR2(80);
74 
75   C_ARCHIVE_INF_HEADERS2 NUMBER;
76 
77   C_ARCHIVE_INF_LINES2 NUMBER;
78 
79   C_ARCHIVE_STAT_HEADERS2 NUMBER;
80 
81   C_ARCHIVE_STAT_LINES2 NUMBER;
82 
83   C_PURGE_INF_HEADERS2 NUMBER;
84 
85   C_PURGE_INF_LINES2 NUMBER;
86 
87   C_PURGE_STAT_HEADERS2 NUMBER;
88 
89   C_PURGE_STAT_LINES2 NUMBER;
90 
91   FUNCTION BEFOREREPORT RETURN BOOLEAN;
92 
93   FUNCTION AFTERREPORT RETURN BOOLEAN;
94 
95   FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN VARCHAR2;
96 
97   FUNCTION C_ARCHIVE_INF_HEADERS_P RETURN NUMBER;
98 
99   FUNCTION C_ARCHIVE_INF_LINES_P RETURN NUMBER;
100 
101   FUNCTION C_ARCHIVE_STAT_HEADERS_P RETURN NUMBER;
102 
103   FUNCTION C_ARCHIVE_STAT_LINES_P RETURN NUMBER;
104 
105   FUNCTION C_ARCHIVE_STAT_REC_P RETURN NUMBER;
106 
107   FUNCTION C_ARCHIVE_STAT_ERRORS_P RETURN NUMBER;
108 
109   FUNCTION C_PURGE_INF_HEADERS_P RETURN NUMBER;
110 
111   FUNCTION C_PURGE_INF_LINES_P RETURN NUMBER;
112 
113   FUNCTION C_PURGE_STAT_HEADERS_P RETURN NUMBER;
114 
115   FUNCTION C_PURGE_STAT_LINES_P RETURN NUMBER;
116 
117   FUNCTION C_PURGE_STAT_REC_P RETURN NUMBER;
118 
119   FUNCTION C_PURGE_STAT_ERRORS_P RETURN NUMBER;
120 
121   FUNCTION C_BANK_NAME_P RETURN VARCHAR2;
122 
123   FUNCTION C_BANK_BRANCH_NAME_P RETURN VARCHAR2;
124 
125   FUNCTION C_BANK_ACCOUNT_NAME_P RETURN VARCHAR2;
126 
127   FUNCTION C_BANK_ACCOUNT_NUM_P RETURN VARCHAR2;
128 
129   FUNCTION C_CURRENCY_CODE_P RETURN VARCHAR2;
130 
131   FUNCTION C_SET_OF_BOOK_P RETURN VARCHAR2;
132 
133   FUNCTION C_ALL_TRANSLATION_P RETURN VARCHAR2;
134 
135   FUNCTION C_ARCHIVE_INF_HEADERS2_P RETURN NUMBER;
136 
137   FUNCTION C_ARCHIVE_INF_LINES2_P RETURN NUMBER;
138 
139   FUNCTION C_ARCHIVE_STAT_HEADERS2_P RETURN NUMBER;
140 
141   FUNCTION C_ARCHIVE_STAT_LINES2_P RETURN NUMBER;
142 
143   FUNCTION C_PURGE_INF_HEADERS2_P RETURN NUMBER;
144 
145   FUNCTION C_PURGE_INF_LINES2_P RETURN NUMBER;
146 
147   FUNCTION C_PURGE_STAT_HEADERS2_P RETURN NUMBER;
148 
149   FUNCTION C_PURGE_STAT_LINES2_P RETURN NUMBER;
150 
151   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
152                     ,NAME IN VARCHAR2);
153 
154   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
155                      ,VALUE IN VARCHAR2
156                      ,TRANSLATE IN number);
157 
158   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
159 
160   PROCEDURE CLEAR;
161 
162   FUNCTION GET_STRING(APPIN IN VARCHAR2
163                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
164 
165   FUNCTION GET_NUMBER(APPIN IN VARCHAR2
166                      ,NAMEIN IN VARCHAR2) RETURN NUMBER;
167 
168   FUNCTION GET RETURN VARCHAR2;
169 
170   FUNCTION GET_ENCODED RETURN VARCHAR2;
171 
172   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
173                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
174                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
175 
176   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
177 
178   PROCEDURE RAISE_ERROR;
179 
180   PROCEDURE DEBUG(LINE IN VARCHAR2);
181 
182   PROCEDURE ENABLE_DEBUG;
183 
184   PROCEDURE DISABLE_DEBUG;
185 
186   FUNCTION GET_WINDOW_SESSION_TITLE(P_ORG_ID IN NUMBER := NULL
187                                    ,P_LEGAL_ENTITY_ID IN NUMBER := NULL) RETURN VARCHAR2;
188 
189   FUNCTION GET_EFFECTIVE_DATE(P_BANK_ACCOUNT_ID IN NUMBER
190                              ,P_TRX_CODE IN VARCHAR2
191                              ,P_RECEIPT_DATE IN DATE) RETURN DATE;
192 
193   PROCEDURE INIT_SECURITY;
194 
195 END CE_CEPURGE_XMLP_PKG;
196