APPS.OPI_EDW_FACT_SZ dependencies on OPI_EDW_INV_DAILY_STAT_F_SZ

Line 38: OPI_EDW_INV_DAILY_STAT_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;

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:

Line 51: OPI_EDW_INV_DAILY_STAT_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;

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: