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 1201: UPDATE ar_payment_schedules ps

1197: print_fcn_label( 'arp_maintain_ps.reverse_adjustments()+' );
1198:
1199: BEGIN
1200:
1201: UPDATE ar_payment_schedules ps
1202: SET (
1203: ps.status,
1204: ps.gl_date_closed,
1205: ps.actual_date_closed,

Line 1272: ar_payment_schedules ps2,

1268: trunc(sysdate),
1269: p_profile_info.conc_login_id
1270: FROM
1271: ar_adjustments adj,
1272: ar_payment_schedules ps2,
1273: ar_adjustments adj2,
1274: ar_receivable_applications ra2
1275: WHERE adj.receivables_trx_id =-1
1276: and adj.customer_trx_id = p_customer_trx_id

Line 1324: p_table_name => 'AR_PAYMENT_SCHEDULES',

1320: +---------------------------------*/
1321:
1322: ar_mrc_engine.maintain_mrc_data(
1323: p_event_mode => 'UPDATE',
1324: p_table_name => 'AR_PAYMENT_SCHEDULES',
1325: p_mode => 'BATCH',
1326: p_key_value_list => l_ar_ps_key_value_list);
1327:
1328: EXCEPTION

Line 1379: UPDATE ar_payment_schedules ps

1375: print_fcn_label( 'arp_maintain_ps.reverse_cm_effect()+' );
1376:
1377: BEGIN
1378:
1379: UPDATE ar_payment_schedules ps
1380: SET (
1381: status,
1382: gl_date_closed,
1383: actual_date_closed,

Line 1427: ar_payment_schedules ps2,

1423: trunc(sysdate),
1424: p_profile_info.conc_login_id
1425: FROM
1426: ar_receivable_applications ra,
1427: ar_payment_schedules ps2,
1428: ar_adjustments adj2,
1429: ar_receivable_applications ra2
1430: WHERE ra.customer_trx_id = p_customer_trx_id
1431: and ra.status||'' = 'APP'

Line 1475: p_table_name => 'AR_PAYMENT_SCHEDULES',

1471: +---------------------------------*/
1472:
1473: ar_mrc_engine.maintain_mrc_data(
1474: p_event_mode => 'UPDATE',
1475: p_table_name => 'AR_PAYMENT_SCHEDULES',
1476: p_mode => 'BATCH',
1477: p_key_value_list => l_ar_ps_key_value_list);
1478:
1479: EXCEPTION

Line 1621: ar_payment_schedules ps_cm,

1617: l_inv_adr,
1618: l_inv_acctd_adr,
1619: l_inv_rate
1620: FROM
1621: ar_payment_schedules ps_cm,
1622: ar_payment_schedules ps_inv,
1623: ar_receivable_applications ra
1624: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
1625: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id

Line 1622: ar_payment_schedules ps_inv,

1618: l_inv_acctd_adr,
1619: l_inv_rate
1620: FROM
1621: ar_payment_schedules ps_cm,
1622: ar_payment_schedules ps_inv,
1623: ar_receivable_applications ra
1624: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
1625: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id
1626: and ps_inv.payment_schedule_id = p_control.payment_schedule_id

Line 1685: UPDATE ar_payment_schedules ps

1681: ----------------------------------------------------------------
1682: -- Reverse the origial CM application amounts and use the new
1683: -- amounts passed in for the invoice's payment schedule.
1684: ----------------------------------------------------------------
1685: UPDATE ar_payment_schedules ps
1686: SET (
1687: ps.status,
1688: ps.gl_date_closed,
1689: ps.actual_date_closed,

Line 1759: ar_payment_schedules ps2,

1755: trunc(sysdate),
1756: p_profile_info.conc_login_id
1757: FROM
1758: ar_receivable_applications ra,
1759: ar_payment_schedules ps2,
1760: ar_receivable_applications ra2,
1761: ar_adjustments adj2
1762: WHERE ra.customer_trx_id = p_control.customer_trx_id
1763: and ra.status||'' = 'APP'

Line 1813: p_table_name => 'AR_PAYMENT_SCHEDULES',

1809: +---------------------------------*/
1810:
1811: ar_mrc_engine.maintain_mrc_data(
1812: p_event_mode => 'UPDATE',
1813: p_table_name => 'AR_PAYMENT_SCHEDULES',
1814: p_mode => 'BATCH',
1815: p_key_value_list => l_ar_ps_key_value_list);
1816:
1817: EXCEPTION

Line 2274: ar_payment_schedules ps_cm,

2270: l_inv_acctd_adr,
2271: l_inv_rate,
2272: l_new_adj_amount
2273: FROM
2274: ar_payment_schedules ps_cm,
2275: ar_payment_schedules ps_inv,
2276: ar_receivable_applications ra
2277: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
2278: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id

Line 2275: ar_payment_schedules ps_inv,

2271: l_inv_rate,
2272: l_new_adj_amount
2273: FROM
2274: ar_payment_schedules ps_cm,
2275: ar_payment_schedules ps_inv,
2276: ar_receivable_applications ra
2277: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
2278: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id
2279: and ps_inv.payment_schedule_id = p_control.payment_schedule_id

Line 2663: UPDATE ar_payment_schedules ps

2659: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2660:
2661: BEGIN
2662:
2663: UPDATE ar_payment_schedules ps
2664: SET (
2665: ps.status,
2666: ps.gl_date_closed,
2667: ps.actual_date_closed,

Line 2740: ar_payment_schedules ps2,

2736: trunc(sysdate),
2737: p_profile_info.conc_login_id
2738: FROM
2739: ar_receivable_applications ra,
2740: ar_payment_schedules ps2,
2741: ar_receivable_applications ra2,
2742: ar_adjustments adj2
2743: WHERE ra.customer_trx_id = p_control.customer_trx_id
2744: and ra.status||'' = 'APP'

Line 2784: p_table_name => 'AR_PAYMENT_SCHEDULES',

2780: +---------------------------------*/
2781:
2782: ar_mrc_engine.maintain_mrc_data(
2783: p_event_mode => 'UPDATE',
2784: p_table_name => 'AR_PAYMENT_SCHEDULES',
2785: p_mode => 'BATCH',
2786: p_key_value_list => l_ar_ps_key_value_list);
2787:
2788: EXCEPTION

Line 3046: FROM ar_payment_schedules

3042: print_fcn_label( 'arp_maintain_ps.ps_records_exist()+' );
3043:
3044: SELECT 1
3045: INTO l_temp
3046: FROM ar_payment_schedules
3047: WHERE customer_trx_id = p_customer_trx_id;
3048:
3049: print_fcn_label( 'arp_maintain_ps.ps_records_exist()-' );
3050: