DBA Data[Home] [Help]

APPS.ARP_CORRECT_CCID dependencies on AR_CASH_RECEIPT_HISTORY

Line 131: UPDATE AR_CASH_RECEIPT_HISTORY

127: and code_combination_id = p_old_ccid;
128: END IF;
129:
130: IF (p_source_table = 'CRH' and p_dist_type ='CASH') THEN
131: UPDATE AR_CASH_RECEIPT_HISTORY
132: SET account_code_combination_id = NVL(p_new_ccid,
133: account_code_combination_id),
134: last_update_date = SYSDATE,
135: last_updated_by = arp_global.last_updated_by,

Line 348: UPDATE AR_CASH_RECEIPT_HISTORY crh

344: SQL%ROWCOUNT);
345: END IF;
346:
347: /* correct parent CRH records */
348: UPDATE AR_CASH_RECEIPT_HISTORY crh
349: SET last_update_date = SYSDATE,
350: last_updated_by = arp_global.last_updated_by,
351: last_update_login = arp_global.last_update_login,
352: account_code_combination_id = (

Line 367: arp_standard.debug(' ar_cash_receipt_history rows updated: ' ||

363: AND source_table = 'CRH'
364: AND distribution_type = 'CASH');
365:
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_standard.debug(' ar_cash_receipt_history rows updated: ' ||
368: SQL%ROWCOUNT);
369: END IF;
370:
371: /* correct parent MCD records */