DBA Data[Home] [Help]

APPS.ARP_CORRECT_CCID dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 85: UPDATE RA_CUST_TRX_LINE_GL_DIST

81: /* if we are dealing with GL DIST Records */
82: IF (p_source_table = 'GLD') THEN
83:
84: /* update the distribution record */
85: UPDATE RA_CUST_TRX_LINE_GL_DIST
86: SET code_combination_id = nvl(p_new_ccid, code_combination_id),
87: last_update_date = SYSDATE,
88: last_updated_by = arp_global.last_updated_by,
89: last_update_login = arp_global.last_update_login

Line 278: UPDATE RA_CUST_TRX_LINE_GL_DIST gld

274: arp_standard.debug(' p_submission_id :' || p_submission_id);
275: END IF;
276:
277: /* Correct GL_DIST ccids */
278: UPDATE RA_CUST_TRX_LINE_GL_DIST gld
279: SET last_update_date = SYSDATE,
280: last_updated_by = arp_global.last_updated_by,
281: last_update_login = arp_global.last_update_login,
282: code_combination_id = (

Line 296: arp_standard.debug(' ra_cust_trx_line_gl_dist rows updated: ' ||

292: WHERE submission_id = p_submission_id
293: AND source_table = 'GLD');
294:
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_standard.debug(' ra_cust_trx_line_gl_dist rows updated: ' ||
297: SQL%ROWCOUNT);
298: END IF;
299:
300: /* Correct AR_DISTRIBUTION ccids */