773: ----------------------------------------------------------------------
774: l_debug_info := 'Insert into CC Transactions.';
775: ----------------------------------------------------------------------
776:
777: insert into ap_credit_card_trxns_arc (
778: ARC_REQ_ID,
779: ARCHIVE_DATE,
780: TRX_ID,
781: VALIDATE_CODE,
1552:
1553: DELETE FROM ap_credit_card_trxns_all
1554: WHERE report_header_id IN (
1555: SELECT report_header_id
1556: FROM ap_credit_card_trxns_arc
1557: WHERE arc_req_id = p_request_id);
1558:
1559: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' CC Transactions');
1560: