1 PACKAGE WSH_UPGRADE_PICK_SLIP_DATA_NEW AUTHID CURRENT_USER AS
2 /* $Header: wshpupds.pls 120.0 2005/05/26 18:16:04 appldev noship $ */
3
4 --
5 -- Package
6 -- WSH_UPGRADE_PICK_SLIP_DATA_NEW
7 --
8 -- Purpose
9 -- To upgrade historic pick slip data to delivery based shipping
10 --
11
12 /*
13
14 PACKAGE: WSH_UPGRADE_PICK_SLIP_DATA_NEW.UPGRADE_ROWS
15
16 SUMMARY: The PL/SQL script consisting of the procedures described below is
17 used to upgrade historic pick-slip data to the new Delivery based
18 system (DBS) in release 10.7 and later versions. This script
19 searches for picking headers (greater than zero) that do not have
20 a delivery ID and which have already been shipped (with status
21 CLOSED). New departure and delivery information is created for each
22 picking header obtained in this manner. Each of these new delivery/
23 departure rows contains existing data from their picking headers
24 and order headers and can subsequently be used in new delivery-based
25 forms and reports.
26
27 USAGE: Please run the driver file for the patch to install the package
28 WSH_UPGRADE_PICK_SLIP_DATA_NEW before executing the SQL driver
29 statement in wshrpupd.sql.
30
31 wshrpupd.sql <total workers> <worker number>
32 e.g.
33 sqlplus <username/password@database> @wshrpupd.sql 5 1
34
35 The file wshrpupd.sql calls the procedure with another parameter
36 num_rows which specifies the commit size.
37
38 */
39
40 PROCEDURE Upgrade_Rows(
41 num_rows IN BINARY_INTEGER,
42 total_workers IN BINARY_INTEGER,
43 worker IN BINARY_INTEGER,
44 batch_number IN BINARY_INTEGER
45 );
46
47 END WSH_UPGRADE_PICK_SLIP_DATA_NEW;