[Home] [Help]
PACKAGE: APPS.JG_JGZZRCAK_XMLP_PKG
Source
1 PACKAGE JG_JGZZRCAK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JGZZRCAKS.pls 120.0 2008/01/08 07:56:28 vjaganat noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_SOB_ID NUMBER;
6
7 P_RA_FROM NUMBER;
8
9 P_RA_TO NUMBER;
10
11 P_CUSTOMER_FROM VARCHAR2(50);
12
13 P_CUSTOMER_TO VARCHAR2(50);
14
15 P_REPRINT VARCHAR2(1);
16
17 P_RECEIPT_FROM DATE;
18
19 P_RECEIPT_TO DATE;
20
21 P_DEBUG_SWITCH VARCHAR2(1);
22
23 P_SIGNER VARCHAR2(60);
24
25 P_DOC_SEQ_ASSIGN_ID NUMBER;
26
27 P_ORG_ID NUMBER;
28
29 CP_FUNC_CURRENCY VARCHAR2(25);
30
31 CP_PRECISION NUMBER;
32
33 CP_STRUCT_NUM NUMBER;
34
35 CP_SOB_NAME VARCHAR2(100);
36
37 CP_WHERE_RECEIPT_DATES VARCHAR2(240) := '1=1';
38
39 CP_SUB_UNIT_PLURAL VARCHAR2(25) := 'Centavos';
40
41 CP_SUB_UNIT_SINGULAR VARCHAR2(25) := 'Centavo';
42
43 CP_UNIT_PLURAL VARCHAR2(80) := 'Escudos';
44
45 CP_UNIT_SINGULAR VARCHAR2(80) := 'Escudo';
46
47 CP_UNIT_RATIO NUMBER := 100;
48
49 CP_SYSDATE VARCHAR2(20);
50
51 CP_COUNTRY_CODE VARCHAR2(20);
52
53 CP_DATE_FROM VARCHAR2(11);
54
55 CP_DATE_TO VARCHAR2(11);
56
57 CP_CATEGORY VARCHAR2(80);
58
59 CP_DOC_SEQ_ID NUMBER;
60
61 CP_DOC_VALUE NUMBER;
62
63 CP_LETTER_DATE DATE;
64
65 CP_HR_ADDRESS1 VARCHAR2(100);
66
67 CP_HR_ADDRESS2 VARCHAR2(100);
68
69 CP_HR_ADDRESS3 VARCHAR2(100);
70
71 CP_HR_CITY VARCHAR2(50);
72
73 CP_HR_FAX VARCHAR2(30);
74
75 CP_HR_LOCATION VARCHAR2(50);
76
77 CP_HR_TAX_ID VARCHAR2(30);
78
79 CP_HR_TELEPHONE VARCHAR2(30);
80
81 CP_HR_TELEPHONE3 VARCHAR2(30);
82
83 CP_HR_TERRITORY VARCHAR2(50);
84
85 FUNCTION BEFOREREPORT RETURN BOOLEAN;
86
87 FUNCTION AFTERREPORT RETURN BOOLEAN;
88
89 FUNCTION CF_WORD_AMOUNTFORMULA(C_CURR_TOTAL_CURRENCY IN VARCHAR2
90 ,CS_CURR_TOTAL IN NUMBER) RETURN VARCHAR2;
91
92 PROCEDURE CUSTOMER_RECEIPTS(FROM_CUST IN VARCHAR2
93 ,TO_CUST IN VARCHAR2);
94
95 PROCEDURE AR_DOC_SEQUENCE_AUDIT_P;
96
97 FUNCTION CF_COUNTFORMULA(CS_INV_APPLIED_AMT IN NUMBER) RETURN NUMBER;
98
99 FUNCTION CONVERT_NUMBER2(SEGMENT IN NUMBER) RETURN VARCHAR2;
100
101 FUNCTION CONVERT_NUMBER(IN_NUMERAL IN INTEGER := 0) RETURN VARCHAR2;
102
103 FUNCTION GET_WORD_VALUE(P_AMOUNT IN NUMBER
104 ,P_UNIT_SINGULAR IN VARCHAR2
105 ,P_UNIT_PLURAL IN VARCHAR2
106 ,P_SUB_UNIT_SINGULAR IN VARCHAR2
107 ,P_SUB_UNIT_PLURAL IN VARCHAR2
108 ,P_UNIT_RATIO IN NUMBER) RETURN VARCHAR2;
109
110 FUNCTION PRECISION(CUR_CODE IN VARCHAR2) RETURN NUMBER;
111
112 FUNCTION CP_FUNC_CURRENCY_P RETURN VARCHAR2;
113
114 FUNCTION CP_PRECISION_P RETURN NUMBER;
115
116 FUNCTION CP_STRUCT_NUM_P RETURN NUMBER;
117
118 FUNCTION CP_SOB_NAME_P RETURN VARCHAR2;
119
120 FUNCTION CP_WHERE_RECEIPT_DATES_P RETURN VARCHAR2;
121
122 FUNCTION CP_SUB_UNIT_PLURAL_P RETURN VARCHAR2;
123
124 FUNCTION CP_SUB_UNIT_SINGULAR_P RETURN VARCHAR2;
125
126 FUNCTION CP_UNIT_PLURAL_P RETURN VARCHAR2;
127
128 FUNCTION CP_UNIT_SINGULAR_P RETURN VARCHAR2;
129
130 FUNCTION CP_UNIT_RATIO_P RETURN NUMBER;
131
132 FUNCTION CP_SYSDATE_P RETURN VARCHAR2;
133
134 FUNCTION CP_COUNTRY_CODE_P RETURN VARCHAR2;
135
136 FUNCTION CP_DATE_FROM_P RETURN VARCHAR2;
137
138 FUNCTION CP_DATE_TO_P RETURN VARCHAR2;
139
140 FUNCTION CP_CATEGORY_P RETURN VARCHAR2;
141
142 FUNCTION CP_DOC_SEQ_ID_P RETURN NUMBER;
143
144 FUNCTION CP_DOC_VALUE_P RETURN NUMBER;
145
146 FUNCTION CP_LETTER_DATE_P RETURN DATE;
147
148 FUNCTION CP_HR_ADDRESS1_P RETURN VARCHAR2;
149
150 FUNCTION CP_HR_ADDRESS2_P RETURN VARCHAR2;
151
152 FUNCTION CP_HR_ADDRESS3_P RETURN VARCHAR2;
153
154 FUNCTION CP_HR_CITY_P RETURN VARCHAR2;
155
156 FUNCTION CP_HR_FAX_P RETURN VARCHAR2;
157
158 FUNCTION CP_HR_LOCATION_P RETURN VARCHAR2;
159
160 FUNCTION CP_HR_TAX_ID_P RETURN VARCHAR2;
161
162 FUNCTION CP_HR_TELEPHONE_P RETURN VARCHAR2;
163
164 FUNCTION CP_HR_TELEPHONE3_P RETURN VARCHAR2;
165
166 FUNCTION CP_HR_TERRITORY_P RETURN VARCHAR2;
167
168 PROCEDURE JG_GET_SET_OF_BOOKS_INFO(SOBID IN NUMBER
169 ,COAID OUT NOCOPY NUMBER
170 ,SOBNAME OUT NOCOPY VARCHAR2
171 ,FUNC_CURR OUT NOCOPY VARCHAR2
172 ,ERRBUF OUT NOCOPY VARCHAR2);
173
174 PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
175 ,TYPE_ID IN NUMBER
176 ,NAME OUT NOCOPY VARCHAR2
177 ,ERRBUF OUT NOCOPY VARCHAR2);
178
179 PROCEDURE JG_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
180 ,CODE IN VARCHAR2
181 ,TYPE IN VARCHAR2
182 ,VALUE OUT NOCOPY VARCHAR2
183 ,ERRBUF OUT NOCOPY VARCHAR2);
184
185 PROCEDURE JG_GET_FIRST_PERIOD(APP_ID IN NUMBER
186 ,TSET_OF_BOOKS_ID IN NUMBER
187 ,TPERIOD_NAME IN VARCHAR2
188 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
189 ,ERRBUF OUT NOCOPY VARCHAR2);
190
191 PROCEDURE JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID IN NUMBER
192 ,TSET_OF_BOOKS_ID IN NUMBER
193 ,TPERIOD_NAME IN VARCHAR2
194 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
195 ,ERRBUF OUT NOCOPY VARCHAR2);
196
197 FUNCTION JG_FORMAT_CURR_AMT(IN_PRECISION IN NUMBER
198 ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2;
199
200 FUNCTION GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
201 ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2;
202
203 FUNCTION SAFE_GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
204 ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2;
205
206 PROCEDURE GET_INFO(CURRENCY_CODE IN VARCHAR2
207 ,PRECISION OUT NOCOPY NUMBER
208 ,EXT_PRECISION OUT NOCOPY NUMBER
209 ,MIN_ACCT_UNIT OUT NOCOPY NUMBER);
210
211 PROCEDURE BUILD_FORMAT_MASK(FORMAT_MASK OUT NOCOPY VARCHAR2
212 ,FIELD_LENGTH IN NUMBER
213 ,PRECISION IN NUMBER
214 ,MIN_ACCT_UNIT IN NUMBER
215 ,DISP_GRP_SEP IN BOOLEAN
216 ,NEG_FORMAT IN VARCHAR2
217 ,POS_FORMAT IN VARCHAR2);
218
219 PROCEDURE SAFE_BUILD_FORMAT_MASK(FORMAT_MASK OUT NOCOPY VARCHAR2
220 ,FIELD_LENGTH IN NUMBER
221 ,PRECISION IN NUMBER
222 ,MIN_ACCT_UNIT IN NUMBER
223 ,DISP_GRP_SEP IN BOOLEAN
224 ,NEG_FORMAT IN VARCHAR2
225 ,POS_FORMAT IN VARCHAR2);
226
227 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
228 ,NAME IN VARCHAR2);
229
230 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
231 ,VALUE IN VARCHAR2
232 ,TRANSLATE IN BOOLEAN);
233
234 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
235
236 PROCEDURE CLEAR;
237
238 FUNCTION GET_STRING(APPIN IN VARCHAR2
239 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
240
241 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
242 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
243
244 FUNCTION GET RETURN VARCHAR2;
245
246 FUNCTION GET_ENCODED RETURN VARCHAR2;
247
248 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
249 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
250 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
251
252 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
253
254 PROCEDURE RAISE_ERROR;
255
256 FUNCTION GET_NEXT_SEQUENCE(APPID IN NUMBER
257 ,CAT_CODE IN VARCHAR2
258 ,SOBID IN NUMBER
259 ,MET_CODE IN VARCHAR2
260 ,TRX_DATE IN DATE
261 ,DBSEQNM IN OUT NOCOPY VARCHAR2
262 ,DBSEQID IN OUT NOCOPY INTEGER) RETURN NUMBER;
263
264 PROCEDURE GET_SEQ_NAME(APPID IN NUMBER
265 ,CAT_CODE IN VARCHAR2
266 ,SOBID IN NUMBER
267 ,MET_CODE IN VARCHAR2
268 ,TRX_DATE IN DATE
269 ,DBSEQNM OUT NOCOPY VARCHAR2
270 ,DBSEQID OUT NOCOPY INTEGER
271 ,SEQASSID OUT NOCOPY INTEGER);
272
273 FUNCTION GET_NEXT_AUTO_SEQ(DBSEQNM IN VARCHAR2) RETURN NUMBER;
274
275 FUNCTION GET_NEXT_AUTO_SEQUENCE(APPID IN NUMBER
276 ,CAT_CODE IN VARCHAR2
277 ,SOBID IN NUMBER
278 ,MET_CODE IN VARCHAR2
279 ,TRX_DATE IN VARCHAR2) RETURN NUMBER;
280
281 FUNCTION GET_NEXT_AUTO_SEQUENCE(APPID IN NUMBER
282 ,CAT_CODE IN VARCHAR2
283 ,SOBID IN NUMBER
284 ,MET_CODE IN VARCHAR2
285 ,TRX_DATE IN DATE) RETURN NUMBER;
286
287 PROCEDURE CREATE_GAPLESS_SEQUENCES;
288
289 /*FUNCTION CREATE_GAPLESS_SEQUENCE(SEQID IN NUMBER
290 ,SEQASSID IN NUMBER) RETURN NUMBER;*/
291
292 FUNCTION GET_NEXT_USER_SEQUENCE(FDS_USER_ID IN NUMBER
293 ,SEQASSID IN NUMBER
294 ,SEQID IN NUMBER) RETURN NUMBER;
295
296 END JG_JGZZRCAK_XMLP_PKG;
297
298