APPS.OPI_EDW_FACT_SZ dependencies on OPI_EDW_RES_UTIL_F_SZ

Line 118: OPI_EDW_RES_UTIL_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;

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:

Line 131: OPI_EDW_RES_UTIL_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;

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: