APPS.MSC_POST_PRO dependencies on MSC_ATP_SRC_PROFILE_TEMP

Line 6478: DELETE FROM msc_atp_src_profile_temp

6474:
6475: msc_util.msc_log('Records Deleted from mrp_atp_details_temp : ' ||
6476: SQL%ROWCOUNT);
6477: --bug3940999
6478: DELETE FROM msc_atp_src_profile_temp
6479: WHERE last_update_date < l_retain_date;
6480:
6481: msc_util.msc_log('Records Deleted from msc_atp_src_profile_temp : ' ||
6482: SQL%ROWCOUNT);

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

6477: --bug3940999
6478: DELETE FROM msc_atp_src_profile_temp
6479: WHERE last_update_date < l_retain_date;
6480:
6481: msc_util.msc_log('Records Deleted from msc_atp_src_profile_temp : ' ||
6482: SQL%ROWCOUNT);
6483:
6484: ELSE
6485: msc_util.msc_log('completely purging temp tables');

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

6505: AND b.application_id = 724;
6506:
6507: msc_util.msc_log('l_msc_schema: ' || l_msc_schema );
6508:
6509: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_msc_schema ||'.msc_atp_src_profile_temp';
6510:
6511: END IF;
6512:
6513: commit;