APPS.OPI_EDW_DIM_SZ dependencies on EDW_OPI_LOT_MOPM_SZ

Line 57: EDW_OPI_LOT_MOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;

53: p_opi_num_rows NUMBER := 0 ;
54: p_pmi_num_rows NUMBER := 0 ;
55: BEGIN
56: OPI_EDW_OPI_LOT_M_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
57: EDW_OPI_LOT_MOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
58: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
59: END;
60: -- procedure to get average row length Lot Dimension rows.
61:

Line 69: EDW_OPI_LOT_MOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;

65: p_opi_row_len NUMBER := 0 ;
66: p_pmi_row_len NUMBER := 0 ;
67: BEGIN
68: OPI_EDW_OPI_LOT_M_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
69: EDW_OPI_LOT_MOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
70: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len) ;
71: END;
72:
73: