[Home] [Help]
PACKAGE: APPS.XTR_XTRJLDAT_XMLP_PKG
Source
1 PACKAGE XTR_XTRJLDAT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRJLDATS.pls 120.1 2007/12/28 12:52:38 npannamp noship $ */
3 REPORT_NOS VARCHAR2(30);
4
5 REPORT_SHORT_NAME VARCHAR2(80);
6
7 REPORT_GROUP VARCHAR2(32767);
8
9 USE_DEFAULTS VARCHAR2(1);
10
11 COMPANY_CODE VARCHAR2(7);
12
13 DEAL_NUMBER NUMBER;
14
15 AMOUNT NUMBER;
16
17 JNL_TRANSFER_DATE DATE;
18
19 DEAL_TYPE_NAME VARCHAR2(30);
20
21 AMOUNT_TYPE_NAME VARCHAR2(30);
22
23 GL_CODE_REF VARCHAR2(1000):='%';
24
25 Z2SUBTYPE VARCHAR2(100);
26
27 Z2PRODUCT VARCHAR2(100);
28
29 Z2END_OF_REPORT VARCHAR2(100);
30
31 Z2PORTFOLIO VARCHAR2(100);
32
33 Z2DESCRIPTION VARCHAR2(100);
34
35 Z2DR_AMOUNT VARCHAR2(100);
36
37 Z2CR_AMOUNT VARCHAR2(100);
38
39 Z1PARAMETERS VARCHAR2(100);
40
41 Z1COMPANY VARCHAR2(100);
42
43 Z1AMOUNT VARCHAR2(100);
44
45 Z2DEAL VARCHAR2(100);
46
47 Z1GL_CODE VARCHAR2(100);
48
49 Z1TYPE VARCHAR2(100);
50
51 Z1AMOUNT_TYPE VARCHAR2(100);
52
53 Z1JOURNALS_FROM VARCHAR2(100);
54
55 Z1TO VARCHAR2(100);
56
57 Z2AND_NAME VARCHAR2(100);
58
59 Z2NOTE_ALL_AMOUNTS_ARE_IN VARCHAR2(100);
60
61 Z2JOURNAL_DATE VARCHAR2(100);
62
63 Z2PAGE VARCHAR2(100);
64
65 REPORT_SHORT_NAME2 VARCHAR2(240);
66
67 P_CONC_REQUEST_ID NUMBER;
68
69 COMPANY_NAME_HEADER VARCHAR2(80);
70
71 P_JOURNALS_FROM VARCHAR2(32767);
72 P_JOURNALS_FROM_T VARCHAR2(32767);
73 P_JOURNALS_TO VARCHAR2(32767);
74 P_JOURNALS_TO_T VARCHAR2(32767);
75 P_COMPANY VARCHAR2(7);
76
77 P_NAME VARCHAR2(32767);
78
79 P_DEAL_NUMBER NUMBER;
80
81 P_DEAL_TYPE VARCHAR2(7);
82
83 P_AMOUNT_TYPE VARCHAR2(7);
84
85 P_AMOUNT NUMBER;
86
87 P_GL_ACCOUNT VARCHAR2(1000);
88
89 P_SQL_TRACE VARCHAR2(32767);
90
91 P_DISPLAY_DEBUG VARCHAR2(32767);
92
93 JNLS_FROM_DATE2 DATE;
94
95 JNLS_TO_DATE2 DATE;
96
97 COMPANY_CODE2 VARCHAR2(7);
98
99 DEAL_NUMBER2 NUMBER;
100
101 DEAL_TYPE2 VARCHAR2(7);
102
103 AMOUNT_TYPE2 VARCHAR2(7);
104
105 AMOUNT2 NUMBER;
106
107 GL_CODE2 VARCHAR2(1000);
108
109 REPORT_DATE VARCHAR2(100);
110
111 P_STRUCT_NUM VARCHAR2(32767) := '101';
112
113 COMPANY_NAME VARCHAR2(32767);
114
115 Z2TRANSACTION VARCHAR2(100);
116
117 Z2NUMBER VARCHAR2(100);
118
119 Z2CURRENCY VARCHAR2(100);
120
121 P_CCY_TYPE VARCHAR2(50);
122
123 P_GL_INTERFACED VARCHAR2(1);
124
125 Z1GL_INTERFACED VARCHAR2(100);
126
127 Z2CURRENCY1 VARCHAR2(100);
128
129 Z2SOB_DESC VARCHAR2(100);
130
131 Z2TOTAL VARCHAR2(100);
132
133 Z2TR_DESC VARCHAR2(100);
134
135 TR_GL_MEANING VARCHAR2(100);
136
137 AMT_TYP_MEANING VARCHAR2(100);
138
139 Z2DEALNO VARCHAR2(100);
140
141 Z2DEALTYPE VARCHAR2(100);
142
143 P_SHORT_NAME VARCHAR2(32767);
144
145 P_ACCT_DESC VARCHAR2(2000);
146
147 CP_PARA VARCHAR2(32767);
148
149 CP_FLEXDATA VARCHAR2(1000) := '(GCC.SEGMENT1||''\n''||GCC.SEGMENT2||''\n''||GCC.SEGMENT3||''\n''||
150 GCC.SEGMENT4||''\n''||GCC.SEGMENT5||''\n''||GCC.SEGMENT6||''\n''||GCC.SEGMENT7||''\n''||GCC.SEGMENT8||''\n''||
151 GCC.SEGMENT9||''\n''||GCC.SEGMENT10||''\n''||GCC.SEGMENT11||''\n''||GCC.SEGMENT12||''\n''||GCC.SEGMENT13||''\n''||
152 GCC.SEGMENT14||''\n''||GCC.SEGMENT15||''\n''||GCC.SEGMENT16||''\n''||GCC.SEGMENT17||''\n''||GCC.SEGMENT18||''\n''||
153 GCC.SEGMENT19||''\n''||GCC.SEGMENT20||''\n''||GCC.SEGMENT21||''\n''||GCC.SEGMENT22||''\n''||GCC.SEGMENT23||''\n''||
154 GCC.SEGMENT24||''\n''||GCC.SEGMENT25||''\n''||GCC.SEGMENT26||''\n''||GCC.SEGMENT27||''\n''||GCC.SEGMENT28||''\n''||
155 GCC.SEGMENT29||''\n''||GCC.SEGMENT30)';
156
157 WHERE_FLEX VARCHAR2(4000) := '1=1';
158
159 GL_WHERE VARCHAR2(100) := '1=1';
160
161 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
162
163 -- FUNCTION BEFOREREPORT(C_DATEFORMAT IN VARCHAR2) RETURN BOOLEAN;
164 FUNCTION BEFOREREPORT RETURN BOOLEAN;
165
166 FUNCTION AFTERREPORT RETURN BOOLEAN;
167
168 FUNCTION AFTERPFORM RETURN BOOLEAN;
169
170 FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN CHAR;
171
172 FUNCTION CP_PARA_P RETURN VARCHAR2;
173
174 FUNCTION CP_FLEXDATA_P RETURN VARCHAR2;
175
176 FUNCTION WHERE_FLEX_P RETURN VARCHAR2;
177
178 FUNCTION GL_WHERE_P RETURN VARCHAR2;
179
180 END XTR_XTRJLDAT_XMLP_PKG;
181
182