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;