APPS.PMI_BUILD_PROD_SUM dependencies on PMI_SUMMARY_LOG_TABLE

Line 160: FROM PMI_SUMMARY_LOG_TABLE

156:
157: -- Cursors and cursor row type variables
158: CURSOR cur_bisopm_prod IS
159: SELECT LAST_RUN_DATE,ATTR1
160: FROM PMI_SUMMARY_LOG_TABLE
161: WHERE summary_table = 'PMI_PROD_SUM';
162: CURSOR cur_last_trans_eff_date IS
163: SELECT min(trans_date)
164: from (Select (min(trans_date)) trans_date

Line 220: UPDATE PMI_SUMMARY_LOG_TABLE

216: CLOSE cur_last_trans_eff_date;
217: l_start_population_date := least(nvl(trunc(l_last_run_date),trunc(SYSDATE)),trunc(l_last_trns_eff_date));
218: populate_summary(l_start_population_date,l_log_end_date);
219: BEGIN
220: UPDATE PMI_SUMMARY_LOG_TABLE
221: SET LAST_RUN_DATE = l_log_end_date,
222: ATTR1 = PV_conv_uom
223: WHERE summary_table = 'PMI_PROD_SUM';
224: IF SQL%ROWCOUNT = 0 THEN

Line 225: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)

221: SET LAST_RUN_DATE = l_log_end_date,
222: ATTR1 = PV_conv_uom
223: WHERE summary_table = 'PMI_PROD_SUM';
224: IF SQL%ROWCOUNT = 0 THEN
225: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)
226: VALUES ('PMI_PROD_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);
227: END IF;
228: END;
229: