APPS.OPI_EDW_FACT_SZ dependencies on OPI_EDW_COGS_FOPM_SZ

Line 13: OPI_EDW_COGS_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;

9: p_opi_num_rows NUMBER := 0 ;
10: p_pmi_num_rows NUMBER := 0 ;
11: BEGIN
12: OPI_EDW_COGS_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
13: OPI_EDW_COGS_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
14: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
15: END;
16:
17: -- procedure to get average row length COGS Fact rows.

Line 26: OPI_EDW_COGS_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;

22: p_opi_row_len NUMBER := 0 ;
23: p_pmi_row_len NUMBER := 0 ;
24: BEGIN
25: OPI_EDW_COGS_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
26: OPI_EDW_COGS_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
27: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
28: END;
29:
30: -- procedure to count Inventory Daily Status Fact rows.