[Home] [Help]
PACKAGE: APPS.OEXVWLIN
Source
1 PACKAGE OEXVWLIN AUTHID CURRENT_USER AS
2 /* $Header: OEXVWLNS.pls 115.3 99/10/19 17:29:50 porting ship $ */
3
4 function LINE_TOTAL (
5 ORDER_ROWID IN VARCHAR2
6 , ORDER_LINE_ID IN NUMBER DEFAULT NULL
7 , LINE_TYPE_CODE IN VARCHAR2
8 , ITEM_TYPE_CODE IN VARCHAR2
9 , SERVICE_DURATION IN NUMBER
10 , SERVICEABLE_FLAG IN VARCHAR2
11 , ORDERED_QTY IN NUMBER
12 , CANCELLED_QTY IN NUMBER
13 , SELLING_PRICE IN NUMBER
14 )
15 return NUMBER;
16
17 function SCHEDULE_STATUS(
18 ORDER_LINE_ID IN NUMBER DEFAULT NULL
19 )
20 return VARCHAR2;
21
22 function RESERVED_QUANTITY(
23 ORDER_LINE_ID IN NUMBER DEFAULT NULL
24 )
25 return NUMBER;
26
27 function HOLD(
28 ORDER_LINE_ID IN NUMBER DEFAULT NULL
29 , ORDER_HEADER_ID IN NUMBER DEFAULT NULL
30 )
31 return varchar2;
32
33 function SHIPMENT_NUMBER(
34 ORDER_LINE_ID IN NUMBER DEFAULT NULL
35 , ORDER_PARENT_LINE_ID IN NUMBER DEFAULT NULL
36 , ORDER_SHIP_SCHEDULE_LINE_ID IN NUMBER DEFAULT NULL
37 , ORDER_LINE_NUMBER IN NUMBER DEFAULT NULL
38 )
39 return NUMBER;
40
41 function LINE_NUMBER(
42 ORDER_LINE_ID IN NUMBER DEFAULT NULL
43 , ORDER_SHIP_SCHEDULE_LINE_ID IN NUMBER DEFAULT NULL
44 , ORDER_PARENT_LINE_ID IN NUMBER DEFAULT NULL
45 , ORDER_LINE_NUMBER IN NUMBER DEFAULT NULL
46 )
47 return NUMBER;
48
49
50 function ITEM_CONC_SEG(
51 ITEM_ID IN NUMBER DEFAULT NULL
52 , ORG_ID IN NUMBER DEFAULT NULL
53 )
54 return VARCHAR2;
55
56 function ORDER_TYPE(
57 ID IN NUMBER DEFAULT NULL
58 )
59 return VARCHAR2;
60
61
62 pragma restrict_references(LINE_TOTAL, WNDS, WNPS);
63 pragma restrict_references( SCHEDULE_STATUS, WNDS); -- ,WNPS);
64 pragma restrict_references( RESERVED_QUANTITY, WNDS, WNPS);
65 pragma restrict_references( HOLD, WNDS, WNPS);
66 pragma restrict_references( SHIPMENT_NUMBER, WNDS, WNPS);
67 pragma restrict_references( LINE_NUMBER, WNDS, WNPS);
68 pragma restrict_references( ITEM_CONC_SEG, WNDS, WNPS);
69 pragma restrict_references( ORDER_TYPE, WNDS, WNPS);
70
71 END OEXVWLIN;