APPS.OPI_EDW_FACT_SZ dependencies on OPI_EDW_JOB_RSRC_FOPM_SZ

Line 92: OPI_EDW_JOB_RSRC_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;

88: p_opi_num_rows NUMBER := 0 ;
89: p_pmi_num_rows NUMBER := 0 ;
90: BEGIN
91: OPI_EDW_JOB_RSRC_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
92: OPI_EDW_JOB_RSRC_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
93: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
94: END;
95:
96: -- procedure to get average row length Job Resource Fact rows.

Line 105: OPI_EDW_JOB_RSRC_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;

101: p_opi_row_len NUMBER := 0 ;
102: p_pmi_row_len NUMBER := 0 ;
103: BEGIN
104: OPI_EDW_JOB_RSRC_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
105: OPI_EDW_JOB_RSRC_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
106: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
107: END;
108:
109: