eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_SECURITY dependencies on OE_AK_ORDER_LINES_V

Line 11: g_record OE_AK_ORDER_LINES_V%ROWTYPE;

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

Line 16: , p_record IN 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

Line 22: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 27: ,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

Line 33: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 39: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 45: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 53: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 59: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 65: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 71: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 77: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 83: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 89: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 96: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 102: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 108: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 114: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 120: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 126: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 132: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 138: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 144: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 150: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 156: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 162: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 168: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 174: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 182: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 189: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 196: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 203: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 210: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 217: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 223: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 230: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 237: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 243: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 249: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 255: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 262: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 268: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 274: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 280: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 287: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 293: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 299: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 305: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 311: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 317: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 324: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 330: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 336: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 342: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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 */
344: ) RETURN NUMBER;
345:
346:

Line 349: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

345:
346:
347: FUNCTION ORDERED_QUANTITY
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

Line 357: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 365: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 371: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 377: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 383: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 389: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 395: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 401: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 407: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 413: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 419: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 425: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 431: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 437: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 443: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 449: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 455: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 461: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

457: ) RETURN NUMBER;
458:
459: FUNCTION REQUEST_DATE
460: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
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;
464:
465: FUNCTION RETURN_REASON

Line 467: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

463: ) RETURN NUMBER;
464:
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

Line 473: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 479: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 485: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 492: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 498: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 505: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 511: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 517: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 523: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 529: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 535: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 541: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 547: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 553: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 559: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 565: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 571: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:
575: FUNCTION SHIP_TOLERANCE_BELOW

Line 577: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

573: ) RETURN NUMBER;
574:
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
578: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
579: ) RETURN NUMBER;
580:
581: FUNCTION SHIP_TO_CONTACT

Line 583: , 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

Line 589: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 595: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 601: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 607: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 613: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 619: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 625: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 631: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 637: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 643: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 649: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 655: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 662: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 668: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 674: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 682: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 688: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

684: ) RETURN NUMBER;
685:
686: FUNCTION SERVICE_DURATION
687: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
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;
691:
692: FUNCTION SERVICE_END_DATE

Line 694: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

690: ) RETURN NUMBER;
691:
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

Line 700: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 706: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 712: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 718: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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*/

Line 725: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 732: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 738: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 744: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 750: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 756: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 762: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 769: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 777: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 785: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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:

Line 825: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 831: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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;