APPS.MSC_POST_PRO dependencies on MRP_ATP_DETAILS_TEMP

Line 6457: * Deletes entries from mrp_atp_schedule_temp and mrp_atp_details_temp

6453:
6454: /*
6455: * dsting 7/24/2002
6456: *
6457: * Deletes entries from mrp_atp_schedule_temp and mrp_atp_details_temp
6458: * older than p_hours old
6459: *
6460: */
6461: PROCEDURE ATP_Purge_MRP_Temp(

Line 6501: DELETE FROM mrp_atp_details_temp

6497:
6498: --3670695: issue commit so that rollback segment is freed
6499: commit;
6500:
6501: DELETE FROM mrp_atp_details_temp
6502: WHERE last_update_date < l_retain_date;
6503:
6504: msc_util.msc_log('Records Deleted from mrp_atp_details_temp : ' ||
6505: SQL%ROWCOUNT);

Line 6504: msc_util.msc_log('Records Deleted from mrp_atp_details_temp : ' ||

6500:
6501: DELETE FROM mrp_atp_details_temp
6502: WHERE last_update_date < l_retain_date;
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;

Line 6526: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_mrp_schema ||'.mrp_atp_details_temp';

6522:
6523: msc_util.msc_log('l_mrp_schema: ' || l_mrp_schema );
6524: --bug3545959 end
6525: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_mrp_schema ||'.mrp_atp_schedule_temp';
6526: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_mrp_schema ||'.mrp_atp_details_temp';
6527:
6528: --bug3940999
6529: SELECT a.oracle_username
6530: INTO l_msc_schema