PACKAGE: APPS.JE_JENOGEIS_XMLP_PKG

Source

1 PACKAGE JE_JENOGEIS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JENOGEISS.pls 120.1 2007/12/25 16:57:53 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_LEDGER_ID NUMBER;
6 
7   P_FILENAME VARCHAR2(240);
8 
9   P_EXPENSE VARCHAR2(32767);
10 
11   P_INCOME VARCHAR2(32767);
12 
13   P_PERIOD_NAME VARCHAR2(32767);
14 
15   P_FINAL VARCHAR2(32767);
16 
17   STRUCT_NUM VARCHAR2(15) := '101';
18 
19   SET_OF_BOOKS_NAME VARCHAR2(30);
20 
21   SELECT_ALL VARCHAR2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' ||
22   SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 ||
23   ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' ||
24   SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25
25   || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
26 
27   WHERE_FLEX VARCHAR2(4000) := 'CC.SEGMENT11 BETWEEN  ''00'' and ''11''';
28 
29   ORDERBY_ACCT VARCHAR2(30) := 'CC.SEGMENT10';
30 
31   PRECISION NUMBER := 0;
32 
33   FUNC_CURRENCY VARCHAR2(25);
34 
35   FUNCTION AFTERREPORT RETURN BOOLEAN;
36 
37   FUNCTION BEFOREREPORT RETURN BOOLEAN;
38 
39   PROCEDURE P_GEI_VIEW;
40 
41   PROCEDURE P_INS_ASCII(P_LINE_NUMBER IN JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE
42                        ,P_TEXT IN JE_NO_GEI_ASCIIS_T.TEXT%TYPE);
43 
44   PROCEDURE P_INSERT_PERIOD_NAME(P_PERIOD_NAME IN GL_BALANCES.PERIOD_NAME%TYPE
45                                 ,P_ACCOUNT_INCOME IN GL_BALANCES.PERIOD_NET_DR%TYPE
46                                 ,P_ACCOUNT_EXPENSE IN GL_BALANCES.PERIOD_NET_DR%TYPE);
47 
48   FUNCTION CF_DATEFORMULA RETURN CHAR;
49 
50   FUNCTION CF_REPORT_TITLEFORMULA RETURN CHAR;
51 
52   FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
53 
54   FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
55 
56   FUNCTION SELECT_ALL_P RETURN VARCHAR2;
57 
58   FUNCTION WHERE_FLEX_P RETURN VARCHAR2;
59 
60   FUNCTION ORDERBY_ACCT_P RETURN VARCHAR2;
61 
62   FUNCTION PRECISION_P RETURN NUMBER;
63 
64   FUNCTION FUNC_CURRENCY_P RETURN VARCHAR2;
65 
66 END JE_JENOGEIS_XMLP_PKG;
67 
68 
69