1 PACKAGE MSD_DEM_UPDATE_LEVEL_CODES AUTHID CURRENT_USER AS
2 /* $Header: msddemupdlvs.pls 120.0.12010000.3 2009/04/15 10:17:07 sjagathe ship $ */
3
4 procedure update_code(errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY VARCHAR2,
6 p_instance_id IN NUMBER,
7 p_level IN VARCHAR2,
8 p_dest_table_name IN VARCHAR2,
9 p_dest_column_name IN VARCHAR2,
10 p_src_coulmn_name IN VARCHAR2);
11
12
13 /*
14 * This procedure converts the level code format from descriptive to integer format based upon the
15 * given parameters.
16 * If p_convert_type = 1, then change from new to old (descriptive)
17 * If p_convert_type = 2, then change from old to new
18 */
19 PROCEDURE CONVERT_SITE_CODE (
20 errbuf OUT NOCOPY VARCHAR2,
21 retcode OUT NOCOPY VARCHAR2,
22 p_sr_instance_id IN NUMBER,
23 p_level IN VARCHAR2,
24 p_dest_table_name IN VARCHAR2,
25 p_dest_column_name IN VARCHAR2,
26 p_convert_type IN NUMBER);
27
28
29 /*
30 * This procedure updates the level codes from descriptive to id format. The levels are -
31 * SITE, ACCOUNT, CUSTOMER, SUPPLIER, TRADING PARTNER ZONE
32 *
33 * This is an upgrade procedure hence proper backup of the Demantra Schema must be taken
34 * before running this procedure.
35 *
36 * This procedure must be run once for each instance for which data is available inside
37 * Demantra.
38 *
39 * This procedure creates a backup copy of the tables before updating them.
40 *
41 * The Demantra Application Server should be down when the procedure is run.
42 *
43 * Once the procedure has finished, bring up the Demantra Application Server and verify data.
44 *
45 * Run Data Load and verify data.
46 */
47 PROCEDURE UPGRADE_GEO_LEVEL_CODES (
48 errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2,
50 p_sr_instance_id IN NUMBER);
51
52 END MSD_DEM_UPDATE_LEVEL_CODES;
53