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 581: 'INSERT INTO AR_PAYMENT_SCHEDULES

577: ------------------------------------------------
578: -- Insert sql
579: ------------------------------------------------
580: l_insert_ps_sql :=
581: 'INSERT INTO AR_PAYMENT_SCHEDULES
582: (
583: created_by,
584: creation_date,
585: last_updated_by,

Line 932: l_ps_id ar_payment_schedules.payment_schedule_id%type;

928: p_acctd_amt_due_rem_t IN OUT NOCOPY number_table_type ) IS
929:
930: l_ignore INTEGER;
931:
932: l_ps_id ar_payment_schedules.payment_schedule_id%type;
933: /* BR Sped Project */
934: l_jgzz_product_code VARCHAR2(100);
935: lcursor NUMBER;
936: lignore NUMBER;

Line 1029: -- Insert into ar_payment_schedules

1025:
1026:
1027:
1028: -------------------------------------------------------------
1029: -- Insert into ar_payment_schedules
1030: -------------------------------------------------------------
1031:
1032: FOR i IN 0..p_number_of_due_dates - 1 LOOP
1033:

Line 1063: SELECT ar_payment_schedules_s.nextval

1059:
1060: /* retrieve the next payment schedule id. Added for
1061: MRC trigger replacement */
1062:
1063: SELECT ar_payment_schedules_s.nextval
1064: INTO l_ps_id
1065: FROM dual;
1066:
1067: dbms_sql.bind_variable( p_insert_ps_c,

Line 1205: p_table_name => 'AR_PAYMENT_SCHEDULES',

1201: +-------------------------------------------*/
1202:
1203: ar_mrc_engine.maintain_mrc_data(
1204: p_event_mode => 'INSERT',
1205: p_table_name => 'AR_PAYMENT_SCHEDULES',
1206: p_mode => 'SINGLE',
1207: p_key_value => l_ps_id);
1208:
1209: EXCEPTION

Line 1577: ar_payment_schedules ps,

1573: nvl(ps.receivables_charges_remaining,0)
1574: /* , 0 */
1575: FROM
1576: ar_receivable_applications ra,
1577: ar_payment_schedules ps,
1578: ar_adjustments adj,
1579: ra_cust_trx_types ctt,
1580: ra_cust_trx_line_gl_dist ctlgd,
1581: ra_customer_trx ct,

Line 1658: 'INSERT INTO AR_PAYMENT_SCHEDULES

1654: ------------------------------------------------
1655: -- Insert ps sql
1656: ------------------------------------------------
1657: l_insert_ps_sql :=
1658: 'INSERT INTO AR_PAYMENT_SCHEDULES
1659: (
1660: created_by,
1661: creation_date,
1662: last_updated_by,

Line 1836: FROM AR_PAYMENT_SCHEDULES ps

1832: -3, /* posting_control_id */
1833: null, /* cash_receipt_history_id */
1834: :ussgl_transaction_code /*Transaction code*/
1835: ,ps.org_id /* SSA changes anuj */
1836: FROM AR_PAYMENT_SCHEDULES ps
1837: /* assumes only one ps line exists for CM */
1838: WHERE :customer_trx_id = ps.customer_trx_id';
1839:
1840: debug(' insert_ra_sql = ' || CRLF ||

Line 1853: 'UPDATE AR_PAYMENT_SCHEDULES

1849: -- Update ps sql
1850: ------------------------------------------------
1851: -- Modified the update statement to incorporate the hard-coded date if the transaction is open - For Bug:5491085
1852: l_update_ps_sql :=
1853: 'UPDATE AR_PAYMENT_SCHEDULES
1854: SET
1855: last_update_date = sysdate,
1856: last_updated_by = :user_id,
1857: last_update_login = :login_id,

Line 2498: l_ps_class ar_payment_schedules.class%type;

2494: l_new_inv_acctd_adr NUMBER;
2495: l_new_acctd_amt_applied_to NUMBER;
2496:
2497: l_ae_doc_rec ae_doc_rec_type;
2498: l_ps_class ar_payment_schedules.class%type;
2499: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2500: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2501:
2502: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;

Line 2499: l_ps_is ar_payment_schedules.payment_schedule_id%type;

2495: l_new_acctd_amt_applied_to NUMBER;
2496:
2497: l_ae_doc_rec ae_doc_rec_type;
2498: l_ps_class ar_payment_schedules.class%type;
2499: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2500: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2501:
2502: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;
2503:

Line 2500: l_ps_id ar_payment_schedules.payment_schedule_id%type;

2496:
2497: l_ae_doc_rec ae_doc_rec_type;
2498: l_ps_class ar_payment_schedules.class%type;
2499: l_ps_is ar_payment_schedules.payment_schedule_id%type;
2500: l_ps_id ar_payment_schedules.payment_schedule_id%type;
2501:
2502: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%type;
2503:
2504: BEGIN

Line 2677: -- Insert into ar_payment_schedules

2673:
2674:
2675:
2676: -------------------------------------------------------------
2677: -- Insert into ar_payment_schedules
2678: -------------------------------------------------------------
2679:
2680: -------------------------------------------------------------
2681: -- Bind vars

Line 2707: SELECT ar_payment_schedules_s.nextval

2703: 'program_id',
2704: p_profile_info.conc_program_id );
2705:
2706: /* added for mrc trigger elimination */
2707: SELECT ar_payment_schedules_s.nextval
2708: INTO l_ps_id
2709: FROM dual;
2710:
2711: dbms_sql.bind_variable( p_insert_ps_c,

Line 2821: p_table_name => 'AR_PAYMENT_SCHEDULES',

2817: +-------------------------------------------*/
2818:
2819: ar_mrc_engine.maintain_mrc_data(
2820: p_event_mode => 'INSERT',
2821: p_table_name => 'AR_PAYMENT_SCHEDULES',
2822: p_mode => 'SINGLE',
2823: p_key_value => l_ps_id);
2824:
2825: EXCEPTION

Line 3001: FROM ar_payment_schedules

2997:
2998: --Bug 1329091 - For CM, payment schedule is updated before accounting engine call
2999: BEGIN
3000: SELECT class INTO l_ps_class
3001: FROM ar_payment_schedules
3002: WHERE customer_trx_id = p_select_rec.customer_trx_id;
3003: EXCEPTION
3004: WHEN NO_DATA_FOUND then
3005: l_ps_class := 'CM';

Line 3024: -- Update ar_payment_schedules

3020: 'N');
3021:
3022:
3023: -------------------------------------------------------------
3024: -- Update ar_payment_schedules
3025: -------------------------------------------------------------
3026:
3027: -------------------------------------------------------------
3028: -- Bind vars

Line 3101: | of AR_PAYMENT_SCHEDULES |

3097: MSG_LEVEL_DEBUG );
3098:
3099: /*-------------------------------------------+
3100: | Call central MRC library for update |
3101: | of AR_PAYMENT_SCHEDULES |
3102: +-------------------------------------------*/
3103:
3104: ar_mrc_engine.maintain_mrc_data(
3105: p_event_mode => 'UPDATE',

Line 3106: p_table_name => 'AR_PAYMENT_SCHEDULES',

3102: +-------------------------------------------*/
3103:
3104: ar_mrc_engine.maintain_mrc_data(
3105: p_event_mode => 'UPDATE',
3106: p_table_name => 'AR_PAYMENT_SCHEDULES',
3107: p_mode => 'SINGLE',
3108: p_key_value => p_inv_ps_id_t( i ));
3109:
3110: EXCEPTION

Line 3620: ar_payment_schedules ps,

3616: FROM
3617: ra_cust_trx_types ctt,
3618: ra_cust_trx_types ctt_com,
3619: ra_cust_trx_line_gl_dist ctlgd_com,
3620: ar_payment_schedules ps,
3621: ar_receivable_applications ra,
3622: ar_adjustments adj,
3623: fnd_currencies c,
3624: ra_terms t,

Line 3795: 'UPDATE AR_PAYMENT_SCHEDULES

3791: -- Update ps sql
3792: ------------------------------------------------
3793: -- Modified the update statement to incorporate the hard-coded date if the transaction is open - For Bug:5491085
3794: l_update_ps_sql :=
3795: 'UPDATE AR_PAYMENT_SCHEDULES
3796: SET last_update_date = sysdate,
3797: last_updated_by = :user_id,
3798: last_update_login = :login_id,
3799: status = decode(:amount_due_remaining, 0, ''CL'', ''OP''),

Line 4533: -- Update ar_payment_schedules

4529: END;
4530:
4531:
4532: -------------------------------------------------------------
4533: -- Update ar_payment_schedules
4534: -------------------------------------------------------------
4535:
4536: -------------------------------------------------------------
4537: -- Bind vars

Line 4606: | of AR_PAYMENT_SCHEDULES |

4602: MSG_LEVEL_DEBUG );
4603:
4604: /*-------------------------------------------+
4605: | Call central MRC library for update |
4606: | of AR_PAYMENT_SCHEDULES |
4607: +-------------------------------------------*/
4608:
4609: ar_mrc_engine.maintain_mrc_data(
4610: p_event_mode => 'UPDATE',

Line 4611: p_table_name => 'AR_PAYMENT_SCHEDULES',

4607: +-------------------------------------------*/
4608:
4609: ar_mrc_engine.maintain_mrc_data(
4610: p_event_mode => 'UPDATE',
4611: p_table_name => 'AR_PAYMENT_SCHEDULES',
4612: p_mode => 'SINGLE',
4613: p_key_value => p_ps_id_t( i ));
4614:
4615: EXCEPTION

Line 5195: ar_payment_schedules ps,

5191: FROM
5192: ra_cust_trx_types ctt_com,
5193: ra_cust_trx_types ctt,
5194: ra_cust_trx_line_gl_dist ctlgd_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,
5197: ar_receivable_applications ra,
5198: ar_adjustments adj,
5199: ar_adjustments adjd,

Line 5196: ar_payment_schedules ps_inv,

5192: ra_cust_trx_types ctt_com,
5193: ra_cust_trx_types ctt,
5194: ra_cust_trx_line_gl_dist ctlgd_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,
5197: ar_receivable_applications ra,
5198: ar_adjustments adj,
5199: ar_adjustments adjd,
5200: fnd_currencies c,

Line 5381: 'UPDATE AR_PAYMENT_SCHEDULES

5377: -- Update ps sql
5378: ------------------------------------------------
5379: -- Modified the update statement to incorporate the hard-coded date if the transaction is open - For Bug:5491085
5380: l_update_ps_sql :=
5381: 'UPDATE AR_PAYMENT_SCHEDULES
5382: SET last_update_date = sysdate,
5383: last_updated_by = :user_id,
5384: last_update_login = :login_id,
5385: status = decode(:amount_due_remaining, 0, ''CL'', ''OP''),

Line 6360: -- Update ar_payment_schedules

6356: END;
6357:
6358:
6359: -------------------------------------------------------------
6360: -- Update ar_payment_schedules
6361: -------------------------------------------------------------
6362:
6363: -------------------------------------------------------------
6364: -- Bind vars

Line 6431: | of AR_PAYMENT_SCHEDULES |

6427: MSG_LEVEL_DEBUG );
6428:
6429: /*-------------------------------------------+
6430: | Call central MRC library for update |
6431: | of AR_PAYMENT_SCHEDULES |
6432: +-------------------------------------------*/
6433:
6434: ar_mrc_engine.maintain_mrc_data(
6435: p_event_mode => 'UPDATE',

Line 6436: p_table_name => 'AR_PAYMENT_SCHEDULES',

6432: +-------------------------------------------*/
6433:
6434: ar_mrc_engine.maintain_mrc_data(
6435: p_event_mode => 'UPDATE',
6436: p_table_name => 'AR_PAYMENT_SCHEDULES',
6437: p_mode => 'SINGLE',
6438: p_key_value => p_ps_id_t( i ));
6439:
6440: EXCEPTION