1 PACKAGE ONT_OEXOEACK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEACKS.pls 120.2 2011/11/11 14:30:36 vmachett ship $ */
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 --Bug# 12690206
145 FUNCTION ITEM_DSPFORMULA(ITEM_IDENTIFIER_TYPE IN VARCHAR2,INVENTORY_ITEM_ID IN NUMBER,
146 C_MASTER_ORG IN VARCHAR2,ORDERED_ITEM_ID IN NUMBER,
147 ORDERED_ITEM IN VARCHAR2,SI_ORGANIZATION_ID IN NUMBER, SI_INVENTORY_ITEM_ID IN NUMBER) RETURN VARCHAR2;
148
149 FUNCTION AFTERREPORT RETURN BOOLEAN;
150
151 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
152
153 FUNCTION AFTERPFORM RETURN BOOLEAN;
154
155 FUNCTION C_LINE_SHIP_TO_CUSTFORMULA(LINE_SHIP_TO_ORG_ID IN NUMBER
156 ,HDR_SHIP_TO_ORG_ID IN NUMBER
157 ,LINE_S_CITY_ST_ZIP IN VARCHAR2) RETURN VARCHAR2;
158
159 FUNCTION C_DATA_NOT_FOUNDFORMULA(ORDER_NUMBER IN NUMBER) RETURN NUMBER;
160
161 FUNCTION C_EXTENDED_PRICEFORMULA(SELLING_PRICE IN NUMBER
162 ,C_PRECISION IN NUMBER
163 ,PRICING_QUANTITY IN NUMBER
164 ,LINE_CATEGORY_CODE IN VARCHAR2
165 ,ORDERED_QUANTITY IN NUMBER) RETURN NUMBER;
166
167 FUNCTION S_TAX_TOTAL_DSPFORMULA RETURN VARCHAR2;
168
169 FUNCTION C_PRECISIONFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
170
171 PROCEDURE POPULATE_MLS_LEXICALS;
172
173 FUNCTION C_USE_CURRENCYFORMULA(C_BASE_CURRENCY IN VARCHAR2
174 ,CURRENCY1 IN VARCHAR2) RETURN VARCHAR2;
175
176 FUNCTION C_BASE_CURRENCYFORMULA RETURN VARCHAR2;
177
178 FUNCTION C_GL_CONV_RATEFORMULA(CURRENCY1 IN VARCHAR2
179 ,C_BASE_CURRENCY IN VARCHAR2
180 ,CONVERSION_RATE IN NUMBER
181 ,ORDER_DATE IN DATE
182 ,CONVERSION_TYPE_CODE IN VARCHAR2) RETURN NUMBER;
183
184 FUNCTION C_LINE_BILL_TO_CUSTFORMULA(LINE_BILL_TO_ORG_ID IN NUMBER
185 ,HDR_BILL_TO_ORG_ID IN NUMBER
186 ,LINE_B_CITY_ST_ZIP IN VARCHAR2) RETURN CHAR;
187
188 FUNCTION C_LINE_DEL_TO_CUSTFORMULA(LINE_DEL_TO_ORG_ID IN NUMBER
189 ,HDR_DEL_TO_ORG_ID IN NUMBER
190 ,LINE_D_CITY_ST_ZIP IN VARCHAR2) RETURN CHAR;
191
192 FUNCTION C_LINE_SALESREPFORMULA(LINE_SALESREP IN VARCHAR2
193 ,SALES_PERSON IN VARCHAR2) RETURN CHAR;
194
195 FUNCTION C_LINE_POFORMULA(LINE_PO IN VARCHAR2
196 ,PURCHASE_ORDER IN VARCHAR2) RETURN CHAR;
197
198 FUNCTION C_LINE_TYPEFORMULA(LINE_TYPE_ID IN NUMBER
199 ,LINE_TYPE IN VARCHAR2) RETURN CHAR;
200
201 FUNCTION C_LINE_FREIGHT_TERMSFORMULA(LINE_FREIGHT_TERMS IN VARCHAR2
202 ,FREIGHT_TERMS IN VARCHAR2) RETURN CHAR;
203
204 FUNCTION C_LINE_FOBFORMULA(LINE_FOB IN VARCHAR2
205 ,FOB IN VARCHAR2) RETURN CHAR;
206
207 FUNCTION C_LINE_CARRIERFORMULA(LINE_CARRIER IN VARCHAR2
208 ,CARRIER IN VARCHAR2) RETURN CHAR;
209
210 FUNCTION C_FC_EXTEND_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
211 ,SVC_EXTENDED_PRICE IN NUMBER
212 ,C_PRECISION IN NUMBER) RETURN NUMBER;
213
214 FUNCTION C_FC_SALE_PRICEFORMULA(C_GL_CONV_RATE IN NUMBER
215 ,SVC_SELLING_PRICE IN NUMBER) RETURN NUMBER;
216
217 FUNCTION C_LINE_AGREEMENTFORMULA(LINE_AGREEMENT IN VARCHAR2
218 ,AGREEMENT IN VARCHAR2) RETURN CHAR;
219
220 FUNCTION C_LINE_TERMSFORMULA(LINE_TERM IN VARCHAR2
221 ,PAYMENT_TERMS IN VARCHAR2) RETURN CHAR;
222
223 FUNCTION C_FMT_TAX_ON_LINEFORMULA(LINE_CATEGORY_CODE IN VARCHAR2
224 ,C_TOTAL_LINE_TAX IN NUMBER
225 ,C_PRECISION IN NUMBER) RETURN NUMBER;
226
227 FUNCTION C_LINE_CATEGORYFORMULA(LINE_CATEGORY_CODE IN VARCHAR2) RETURN CHAR;
228
229 FUNCTION C_LINE_CHARGEFORMULA(LINE_CHARGE IN NUMBER
230 ,C_PRECISION IN NUMBER) RETURN NUMBER;
231
232 FUNCTION C_MASTER_ORGFORMULA RETURN CHAR;
233
234 FUNCTION CF_1FORMULA(S_TAX_TOTAL IN NUMBER
235 ,S_LINE_CHARGE IN NUMBER
236 ,S_EXTENDED_PRICE IN NUMBER
237 ,S_SVC_EXTENDED_PRICE IN NUMBER
238 ,S_HEADER_CHARGE IN NUMBER
239 ,C_PRECISION IN NUMBER) RETURN NUMBER;
240
241 FUNCTION C_TAX_ON_LINEFORMULA(LINE_CATEGORY_CODE IN VARCHAR2
242 ,C_TOTAL_LINE_TAX IN NUMBER
243 ,C_PRECISION IN NUMBER) RETURN NUMBER;
244
245 FUNCTION C_ORDERED_QUANTITY(LINE_CATEGORY_CODE IN VARCHAR2
246 ,ORDERED_QUANTITY IN NUMBER) RETURN NUMBER;
247
248 FUNCTION C_TOTAL_LINE_TAXFORMULA(TAX_ON_LINE IN NUMBER
249 ,S_TOTAL_SVC_TAX IN NUMBER) RETURN NUMBER;
250
251 FUNCTION C_SVC_TAXFORMULA(TAX_ON_SVC_LINE IN NUMBER
252 ,C_PRECISION IN NUMBER) RETURN NUMBER;
253
254 FUNCTION C_CHARGE_PERIODICITYFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
255
256 FUNCTION G_GRAND_TOTALFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2
257 ,C_TAX_TOTAL IN NUMBER
258 ,C_LINE_RECUR_CHARGE IN NUMBER
259 ,CF_EXTENDED_PRICE IN NUMBER
260 ,C_SVC_EXTENDED_PRICE IN NUMBER
261 ,C_HEADER_CHARGE_PERIODICITY IN NUMBER
262 ,C_PRECISION IN NUMBER) RETURN NUMBER;
263
264 FUNCTION G_PRECISIONFORMULA(CURRENCY1 IN VARCHAR2) RETURN NUMBER;
265
266 FUNCTION C_HEADER_CHARGE_PERIODICITYFOR(CHARGE_PERIODICITY_CODE IN VARCHAR2
267 ,C_HEADER_CHARGE IN NUMBER
268 ,C_PRECISION IN NUMBER) RETURN NUMBER;
269
270 FUNCTION C_HEADER_CHARGEFORMULA(HEADER_ID IN NUMBER) RETURN NUMBER;
271
272 FUNCTION C_ACCEPT_REQUIREDFORMULA(CONTINGENCY_ID IN NUMBER) RETURN CHAR;
273
274 FUNCTION C_BILL_CONTACTFORMULA(INVOICE_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
275
276 FUNCTION C_SHIP_CONTACTFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
277
278 FUNCTION C_DEL_CONTACTFORMULA(DELIVER_TO_CONTACT_ID IN NUMBER) RETURN CHAR;
279
280 FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
281
282 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
283
284 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
285
286 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
287
288 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
289
290 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
291
292 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
293
294 FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
295
296 FUNCTION RP_CURR_PROFILE_P RETURN VARCHAR2;
297
298 FUNCTION RP_ITEM_FLEX_SEG_VAL_P RETURN VARCHAR2;
299
300 FUNCTION RP_TAX_TOTAL_ROUNDED_P RETURN NUMBER;
301
302 FUNCTION RP_LINE_CHARGE_TOTAL_ROUNDED_P RETURN NUMBER;
303
304 FUNCTION RP_HDR_CHARGE_TOTAL_ROUNDED_P RETURN NUMBER;
305
306 FUNCTION RP_HDR_CHARGE_TOTAL_P RETURN NUMBER;
307
308 FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
309 ,X_TO_CURRENCY IN VARCHAR2
310 ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
311
312 PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
313 ,X_TO_CURRENCY IN VARCHAR2
314 ,X_EFFECTIVE_DATE IN DATE
315 ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
316 ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);
317
318 FUNCTION GET_EURO_CODE RETURN VARCHAR2;
319
320 FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
321 ,X_TO_CURRENCY IN VARCHAR2
322 ,X_CONVERSION_DATE IN DATE
323 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
324
325 FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
326 ,X_FROM_CURRENCY IN VARCHAR2
327 ,X_CONVERSION_DATE IN DATE
328 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
329
330 FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
331 ,X_TO_CURRENCY IN VARCHAR2
332 ,X_CONVERSION_DATE IN DATE
333 ,X_CONVERSION_TYPE IN VARCHAR2
334 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
335
336 FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
337 ,X_FROM_CURRENCY IN VARCHAR2
338 ,X_CONVERSION_DATE IN DATE
339 ,X_CONVERSION_TYPE IN VARCHAR2
340 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
341
342 FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
343 ,PERIOD IN VARCHAR2
344 ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
345
346 FUNCTION RATE_EXISTS(X_FROM_CURRENCY IN VARCHAR2
347 ,X_TO_CURRENCY IN VARCHAR2
348 ,X_CONVERSION_DATE IN DATE
349 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN VARCHAR2;
350
351 FUNCTION BEFOREREPORT RETURN BOOLEAN;
352 FUNCTION F_PERIODICITYFORMATTRIGGER RETURN VARCHAR2;
353 FUNCTION test (abc IN VARCHAR)RETURN VARCHAR2; --Bug# 12690206
354
355 END ONT_OEXOEACK_XMLP_PKG;
356
[Home] [Help]