1 PACKAGE AMS_MTL_CATG_LOADER_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvmcas.pls 115.6 2004/03/16 01:16:46 musman ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- Refresh_Inv_Category
8 --
9 -- PURPOSE
10 -- This procedure is created to as a concurrent program which
11 -- will load inventory categories into ams denorm table.
12 --
13 -- NOTES
14 --
15 --
16 -- HISTORY
17 -- 07/01/2002 ABHOLA Created
18 -- 28-MAR-2003 mukumar Add languagem added
19
20 -- End of Comments
21
22 PROCEDURE Load_Inv_Category
23 (errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY NUMBER);
25
26 /*
27 * This procedure would upgrade the interest types in ams_competitor_products_b
28 * categories and category sets from as_interets_types_vl mapped in OSO
29 */
30
31
32 PROCEDURE UPGRADE_INTEREST_TYPES
33 (errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY NUMBER);
35
36 /*
37 * This procedure would upgrade the marketing transaction table (ams_Act_products)
38 * categories and category sets to the one mapped in PLM
39 */
40
41 PROCEDURE UPGRADE_CATEGORIES
42 (errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY NUMBER);
44
45
46 procedure ADD_LANGUAGE;
47
48 END AMS_MTL_CATG_LOADER_PVT;