[Home] [Help]
PACKAGE: APPS.MTH_ITEM_DIMENSION_PKG
Source
1 Package mth_item_dimension_pkg AUTHID CURRENT_USER AS
2 /*$Header: mthitems.pls 120.4.12020000.3 2012/10/17 22:47:23 gtippire 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 * Procedure :MTH_ITEM_HRCHY_UNASSIGNED_MAP *
54 * Description :This procedure is used for the assigning items to *
55 unassigned parent to different hierrachies of item in which they are not assigned .*
56 * File Name :MTHITEMS.PLS *
57 * Visibility :Public *
58 * Parameters :fact table name *
59 * Modification log : *
60 * Author Date Change *
61 * Amrit Kaur 30-Mar-2012 Initial Creation *
62 ****************************************************************************** */
63 PROCEDURE MTH_ITEM_HRCHY_UNASSIGNED_MAP;
64
65 END MTH_ITEM_DIMENSION_PKG;