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.ARP_MAINTAIN_PS dependencies on AR_PAYMENT_SCHEDULES

Line 944: FROM ar_payment_schedules ps

940: --
941: BEGIN
942:
943: DELETE
944: FROM ar_payment_schedules ps
945: WHERE ps.customer_trx_id = p_customer_trx_id
946: RETURNING ps.payment_schedule_id
947: BULK COLLECT INTO l_ar_ps_key_value_list;
948:

Line 958: p_table_name => 'AR_PAYMENT_SCHEDULES',

954: +-------------------------------*/
955:
956: ar_mrc_engine.maintain_mrc_data(
957: p_event_mode => 'DELETE',
958: p_table_name => 'AR_PAYMENT_SCHEDULES',
959: p_mode => 'BATCH',
960: p_key_value_list => l_ar_ps_key_value_list);
961:
962: EXCEPTION

Line 1155: UPDATE ar_payment_schedules ps

1151: print_fcn_label( 'arp_maintain_ps.reverse_adjustments()+' );
1152:
1153: BEGIN
1154:
1155: UPDATE ar_payment_schedules ps
1156: SET (
1157: ps.status,
1158: ps.gl_date_closed,
1159: ps.actual_date_closed,

Line 1226: ar_payment_schedules ps2,

1222: trunc(sysdate),
1223: p_profile_info.conc_login_id
1224: FROM
1225: ar_adjustments adj,
1226: ar_payment_schedules ps2,
1227: ar_adjustments adj2,
1228: ar_receivable_applications ra2
1229: WHERE adj.receivables_trx_id =-1
1230: and adj.customer_trx_id = p_customer_trx_id

Line 1278: p_table_name => 'AR_PAYMENT_SCHEDULES',

1274: +---------------------------------*/
1275:
1276: ar_mrc_engine.maintain_mrc_data(
1277: p_event_mode => 'UPDATE',
1278: p_table_name => 'AR_PAYMENT_SCHEDULES',
1279: p_mode => 'BATCH',
1280: p_key_value_list => l_ar_ps_key_value_list);
1281:
1282: EXCEPTION

Line 1331: UPDATE ar_payment_schedules ps

1327: print_fcn_label( 'arp_maintain_ps.reverse_cm_effect()+' );
1328:
1329: BEGIN
1330:
1331: UPDATE ar_payment_schedules ps
1332: SET (
1333: status,
1334: gl_date_closed,
1335: actual_date_closed,

Line 1379: ar_payment_schedules ps2,

1375: trunc(sysdate),
1376: p_profile_info.conc_login_id
1377: FROM
1378: ar_receivable_applications ra,
1379: ar_payment_schedules ps2,
1380: ar_adjustments adj2,
1381: ar_receivable_applications ra2
1382: WHERE ra.customer_trx_id = p_customer_trx_id
1383: and ra.status||'' = 'APP'

Line 1427: p_table_name => 'AR_PAYMENT_SCHEDULES',

1423: +---------------------------------*/
1424:
1425: ar_mrc_engine.maintain_mrc_data(
1426: p_event_mode => 'UPDATE',
1427: p_table_name => 'AR_PAYMENT_SCHEDULES',
1428: p_mode => 'BATCH',
1429: p_key_value_list => l_ar_ps_key_value_list);
1430:
1431: EXCEPTION

Line 1573: ar_payment_schedules ps_cm,

1569: l_inv_adr,
1570: l_inv_acctd_adr,
1571: l_inv_rate
1572: FROM
1573: ar_payment_schedules ps_cm,
1574: ar_payment_schedules ps_inv,
1575: ar_receivable_applications ra
1576: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
1577: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id

Line 1574: ar_payment_schedules ps_inv,

1570: l_inv_acctd_adr,
1571: l_inv_rate
1572: FROM
1573: ar_payment_schedules ps_cm,
1574: ar_payment_schedules ps_inv,
1575: ar_receivable_applications ra
1576: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
1577: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id
1578: and ps_inv.payment_schedule_id = p_control.payment_schedule_id

Line 1637: UPDATE ar_payment_schedules ps

1633: ----------------------------------------------------------------
1634: -- Reverse the origial CM application amounts and use the new
1635: -- amounts passed in for the invoice's payment schedule.
1636: ----------------------------------------------------------------
1637: UPDATE ar_payment_schedules ps
1638: SET (
1639: ps.status,
1640: ps.gl_date_closed,
1641: ps.actual_date_closed,

Line 1711: ar_payment_schedules ps2,

1707: trunc(sysdate),
1708: p_profile_info.conc_login_id
1709: FROM
1710: ar_receivable_applications ra,
1711: ar_payment_schedules ps2,
1712: ar_receivable_applications ra2,
1713: ar_adjustments adj2
1714: WHERE ra.customer_trx_id = p_control.customer_trx_id
1715: and ra.status||'' = 'APP'

Line 1765: p_table_name => 'AR_PAYMENT_SCHEDULES',

1761: +---------------------------------*/
1762:
1763: ar_mrc_engine.maintain_mrc_data(
1764: p_event_mode => 'UPDATE',
1765: p_table_name => 'AR_PAYMENT_SCHEDULES',
1766: p_mode => 'BATCH',
1767: p_key_value_list => l_ar_ps_key_value_list);
1768:
1769: EXCEPTION

Line 2226: ar_payment_schedules ps_cm,

2222: l_inv_acctd_adr,
2223: l_inv_rate,
2224: l_new_adj_amount
2225: FROM
2226: ar_payment_schedules ps_cm,
2227: ar_payment_schedules ps_inv,
2228: ar_receivable_applications ra
2229: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
2230: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id

Line 2227: ar_payment_schedules ps_inv,

2223: l_inv_rate,
2224: l_new_adj_amount
2225: FROM
2226: ar_payment_schedules ps_cm,
2227: ar_payment_schedules ps_inv,
2228: ar_receivable_applications ra
2229: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
2230: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id
2231: and ps_inv.payment_schedule_id = p_control.payment_schedule_id

Line 2615: UPDATE ar_payment_schedules ps

2611: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2612:
2613: BEGIN
2614:
2615: UPDATE ar_payment_schedules ps
2616: SET (
2617: ps.status,
2618: ps.gl_date_closed,
2619: ps.actual_date_closed,

Line 2692: ar_payment_schedules ps2,

2688: trunc(sysdate),
2689: p_profile_info.conc_login_id
2690: FROM
2691: ar_receivable_applications ra,
2692: ar_payment_schedules ps2,
2693: ar_receivable_applications ra2,
2694: ar_adjustments adj2
2695: WHERE ra.customer_trx_id = p_control.customer_trx_id
2696: and ra.status||'' = 'APP'

Line 2736: p_table_name => 'AR_PAYMENT_SCHEDULES',

2732: +---------------------------------*/
2733:
2734: ar_mrc_engine.maintain_mrc_data(
2735: p_event_mode => 'UPDATE',
2736: p_table_name => 'AR_PAYMENT_SCHEDULES',
2737: p_mode => 'BATCH',
2738: p_key_value_list => l_ar_ps_key_value_list);
2739:
2740: EXCEPTION

Line 2998: FROM ar_payment_schedules

2994: print_fcn_label( 'arp_maintain_ps.ps_records_exist()+' );
2995:
2996: SELECT 1
2997: INTO l_temp
2998: FROM ar_payment_schedules
2999: WHERE customer_trx_id = p_customer_trx_id;
3000:
3001: print_fcn_label( 'arp_maintain_ps.ps_records_exist()-' );
3002: