1 PACKAGE OEXVWCAN AUTHID CURRENT_USER AS
2 /* $Header: OEXVWCNS.pls 115.2 99/07/16 08:17:11 porting shi $ */
3
4 function SHIPMENT_SCHEDULE_NUMBER(
5 P_PARENT_LINE_ID IN NUMBER DEFAULT NULL
6 , P_SERVICE_PARENT_LINE_ID IN NUMBER DEFAULT NULL
7 , P_SHIPMENT_SCHEDULE_LINE_ID IN NUMBER DEFAULT NULL
8 , P_LINE_NUMBER IN NUMBER DEFAULT NULL
9 )
10 return NUMBER;
11
12 function BASE_LINE_NUMBER(
13 P_PARENT_LINE_ID IN NUMBER DEFAULT NULL
14 , P_SERVICE_PARENT_LINE_ID IN NUMBER DEFAULT NULL
15 , P_SHIPMENT_SCHEDULE_LINE_ID IN NUMBER DEFAULT NULL
16 , P_LINE_NUMBER IN NUMBER DEFAULT NULL
17 )
18 return NUMBER;
19
20
21 function OPTION_LINE_NUMBER(
22 P_PARENT_LINE_ID IN NUMBER DEFAULT NULL
23 , P_SERVICE_PARENT_LINE_ID IN NUMBER DEFAULT NULL
24 , P_SHIPMENT_SCHEDULE_LINE_ID IN NUMBER DEFAULT NULL
25 , P_LINE_NUMBER IN NUMBER DEFAULT NULL
26 )
27 return NUMBER;
28
29
30 function SUBTREE_EXISTS(
31 V_LINE_ID IN NUMBER
32 , V_REAL_PARENT_LINE_ID IN NUMBER
33 )
34 return VARCHAR2;
35
36 function IN_CONFIGURATION(
37 V_PARENT_LINE_ID IN NUMBER
38 , V_ITEM_TYPE_CODE IN VARCHAR2
39 , V_SERVICE_PARENT_LINE_ID IN NUMBER
40 )
41 return VARCHAR2;
42
43 function OPEN_PICKING_SLIPS(
44 V_LINE_ID IN NUMBER
45 , V_REAL_PARENT_LINE_ID IN NUMBER
46 , V_COMPONENT_CODE IN VARCHAR2
47 )
48 return VARCHAR2;
49
50 function PRICE_ADJUST_EXISTS(
51 V_HEADER_ID IN NUMBER
52 , V_LINE_ID IN NUMBER
53 )
54 return VARCHAR2;
55
56
57 function TOP_BILL_SEQUENCE_ID(
58 V_LINE_ID IN NUMBER DEFAULT NULL
59 , V_PARENT_LINE_ID IN NUMBER DEFAULT NULL
60 )
61 return NUMBER;
62
63 function SECURITY_OBJECT(
64 V_PARENT_LINE_ID IN NUMBER
65 , V_SHIPMENT_SCHEDULE_LINE_ID IN NUMBER
66 , V_SERVICE_PARENT_LINE_ID IN NUMBER
67 , V_LINE_TYPE_CODE IN VARCHAR2
68 )
69 return VARCHAR2;
70
71
72 pragma restrict_references( SHIPMENT_SCHEDULE_NUMBER, WNDS, WNPS);
73 pragma restrict_references( BASE_LINE_NUMBER, WNDS, WNPS);
74 pragma restrict_references( OPTION_LINE_NUMBER, WNDS, WNPS);
75 pragma restrict_references( SUBTREE_EXISTS, WNDS, WNPS);
76 pragma restrict_references( IN_CONFIGURATION, WNDS, WNPS);
77 pragma restrict_references( OPEN_PICKING_SLIPS, WNDS, WNPS);
78 pragma restrict_references( PRICE_ADJUST_EXISTS, WNDS, WNPS);
79 pragma restrict_references( TOP_BILL_SEQUENCE_ID, WNDS, WNPS);
80 pragma restrict_references( SECURITY_OBJECT, WNDS, WNPS);
81
82
83 END OEXVWCAN;