[Home] [Help]
PACKAGE: APPS.GL_GLXRBUDA_XMLP_PKG
Source
1 PACKAGE GL_GLXRBUDA_XMLP_PKG AS
2 /* $Header: GLXRBUDAS.pls 120.0 2007/12/27 15:06:04 vijranga noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_LEDGER_ID NUMBER;
6
7 P_BUDGET_VERSION_ID NUMBER;
8
9 P_CURRENCY_CODE VARCHAR2(15);
10
11 P_PERIOD_NAME VARCHAR2(15);
12
13 P_PERIOD_TYPE VARCHAR2(30);
14
15 P_ACCESS_SET_ID NUMBER;
16
17 LEDGER_NAME VARCHAR2(30);
18
19 BUDGET_NAME VARCHAR2(30);
20
21 STRUCT_NUM NUMBER := 50105;
22
23 FLEXDATA VARCHAR2(1000) := '(segment1||''\n''||segment2||''\n''||segment3||''\n''||segment4||''\n''||segment5||
24 ''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''||segment9||''\n''||segment10||''\n''||segment11||
25 ''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||''\n''||segment19||''\n''||segment20||''\n''||segment21||
26 ''\n''||segment22||''\n''||segment23||''\n''||segment24||''\n''||segment25||''\n''||segment26||''\n''||segment27||''\n''||segment28||''\n''||segment29||''\n''||segment30)';
27
28 ACCOUNT_SEG VARCHAR2(1000) := '(segment1||''\n''||segment2||''\n''||segment3||''\n''||segment4||''\n''||segment5||''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''||segment9||''\n''
29 ||segment10||''\n''||segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||''\n''||segment19||''\n''||
30 segment20||''\n''||segment21||''\n''||segment22||''\n''||segment23||''\n''||segment24||''\n''||segment25||''\n''||segment26||''\n''||segment27||''\n''||segment28||''\n''||segment29||''\n''||segment30)';
31
32 FLEX_ORDERBY VARCHAR2(1000) := '1';
33
34 PTD_YTD VARCHAR2(300) := '(glbd.period_net_dr + glbd.project_to_date_dr - glbd.period_net_cr - glbd.project_to_date_cr)';
35
36 PTD_YTD_DSP VARCHAR2(240);
37
38 ACCESS_SET_NAME VARCHAR2(30);
39
40 WHERE_DAS VARCHAR2(800);
41
42 FUNCTION AFTERREPORT RETURN BOOLEAN;
43
44 FUNCTION BEFOREREPORT RETURN BOOLEAN;
45
46 FUNCTION LEDGER_NAME_P RETURN VARCHAR2;
47
48 FUNCTION BUDGET_NAME_P RETURN VARCHAR2;
49
50 FUNCTION STRUCT_NUM_P RETURN NUMBER;
51
52 FUNCTION FLEXDATA_P RETURN VARCHAR2;
53
54 FUNCTION ACCOUNT_SEG_P RETURN VARCHAR2;
55
56 FUNCTION FLEX_ORDERBY_P RETURN VARCHAR2;
57
58 FUNCTION PTD_YTD_P RETURN VARCHAR2;
59
60 FUNCTION PTD_YTD_DSP_P RETURN VARCHAR2;
61
62 FUNCTION ACCESS_SET_NAME_P RETURN VARCHAR2;
63
64 FUNCTION WHERE_DAS_P RETURN VARCHAR2;
65
66 PROCEDURE GL_GET_PERIOD_DATES(TLEDGER_ID IN NUMBER
67 ,TPERIOD_NAME IN VARCHAR2
68 ,TSTART_DATE OUT NOCOPY DATE
69 ,TEND_DATE OUT NOCOPY DATE
70 ,ERRBUF OUT NOCOPY VARCHAR2);
71
72 PROCEDURE GL_GET_LEDGER_INFO(LEDID IN NUMBER
73 ,COAID OUT NOCOPY NUMBER
74 ,LEDNAME OUT NOCOPY VARCHAR2
75 ,FUNC_CURR OUT NOCOPY VARCHAR2
76 ,ERRBUF OUT NOCOPY VARCHAR2);
77
78 PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
79 ,TYPE_ID IN NUMBER
80 ,NAME OUT NOCOPY VARCHAR2
81 ,ERRBUF OUT NOCOPY VARCHAR2);
82
83 PROCEDURE GL_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
84 ,CODE IN VARCHAR2
85 ,TYPE IN VARCHAR2
86 ,VALUE OUT NOCOPY VARCHAR2
87 ,ERRBUF OUT NOCOPY VARCHAR2);
88
89 PROCEDURE GL_GET_FIRST_PERIOD(TLEDGER_ID IN NUMBER
90 ,TPERIOD_NAME IN VARCHAR2
91 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
92 ,ERRBUF OUT NOCOPY VARCHAR2);
93
94 PROCEDURE GL_GET_FIRST_PERIOD_OF_QUARTER(TLEDGER_ID IN NUMBER
95 ,TPERIOD_NAME IN VARCHAR2
96 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
97 ,ERRBUF OUT NOCOPY VARCHAR2);
98
99 PROCEDURE GL_GET_CONSOLIDATION_INFO(CONS_ID IN NUMBER
100 ,CONS_NAME OUT NOCOPY VARCHAR2
101 ,METHOD OUT NOCOPY VARCHAR2
102 ,CURR_CODE OUT NOCOPY VARCHAR2
103 ,FROM_LEDID OUT NOCOPY NUMBER
104 ,TO_LEDID OUT NOCOPY NUMBER
105 ,DESCRIPTION OUT NOCOPY VARCHAR2
106 ,START_DATE OUT NOCOPY DATE
107 ,END_DATE OUT NOCOPY DATE
108 ,ERRBUF OUT NOCOPY VARCHAR2);
109
110 END GL_GLXRBUDA_XMLP_PKG;
111
112