1 PACKAGE WSH_DEL_OI_CORE AUTHID CURRENT_USER AS
2 /* $Header: WSHSDVAS.pls 115.5 99/07/16 08:21:53 porting ship $ */
3
4
5 -- WSH_DEL_OI_CORE
6 -- Purpose
7 -- Core Validation Routines for Open Interface
8 -- History
9 -- 20-MAY-96 troveda Created
10 --
11
12 suppress_print boolean := TRUE;
13
14 PROCEDURE GET_ORDER_INFO
15 (X_picking_header_id in number,
16 X_Order_currency in out varchar2,
17 X_Order_category in out varchar2);
18
19 FUNCTION PICKSLIP_CLOSED
20 (X_PICKING_HEADER_ID IN NUMBER) return BOOLEAN ;
21
22 PROCEDURE GET_ITEM_CONTROL_CODES
23 (X_warehouse_id in number,
24 X_item_id in number,
25 X_order_category in varchar2,
26 X_subinv_restricted_flag in out varchar2,
27 X_revision_control_flag in out varchar2,
28 X_lot_control_flag in out varchar2,
29 X_serial_number_control_flag in out varchar2,
30 error_code in out varchar2);
31
32 FUNCTION VALID_SUBINVENTORY
33 (X_warehouse_id in number,
34 X_item_id in number,
35 X_subinventory in varchar2,
36 X_subinv_restricted_flag in varchar2) return BOOLEAN;
37
38 FUNCTION DEFAULT_SUBINVENTORY
39 (X_warehouse_id in number,
40 X_item_id in number) return VARCHAR2;
41
42 PROCEDURE GET_LOCATOR_CONTROLS
43 (X_warehouse_id in number,
44 X_item_id in number,
45 X_subinventory in varchar2,
46 X_location_control_flag in out varchar2,
47 X_location_restricted_flag in out varchar2,
48 error_code in out varchar2);
49
50 FUNCTION VALID_LOT_NUMBER
51 (X_warehouse_id in number,
52 X_item_id in number,
53 X_subinventory in varchar2,
54 X_lot_number in varchar2) return BOOLEAN;
55
56 FUNCTION VALID_REVISION
57 (X_warehouse_id in number,
58 X_item_id in number,
59 X_revision in varchar2) return BOOLEAN;
60
61 FUNCTION VALID_LOCATOR_ID
62 (X_warehouse_id in number,
63 X_item_id in number,
64 X_subinventory in varchar2,
65 X_location_restricted_flag in varchar2,
66 X_locator_id in number) return BOOLEAN;
67
68 FUNCTION DEFAULT_LOCATOR
69 (X_warehouse_id in number,
70 X_item_id in number,
71 X_subinventory in varchar2,
72 X_location_restricted_flag in varchar2) return NUMBER;
73
74 FUNCTION VALID_SERIAL_NUMBER
75 (X_warehouse_id in number,
76 X_item_id in number,
77 X_subinventory in varchar2,
78 X_revision in varchar2,
79 X_lot_number in varchar2,
80 X_locator_id in number,
81 X_serial_number in varchar2,
82 X_location_restricted_flag in varchar2,
83 X_location_control_flag in varchar2,
84 X_serial_number_control_flag in varchar2) return BOOLEAN;
85
86 FUNCTION Validate_Container_Id
87 (X_container_id in number,
88 X_sequence_number in number,
89 x_delivery_id in number,
90 error_code in out varchar2) return NUMBER;
91
92
93 FUNCTION AR_INTERFACED
94 (X_delivery_id in number) return BOOLEAN;
95
96 FUNCTION VALID_FREIGHT_TYPE
97 (X_in_id in number,
98 X_in_code in varchar2) return NUMBER;
99
100 FUNCTION Valid_Carrier_Code
101 (X_organization_id in number,
102 X_carrier_code in varchar2) return BOOLEAN;
103
104 PROCEDURE VALIDATE_CURRENCY
105 (X_in_code in varchar2,
106 X_in_name in varchar2,
107 X_amount in number,
108 X_out_code out varchar2,
109 X_out_name out varchar2,
110 error_code in out varchar2);
111
112 PROCEDURE VALIDATE_UOM
113 (X_class in varchar2,
114 X_uom_code in out varchar2,
115 X_uom_desc in varchar2,
116 error_code in out varchar2);
117
118
119 PROCEDURE VALIDATE_USER
120 (X_user_id in out number,
121 X_user_name in varchar2,
122 error_code in out varchar2);
123
124
125 PROCEDURE UPDATE_SHIPPING_ONLINE
126 (x_picking_header_id in number,
127 x_batch_id in number);
128
129 FUNCTION SHIP_MULTI_ORG
130 (x_picking_header_id in number ) return BOOLEAN;
131
132
133 PROCEDURE VALIDATE_SO_CODE
134 (X_lookup_type in varchar2,
135 X_code in out varchar2,
136 X_meaning in varchar2,
137 X_error_code in out varchar2);
138
139
140 -- write messages to output if debug is on
141 PROCEDURE println;
142 PROCEDURE println (msg IN VARCHAR2);
143
144
145 END WSH_DEL_OI_CORE;