APPS.OPI_EDW_DIM_SZ dependencies on OPI_EDW_OPI_ACTV_M_SZ

Line 31: OPI_EDW_OPI_ACTV_M_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;

27: p_num_rows OUT NOCOPY NUMBER) IS
28: p_opi_num_rows NUMBER := 0 ;
29: p_pmi_num_rows NUMBER := 0 ;
30: BEGIN
31: OPI_EDW_OPI_ACTV_M_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
32: EDW_OPI_ACTV_MOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
33: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
34: END;
35: -- procedure to get average row length Activity Dimension rows.

Line 43: OPI_EDW_OPI_ACTV_M_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;

39: p_avg_row_len OUT NOCOPY NUMBER) IS
40: p_opi_row_len NUMBER := 0 ;
41: p_pmi_row_len NUMBER := 0 ;
42: BEGIN
43: OPI_EDW_OPI_ACTV_M_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
44: EDW_OPI_ACTV_MOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
45: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len) ;
46: END;
47: