1 PACKAGE WSH_CONC_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHCPUTS.pls 120.2 2006/05/05 14:56:13 wrudge noship $ */
3
4
5 -- Description: This procedure updates transactions with the new/valid
6 -- Freight Code/Carrier id after upgrade. It updates the
7 -- Old/Invalid Fgt.Code with the new/valid Fgt. Code, where
8 -- ever the Old Fgt.Code-Ship.Method Combination is non-exis
9 -- -tant after the upgrade.
10 -- This uses LTU architecture to exucute the updgrade in
11 -- parallel
12 -- Parameters: p_batch_commit_size - batch size < 1000
13 -- p_numworkers - Number of workers.
14 -- p_logical_worker_id - Worker id.
15
16 Procedure Worker_Upgrade_Closed_Orders(
17 errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY VARCHAR2,
19 p_batch_commit_size IN NUMBER,
20 p_logical_worker_id IN NUMBER,
21 p_numworkers IN NUMBER);
22
23
24
25 -- Description: This is a wrapper around AD_Conc_Utils_PKG.Submit_Subrequests
26 -- Parameters : p_worker_conc_appsshortname - Shortname for the application
27 -- owning the worker concurrent program
28 -- p_worker_conc_program - Worker concurrent program that will
29 -- will be run in parallel using LTU architecture.
30 -- p_batch_commit_size - batch size < 1000
31 -- p_numworkers - Number of workers.
32
33 Procedure Master_Conc_Parallel_Upgrade(
34 errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY VARCHAR2,
36 p_worker_conc_appsshortname IN VARCHAR2,
37 p_worker_conc_program IN VARCHAR2,
38 p_batch_commit_size IN NUMBER,
39 p_numworkers IN NUMBER);
40
41
42
43 -- Description: Update Ship Method SRS for ECO 5069719
44 -- This will upgrade open shipping data with mode of transport
45 -- and service level that are entered on ship methods upgraded
46 -- from 11.0 or 10.7
47 -- PARAMETERS: errbuf Used by the concurrent program for error
48 -- messages.
49 -- retcode Used by the concurrent program for
50 -- return code.
51 PROCEDURE update_ship_method_SRS(
52 errbuf OUT NOCOPY VARCHAR2,
53 retcode OUT NOCOPY VARCHAR2);
54
55 END WSH_CONC_UTIL_PKG;
56