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_PS2 dependencies on AR_PAYMENT_SCHEDULES

Line 589: 'INSERT INTO AR_PAYMENT_SCHEDULES

585: ------------------------------------------------
586: -- Insert sql
587: ------------------------------------------------
588: l_insert_ps_sql :=
589: 'INSERT INTO AR_PAYMENT_SCHEDULES
590: (
591: created_by,
592: creation_date,
593: last_updated_by,

Line 940: l_ps_id ar_payment_schedules.payment_schedule_id%type;

936: p_acctd_amt_due_rem_t IN OUT NOCOPY number_table_type ) IS
937:
938: l_ignore INTEGER;
939:
940: l_ps_id ar_payment_schedules.payment_schedule_id%type;
941: /* BR Sped Project */
942: l_jgzz_product_code VARCHAR2(100);
943: lcursor NUMBER;
944: lignore NUMBER;

Line 1037: -- Insert into ar_payment_schedules

1033:
1034:
1035:
1036: -------------------------------------------------------------
1037: -- Insert into ar_payment_schedules
1038: -------------------------------------------------------------
1039:
1040: FOR i IN 0..p_number_of_due_dates - 1 LOOP
1041:

Line 1071: SELECT ar_payment_schedules_s.nextval

1067:
1068: /* retrieve the next payment schedule id. Added for
1069: MRC trigger replacement */
1070:
1071: SELECT ar_payment_schedules_s.nextval
1072: INTO l_ps_id
1073: FROM dual;
1074:
1075: dbms_sql.bind_variable( p_insert_ps_c,

Line 1213: p_table_name => 'AR_PAYMENT_SCHEDULES',

1209: +-------------------------------------------*/
1210:
1211: ar_mrc_engine.maintain_mrc_data(
1212: p_event_mode => 'INSERT',
1213: p_table_name => 'AR_PAYMENT_SCHEDULES',
1214: p_mode => 'SINGLE',
1215: p_key_value => l_ps_id);
1216:
1217: EXCEPTION

Line 1585: ar_payment_schedules ps,

1581: nvl(ps.receivables_charges_remaining,0)
1582: /* , 0 */
1583: FROM
1584: ar_receivable_applications ra,
1585: ar_payment_schedules ps,
1586: ar_adjustments adj,
1587: ra_cust_trx_types ctt,
1588: ra_cust_trx_line_gl_dist ctlgd,
1589: ra_customer_trx ct,

Line 1666: 'INSERT INTO AR_PAYMENT_SCHEDULES

1662: ------------------------------------------------
1663: -- Insert ps sql
1664: ------------------------------------------------
1665: l_insert_ps_sql :=
1666: 'INSERT INTO AR_PAYMENT_SCHEDULES
1667: (
1668: created_by,
1669: creation_date,
1670: last_updated_by,

Line 1844: FROM AR_PAYMENT_SCHEDULES ps

1840: -3, /* posting_control_id */
1841: null, /* cash_receipt_history_id */
1842: :ussgl_transaction_code /*Transaction code*/
1843: ,ps.org_id /* SSA changes anuj */
1844: FROM AR_PAYMENT_SCHEDULES ps
1845: /* assumes only one ps line exists for CM */
1846: WHERE :customer_trx_id = ps.customer_trx_id';
1847:
1848: debug(' insert_ra_sql = ' || CRLF ||

Line 1861: 'UPDATE AR_PAYMENT_SCHEDULES

1857: -- Update ps sql
1858: ------------------------------------------------
1859: -- Modified the update statement to incorporate the hard-coded date if the transaction is open - For Bug:5491085
1860: l_update_ps_sql :=
1861: 'UPDATE AR_PAYMENT_SCHEDULES
1862: SET
1863: last_update_date = sysdate,
1864: last_updated_by = :user_id,
1865: last_update_login = :login_id,

Line 2506: l_ps_class ar_payment_schedules.class%type;

2502: l_new_inv_acctd_adr NUMBER;
2503: l_new_acctd_amt_applied_to NUMBER;
2504:
2505: l_ae_doc_rec ae_doc_rec_type;
2506: l_ps_class ar_payment_schedules.class%type;
2507: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2508: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2509:
2510: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;

Line 2507: l_ps_is ar_payment_schedules.payment_schedule_id%type;

2503: l_new_acctd_amt_applied_to NUMBER;
2504:
2505: l_ae_doc_rec ae_doc_rec_type;
2506: l_ps_class ar_payment_schedules.class%type;
2507: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2508: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2509:
2510: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;
2511:

Line 2508: l_ps_id ar_payment_schedules.payment_schedule_id%type;

2504:
2505: l_ae_doc_rec ae_doc_rec_type;
2506: l_ps_class ar_payment_schedules.class%type;
2507: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2508: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2509:
2510: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;
2511:
2512: BEGIN

Line 2685: -- Insert into ar_payment_schedules

2681:
2682:
2683:
2684: -------------------------------------------------------------
2685: -- Insert into ar_payment_schedules
2686: -------------------------------------------------------------
2687:
2688: -------------------------------------------------------------
2689: -- Bind vars

Line 2715: SELECT ar_payment_schedules_s.nextval

2711: 'program_id',
2712: p_profile_info.conc_program_id );
2713:
2714: /* added for mrc trigger elimination */
2715: SELECT ar_payment_schedules_s.nextval
2716: INTO l_ps_id
2717: FROM dual;
2718:
2719: dbms_sql.bind_variable( p_insert_ps_c,

Line 2829: p_table_name => 'AR_PAYMENT_SCHEDULES',

2825: +-------------------------------------------*/
2826:
2827: ar_mrc_engine.maintain_mrc_data(
2828: p_event_mode => 'INSERT',
2829: p_table_name => 'AR_PAYMENT_SCHEDULES',
2830: p_mode => 'SINGLE',
2831: p_key_value => l_ps_id);
2832:
2833: EXCEPTION

Line 3009: FROM ar_payment_schedules

3005:
3006: --Bug 1329091 - For CM, payment schedule is updated before accounting engine call
3007: BEGIN
3008: SELECT class INTO l_ps_class
3009: FROM ar_payment_schedules
3010: WHERE customer_trx_id = p_select_rec.customer_trx_id;
3011: EXCEPTION
3012: WHEN NO_DATA_FOUND then
3013: l_ps_class := 'CM';

Line 3032: -- Update ar_payment_schedules

3028: 'N');
3029:
3030:
3031: -------------------------------------------------------------
3032: -- Update ar_payment_schedules
3033: -------------------------------------------------------------
3034:
3035: -------------------------------------------------------------
3036: -- Bind vars

Line 3109: | of AR_PAYMENT_SCHEDULES |

3105: MSG_LEVEL_DEBUG );
3106:
3107: /*-------------------------------------------+
3108: | Call central MRC library for update |
3109: | of AR_PAYMENT_SCHEDULES |
3110: +-------------------------------------------*/
3111:
3112: ar_mrc_engine.maintain_mrc_data(
3113: p_event_mode => 'UPDATE',

Line 3114: p_table_name => 'AR_PAYMENT_SCHEDULES',

3110: +-------------------------------------------*/
3111:
3112: ar_mrc_engine.maintain_mrc_data(
3113: p_event_mode => 'UPDATE',
3114: p_table_name => 'AR_PAYMENT_SCHEDULES',
3115: p_mode => 'SINGLE',
3116: p_key_value => p_inv_ps_id_t( i ));
3117:
3118: EXCEPTION

Line 3628: ar_payment_schedules ps,

3624: FROM
3625: ra_cust_trx_types ctt,
3626: ra_cust_trx_types ctt_com,
3627: ra_cust_trx_line_gl_dist ctlgd_com,
3628: ar_payment_schedules ps,
3629: ar_receivable_applications ra,
3630: ar_adjustments adj,
3631: fnd_currencies c,
3632: ra_terms t,

Line 3804: 'UPDATE AR_PAYMENT_SCHEDULES

3800: -- Update ps sql
3801: ------------------------------------------------
3802: -- Modified the update statement to incorporate the hard-coded date if the transaction is open - For Bug:5491085
3803: l_update_ps_sql :=
3804: 'UPDATE AR_PAYMENT_SCHEDULES
3805: SET last_update_date = sysdate,
3806: last_updated_by = :user_id,
3807: last_update_login = :login_id,
3808: status = decode(:amount_due_remaining, 0, ''CL'', ''OP''),

Line 4542: -- Update ar_payment_schedules

4538: END;
4539:
4540:
4541: -------------------------------------------------------------
4542: -- Update ar_payment_schedules
4543: -------------------------------------------------------------
4544:
4545: -------------------------------------------------------------
4546: -- Bind vars

Line 4615: | of AR_PAYMENT_SCHEDULES |

4611: MSG_LEVEL_DEBUG );
4612:
4613: /*-------------------------------------------+
4614: | Call central MRC library for update |
4615: | of AR_PAYMENT_SCHEDULES |
4616: +-------------------------------------------*/
4617:
4618: ar_mrc_engine.maintain_mrc_data(
4619: p_event_mode => 'UPDATE',

Line 4620: p_table_name => 'AR_PAYMENT_SCHEDULES',

4616: +-------------------------------------------*/
4617:
4618: ar_mrc_engine.maintain_mrc_data(
4619: p_event_mode => 'UPDATE',
4620: p_table_name => 'AR_PAYMENT_SCHEDULES',
4621: p_mode => 'SINGLE',
4622: p_key_value => p_ps_id_t( i ));
4623:
4624: EXCEPTION

Line 5204: ar_payment_schedules ps,

5200: FROM
5201: ra_cust_trx_types ctt_com,
5202: ra_cust_trx_types ctt,
5203: ra_cust_trx_line_gl_dist ctlgd_com,
5204: ar_payment_schedules ps,
5205: ar_payment_schedules ps_inv,
5206: ar_receivable_applications ra,
5207: ar_adjustments adj,
5208: ar_adjustments adjd,

Line 5205: ar_payment_schedules ps_inv,

5201: ra_cust_trx_types ctt_com,
5202: ra_cust_trx_types ctt,
5203: ra_cust_trx_line_gl_dist ctlgd_com,
5204: ar_payment_schedules ps,
5205: ar_payment_schedules ps_inv,
5206: ar_receivable_applications ra,
5207: ar_adjustments adj,
5208: ar_adjustments adjd,
5209: fnd_currencies c,

Line 5390: 'UPDATE AR_PAYMENT_SCHEDULES

5386: -- Update ps sql
5387: ------------------------------------------------
5388: -- Modified the update statement to incorporate the hard-coded date if the transaction is open - For Bug:5491085
5389: l_update_ps_sql :=
5390: 'UPDATE AR_PAYMENT_SCHEDULES
5391: SET last_update_date = sysdate,
5392: last_updated_by = :user_id,
5393: last_update_login = :login_id,
5394: status = decode(:amount_due_remaining, 0, ''CL'', ''OP''),

Line 6369: -- Update ar_payment_schedules

6365: END;
6366:
6367:
6368: -------------------------------------------------------------
6369: -- Update ar_payment_schedules
6370: -------------------------------------------------------------
6371:
6372: -------------------------------------------------------------
6373: -- Bind vars

Line 6440: | of AR_PAYMENT_SCHEDULES |

6436: MSG_LEVEL_DEBUG );
6437:
6438: /*-------------------------------------------+
6439: | Call central MRC library for update |
6440: | of AR_PAYMENT_SCHEDULES |
6441: +-------------------------------------------*/
6442:
6443: ar_mrc_engine.maintain_mrc_data(
6444: p_event_mode => 'UPDATE',

Line 6445: p_table_name => 'AR_PAYMENT_SCHEDULES',

6441: +-------------------------------------------*/
6442:
6443: ar_mrc_engine.maintain_mrc_data(
6444: p_event_mode => 'UPDATE',
6445: p_table_name => 'AR_PAYMENT_SCHEDULES',
6446: p_mode => 'SINGLE',
6447: p_key_value => p_ps_id_t( i ));
6448:
6449: EXCEPTION