1 PACKAGE JE_JEPTARER_XMLP_PKG AS
2 /* $Header: JEPTARERS.pls 120.1 2007/12/25 16:59:22 dwkrishn noship $ */
3 P_SET_OF_BOOKS_ID NUMBER;
4
5 P_CONC_REQUEST_ID NUMBER := 1374621;
6
7 P_LEGAL_ENTITY_ID NUMBER;
8
9 P_CHART_OF_ACCT NUMBER;
10
11 P_BALANCING_SEGMENT VARCHAR2(25);
12
13 P_BAL_SEG_NAME VARCHAR2(200) := '1=1';
14
15 PLACE_REP_TITLE VARCHAR2(240);
16
17 PLACE_COA_ID VARCHAR2(50);
18
19 PLACE_SOB_NAME VARCHAR2(50);
20
21 PLACE_FUNCT_CURR VARCHAR2(50);
22
23 FUNCTION BEFOREREPORT RETURN BOOLEAN;
24
25 FUNCTION AFTERREPORT RETURN BOOLEAN;
26
27 FUNCTION PLACE_REP_TITLE_P RETURN VARCHAR2;
28
29 FUNCTION PLACE_COA_ID_P RETURN VARCHAR2;
30
31 FUNCTION PLACE_SOB_NAME_P RETURN VARCHAR2;
32
33 FUNCTION PLACE_FUNCT_CURR_P RETURN VARCHAR2;
34
35 PROCEDURE GL_GET_PERIOD_DATES(TSET_OF_BOOKS_ID IN NUMBER
36 ,TPERIOD_NAME IN VARCHAR2
37 ,TSTART_DATE OUT NOCOPY DATE
38 ,TEND_DATE OUT NOCOPY DATE
39 ,ERRBUF OUT NOCOPY VARCHAR2);
40
41 PROCEDURE GL_GET_LEDGER_INFO(SOBID IN NUMBER
42 ,COAID OUT NOCOPY NUMBER
43 ,SOBNAME OUT NOCOPY VARCHAR2
44 ,FUNC_CURR OUT NOCOPY VARCHAR2
45 ,ERRBUF OUT NOCOPY VARCHAR2);
46
47 PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
48 ,TYPE_ID IN NUMBER
49 ,NAME OUT NOCOPY VARCHAR2
50 ,ERRBUF OUT NOCOPY VARCHAR2);
51
52 PROCEDURE GL_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
53 ,CODE IN VARCHAR2
54 ,TYPE IN VARCHAR2
55 ,VALUE OUT NOCOPY VARCHAR2
56 ,ERRBUF OUT NOCOPY VARCHAR2);
57
58 PROCEDURE GL_GET_FIRST_PERIOD(TSET_OF_BOOKS_ID IN NUMBER
59 ,TPERIOD_NAME IN VARCHAR2
60 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
61 ,ERRBUF OUT NOCOPY VARCHAR2);
62
63 PROCEDURE GL_GET_FIRST_PERIOD_OF_QUARTER(TSET_OF_BOOKS_ID IN NUMBER
64 ,TPERIOD_NAME IN VARCHAR2
65 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
66 ,ERRBUF OUT NOCOPY VARCHAR2);
67
68 PROCEDURE GL_GET_CONSOLIDATION_INFO(CONS_ID IN NUMBER
69 ,CONS_NAME OUT NOCOPY VARCHAR2
70 ,METHOD OUT NOCOPY VARCHAR2
71 ,CURR_CODE OUT NOCOPY VARCHAR2
72 ,FROM_SOBID OUT NOCOPY NUMBER
73 ,TO_SOBID OUT NOCOPY NUMBER
74 ,DESCRIPTION OUT NOCOPY VARCHAR2
75 ,START_DATE OUT NOCOPY DATE
76 ,END_DATE OUT NOCOPY DATE
77 ,ERRBUF OUT NOCOPY VARCHAR2);
78
79 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
80 ,NAME IN VARCHAR2);
81
82 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
83 ,VALUE IN VARCHAR2
84 ,TRANSLATE IN BOOLEAN);
85
86 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
87
88 PROCEDURE CLEAR;
89
90 FUNCTION GET_STRING(APPIN IN VARCHAR2
91 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
92
93 FUNCTION GET RETURN VARCHAR2;
94
95 FUNCTION GET_ENCODED RETURN VARCHAR2;
96
97 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
98 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
99 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
100
101 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
102
103 PROCEDURE RAISE_ERROR;
104
105 END JE_JEPTARER_XMLP_PKG;
106
107