DBA Data[Home] [Help]

APPS.ARP_CORRECT_CCID dependencies on AR_ADJUSTMENTS

Line 111: update AR_ADJUSTMENTS

107: IF ( p_source_table = 'ADJ' and p_dist_type = 'ADJ' ) THEN
108: /* We need to update the parent record if the distribution
109: type is ADJ */
110:
111: update AR_ADJUSTMENTS
112: SET code_combination_id = NVL(p_new_ccid, code_combination_id),
113: last_update_date = sysdate,
114: last_updated_by = arp_global.last_updated_by,
115: last_update_login = arp_global.last_update_login

Line 324: UPDATE AR_ADJUSTMENTS adj

320: SQL%ROWCOUNT);
321: END IF;
322:
323: /* correct parent ADJ records */
324: UPDATE AR_ADJUSTMENTS adj
325: SET last_update_date = SYSDATE,
326: last_updated_by = arp_global.last_updated_by,
327: last_update_login = arp_global.last_update_login,
328: code_combination_id = (

Line 343: arp_standard.debug(' ar_adjustments rows updated: ' ||

339: AND source_table = 'ADJ'
340: AND distribution_type = 'ADJ');
341:
342: IF PG_DEBUG in ('Y', 'C') THEN
343: arp_standard.debug(' ar_adjustments rows updated: ' ||
344: SQL%ROWCOUNT);
345: END IF;
346:
347: /* correct parent CRH records */