1 Package EDW_ITEMS_M_C AUTHID CURRENT_USER AS
2 /*$Header: ENICITMS.pls 115.3 2004/01/30 22:01:06 sbag noship $*/
3 VERSION CONSTANT CHAR(80) :=
4 '$Header: ENICITMS.pls 115.3 2004/01/30 22:01:06 sbag noship $';
5
6 -- Global Variables
7
8 -- The ID of the category set from which the item category value based hierarchy
9 -- will be loaded
10
11 G_VBH_CATSET_ID CONSTANT NUMBER:=1000000006;
12
13 Procedure Push( Errbuf OUT NOCOPY Varchar2,
14 Retcode OUT NOCOPY Varchar2,
15 p_from_date IN Varchar2,
16 p_to_date IN Varchar2);
17 Procedure Push_EDW_ITEM_ITEMREV(
18 p_from_date IN Date,
19 p_to_date IN Date);
20 Procedure Push_EDW_ITEM_PRDFAM(
21 p_from_date IN Date,
22 p_to_date IN Date);
23 Procedure Push_EDW_ITEM_ITEMORG(
24 p_from_date IN Date,
25 p_to_date IN Date);
26 Procedure Push_EDW_ITEM_ITEM(
27 p_from_date IN Date,
28 p_to_date IN Date);
29 Procedure Push_EDW_ITEM_ITEMORG_CAT(
30 p_from_date IN Date,
31 p_to_date IN Date);
32 Procedure Push_EDW_ITEM_ITEM_CAT(
33 p_from_date IN Date,
34 p_to_date IN Date);
35 Procedure Push_EDW_ITEM_PROD_LINE(
36 p_from_date IN Date,
37 p_to_date IN Date);
38 Procedure Push_EDW_ITEM_PROD_CATG(
39 p_from_date IN Date,
40 p_to_date IN Date);
41 Procedure Push_EDW_ITEM_PROD_GRP(
42 p_from_date IN Date,
43 p_to_date IN Date);
44 End EDW_ITEMS_M_C;