[Home] [Help]
PACKAGE BODY: APPS.OPI_EDW_FACT_SZ
Source
1 PACKAGE BODY OPI_EDW_FACT_SZ AS
2 /* $Header: OPIMFSZB.pls 120.1 2005/06/10 11:35:52 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) IS
9 p_opi_num_rows NUMBER := 0 ;
10 p_pmi_num_rows NUMBER := 0 ;
11 BEGIN
12 OPI_EDW_COGS_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
13 OPI_EDW_COGS_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
14 p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
15 END;
16
17 -- procedure to get average row length COGS Fact rows.
18
19 PROCEDURE OPI_EDW_COGS_F_EST_ROW_LEN(p_from_date DATE,
20 p_to_date DATE,
21 p_avg_row_len OUT NOCOPY NUMBER) IS
22 p_opi_row_len NUMBER := 0 ;
23 p_pmi_row_len NUMBER := 0 ;
24 BEGIN
25 OPI_EDW_COGS_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
26 OPI_EDW_COGS_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
27 p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
28 END;
29
30 -- procedure to count Inventory Daily Status Fact rows.
31
32 PROCEDURE OPI_EDW_IDS_F_CNT_ROWS(p_from_date DATE,
33 p_to_date DATE,
34 p_num_rows OUT NOCOPY NUMBER) IS
35 p_opi_num_rows NUMBER := 0 ;
36 p_pmi_num_rows NUMBER := 0 ;
37 BEGIN
38 OPI_EDW_INV_DAILY_STAT_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
39 OPI_EDW_INV_DAILY_STAT_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
40 p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
41 END;
42
43 -- procedure to get average row length Inventory Daily Status Fact rows.
44
45 PROCEDURE OPI_EDW_IDS_F_EST_ROW_LEN(p_from_date DATE,
46 p_to_date DATE,
47 p_avg_row_len OUT NOCOPY NUMBER) IS
48 p_opi_row_len NUMBER := 0 ;
49 p_pmi_row_len NUMBER := 0 ;
50 BEGIN
51 OPI_EDW_INV_DAILY_STAT_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
52 OPI_EDW_INV_DAILY_STAT_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
53 p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len) ;
54 END;
55
56 -- procedure to count Job Details Fact rows.
57
58 PROCEDURE OPI_EDW_JOB_DTL_F_CNT_ROWS(p_from_date DATE,
59 p_to_date DATE,
60 p_num_rows OUT NOCOPY NUMBER) IS
61 p_opi_num_rows NUMBER := 0 ;
62 p_pmi_num_rows NUMBER := 0 ;
63 BEGIN
64 OPI_EDW_JOB_DETAIL_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
65 OPI_EDW_JOB_DETAIL_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
66 p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
67 END;
68
69 -- procedure to get average row length Job Details Fact rows.
70
71 PROCEDURE OPI_EDW_JOB_DTL_F_EST_ROW_LEN(p_from_date DATE,
72 p_to_date DATE,
73 p_avg_row_len OUT NOCOPY NUMBER) IS
74 p_opi_row_len NUMBER := 0 ;
75 p_pmi_row_len NUMBER := 0 ;
76 BEGIN
77 OPI_EDW_JOB_DETAIL_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
78 OPI_EDW_JOB_DETAIL_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
79 p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
80 END;
81
82
83 -- procedure to count Job Resource Fact rows.
84
85 PROCEDURE OPI_EDW_JOB_RSRC_F_CNT_ROWS(p_from_date DATE,
86 p_to_date DATE,
87 p_num_rows OUT NOCOPY NUMBER) IS
88 p_opi_num_rows NUMBER := 0 ;
89 p_pmi_num_rows NUMBER := 0 ;
90 BEGIN
91 OPI_EDW_JOB_RSRC_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
92 OPI_EDW_JOB_RSRC_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
93 p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
94 END;
95
96 -- procedure to get average row length Job Resource Fact rows.
97
98 PROCEDURE OPI_EDW_JOB_RSRC_F_EST_ROW_LEN(p_from_date DATE,
99 p_to_date DATE,
100 p_avg_row_len OUT NOCOPY NUMBER) IS
101 p_opi_row_len NUMBER := 0 ;
102 p_pmi_row_len NUMBER := 0 ;
103 BEGIN
104 OPI_EDW_JOB_RSRC_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
105 OPI_EDW_JOB_RSRC_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
106 p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
107 END;
108
109
110 -- procedure to count Resource Utilization Fact rows.
111
112 PROCEDURE OPI_EDW_RES_UTIL_F_CNT_ROWS(p_from_date DATE,
113 p_to_date DATE,
114 p_num_rows OUT NOCOPY NUMBER) IS
115 p_opi_num_rows NUMBER := 0 ;
116 p_pmi_num_rows NUMBER := 0 ;
117 BEGIN
118 OPI_EDW_RES_UTIL_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
119 OPI_EDW_RES_UTIL_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
120 p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
121 END;
122
123 -- procedure to get average row length Resource Utilization Fact rows.
124
125 PROCEDURE OPI_EDW_RES_UTIL_F_EST_ROW_LEN(p_from_date DATE,
126 p_to_date DATE,
127 p_avg_row_len OUT NOCOPY NUMBER) IS
128 p_opi_row_len NUMBER := 0 ;
129 p_pmi_row_len NUMBER := 0 ;
130 BEGIN
131 OPI_EDW_RES_UTIL_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
132 OPI_EDW_RES_UTIL_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
133 p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
134 END;
135
136
137 -- procedure to count UOM Conversion Fact rows.
138
139 PROCEDURE OPI_EDW_UOM_CONV_F_CNT_ROWS(p_from_date DATE,
140 p_to_date DATE,
141 p_num_rows OUT NOCOPY NUMBER) IS
142 p_opi_num_rows NUMBER := 0 ;
143 p_pmi_num_rows NUMBER := 0 ;
144 BEGIN
145 OPI_EDW_UOM_CONV_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
146 p_num_rows := p_opi_num_rows;
147 END;
148
149 -- procedure to get average row length UOM Conversion Fact rows.
150
151 PROCEDURE OPI_EDW_UOM_CONV_F_EST_ROW_LEN(p_from_date DATE,
152 p_to_date DATE,
153 p_avg_row_len OUT NOCOPY NUMBER) IS
154 p_opi_row_len NUMBER := 0 ;
155 p_pmi_row_len NUMBER := 0 ;
156 BEGIN
157 OPI_EDW_UOM_CONV_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
158 p_avg_row_len := p_opi_row_len;
159 END;
160
161
162 END;
163