DBA Data[Home] [Help]

APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_CREDIT_CARD_TRXNS_ARC

Line 777: insert into ap_credit_card_trxns_arc (

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,

Line 1556: FROM ap_credit_card_trxns_arc

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: