APPS.MSC_POST_PRO dependencies on MRP_ATP_DETAILS_TEMP

Line 6428: * Deletes entries from mrp_atp_schedule_temp and mrp_atp_details_temp

6424:
6425: /*
6426: * dsting 7/24/2002
6427: *
6428: * Deletes entries from mrp_atp_schedule_temp and mrp_atp_details_temp
6429: * older than p_hours old
6430: *
6431: */
6432: PROCEDURE ATP_Purge_MRP_Temp(

Line 6472: DELETE FROM mrp_atp_details_temp

6468:
6469: --3670695: issue commit so that rollback segment is freed
6470: commit;
6471:
6472: DELETE FROM mrp_atp_details_temp
6473: WHERE last_update_date < l_retain_date;
6474:
6475: msc_util.msc_log('Records Deleted from mrp_atp_details_temp : ' ||
6476: SQL%ROWCOUNT);

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

6471:
6472: DELETE FROM mrp_atp_details_temp
6473: WHERE last_update_date < l_retain_date;
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;

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

6493:
6494: msc_util.msc_log('l_mrp_schema: ' || l_mrp_schema );
6495: --bug3545959 end
6496: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_mrp_schema ||'.mrp_atp_schedule_temp';
6497: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_mrp_schema ||'.mrp_atp_details_temp';
6498:
6499: --bug3940999
6500: SELECT a.oracle_username
6501: INTO l_msc_schema