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

Source


1 PACKAGE ONT_OEXOEOSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEOSRS.pls 120.1 2007/12/25 07:24:01 npannamp noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6   F1 VARCHAR2(100);
7   P_ORDER_TYPE_LOW VARCHAR2(240);
8 
9   P_ORDER_TYPE_HIGH VARCHAR2(240);
10 
11   P_ORDER_BY VARCHAR2(100);
12 
13   P_ORDER_NUM_LOW VARCHAR2(30);
14 
15   P_ORDER_NUM_HIGH VARCHAR2(30);
16 
17   P_CUSTOMER_NAME_LOW VARCHAR2(360);
18 
19   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
20 
21   P_ORG_ID VARCHAR2(32767);
22   P_ORG_ID_V VARCHAR2(32767);
23 
24   P_SALESREP_LOW VARCHAR2(240);
25 
26   P_SALESREP_HIGH VARCHAR2(240);
27 
28   P_OPEN_ORDERS_ONLY VARCHAR2(3);
29 
30   P_COUNTRY_LOW VARCHAR2(240);
31 
32   --LP_COUNTRY VARCHAR2(1000);
33   LP_COUNTRY VARCHAR2(1000):=' ';
34 
35   --LP_SALESREP VARCHAR2(1000);
36   LP_SALESREP VARCHAR2(1000):=' ';
37   --LP_ORDER_NUM VARCHAR2(1000);
38   LP_ORDER_NUM VARCHAR2(1000):=' ';
39 
40   --LP_CUSTOMER_NAME VARCHAR2(1000);
41   LP_CUSTOMER_NAME VARCHAR2(1000):=' ';
42 
43   --LP_ORDER_TYPE VARCHAR2(1000);
44   LP_ORDER_TYPE VARCHAR2(1000):=' ';
45   P_INVOICE_LINE_CONTEXT VARCHAR2(50);
46 
47   --LP_OPEN_ORDERS_ONLY VARCHAR2(240);
48   LP_OPEN_ORDERS_ONLY VARCHAR2(240):=' ';
49 
50   P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
51 
52   P_ORDER_DATE_LOW DATE;
53   P_ORDER_DATE_LOW_V VARCHAR2(240);
54 
55   P_ORDER_DATE_HIGH DATE;
56   P_ORDER_DATE_HIGH_V VARCHAR2(240);
57   P_COUNTRY_HIGH VARCHAR2(240);
58 
59   P_ORDER_STATUS_LOW VARCHAR2(240);
60 
61   P_ORDER_STATUS_HIGH VARCHAR2(240);
62 
63   --LP_ORDER_DATE VARCHAR2(1000);
64   LP_ORDER_DATE VARCHAR2(1000):=' ';
65   --LP_PO_NUM VARCHAR2(1000);
66   LP_PO_NUM VARCHAR2(1000):=' ';
67   LP_ORDER_STATUS VARCHAR2(1000);
68 
69   P_PO_NUM_LOW VARCHAR2(240);
70 
71   P_PO_NUM_HIGH VARCHAR2(240);
72 
73   P_CREATED_BY_LOW VARCHAR2(240);
74 
75   P_CREATED_BY_HIGH VARCHAR2(240);
76 
77   --LP_CREATED_BY VARCHAR2(1000);
78   LP_CREATED_BY VARCHAR2(1000):=' ';
79 
80   --LP_ORDER_SOURCE VARCHAR2(1000);
81   LP_ORDER_SOURCE VARCHAR2(1000):=' ';
82 
83   P_ORDER_SOURCE VARCHAR2(240);
84 
85   P_ENABLE_TRACE VARCHAR2(5);
86 
87   LP_ORDER_SOURCE_NAME VARCHAR2(50);
88 
89   --LP_AGREEMENT VARCHAR2(80);
90   LP_AGREEMENT VARCHAR2(80):=' ';
91 
92   P_AGREEMENT NUMBER;
93 
94   P_ONE_TIME VARCHAR2(32767);
95 
96   L_ORDER_TYPE_LOW VARCHAR2(30);
97 
98   L_ORDER_TYPE_HIGH VARCHAR2(30);
99 
100   RP_REPORT_NAME VARCHAR2(240);
101 
102   RP_SUB_TITLE VARCHAR2(80);
103 
104   RP_COMPANY_NAME VARCHAR2(50);
105 
106   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
107 
108   RP_DATA_FOUND VARCHAR2(300);
109 
110   RP_ORDER_NUMBER_RANGE VARCHAR2(500);
111 
112   RP_SALESREP_RANGE VARCHAR2(500);
113 
114   RP_CUSTOMER_NAME_RANGE VARCHAR2(500);
115 
116   RP_ORDER_TYPE_RANGE VARCHAR2(500);
117 
118   RP_OPEN_ORDERS_ONLY VARCHAR2(80);
119 
120   RP_PO_NUMBER_RANGE VARCHAR2(500);
121 
122   RP_ORDER_DATE_RANGE VARCHAR2(500);
123 
124   RP_ORDER_STATUS_RANGE VARCHAR2(500);
125 
126   RP_COUNTRY_RANGE VARCHAR2(500);
127 
128   RP_CREATED_BY_RANGE VARCHAR2(500);
129 
130   RP_ORDER_BY VARCHAR2(100);
131 
132   RP_AGREEMENT VARCHAR2(100);
133 
134   FUNCTION BEFOREREPORT RETURN BOOLEAN;
135 
136   FUNCTION AFTERREPORT RETURN BOOLEAN;
137 
138   FUNCTION AFTERPFORM RETURN BOOLEAN;
139 
140   FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
141 
142   FUNCTION RP_CURR_LABELFORMULA RETURN VARCHAR2;
143 
144   FUNCTION C_ORDER_COUNTFORMULA RETURN NUMBER;
145 
146   FUNCTION C_LINE_COUNTFORMULA(HEADER_ID1 IN NUMBER) RETURN NUMBER;
147 
148   FUNCTION RP_USE_FUNCTIONAL_CURRENCYFORM RETURN VARCHAR2;
149 
150   FUNCTION C_ORDER_AMOUNTFORMULA(CURRENCY1 IN VARCHAR2
151                                 ,ORDER_AMOUNT IN NUMBER
152                                 ,CONVERSION_TYPE_CODE IN VARCHAR2
153                                 ,ORDER_DATE IN DATE
154                                 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
155 
156   FUNCTION C_LIST_AMOUNTFORMULA(CURRENCY1 IN VARCHAR2
157                                ,LIST_VALUE IN NUMBER
158                                ,CONVERSION_TYPE_CODE IN VARCHAR2
159                                ,ORDER_DATE IN DATE
160                                ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
161 
162   FUNCTION C_SHIPPED_AMOUNTFORMULA(CURRENCY1 IN VARCHAR2
163                                   ,SHIP_VALUE IN NUMBER
164                                   ,CONVERSION_TYPE_CODE IN VARCHAR2
165                                   ,ORDER_DATE IN DATE
166                                   ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
167 
168   FUNCTION CF_1FORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
169 
170   FUNCTION C_CURRENCYFORMULA(CURRENCY1 IN VARCHAR2) RETURN CHAR;
171 
172   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
173 
174   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
175 
176   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
177 
178   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
179 
180   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
181 
182   FUNCTION RP_ORDER_NUMBER_RANGE_P RETURN VARCHAR2;
183 
184   FUNCTION RP_SALESREP_RANGE_P RETURN VARCHAR2;
185 
186   FUNCTION RP_CUSTOMER_NAME_RANGE_P RETURN VARCHAR2;
187 
188   FUNCTION RP_ORDER_TYPE_RANGE_P RETURN VARCHAR2;
189 
190   FUNCTION RP_OPEN_ORDERS_ONLY_P RETURN VARCHAR2;
191 
192   FUNCTION RP_PO_NUMBER_RANGE_P RETURN VARCHAR2;
193 
194   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
195 
196   FUNCTION RP_ORDER_STATUS_RANGE_P RETURN VARCHAR2;
197 
198   FUNCTION RP_COUNTRY_RANGE_P RETURN VARCHAR2;
199 
200   FUNCTION RP_CREATED_BY_RANGE_P RETURN VARCHAR2;
201 
202   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
203 
204   FUNCTION RP_AGREEMENT_P RETURN VARCHAR2;
205 
206   FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
207                         ,X_TO_CURRENCY IN VARCHAR2
208                         ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
209 
210   PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
211                         ,X_TO_CURRENCY IN VARCHAR2
212                         ,X_EFFECTIVE_DATE IN DATE
213                         ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
214                         ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
215 
216   FUNCTION GET_EURO_CODE RETURN VARCHAR2;
217 
218   FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
219                    ,X_TO_CURRENCY IN VARCHAR2
220                    ,X_CONVERSION_DATE IN DATE
221                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
222 
223   FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
224                    ,X_FROM_CURRENCY IN VARCHAR2
225                    ,X_CONVERSION_DATE IN DATE
226                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
227 
228   FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
229                          ,X_TO_CURRENCY IN VARCHAR2
230                          ,X_CONVERSION_DATE IN DATE
231                          ,X_CONVERSION_TYPE IN VARCHAR2
232                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
233 
234   FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
235                          ,X_FROM_CURRENCY IN VARCHAR2
236                          ,X_CONVERSION_DATE IN DATE
237                          ,X_CONVERSION_TYPE IN VARCHAR2
238                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
239 
240   FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
241                           ,PERIOD IN VARCHAR2
242                           ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
243 
244 END ONT_OEXOEOSR_XMLP_PKG;
245 
246