DBA Data[Home] [Help]

PACKAGE: APPS.OE_LINE_SECURITY

Source


1 PACKAGE OE_Line_Security AS
2 /* $Header: OEXXLINS.pls 120.6.12000000.1 2007/01/16 22:15:23 appldev ship $ */
3 
4 
5 -- Package Globals
6 g_check_all_cols_constraint VARCHAR2(1) := 'Y';
7 g_is_caller_defaulting      VARCHAR2(1) := 'N';
8 -- Entity global record that is used in APIs for validation templates
9 -- and the generated validation packages to access attribute values
10 -- on the entity record
11 g_record				   OE_AK_ORDER_LINES_V%ROWTYPE;
12 g_operation_action		   NUMBER;
13 
14 FUNCTION ACCOUNTING_RULE
15 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
16 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
17 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
18 ) RETURN NUMBER;
19 
20 FUNCTION ACCOUNTING_RULE_DURATION
21 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
22 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
23 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
24 ) RETURN NUMBER;
25 
26 FUNCTION calculate_price_flag(p_operation IN        VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
27                              ,p_record              IN oe_ak_order_lines_v%ROWTYPE
28                              ,x_on_operation_action OUT NOCOPY NUMBER)
29 RETURN NUMBER;
30 
31 FUNCTION COMMITMENT_ID
32 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
33 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
34 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
35 ) RETURN NUMBER;
36 
37 FUNCTION AGREEMENT
38 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
39 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
40 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
41 ) RETURN NUMBER;
42 
43 FUNCTION AUTHORIZED_TO_SHIP
44 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
45 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
46 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
47 ) RETURN NUMBER;
48 
49 -- Start of fix #1459428
50 
51 FUNCTION ATTRIBUTE1
52 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
53 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
54 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
55 ) RETURN NUMBER;
56 
57 FUNCTION ATTRIBUTE10
58 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
59 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
60 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
61 ) RETURN NUMBER;
62 
63 FUNCTION ATTRIBUTE11
64 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
65 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
66 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
67 ) RETURN NUMBER;
68 
69 FUNCTION ATTRIBUTE12
70 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
71 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
72 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
73 ) RETURN NUMBER;
74 
75 FUNCTION ATTRIBUTE13
76 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
77 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
78 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
79 ) RETURN NUMBER;
80 
81 FUNCTION ATTRIBUTE14
82 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
83 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
84 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
85 ) RETURN NUMBER;
86 
87 FUNCTION ATTRIBUTE15
88 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
89 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
90 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
91 ) RETURN NUMBER;
92 
93 -- For bug 2184255
94 FUNCTION ATTRIBUTE16
95 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
96 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
97 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
98 ) RETURN NUMBER;
99 
100 FUNCTION ATTRIBUTE17
101 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
102 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
103 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
104 ) RETURN NUMBER;
105 
106 FUNCTION ATTRIBUTE18
107 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
108 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
109 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
110 ) RETURN NUMBER;
111 
112 FUNCTION ATTRIBUTE19
113 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
114 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
115 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
116 ) RETURN NUMBER;
117 
118 FUNCTION ATTRIBUTE2
119 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
120 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
121 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
122 ) RETURN NUMBER;
123 
124 FUNCTION ATTRIBUTE20
125 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
126 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
127 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
128 ) RETURN NUMBER;
129 
130 FUNCTION ATTRIBUTE3
131 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
132 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
133 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
134 ) RETURN NUMBER;
135 
136 FUNCTION ATTRIBUTE4
137 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
138 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
139 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
140 ) RETURN NUMBER;
141 
142 FUNCTION ATTRIBUTE5
143 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
144 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
145 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
146 ) RETURN NUMBER;
147 
148 FUNCTION ATTRIBUTE6
149 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
150 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
151 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
152 ) RETURN NUMBER;
153 
154 FUNCTION ATTRIBUTE7
155 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
156 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
157 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
158 ) RETURN NUMBER;
159 
160 FUNCTION ATTRIBUTE8
161 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
162 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
163 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
164 ) RETURN NUMBER;
165 
166 FUNCTION ATTRIBUTE9
167 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
168 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
169 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
170 ) RETURN NUMBER;
171 
172 FUNCTION CONTEXT
173 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
174 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
175 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
176 ) RETURN NUMBER;
177 
178 --  End of fix #1459428
179 
180 FUNCTION CREATED_BY
181 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
182 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
183 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
184 ) RETURN NUMBER;
185 
186 
187 FUNCTION CREDIT_INVOICE_LINE
188 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
189 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
190 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
191 ) RETURN NUMBER;
192 
193 
194 FUNCTION CUSTOMER_LINE_NUMBER
195 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
196 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
197 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
198 ) RETURN NUMBER;
199 
200 
201 FUNCTION CUSTOMER_TRX_LINE
202 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
203 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
204 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
205 ) RETURN NUMBER;
206 
207 
208 FUNCTION CUST_PO_NUMBER
209 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
210 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
211 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
212 ) RETURN NUMBER;
213 
214 
215 FUNCTION DELIVERY_LEAD_TIME
216 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
217 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
218 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
219 ) RETURN NUMBER;
220 
221 FUNCTION DELIVER_TO_CONTACT
222 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
223 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
224 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
225 ) RETURN NUMBER;
226 
227 
228 FUNCTION DELIVER_TO_ORG
229 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
230 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
231 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
232 ) RETURN NUMBER;
233 
234 
235 FUNCTION DEMAND_CLASS
236 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
237 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
238 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
239 ) RETURN NUMBER;
240 
241 FUNCTION DEP_PLAN_REQUIRED
242 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
243 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
244 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
245 ) RETURN NUMBER;
246 
247 FUNCTION EARLIEST_ACCEPTABLE_DATE
248 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
249 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
250 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
251 ) RETURN NUMBER;
252 
253 FUNCTION END_ITEM_UNIT_NUMBER
254 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
255 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
256 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
257 ) RETURN NUMBER;
258 
259 
260 FUNCTION FOB_POINT
261 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
262 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
263 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
264 ) RETURN NUMBER;
265 
266 FUNCTION FREIGHT_CARRIER
267 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
268 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
269 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
270 ) RETURN NUMBER;
271 
272 FUNCTION FREIGHT_TERMS
273 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
274 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
275 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
276 ) RETURN NUMBER;
277 
278 FUNCTION FULFILLED_QUANTITY
279 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
280 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
281 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
282 ) RETURN NUMBER;
283 
284 
285 FUNCTION INVENTORY_ITEM
286 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
287 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
288 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
289 ) RETURN NUMBER;
290 
291 FUNCTION INVOICE_TO_CONTACT
292 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
293 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
294 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
295 ) RETURN NUMBER;
296 
297 FUNCTION INVOICE_TO_ORG
298 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
299 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
300 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
301 ) RETURN NUMBER;
302 
303 FUNCTION INVOICING_RULE
304 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
305 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
306 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
307 ) RETURN NUMBER;
308 
309 FUNCTION ITEM_REVISION
310 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
311 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
312 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
313 ) RETURN NUMBER;
314 
315 FUNCTION ITEM_TYPE
316 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
317 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
318 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
319 ) RETURN NUMBER;
320 
321 
322 FUNCTION LATEST_ACCEPTABLE_DATE
323 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
324 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
325 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
326 ) RETURN NUMBER;
327 
328 FUNCTION LINE_CATEGORY
329 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
330 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
331 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
332 ) RETURN NUMBER;
333 
334 FUNCTION LINE_NUMBER
335 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
336 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
337 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
338 ) RETURN NUMBER;
339 
340 FUNCTION LINE_TYPE
341 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
342 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
343 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
347 FUNCTION ORDERED_QUANTITY
344 ) RETURN NUMBER;
345 
346 
348 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
349 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
350 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
351 ) RETURN NUMBER;
352 
353 -- OPM 1857167 start
354 
355 FUNCTION ORDERED_QUANTITY2
356 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
357 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
358 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
359 ) RETURN NUMBER;
360 
361 -- OPM 1857167 end
362 
363 FUNCTION ORDER_QUANTITY_UOM
364 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
365 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
366 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
367 ) RETURN NUMBER;
368 
369 FUNCTION ORIG_SYS_DOCUMENT_REF
370 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
371 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
372 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
373 ) RETURN NUMBER;
374 
375 FUNCTION ORIG_SYS_LINE_REF
376 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
377 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
378 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
379 ) RETURN NUMBER;
380 
381 FUNCTION OVER_SHIP_REASON
382 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
383 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
384 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
385 ) RETURN NUMBER;
386 
387 FUNCTION OVER_SHIP_RESOLVED
388 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
389 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
390 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
391 ) RETURN NUMBER;
392 
393 FUNCTION PACKING_INSTRUCTIONS
394 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
395 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
396 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
397 ) RETURN NUMBER;
398 
399 FUNCTION PAYMENT_TERM
400 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
401 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
402 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
403 ) RETURN NUMBER;
404 
405 FUNCTION PLANNING_PRIORITY
406 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
407 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
408 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
409 ) RETURN NUMBER;
410 
411 FUNCTION PRICE_LIST
412 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
413 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
414 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
415 ) RETURN NUMBER;
416 
417 FUNCTION PRICING_DATE
418 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
419 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
420 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
421 ) RETURN NUMBER;
422 
423 FUNCTION PRICING_QUANTITY
424 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
425 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
426 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
427 ) RETURN NUMBER;
428 
429 FUNCTION PRICING_QUANTITY_UOM
430 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
431 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
432 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
433 ) RETURN NUMBER;
434 
435 FUNCTION PROJECT
436 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
437 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
438 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
439 ) RETURN NUMBER;
440 
441 FUNCTION PROMISE_DATE
442 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
443 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
444 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
445 ) RETURN NUMBER;
446 
447 FUNCTION REFERENCE_CUST_TRX_LINE
448 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
449 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
450 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
451 ) RETURN NUMBER;
452 
453 FUNCTION REFERENCE_TYPE
454 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
455 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
456 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
457 ) RETURN NUMBER;
458 
459 FUNCTION REQUEST_DATE
460 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
464 
461 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
462 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
463 ) RETURN NUMBER;
465 FUNCTION RETURN_REASON
466 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
467 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
468 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
469 ) RETURN NUMBER;
470 
471 FUNCTION SALESREP
472 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
473 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
474 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
475 ) RETURN NUMBER;
476 
477 FUNCTION SHIP_SET
478 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
479 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
480 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
481 ) RETURN NUMBER;
482 
483 FUNCTION ARRIVAL_SET
484 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
485 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
486 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
487 ) RETURN NUMBER;
488 
489 
490 FUNCTION SCHEDULE_ARRIVAL_DATE
491 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
492 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
493 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
494 ) RETURN NUMBER;
495 
496 FUNCTION SCHEDULE_SHIP_DATE
497 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
498 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
499 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
500 ) RETURN NUMBER;
501 
502 
503 FUNCTION SHIPMENT_NUMBER
504 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
505 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
506 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
507 ) RETURN NUMBER;
508 
509 FUNCTION SHIPMENT_PRIORITY
510 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
511 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
512 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
513 ) RETURN NUMBER;
514 
515 FUNCTION SHIPPED_QUANTITY
516 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
517 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
518 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
519 ) RETURN NUMBER;
520 
521 FUNCTION SHIPPING_INSTRUCTIONS
522 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
523 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
524 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
525 ) RETURN NUMBER;
526 
527 FUNCTION SHIPPING_METHOD
528 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
529 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
530 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
531 ) RETURN NUMBER;
532 
533 FUNCTION SHIPPING_QUANTITY
534 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
535 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
536 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
537 ) RETURN NUMBER;
538 
539 FUNCTION SHIPPING_QUANTITY_UOM
540 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
541 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
542 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
543 ) RETURN NUMBER;
544 
545 FUNCTION SHIPPING_QUANTITY_UOM2  -- INVCONV
546 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
547 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
548 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
549 ) RETURN NUMBER;
550 
551 FUNCTION SHIP_FROM_ORG
552 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
553 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
554 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
555 ) RETURN NUMBER;
556 
557 FUNCTION SUBINVENTORY
558 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
559 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
560 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
561 ) RETURN NUMBER;
562 
563 FUNCTION SHIP_MODEL_COMPLETE
564 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
565 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
566 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
567 ) RETURN NUMBER;
568 
569 FUNCTION SHIP_TOLERANCE_ABOVE
570 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
571 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
572 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
573 ) RETURN NUMBER;
574 
578 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
575 FUNCTION SHIP_TOLERANCE_BELOW
576 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
577 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
579 ) RETURN NUMBER;
580 
581 FUNCTION SHIP_TO_CONTACT
582 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
583 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
584 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
585 ) RETURN NUMBER;
586 
587 FUNCTION SHIP_TO_ORG
588 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
589 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
590 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
591 ) RETURN NUMBER;
592 
593 FUNCTION SOLD_TO_ORG
594 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
595 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
596 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
597 ) RETURN NUMBER;
598 
599 FUNCTION SOURCE_DOCUMENT_TYPE
600 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
601 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
602 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
603 ) RETURN NUMBER;
604 
605 FUNCTION SOURCE_TYPE
606 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
607 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
608 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
609 ) RETURN NUMBER;
610 
611 FUNCTION TASK
612 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
613 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
614 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
615 ) RETURN NUMBER;
616 
617 FUNCTION TAX
618 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
619 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
620 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
621 ) RETURN NUMBER;
622 
623 FUNCTION TAX_DATE
624 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
625 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
626 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
627 ) RETURN NUMBER;
628 
629 FUNCTION TAX_EXEMPT
630 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
631 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
632 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
633 ) RETURN NUMBER;
634 
635 FUNCTION TAX_EXEMPT_NUMBER
636 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
637 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
638 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
639 ) RETURN NUMBER;
640 
641 FUNCTION TAX_EXEMPT_REASON
642 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
643 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
644 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
645 ) RETURN NUMBER;
646 
647 FUNCTION UNIT_LIST_PRICE
648 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
649 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
650 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
651 ) RETURN NUMBER;
652 
653 FUNCTION UNIT_SELLING_PRICE
654 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
655 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
656 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
657 ) RETURN NUMBER;
658 
659 
660 FUNCTION SERVICE_REFERENCE_TYPE
661 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
662 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
663 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
664 ) RETURN NUMBER;
665 
666 FUNCTION SERVICE_REFERENCE_LINE
667 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
668 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
669 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
670 ) RETURN NUMBER;
671 
672 FUNCTION SERVICE_REFERENCE_SYSTEM
673 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
674 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
675 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
676 ) RETURN NUMBER;
677 
678 /* Fix to bug 2205900: Added constraints functions for
679 some missing SERVICE fields */
680 FUNCTION SERVICE_COTERMINATE
681 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
682 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
683 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
684 ) RETURN NUMBER;
685 
686 FUNCTION SERVICE_DURATION
687 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
691 
688 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
689 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
690 ) RETURN NUMBER;
692 FUNCTION SERVICE_END_DATE
693 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
694 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
695 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
696 ) RETURN NUMBER;
697 
698 FUNCTION SERVICE_PERIOD
699 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
700 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
701 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
702 ) RETURN NUMBER;
703 
704 FUNCTION SERVICE_START_DATE
705 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
706 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
707 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
708 ) RETURN NUMBER;
709 
710 FUNCTION SERVICE_TXN_COMMENTS
711 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
712 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
713 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
714 ) RETURN NUMBER;
715 
716 FUNCTION SERVICE_TXN_REASON
717 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
718 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
719 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
720 ) RETURN NUMBER;
721 
722 /*1449220*/
723 FUNCTION ITEM_IDENTIFIER_TYPE
724 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
725 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
726 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
727 ) RETURN NUMBER;
728 /*1449220*/
729 
730 FUNCTION USER_ITEM_DESCRIPTION
731 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
732 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
733 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
734 ) RETURN NUMBER;
735 
736 FUNCTION BLANKET_NUMBER
737 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
738 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
739 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
740 ) RETURN NUMBER;
741 
742 FUNCTION BLANKET_LINE_NUMBER
743 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
744 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
745 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
746 ) RETURN NUMBER;
747 
748 FUNCTION IB_OWNER
749 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
750 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
751 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
752 ) RETURN NUMBER;
753 
754 FUNCTION IB_INSTALLED_AT_LOCATION
755 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
756 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
757 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
758 ) RETURN NUMBER;
759 
760 FUNCTION IB_CURRENT_LOCATION
761 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
762 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
763 ,   x_on_operation_action           OUT NOCOPY NUMBER  /* file.sql.39 change */
764 ) RETURN NUMBER;
765 
766 
767 FUNCTION END_CUSTOMER
768 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
769 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
770 , x_on_operation_action OUT NOCOPY NUMBER  /* file.sql.39 change */
771 
772 ) RETURN NUMBER;
773 
774 
775 FUNCTION END_CUSTOMER_CONTACT
776 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
777 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
778 , x_on_operation_action OUT NOCOPY NUMBER  /* file.sql.39 change */
779 
780 ) RETURN NUMBER;
781 
782 
783 FUNCTION END_CUSTOMER_SITE_USE
784 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
785 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
786 , x_on_operation_action OUT NOCOPY NUMBER  /* file.sql.39 change */
787 
788 ) RETURN NUMBER;
789 
790 PROCEDURE ALLOW_TAX_CODE_OVERRIDE
791 ( p_application_id                  IN NUMBER,
792   p_entity_short_name               IN VARCHAR2,
793   p_validation_entity_short_name    IN VARCHAR2,
794   p_validation_tmplt_short_name     IN VARCHAR2,
795   p_record_set_tmplt_short_name     IN VARCHAR2,
796   p_scope                           IN VARCHAR2,
797   p_result                          OUT NOCOPY NUMBER  /* file.sql.39 change */
798 );
799 
800 PROCEDURE ALLOW_TRX_LINE_EXEMPTIONS
801 ( p_application_id                  IN NUMBER,
802   p_entity_short_name               IN VARCHAR2,
803   p_validation_entity_short_name    IN VARCHAR2,
804   p_validation_tmplt_short_name     IN VARCHAR2,
805   p_record_set_tmplt_short_name     IN VARCHAR2,
809 
806   p_scope                           IN VARCHAR2,
807   p_result                          OUT NOCOPY NUMBER  /* file.sql.39 change */
808 );
810 PROCEDURE Entity
811 (   p_LINE_rec                      IN  OE_Order_PUB.LINE_Rec_Type
812 ,   x_result                        OUT NOCOPY NUMBER  /* file.sql.39 change */
813 ,   x_return_status                 OUT NOCOPY VARCHAR2  /* file.sql.39 change */
814 );
815 
816 PROCEDURE Attributes
817 (   p_LINE_rec                      IN  OE_Order_PUB.LINE_Rec_Type
818 ,   p_old_LINE_rec                  IN  OE_Order_PUB.LINE_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
819 ,   x_result                        OUT NOCOPY NUMBER  /* file.sql.39 change */
820 ,   x_return_status                 OUT NOCOPY VARCHAR2  /* file.sql.39 change */
821 );
822 
823 FUNCTION CONTINGENCY
824 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
825 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
826 ,   x_on_operation_action           OUT NOCOPY NUMBER
827 ) RETURN NUMBER;
828 
829 FUNCTION REVREC_EXPIRATION_DAYS
830 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
831 ,   p_record                        IN  OE_AK_ORDER_LINES_V%ROWTYPE
832 ,   x_on_operation_action           OUT NOCOPY NUMBER
833 ) RETURN NUMBER;
834 
835 END OE_Line_Security;