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_OEXOEOCR_XMLP_PKG

Source


1 PACKAGE ONT_OEXOEOCR_XMLP_PKG AS
2 /* $Header: OEXOEOCRS.pls 120.3 2008/05/05 09:06:37 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6 
7   P_CANCELLED_BY_HIGH VARCHAR2(50);
8 
9   P_CANCEL_REASON VARCHAR2(50);
10 
11   P_ORDER_BY VARCHAR2(30);
12 
13   LP_ORDER_BY varchar2(30);
14 
15   P_ORDER_NUM_LOW VARCHAR2(32767);
16 
17   P_ORDER_NUM_HIGH VARCHAR2(32767);
18 
19   P_CUSTOMER_NAME_LOW VARCHAR2(360);
20 
21   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
22 
23   P_ITEM_FLEX_CODE VARCHAR2(32767);
24 
25   P_ORGANIZATION_ID NUMBER;
26 
27   P_CANCEL_DATE_LOW DATE;
28 
29   LP_CANCEL_DATE_LOW VARCHAR2(20);
30 
31   P_CANCEL_DATE_HIGH DATE;
32 
33   LP_CANCEL_DATE_HIGH VARCHAR2(20);
34 
35   P_SALESREP_LOW VARCHAR2(240);
36 
37   P_SALESREP_HIGH VARCHAR2(240);
38 
39   P_USE_FUNCTIONAL_CURRENCY VARCHAR2(5);
40 
41   LP_ITEM_FLEX_CODE_HIGH VARCHAR2(600);
42 
43   LP_ITEM_FLEX_CODE_LOW VARCHAR2(600);
44 
45   LP_ORDER_NUM VARCHAR2(200);
46 
47   LP_SALESREP VARCHAR2(240);
48 
49   LP_CANCEL_DATE VARCHAR2(500);
50 
51   LP_CUSTOMER_NAME VARCHAR2(200);
52 
53   P_PRINT_DESCRIPTION VARCHAR2(32767);
54 
55   LP_CANCELLED_BY VARCHAR2(1000);
56 
57   LP_CANCEL_REASON VARCHAR2(500);
58 
59   P_MIXED_PRECISION NUMBER;
60 
61   LP_ITEM_FLEX_ALL_SEG VARCHAR2(1000);
62 
63   P_ITEM NUMBER;
64 
65   P_ITEM_STRUCTURE_NUM NUMBER;
66 
67   LP_ORDER_CATEGORY VARCHAR2(500);
68 
69   P_ORDER_TYPE VARCHAR2(30);
70 
71   LP_ORDER_DATE VARCHAR2(500);
72 
73   P_CANCELLED_BY_LOW VARCHAR2(50);
74 
75   P_ORDER_DATE_HIGH DATE;
76 
77   LP_ORDER_DATE_HIGH  VARCHAR2(20);
78 
79   P_ORDER_DATE_LOW DATE;
80 
81   LP_ORDER_DATE_LOW VARCHAR2(20);
82 
83   P_ORDER_CATEGORY VARCHAR2(32767);
84 
85   LP_LINE_CATEGORY VARCHAR2(500);
86 
87   P_LINE_CATEGORY VARCHAR2(30);
88 
89   P_ITEM_NAME VARCHAR2(200);
90 
91   RP_REPORT_NAME VARCHAR2(240);
92 
93   RP_SUB_TITLE VARCHAR2(80);
94 
95   RP_COMPANY_NAME VARCHAR2(100);
96 
97   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
98 
99   RP_DATA_FOUND VARCHAR2(300);
100 
101   RP_ITEM_FLEX_LPROMPT VARCHAR2(100);
102 
103   RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'SI.SEGMENT1';
104 
105   RP_ITEM_FLEX_APROMPT VARCHAR2(100);
106 
107   RP_SALES_REASON_LBL VARCHAR2(15);
108 
109   RP_CUSTOMER_RANGE VARCHAR2(42);
110 
111   RP_SALESPERSON_RANGE VARCHAR2(42);
112 
113   RP_ORDER_RANGE VARCHAR2(82);
114 
115   RP_CANCEL_DATE_RANGE VARCHAR2(47);
116 
117   RP_SALES_REASON_LBL_2 VARCHAR2(16);
118 
119   RP_ORDER_BY VARCHAR2(80);
120 
121   RP_CANCEL_REASON VARCHAR2(80);
122 
123   RP_USE_FUNCTIONAL_CURRENCY VARCHAR2(80);
124 
125   RP_FLEX_OR_DESC VARCHAR2(80);
126 
127   RP_ITEM_FLEX_ALL_SEG_WHERE VARCHAR2(1000);
128 
129   RP_ORDER_DATE_RANGE VARCHAR2(47);
130 
131   RP_CANCELLED_BY_RANGE VARCHAR2(42);
132 
133   RP_DATE_LBL VARCHAR2(20);
134 
135   CP_UNIT1 VARCHAR2(20);
136 
137   CP_UNIT2 VARCHAR2(20);
138 
139   RP_DUMMY_ITEM NUMBER;
140 
141   FUNCTION BEFOREREPORT RETURN BOOLEAN;
142 
143   FUNCTION AFTERREPORT RETURN BOOLEAN;
144 
145   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
146 
147   FUNCTION P_USE_FUNCTIONAL_CURRENCYVALID RETURN BOOLEAN;
148 
149   FUNCTION AFTERPFORM RETURN BOOLEAN;
150 
151   FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
152 
153   FUNCTION C_GL_CONV_RATEFORMULA(CURRENCY_CODE IN VARCHAR2
154                                 ,ORD_DATE IN DATE
155                                 ,CONVERSION_TYPE_CODE IN VARCHAR2
156                                 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
157 
158   FUNCTION C_AMOUNTFORMULA(CALC_AMOUNT IN NUMBER
159                           ,C_GL_CONV_RATE IN NUMBER
160                           ,C_PRECISION IN NUMBER) RETURN NUMBER;
161 
162   FUNCTION C_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
163 
164   FUNCTION PR_ORDER_CATEGORYFORMULA RETURN CHAR;
165 
166   FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
167 
168   FUNCTION CF_UNIT1FORMULA(UNIT1 IN VARCHAR2) RETURN CHAR;
169 
170   FUNCTION CF_UNIT2FORMULA(UNIT2 IN VARCHAR2) RETURN CHAR;
171 
172   FUNCTION C_CANCELLED_QTYFORMULA(LINEID IN NUMBER
173                                  ,CANCELLED_QTY IN NUMBER) RETURN NUMBER;
174 
175   FUNCTION CALC_AMOUNTFORMULA(LINEID IN NUMBER
176                              ,CANCELLED_QTY IN NUMBER) RETURN NUMBER;
177 
178   FUNCTION C_PRECISIONFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
179 
180   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
181 
182   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
183 
184   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
185 
186   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
187 
188   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
189 
190   FUNCTION RP_ITEM_FLEX_LPROMPT_P RETURN VARCHAR2;
191 
192   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
193 
194   FUNCTION RP_ITEM_FLEX_APROMPT_P RETURN VARCHAR2;
195 
196   FUNCTION RP_SALES_REASON_LBL_P RETURN VARCHAR2;
197 
198   FUNCTION RP_CUSTOMER_RANGE_P RETURN VARCHAR2;
199 
200   FUNCTION RP_SALESPERSON_RANGE_P RETURN VARCHAR2;
201 
202   FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
203 
204   FUNCTION RP_CANCEL_DATE_RANGE_P RETURN VARCHAR2;
205 
206   FUNCTION RP_SALES_REASON_LBL_2_P RETURN VARCHAR2;
207 
208   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
209 
210   FUNCTION RP_CANCEL_REASON_P RETURN VARCHAR2;
211 
212   FUNCTION RP_USE_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
213 
214   FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
215 
216   FUNCTION RP_ITEM_FLEX_ALL_SEG_WHERE_P RETURN VARCHAR2;
217 
218   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
219 
220   FUNCTION RP_CANCELLED_BY_RANGE_P RETURN VARCHAR2;
221 
222   FUNCTION RP_DATE_LBL_P RETURN VARCHAR2;
223 
224   FUNCTION CP_UNIT1_P RETURN VARCHAR2;
225 
226   FUNCTION CP_UNIT2_P RETURN VARCHAR2;
227 
228   FUNCTION RP_DUMMY_ITEM_P RETURN NUMBER;
229 
230   FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
231                         ,X_TO_CURRENCY IN VARCHAR2
232                         ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
233 
237                         ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
234   PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
235                         ,X_TO_CURRENCY IN VARCHAR2
236                         ,X_EFFECTIVE_DATE IN DATE
238                         ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
239 
240   FUNCTION GET_EURO_CODE RETURN VARCHAR2;
241 
242   FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
243                    ,X_TO_CURRENCY IN VARCHAR2
244                    ,X_CONVERSION_DATE IN DATE
245                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
246 
247   FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
248                    ,X_FROM_CURRENCY IN VARCHAR2
249                    ,X_CONVERSION_DATE IN DATE
250                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
251 
252   FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
253                          ,X_TO_CURRENCY IN VARCHAR2
254                          ,X_CONVERSION_DATE IN DATE
255                          ,X_CONVERSION_TYPE IN VARCHAR2
256                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
257 
258   FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
259                          ,X_FROM_CURRENCY IN VARCHAR2
260                          ,X_CONVERSION_DATE IN DATE
261                          ,X_CONVERSION_TYPE IN VARCHAR2
262                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
263 
264   FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
265                           ,PERIOD IN VARCHAR2
266                           ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
267 
268   FUNCTION C_AMOUNT_DSPFORMULA RETURN VARCHAR2;
269 
270 FUNCTION ITEM_DSPFORMULA
271 (
272 ITEM_IDENTIFIER_TYPE_T IN VARCHAR2,
273 IID IN NUMBER,
274 SI_ORGANIZATION_ID IN NUMBER,
275 SI_INVENTORY_ITEM_ID IN NUMBER,
276 ORDERED_ITEM_ID IN NUMBER,
277 ORDERED_ITEM IN VARCHAR
278 )
279 RETURN CHAR;
280 
281 END ONT_OEXOEOCR_XMLP_PKG;
282