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