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.XTR_XTRHOAPR_XMLP_PKG

Source


1 PACKAGE XTR_XTRHOAPR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRHOAPRS.pls 120.1 2007/12/28 12:49:17 npannamp noship $ */
3   AR_WHERE_CLAUSE VARCHAR2(1000);
4 
5   AR_SOURCE_NAME VARCHAR2(80);
6 
7   AP_WHERE_CLAUSE VARCHAR2(1000);
8 
9   AP_SOURCE_NAME VARCHAR2(80);
10 
11   P_DISCOUNT_METHOD VARCHAR2(32767);
12 
13   P_SEARCH_BY VARCHAR2(80);
14 
15   AP_ORDER_CLAUSE VARCHAR2(80);
16 
17   AP_FROM_CLAUSE VARCHAR2(80);
18 
19   AR_FROM_CLAUSE VARCHAR2(80);
20 
21   P_CRITERIA_SET VARCHAR2(80);
22   P_CRITERIA_SET_V VARCHAR2(80);
23 
24   P_CRITERIA_SET_OWNER VARCHAR2(80);
25 
26   P_REF_DATE DATE;
27 
28   P_CURRENCY VARCHAR2(32767);
29 
30   P_FACTOR VARCHAR2(32767);
31 
32   P_COMPANY_CODE VARCHAR2(80);
33 
34   P_SHOW_TRANSACTIONS VARCHAR2(32767);
35 
36   DSP_SEARCH_BY VARCHAR2(80);
37 
38   P_SOURCE VARCHAR2(80);
39 
40   DSP_SOURCE VARCHAR2(80);
41 
42   DSP_COMPANY_NAME VARCHAR2(80);
43 
44   P_SOB_CURRENCY VARCHAR2(32767);
45 
46   DSP_DISCOUNT_METHOD VARCHAR2(80);
47 
48   P_DATE_FROM DATE;
49   P_DATE_FROM_v DATE;
50 
51   P_DATE_TO DATE;
52   P_DATE_TO_v DATE;
53 
54   P_UNAPLD_PREPAYMENTS VARCHAR2(80);
55 
56   DSP_UNAPLD_PREPAYMENTS VARCHAR2(80);
57 
58   P_UNAPLD_RECEIPTS VARCHAR2(80);
59 
60   DSP_UNAPLD_RECEIPTS VARCHAR2(80);
61 
62   DSP_SHOW_TRANSACTIONS VARCHAR2(80);
63 
64   P_UNIT NUMBER;
65 
66   DSP_FACTOR VARCHAR2(32767);
67 
68   P_CONC_REQUEST_ID NUMBER;
69 
70   P_REPORT_NAME VARCHAR2(240);
71 
72   Z_SEARCH_BY VARCHAR2(300);
73 
74   Z_DUE_DATE_FROM VARCHAR2(300);
75 
76   Z_DUE_DATE_TO VARCHAR2(300);
77 
78   Z_UNAPPLIED_PREPAYMENTS VARCHAR2(300);
79 
80   Z_UNAPPLIED_RECEIPTS VARCHAR2(300);
81 
82   Z_SHOW_TRANSACTIONS VARCHAR2(300);
83 
84   Z_PARAMETERS VARCHAR2(300);
85 
86   Z_CRITERIA_SET VARCHAR2(300);
87 
88   Z_BASIC_SEARCH_CRITERIA VARCHAR2(300);
89 
90   Z_SOURCE VARCHAR2(300);
91 
92   Z_CURRENCY VARCHAR2(300);
93 
94   Z_COMPANY VARCHAR2(300);
95 
96   Z_SOB_CURRENCY VARCHAR2(300);
97 
98   Z_AP_DISCOUNT VARCHAR2(300);
99 
100   Z_FACTOR VARCHAR2(300);
101 
102   Z_ADVANCED_SEARCH_CRITERIA VARCHAR2(300);
103 
104   Z_OUTSTANDING_AMOUNT VARCHAR2(300);
105 
106   Z_ACTUAL_OPEN_POSITION_SUM VARCHAR2(300);
107 
108   Z_HEDGE_NUMBER VARCHAR2(300);
109 
110   Z_DEAL_NUMBER VARCHAR2(300);
111 
112   Z_OFFSET VARCHAR2(300);
113 
114   Z_DAYS VARCHAR2(300);
115 
116   Z_REMAINING VARCHAR2(300);
117 
118   Z_REPORT_DATE VARCHAR2(300);
119 
120   Z_AS_OF_DATE VARCHAR2(300);
121 
122   Z_SUMMARY_POSITION VARCHAR2(300);
123 
124   Z_NET_POSITION VARCHAR2(300);
125 
126   Z_ACTUAL_HEDGE_POSITION VARCHAR2(300);
127 
128   Z_UNDER_APPLIED VARCHAR2(300);
129 
130   Z_OPEN_ARAP_HEDGE_POSITION VARCHAR2(300);
131 
132   Z_PAGE VARCHAR2(300);
133 
134   Z_RECEIVABLES VARCHAR2(300);
135 
136   Z_END_OF_REPORT VARCHAR2(300);
137 
138   Z_CUSTOMER VARCHAR2(300);
139 
140   Z_TRANS_AMOUNT VARCHAR2(300);
141 
142   Z_TRANS_NUMBER VARCHAR2(300);
143 
144   Z_DUE_DATE VARCHAR2(300);
145 
146   Z_TRANS_DATE VARCHAR2(300);
147 
148   Z_OPERATING_UNIT VARCHAR2(300);
149 
150   Z_TRANS_TYPE VARCHAR2(300);
151 
152   Z_TOTAL VARCHAR2(300);
153 
154   Z_PAYABLES VARCHAR2(300);
155 
156   Z_INVOICE_TYPE VARCHAR2(300);
157 
158   Z_SUPPLIER VARCHAR2(300);
159 
160   Z_INVOICE_DATE VARCHAR2(300);
161 
162   Z_INVOICE_NUMBER VARCHAR2(300);
163 
164   Z_INVOICE_AMOUNT VARCHAR2(300);
165 
166   Z_NO_DATA_FOUND VARCHAR2(300);
167 
168   Z_ACTUAL_HEDGE_POSITION_SUM VARCHAR2(300);
169 
170   Z_OVER_APPLIED VARCHAR2(300);
171 
172   P_DUMMY1 VARCHAR2(32767);
173 
174   P_DUMMY2 VARCHAR2(32767);
175 
176   P_DUMMY3 VARCHAR2(32767);
177 
178   P_DUMMY4 VARCHAR2(32767);
179 
180   Z_EVEN VARCHAR2(300);
181 
182   DSP_CRITERIA_SET VARCHAR2(80);
183 
184   FUNCTION AFTERPFORM RETURN BOOLEAN;
185 
186   FUNCTION CF_NET_POSITIONFORMULA(SUMSUMAMOUNTPERRPT IN NUMBER
187                                  ,SUMHPAMOUNTPERRPT IN NUMBER) RETURN NUMBER;
188 
189   FUNCTION AMOUNT_DSPFORMULA(AMOUNT IN NUMBER
190                             ,AMOUNT_DSP IN VARCHAR2) RETURN CHAR;
191 
192   FUNCTION SUMAMOUNTPERAR_SRC_DSPFORMULA(SUMAMOUNTPERAR_SRC IN NUMBER
193                                         ,SUMAMOUNTPERAR_SRC_DSP IN VARCHAR2) RETURN CHAR;
194 
195   FUNCTION SUMAMOUNTPERAP_SRC_DSPFORMULA(SUMAMOUNTPERAP_SRC IN NUMBER
196                                         ,SUMAMOUNTPERAP_SRC_DSP IN VARCHAR2) RETURN CHAR;
197 
198   FUNCTION AMOUNT1_DSPFORMULA(AMOUNT1 IN NUMBER
199                              ,AMOUNT1_DSP IN VARCHAR2) RETURN CHAR;
200 
201   FUNCTION SUM_AMOUNT_DSPFORMULA(SUM_AMOUNT IN NUMBER
202                                 ,SUM_AMOUNT_DSP IN VARCHAR2) RETURN CHAR;
203 
204   FUNCTION HP_AMOUNT_DSPFORMULA(HP_AMOUNT IN NUMBER
205                                ,HP_AMOUNT_DSP IN VARCHAR2) RETURN CHAR;
206 
207   FUNCTION SUMSUMAMOUNTPERRPT_DSPFORMULA(SUMSUMAMOUNTPERRPT IN NUMBER
208                                         ,SUMSUMAMOUNTPERRPT_DSP IN VARCHAR2) RETURN CHAR;
209 
210   FUNCTION SUMHPAMOUNTPERRPT_DSPFORMULA(SUMHPAMOUNTPERRPT IN NUMBER
211                                        ,SUMHPAMOUNTPERRPT_DSP IN VARCHAR2) RETURN CHAR;
212 
213   FUNCTION CF_NET_POSITION_DSPFORMULA(CF_NET_POSITION IN NUMBER
214                                      ,CF_NET_POSITION_DSP IN VARCHAR2) RETURN CHAR;
215 
216   FUNCTION BEFOREREPORT RETURN BOOLEAN;
217 
218   FUNCTION AFTERREPORT RETURN BOOLEAN;
219 
220   FUNCTION CF_FROM_VALUE_DSPFORMULA(CRITERIA_CODE IN VARCHAR2
221                                    ,FROM_VALUE IN VARCHAR2) RETURN CHAR;
222   PROCEDURE FORMAT_AMOUNT_FIELD(p_amt_field VARCHAR2);
223   PROCEDURE FORMAT_AMOUNT_FIELD_LARGE(p_amt_field VARCHAR2);
224 
225 END XTR_XTRHOAPR_XMLP_PKG;
226