APPS.OPI_EDW_FACT_SZ dependencies on OPI_EDW_JOB_DETAIL_F_SZ

Line 64: OPI_EDW_JOB_DETAIL_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;

60: p_num_rows OUT NOCOPY NUMBER) IS
61: p_opi_num_rows NUMBER := 0 ;
62: p_pmi_num_rows NUMBER := 0 ;
63: BEGIN
64: OPI_EDW_JOB_DETAIL_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
65: OPI_EDW_JOB_DETAIL_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
66: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
67: END;
68:

Line 77: OPI_EDW_JOB_DETAIL_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;

73: p_avg_row_len OUT NOCOPY NUMBER) IS
74: p_opi_row_len NUMBER := 0 ;
75: p_pmi_row_len NUMBER := 0 ;
76: BEGIN
77: OPI_EDW_JOB_DETAIL_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
78: OPI_EDW_JOB_DETAIL_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
79: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
80: END;
81: