DBA Data[Home] [Help]

APPS.ARP_CTLGD_PKG dependencies on AR_MRC_ENGINE

Line 1492: ar_mrc_engine.maintain_mrc_data(

1488: +-----------------------------------------------------*/
1489: arp_standard.debug('before calling maintain_mrc ');
1490: arp_standard.debug('gl dist array('||to_char(I) || ') = ' || to_char(gl_dist_array(I)));
1491:
1492: ar_mrc_engine.maintain_mrc_data(
1493: p_event_mode => 'UPDATE',
1494: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
1495: p_mode => 'SINGLE',
1496: p_key_value => gl_dist_array(I));

Line 2820: ar_mrc_engine.maintain_mrc_data(

2816: END IF;
2817:
2818: /* call mrc api to delete */
2819: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2820: ar_mrc_engine.maintain_mrc_data(
2821: p_event_mode => 'DELETE',
2822: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2823: p_mode => 'SINGLE',
2824: p_key_value => p_cust_trx_line_gl_dist_id);

Line 2889: ar_mrc_engine.maintain_mrc_data(

2885: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2886: AND account_class = nvl(p_account_class, account_class);
2887:
2888: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2889: ar_mrc_engine.maintain_mrc_data(
2890: p_event_mode => 'DELETE',
2891: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2892: p_mode => 'BATCH',
2893: p_key_value_list => l_gl_dist_key_value_list);

Line 2990: ar_mrc_engine.maintain_mrc_data(

2986: and account_class = 'REC'
2987: and account_set_flag = 'N';
2988:
2989: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2990: ar_mrc_engine.maintain_mrc_data(
2991: p_event_mode => 'DELETE',
2992: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2993: p_mode => 'BATCH',
2994: p_key_value_list => l_gl_dist_key_value_list);

Line 3060: ar_mrc_engine.maintain_mrc_data(

3056: RETURNING cust_trx_line_gl_dist_id
3057: BULK COLLECT INTO l_gl_dist_key_value_list;
3058:
3059: arp_standard.debug('calling mrc engine for insertion of gl dist data');
3060: ar_mrc_engine.maintain_mrc_data(
3061: p_event_mode => 'DELETE',
3062: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3063: p_mode => 'BATCH',
3064: p_key_value_list => l_gl_dist_key_value_list);

Line 3599: ar_mrc_engine.maintain_mrc_data(

3595: MRC code when no rows will be updated */
3596: IF (SQL%ROWCOUNT > 0 )
3597: THEN
3598: arp_standard.debug('calling mrc engine for update of gl dist data');
3599: ar_mrc_engine.maintain_mrc_data(
3600: p_event_mode => 'UPDATE',
3601: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3602: p_mode => 'BATCH',
3603: p_key_value_list => l_gl_dist_key_value_list);

Line 3703: ar_mrc_engine.maintain_mrc_data(

3699: IF (SQL%ROWCOUNT > 0 ) then
3700: /* Used arp_global.request_id for bug3620556 */
3701: IF arp_global.request_id is NULL then
3702: arp_standard.debug('calling mrc engine for update of gl dist data');
3703: ar_mrc_engine.maintain_mrc_data(
3704: p_event_mode => 'UPDATE',
3705: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3706: p_mode => 'BATCH',
3707: p_key_value_list => l_gl_dist_key_value_list);

Line 3925: ar_mrc_engine.maintain_mrc_data(

3921:
3922: p_cust_trx_line_gl_dist_id := l_cust_trx_line_gl_dist_id;
3923:
3924: arp_standard.debug('calling mrc engine for INSERT of gl dist data');
3925: ar_mrc_engine.maintain_mrc_data(
3926: p_event_mode => 'INSERT',
3927: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3928: p_mode => 'SINGLE',
3929: p_key_value => p_cust_trx_line_gl_dist_id);