[Home] [Help]
PACKAGE: APPS.OE_BLANKET_LINE_SECURITY
Source
1 PACKAGE OE_Blanket_Line_Security AS
2 /* $Header: OEXXBLNS.pls 120.2 2007/10/31 06:50:16 smmathew noship $ */
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_BLANKET_LINES_V%ROWTYPE;
12
13 FUNCTION ACCOUNTING_RULE
14 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
15 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
16 , x_on_operation_action OUT NOCOPY NUMBER
17 ) RETURN NUMBER;
18
19 FUNCTION CUST_PO_NUMBER
20 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
21 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
22 , x_on_operation_action OUT NOCOPY NUMBER
23 ) RETURN NUMBER;
24
25 FUNCTION DELIVER_TO_ORG
26 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
27 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
28 , x_on_operation_action OUT NOCOPY NUMBER
29 ) RETURN NUMBER;
30
31 FUNCTION FREIGHT_TERMS
32 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
33 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
34 , x_on_operation_action OUT NOCOPY NUMBER
35 ) RETURN NUMBER;
36
37 FUNCTION INVENTORY_ITEM
38 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
39 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
40 , x_on_operation_action OUT NOCOPY NUMBER
41 ) RETURN NUMBER;
42
43 FUNCTION INVOICE_TO_ORG
44 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
45 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
46 , x_on_operation_action OUT NOCOPY NUMBER
47 ) RETURN NUMBER;
48
49 FUNCTION INVOICING_RULE
50 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
51 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
52 , x_on_operation_action OUT NOCOPY NUMBER
53 ) RETURN NUMBER;
54
55 FUNCTION LINE_NUMBER
56 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
57 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
58 , x_on_operation_action OUT NOCOPY NUMBER
59 ) RETURN NUMBER;
60
61 FUNCTION ORDER_QUANTITY_UOM
62 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
63 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
64 , x_on_operation_action OUT NOCOPY NUMBER
65 ) RETURN NUMBER;
66
67 FUNCTION PACKING_INSTRUCTIONS
68 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
69 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
70 , x_on_operation_action OUT NOCOPY NUMBER
71 ) RETURN NUMBER;
72
73 FUNCTION PAYMENT_TERM
74 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
75 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
76 , x_on_operation_action OUT NOCOPY NUMBER
77 ) RETURN NUMBER;
78
79 FUNCTION PRICE_LIST
80 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
81 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
82 , x_on_operation_action OUT NOCOPY NUMBER
83 ) RETURN NUMBER;
84
85 FUNCTION PRICING_QUANTITY_UOM
86 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
87 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
88 , x_on_operation_action OUT NOCOPY NUMBER
89 ) RETURN NUMBER;
90
91 FUNCTION SALESREP
92 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
93 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
94 , x_on_operation_action OUT NOCOPY NUMBER
95 ) RETURN NUMBER;
96
97 FUNCTION SHIPPING_INSTRUCTIONS
98 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
99 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
100 , x_on_operation_action OUT NOCOPY NUMBER
101 ) RETURN NUMBER;
102
103 FUNCTION SHIPPING_METHOD
104 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
105 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
106 , x_on_operation_action OUT NOCOPY NUMBER
107 ) RETURN NUMBER;
108
109 FUNCTION SHIP_FROM_ORG
110 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
111 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
112 , x_on_operation_action OUT NOCOPY NUMBER
113 ) RETURN NUMBER;
114
115 FUNCTION SHIP_TO_ORG
116 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
117 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
118 , x_on_operation_action OUT NOCOPY NUMBER
119 ) RETURN NUMBER;
120
121 FUNCTION UNIT_LIST_PRICE
122 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
123 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
124 , x_on_operation_action OUT NOCOPY NUMBER
125 ) RETURN NUMBER;
126
127 /*1449220*/
128 FUNCTION ITEM_IDENTIFIER_TYPE
129 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
130 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
131 , x_on_operation_action OUT NOCOPY NUMBER
132 ) RETURN NUMBER;
133 /*1449220*/
134
135 FUNCTION START_DATE_ACTIVE
136 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
137 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
138 , x_on_operation_action OUT NOCOPY NUMBER
139 ) RETURN NUMBER;
140
141 FUNCTION END_DATE_ACTIVE
142 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
143 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
144 , x_on_operation_action OUT NOCOPY NUMBER
145 ) RETURN NUMBER;
146
147 FUNCTION PREFERRED_GRADE
148 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
149 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
150 , x_on_operation_action OUT NOCOPY NUMBER
151 ) RETURN NUMBER;
152
153 FUNCTION ENFORCE_SHIP_TO_FLAG
154 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
155 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
156 , x_on_operation_action OUT NOCOPY NUMBER
157 ) RETURN NUMBER;
158
159 FUNCTION ENFORCE_FREIGHT_TERM_FLAG
160 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
161 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
162 , x_on_operation_action OUT NOCOPY NUMBER
163 ) RETURN NUMBER;
164
165 FUNCTION ENFORCE_SHIPPING_METHOD_FLAG
166 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
167 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
168 , x_on_operation_action OUT NOCOPY NUMBER
169 ) RETURN NUMBER;
170
171 FUNCTION ENFORCE_INVOICE_TO_FLAG
172 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
173 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
174 , x_on_operation_action OUT NOCOPY NUMBER
175 ) RETURN NUMBER;
176
177 FUNCTION ENFORCE_PRICE_LIST_FLAG
178 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
179 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
180 , x_on_operation_action OUT NOCOPY NUMBER
181 ) RETURN NUMBER;
182
183 FUNCTION ENFORCE_PAYMENT_TERM_FLAG
184 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
185 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
186 , x_on_operation_action OUT NOCOPY NUMBER
187 ) RETURN NUMBER;
188
189 FUNCTION ENFORCE_ACCOUNTING_RULE_FLAG
190 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
191 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
192 , x_on_operation_action OUT NOCOPY NUMBER
193 ) RETURN NUMBER;
194
195 FUNCTION ENFORCE_INVOICING_RULE_FLAG
196 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
197 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
198 , x_on_operation_action OUT NOCOPY NUMBER
199 ) RETURN NUMBER;
200
201 FUNCTION BLANKET_LINE_MIN_AMOUNT
202 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
203 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
204 , x_on_operation_action OUT NOCOPY NUMBER
205 ) RETURN NUMBER;
206
207 FUNCTION BLANKET_LINE_MAX_AMOUNT
208 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
209 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
210 , x_on_operation_action OUT NOCOPY NUMBER
211 ) RETURN NUMBER;
212
213 FUNCTION BLANKET_MIN_QUANTITY
214 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
215 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
216 , x_on_operation_action OUT NOCOPY NUMBER
217 ) RETURN NUMBER;
218
219 FUNCTION BLANKET_MAX_QUANTITY
220 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
221 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
222 , x_on_operation_action OUT NOCOPY NUMBER
223 ) RETURN NUMBER;
224
225 FUNCTION MIN_RELEASE_AMOUNT
226 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
227 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
228 , x_on_operation_action OUT NOCOPY NUMBER
229 ) RETURN NUMBER;
230
231 FUNCTION MAX_RELEASE_AMOUNT
232 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
233 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
234 , x_on_operation_action OUT NOCOPY NUMBER
235 ) RETURN NUMBER;
236
237 FUNCTION MIN_RELEASE_QUANTITY
238 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
239 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
240 , x_on_operation_action OUT NOCOPY NUMBER
241 ) RETURN NUMBER;
242
243 FUNCTION MAX_RELEASE_QUANTITY
244 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
245 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
246 , x_on_operation_action OUT NOCOPY NUMBER
247 ) RETURN NUMBER;
248
249 FUNCTION OVERRIDE_BLANKET_CONTROLS_FLAG
250 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
251 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
252 , x_on_operation_action OUT NOCOPY NUMBER
253 ) RETURN NUMBER;
254
255 FUNCTION OVERRIDE_RELEASE_CONTROLS_FLAG
256 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
257 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
258 , x_on_operation_action OUT NOCOPY NUMBER
259 ) RETURN NUMBER;
260
261
262 PROCEDURE ALLOW_TRX_LINE_EXEMPTIONS
263 ( p_application_id IN NUMBER,
264 p_entity_short_name IN VARCHAR2,
265 p_validation_entity_short_name IN VARCHAR2,
266 p_validation_tmplt_short_name IN VARCHAR2,
267 p_record_set_tmplt_short_name IN VARCHAR2,
268 p_scope IN VARCHAR2,
269 p_result OUT NOCOPY NUMBER
270 );
271
272 PROCEDURE Entity
273 ( p_LINE_rec IN Oe_Blanket_Pub.LINE_Rec_Type
274 , x_result OUT NOCOPY NUMBER
275 , x_return_status OUT NOCOPY VARCHAR2
276 );
277
278 PROCEDURE Attributes
279 ( p_LINE_rec IN Oe_Blanket_Pub.LINE_Rec_Type
280 , p_old_LINE_rec IN Oe_Blanket_Pub.LINE_Rec_Type := Oe_Blanket_Pub.G_MISS_BLANKET_LINE_REC
281 , x_result OUT NOCOPY NUMBER
282 , x_return_status OUT NOCOPY VARCHAR2
283 );
284
285 --bug6531947
286 FUNCTION CONTEXT
287 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
288 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
289 , x_on_operation_action OUT NOCOPY NUMBER
290 ) RETURN NUMBER;
291
292 FUNCTION ATTRIBUTE1
293 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
294 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
295 , x_on_operation_action OUT NOCOPY NUMBER
296 ) RETURN NUMBER;
297
298 FUNCTION ATTRIBUTE2
299 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
300 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
301 , x_on_operation_action OUT NOCOPY NUMBER
302 ) RETURN NUMBER;
303
304 FUNCTION ATTRIBUTE3
305 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
306 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
307 , x_on_operation_action OUT NOCOPY NUMBER
308 ) RETURN NUMBER;
309
310 FUNCTION ATTRIBUTE4
311 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
312 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
313 , x_on_operation_action OUT NOCOPY NUMBER
314 ) RETURN NUMBER;
315
316 FUNCTION ATTRIBUTE5
317 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
318 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
319 , x_on_operation_action OUT NOCOPY NUMBER
320 ) RETURN NUMBER;
321
322 FUNCTION ATTRIBUTE6
323 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
324 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
325 , x_on_operation_action OUT NOCOPY NUMBER
326 ) RETURN NUMBER;
327
328 FUNCTION ATTRIBUTE7
329 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
330 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
331 , x_on_operation_action OUT NOCOPY NUMBER
332 ) RETURN NUMBER;
333
334 FUNCTION ATTRIBUTE8
335 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
336 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
337 , x_on_operation_action OUT NOCOPY NUMBER
338 ) RETURN NUMBER;
339
340 FUNCTION ATTRIBUTE9
341 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
342 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
343 , x_on_operation_action OUT NOCOPY NUMBER
344 ) RETURN NUMBER;
348 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
345
346 FUNCTION ATTRIBUTE10
347 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
349 , x_on_operation_action OUT NOCOPY NUMBER
350 ) RETURN NUMBER;
351
352 FUNCTION ATTRIBUTE11
353 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
354 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
355 , x_on_operation_action OUT NOCOPY NUMBER
356 ) RETURN NUMBER;
357
358 FUNCTION ATTRIBUTE12
359 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
360 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
361 , x_on_operation_action OUT NOCOPY NUMBER
362 ) RETURN NUMBER;
363
364 FUNCTION ATTRIBUTE13
365 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
366 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
367 , x_on_operation_action OUT NOCOPY NUMBER
368 ) RETURN NUMBER;
369
370 FUNCTION ATTRIBUTE14
371 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
372 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
373 , x_on_operation_action OUT NOCOPY NUMBER
374 ) RETURN NUMBER;
375
376 FUNCTION ATTRIBUTE15
377 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
378 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
379 , x_on_operation_action OUT NOCOPY NUMBER
380 ) RETURN NUMBER;
381
382 FUNCTION ATTRIBUTE16
383 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
384 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
385 , x_on_operation_action OUT NOCOPY NUMBER
386 ) RETURN NUMBER;
387
388 FUNCTION ATTRIBUTE17
389 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
390 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
391 , x_on_operation_action OUT NOCOPY NUMBER
392 ) RETURN NUMBER;
393
394 FUNCTION ATTRIBUTE18
395 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
396 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
397 , x_on_operation_action OUT NOCOPY NUMBER
398 ) RETURN NUMBER;
399
400 FUNCTION ATTRIBUTE19
401 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
402 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
403 , x_on_operation_action OUT NOCOPY NUMBER
404 ) RETURN NUMBER;
405
406 FUNCTION ATTRIBUTE20
407 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
408 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
409 , x_on_operation_action OUT NOCOPY NUMBER
410 ) RETURN NUMBER;
411
412
413 END OE_Blanket_Line_Security;