1134: ----------------------------------------------------------------------
1135: l_debug_info := 'Insert into Perdiem Daily Breakups.';
1136: ----------------------------------------------------------------------
1137:
1138: insert into oie_pdm_daily_breakups_arc (
1139: ARC_REQ_ID,
1140: ARCHIVE_DATE,
1141: PDM_DAILY_BREAKUP_ID,
1142: REPORT_LINE_ID,
1513:
1514: DELETE FROM oie_pdm_daily_breakups
1515: WHERE pdm_daily_breakup_id IN (
1516: SELECT pdm_daily_breakup_id
1517: FROM oie_pdm_daily_breakups_arc
1518: WHERE arc_req_id = p_request_id);
1519:
1520: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Perdiem Daily Breakups');
1521: