PACKAGE: APPS.OPI_EDW_DIM_SZ

Source

1 PACKAGE OPI_EDW_DIM_SZ AS
2 /* $Header: OPIMDSZS.pls 120.1 2005/06/10 11:45:59 appldev  $*/
3 
4 -- procedure to count inventory Locator Dimension rows.
5 
6   PROCEDURE EDW_MTL_INV_LOC_M_CNT_ROWS(p_from_date DATE,
7                    p_to_date DATE,
8                    p_num_rows OUT NOCOPY NUMBER);
9 -- procedure to get average row length inventory Locator Dimension rows.
10 
11   PROCEDURE EDW_MTL_INV_LOC_M_EST_ROW_LEN(p_from_date DATE,
12                    p_to_date DATE,
13                    p_avg_row_len OUT NOCOPY NUMBER);
14 
15 -- procedure to count Activity Dimension rows.
16 
17   PROCEDURE EDW_OPI_ACTV_M_CNT_ROWS(p_from_date DATE,
18                    p_to_date DATE,
19                    p_num_rows OUT NOCOPY NUMBER);
20 -- procedure to get average row length Activity Dimension rows.
21 
22   PROCEDURE EDW_OPI_ACTV_M_EST_ROW_LEN(p_from_date DATE,
23                    p_to_date DATE,
24                    p_avg_row_len OUT NOCOPY NUMBER);
25 
26 
27 -- procedure to count Lot Dimension rows.
28 
29   PROCEDURE EDW_OPI_LOT_M_CNT_ROWS(p_from_date DATE,
30                    p_to_date DATE,
31                    p_num_rows OUT NOCOPY NUMBER);
32 -- procedure to get average row length Lot Dimension rows.
33 
34   PROCEDURE EDW_OPI_LOT_M_EST_ROW_LEN(p_from_date DATE,
35                    p_to_date DATE,
36                    p_avg_row_len OUT NOCOPY NUMBER);
37 
38 
39 -- procedure to count Production Operation Dimension rows.
40 
41   PROCEDURE EDW_OPI_OPRN_M_CNT_ROWS(p_from_date DATE,
42                    p_to_date DATE,
43                    p_num_rows OUT NOCOPY NUMBER);
44 
45 -- procedure to get average row length Production Operation Dimension rows.
46 
47   PROCEDURE EDW_OPI_OPRN_M_EST_ROW_LEN(p_from_date DATE,
48                    p_to_date DATE,
49                    p_avg_row_len OUT NOCOPY NUMBER);
50 
51 
52 -- procedure to count Production Line Dimension rows.
53 
54   PROCEDURE EDW_OPI_PRDL_M_CNT_ROWS(p_from_date DATE,
55                    p_to_date DATE,
56                    p_num_rows OUT NOCOPY NUMBER);
57 
58 -- procedure to get average row length Production Line Dimension rows.
59 
60   PROCEDURE EDW_OPI_PRDL_M_EST_ROW_LEN(p_from_date DATE,
61                    p_to_date DATE,
62                    p_avg_row_len OUT NOCOPY NUMBER);
63 
64 END;
65