DBA Data[Home] [Help]

APPS.OPI_EDW_DIM_SZ dependencies on EDW_OPI_OPRN_MOPM_SZ

Line 83: EDW_OPI_OPRN_MOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;

79: p_opi_num_rows NUMBER := 0 ;
80: p_pmi_num_rows NUMBER := 0 ;
81: BEGIN
82: OPI_EDW_OPI_OPRN_M_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
83: EDW_OPI_OPRN_MOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
84: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
85: END;
86:
87: -- procedure to get average row length Production Operation Dimension rows.

Line 96: EDW_OPI_OPRN_MOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;

92: p_opi_row_len NUMBER := 0 ;
93: p_pmi_row_len NUMBER := 0 ;
94: BEGIN
95: OPI_EDW_OPI_OPRN_M_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
96: EDW_OPI_OPRN_MOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
97: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
98: END;
99:
100: