eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_MATCH_TAX_PKG dependencies on AR_MRC_ENGINE

Line 496: lv_object_name := 'AR_MRC_ENGINE' ;

492: fetch cur_gl_dist into ln_gl_dist_id;
493: close cur_gl_dist;
494:
495: /* Ramananda for bug#5219225. START. Modified the following if..endif. and the call to be dynamic using execute immediate */
496: lv_object_name := 'AR_MRC_ENGINE' ;
497: lv_procedure_name := 'MAINTAIN_MRC_DATA' ;
498:
499: OPEN c_proc_exists(lv_object_name, lv_procedure_name) ;
500: FETCH c_proc_exists INTO ln_exists ;

Line 506: ar_mrc_engine.maintain_mrc_data(

502: IF ln_exists = 1 THEN
503: --Update the mrc data for ra_cust_trx_line_gl_dist_all
504: --This is done, irrespective of whether the transaction_type is CM or Invoice
505: /* Commented for bug# 5219225
506: ar_mrc_engine.maintain_mrc_data(
507: p_event_mode => 'UPDATE',
508: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
509: p_mode => 'SINGLE',
510: p_key_value => ln_gl_dist_id); */

Line 512: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(

508: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
509: p_mode => 'SINGLE',
510: p_key_value => ln_gl_dist_id); */
511:
512: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
513: p_event_mode => ''UPDATE'',
514: p_table_name => ''RA_CUST_TRX_LINE_GL_DIST'',
515: p_mode => ''SINGLE'',
516: p_key_value => :1

Line 526: ar_mrc_engine.maintain_mrc_data(

522: IF p_called_from = lv_imported_trx THEN
523: FOR rec_mrc IN cur_payment_schedule_mrc(p_customer_trx_id)
524: LOOP
525: /* Commented for bug# 5219225
526: ar_mrc_engine.maintain_mrc_data(
527: p_event_mode => 'UPDATE',
528: p_table_name => 'AR_PAYMENT_SCHEDULES',
529: p_mode => 'SINGLE',
530: p_key_value => rec_mrc.payment_schedule_id); */

Line 532: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(

528: p_table_name => 'AR_PAYMENT_SCHEDULES',
529: p_mode => 'SINGLE',
530: p_key_value => rec_mrc.payment_schedule_id); */
531:
532: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
533: p_event_mode => ''UPDATE'',
534: p_table_name => ''AR_PAYMENT_SCHEDULES'',
535: p_mode => ''SINGLE'',
536: p_key_value => :1

Line 549: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(

545:
546: FOR rec_mrc IN cur_payment_schedule_mrc(p_previous_cust_trx_id)
547: LOOP
548:
549: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
550: p_event_mode => ''UPDATE'',
551: p_table_name => ''AR_PAYMENT_SCHEDULES'',
552: p_mode => ''SINGLE'',
553: p_key_value => :1

Line 566: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(

562: where customer_trx_id = p_customer_trx_id
563: )
564: LOOP
565:
566: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
567: p_event_mode => ''UPDATE'',
568: p_table_name => ''AR_RECEIVABLE_APPLICATIONS'',
569: p_mode => ''SINGLE'',
570: p_key_value => :1

Line 946: lv_object_name := 'AR_MRC_ENGINE' ;

942: p_set_of_books_id,
943: p_event_id); --added for bug#7645588
944:
945: /* Ramananda for bug#5219225. START */
946: lv_object_name := 'AR_MRC_ENGINE' ;
947: lv_procedure_name := 'MAINTAIN_MRC_DATA' ;
948:
949: p_seq_id := ln_cust_trx_line_gl_dist_id ;
950: OPEN c_proc_exists(lv_object_name, lv_procedure_name) ;

Line 955: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(

951: FETCH c_proc_exists INTO ln_exists ;
952: CLOSE c_proc_exists ;
953: IF ln_exists = 1 THEN
954:
955: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
956: p_event_mode => ''INSERT'',
957: p_table_name => ''RA_CUST_TRX_LINE_GL_DIST'',
958: p_mode => ''SINGLE'',
959: p_key_value => :1

Line 1094: lv_object_name := 'AR_MRC_ENGINE' ;

1090: p_process_status := jai_constants.successful;
1091: p_process_message := NULL;
1092:
1093: /* Ramananda for bug#5219225. START */
1094: lv_object_name := 'AR_MRC_ENGINE' ;
1095: lv_procedure_name := 'MAINTAIN_MRC_DATA' ;
1096:
1097: OPEN c_proc_exists(lv_object_name, lv_procedure_name) ;
1098: FETCH c_proc_exists INTO ln_exists ;

Line 1117: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(

1113: )
1114: )
1115: LOOP
1116:
1117: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1118: p_event_mode =>''DELETE'',
1119: p_table_name =>''RA_CUST_TRX_LINE_GL_DIST'',
1120: p_mode =>''SINGLE'',
1121: p_key_value => :1

Line 2780: ar_mrc_engine.maintain_mrc_data(

2776: AND LINE_TYPE IN (lv_tax_const,lv_freight_acc_class) --rchandan for bug#4428980
2777: )
2778: )
2779: Loop
2780: ar_mrc_engine.maintain_mrc_data(
2781: p_event_mode => 'DELETE',
2782: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2783: p_mode => 'SINGLE',
2784: p_key_value => mrc_rec.CUST_TRX_LINE_GL_DIST_ID

Line 3001: ar_mrc_engine.maintain_mrc_data(

2997: ARP_XLA_EVENTS.CREATE_EVENTS(p_xla_ev_rec => l_xla_event);
2998:
2999:
3000: -- code for mrc insert starts here -- bug # 3326394
3001: ar_mrc_engine.maintain_mrc_data(
3002: p_event_mode => 'INSERT',
3003: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3004: p_mode => 'SINGLE',
3005: p_key_value => v_gl_dist_id);

Line 3079: ar_mrc_engine.maintain_mrc_data(

3075: fetch c_gl_dist_cur into v_gl_dist_id;
3076: close c_gl_dist_cur;
3077:
3078:
3079: ar_mrc_engine.maintain_mrc_data(
3080: p_event_mode => 'UPDATE',
3081: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3082: p_mode => 'SINGLE',
3083: p_key_value => v_gl_dist_id);