DBA Data[Home] [Help]

PACKAGE: APPS.JE_JENOGEIA_XMLP_PKG

Source


1 PACKAGE        "JE_JENOGEIA_XMLP_PKG" AUTHID CURRENT_USER AS
2 /* $Header: JENOGEIAS.pls 120.1 2008/01/11 08:15:12 vijranga noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_LEDGER_ID NUMBER;
6 
7   P_FILENAME VARCHAR2(240);
8 
9   P_ERRORS VARCHAR2(32767);
10 
11   STRUCT_NUM VARCHAR2(15) := '101';
12 
13   SET_OF_BOOKS_NAME VARCHAR2(30);
14 
15   SELECT_ALL VARCHAR2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 ||
16   ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 ||
17   ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 ||
18   ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 ||
19   ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
20 
21   WHERE_FLEX VARCHAR2(4000) := 'CC.SEGMENT11 BETWEEN  ''00'' and ''11''';
22 
23   ORDERBY_ACCT VARCHAR2(30) := 'CC.SEGMENT10';
24 
25   PRECISION NUMBER := 0;
26 
27   FUNC_CURRENCY VARCHAR2(25);
28 
29   FUNCTION AFTERREPORT RETURN BOOLEAN;
30 
31   FUNCTION BEFOREREPORT RETURN BOOLEAN;
32 
33   FUNCTION B_EORFORMATTRIGGER(CS_COUNT_AUT IN NUMBER) RETURN BOOLEAN;
34 
35   FUNCTION CF_REPORT_TITLEFORMULA RETURN CHAR;
36 
37   FUNCTION CF_DATEFORMULA RETURN CHAR;
38 
39   FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
40 
41   FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
42 
43   FUNCTION SELECT_ALL_P RETURN VARCHAR2;
44 
45   FUNCTION WHERE_FLEX_P RETURN VARCHAR2;
46 
47   FUNCTION ORDERBY_ACCT_P RETURN VARCHAR2;
48 
49   FUNCTION PRECISION_P RETURN NUMBER;
50 
51   FUNCTION FUNC_CURRENCY_P RETURN VARCHAR2;
52 
53 END JE_JENOGEIA_XMLP_PKG;
54 
55 
56