PACKAGE: APPS.OPI_EDW_FACT_SZ

Source

1 PACKAGE OPI_EDW_FACT_SZ AS
2 /* $Header: OPIMFSZS.pls 120.1 2005/06/07 03:27:59 appldev  $*/
3 
4 -- procedure to count COGS Fact rows.
5 
6   PROCEDURE OPI_EDW_COGS_F_CNT_ROWS(p_from_date DATE,
7                    p_to_date DATE,
8                    p_num_rows OUT NOCOPY NUMBER);
9 
10 -- procedure to get average row length COGS Fact rows.
11 
12   PROCEDURE OPI_EDW_COGS_F_EST_ROW_LEN(p_from_date DATE,
13                    p_to_date DATE,
14                    p_avg_row_len OUT NOCOPY NUMBER);
15 
16 -- procedure to count Inventory Daily Status Fact rows.
17 
18   PROCEDURE OPI_EDW_IDS_F_CNT_ROWS(p_from_date DATE,
19                    p_to_date DATE,
20                    p_num_rows OUT NOCOPY NUMBER);
21 
22 -- procedure to get average row length Inventory Daily Status Fact rows.
23 
24   PROCEDURE OPI_EDW_IDS_F_EST_ROW_LEN(p_from_date DATE,
25                    p_to_date DATE,
26                    p_avg_row_len OUT NOCOPY NUMBER);
27 
28 
29 -- procedure to count Job Details Fact rows.
30 
31   PROCEDURE OPI_EDW_JOB_DTL_F_CNT_ROWS(p_from_date DATE,
32                    p_to_date DATE,
33                    p_num_rows OUT NOCOPY NUMBER);
34 
35 -- procedure to get average row length Job Details Fact rows.
36 
37   PROCEDURE OPI_EDW_JOB_DTL_F_EST_ROW_LEN(p_from_date DATE,
38                    p_to_date DATE,
39                    p_avg_row_len OUT NOCOPY NUMBER);
40 
41 
42 -- procedure to count Job Resource Fact rows.
43 
44   PROCEDURE OPI_EDW_JOB_RSRC_F_CNT_ROWS(p_from_date DATE,
45                    p_to_date DATE,
46                    p_num_rows OUT NOCOPY NUMBER);
47 
48 -- procedure to get average row length Job Resource Fact rows.
49 
50   PROCEDURE OPI_EDW_JOB_RSRC_F_EST_ROW_LEN(p_from_date DATE,
51                    p_to_date DATE,
52                    p_avg_row_len OUT NOCOPY NUMBER);
53 
54 
55 -- procedure to count Resource Utilization Fact rows.
56 
57   PROCEDURE OPI_EDW_RES_UTIL_F_CNT_ROWS(p_from_date DATE,
58                    p_to_date DATE,
59                    p_num_rows OUT NOCOPY NUMBER);
60 
61 -- procedure to get average row length Resource Utilization Fact rows.
62 
63   PROCEDURE OPI_EDW_RES_UTIL_F_EST_ROW_LEN(p_from_date DATE,
64                    p_to_date DATE,
65                    p_avg_row_len OUT NOCOPY NUMBER);
66 
67 
68 -- procedure to count UOM Conversion Fact rows.
69 
70   PROCEDURE OPI_EDW_UOM_CONV_F_CNT_ROWS(p_from_date DATE,
71                    p_to_date DATE,
72                    p_num_rows OUT NOCOPY NUMBER);
73 
74 -- procedure to get average row length UOM Conversion Fact rows.
75 
76   PROCEDURE OPI_EDW_UOM_CONV_F_EST_ROW_LEN(p_from_date DATE,
77                    p_to_date DATE,
78                    p_avg_row_len OUT NOCOPY NUMBER);
79 
80 
81 END OPI_EDW_FACT_SZ;
82