DBA Data[Home] [Help]

APPS.OPI_EDW_DIM_SZ dependencies on OPI_EDW_OPI_PRDL_M_SZ

Line 109: OPI_EDW_OPI_PRDL_M_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;

105: p_num_rows OUT NOCOPY NUMBER) IS
106: p_opi_num_rows NUMBER := 0 ;
107: p_pmi_num_rows NUMBER := 0 ;
108: BEGIN
109: OPI_EDW_OPI_PRDL_M_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
110: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
111: END;
112:
113: -- procedure to get average row length Production Line Dimension rows.

Line 121: OPI_EDW_OPI_PRDL_M_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;

117: p_avg_row_len OUT NOCOPY NUMBER) IS
118: p_opi_row_len NUMBER := 0 ;
119: p_pmi_row_len NUMBER := 0 ;
120: BEGIN
121: OPI_EDW_OPI_PRDL_M_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
122: p_avg_row_len := p_opi_row_len;
123: END;
124:
125: END OPI_EDW_DIM_SZ;