1 PACKAGE ONT_OEXOECOD_XMLP_PKG AS
2 /* $Header: OEXOECODS.pls 120.2 2008/05/05 09:02:57 dwkrishn noship $ */
3 P_SOB_ID NUMBER;
4
5 P_ORDER_BY VARCHAR2(30);
6
7 P_CONC_REQUEST_ID NUMBER;
8
9 P_ORDER_TYPE_LO VARCHAR2(30);
10
11 P_ORDER_TYPE_HI VARCHAR2(30);
12
13 P_ORDER_NUM_LO VARCHAR2(32767);
14
15 P_ORDER_NUM_HI VARCHAR2(32767);
16
17 P_CUSTOMER_LO VARCHAR2(50);
18
19 P_CUSTOMER_HI VARCHAR2(50);
20
21 P_SALESREP_LO VARCHAR2(240);
22
23 P_SALESREP_HI VARCHAR2(240);
24
25 P_OPEN_ORDERS VARCHAR2(32767);
26
27 P_SALES_CREDITS VARCHAR2(30);
28
29 P_ADJUSTMENTS VARCHAR2(30);
30
31 P_FUNCTIONAL_CURRENCY VARCHAR2(30);
32
33 P_ENTERED_BY_LO VARCHAR2(100);
34
35 P_ENTERED_BY_HI VARCHAR2(100);
36
37 P_ORGANIZATION_ID NUMBER;
38
39 P_ORDER_CATEGORY VARCHAR2(30);
40
41 LP_ORDER_CATEGORY VARCHAR2(500) := ' ';
42
43 LP_ORDER_TYPE VARCHAR2(200) := ' ';
44
45 LP_CUSTOMER_NAME VARCHAR2(200) := ' ';
46
47 LP_SALESREP_NAME VARCHAR2(240) := ' ';
48
49 LP_ENTERED_BY VARCHAR2(200) := ' ';
50
51 LP_LINE_TYPE VARCHAR2(200) := ' ';
52
53 P_PRINT_DESCRIPTION VARCHAR2(32767);
54
55 P_CUST_NUM_LO VARCHAR2(30);
56
57 P_CUST_NUM_HI VARCHAR2(30);
58
59 P_ORDER_DATE_HI DATE;
60 P_ORDER_DATE_HI_T VARCHAR2(30);
61
62 P_ORDER_DATE_LO DATE;
63 P_ORDER_DATE_LO_T VARCHAR2(30);
64
65 LP_ORDER_DATE VARCHAR2(200) := ' ';
66
67 P_LINE_TYPE_HI VARCHAR2(30);
68
69 P_LINE_TYPE_LO VARCHAR2(30);
70
71 P_ITEM_FLEX_CODE VARCHAR2(32767);
72
73 P_ITEM_STRUCTURE_NUM NUMBER;
74
75 P_LINE_CATEGORY VARCHAR2(30);
76
77 LP_LINE_CATEGORY VARCHAR2(40) := ' ';
78
79 LP_CUSTOMER_NUMBER VARCHAR2(200) := ' ';
80
81 LP_LINE_TYPE_WHERE VARCHAR2(200) := ' ';
82
83 LP_ORDER_NUM VARCHAR2(800) := ' ';
84
85 LP_ORDER_BY VARCHAR2(200) := ' ';
86
87 P_ENABLE_TRACE VARCHAR2(5);
88
89 P_CHARGE_PERIODICITY VARCHAR2(32767);
90
91 L_ORDER_TYPE_LOW VARCHAR2(30);
92
93 L_ORDER_TYPE_HIGH VARCHAR2(30);
94
95 L_LINE_TYPE_LOW VARCHAR2(30);
96
97 L_LINE_TYPE_HIGH VARCHAR2(30);
98
99 P_END_CUST VARCHAR2(30);
100
101 CP_STD_PRECISION NUMBER;
102
103 CP_EXT_PRECISION NUMBER;
104
105 CP_MIN_ACCT_UNIT NUMBER;
106
107 LP_ORGANIZATION_ID number;
108
109 CP_COMMITMENT NUMBER;
110
111 CP_LINE_COMMITMENT NUMBER;
112
113 RP_CURR_PROFILE VARCHAR2(50) := 'STANDARD';
114
115 RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'SI.SEGMENT1';
116
117 RP_ITEM_FLEX_SEG_VAL VARCHAR2(2000);
118
119 function BeforeReport return boolean;
120
121 FUNCTION C_ORDER_BY_DISPLAYFORMULA RETURN VARCHAR2;
122
123 FUNCTION AFTERREPORT RETURN BOOLEAN;
124
125 FUNCTION C_ORDER_NUM_WHERE RETURN VARCHAR2;
126
127 FUNCTION GET_SOB_NAME RETURN VARCHAR2;
128
129 FUNCTION C_OPEN_ORDERS_DISPLAYFORMULA RETURN VARCHAR2;
130
131 FUNCTION CONTACT_PHONE(CONTACT_ID IN NUMBER) RETURN VARCHAR2;
132
133 FUNCTION C_BASE_CURRENCYFORMULA RETURN VARCHAR2;
134
135 FUNCTION C_SALES_CREDITS_DISPLAYFORMULA RETURN VARCHAR2;
136
137 FUNCTION C_ADJUSTMENTS_DISPLAYFORMULA RETURN VARCHAR2;
138
139 FUNCTION C_FUNCTIONAL_CURRENCY_DISPFORM RETURN VARCHAR2;
140
141 FUNCTION C_GL_CONV_RATEFORMULA(CURRENCY1 IN VARCHAR2
142 ,C_BASE_CURRENCY IN VARCHAR2
143 ,CONVERSION_RATE IN NUMBER
144 ,ORDER_DATE IN DATE
145 ,CONVERSION_TYPE_CODE IN VARCHAR2) RETURN NUMBER;
146
147 FUNCTION C_FC_ORDER_VALUEFORMULA(C_GL_CONV_RATE IN NUMBER
148 ,HEADER_ID IN NUMBER) RETURN NUMBER;
149
150 FUNCTION C_FC_HDR_PA_AMOUNTFORMULA(C_GL_CONV_RATE IN NUMBER
151 ,HDR_PA_AMOUNT IN NUMBER) RETURN NUMBER;
152
153 FUNCTION C_FC_LIST_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
154 ,LIST_PRICE IN NUMBER) RETURN NUMBER;
155
156 FUNCTION C_FC_SELLING_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
157 ,SELLING_PRICE IN NUMBER) RETURN NUMBER;
158
159 FUNCTION C_FC_EXTENDED_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
160 ,EXTENDED_PRICE IN NUMBER) RETURN NUMBER;
161
162 FUNCTION C_FC_L_PA_AMOUNTFORMULA(C_GL_CONV_RATE IN NUMBER
163 ,L_PA_AMOUNT IN NUMBER) RETURN NUMBER;
164
165 FUNCTION C_OPEN_ORDERS_WHERE RETURN VARCHAR2;
166
167 FUNCTION C_USE_CURRENCYFORMULA(C_BASE_CURRENCY IN VARCHAR2
168 ,CURRENCY1 IN VARCHAR2) RETURN VARCHAR2;
169
170 FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
171
172 FUNCTION AFTERPFORM RETURN BOOLEAN;
173
174 FUNCTION C_FC_TAXFORMULA(C_GL_CONV_RATE IN NUMBER
175 ,TAX_ON_LINE IN NUMBER) RETURN NUMBER;
176
177 FUNCTION C_FC_LINE_CHARGEFORMULA(C_GL_CONV_RATE IN NUMBER
178 ,LINE_CHARGE IN NUMBER) RETURN NUMBER;
179
180 FUNCTION C_LINE_BILL_TO_CUSTFORMULA(LINE_BILL_TO_ORG_ID IN NUMBER
181 ,INVOICE_TO_ORG_ID IN NUMBER
182 ,L_BILL_ADDRESS IN VARCHAR2) RETURN CHAR;
183
184 FUNCTION C_LINE_SHIP_TO_CUSTFORMULA(LINE_SHIP_TO_ORG_ID IN NUMBER
185 ,HDR_SHIP_SITE_USE_ID IN NUMBER
186 ,L_SHIP_ADDRESS IN VARCHAR2) RETURN CHAR;
187
188 FUNCTION C_LINE_AGREEMENTFORMULA(LINE_AGREEMENT IN VARCHAR2
189 ,AGREEMENT1 IN VARCHAR2) RETURN CHAR;
190
191 FUNCTION C_LINE_POFORMULA(LINE_PO IN VARCHAR2
192 ,PURCHASE_ORDER IN VARCHAR2) RETURN CHAR;
193
194 FUNCTION C_LINE_TERMSFORMULA(LINE_TERMS IN VARCHAR2
195 ,TERMS1 IN VARCHAR2) RETURN CHAR;
196
197 FUNCTION C_ITEM_REVISIONFORMULA(ITEM_REVISION IN VARCHAR2) RETURN CHAR;
198
199 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
200
201 FUNCTION C_FC_EXTEND_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
202 ,SVC_EXTENDED_PRICE IN NUMBER) RETURN NUMBER;
203
204 FUNCTION C_FC_SALE_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
205 ,SVC_SELLING_PRICE IN NUMBER) RETURN NUMBER;
206
207 FUNCTION C_FMT_EXTEND_PRICEFORMULA(C_FC_EXTEND_PRICE IN NUMBER) RETURN NUMBER;
208
209 FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
210
211 FUNCTION RP_ITEM_DISPLAYFORMULA RETURN VARCHAR2;
212
213 FUNCTION C_FC_AMOUNTFORMULA(C_GL_CONV_RATE IN NUMBER
214 ,AMOUNT IN NUMBER
215 ,C_USE_CURRENCY IN VARCHAR2) RETURN NUMBER;
216
217 FUNCTION C_MASTER_ORGFORMULA RETURN CHAR;
218
219 FUNCTION C_SHIP_HDR_ADDRESS4FORMULA(S_ADDRESS4 IN VARCHAR2
220 ,HDR_SHIP_SITE_USE_ID IN NUMBER) RETURN CHAR;
221
222 FUNCTION C_BILL_HDR_ADDRESS4FORMULA(B_ADDRESS4 IN VARCHAR2
223 ,INVOICE_TO_ORG_ID IN NUMBER) RETURN CHAR;
224
225 FUNCTION CF_HDR_PERCENTFORMULA(PREPAID_AMOUNT IN NUMBER
226 ,C_FC_ORDER_VALUE IN NUMBER) RETURN NUMBER;
227
228 FUNCTION CF_LINE_PERCENTFORMULA(PREPAID_AMOUNT1 IN NUMBER
229 ,C_FC_ORDER_VALUE IN NUMBER) RETURN NUMBER;
230
231 FUNCTION C_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
232
233 FUNCTION CF_INITIAL_DUE_TOTALFORMULA(HEADER_ID IN NUMBER) RETURN NUMBER;
234
235 FUNCTION CF_INITIAL_DUE_BALANCEFORMULA(CF_INITIAL_DUE_TOTAL IN NUMBER
236 ,CS_PREPAID_AMOUNT IN NUMBER) RETURN NUMBER;
237
238 FUNCTION CF_AUTHORIZED_AMOUNTFORMULA(HEADER_ID IN NUMBER) RETURN NUMBER;
239
240 FUNCTION CF_LINE_INITIAL_DUE_TOTALFORMU(HEADER_ID IN NUMBER
241 ,LINE_ID IN NUMBER) RETURN NUMBER;
242
243 FUNCTION CF_LINE_INITIAL_DUE_BALFORMULA(CF_LINE_INITIAL_DUE_TOTAL IN NUMBER) RETURN NUMBER;
244
245 FUNCTION CF_LINE_AUTHORIZED_AMOUNTFORMU(LINE_ID IN NUMBER) RETURN NUMBER;
246
247 FUNCTION CF_END_CUSTOMERFORMULA(END_CUSTOMER_ID IN NUMBER) RETURN CHAR;
248
249 FUNCTION CF_END_CUSTOMER_ADDRESS1FORMUL(END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
250
251 FUNCTION CF_END_CUSTOMER_ADDRESS5FORMUL(END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
252
253 FUNCTION CF_END_CUSTOMER_CONTACTFORMULA(END_CUSTOMER_CONTACT_ID IN NUMBER) RETURN CHAR;
254
255 FUNCTION CF_END_CUSTOMER_COUNTRYFORMULA(END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
256
257 FUNCTION CF_END_CUSTOMER_NUMBERFORMULA(END_CUSTOMER_ID IN NUMBER) RETURN NUMBER;
258
259 FUNCTION CF_IB_CURRENT_ADDRESS1FORMULA(IB_CURRENT_LOCATION IN VARCHAR2
260 ,L_SHIP_ADDRESS IN VARCHAR2
261 ,L_BILL_ADDRESS IN VARCHAR2
262 ,DELIVER_TO_ORG_ID IN NUMBER
263 ,HEADER_ID IN NUMBER
264 ,END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
265
266 FUNCTION CF_IB_CURRENT_ADDRESS5FORMULA(IB_CURRENT_LOCATION IN VARCHAR2
267 ,SHIP_TO_ADDRESS5 IN VARCHAR2
268 ,INVOICE_TO_ADDRESS5 IN VARCHAR2
269 ,DELIVER_TO_ORG_ID IN NUMBER
270 ,HEADER_ID IN NUMBER
271 ,END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
272
273 FUNCTION CF_IB_INSTALLED_AT_ADDRESS1FOR(IB_INSTALLED_AT_LOCATION IN VARCHAR2
274 ,L_SHIP_ADDRESS IN VARCHAR2
275 ,L_BILL_ADDRESS IN VARCHAR2
276 ,DELIVER_TO_ORG_ID IN NUMBER
277 ,HEADER_ID IN NUMBER
278 ,END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
279
280 FUNCTION CF_INSTALLED_AT_ADDRESS5FORMUL(IB_INSTALLED_AT_LOCATION IN VARCHAR2
281 ,SHIP_TO_ADDRESS5 IN VARCHAR2
282 ,INVOICE_TO_ADDRESS5 IN VARCHAR2
283 ,DELIVER_TO_ORG_ID IN NUMBER
284 ,HEADER_ID IN NUMBER
285 ,END_CUSTOMER_SITE_USE_ID IN NUMBER) RETURN CHAR;
286
287 FUNCTION CF_IB_OWNERFORMULA(IB_OWNER IN VARCHAR2
288 ,HEADER_ID IN NUMBER
289 ,END_CUSTOMER_ID IN NUMBER) RETURN CHAR;
290
291 FUNCTION CF_END_DISPLAYFORMULA RETURN CHAR;
292
293 FUNCTION CP_STD_PRECISION_P RETURN NUMBER;
294
295 FUNCTION CP_EXT_PRECISION_P RETURN NUMBER;
296
297 FUNCTION CP_MIN_ACCT_UNIT_P RETURN NUMBER;
298
299 FUNCTION CP_COMMITMENT_P RETURN NUMBER;
300
301 FUNCTION CP_LINE_COMMITMENT_P RETURN NUMBER;
302
303 FUNCTION RP_CURR_PROFILE_P RETURN VARCHAR2;
304
305 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
306
307 FUNCTION RP_ITEM_FLEX_SEG_VAL_P RETURN VARCHAR2;
308
309 FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
310 ,X_TO_CURRENCY IN VARCHAR2
311 ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
312
313 PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
314 ,X_TO_CURRENCY IN VARCHAR2
315 ,X_EFFECTIVE_DATE IN DATE
316 ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
317 ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
318
319 FUNCTION GET_EURO_CODE RETURN VARCHAR2;
320
321 FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
322 ,X_TO_CURRENCY IN VARCHAR2
323 ,X_CONVERSION_DATE IN DATE
324 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
325
326 FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
327 ,X_FROM_CURRENCY IN VARCHAR2
328 ,X_CONVERSION_DATE IN DATE
329 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
330
331 FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
332 ,X_TO_CURRENCY IN VARCHAR2
333 ,X_CONVERSION_DATE IN DATE
334 ,X_CONVERSION_TYPE IN VARCHAR2
335 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
336
337 FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
338 ,X_FROM_CURRENCY IN VARCHAR2
339 ,X_CONVERSION_DATE IN DATE
340 ,X_CONVERSION_TYPE IN VARCHAR2
341 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
342
343 FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
344 ,PERIOD IN VARCHAR2
345 ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
346
347 FUNCTION RATE_EXISTS(X_FROM_CURRENCY IN VARCHAR2
348 ,X_TO_CURRENCY IN VARCHAR2
349 ,X_CONVERSION_DATE IN DATE
350 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN VARCHAR2;
351 FUNCTION ITEM_DSPFORMULA
352 (
353 ITEM_IDENTIFIER_TYPE IN VARCHAR,
354 C_MASTER_ORG IN VARCHAR,
355 INVENTORY_ITEM_ID_T IN NUMBER,
356 ORDERED_ITEM_ID_T IN NUMBER,
357 ORDERED_ITEM IN varchar2,
358 SI_ORGANIZATION_ID in number,
359 SI_INVENTORY_ITEM_ID in number
360 )
361 RETURN CHAR ;
362 END ONT_OEXOECOD_XMLP_PKG;
363