DBA Data[Home] [Help]

APPS.ARP_CORRECT_CCID dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 121: UPDATE AR_MISC_CASH_DISTRIBUTIONS

117: AND code_combination_id = p_old_ccid;
118: END IF;
119:
120: IF (p_source_table = 'MCD' and p_dist_type = 'MISCCASH') then
121: UPDATE AR_MISC_CASH_DISTRIBUTIONS
122: SET code_combination_id = NVL(p_new_ccid, code_combination_id),
123: last_update_date = SYSDATE,
124: last_updated_by = arp_global.last_updated_by,
125: last_update_login = arp_global.last_update_login

Line 372: UPDATE AR_MISC_CASH_DISTRIBUTIONS mcd

368: SQL%ROWCOUNT);
369: END IF;
370:
371: /* correct parent MCD records */
372: UPDATE AR_MISC_CASH_DISTRIBUTIONS mcd
373: SET last_update_date = SYSDATE,
374: last_updated_by = arp_global.last_updated_by,
375: last_update_login = arp_global.last_update_login,
376: code_combination_id = (

Line 391: arp_standard.debug(' ar_misc_cash_distributions rows updated: ' ||

387: AND source_table = 'MCD'
388: AND distribution_type = 'MISCCASH');
389:
390: IF PG_DEBUG in ('Y', 'C') THEN
391: arp_standard.debug(' ar_misc_cash_distributions rows updated: ' ||
392: SQL%ROWCOUNT);
393: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()-');
394: END IF;
395: