[Home] [Help]
PACKAGE: APPS.ONT_OEXOESOS_XMLP_PKG
Source
1 PACKAGE ONT_OEXOESOS_XMLP_PKG AS
2 /* $Header: OEXOESOSS.pls 120.2 2008/05/05 06:37:25 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER;
4
5 P_SOB_ID NUMBER;
6
7 P_ORDER_TYPE VARCHAR2(30);
8
9 P_AGREEMENT NUMBER;
10
11 P_ORDER_BY VARCHAR2(30);
12
13 P_ORDER_NUM_LOW VARCHAR2(32767);
14
15 P_ORDER_NUM_HIGH VARCHAR2(32767);
16
17 P_CUSTOMER_NAME_LOW VARCHAR2(360);
18
19 P_OPEN_ORDERS_ONLY VARCHAR2(5);
20
21 P_ITEM_FLEX_CODE VARCHAR2(32767);
22
23 P_ORGANIZATION_ID NUMBER;
24
25 P_ORDER_DATE_LOW DATE;
26
27 P_ORDER_DATE_HIGH DATE;
28
29 P_SALESREP_LOW VARCHAR2(50);
30
31 P_CUSTOMER_NUM_LOW VARCHAR2(30);
32
33 P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
34
35 LP_ITEM_FLEX_CODE_HIGH VARCHAR2(600);
36
37 LP_ITEM_FLEX_CODE_LOW VARCHAR2(600);
38
39 LP_ORDER_NUM VARCHAR2(200);
40
41 ITEM_DSP VARCHAR2(240);
42
43 LP_SALESREP VARCHAR2(500);
44
45 LP_ORDER_DATE VARCHAR2(200);
46
47 LP_CUSTOMER_NAME VARCHAR2(500);
48
49 LP_ORDER_TYPE VARCHAR2(200);
50
51 ITEM_IDENTIFIER_TYPE VARCHAR2(30);
52
53 P_PRINT_DESCRIPTION VARCHAR2(32767);
54
55 LP_AGREEMENT VARCHAR2(500);
56
57 LP_CUSTOMER_NUM VARCHAR2(500);
58
59 P_MIXED_PRECISION NUMBER;
60
61 LP_OPEN_ORDERS_ONLY VARCHAR2(500);
62
63 P_ITEM_STRUCTURE_NUM NUMBER;
64
65 LP_ORDER_CATEGORY VARCHAR2(500);
66
67 LP_LINE_CATEGORY VARCHAR2(500);
68
69 LP_LINE_TYPE VARCHAR2(500);
70
71 LP_ORDER_DATE_LOW VARCHAR2(20);
72
73 LP_ORDER_DATE_HIGH VARCHAR2(20);
74
75 P_CUSTOMER_NAME_HIGH VARCHAR2(360);
76
77 P_CUSTOMER_NUM_HIGH VARCHAR2(30);
78
79 P_SALESREP_HIGH VARCHAR2(50);
80
81 P_LINE_TYPE VARCHAR2(50);
82
83 P_LINE_CATEGORY VARCHAR2(50);
84
85 P_ORDER_CATEGORY VARCHAR2(50);
86
87 P_LANG VARCHAR2(32767);
88
89 P_ORG_ID VARCHAR2(32767);
90
91 P_CHARGE_PERIODICITY VARCHAR2(32767);
92
93 function Item_dspFormula(item_identifier_type_L varchar2,
94 inventory_item_id_L number,
95 ordered_item_id_L number,
96 ordered_item_L varchar2,
97 ORGANIZATION_ID_L number) return Char;
98
99 L_ORDER_TYPE VARCHAR2(30);
100
101 L_LINE_TYPE VARCHAR2(30);
102
103 RP_REPORT_NAME VARCHAR2(240);
104
105 RP_SUB_TITLE VARCHAR2(240);
106
107 RP_COMPANY_NAME VARCHAR2(100);
108
109 RP_FUNCTIONAL_CURRENCY VARCHAR2(80);
110
111 RP_DATA_FOUND VARCHAR2(300);
112
113 RP_ITEM_FLEX_LPROMPT VARCHAR2(100);
114
115 RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
116
117 RP_ITEM_FLEX_APROMPT VARCHAR2(100);
118
119 RP_SALES_REASON_LBL VARCHAR2(15);
120
121 RP_CUSTOMER_RANGE VARCHAR2(100);
122
123 RP_SALESPERSON_RANGE VARCHAR2(100);
124
125 RP_ORDER_RANGE VARCHAR2(42);
126
127 RP_ORDER_DATE_RANGE VARCHAR2(47);
128
129 RP_SALES_REASON_LBL_2 VARCHAR2(16);
130
131 RP_ORDER_BY VARCHAR2(80);
132
133 RP_OPEN_ORDERS_ONLY VARCHAR2(80);
134
135 RP_USE_FUNCTIONAL_CURRENCY VARCHAR2(80);
136
137 RP_FLEX_OR_DESC VARCHAR2(80);
138
139 RP_AGREEMENT_NAME VARCHAR2(50);
140
141 RP_CUSTOMER_NUM_RANGE VARCHAR2(50);
142
143 FUNCTION AFTERREPORT RETURN BOOLEAN;
144
145 FUNCTION P_ORGANIZATION_IDVALIDTRIGGER RETURN BOOLEAN;
146
147 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
148
149 FUNCTION P_SOB_IDVALIDTRIGGER RETURN BOOLEAN;
150
151 FUNCTION P_USE_FUNCTIONAL_CURRENCYVALID RETURN BOOLEAN;
152
153 FUNCTION AFTERPFORM RETURN BOOLEAN;
154
155 FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
156
157 FUNCTION C_GL_CONV_RATEFORMULA(CURRENCY_CODE IN VARCHAR2
158 ,ORDERED_DATE IN DATE
159 ,CONVERSION_TYPE_CODE IN VARCHAR2
160 ,CONVERSION_RATE IN NUMBER) RETURN NUMBER;
161
162 FUNCTION C_PRICEFORMULA(EXTENDED_PRICE IN NUMBER
163 ,C_GL_CONV_RATE IN NUMBER) RETURN NUMBER;
164
165 FUNCTION C_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
166
167 FUNCTION C_DISCOUNT_CURRFORMULA(S_SELLP_CURR IN NUMBER
168 ,S_LISTP_CURR IN NUMBER
169 ,S_SELLP_CURR_RMA IN NUMBER
170 ,S_LISTP_CURR_RMA IN NUMBER) RETURN NUMBER;
171
172 FUNCTION C_DISCOUNT_SRFORMULA(S_SELLP_SR IN NUMBER
173 ,S_LISTP_SR IN NUMBER
174 ,S_SELLP_SR_RMA IN NUMBER
175 ,S_LISTP_SR_RMA IN NUMBER) RETURN NUMBER;
176
177 FUNCTION C_DISCOUNT_CUSTFORMULA(S_SELLP_CUST IN NUMBER
178 ,S_LISTP_CUST IN NUMBER) RETURN NUMBER;
179
180 FUNCTION C_SALE_PRICEFORMULA(SALE_PRICE IN NUMBER
181 ,C_GL_CONV_RATE IN NUMBER) RETURN NUMBER;
182
183 FUNCTION C_DISCOUNT_ORDERFORMULA(S_SELLP_ORDER IN NUMBER
184 ,S_LISTP_ORDER IN NUMBER) RETURN NUMBER;
185
186 FUNCTION C_SALESREP_TOTAL_NETFORMULA RETURN NUMBER;
187
188 FUNCTION S_PRICE_CURR_NETFORMULA(S_PRICE_CURR IN NUMBER
189 ,S_PRICE_CURR_RMA IN NUMBER) RETURN NUMBER;
190
191 FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
192
193 FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
194
195 FUNCTION C_COUNT_LINEFORMULA(HEADER_ID IN NUMBER) RETURN NUMBER;
196
197 FUNCTION C_COUNT_SALESREPFORMULA(HEADER_ID IN NUMBER) RETURN NUMBER;
198
199 FUNCTION S_SALESREP_TOTAL_NETFORMULA(C_SALESREP_TOTAL IN NUMBER
200 ,C_SALESREP_TOTAL_RMA IN NUMBER) RETURN NUMBER;
201
202 FUNCTION C_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
203
204 FUNCTION C_DISCOUNT_PERIODICITYFORMULA(S_SELLP_PERIODICITY IN NUMBER
205 ,S_LISTP_PERIODICITY IN NUMBER) RETURN NUMBER;
206
207 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
208
209 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
210
211 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
212
213 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
214
215 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
216
217 FUNCTION RP_ITEM_FLEX_LPROMPT_P RETURN VARCHAR2;
218
219 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
220
221 FUNCTION RP_ITEM_FLEX_APROMPT_P RETURN VARCHAR2;
222
223 FUNCTION RP_SALES_REASON_LBL_P RETURN VARCHAR2;
224
225 FUNCTION RP_CUSTOMER_RANGE_P RETURN VARCHAR2;
226
227 FUNCTION RP_SALESPERSON_RANGE_P RETURN VARCHAR2;
228
229 FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
230
231 FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
232
233 FUNCTION RP_SALES_REASON_LBL_2_P RETURN VARCHAR2;
234
235 FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
236
237 FUNCTION RP_OPEN_ORDERS_ONLY_P RETURN VARCHAR2;
238
239 FUNCTION RP_USE_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
240
241 FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
242
243 FUNCTION RP_AGREEMENT_NAME_P RETURN VARCHAR2;
244
245 FUNCTION RP_CUSTOMER_NUM_RANGE_P RETURN VARCHAR2;
246
247 -- FUNCTION ITEM_DSPFORMULA RETURN CHAR ;
248
249 FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
250 ,X_TO_CURRENCY IN VARCHAR2
251 ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
252
253 PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
254 ,X_TO_CURRENCY IN VARCHAR2
255 ,X_EFFECTIVE_DATE IN DATE
256 ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
257 ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
258
259 FUNCTION GET_EURO_CODE RETURN VARCHAR2;
260
261 FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
262 ,X_TO_CURRENCY IN VARCHAR2
263 ,X_CONVERSION_DATE IN DATE
264 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
265
266 FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
267 ,X_FROM_CURRENCY IN VARCHAR2
268 ,X_CONVERSION_DATE IN DATE
269 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
270
271 FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
272 ,X_TO_CURRENCY IN VARCHAR2
273 ,X_CONVERSION_DATE IN DATE
274 ,X_CONVERSION_TYPE IN VARCHAR2
275 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
276
277 FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
278 ,X_FROM_CURRENCY IN VARCHAR2
279 ,X_CONVERSION_DATE IN DATE
280 ,X_CONVERSION_TYPE IN VARCHAR2
281 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
282
283 FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
284 ,PERIOD IN VARCHAR2
285 ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
286
287 FUNCTION BEFOREREPORT RETURN BOOLEAN;
288
289 TYPE HEADER_SC_REC_TYPE IS RECORD (HEADER_ID NUMBER,COUNT_SALESREP NUMBER := 0);
290
291 TYPE HEADER_SC_TBL_TYPE IS TABLE OF HEADER_SC_REC_TYPE INDEX BY BINARY_INTEGER;
292
293 G_HEADER_SC_TBL HEADER_SC_TBL_TYPE;
294
295 G_BINARY_LIMIT CONSTANT NUMBER DEFAULT 2147483647;
296
297 FUNCTION F_PERIODICITYFORMATTRIGGER RETURN VARCHAR2;
298
299 END ONT_OEXOESOS_XMLP_PKG;
300