DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on AR_MRC_ENGINE

Line 1058: lv_object_name := 'AR_MRC_ENGINE' ;

1054: fetch cur_gl_dist into ln_gl_dist_id;
1055: close cur_gl_dist;
1056:
1057: /* Ramananda for bug#5219225. START. Modified the following if..endif. and the call to be dynamic using execute immediate */
1058: lv_object_name := 'AR_MRC_ENGINE' ;
1059: lv_procedure_name := 'MAINTAIN_MRC_DATA' ;
1060:
1061: OPEN c_proc_exists(lv_object_name, lv_procedure_name) ;
1062: FETCH c_proc_exists INTO ln_exists ;

Line 1068: ar_mrc_engine.maintain_mrc_data(

1064: IF ln_exists = 1 THEN
1065: --Update the mrc data for ra_cust_trx_line_gl_dist_all
1066: --This is done, irrespective of whether the transaction_type is CM or Invoice
1067: /* Commented for bug# 5219225
1068: ar_mrc_engine.maintain_mrc_data(
1069: p_event_mode => 'UPDATE',
1070: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
1071: p_mode => 'SINGLE',
1072: p_key_value => ln_gl_dist_id); */

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

1070: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
1071: p_mode => 'SINGLE',
1072: p_key_value => ln_gl_dist_id); */
1073:
1074: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1075: p_event_mode => ''UPDATE'',
1076: p_table_name => ''RA_CUST_TRX_LINE_GL_DIST'',
1077: p_mode => ''SINGLE'',
1078: p_key_value => :1

Line 1088: ar_mrc_engine.maintain_mrc_data(

1084: IF p_called_from = lv_imported_trx THEN
1085: FOR rec_mrc IN cur_payment_schedule_mrc(p_customer_trx_id)
1086: LOOP
1087: /* Commented for bug# 5219225
1088: ar_mrc_engine.maintain_mrc_data(
1089: p_event_mode => 'UPDATE',
1090: p_table_name => 'AR_PAYMENT_SCHEDULES',
1091: p_mode => 'SINGLE',
1092: p_key_value => rec_mrc.payment_schedule_id); */

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

1090: p_table_name => 'AR_PAYMENT_SCHEDULES',
1091: p_mode => 'SINGLE',
1092: p_key_value => rec_mrc.payment_schedule_id); */
1093:
1094: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1095: p_event_mode => ''UPDATE'',
1096: p_table_name => ''AR_PAYMENT_SCHEDULES'',
1097: p_mode => ''SINGLE'',
1098: p_key_value => :1

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

1107:
1108: FOR rec_mrc IN cur_payment_schedule_mrc(p_previous_cust_trx_id)
1109: LOOP
1110:
1111: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1112: p_event_mode => ''UPDATE'',
1113: p_table_name => ''AR_PAYMENT_SCHEDULES'',
1114: p_mode => ''SINGLE'',
1115: p_key_value => :1

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

1124: where customer_trx_id = p_customer_trx_id
1125: )
1126: LOOP
1127:
1128: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1129: p_event_mode => ''UPDATE'',
1130: p_table_name => ''AR_RECEIVABLE_APPLICATIONS'',
1131: p_mode => ''SINGLE'',
1132: p_key_value => :1

Line 1508: lv_object_name := 'AR_MRC_ENGINE' ;

1504: p_set_of_books_id,
1505: p_event_id); --added for bug#7645588
1506:
1507: /* Ramananda for bug#5219225. START */
1508: lv_object_name := 'AR_MRC_ENGINE' ;
1509: lv_procedure_name := 'MAINTAIN_MRC_DATA' ;
1510:
1511: p_seq_id := ln_cust_trx_line_gl_dist_id ;
1512: OPEN c_proc_exists(lv_object_name, lv_procedure_name) ;

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

1513: FETCH c_proc_exists INTO ln_exists ;
1514: CLOSE c_proc_exists ;
1515: IF ln_exists = 1 THEN
1516:
1517: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1518: p_event_mode => ''INSERT'',
1519: p_table_name => ''RA_CUST_TRX_LINE_GL_DIST'',
1520: p_mode => ''SINGLE'',
1521: p_key_value => :1

Line 1695: lv_object_name := 'AR_MRC_ENGINE' ;

1691: p_process_status := jai_constants.successful;
1692: p_process_message := NULL;
1693:
1694: /* Ramananda for bug#5219225. START */
1695: lv_object_name := 'AR_MRC_ENGINE' ;
1696: lv_procedure_name := 'MAINTAIN_MRC_DATA' ;
1697:
1698: OPEN c_proc_exists(lv_object_name, lv_procedure_name) ;
1699: FETCH c_proc_exists INTO ln_exists ;

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

1714: )
1715: )
1716: LOOP
1717:
1718: lv_sqlstmt := 'BEGIN ar_mrc_engine.maintain_mrc_data(
1719: p_event_mode =>''DELETE'',
1720: p_table_name =>''RA_CUST_TRX_LINE_GL_DIST'',
1721: p_mode =>''SINGLE'',
1722: p_key_value => :1

Line 3841: ar_mrc_engine.maintain_mrc_data(

3837: AND LINE_TYPE IN (lv_tax_const,lv_freight_acc_class) --rchandan for bug#4428980
3838: )
3839: )
3840: Loop
3841: ar_mrc_engine.maintain_mrc_data(
3842: p_event_mode => 'DELETE',
3843: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3844: p_mode => 'SINGLE',
3845: p_key_value => mrc_rec.CUST_TRX_LINE_GL_DIST_ID

Line 4075: ar_mrc_engine.maintain_mrc_data(

4071: ARP_XLA_EVENTS.CREATE_EVENTS(p_xla_ev_rec => l_xla_event);
4072:
4073:
4074: -- code for mrc insert starts here -- bug # 3326394
4075: ar_mrc_engine.maintain_mrc_data(
4076: p_event_mode => 'INSERT',
4077: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
4078: p_mode => 'SINGLE',
4079: p_key_value => v_gl_dist_id);

Line 4153: ar_mrc_engine.maintain_mrc_data(

4149: fetch c_gl_dist_cur into v_gl_dist_id;
4150: close c_gl_dist_cur;
4151:
4152:
4153: ar_mrc_engine.maintain_mrc_data(
4154: p_event_mode => 'UPDATE',
4155: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
4156: p_mode => 'SINGLE',
4157: p_key_value => v_gl_dist_id);