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_OEXOEORS_XMLP_PKG

Source


1 PACKAGE ONT_OEXOEORS_XMLP_PKG AS
2 /* $Header: OEXOEORSS.pls 120.2 2008/05/05 12:42:31 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_SOB_ID NUMBER;
6   --added as fix
7   P_RETURN_DATE_LOW_V varchar2(40);
8   P_RETURN_DATE_HIGH_V varchar2(40);
9   P_EXP_REC_DATE_LOW_V varchar2(40);
10   P_EXP_REC_DATE_HIGH_V varchar2(40);
11 
12   P_EXP_REC_DATE_LOW DATE;
13 
14   P_EXP_REC_DATE_HIGH DATE;
15 
16   P_RETURN_TYPE VARCHAR2(30);
17 
18   P_ORDER_BY VARCHAR2(30);
19 
20   P_RETURN_NUM_LOW VARCHAR2(32767);
21 
22   P_RETURN_NUM_HIGH VARCHAR2(32767);
23 
24   P_CUSTOMER_NAME_LOW VARCHAR2(360);
25 
26   P_CUSTOMER_NUMBER_LOW VARCHAR2(50);
27 
28   P_ITEM_FLEX_CODE VARCHAR2(32767);
29 
30   P_ORGANIZATION_ID VARCHAR2(32767);
31 --added as fix
32   P_ORGANIZATION_ID_V  VARCHAR2(32767);
33   P_RETURN_DAYS_HIGH NUMBER;
34 
35   P_RETURN_DAYS_LOW NUMBER;
36 
37   P_OPEN_RETURNS_ONLY VARCHAR2(50);
38 
39   P_PRINT_DESCRIPTION VARCHAR2(50);
40 
41   P_REC_DAYS_LOW NUMBER;
42 
43   P_REC_DAYS_HIGH NUMBER;
44 
45   P_RETURN_DATE_LOW DATE;
46 
47   P_RETURN_DATE_HIGH DATE;
48 
49   P_WAREHOUSE VARCHAR2(60);
50 
51   P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
52 
53   --LP_OPEN_RETURNS_ONLY VARCHAR2(500);
54   LP_OPEN_RETURNS_ONLY VARCHAR2(500):=' ';
55 
56   --LP_REC_DAYS VARCHAR2(500);
57   LP_REC_DAYS VARCHAR2(500):= ' ';
58 
59   --LP_RETURN_DAYS VARCHAR2(500);
60   LP_RETURN_DAYS VARCHAR2(500):= ' ';
61 
62   --LP_RETURN_DATE VARCHAR2(500);
63   LP_RETURN_DATE VARCHAR2(500):=' ';
64 
65   --LP_EXP_REC_DATE VARCHAR2(500);
66   LP_EXP_REC_DATE VARCHAR2(500):=' ';
67 
68   --LP_RETURN_NUM VARCHAR2(500);
69   LP_RETURN_NUM VARCHAR2(500):= ' ';
70 
71   --LP_RETURN_TYPE VARCHAR2(500);
72   LP_RETURN_TYPE VARCHAR2(500):=' ';
73 
74   --LP_WAREHOUSE VARCHAR2(500);
75   LP_WAREHOUSE VARCHAR2(500):=' ';
76 
77   --LP_CUSTOMER_NUMBER VARCHAR2(500);
78   LP_CUSTOMER_NUMBER VARCHAR2(500):=' ';
79 
80   --LP_CUSTOMER_NAME VARCHAR2(500);
81   LP_CUSTOMER_NAME VARCHAR2(500):=' ';
82 
83   P_ITEM_STRUCTURE_NUM NUMBER;
84 
85   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
86 
87   P_CUSTOMER_NUMBER_HIGH VARCHAR2(50);
88 
89   P_RETURN_LINE_TYPE VARCHAR2(30);
90 
91   P_LINE_CATEGORY VARCHAR2(30);
92 
93   --LP_RETURN_LINE_TYPE VARCHAR2(500);
94   LP_RETURN_LINE_TYPE VARCHAR2(500):=' ';
95 
96   --LP_LINE_CATEGORY VARCHAR2(500);
97   LP_LINE_CATEGORY VARCHAR2(500):= ' ';
98 
99   P_ENABLE_TRACE VARCHAR2(5);
100 
101   L_ORDER_TYPE VARCHAR2(30);
102 
103   L_LINE_TYPE VARCHAR2(30);
104 
105   RP_DUMMY_ITEM VARCHAR2(2000);
106 
107   C_AUTHORIZED_AMOUNT NUMBER;
108 
109   RP_REPORT_NAME VARCHAR2(240);
110 
111   RP_SUB_TITLE VARCHAR2(80);
112 
113   RP_COMPANY_NAME VARCHAR2(50);
114 
115   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
116 
117   RP_DATA_FOUND VARCHAR2(300);
118 
119   RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
120 
121   RP_PRINT_DESCRIPTION VARCHAR2(80);
122 
123   RP_RETURN_NUMBER_RANGE VARCHAR2(100);
124 
125   RP_EXP_REC_DATE_RANGE VARCHAR2(100);
126 
127   RP_RETURN_DATE_RANGE VARCHAR2(100);
128 
129   RP_OPEN_RETURNS_ONLY VARCHAR2(80);
130 
131   RP_USE_FUNCTIONAL_CURRENCY VARCHAR2(80);
132 
133   RP_CUST_NAME_RANGE VARCHAR2(60);
134 
135   RP_CUST_NO_RANGE VARCHAR2(60);
136 
137   FUNCTION AFTERREPORT RETURN BOOLEAN;
138 
139   FUNCTION P_ORGANIZATION_IDVALIDTRIGGER RETURN BOOLEAN;
140 
141   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
142 
143   FUNCTION P_SOB_IDVALIDTRIGGER RETURN BOOLEAN;
144 
145   FUNCTION P_USE_FUNCTIONAL_CURRENCYVALID RETURN BOOLEAN;
146 
147   FUNCTION C_ACTUAL_RECEIPT_DAYS(QTY_AUTHORIZED IN NUMBER
148                                 ,RECEIPT_DAYS IN NUMBER) RETURN NUMBER;
149 
150   FUNCTION C_ACTUAL_RETURN_DAYS(QTY_AUTHORIZED IN NUMBER
151                                ,RETURN_DAYS IN NUMBER) RETURN NUMBER;
152 
153   FUNCTION AFTERPFORM RETURN BOOLEAN;
154 
155   FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY2 IN VARCHAR2) RETURN NUMBER;
156 
157   FUNCTION C_ORDER_COUNTFORMULA RETURN NUMBER;
158 
159   FUNCTION RP_ORDER_BYFORMULA RETURN VARCHAR2;
160 
161   FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER;
162 
163   FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
164 
165    FUNCTION C_AUTHORIZED_AMOUNT_P(currency2 varchar2,authorized_amount number,conversion_type_code varchar2,return_date date,conversion_rate number) RETURN NUMBER;
166 
167 
168   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
169 
170   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
171 
172   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
173 
174   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
175 
176   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
177 
178   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
179 
180   FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
181 
182   FUNCTION RP_RETURN_NUMBER_RANGE_P RETURN VARCHAR2;
183 
184   FUNCTION RP_EXP_REC_DATE_RANGE_P RETURN VARCHAR2;
185 
186   FUNCTION RP_RETURN_DATE_RANGE_P RETURN VARCHAR2;
187 
188   FUNCTION RP_OPEN_RETURNS_ONLY_P RETURN VARCHAR2;
189 
190   FUNCTION RP_USE_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
191 
192   FUNCTION RP_CUST_NAME_RANGE_P RETURN VARCHAR2;
193 
194   FUNCTION RP_CUST_NO_RANGE_P RETURN VARCHAR2;
195 
196   FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
197                         ,X_TO_CURRENCY IN VARCHAR2
198                         ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
199 
200   PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
201                         ,X_TO_CURRENCY IN VARCHAR2
202                         ,X_EFFECTIVE_DATE IN DATE
203                         ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
204                         ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
205 
206   FUNCTION GET_EURO_CODE RETURN VARCHAR2;
207 
208   FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
209                    ,X_TO_CURRENCY IN VARCHAR2
210                    ,X_CONVERSION_DATE IN DATE
211                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
212 
213   FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
214                    ,X_FROM_CURRENCY IN VARCHAR2
215                    ,X_CONVERSION_DATE IN DATE
216                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
217 
218   FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
219                          ,X_TO_CURRENCY IN VARCHAR2
220                          ,X_CONVERSION_DATE IN DATE
221                          ,X_CONVERSION_TYPE IN VARCHAR2
222                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
223 
224   FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
225                          ,X_FROM_CURRENCY IN VARCHAR2
226                          ,X_CONVERSION_DATE IN DATE
227                          ,X_CONVERSION_TYPE IN VARCHAR2
228                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
229 
230   FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
231                           ,PERIOD IN VARCHAR2
232                           ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
233 
234 function BeforeReport return boolean;
235 
236 FUNCTION ITEM_DSPFORMULA(ITEM_IDENTIFIER_TYPE IN VARCHAR2,INVENTORY_ITEM_ID1 IN NUMBER,ORDERED_ITEM_ID IN NUMBER,ORDERED_ITEM IN VARCHAR2,C_ORGANIZATION_ID IN VARCHAR2,C_INVENTORY_ITEM_ID IN VARCHAR2)  return Char ;
237 
238 END ONT_OEXOEORS_XMLP_PKG;
239