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_OEXOEOCS_XMLP_PKG

Source


1 PACKAGE ONT_OEXOEOCS_XMLP_PKG AS
2 /* $Header: OEXOEOCSS.pls 120.2 2008/05/05 12:38:41 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6 
7   P_ORDER_BY VARCHAR2(30);
8 
9   P_ORDER_NUM_LOW VARCHAR2(32767);
10 
11   P_ORDER_NUM_HIGH VARCHAR2(32767);
12 
13   P_CUSTOMER_NAME_LOW VARCHAR2(360);
14 
15   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
16 
17   P_ITEM_FLEX_CODE VARCHAR2(32767);
18 
19   P_ORGANIZATION_ID NUMBER;
20 
21   P_ORGANIZATION_ID1 NUMBER;
22 
23   P_SALESREP_LOW VARCHAR2(240);
24 
25   P_SALESREP_HIGH VARCHAR2(240);
26 
27   P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
28 
29   LP_ITEM_FLEX_CODE_HIGH VARCHAR2(600);
30 
31   LP_ITEM_FLEX_CODE_LOW VARCHAR2(600);
32 
33   LP_ORDER_NUM VARCHAR2(200);
34 
35   LP_SALESREP VARCHAR2(240);
36 
37   LP_CUSTOMER_NAME VARCHAR2(200);
38 
39   P_PRINT_DESCRIPTION VARCHAR2(32767);
40 
41   P_MIXED_PRECISION NUMBER;
42 
43   LP_ITEM_FLEX_ALL_SEG VARCHAR2(1000);
44 
45   P_ITEM NUMBER;
46 
47   P_ITEM_STRUCTURE_NUM NUMBER;
48 
49   LP_ORDER_DATE VARCHAR2(1000);
50 
51   P_ORDER_DATE_HIGH DATE;
52 
53   P_ORDER_DATE_LOW DATE;
54 
55   P_ORDER_DATE_HIGH1 VARCHAR2(30);
56 
57   P_ORDER_DATE_LOW1 VARCHAR2(30);
58 
59   P_ORDER_CATEGORY VARCHAR2(30);
60 
61   LP_ORDER_CATEGORY VARCHAR2(500);
62 
63   LP_LINE_CATEGORY VARCHAR2(500);
64 
65   P_LINE_CATEGORY VARCHAR2(30);
66 
67   P_ITEM_NAME VARCHAR2(200);
68 
69   RP_DUMMY_ITEM VARCHAR2(2002);
70 
71   RP_REPORT_NAME VARCHAR2(240);
72 
73   RP_SUB_TITLE VARCHAR2(80);
74 
75   RP_COMPANY_NAME VARCHAR2(100);
76 
77   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
78 
79   RP_DATA_FOUND VARCHAR2(300);
80 
81   RP_ITEM_FLEX_LPROMPT VARCHAR2(100);
82 
83   RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'SI.SEGMENT1';
84 
85   RP_ITEM_FLEX_APROMPT VARCHAR2(100);
86 
87   RP_CUSTOMER_RANGE VARCHAR2(42);
88 
89   RP_SALESPERSON_RANGE VARCHAR2(42);
90 
91   RP_ORDER_RANGE VARCHAR2(82);
92 
93   RP_ORDER_BY VARCHAR2(80);
94 
95   RP_USE_FUNCTIONAL_CURRENCY VARCHAR2(80);
96 
97   RP_FLEX_OR_DESC VARCHAR2(80);
98 
99   RP_ITEM_FLEX_ALL_SEG_WHERE VARCHAR2(1000);
100 
101   RP_ORDER_DATE_RANGE VARCHAR2(47);
102 
103   CP_UNIT3 VARCHAR2(20);
104 
105   CP_UNIT4 VARCHAR2(20);
106 
107   FUNCTION BEFOREREPORT RETURN BOOLEAN;
108 
109   FUNCTION AFTERREPORT RETURN BOOLEAN;
110 
111   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
112 
113   FUNCTION P_USE_FUNCTIONAL_CURRENCYVALID RETURN BOOLEAN;
114 
115   FUNCTION AFTERPFORM RETURN BOOLEAN;
116 
117   FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
118 
119   FUNCTION ITEM_DSPFORMULA (item_identifier_type in varchar2, IID number, ORDERED_ITEM_ID number, ORDERED_ITEM varchar2,C_ORGANIZATION_ID in varchar2,C_INVENTORY_ITEM_ID in varchar2) RETURN CHAR;
120 
121 
122   FUNCTION C_GL_CONV_RATEFORMULA(CURRENCY2 IN VARCHAR2
123                                 ,ORD_DATE IN DATE
124                                 ,CONVERSION_TYPE_CODE IN VARCHAR2
125                                 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
126 
127   FUNCTION C_AMOUNTFORMULA(AMOUNT IN NUMBER
128                           ,C_GL_CONV_RATE IN NUMBER
129                           ,C_PRECISION IN NUMBER) RETURN NUMBER;
130 
131   FUNCTION C_CURRENCY_CODEFORMULA(CURRENCY2 IN VARCHAR2) RETURN VARCHAR2;
132 
133   FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
134 
135   FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
136 
137   FUNCTION CF_UNIT4FORMULA(UNIT2 IN VARCHAR2) RETURN CHAR;
138 
139   FUNCTION CF_UNIT3FORMULA(UNIT1 IN VARCHAR2) RETURN CHAR;
140 
141   --FUNCTION C_PRECISIONFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
142   FUNCTION C_PRECISIONFORMULA(P_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
143 
144   FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
145 
146   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
147 
148   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
149 
150   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
151 
152   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
153 
154   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
155 
156   FUNCTION RP_ITEM_FLEX_LPROMPT_P RETURN VARCHAR2;
157 
158   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
159 
160   FUNCTION RP_ITEM_FLEX_APROMPT_P RETURN VARCHAR2;
161 
162   FUNCTION RP_CUSTOMER_RANGE_P RETURN VARCHAR2;
163 
164   FUNCTION RP_SALESPERSON_RANGE_P RETURN VARCHAR2;
165 
166   FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
167 
168   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
169 
170   FUNCTION RP_USE_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
171 
172   FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
173 
174   FUNCTION RP_ITEM_FLEX_ALL_SEG_WHERE_P RETURN VARCHAR2;
175 
176   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
177 
178   FUNCTION CP_UNIT3_P RETURN VARCHAR2;
179 
180   FUNCTION CP_UNIT4_P RETURN VARCHAR2;
181 
182   FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
183                         ,X_TO_CURRENCY IN VARCHAR2
184                         ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
185 
186   PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
187                         ,X_TO_CURRENCY IN VARCHAR2
188                         ,X_EFFECTIVE_DATE IN DATE
189                         ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
190                         ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
191 
192   FUNCTION GET_EURO_CODE RETURN VARCHAR2;
193 
194   FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
195                    ,X_TO_CURRENCY IN VARCHAR2
196                    ,X_CONVERSION_DATE IN DATE
197                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
198 
199   FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
200                    ,X_FROM_CURRENCY IN VARCHAR2
201                    ,X_CONVERSION_DATE IN DATE
202                    ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
203 
204   FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
205                          ,X_TO_CURRENCY IN VARCHAR2
206                          ,X_CONVERSION_DATE IN DATE
207                          ,X_CONVERSION_TYPE IN VARCHAR2
208                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
209 
210   FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
211                          ,X_FROM_CURRENCY IN VARCHAR2
212                          ,X_CONVERSION_DATE IN DATE
213                          ,X_CONVERSION_TYPE IN VARCHAR2
214                          ,X_AMOUNT IN NUMBER) RETURN NUMBER;
215 
216   FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
217                           ,PERIOD IN VARCHAR2
218                           ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
219 
220 END ONT_OEXOEOCS_XMLP_PKG;
221