1 PACKAGE WSH_PACKING_SLIPS_PVT AUTHID CURRENT_USER AS
2 -- $Header: WSHPSTHS.pls 115.4 2002/11/12 01:48:59 nparikh ship $
3
4 PROCEDURE update_Row
5 ( p_api_version IN NUMBER
6 , p_init_msg_list IN VARCHAR2
7 , p_commit IN VARCHAR2
8 , p_validation_level IN NUMBER
9 , x_return_status OUT NOCOPY VARCHAR2
10 , x_msg_count OUT NOCOPY NUMBER
11 , x_msg_data OUT NOCOPY VARCHAR2
12 , p_entity_name IN VARCHAR2
13 , p_entity_id IN NUMBER
14 , p_document_type IN VARCHAR2
15 , p_reason_of_transport IN VARCHAR2
16 , p_description IN VARCHAR2
17 , p_document_number IN VARCHAR2
18 );
19
20
21
22 PROCEDURE insert_row
23 (x_return_status IN OUT NOCOPY VARCHAR2,
24 x_msg_count IN OUT NOCOPY VARCHAR2,
25 x_msg_data IN OUT NOCOPY VARCHAR2,
26 p_entity_name IN VARCHAR2,
27 p_entity_id IN NUMBER,
28 p_application_id IN NUMBER,
29 p_location_id IN NUMBER,
30 p_document_type IN VARCHAR2,
31 p_document_sub_type IN VARCHAR2,
32 p_reason_of_transport IN VARCHAR2,
33 p_description IN VARCHAR2,
34 x_document_number IN OUT NOCOPY VARCHAR2);
35
36
37 PROCEDURE delete_row
38 ( p_api_version IN NUMBER
39 , p_init_msg_list IN VARCHAR2
40 , p_commit IN VARCHAR2
41 , p_validation_level IN NUMBER
42 , x_return_status OUT NOCOPY VARCHAR2
43 , x_msg_count OUT NOCOPY NUMBER
44 , x_msg_data OUT NOCOPY VARCHAR2
45 , p_entity_id IN NUMBER
46 , p_document_type IN VARCHAR2
47 , p_document_number IN VARCHAR2
48 );
49
50
51 -- Procedure: Get_Disabled_List
52 --
53 -- Parameters: p_delivery_id -- delivery the detail is assigned to
54 -- p_list_type --
55 -- 'FORM', will return list of form field names
56 -- 'TABLE', will return list of table column names
57 -- x_return_status -- return status for execution of this API
58 -- x_disabled_list -- list of disabled field names
59 -- x_msg_count -- number of error message
60 -- x_msg_data -- error message if API failed
61 --
62 PROCEDURE Get_Disabled_List(
63 p_delivery_id IN NUMBER
64 , p_list_type IN VARCHAR2
65 , x_return_status OUT NOCOPY VARCHAR2
66 , x_disabled_list OUT NOCOPY WSH_UTIL_CORE.column_tab_type
67 , x_msg_count OUT NOCOPY NUMBER
68 , x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71
72 END WSH_PACKING_SLIPS_PVT;