1 PACKAGE IGI_IGIRRTRH_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGIRRTRHS.pls 120.0.12010000.1 2008/07/29 08:59:28 appldev ship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_ORDER_BY VARCHAR2(50);
6 P_ORDER_BY_1 VARCHAR2(50);
7 P_START_GL_DATE DATE;
8
9 P_END_GL_DATE DATE;
10
11 P_END_TRX_DATE DATE;
12
13 P_START_TRX_DATE DATE;
14
15 P_TRX_TYPE_TYPE VARCHAR2(80);
16
17 P_INVOICE_TYPE_LOW VARCHAR2(30);
18
19 P_INVOICE_TYPE_HIGH VARCHAR2(30);
20
21 P_START_CURRENCY_CODE VARCHAR2(15);
22
23 P_END_CURRENCY_CODE VARCHAR2(15);
24
25 P_START_COMPANY_SEGMENT VARCHAR2(100);
26
27 P_END_COMPANY_SEGMENT VARCHAR2(100);
28
29 LP_ORDER_BY VARCHAR2(500);
30
31 P_DUMMY_CURR_CODE_LOW VARCHAR2(30);
32
33 P_DUMMY_CURR_CODE_HIGH VARCHAR2(30);
34
35 LP_INVOICE_TYPE_LOW VARCHAR2(100):='and 1=1';
36
37 LP_INVOICE_TYPE_HIGH VARCHAR2(100):='and 1=1';
38
39 LP_START_TRX_DATE VARCHAR2(100):='and 1=1';
40
41 LP_END_TRX_DATE VARCHAR2(100):='and 1=1';
42
43 LP_TRX_TYPE_TYPE_LOW VARCHAR2(100):='and 1=1';
44
45 LP_TRX_TYPE_TYPE_HIGH VARCHAR2(100):='and 1=1';
46
47 LP_START_GL_DATE VARCHAR2(300):='and 1=1';
48
49 LP_END_GL_DATE VARCHAR2(300):='and 1=1';
50
51 P_COA NUMBER;
52
53 LP_START_COMPANY_SEGMENT VARCHAR2(500):='and 1=1';
54
55 LP_END_COMPANY_SEGMENT VARCHAR2(500):='and 1=1';
56
57 LP_MEANING_INV VARCHAR2(11);
58
59 LP_MEANING_DEP VARCHAR2(32767);
60
61 LP_MEANING_GUAR VARCHAR2(32767);
62
63 LP_MEANING_CM VARCHAR2(11);
64
65 LP_MEANING_DM VARCHAR2(32767);
66
67 LP_MEANING_CB VARCHAR2(32767);
68
69 P_CONS_PROFILE_VALUE VARCHAR2(10) := 'N';
70
71 LP_QUERY_SHOW_BILL VARCHAR2(1000) := 'trx.trx_number';
72
73 LP_TABLE_SHOW_BILL VARCHAR2(1000);
74
75 LP_WHERE_SHOW_BILL VARCHAR2(1000):='and 1=1';
76
77 P_FROM_SC_REF VARCHAR2(50);
78
79 P_TO_SC_REF VARCHAR2(50);
80
81 RP_COMPANY_NAME VARCHAR2(50);
82
83 RP_REPORT_NAME VARCHAR2(80);
84
85 RP_DATA_FOUND VARCHAR2(300);
86
87 RP_YES VARCHAR2(80);
88
89 RP_NO VARCHAR2(80);
90
91 RP_GL_DATE VARCHAR2(50);
92
93 RP_INVOICE_DATE VARCHAR2(50);
94
95 RP_CURR_CODE VARCHAR2(15) := 'USD';
96
97 C_INDUSTRY_CODE VARCHAR2(20);
98
99 C_COMPANY_TITLE VARCHAR2(20);
100
101 RP_SUM_FOR VARCHAR2(240);
102
103 FUNCTION BEFOREREPORT RETURN BOOLEAN;
104
105 FUNCTION AFTERREPORT RETURN BOOLEAN;
106
107 FUNCTION REPORT_NAMEFORMULA(FUNCTIONAL_CURRENCY IN VARCHAR2
108 ,COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
109
110 FUNCTION C_COMPANY_SUMMARY_LABELFORMULA(COMPANY IN VARCHAR2) RETURN VARCHAR2;
111
112 FUNCTION C_POSTABLE_SUMMARY_LABELFORMUL(POSTABLE IN VARCHAR2) RETURN VARCHAR2;
113
114 FUNCTION C_CURRENCY_SUMMARY_LABELFORMUL(CURRENCY_A IN VARCHAR2) RETURN VARCHAR2;
115
116 FUNCTION C_CLASS_SUMMARY_LABELFORMULA(CLASS IN VARCHAR2) RETURN VARCHAR2;
117
118 FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY_A IN VARCHAR2) RETURN NUMBER;
119
120 FUNCTION AFTERPFORM RETURN BOOLEAN;
121
122 FUNCTION D_COMPANYFORMULA(COMPANY IN VARCHAR2) RETURN VARCHAR2;
123
124 FUNCTION AR_LOOKUP(L_TYPE IN VARCHAR2
125 ,L_CODE IN VARCHAR2) RETURN VARCHAR2;
126
127 PROCEDURE GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
128 ,P_LOOKUP_CODE IN VARCHAR2
129 ,P_LOOKUP_MEANING IN OUT NOCOPY VARCHAR2);
130
131 PROCEDURE GET_BOILER_PLATES;
132
133 FUNCTION SET_DISPLAY_FOR_CORE RETURN BOOLEAN;
134
135 FUNCTION SET_DISPLAY_FOR_GOV RETURN BOOLEAN;
136
137 FUNCTION INVOICE_CONSFORMULA(INVOICE_NUMBER IN VARCHAR2
138 ,CONS_BILLING_NUMBER IN VARCHAR2) RETURN VARCHAR2;
139
140 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
141
142 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
143
144 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
145
146 FUNCTION RP_YES_P RETURN VARCHAR2;
147
148 FUNCTION RP_NO_P RETURN VARCHAR2;
149
150 FUNCTION RP_GL_DATE_P RETURN VARCHAR2;
151
152 FUNCTION RP_INVOICE_DATE_P RETURN VARCHAR2;
153
154 FUNCTION RP_CURR_CODE_P RETURN VARCHAR2;
155
156 FUNCTION C_INDUSTRY_CODE_P RETURN VARCHAR2;
157
158 FUNCTION C_COMPANY_TITLE_P RETURN VARCHAR2;
159
160 FUNCTION RP_SUM_FOR_P RETURN VARCHAR2;
161
162 /* FUNCTION GET_NEXT_WORD(LIST IN OUT NOCOPY VARCHAR2
163 ,VALUE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
164
165 FUNCTION CEIL(D IN DATE) RETURN DATE;
166
167 FUNCTION EVEN(N IN NUMBER) RETURN BOOLEAN;
168
169 FUNCTION ODD(N IN NUMBER) RETURN BOOLEAN;
170
171 FUNCTION CHECK_FLAG(OPTIONS IN NUMBER
172 ,FLAG IN NUMBER) RETURN BOOLEAN;
173
174 PROCEDURE CLEAR_FLAG(OPTIONS IN OUT NOCOPY NUMBER
175 ,FLAG IN NUMBER);
176
177 PROCEDURE SET_FLAG(OPTIONS IN OUT NOCOPY NUMBER
178 ,FLAG IN NUMBER);*/
179
180 FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER) RETURN VARCHAR2;
181
182 FUNCTION FND_MESSAGE RETURN VARCHAR2;
183
184 FUNCTION PREVIOUS_MESSAGE(MD_OPTIONS IN NUMBER) RETURN VARCHAR2;
185
186 FUNCTION PREVIOUS_MESSAGE RETURN VARCHAR2;
187
188 FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2) RETURN VARCHAR2;
189
190 FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2
191 ,T1 IN VARCHAR2
192 ,V1 IN VARCHAR2) RETURN VARCHAR2;
193
194 FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2
195 ,T1 IN VARCHAR2
196 ,V1 IN VARCHAR2
197 ,T2 IN VARCHAR2
198 ,V2 IN VARCHAR2) RETURN VARCHAR2;
199
200 FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2
201 ,T1 IN VARCHAR2
202 ,V1 IN VARCHAR2
203 ,T2 IN VARCHAR2
204 ,V2 IN VARCHAR2
205 ,T3 IN VARCHAR2
206 ,V3 IN VARCHAR2) RETURN VARCHAR2;
207
208 FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2
209 ,T1 IN VARCHAR2
210 ,V1 IN VARCHAR2
211 ,T2 IN VARCHAR2
212 ,V2 IN VARCHAR2
213 ,T3 IN VARCHAR2
214 ,V3 IN VARCHAR2
215 ,T4 IN VARCHAR2
216 ,V4 IN VARCHAR2) RETURN VARCHAR2;
217
218 FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER
219 ,MSG_NAME IN VARCHAR2) RETURN VARCHAR2;
220
221 FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER
222 ,MSG_NAME IN VARCHAR2
223 ,T1 IN VARCHAR2
224 ,V1 IN VARCHAR2) RETURN VARCHAR2;
225
226 FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER
227 ,MSG_NAME IN VARCHAR2
228 ,T1 IN VARCHAR2
229 ,V1 IN VARCHAR2
230 ,T2 IN VARCHAR2
231 ,V2 IN VARCHAR2) RETURN VARCHAR2;
232
233 FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER
234 ,MSG_NAME IN VARCHAR2
235 ,T1 IN VARCHAR2
236 ,V1 IN VARCHAR2
237 ,T2 IN VARCHAR2
238 ,V2 IN VARCHAR2
239 ,T3 IN VARCHAR2
240 ,V3 IN VARCHAR2) RETURN VARCHAR2;
241
242 FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER
243 ,MSG_NAME IN VARCHAR2
244 ,T1 IN VARCHAR2
245 ,V1 IN VARCHAR2
246 ,T2 IN VARCHAR2
247 ,V2 IN VARCHAR2
248 ,T3 IN VARCHAR2
249 ,V3 IN VARCHAR2
250 ,T4 IN VARCHAR2
251 ,V4 IN VARCHAR2) RETURN VARCHAR2;
252
253 /* FUNCTION FUNCTIONAL_AMOUNT(AMOUNT IN NUMBER
254 ,CURRENCY_CODE IN VARCHAR2
255 ,EXCHANGE_RATE IN NUMBER
256 ,PRECISION IN NUMBER
257 ,MIN_ACC_UNIT IN NUMBER) RETURN NUMBER;
258
259 FUNCTION GL_DATE_RANGE_OPEN(PSTART_DATE IN VARCHAR2
260 ,PEND_DATE IN VARCHAR2) RETURN BOOLEAN;
261
262 FUNCTION AR_LOOKUP(LOOKUP_TYPE IN VARCHAR2
263 ,LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2;
264
265 FUNCTION MD_MSG_NUMBER RETURN NUMBER;
266
267 FUNCTION MD_MSG_TEXT RETURN NUMBER;
268
269 FUNCTION MD_MSG_NAME RETURN NUMBER;
270
271 FUNCTION MD_MSG_TOKENS RETURN NUMBER;
272
273 FUNCTION MD_MSG_EXPLANATION RETURN NUMBER;
274
275 FUNCTION MD_MSG_FIND_NUMBER RETURN NUMBER;
276
277 PROCEDURE GL_PERIOD_INFO(GL_DATE IN DATE
278 ,PERIOD_NAME OUT NOCOPY VARCHAR2
279 ,START_DATE OUT NOCOPY DATE
280 ,END_DATE OUT NOCOPY DATE
281 ,CLOSING_STATUS OUT NOCOPY VARCHAR2
282 ,PERIOD_TYPE OUT NOCOPY VARCHAR2
283 ,PERIOD_YEAR OUT NOCOPY NUMBER
284 ,PERIOD_NUM OUT NOCOPY NUMBER
285 ,QUARTER_NUM OUT NOCOPY NUMBER);
286
287 FUNCTION GL_PERIOD_NAME(GL_DATE IN DATE) RETURN VARCHAR2;
288
289 FUNCTION IS_GL_DATE_VALID(P_GL_DATE IN DATE
290 ,P_TRX_DATE IN DATE
291 ,P_VALIDATION_DATE1 IN DATE
292 ,P_VALIDATION_DATE2 IN DATE
293 ,P_VALIDATION_DATE3 IN DATE
294 ,P_ALLOW_NOT_OPEN_FLAG IN VARCHAR2
295 ,P_SET_OF_BOOKS_ID IN NUMBER
296 ,P_APPLICATION_ID IN NUMBER
297 ,P_CHECK_PERIOD_STATUS IN BOOLEAN) RETURN BOOLEAN;
298
299 FUNCTION VALIDATE_AND_DEFAULT_GL_DATE(GL_DATE IN DATE
300 ,TRX_DATE IN DATE
301 ,VALIDATION_DATE1 IN DATE
302 ,VALIDATION_DATE2 IN DATE
303 ,VALIDATION_DATE3 IN DATE
304 ,DEFAULT_DATE1 IN DATE
305 ,DEFAULT_DATE2 IN DATE
306 ,DEFAULT_DATE3 IN DATE
307 ,P_ALLOW_NOT_OPEN_FLAG IN VARCHAR2
308 ,P_INVOICING_RULE_ID IN VARCHAR2
309 ,P_SET_OF_BOOKS_ID IN NUMBER
310 ,P_APPLICATION_ID IN NUMBER
311 ,DEFAULT_GL_DATE OUT NOCOPY DATE
312 ,DEFAULTING_RULE_USED OUT NOCOPY VARCHAR2
313 ,ERROR_MESSAGE OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
314
315 PROCEDURE DEBUG(LINE IN VARCHAR2);
316
317 PROCEDURE ENABLE_DEBUG;
318
319 PROCEDURE ENABLE_DEBUG(BUFFER_SIZE IN NUMBER);
320
321 PROCEDURE DISABLE_DEBUG;
322
323 PROCEDURE SET_WHO_INFORMATION(USER_ID IN NUMBER
324 ,REQUEST_ID IN NUMBER
325 ,PROGRAM_APPLICATION_ID IN NUMBER
326 ,PROGRAM_ID IN NUMBER
327 ,LAST_UPDATE_LOGIN IN NUMBER);
328
329 PROCEDURE SET_APPLICATION_INFORMATION(APPL_ID IN NUMBER
330 ,LANGUAGE_ID IN NUMBER);
331
332 PROCEDURE FND_MESSAGE;
333
334 PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2);
335
336 PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2
337 ,T1 IN VARCHAR2
338 ,V1 IN VARCHAR2);
339
340 PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2
341 ,T1 IN VARCHAR2
342 ,V1 IN VARCHAR2
343 ,T2 IN VARCHAR2
344 ,V2 IN VARCHAR2);
345
346 PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2
347 ,T1 IN VARCHAR2
348 ,V1 IN VARCHAR2
349 ,T2 IN VARCHAR2
350 ,V2 IN VARCHAR2
351 ,T3 IN VARCHAR2
352 ,V3 IN VARCHAR2);
353
354 PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2
355 ,T1 IN VARCHAR2
356 ,V1 IN VARCHAR2
357 ,T2 IN VARCHAR2
358 ,V2 IN VARCHAR2
359 ,T3 IN VARCHAR2
360 ,V3 IN VARCHAR2
361 ,T4 IN VARCHAR2
362 ,V4 IN VARCHAR2);
363
364 PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER);
365
366 PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER
367 ,MSG_NAME IN VARCHAR2);
368
369 PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER
370 ,MSG_NAME IN VARCHAR2
371 ,T1 IN VARCHAR2
372 ,V1 IN VARCHAR2);
373
374 PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER
375 ,MSG_NAME IN VARCHAR2
376 ,T1 IN VARCHAR2
377 ,V1 IN VARCHAR2
378 ,T2 IN VARCHAR2
379 ,V2 IN VARCHAR2);
380
381 PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER
382 ,MSG_NAME IN VARCHAR2
383 ,T1 IN VARCHAR2
384 ,V1 IN VARCHAR2
385 ,T2 IN VARCHAR2
386 ,V2 IN VARCHAR2
387 ,T3 IN VARCHAR2
388 ,V3 IN VARCHAR2);
389
390 PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER
391 ,MSG_NAME IN VARCHAR2
392 ,T1 IN VARCHAR2
393 ,V1 IN VARCHAR2
394 ,T2 IN VARCHAR2
395 ,V2 IN VARCHAR2
396 ,T3 IN VARCHAR2
397 ,V3 IN VARCHAR2
398 ,T4 IN VARCHAR2
399 ,V4 IN VARCHAR2);
400
401 PROCEDURE GL_ACTIVITY(P_PERIOD_FROM IN VARCHAR2
402 ,P_PERIOD_TO IN VARCHAR2
403 ,P_CODE_COMBINATION_ID IN NUMBER
404 ,P_SET_OF_BOOKS_ID IN NUMBER
405 ,P_PERIOD_NET_DR OUT NOCOPY NUMBER
406 ,P_PERIOD_NET_CR OUT NOCOPY NUMBER);
407
408 PROCEDURE FIND_PREVIOUS_TRX_LINE_ID(P_CUSTOMER_TRX_LINE_ID IN NUMBER
409 ,P_TAX_LINE_NUMBER IN NUMBER
410 ,P_VAT_TAX_ID IN NUMBER
411 ,P_TAX_CUSTOMER_TRX_ID OUT NOCOPY NUMBER
412 ,P_TAX_CUSTOMER_TRX_LINE_ID OUT NOCOPY NUMBER
413 ,P_CHK_APPLIED_CM IN BOOLEAN);*/
414
415
416
417 /* FUNCTION GET_APP_INFO(APPLICATION_SHORT_NAME IN VARCHAR2
418 ,STATUS OUT NOCOPY VARCHAR2
419 ,INDUSTRY OUT NOCOPY VARCHAR2
420 ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
421
422 FUNCTION GET_APP_INFO_OTHER(APPLICATION_SHORT_NAME IN VARCHAR2
423 ,TARGET_SCHEMA IN VARCHAR2
424 ,STATUS OUT NOCOPY VARCHAR2
428 FUNCTION GET(APPL_ID IN INTEGER
425 ,INDUSTRY OUT NOCOPY VARCHAR2
426 ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;*/
427
429 ,DEP_APPL_ID IN INTEGER
430 ,STATUS OUT NOCOPY VARCHAR2
431 ,INDUSTRY OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
432
433 END IGI_IGIRRTRH_XMLP_PKG;
434