1 PACKAGE WSH_AUTO_MANIFEST AUTHID CURRENT_USER as
2 /* $Header: WSHAUMNS.pls 120.3.12020000.1 2012/06/27 11:41:16 appldev ship $ */
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 --R12.1.1 STANDALONE PROJECT
36 -- p_standalone_mode is a parameter defined in concurrent program and it is
37 -- not used anywhere in code.
38 p_standalone_mode IN VARCHAR2,
39 -- K proj
40 p_doctype IN VARCHAR2,
41 p_shipment_type IN VARCHAR2,
42 p_deploy_mode IN VARCHAR2, -- Modified R12.1.1 LSP PROJECT
43 p_set_org IN NUMBER,
44 p_client_id IN NUMBER, -- Modified R12.1.1 LSP PROJECT(rminocha)
45 p_organization_id IN NUMBER,
46 -- K proj
47 p_src_header_num_from IN VARCHAR2,
48 p_src_header_num_to IN VARCHAR2,
49 --R12.1.1 STANDALONE PROJECT
50 p_del_name_from IN VARCHAR2,
51 p_del_name_to IN VARCHAR2,
52 p_carrier_id IN NUMBER,
53 p_customer_id IN NUMBER,
54 p_customer_ship_to_id IN NUMBER,
55 p_scheduled_from_date IN VARCHAR2,
56 p_scheduled_to_date IN VARCHAR2,
57 p_set_auto_pack IN NUMBER,
58 p_autopack IN VARCHAR2,
59 p_log_level IN NUMBER);
60
61
62 --
63 -- PROCEDURE : Process_Auto_Manifest
64 -- Description: This is the main procedure for Automated Carrier Manifesting System,
65 -- which is called by procedure submit.
66 --
67 PROCEDURE Process_Auto_Manifest (
68 p_organization_id IN NUMBER,
69 p_carrier_id IN NUMBER,
70 p_customer_id IN NUMBER,
71 p_customer_ship_to_id IN NUMBER,
72 p_scheduled_from_date IN DATE,
73 p_scheduled_to_date IN DATE,
74 p_autopack IN VARCHAR2 DEFAULT 'N',
75 p_log_level IN NUMBER DEFAULT 0,
76 x_return_status OUT NOCOPY VARCHAR2,
77 p_shipment_type IN VARCHAR2,
78 p_doctype IN VARCHAR2,
79 p_src_header_num_from IN VARCHAR2,
80 p_src_header_num_to IN VARCHAR2,
81 --R12.1.1 STANDALONE PROJECT
82 p_del_name_from IN VARCHAR2,
83 p_del_name_to IN VARCHAR2,
84 p_client_id IN NUMBER -- Modified R12.1.1 LSP PROJECT
85 );
86
87 --
88 -- PROCEDURE : Lock_Manifest_Delivery
89 -- Description: This procedure lock the delivery and its assigned lines
90 --
91 PROCEDURE Lock_Manifest_Delivery(
92 p_delivery_id IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2);
94
95
96 --
97 -- PROCEDURE : Validate_Scheduled_Ship_Date
98 -- Description: This procedure check if scheduled_date of lines assign to delivery fall in the range
99 -- of input scheduled_ship_dates
100 --
101 PROCEDURE Validate_Scheduled_Ship_Date(
102 p_delivery_id IN NUMBER,
103 p_scheduled_from_date IN DATE,
104 p_scheduled_to_date IN DATE,
105 x_validate OUT NOCOPY VARCHAR2,
106 x_return_status OUT NOCOPY VARCHAR2);
107
108 FUNCTION set_auto_pack (
109 p_doc_type IN VARCHAR2,
110 p_shipment_type IN VARCHAR2
111 ) RETURN NUMBER;
112
113
114 END WSH_AUTO_MANIFEST;