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

Line 68: , ar_payment_schedules ps

64: l_creation_sign,
65: l_allow_overapp_flag
66: FROM
67: ra_cust_trx_types ctt
68: , ar_payment_schedules ps
69: WHERE ps.payment_schedule_id = p_payment_schedule_id
70: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
71:
72: arp_util.debug( 'p_type = ' || p_type);

Line 194: FROM ar_payment_schedules ps,

190: l_amount_due_remaining,
191: l_amount_due_original,
192: l_creation_sign,
193: l_allow_overapp_flag
194: FROM ar_payment_schedules ps,
195: ra_cust_trx_types ctt
196: WHERE ps.payment_schedule_id = p_payment_schedule_id
197: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
198:

Line 391: p_ps_rec IN ar_payment_schedules%rowtype)

387: +===========================================================================*/
388:
389: PROCEDURE validate_inv_line_amount(p_adj_rec IN
390: ar_adjustments%rowtype,
391: p_ps_rec IN ar_payment_schedules%rowtype)
392: IS
393:
394:
395: l_result VARCHAR2(1);

Line 608: l_ps_rec ar_payment_schedules%rowtype;

604: p_payment_schedule_id IN number,
605: p_amount IN number) IS
606:
607: l_adj_rec ar_adjustments%rowtype;
608: l_ps_rec ar_payment_schedules%rowtype;
609:
610: BEGIN
611:
612: arp_util.debug('arp_process_adjustment.validate_inv_line_amount_cover()+',

Line 627: FROM ar_payment_schedules

623: invoice_currency_code
624: INTO l_ps_rec.term_id,
625: l_ps_rec.terms_sequence_number,
626: l_ps_rec.invoice_currency_code
627: FROM ar_payment_schedules
628: WHERE payment_schedule_id = p_payment_schedule_id;
629:
630: validate_inv_line_amount( l_adj_rec, l_ps_rec );
631:

Line 696: p_ps_rec IN ar_payment_schedules%rowtype,

692: | |
693: +===========================================================================*/
694:
695: PROCEDURE validate_update_approve_adj( p_adj_rec IN ar_adjustments%rowtype,
696: p_ps_rec IN ar_payment_schedules%rowtype,
697: p_adjustment_code IN ar_lookups.lookup_code%type,
698: p_chk_approval_limits IN varchar2
699: ) IS
700:

Line 931: l_ps_rec ar_payment_schedules%rowtype;

927:
928: IS
929:
930: l_adjustment_id ar_adjustments.adjustment_id%type;
931: l_ps_rec ar_payment_schedules%rowtype;
932: l_acctd_amount ar_adjustments.acctd_amount%type;
933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
934: l_aah_rec ar_approval_action_history%rowtype;
935: l_approval_action_history_id

Line 933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;

929:
930: l_adjustment_id ar_adjustments.adjustment_id%type;
931: l_ps_rec ar_payment_schedules%rowtype;
932: l_acctd_amount ar_adjustments.acctd_amount%type;
933: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
934: l_aah_rec ar_approval_action_history%rowtype;
935: l_approval_action_history_id
936: ar_approval_action_history.approval_action_history_id%type;
937: ln_adr_tmp NUMBER;

Line 1155: --update ar_payment_schedules.amount_adjusted_pending

1151: END IF;
1152: END IF;
1153:
1154: ELSE
1155: --update ar_payment_schedules.amount_adjusted_pending
1156: --Bug 1395396.Update PS record only if Amount is not 0
1157:
1158: IF p_adj_rec.amount <> 0 THEN
1159:

Line 1575: l_ps_rec ar_payment_schedules%rowtype;

1571: IS
1572:
1573: l_adj_rec ar_adjustments%rowtype;
1574: l_aah_rec ar_approval_action_history%rowtype;
1575: l_ps_rec ar_payment_schedules%rowtype;
1576: l_approval_action_history_id
1577: ar_approval_action_history.approval_action_history_id%type;
1578: l_status_changed_flag boolean;
1579: l_old_adj_rec ar_adjustments%rowtype;

Line 1739: UPDATE ar_payment_schedules set amount_adjusted_pending=

1735: l_amount_adjusted_pending:=0;
1736: Select SUM(AMOUNT) into l_amount_adjusted_pending
1737: FROM ar_adjustments where payment_schedule_id=l_adj_rec.payment_schedule_id
1738: AND STATUS NOT IN ('A','R','U');
1739: UPDATE ar_payment_schedules set amount_adjusted_pending=
1740: DECODE(l_amount_adjusted_pending,0,NULL,l_amount_adjusted_pending)
1741: WHERE payment_schedule_id=l_adj_rec.payment_schedule_id;
1742: EXCEPTION
1743: WHEN OTHERS THEN

Line 2027: l_ps_rec ar_payment_schedules%rowtype;

2023: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2024: p_chk_approval_limits IN varchar2,
2025: p_move_deferred_tax IN varchar2 := 'Y') IS
2026:
2027: l_ps_rec ar_payment_schedules%rowtype;
2028: l_adj_rec ar_adjustments%rowtype;
2029: l_aah_rec ar_approval_action_history%rowtype;
2030: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2031:

Line 2178: | update ar_payment_schedules |

2174:
2175: END IF;
2176:
2177: /*---------------------------------+
2178: | update ar_payment_schedules |
2179: +---------------------------------*/
2180:
2181: IF ( p_adjustment_code = 'A' )
2182: THEN

Line 2387: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS

2383: +===========================================================================*/
2384:
2385: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
2386: p_result IN OUT NOCOPY varchar2,
2387: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS
2388:
2389: l_new_ps_rec ar_payment_schedules%rowtype;
2390:
2391: BEGIN

Line 2389: l_new_ps_rec ar_payment_schedules%rowtype;

2385: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
2386: p_result IN OUT NOCOPY varchar2,
2387: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS
2388:
2389: l_new_ps_rec ar_payment_schedules%rowtype;
2390:
2391: BEGIN
2392: arp_util.debug('test_adj()+');
2393:

Line 2621: l_ps_rec ar_payment_schedules%rowtype;

2617: p_module_version IN VARCHAR2 ) IS
2618: l_aah_rec ar_approval_action_history%ROWTYPE;
2619: l_aah_id NUMBER;
2620: l_adj_rec ar_adjustments%ROWTYPE;
2621: l_ps_rec ar_payment_schedules%rowtype;
2622: --BUG#2750340
2623: l_xla_ev_rec arp_xla_events.xla_events_type;
2624:
2625: BEGIN

Line 3272: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;

3268: ) IS
3269: l_line_remaining number;
3270: l_tax_remaining number;
3271: l_prorated_tax number;
3272: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3273: l_activity_type ar_receivables_trx.type%TYPE;
3274: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3275: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3276: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;

Line 3306: ar_payment_schedules ps

3302: IF (arp_legal_entity_util.Is_LE_Subscriber) THEN
3303: SELECT trx.legal_entity_id
3304: INTO l_le_id
3305: FROM ra_customer_Trx trx,
3306: ar_payment_schedules ps
3307: where ps.payment_schedule_id = p_payment_schedule_id
3308: and ps.customer_trx_id = trx.customer_trx_id;
3309:
3310: /* 5236782 - detail table not required for adj */

Line 3343: FROM ar_payment_schedules

3339: invoice_currency_code
3340: INTO l_line_remaining,
3341: l_tax_remaining,
3342: l_invoice_currency_code
3343: FROM ar_payment_schedules
3344: WHERE payment_schedule_id = p_payment_schedule_id;
3345: ELSE
3346: -- then we are adjusting at the Line Level.
3347: SELECT sum(DECODE (lines.line_type,