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 109: ar_payment_schedules p

105: /* This invoice either has rules or created with contingency */
106: SELECT SUM(NVL(d.amount,0)) amount
107: INTO l_inv_amount
108: FROM ra_cust_trx_line_gl_dist d,
109: ar_payment_schedules p
110: WHERE p.payment_schedule_id = p_payment_schedule_id
111: AND d.customer_trx_id = p.customer_trx_id
112: AND d.account_class = 'UNEARN'
113: AND d.account_set_flag = 'N';

Line 123: ar_payment_schedules p

119: SELECT SUM(NVL(d.amount,0)) amount
120: INTO l_cm_amount
121: FROM ra_cust_trx_line_gl_dist d,
122: ra_customer_trx t,
123: ar_payment_schedules p
124: WHERE p.payment_schedule_id = p_payment_schedule_id
125: AND p.customer_trx_id = t.previous_customer_trx_id
126: AND d.customer_trx_id = t.customer_trx_id
127: AND d.account_class = 'UNEARN'

Line 243: FROM ar_payment_schedules ps,

239: l_amount_due_remaining,
240: l_amount_due_original,
241: l_creation_sign,
242: l_allow_overapp_flag
243: FROM ar_payment_schedules ps,
244: ra_cust_trx_types ctt
245: WHERE ps.payment_schedule_id = p_payment_schedule_id
246: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
247:

Line 440: p_ps_rec IN ar_payment_schedules%rowtype)

436: +===========================================================================*/
437:
438: PROCEDURE validate_inv_line_amount(p_adj_rec IN
439: ar_adjustments%rowtype,
440: p_ps_rec IN ar_payment_schedules%rowtype)
441: IS
442:
443: CURSOR cu_rem_amt(p_customer_trx_id IN NUMBER, p_customer_trx_line_id IN NUMBER) IS
444: SELECT b.sum_orig sum_orig

Line 830: l_ps_rec ar_payment_schedules%rowtype;

826: p_amount IN number,
827: p_receivables_trx_id IN NUMBER DEFAULT NULL) IS
828:
829: l_adj_rec ar_adjustments%rowtype;
830: l_ps_rec ar_payment_schedules%rowtype;
831:
832: BEGIN
833:
834: arp_util.debug('arp_process_adjustment.validate_inv_line_amount_cover()+',

Line 849: FROM ar_payment_schedules

845: invoice_currency_code
846: INTO l_ps_rec.term_id,
847: l_ps_rec.terms_sequence_number,
848: l_ps_rec.invoice_currency_code
849: FROM ar_payment_schedules
850: WHERE payment_schedule_id = p_payment_schedule_id;
851:
852: validate_inv_line_amount( l_adj_rec, l_ps_rec );
853:

Line 918: p_ps_rec IN ar_payment_schedules%rowtype,

914: | |
915: +===========================================================================*/
916:
917: PROCEDURE validate_update_approve_adj( p_adj_rec IN ar_adjustments%rowtype,
918: p_ps_rec IN ar_payment_schedules%rowtype,
919: p_adjustment_code IN ar_lookups.lookup_code%type,
920: p_chk_approval_limits IN varchar2
921: ) IS
922:

Line 1153: l_ps_rec ar_payment_schedules%rowtype;

1149:
1150: IS
1151:
1152: l_adjustment_id ar_adjustments.adjustment_id%type;
1153: l_ps_rec ar_payment_schedules%rowtype;
1154: l_acctd_amount ar_adjustments.acctd_amount%type;
1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
1156: l_aah_rec ar_approval_action_history%rowtype;
1157: l_approval_action_history_id

Line 1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;

1151:
1152: l_adjustment_id ar_adjustments.adjustment_id%type;
1153: l_ps_rec ar_payment_schedules%rowtype;
1154: l_acctd_amount ar_adjustments.acctd_amount%type;
1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
1156: l_aah_rec ar_approval_action_history%rowtype;
1157: l_approval_action_history_id
1158: ar_approval_action_history.approval_action_history_id%type;
1159: ln_adr_tmp NUMBER;

Line 1253: ar_payment_schedules ps,

1249: BEGIN
1250:
1251: SELECT ps.amount_due_remaining-ofc.amount+p_adj_rec.amount,ofc.amount into v_cont,v_claim_amt ---Modified for the bug 14500887
1252: FROM ra_customer_trx rct,
1253: ar_payment_schedules ps,
1254: ar_receivable_applications ra,
1255: ozf_claims ofc
1256: WHERE rct.customer_trx_id=ps.customer_trx_id
1257: AND ra.applied_customer_trx_id=rct.customer_trx_id

Line 1427: --update ar_payment_schedules.amount_adjusted_pending

1423: END IF;
1424: END IF;
1425:
1426: ELSE
1427: --update ar_payment_schedules.amount_adjusted_pending
1428: --Bug 1395396.Update PS record only if Amount is not 0
1429:
1430: IF p_adj_rec.amount <> 0 THEN
1431:

Line 1857: l_ps_rec ar_payment_schedules%rowtype;

1853: IS
1854:
1855: l_adj_rec ar_adjustments%rowtype;
1856: l_aah_rec ar_approval_action_history%rowtype;
1857: l_ps_rec ar_payment_schedules%rowtype;
1858: l_approval_action_history_id
1859: ar_approval_action_history.approval_action_history_id%type;
1860: l_status_changed_flag boolean;
1861: l_old_adj_rec ar_adjustments%rowtype;

Line 2162: UPDATE ar_payment_schedules set amount_adjusted_pending=

2158: l_amount_adjusted_pending:=0;
2159: Select SUM(AMOUNT) into l_amount_adjusted_pending
2160: FROM ar_adjustments where payment_schedule_id=l_adj_rec.payment_schedule_id
2161: AND STATUS NOT IN ('A','R','U');
2162: UPDATE ar_payment_schedules set amount_adjusted_pending=
2163: DECODE(l_amount_adjusted_pending,0,NULL,l_amount_adjusted_pending)
2164: WHERE payment_schedule_id=l_adj_rec.payment_schedule_id;
2165: EXCEPTION
2166: WHEN OTHERS THEN

Line 2455: l_ps_rec ar_payment_schedules%rowtype;

2451: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2452: p_chk_approval_limits IN varchar2,
2453: p_move_deferred_tax IN varchar2 := 'Y') IS
2454:
2455: l_ps_rec ar_payment_schedules%rowtype;
2456: l_adj_rec ar_adjustments%rowtype;
2457: l_aah_rec ar_approval_action_history%rowtype;
2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2459:

