APPS.MSC_POST_PRO dependencies on MRP_ATP_SCHEDULE_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 6492: DELETE FROM mrp_atp_schedule_temp

6488: msc_util.msc_log('Now sysdate: ' ||
6489: to_char(sysdate, 'DD:MM:YYYY hh24:mi:ss'));
6490:
6491:
6492: DELETE FROM mrp_atp_schedule_temp
6493: WHERE last_update_date < l_retain_date;
6494:
6495: msc_util.msc_log('Records Deleted from mrp_atp_schedule_temp : ' ||
6496: SQL%ROWCOUNT);

Line 6495: msc_util.msc_log('Records Deleted from mrp_atp_schedule_temp : ' ||

6491:
6492: DELETE FROM mrp_atp_schedule_temp
6493: WHERE last_update_date < l_retain_date;
6494:
6495: msc_util.msc_log('Records Deleted from mrp_atp_schedule_temp : ' ||
6496: SQL%ROWCOUNT);
6497:
6498: --3670695: issue commit so that rollback segment is freed
6499: commit;

Line 6525: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_mrp_schema ||'.mrp_atp_schedule_temp';

6521: AND b.application_id = 704;
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