APPS.MSC_POST_PRO dependencies on MSC_ATP_SRC_PROFILE_TEMP

Line 6507: DELETE FROM msc_atp_src_profile_temp

6503:
6504: msc_util.msc_log('Records Deleted from mrp_atp_details_temp : ' ||
6505: SQL%ROWCOUNT);
6506: --bug3940999
6507: DELETE FROM msc_atp_src_profile_temp
6508: WHERE last_update_date < l_retain_date;
6509:
6510: msc_util.msc_log('Records Deleted from msc_atp_src_profile_temp : ' ||
6511: SQL%ROWCOUNT);

Line 6510: msc_util.msc_log('Records Deleted from msc_atp_src_profile_temp : ' ||

6506: --bug3940999
6507: DELETE FROM msc_atp_src_profile_temp
6508: WHERE last_update_date < l_retain_date;
6509:
6510: msc_util.msc_log('Records Deleted from msc_atp_src_profile_temp : ' ||
6511: SQL%ROWCOUNT);
6512:
6513: ELSE
6514: msc_util.msc_log('completely purging temp tables');

Line 6538: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_msc_schema ||'.msc_atp_src_profile_temp';

6534: AND b.application_id = 724;
6535:
6536: msc_util.msc_log('l_msc_schema: ' || l_msc_schema );
6537:
6538: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_msc_schema ||'.msc_atp_src_profile_temp';
6539:
6540: END IF;
6541:
6542: commit;