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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
176: ) RETURN NUMBER;
177:
178: ---START bug 14272033
179: FUNCTION RETURN_CONTEXT
180: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
181: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
182: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
183: ) RETURN NUMBER;
184:
183: ) RETURN NUMBER;
184:
185:
186: FUNCTION RETURN_ATTRIBUTE1
187: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
188: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
189: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
190: ) RETURN NUMBER;
191:
189: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
190: ) RETURN NUMBER;
191:
192: FUNCTION RETURN_ATTRIBUTE2
193: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
194: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
195: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
196: ) RETURN NUMBER;
197: ----END bug 14272033
198:
199: -- End of fix #1459428
200:
201: FUNCTION CREATED_BY
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:
205: ) RETURN NUMBER;
206:
207:
208: FUNCTION CREDIT_INVOICE_LINE
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:
212: ) RETURN NUMBER;
213:
214:
215: FUNCTION CUSTOMER_LINE_NUMBER
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:
219: ) RETURN NUMBER;
220:
221:
222: FUNCTION CUSTOMER_TRX_LINE
223: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
224: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
225: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
226: ) RETURN NUMBER;
227:
226: ) RETURN NUMBER;
227:
228:
229: FUNCTION CUST_PO_NUMBER
230: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
231: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
232: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
233: ) RETURN NUMBER;
234:
233: ) RETURN NUMBER;
234:
235: -- Added for bug #7608170
236: FUNCTION CUSTOMER_JOB
237: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
238: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
239: , x_on_operation_action OUT NOCOPY NUMBER
240: ) RETURN NUMBER;
241:
239: , x_on_operation_action OUT NOCOPY NUMBER
240: ) RETURN NUMBER;
241:
242: FUNCTION DELIVERY_LEAD_TIME
243: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
244: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
245: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
246: ) RETURN NUMBER;
247:
245: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
246: ) RETURN NUMBER;
247:
248: FUNCTION DELIVER_TO_CONTACT
249: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
250: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
251: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
252: ) RETURN NUMBER;
253:
252: ) RETURN NUMBER;
253:
254:
255: FUNCTION DELIVER_TO_ORG
256: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
257: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
258: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
259: ) RETURN NUMBER;
260:
259: ) RETURN NUMBER;
260:
261:
262: FUNCTION DEMAND_CLASS
263: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
264: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
265: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
266: ) RETURN NUMBER;
267:
265: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
266: ) RETURN NUMBER;
267:
268: FUNCTION DEP_PLAN_REQUIRED
269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
270: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
271: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
272: ) RETURN NUMBER;
273:
271: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
272: ) RETURN NUMBER;
273:
274: FUNCTION EARLIEST_ACCEPTABLE_DATE
275: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
276: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
277: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
278: ) RETURN NUMBER;
279:
277: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
278: ) RETURN NUMBER;
279:
280: FUNCTION END_ITEM_UNIT_NUMBER
281: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
282: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
283: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
284: ) RETURN NUMBER;
285:
284: ) RETURN NUMBER;
285:
286:
287: FUNCTION FOB_POINT
288: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
289: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
290: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
291: ) RETURN NUMBER;
292:
290: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
291: ) RETURN NUMBER;
292:
293: FUNCTION FREIGHT_CARRIER
294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
295: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
296: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
297: ) RETURN NUMBER;
298:
296: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
297: ) RETURN NUMBER;
298:
299: FUNCTION FREIGHT_TERMS
300: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
301: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
302: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
303: ) RETURN NUMBER;
304:
302: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
303: ) RETURN NUMBER;
304:
305: FUNCTION FULFILLED_QUANTITY
306: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
307: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
308: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
309: ) RETURN NUMBER;
310:
309: ) RETURN NUMBER;
310:
311:
312: FUNCTION INVENTORY_ITEM
313: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
314: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
315: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
316: ) RETURN NUMBER;
317:
315: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
316: ) RETURN NUMBER;
317:
318: FUNCTION INVOICE_TO_CONTACT
319: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
320: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
321: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
322: ) RETURN NUMBER;
323:
321: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
322: ) RETURN NUMBER;
323:
324: FUNCTION INVOICE_TO_ORG
325: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
326: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
327: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
328: ) RETURN NUMBER;
329:
327: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
328: ) RETURN NUMBER;
329:
330: FUNCTION INVOICING_RULE
331: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
332: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
333: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
334: ) RETURN NUMBER;
335:
333: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
334: ) RETURN NUMBER;
335:
336: FUNCTION ITEM_REVISION
337: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
338: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
339: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
340: ) RETURN NUMBER;
341:
339: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
340: ) RETURN NUMBER;
341:
342: FUNCTION ITEM_TYPE
343: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
344: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
345: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
346: ) RETURN NUMBER;
347:
346: ) RETURN NUMBER;
347:
348:
349: FUNCTION LATEST_ACCEPTABLE_DATE
350: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
351: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
352: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
353: ) RETURN NUMBER;
354:
352: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
353: ) RETURN NUMBER;
354:
355: FUNCTION LINE_CATEGORY
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:
358: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
359: ) RETURN NUMBER;
360:
361: FUNCTION LINE_NUMBER
362: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
363: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
364: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
365: ) RETURN NUMBER;
366:
364: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
365: ) RETURN NUMBER;
366:
367: FUNCTION LINE_TYPE
368: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
369: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
370: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
371: ) RETURN NUMBER;
372:
371: ) RETURN NUMBER;
372:
373:
374: FUNCTION ORDERED_QUANTITY
375: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
376: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
377: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
378: ) RETURN NUMBER;
379:
379:
380: -- OPM 1857167 start
381:
382: FUNCTION ORDERED_QUANTITY2
383: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
384: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
385: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
386: ) RETURN NUMBER;
387:
387:
388: -- OPM 1857167 end
389:
390: FUNCTION ORDER_QUANTITY_UOM
391: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
392: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
393: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
394: ) RETURN NUMBER;
395:
393: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
394: ) RETURN NUMBER;
395:
396: FUNCTION ORIG_SYS_DOCUMENT_REF
397: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
398: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
399: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
400: ) RETURN NUMBER;
401:
399: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
400: ) RETURN NUMBER;
401:
402: FUNCTION ORIG_SYS_LINE_REF
403: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
404: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
405: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
406: ) RETURN NUMBER;
407:
405: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
406: ) RETURN NUMBER;
407:
408: FUNCTION OVER_SHIP_REASON
409: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
410: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
411: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
412: ) RETURN NUMBER;
413:
411: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
412: ) RETURN NUMBER;
413:
414: FUNCTION OVER_SHIP_RESOLVED
415: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
416: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
417: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
418: ) RETURN NUMBER;
419:
417: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
418: ) RETURN NUMBER;
419:
420: FUNCTION PACKING_INSTRUCTIONS
421: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
422: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
423: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
424: ) RETURN NUMBER;
425:
423: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
424: ) RETURN NUMBER;
425:
426: FUNCTION PAYMENT_TERM
427: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
428: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
429: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
430: ) RETURN NUMBER;
431:
429: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
430: ) RETURN NUMBER;
431:
432: FUNCTION PLANNING_PRIORITY
433: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
434: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
435: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
436: ) RETURN NUMBER;
437:
435: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
436: ) RETURN NUMBER;
437:
438: FUNCTION PRICE_LIST
439: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
440: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
441: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
442: ) RETURN NUMBER;
443:
441: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
442: ) RETURN NUMBER;
443:
444: FUNCTION PRICING_DATE
445: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
446: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
447: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
448: ) RETURN NUMBER;
449:
447: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
448: ) RETURN NUMBER;
449:
450: FUNCTION PRICING_QUANTITY
451: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
452: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
453: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
454: ) RETURN NUMBER;
455:
453: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
454: ) RETURN NUMBER;
455:
456: FUNCTION PRICING_QUANTITY_UOM
457: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
458: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
459: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
460: ) RETURN NUMBER;
461:
459: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
460: ) RETURN NUMBER;
461:
462: FUNCTION PROJECT
463: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
464: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
465: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
466: ) RETURN NUMBER;
467:
465: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
466: ) RETURN NUMBER;
467:
468: FUNCTION PROMISE_DATE
469: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
470: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
471: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
472: ) RETURN NUMBER;
473:
471: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
472: ) RETURN NUMBER;
473:
474: FUNCTION REFERENCE_CUST_TRX_LINE
475: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
476: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
477: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
478: ) RETURN NUMBER;
479:
477: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
478: ) RETURN NUMBER;
479:
480: FUNCTION REFERENCE_TYPE
481: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
482: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
483: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
484: ) RETURN NUMBER;
485:
483: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
484: ) RETURN NUMBER;
485:
486: FUNCTION REQUEST_DATE
487: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
488: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
489: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
490: ) RETURN NUMBER;
491:
489: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
490: ) RETURN NUMBER;
491:
492: FUNCTION RETURN_REASON
493: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
494: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
495: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
496: ) RETURN NUMBER;
497:
495: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
496: ) RETURN NUMBER;
497:
498: FUNCTION SALESREP
499: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
500: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
501: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
502: ) RETURN NUMBER;
503:
501: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
502: ) RETURN NUMBER;
503:
504: FUNCTION SHIP_SET
505: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
506: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
507: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
508: ) RETURN NUMBER;
509:
507: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
508: ) RETURN NUMBER;
509:
510: FUNCTION ARRIVAL_SET
511: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
512: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
513: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
514: ) RETURN NUMBER;
515:
514: ) RETURN NUMBER;
515:
516:
517: FUNCTION SCHEDULE_ARRIVAL_DATE
518: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
519: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
520: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
521: ) RETURN NUMBER;
522:
520: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
521: ) RETURN NUMBER;
522:
523: FUNCTION SCHEDULE_SHIP_DATE
524: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
525: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
526: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
527: ) RETURN NUMBER;
528:
527: ) RETURN NUMBER;
528:
529:
530: FUNCTION SHIPMENT_NUMBER
531: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
532: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
533: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
534: ) RETURN NUMBER;
535:
533: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
534: ) RETURN NUMBER;
535:
536: FUNCTION SHIPMENT_PRIORITY
537: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
538: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
539: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
540: ) RETURN NUMBER;
541:
539: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
540: ) RETURN NUMBER;
541:
542: FUNCTION SHIPPED_QUANTITY
543: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
544: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
545: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
546: ) RETURN NUMBER;
547:
545: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
546: ) RETURN NUMBER;
547:
548: FUNCTION SHIPPING_INSTRUCTIONS
549: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
550: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
551: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
552: ) RETURN NUMBER;
553:
551: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
552: ) RETURN NUMBER;
553:
554: FUNCTION SHIPPING_METHOD
555: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
556: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
557: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
558: ) RETURN NUMBER;
559:
557: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
558: ) RETURN NUMBER;
559:
560: FUNCTION SHIPPING_QUANTITY
561: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
562: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
563: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
564: ) RETURN NUMBER;
565:
563: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
564: ) RETURN NUMBER;
565:
566: FUNCTION SHIPPING_QUANTITY_UOM
567: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
568: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
569: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
570: ) RETURN NUMBER;
571:
569: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
570: ) RETURN NUMBER;
571:
572: FUNCTION SHIPPING_QUANTITY_UOM2 -- INVCONV
573: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
574: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
575: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
576: ) RETURN NUMBER;
577:
575: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
576: ) RETURN NUMBER;
577:
578: FUNCTION SHIP_FROM_ORG
579: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
580: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
581: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
582: ) RETURN NUMBER;
583:
581: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
582: ) RETURN NUMBER;
583:
584: FUNCTION SUBINVENTORY
585: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
586: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
587: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
588: ) RETURN NUMBER;
589:
587: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
588: ) RETURN NUMBER;
589:
590: FUNCTION SHIP_MODEL_COMPLETE
591: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
592: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
593: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
594: ) RETURN NUMBER;
595:
593: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
594: ) RETURN NUMBER;
595:
596: FUNCTION SHIP_TOLERANCE_ABOVE
597: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
598: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
599: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
600: ) RETURN NUMBER;
601:
599: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
600: ) RETURN NUMBER;
601:
602: FUNCTION SHIP_TOLERANCE_BELOW
603: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
604: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
605: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
606: ) RETURN NUMBER;
607:
605: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
606: ) RETURN NUMBER;
607:
608: FUNCTION SHIP_TO_CONTACT
609: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
610: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
611: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
612: ) RETURN NUMBER;
613:
611: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
612: ) RETURN NUMBER;
613:
614: FUNCTION SHIP_TO_ORG
615: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
616: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
617: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
618: ) RETURN NUMBER;
619:
617: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
618: ) RETURN NUMBER;
619:
620: FUNCTION SOLD_TO_ORG
621: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
622: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
623: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
624: ) RETURN NUMBER;
625:
623: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
624: ) RETURN NUMBER;
625:
626: FUNCTION SOURCE_DOCUMENT_TYPE
627: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
628: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
629: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
630: ) RETURN NUMBER;
631:
629: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
630: ) RETURN NUMBER;
631:
632: FUNCTION SOURCE_TYPE
633: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
634: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
635: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
636: ) RETURN NUMBER;
637:
635: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
636: ) RETURN NUMBER;
637:
638: FUNCTION TASK
639: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
640: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
641: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
642: ) RETURN NUMBER;
643:
641: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
642: ) RETURN NUMBER;
643:
644: FUNCTION TAX
645: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
646: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
647: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
648: ) RETURN NUMBER;
649:
647: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
648: ) RETURN NUMBER;
649:
650: FUNCTION TAX_DATE
651: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
652: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
653: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
654: ) RETURN NUMBER;
655:
653: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
654: ) RETURN NUMBER;
655:
656: FUNCTION TAX_EXEMPT
657: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
658: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
659: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
660: ) RETURN NUMBER;
661:
659: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
660: ) RETURN NUMBER;
661:
662: FUNCTION TAX_EXEMPT_NUMBER
663: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
664: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
665: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
666: ) RETURN NUMBER;
667:
665: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
666: ) RETURN NUMBER;
667:
668: FUNCTION TAX_EXEMPT_REASON
669: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
670: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
671: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
672: ) RETURN NUMBER;
673:
671: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
672: ) RETURN NUMBER;
673:
674: FUNCTION UNIT_LIST_PRICE
675: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
676: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
677: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
678: ) RETURN NUMBER;
679:
677: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
678: ) RETURN NUMBER;
679:
680: FUNCTION UNIT_SELLING_PRICE
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:
684: ) RETURN NUMBER;
685:
686:
687: FUNCTION SERVICE_REFERENCE_TYPE
688: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
689: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
690: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
691: ) RETURN NUMBER;
692:
690: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
691: ) RETURN NUMBER;
692:
693: FUNCTION SERVICE_REFERENCE_LINE
694: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
695: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
696: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
697: ) RETURN NUMBER;
698:
696: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
697: ) RETURN NUMBER;
698:
699: FUNCTION SERVICE_REFERENCE_SYSTEM
700: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
701: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
702: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
703: ) RETURN NUMBER;
704:
704:
705: /* Fix to bug 2205900: Added constraints functions for
706: some missing SERVICE fields */
707: FUNCTION SERVICE_COTERMINATE
708: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
709: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
710: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
711: ) RETURN NUMBER;
712:
710: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
711: ) RETURN NUMBER;
712:
713: FUNCTION SERVICE_DURATION
714: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
715: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
716: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
717: ) RETURN NUMBER;
718:
716: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
717: ) RETURN NUMBER;
718:
719: FUNCTION SERVICE_END_DATE
720: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
721: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
722: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
723: ) RETURN NUMBER;
724:
722: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
723: ) RETURN NUMBER;
724:
725: FUNCTION SERVICE_PERIOD
726: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
727: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
728: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
729: ) RETURN NUMBER;
730:
728: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
729: ) RETURN NUMBER;
730:
731: FUNCTION SERVICE_START_DATE
732: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
733: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
734: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
735: ) RETURN NUMBER;
736:
734: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
735: ) RETURN NUMBER;
736:
737: FUNCTION SERVICE_TXN_COMMENTS
738: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
739: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
740: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
741: ) RETURN NUMBER;
742:
740: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
741: ) RETURN NUMBER;
742:
743: FUNCTION SERVICE_TXN_REASON
744: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
745: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
746: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
747: ) RETURN NUMBER;
748:
747: ) RETURN NUMBER;
748:
749: /*1449220*/
750: FUNCTION ITEM_IDENTIFIER_TYPE
751: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
752: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
753: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
754: ) RETURN NUMBER;
755: /*1449220*/
754: ) RETURN NUMBER;
755: /*1449220*/
756:
757: FUNCTION USER_ITEM_DESCRIPTION
758: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
759: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
760: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
761: ) RETURN NUMBER;
762:
760: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
761: ) RETURN NUMBER;
762:
763: FUNCTION BLANKET_NUMBER
764: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
765: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
766: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
767: ) RETURN NUMBER;
768:
766: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
767: ) RETURN NUMBER;
768:
769: FUNCTION BLANKET_LINE_NUMBER
770: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
771: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
772: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
773: ) RETURN NUMBER;
774:
772: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
773: ) RETURN NUMBER;
774:
775: FUNCTION IB_OWNER
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: ) RETURN NUMBER;
780:
778: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
779: ) RETURN NUMBER;
780:
781: FUNCTION IB_INSTALLED_AT_LOCATION
782: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
783: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
784: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
785: ) RETURN NUMBER;
786:
784: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
785: ) RETURN NUMBER;
786:
787: FUNCTION IB_CURRENT_LOCATION
788: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
789: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
790: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
791: ) RETURN NUMBER;
792:
791: ) RETURN NUMBER;
792:
793:
794: FUNCTION END_CUSTOMER
795: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
796: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
797: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
798:
799: ) RETURN NUMBER;
799: ) RETURN NUMBER;
800:
801:
802: FUNCTION END_CUSTOMER_CONTACT
803: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
804: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
805: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
806:
807: ) RETURN NUMBER;
807: ) RETURN NUMBER;
808:
809:
810: FUNCTION END_CUSTOMER_SITE_USE
811: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
812: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
813: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
814:
815: ) RETURN NUMBER;
847: , x_return_status OUT NOCOPY VARCHAR2 /* file.sql.39 change */
848: );
849:
850: FUNCTION CONTINGENCY
851: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
852: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
853: , x_on_operation_action OUT NOCOPY NUMBER
854: ) RETURN NUMBER;
855:
853: , x_on_operation_action OUT NOCOPY NUMBER
854: ) RETURN NUMBER;
855:
856: FUNCTION REVREC_EXPIRATION_DAYS
857: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
858: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
859: , x_on_operation_action OUT NOCOPY NUMBER
860: ) RETURN NUMBER;
861: