APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on PMI_SUMMARY_LOG_TABLE

Line 486: FROM PMI_SUMMARY_LOG_TABLE

482: l_table_owner VARCHAR2(40);
483: -- Cursors and cursor row type variables
484: CURSOR cur_bisopm_onhand IS
485: SELECT LAST_RUN_DATE,ATTR1
486: FROM PMI_SUMMARY_LOG_TABLE
487: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
488: CURSOR cur_last_trans_eff_date IS
489: SELECT min(trans_date)
490: from (Select (min(trans_date)) trans_date

Line 547: UPDATE PMI_SUMMARY_LOG_TABLE

543: CLOSE cur_last_trans_eff_date;
544: l_start_population_date := least(nvl(trunc(l_last_run_date),trunc(SYSDATE)),trunc(l_last_trns_eff_date));
545: populate_summary(l_start_population_date,l_log_end_date);
546: BEGIN
547: UPDATE PMI_SUMMARY_LOG_TABLE
548: SET LAST_RUN_DATE = l_log_end_date,
549: ATTR1 = PV_conv_uom
550: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
551: IF SQL%ROWCOUNT = 0 THEN

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

548: SET LAST_RUN_DATE = l_log_end_date,
549: ATTR1 = PV_conv_uom
550: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
551: IF SQL%ROWCOUNT = 0 THEN
552: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)
553: VALUES ('PMI_ONHAND_SALE_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);
554: END IF;
555: END;
556: SELECT TABLE_OWNER INTO l_table_owner