DBA Data[Home] [Help]

APPS.ARP_CTLGD_PKG dependencies on STANDARD

Line 1484: arp_standard.debug('before loop for MRC processing...');

1480: IF (l_count = 0)
1481: THEN RAISE NO_DATA_FOUND;
1482: END IF;
1483:
1484: arp_standard.debug('before loop for MRC processing...');
1485: FOR I in gl_dist_array.FIRST .. gl_dist_array.LAST LOOP
1486: /*-----------------------------------------------------+
1487: | call mrc engine to update RA_CUST_TRX_LINES_GL_DIST |
1488: +-----------------------------------------------------*/

Line 1489: arp_standard.debug('before calling maintain_mrc ');

1485: FOR I in gl_dist_array.FIRST .. gl_dist_array.LAST LOOP
1486: /*-----------------------------------------------------+
1487: | call mrc engine to update RA_CUST_TRX_LINES_GL_DIST |
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',

Line 1490: arp_standard.debug('gl dist array('||to_char(I) || ') = ' || to_char(gl_dist_array(I)));

1486: /*-----------------------------------------------------+
1487: | call mrc engine to update RA_CUST_TRX_LINES_GL_DIST |
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',

Line 2615: | Call the standard dist table handler |

2611: l_dist_rec.posting_control_id := p_posting_control_id;
2612: l_dist_rec.ccid_change_flag := p_ccid_change_flag; /* Bug 8788491 */
2613:
2614: /*----------------------------------------------+
2615: | Call the standard dist table handler |
2616: +----------------------------------------------*/
2617:
2618: lock_compare_p(
2619: l_dist_rec,

Line 2819: arp_standard.debug('calling mrc engine for insertion of gl dist data');

2815: RAISE NO_DATA_FOUND;
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',

Line 2888: arp_standard.debug('calling mrc engine for insertion of gl dist data');

2884: WHERE customer_trx_id = p_customer_trx_id
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',

Line 2989: arp_standard.debug('calling mrc engine for insertion of gl dist data');

2985: WHERE customer_trx_line_id = p_customer_trx_line_id)
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',

Line 3059: arp_standard.debug('calling mrc engine for insertion of gl dist data');

3055: AND account_class = nvl(p_account_class, account_class)
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',

Line 3598: arp_standard.debug('calling mrc engine for update of gl dist data');

3594: /* Bug 3858542 - Added IF condition to prevent failures in
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',

Line 3702: arp_standard.debug('calling mrc engine for update of gl dist data');

3698: BULK COLLECT INTO l_gl_dist_key_value_list;
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',

Line 3917: arp_standard.sysparm.org_id, /* SSA changes anuj */

3913: pg_login_id), /* last_update_login */
3914: pg_prog_appl_id, /* program_application_id */
3915: pg_conc_program_id, /* program_id */
3916: sysdate, /* program_update_date */
3917: arp_standard.sysparm.org_id, /* SSA changes anuj */
3918: p_dist_rec.rounding_correction_flag,
3919: p_dist_rec.ccid_change_flag /* Bug 8788491 */
3920: );
3921:

Line 3924: arp_standard.debug('calling mrc engine for INSERT of gl dist data');

3920: );
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',