Line 2606: | update ar_payment_schedules |

2602:
2603: END IF;
2604:
2605: /*---------------------------------+
2606: | update ar_payment_schedules |
2607: +---------------------------------*/
2608:
2609: IF ( p_adjustment_code = 'A' )
2610: THEN

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

2811: +===========================================================================*/
2812:
2813: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
2814: p_result IN OUT NOCOPY varchar2,
2815: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS
2816:
2817: l_new_ps_rec ar_payment_schedules%rowtype;
2818:
2819: BEGIN

Line 2817: l_new_ps_rec ar_payment_schedules%rowtype;

2813: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
2814: p_result IN OUT NOCOPY varchar2,
2815: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS
2816:
2817: l_new_ps_rec ar_payment_schedules%rowtype;
2818:
2819: BEGIN
2820: arp_util.debug('test_adj()+');
2821:

Line 3049: l_ps_rec ar_payment_schedules%rowtype;

3045: p_module_version IN VARCHAR2 ) IS
3046: l_aah_rec ar_approval_action_history%ROWTYPE;
3047: l_aah_id NUMBER;
3048: l_adj_rec ar_adjustments%ROWTYPE;
3049: l_ps_rec ar_payment_schedules%rowtype;
3050: --BUG#2750340
3051: l_xla_ev_rec arp_xla_events.xla_events_type;
3052:
3053: /* 7699796 */

Line 3850: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;

3846: ) IS
3847: l_line_remaining number;
3848: l_tax_remaining number;
3849: l_prorated_tax number;
3850: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3851: l_activity_type ar_receivables_trx.type%TYPE;
3852: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3853: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3854: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;

Line 3889: ar_payment_schedules ps

3885: IF (arp_legal_entity_util.Is_LE_Subscriber) THEN
3886: SELECT trx.legal_entity_id
3887: INTO l_le_id
3888: FROM ra_customer_Trx trx,
3889: ar_payment_schedules ps
3890: where ps.payment_schedule_id = p_payment_schedule_id
3891: and ps.customer_trx_id = trx.customer_trx_id;
3892:
3893: /* 5236782 - detail table not required for adj */

Line 3926: FROM ar_payment_schedules

3922: invoice_currency_code
3923: INTO l_line_remaining,
3924: l_tax_remaining,
3925: l_invoice_currency_code
3926: FROM ar_payment_schedules
3927: WHERE payment_schedule_id = p_payment_schedule_id;
3928: ELSE
3929: -- then we are adjusting at the Line Level.
3930: SELECT sum(DECODE (lines.line_type,

Line 3978: ar_payment_schedules ps

3974:
3975: SELECT trx.legal_entity_id
3976: INTO l_le_id
3977: FROM ra_customer_Trx trx,
3978: ar_payment_schedules ps
3979: WHERE ps.payment_schedule_id = p_payment_schedule_id
3980: AND ps.customer_trx_id = trx.customer_trx_id;
3981:
3982: /* Bug 8652261: Setting the tax security profile as we query the zx tables */