1 PACKAGE ONT_OEXOEACK_XMLP_PKG AS
2 /* $Header: OEXOEACKS.pls 120.1 2007/12/25 07:12:49 npannamp noship $ */
3 P_CONC_REQUEST_ID NUMBER;
4
5 P_SOB_ID NUMBER;
6
7 P_ORDER_NUM_LOW VARCHAR2(32767);
8
9 P_ORDER_NUM_HIGH VARCHAR2(32767);
10
11 P_BILL_TO_CUSTOMER_NAME_LO VARCHAR2(360);
12
13 P_BILL_TO_CUSTOMER_NAME_HI VARCHAR2(360);
14
15 P_ITEM_FLEX_CODE VARCHAR2(32767);
16
17 P_ORG_ID VARCHAR2(32767);
18
19 P_SCHEDULE_DATE_LOW DATE;
20
21 P_SCHEDULE_DATE_HIGH DATE;
22
23 P_ORDER_DATE_LOW DATE;
24
25 P_ORDER_DATE_HIGH DATE;
26
27 P_SALESREP VARCHAR2(240);
28
29 P_CREATED_BY VARCHAR2(100);
30
31 P_SHIP_TO_CUSTOMER_NAME_LO VARCHAR2(360);
32
33 P_SHIP_TO_CUSTOMER_NAME_HI VARCHAR2(360);
34
35 P_BOOKED_STATUS VARCHAR2(32767);
36
37 LP_BOOKED_STATUS VARCHAR2(300):=' ';
38
39 LP_ORDER_DATE VARCHAR2(800):=' ';
40
41 LP_BILL_TO_CUSTOMER_NAME VARCHAR2(800):=' ';
42
43 LP_SHIP_TO_CUSTOMER_NAME VARCHAR2(800):=' ';
44
45 LP_ORDER_NUM VARCHAR2(800):=' ';
46
47 LP_SCHEDULE_DATE VARCHAR2(800):=' ';
48
49 P_PRINT_DESCRIPTION VARCHAR2(32767);
50
51 LP_SALESREP VARCHAR2(1000):=' ';
52
53 LP_CREATED_BY VARCHAR2(1000):=' ';
54
55 P_ITEM_STRUCTURE_NUM NUMBER;
56
57 P_PROFILE_NAME VARCHAR2(50);
58
59 P_OPEN_ORDERS VARCHAR2(32767);
60
61 LP_OPEN_ORDERS VARCHAR2(240):=' ';
62
63 P_ORDER_TYPE NUMBER;
64
65 LP_ORDER_TYPE VARCHAR2(200):=' ';
66
67 LP_UNIT_OF_MEASURE VARCHAR2(200) := 'uom.unit_of_measure';
68
69 LP_LANGUAGE_WHERE VARCHAR2(200) := 'and 1 = 1';
70
71 MLS_FLAG VARCHAR2(1);
72
73 ATT_COLUMN_NAME VARCHAR2(40);
74
75 P_FUNCTIONAL_CURRENCY VARCHAR2(30);
76
77 P_DEL_TO_CUSTOMER_NAME_LO VARCHAR2(360);
78
79 P_DEL_TO_CUSTOMER_NAME_HI VARCHAR2(360);
80
81 LP_DEL_TO_CUSTOMER_NAME VARCHAR2(800):=' ';
82
83 P_ORDER_CATEGORY VARCHAR2(50);
84
85 P_LINE_CATEGORY VARCHAR2(50);
86
87 LP_ORDER_CATEGORY VARCHAR2(200):=' ';
88
89 LP_LINE_CATEGORY VARCHAR2(200):=' ';
90
91 LP_REQUEST_DATE VARCHAR2(800):=' ';
92
93 LP_PROMISE_DATE VARCHAR2(800):=' ';
94
95 P_REQUEST_DATE_HIGH DATE;
96
97 P_REQUEST_DATE_LOW DATE;
98
99 P_PROMISE_DATE_HIGH DATE;
100
101 P_PROMISE_DATE_LOW DATE;
102
103 P_SHOW_HDR_ATTACH VARCHAR2(32767);
104
105 P_SHOW_BODY_ATTACH VARCHAR2(32767);
106
107 P_SHOW_FTR_ATTACH VARCHAR2(32767);
108
109 P_USER_LANG VARCHAR2(32767);
110
111 P_MASTER_ORG_ID VARCHAR2(40);
112
113 P_ENABLE_TRACE VARCHAR2(5);
114
115 P_CHARGE_PERIODICITY VARCHAR2(32767);
116
117 RP_DUMMY_ITEM VARCHAR2(2000);
118
119 RP_REPORT_NAME VARCHAR2(240);
120
121 RP_SUB_TITLE VARCHAR2(80);
122
123 RP_COMPANY_NAME VARCHAR2(50);
124
125 RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
126
127 RP_DATA_FOUND VARCHAR2(300);
128
129 RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'SI.SEGMENT1';
130
131 RP_PRINT_DESCRIPTION VARCHAR2(100);
132
133 RP_CURR_PROFILE VARCHAR2(50) := 'STANDARD';
134
135 RP_ITEM_FLEX_SEG_VAL VARCHAR2(2000);
136
137 RP_TAX_TOTAL_ROUNDED NUMBER;
138
139 RP_LINE_CHARGE_TOTAL_ROUNDED NUMBER;
140
141 RP_HDR_CHARGE_TOTAL_ROUNDED NUMBER;
142
143 RP_HDR_CHARGE_TOTAL NUMBER;
144
145 FUNCTION AFTERREPORT RETURN BOOLEAN;
146
147 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
148
149 FUNCTION AFTERPFORM RETURN BOOLEAN;
150
151 FUNCTION C_LINE_SHIP_TO_CUSTFORMULA(LINE_SHIP_TO_ORG_ID IN NUMBER
152 ,HDR_SHIP_TO_ORG_ID IN NUMBER
153 ,LINE_S_CITY_ST_ZIP IN VARCHAR2) RETURN VARCHAR2;
154
155 FUNCTION C_DATA_NOT_FOUNDFORMULA(ORDER_NUMBER IN NUMBER) RETURN NUMBER;
156
157 FUNCTION C_EXTENDED_PRICEFORMULA(SELLING_PRICE IN NUMBER
158 ,C_PRECISION IN NUMBER
159 ,PRICING_QUANTITY IN NUMBER
160 ,LINE_CATEGORY_CODE IN VARCHAR2
161 ,ORDERED_QUANTITY IN NUMBER) RETURN NUMBER;
162
163 FUNCTION S_TAX_TOTAL_DSPFORMULA RETURN VARCHAR2;
164
165 FUNCTION C_PRECISIONFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
166
167 PROCEDURE POPULATE_MLS_LEXICALS;
168
169 FUNCTION C_USE_CURRENCYFORMULA(C_BASE_CURRENCY IN VARCHAR2
170 ,CURRENCY1 IN VARCHAR2) RETURN VARCHAR2;
171
172 FUNCTION C_BASE_CURRENCYFORMULA RETURN VARCHAR2;
173
174 FUNCTION C_GL_CONV_RATEFORMULA(CURRENCY1 IN VARCHAR2
175 ,C_BASE_CURRENCY IN VARCHAR2
176 ,CONVERSION_RATE IN NUMBER
177 ,ORDER_DATE IN DATE
178 ,CONVERSION_TYPE_CODE IN VARCHAR2) RETURN NUMBER;
179
180 FUNCTION C_LINE_BILL_TO_CUSTFORMULA(LINE_BILL_TO_ORG_ID IN NUMBER
181 ,HDR_BILL_TO_ORG_ID IN NUMBER
182 ,LINE_B_CITY_ST_ZIP IN VARCHAR2) RETURN CHAR;
183
184 FUNCTION C_LINE_DEL_TO_CUSTFORMULA(LINE_DEL_TO_ORG_ID IN NUMBER
185 ,HDR_DEL_TO_ORG_ID IN NUMBER
186 ,LINE_D_CITY_ST_ZIP IN VARCHAR2) RETURN CHAR;
187
188 FUNCTION C_LINE_SALESREPFORMULA(LINE_SALESREP IN VARCHAR2
189 ,SALES_PERSON 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_TYPEFORMULA(LINE_TYPE_ID IN NUMBER
195 ,LINE_TYPE IN VARCHAR2) RETURN CHAR;
196
197 FUNCTION C_LINE_FREIGHT_TERMSFORMULA(LINE_FREIGHT_TERMS IN VARCHAR2
198 ,FREIGHT_TERMS IN VARCHAR2) RETURN CHAR;
199
200 FUNCTION C_LINE_FOBFORMULA(LINE_FOB IN VARCHAR2
201 ,FOB IN VARCHAR2) RETURN CHAR;
202
203 FUNCTION C_LINE_CARRIERFORMULA(LINE_CARRIER IN VARCHAR2
204 ,CARRIER IN VARCHAR2) RETURN CHAR;
205
206 FUNCTION C_FC_EXTEND_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
207 ,SVC_EXTENDED_PRICE IN NUMBER
208 ,C_PRECISION IN NUMBER) RETURN NUMBER;
209
210 FUNCTION C_FC_SALE_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
211 ,SVC_SELLING_PRICE IN NUMBER) RETURN NUMBER;
212
213 FUNCTION C_LINE_AGREEMENTFORMULA(LINE_AGREEMENT IN VARCHAR2
214 ,AGREEMENT IN VARCHAR2) RETURN CHAR;
215
216 FUNCTION C_LINE_TERMSFORMULA(LINE_TERM IN VARCHAR2
217 ,PAYMENT_TERMS IN VARCHAR2) RETURN CHAR;
218
219 FUNCTION C_FMT_TAX_ON_LINEFORMULA(LINE_CATEGORY_CODE IN VARCHAR2
220 ,C_TOTAL_LINE_TAX IN NUMBER
221 ,C_PRECISION IN NUMBER) RETURN NUMBER;
222
223 FUNCTION C_LINE_CATEGORYFORMULA(LINE_CATEGORY_CODE IN VARCHAR2) RETURN CHAR;
224
225 FUNCTION C_LINE_CHARGEFORMULA(LINE_CHARGE IN NUMBER
226 ,C_PRECISION IN NUMBER) RETURN NUMBER;
227
228 FUNCTION C_MASTER_ORGFORMULA RETURN CHAR;
229
230 FUNCTION CF_1FORMULA(S_TAX_TOTAL IN NUMBER
231 ,S_LINE_CHARGE IN NUMBER
232 ,S_EXTENDED_PRICE IN NUMBER
233 ,S_SVC_EXTENDED_PRICE IN NUMBER
234 ,S_HEADER_CHARGE IN NUMBER
235 ,C_PRECISION IN NUMBER) RETURN NUMBER;
236
237 FUNCTION C_TAX_ON_LINEFORMULA(LINE_CATEGORY_CODE IN VARCHAR2
238 ,C_TOTAL_LINE_TAX IN NUMBER
239 ,C_PRECISION IN NUMBER) RETURN NUMBER;
240
241 FUNCTION C_ORDERED_QUANTITY(LINE_CATEGORY_CODE IN VARCHAR2
242 ,ORDERED_QUANTITY IN NUMBER) RETURN NUMBER;
243
244 FUNCTION C_TOTAL_LINE_TAXFORMULA(TAX_ON_LINE IN NUMBER
245 ,S_TOTAL_SVC_TAX IN NUMBER) RETURN NUMBER;
246
247 FUNCTION C_SVC_TAXFORMULA(TAX_ON_SVC_LINE IN NUMBER
248 ,C_PRECISION IN NUMBER) RETURN NUMBER;
249
250 FUNCTION C_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
251
252 FUNCTION G_GRAND_TOTALFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2
253 ,C_TAX_TOTAL IN NUMBER
254 ,C_LINE_RECUR_CHARGE IN NUMBER
255 ,CF_EXTENDED_PRICE IN NUMBER
256 ,C_SVC_EXTENDED_PRICE IN NUMBER
257 ,C_HEADER_CHARGE_PERIODICITY IN NUMBER
258 ,C_PRECISION IN NUMBER) RETURN NUMBER;
259
260 FUNCTION G_PRECISIONFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
261
262 FUNCTION C_HEADER_CHARGE_PERIODICITYFOR(CHARGE_PERIODICITY_CODE IN VARCHAR2
263 ,C_HEADER_CHARGE IN NUMBER
264 ,C_PRECISION IN NUMBER) RETURN NUMBER;
265
266 FUNCTION C_HEADER_CHARGEFORMULA(HEADER_ID IN NUMBER) RETURN NUMBER;
267
268 FUNCTION C_ACCEPT_REQUIREDFORMULA(CONTINGENCY_ID IN NUMBER) RETURN CHAR;
269
270 FUNCTION C_BILL_CONTACTFORMULA(INVOICE_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
271
272 FUNCTION C_SHIP_CONTACTFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
273
274 FUNCTION C_DEL_CONTACTFORMULA(DELIVER_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
275
276 FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
277
278 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
279
280 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
281
282 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
283
284 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
285
286 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
287
288 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
289
290 FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
291
292 FUNCTION RP_CURR_PROFILE_P RETURN VARCHAR2;
293
294 FUNCTION RP_ITEM_FLEX_SEG_VAL_P RETURN VARCHAR2;
295
296 FUNCTION RP_TAX_TOTAL_ROUNDED_P RETURN NUMBER;
297
298 FUNCTION RP_LINE_CHARGE_TOTAL_ROUNDED_P RETURN NUMBER;
299
300 FUNCTION RP_HDR_CHARGE_TOTAL_ROUNDED_P RETURN NUMBER;
301
302 FUNCTION RP_HDR_CHARGE_TOTAL_P RETURN NUMBER;
303
304 FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
305 ,X_TO_CURRENCY IN VARCHAR2
306 ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
307
308 PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
309 ,X_TO_CURRENCY IN VARCHAR2
310 ,X_EFFECTIVE_DATE IN DATE
311 ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
312 ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
313
314 FUNCTION GET_EURO_CODE RETURN VARCHAR2;
315
316 FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
317 ,X_TO_CURRENCY IN VARCHAR2
318 ,X_CONVERSION_DATE IN DATE
319 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
320
321 FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
322 ,X_FROM_CURRENCY IN VARCHAR2
323 ,X_CONVERSION_DATE IN DATE
324 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
325
326 FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
327 ,X_TO_CURRENCY IN VARCHAR2
328 ,X_CONVERSION_DATE IN DATE
329 ,X_CONVERSION_TYPE IN VARCHAR2
330 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
331
332 FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
333 ,X_FROM_CURRENCY IN VARCHAR2
334 ,X_CONVERSION_DATE IN DATE
335 ,X_CONVERSION_TYPE IN VARCHAR2
336 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
337
338 FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
339 ,PERIOD IN VARCHAR2
340 ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
341
342 FUNCTION RATE_EXISTS(X_FROM_CURRENCY IN VARCHAR2
343 ,X_TO_CURRENCY IN VARCHAR2
344 ,X_CONVERSION_DATE IN DATE
345 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN VARCHAR2;
346
347 FUNCTION BEFOREREPORT RETURN BOOLEAN;
348 FUNCTION F_PERIODICITYFORMATTRIGGER RETURN VARCHAR2;
349
350 END ONT_OEXOEACK_XMLP_PKG;
351