DBA Data[Home] [Help]

APPS.OPI_EDW_FACT_SZ dependencies on OPI_EDW_UOM_CONV_F_SZ

Line 145: OPI_EDW_UOM_CONV_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;

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.

Line 157: OPI_EDW_UOM_CONV_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;

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: