[Home] [Help]
PACKAGE: APPS.MTH_ITEM_DIMENSION_PKG
Source
1 Package mth_item_dimension_pkg AS
2 /*$Header: mthitems.pls 120.1.12010000.2 2008/09/09 00:51:23 tkan ship $ */
3
4
5 /* ****************************************************************************
6 * Procedure :ITEM_DIM_LOAD_DENORM *
7 * Description :This procedure is used to populate the denorm table *
8 * for the item dimension hierarchy *
9 * File Name :MTHITEMDS.PLS *
10 * Visibility :Public *
11 * Parameters : *
12 * Modification log : *
13 * Author Date Change *
14 * Ankit Goyal 29-May--2007 Initial Creation *
15 **************************************************************************** */
16
17
18 PROCEDURE ITEM_DIM_LOAD_DENORM ;
19
20
21 /* ****************************************************************************
22 * Procedure :ITEM_DIM_LOAD_DENORM_INCR *
23 * Description :This procedure is used to incrementally populate the *
24 * denorm table for the item dimension hierarchy *
25 * File Name :MTHITEMDS.PLS *
26 * Visibility :Public *
27 * Parameters : *
28 * Modification log : *
29 * Author Date Change *
30 * Yong Feng 10-July-2008 Initial Creation *
31 **************************************************************************** */
32
33 PROCEDURE ITEM_DIM_LOAD_DENORM_INCR;
34
35 /* ****************************************************************************
36 * Procedure :ITEM_DIM_HRCHY_LEVEL_LOAD *
37 * Description :This procedure will populate the level information *
38 * for the item - category and category - category *
39 * relatiopnships in the item hierarchy staging table *
40 * File Name :MTHITEMDS.PLS *
41 * Visibility :Public *
42 * Parameters : *
43 * Modification log : *
44 * Author Date Change *
45 * Ankit Goyal 29-May--2007 Initial Creation *
46 **************************************************************************** */
47
48
49
50 PROCEDURE ITEM_DIM_HRCHY_LEVEL_LOAD;
51
52
53 END MTH_ITEM_DIMENSION_PKG;