1 PACKAGE WSH_AUTO_MANIFEST as
2 /* $Header: WSHAUMNS.pls 120.1 2005/06/03 15:28:03 appldev $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 TYPE delivery_msg_rec is RECORD
8 (delivery_name VARCHAR2(30),
9 msg_summary VARCHAR2(4000),
10 msg_details VARCHAR2(4000));
11
12 TYPE tab_delivery_msg IS TABLE OF delivery_msg_rec INDEX BY BINARY_INTEGER;
13
14 --k proj
15 TYPE t_shipment_rec is RECORD
16 (organization_id NUMBER,
17 delivery_id NUMBER,
18 carrier_id NUMBER,
19 customer_id NUMBER,
20 ultimate_dropoff_location_id NUMBER
21 );
22
23
24
25 --
26 -- PROCEDURE: Submit
27 -- Purpose: Submit Automated Carrier Manifesting based on given criteria.
28 -- Description: This procedure is called by Concurrent Program to submit request for Automated
29 -- Carrier Manifesting. This works as a wrapper to the main procedure
30 -- Process_Auto_Manifest for Automated Carrier Manifesting.
31 --
32 PROCEDURE Submit (
33 errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY VARCHAR2,
35 -- K proj
36 p_doctype IN VARCHAR2,
37 p_shipment_type IN VARCHAR2,
38 p_set_org IN NUMBER,
39 p_organization_id IN NUMBER,
40 -- K proj
41 p_src_header_num_from IN VARCHAR2,
42 p_src_header_num_to IN VARCHAR2,
43 p_carrier_id IN NUMBER,
44 p_customer_id IN NUMBER,
45 p_customer_ship_to_id IN NUMBER,
46 p_scheduled_from_date IN VARCHAR2,
47 p_scheduled_to_date IN VARCHAR2,
48 p_set_auto_pack IN NUMBER,
49 p_autopack IN VARCHAR2,
50 p_log_level IN NUMBER);
51
52
53 --
54 -- PROCEDURE : Process_Auto_Manifest
55 -- Description: This is the main procedure for Automated Carrier Manifesting System,
56 -- which is called by procedure submit.
57 --
58 PROCEDURE Process_Auto_Manifest (
59 p_organization_id IN NUMBER,
60 p_carrier_id IN NUMBER,
61 p_customer_id IN NUMBER,
62 p_customer_ship_to_id IN NUMBER,
63 p_scheduled_from_date IN DATE,
64 p_scheduled_to_date IN DATE,
65 p_autopack IN VARCHAR2 DEFAULT 'N',
66 p_log_level IN NUMBER DEFAULT 0,
67 x_return_status OUT NOCOPY VARCHAR2,
68 p_shipment_type IN VARCHAR2,
69 p_doctype IN VARCHAR2,
70 p_src_header_num_from IN VARCHAR2,
71 p_src_header_num_to IN VARCHAR2) ;
72
73 --
74 -- PROCEDURE : Lock_Manifest_Delivery
75 -- Description: This procedure lock the delivery and its assigned lines
76 --
77 PROCEDURE Lock_Manifest_Delivery(
78 p_delivery_id IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2);
80
81
82 --
83 -- PROCEDURE : Validate_Scheduled_Ship_Date
84 -- Description: This procedure check if scheduled_date of lines assign to delivery fall in the range
85 -- of input scheduled_ship_dates
86 --
87 PROCEDURE Validate_Scheduled_Ship_Date(
88 p_delivery_id IN NUMBER,
89 p_scheduled_from_date IN DATE,
90 p_scheduled_to_date IN DATE,
91 x_validate OUT NOCOPY VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2);
93
94 FUNCTION set_auto_pack (
95 p_doc_type IN VARCHAR2,
96 p_shipment_type IN VARCHAR2
97 ) RETURN NUMBER;
98
99
100 END WSH_AUTO_MANIFEST;