93:
94:
95: ELSE
96:
97: /* we need to update ar_distributions */
98:
99: update AR_DISTRIBUTIONS
100: SET code_combination_id = NVL( p_new_ccid, code_combination_id),
101: last_update_date = sysdate,
95: ELSE
96:
97: /* we need to update ar_distributions */
98:
99: update AR_DISTRIBUTIONS
100: SET code_combination_id = NVL( p_new_ccid, code_combination_id),
101: last_update_date = sysdate,
102: last_updated_by = arp_global.last_updated_by,
103: last_update_login = arp_global.last_update_login
297: SQL%ROWCOUNT);
298: END IF;
299:
300: /* Correct AR_DISTRIBUTION ccids */
301: UPDATE AR_DISTRIBUTIONS ard
302: SET last_update_date = SYSDATE,
303: last_updated_by = arp_global.last_updated_by,
304: last_update_login = arp_global.last_update_login,
305: code_combination_id = (