eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JG_JGZZARIN_XMLP_PKG

Source


1 PACKAGE JG_JGZZARIN_XMLP_PKG AS
2 /* $Header: JGZZARINS.pls 120.0 2008/01/08 07:52:56 vjaganat noship $ */
3   P_INVOICE_NUMBER_LOW VARCHAR2(32767);
4 
5   P_SET_OF_BOOKS_ID NUMBER;
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_DOCUMENT_TYPE VARCHAR2(80);
10 
11   P_PRINT_CODE VARCHAR2(1);
12 
13   P_ORG_ID VARCHAR2(40);
14 
15   P_CUST_ID NUMBER;
16 
17   P_INVOICE_NUMBER_HIGH VARCHAR2(32767);
18 
19   P_ORDER_BY VARCHAR2(50);
20 
21   P_BATCH_ID NUMBER;
22 
23   P_INVOICE_DATE_LOW DATE;
24 
25   P_INVOICE_DATE_HIGH DATE;
26 
27   P_ORGANIZATION_ID VARCHAR2(40);
28 
29   P_COUNTRY_CODE VARCHAR2(32767);
30 
31   P_DEBUG_SWITCH VARCHAR2(32767);
32 
33   P_SESSION_LANGUAGE VARCHAR2(200);
34 
35   S_SAY VARCHAR2(1000);
36 
37   CP_SHIP_CUST_NAME VARCHAR2(240);
38 
39   CP_SHIP_ADD_1 VARCHAR2(240);
40 
41   CP_SHIP_ADD_2 VARCHAR2(240);
42 
43   CP_SHIP_ADD_3 VARCHAR2(240);
44 
45   CP_SHIP_ADD_4 VARCHAR2(240);
46 
47   CP_SHIP_CITY VARCHAR2(240);
48 
49   CP_SHIP_POSTAL_CODE VARCHAR2(240);
50 
51   CP_SHIP_COUNTRY VARCHAR2(240);
52 
53   CP_BILL_CUST_NAME VARCHAR2(240);
54 
55   CP_BILL_ADD_1 VARCHAR2(240);
56 
57   CP_BILL_ADD_2 VARCHAR2(240);
58 
59   CP_BILL_ADD_3 VARCHAR2(240);
60 
61   CP_BILL_ADD_4 VARCHAR2(240);
62 
63   CP_BILL_CITY VARCHAR2(240);
64 
65   CP_BILL_POSTAL_CODE VARCHAR2(240);
66 
67   CP_BILL_COUNTRY VARCHAR2(240);
68 
69   CP_BILL_TAX_REFERENCE VARCHAR2(240);
70 
71   CP_REMIT_CUST VARCHAR2(240);
72 
73   CP_REMIT_ADD_1 VARCHAR2(240);
74 
75   CP_REMIT_ADD_2 VARCHAR2(240);
76 
77   CP_REMIT_ADD_3 VARCHAR2(240);
78 
79   CP_REMIT_ADD_4 VARCHAR2(240);
80 
81   CP_REMIT_CITY VARCHAR2(240);
82 
83   CP_REMIT_COUNTRY VARCHAR2(240);
84 
85   CP_1 NUMBER;
86 
87   CP_REMIT_POSTAL_CODE VARCHAR2(240);
88 
89   FUNC_CURRENCY VARCHAR2(25);
90 
91   ORDERBY_ACCT VARCHAR2(30) := 'cc.segment10';
92 
93   PRECISION NUMBER := 0;
94 
95   SELECT_ALL VARCHAR2(1000) := 'cc.segment1';
96 
97   SET_OF_BOOKS_NAME VARCHAR2(30);
98 
99   STRUCT_NUM VARCHAR2(15) := '101';
100 
101   WHERE_FLEX VARCHAR2(4000) := 'cc.segment11 between ''00'' and ''11''';
102 
103   PRINT_TYPE VARCHAR2(60);
104 
105   TRX_NUMBER_LOW VARCHAR2(20);
106 
107   TRX_NUMBER_HIGH VARCHAR2(20);
108 
109   COMP_NUMBER VARCHAR2(20);
110 
111   VAT_REGISTRATION_NUM VARCHAR2(20);
112 
113   FUNCTION S_SFORMULA(INVOICE_TOTAL IN NUMBER
114                      ,CURRENCY IN VARCHAR2) RETURN VARCHAR2;
115 
116   FUNCTION AFTERREPORT RETURN BOOLEAN;
117 
118   PROCEDURE PRINT_STATUS_UPDATE;
119 
120   FUNCTION BEFOREREPORT RETURN BOOLEAN;
121 
122   FUNCTION CF_SHIP_ADDRESSFORMULA(CUST_NAME IN VARCHAR2
123                                  ,SHIP_ADD_1 IN VARCHAR2
124                                  ,SHIP_ADD_2 IN VARCHAR2
125                                  ,SHIP_ADD_3 IN VARCHAR2
126                                  ,SHIP_ADD_4 IN VARCHAR2
127                                  ,SHIP_CITY IN VARCHAR2
128                                  ,SHIP_POSTAL_CODE IN VARCHAR2
129                                  ,SHIP_COUNTRY IN VARCHAR2) RETURN VARCHAR2;
130 
131   FUNCTION CF_BILL_ADDRESSFORMULA(BILL_CUST_NAME IN VARCHAR2
132                                  ,BILL_ADD_1 IN VARCHAR2
133                                  ,BILL_ADD_2 IN VARCHAR2
134                                  ,BILL_ADD_3 IN VARCHAR2
135                                  ,BILL_ADD_4 IN VARCHAR2
136                                  ,BILL_CITY IN VARCHAR2
137                                  ,BILL_POSTAL_CODE IN VARCHAR2
138                                  ,BILL_TAX_REFERENCE IN VARCHAR2
139                                  ,BILL_COUNTRY IN VARCHAR2) RETURN VARCHAR2;
140 
141   FUNCTION CF_REMIT_ADDRESSFORMULA(REMIT_ADD_1 IN VARCHAR2
142                                   ,REMIT_ADD_2 IN VARCHAR2
143                                   ,REMIT_ADD_3 IN VARCHAR2
144                                   ,REMIT_ADD_4 IN VARCHAR2
145                                   ,REMIT_CITY IN VARCHAR2
146                                   ,REMIT_POSTAL_CODE IN VARCHAR2
147                                   ,REMIT_COUNTRY IN VARCHAR2) RETURN VARCHAR2;
148 
149   FUNCTION CF_1FORMULA RETURN VARCHAR2;
150 
151   FUNCTION CP_SHIP_COUNTRYFORMULA RETURN VARCHAR2;
152 
153   FUNCTION CF_DUE_DATEFORMULA(DUE_DATE IN DATE) RETURN CHAR;
154 
155   FUNCTION CF_TRX_DATEFORMULA(TRX_DATE IN DATE) RETURN CHAR;
156 
157   FUNCTION CF_TAX_DATEFORMULA(TAX_DATE IN DATE) RETURN CHAR;
158 
159   FUNCTION JE_AMOUNT_UTILITIES(IN_NUMERAL IN NUMBER) RETURN VARCHAR2;
160 
161   FUNCTION CF_APPLY_DATEFORMULA(APPLY_DATE1 IN DATE) RETURN CHAR;
162 
163   FUNCTION G_INVOICE_HEADERGROUPFILTER RETURN BOOLEAN;
164 
165   FUNCTION G_CUSTOMER_TRX_ID2GROUPFILTER RETURN BOOLEAN;
166 
167   FUNCTION S_SAY_P RETURN VARCHAR2;
168 
169   FUNCTION CP_SHIP_CUST_NAME_P RETURN VARCHAR2;
170 
171   FUNCTION CP_SHIP_ADD_1_P RETURN VARCHAR2;
172 
173   FUNCTION CP_SHIP_ADD_2_P RETURN VARCHAR2;
174 
175   FUNCTION CP_SHIP_ADD_3_P RETURN VARCHAR2;
176 
177   FUNCTION CP_SHIP_ADD_4_P RETURN VARCHAR2;
178 
179   FUNCTION CP_SHIP_CITY_P RETURN VARCHAR2;
180 
181   FUNCTION CP_SHIP_POSTAL_CODE_P RETURN VARCHAR2;
182 
183   FUNCTION CP_SHIP_COUNTRY_P RETURN VARCHAR2;
184 
185   FUNCTION CP_BILL_CUST_NAME_P RETURN VARCHAR2;
186 
187   FUNCTION CP_BILL_ADD_1_P RETURN VARCHAR2;
188 
189   FUNCTION CP_BILL_ADD_2_P RETURN VARCHAR2;
190 
191   FUNCTION CP_BILL_ADD_3_P RETURN VARCHAR2;
192 
193   FUNCTION CP_BILL_ADD_4_P RETURN VARCHAR2;
194 
195   FUNCTION CP_BILL_CITY_P RETURN VARCHAR2;
196 
197   FUNCTION CP_BILL_POSTAL_CODE_P RETURN VARCHAR2;
198 
199   FUNCTION CP_BILL_COUNTRY_P RETURN VARCHAR2;
200 
201   FUNCTION CP_BILL_TAX_REFERENCE_P RETURN VARCHAR2;
202 
203   FUNCTION CP_REMIT_CUST_P RETURN VARCHAR2;
204 
205   FUNCTION CP_REMIT_ADD_1_P RETURN VARCHAR2;
206 
207   FUNCTION CP_REMIT_ADD_2_P RETURN VARCHAR2;
208 
209   FUNCTION CP_REMIT_ADD_3_P RETURN VARCHAR2;
210 
211   FUNCTION CP_REMIT_ADD_4_P RETURN VARCHAR2;
212 
213   FUNCTION CP_REMIT_CITY_P RETURN VARCHAR2;
214 
215   FUNCTION CP_REMIT_COUNTRY_P RETURN VARCHAR2;
216 
217   FUNCTION CP_1_P RETURN NUMBER;
218 
219   FUNCTION CP_REMIT_POSTAL_CODE_P RETURN VARCHAR2;
220 
221   FUNCTION FUNC_CURRENCY_P RETURN VARCHAR2;
222 
223   FUNCTION ORDERBY_ACCT_P RETURN VARCHAR2;
224 
225   FUNCTION PRECISION_P RETURN NUMBER;
226 
227   FUNCTION SELECT_ALL_P RETURN VARCHAR2;
228 
229   FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
230 
231   FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
232 
233   FUNCTION WHERE_FLEX_P RETURN VARCHAR2;
234 
235   FUNCTION PRINT_TYPE_P RETURN VARCHAR2;
236 
237   FUNCTION TRX_NUMBER_LOW_P RETURN VARCHAR2;
238 
239   FUNCTION TRX_NUMBER_HIGH_P RETURN VARCHAR2;
240 
241   FUNCTION COMP_NUMBER_P RETURN VARCHAR2;
242 
243   FUNCTION VAT_REGISTRATION_NUM_P RETURN VARCHAR2;
244 
245   PROCEDURE JG_GET_PERIOD_DATES(APP_ID IN NUMBER
246                                ,TSET_OF_BOOKS_ID IN NUMBER
247                                ,TPERIOD_NAME IN VARCHAR2
248                                ,TSTART_DATE OUT NOCOPY DATE
249                                ,TEND_DATE OUT NOCOPY DATE
250                                ,ERRBUF OUT NOCOPY VARCHAR2);
251 
252   PROCEDURE JG_GET_SET_OF_BOOKS_INFO(SOBID IN NUMBER
253                                     ,COAID OUT NOCOPY NUMBER
254                                     ,SOBNAME OUT NOCOPY VARCHAR2
255                                     ,FUNC_CURR OUT NOCOPY VARCHAR2
256                                     ,ERRBUF OUT NOCOPY VARCHAR2);
257 
258   PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
259                                   ,TYPE_ID IN NUMBER
260                                   ,NAME OUT NOCOPY VARCHAR2
261                                   ,ERRBUF OUT NOCOPY VARCHAR2);
262 
263   PROCEDURE JG_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
264                                ,CODE IN VARCHAR2
265                                ,TYPE IN VARCHAR2
266                                ,VALUE OUT NOCOPY VARCHAR2
267                                ,ERRBUF OUT NOCOPY VARCHAR2);
268 
269   PROCEDURE JG_GET_FIRST_PERIOD(APP_ID IN NUMBER
270                                ,TSET_OF_BOOKS_ID IN NUMBER
271                                ,TPERIOD_NAME IN VARCHAR2
272                                ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
273                                ,ERRBUF OUT NOCOPY VARCHAR2);
274 
275   PROCEDURE JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID IN NUMBER
276                                           ,TSET_OF_BOOKS_ID IN NUMBER
277                                           ,TPERIOD_NAME IN VARCHAR2
278                                           ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
279                                           ,ERRBUF OUT NOCOPY VARCHAR2);
280 
281   PROCEDURE JG_GET_CONSOLIDATION_INFO(CONS_ID IN NUMBER
282                                      ,CONS_NAME OUT NOCOPY VARCHAR2
283                                      ,METHOD OUT NOCOPY VARCHAR2
284                                      ,CURR_CODE OUT NOCOPY VARCHAR2
285                                      ,FROM_SOBID OUT NOCOPY NUMBER
286                                      ,TO_SOBID OUT NOCOPY NUMBER
287                                      ,DESCRIPTION OUT NOCOPY VARCHAR2
288                                      ,START_DATE OUT NOCOPY DATE
289                                      ,END_DATE OUT NOCOPY DATE
290                                      ,ERRBUF OUT NOCOPY VARCHAR2);
291 
292 END JG_JGZZARIN_XMLP_PKG;
293 
294