1 PACKAGE GL_GLXRLTCL_XMLP_PKG AS
2 /* $Header: GLXRLTCLS.pls 120.0 2007/12/27 15:22:24 vijranga noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_SET_OF_BOOKS_ID NUMBER;
6
7 P_TXN_CODE VARCHAR2(30);
8
9 SET_OF_BOOKS_NAME VARCHAR2(30);
10
11 STRUCT_NUM NUMBER;
12
13 VALUE_SET_ID NUMBER;
14
15 PAGENO NUMBER;
16
17 FUNCTION BEFOREREPORT RETURN BOOLEAN;
18
19 FUNCTION AFTERREPORT RETURN BOOLEAN;
20
21 FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
22
23 FUNCTION STRUCT_NUM_P RETURN NUMBER;
24
25 FUNCTION VALUE_SET_ID_P RETURN NUMBER;
26
27 FUNCTION PAGENO_P RETURN NUMBER;
28
29 PROCEDURE GL_GET_PERIOD_DATES(TSET_OF_BOOKS_ID IN NUMBER
30 ,TPERIOD_NAME IN VARCHAR2
31 ,TSTART_DATE OUT NOCOPY DATE
32 ,TEND_DATE OUT NOCOPY DATE
33 ,ERRBUF OUT NOCOPY VARCHAR2);
34
35 PROCEDURE GL_GET_LEDGER_INFO(SOBID IN NUMBER
36 ,COAID OUT NOCOPY NUMBER
37 ,SOBNAME OUT NOCOPY VARCHAR2
38 ,FUNC_CURR OUT NOCOPY VARCHAR2
39 ,ERRBUF OUT NOCOPY VARCHAR2);
40
41 PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
42 ,TYPE_ID IN NUMBER
43 ,NAME OUT NOCOPY VARCHAR2
44 ,ERRBUF OUT NOCOPY VARCHAR2);
45
46 PROCEDURE GL_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
47 ,CODE IN VARCHAR2
48 ,TYPE IN VARCHAR2
49 ,VALUE OUT NOCOPY VARCHAR2
50 ,ERRBUF OUT NOCOPY VARCHAR2);
51
52 PROCEDURE GL_GET_FIRST_PERIOD(TSET_OF_BOOKS_ID IN NUMBER
53 ,TPERIOD_NAME IN VARCHAR2
54 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
55 ,ERRBUF OUT NOCOPY VARCHAR2);
56
57 PROCEDURE GL_GET_FIRST_PERIOD_OF_QUARTER(TSET_OF_BOOKS_ID IN NUMBER
58 ,TPERIOD_NAME IN VARCHAR2
59 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
60 ,ERRBUF OUT NOCOPY VARCHAR2);
61
62 PROCEDURE GL_GET_CONSOLIDATION_INFO(CONS_ID IN NUMBER
63 ,CONS_NAME OUT NOCOPY VARCHAR2
64 ,METHOD OUT NOCOPY VARCHAR2
65 ,CURR_CODE OUT NOCOPY VARCHAR2
66 ,FROM_SOBID OUT NOCOPY NUMBER
67 ,TO_SOBID OUT NOCOPY NUMBER
68 ,DESCRIPTION OUT NOCOPY VARCHAR2
69 ,START_DATE OUT NOCOPY DATE
70 ,END_DATE OUT NOCOPY DATE
71 ,ERRBUF OUT NOCOPY VARCHAR2);
72
73 PROCEDURE SET_LANGUAGE(LANG_ID IN NUMBER);
74
75 FUNCTION GET_MESSAGE(MSG_NAME IN VARCHAR2
76 ,SHOW_NUM IN VARCHAR2) RETURN VARCHAR2;
77
78 FUNCTION MSG_TKN_EXPAND(MSG IN VARCHAR2
79 ,T1 IN VARCHAR2
80 ,V1 IN VARCHAR2) RETURN VARCHAR2;
81
82 FUNCTION GET_MESSAGE(MSG_NAME IN VARCHAR2
83 ,SHOW_NUM IN VARCHAR2
84 ,T1 IN VARCHAR2
85 ,V1 IN VARCHAR2) RETURN VARCHAR2;
86
87 FUNCTION GET_MESSAGE(MSG_NAME IN VARCHAR2
88 ,SHOW_NUM IN VARCHAR2
89 ,T1 IN VARCHAR2
90 ,V1 IN VARCHAR2
91 ,T2 IN VARCHAR2
92 ,V2 IN VARCHAR2) RETURN VARCHAR2;
93
94 FUNCTION GET_MESSAGE(MSG_NAME IN VARCHAR2
95 ,SHOW_NUM IN VARCHAR2
96 ,T1 IN VARCHAR2
97 ,V1 IN VARCHAR2
98 ,T2 IN VARCHAR2
99 ,V2 IN VARCHAR2
100 ,T3 IN VARCHAR2
101 ,V3 IN VARCHAR2) RETURN VARCHAR2;
102
103 FUNCTION GET_MESSAGE(MSG_NAME IN VARCHAR2
104 ,SHOW_NUM IN VARCHAR2
105 ,T1 IN VARCHAR2
106 ,V1 IN VARCHAR2
107 ,T2 IN VARCHAR2
108 ,V2 IN VARCHAR2
109 ,T3 IN VARCHAR2
110 ,V3 IN VARCHAR2
111 ,T4 IN VARCHAR2
112 ,V4 IN VARCHAR2) RETURN VARCHAR2;
113
114 END GL_GLXRLTCL_XMLP_PKG;
115
[Home] [Help]