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_APPLICATION dependencies on AR_ADJUSTMENTS

Line 2273: | p_adj_id - Adjustment Id of inserted ar_adjustments row|

2269: | p_module_name - Name of module that called this proc. |
2270: | p_module_name - Version of the module that called this |
2271: | function |
2272: | OUT: |
2273: | p_adj_id - Adjustment Id of inserted ar_adjustments row|
2274: | |
2275: | RETURNS : FALSE or TRUE |
2276: | |
2277: | NOTES - This could be a public function later |

Line 2295: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;

2291: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2292: p_module_name IN VARCHAR2,
2293: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2294: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2295: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;
2296: l_ct_id ra_customer_trx.customer_trx_id%TYPE;
2297: l_adj_amt NUMBER;
2298: l_pend_amt NUMBER;
2299: l_pmt NUMBER;

Line 2461: FROM ar_adjustments

2457: -- Check if deletion would result in negative amount_due
2458: --
2459: SELECT NVL( SUM( amount), 0 )
2460: INTO l_adj_amount
2461: FROM ar_adjustments
2462: WHERE payment_schedule_id = l_ps_id
2463: AND associated_cash_receipt_id = l_ass_cr_id
2464: AND status = 'A';
2465: --

Line 2503: FROM ar_adjustments a,

2499: END IF;
2500: --
2501: SELECT count( distinct a.chargeback_customer_trx_id )
2502: INTO l_cb_count
2503: FROM ar_adjustments a,
2504: ar_adjustments b
2505: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2506: AND a.associated_cash_receipt_id = l_ass_cr_id
2507: AND a.payment_schedule_id = l_ps_id

Line 2504: ar_adjustments b

2500: --
2501: SELECT count( distinct a.chargeback_customer_trx_id )
2502: INTO l_cb_count
2503: FROM ar_adjustments a,
2504: ar_adjustments b
2505: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2506: AND a.associated_cash_receipt_id = l_ass_cr_id
2507: AND a.payment_schedule_id = l_ps_id
2508: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID

Line 2538: FROM ar_adjustments

2534: ), 0
2535: )
2536: INTO l_adj_amt,
2537: l_pend_amt
2538: FROM ar_adjustments
2539: WHERE payment_schedule_id = l_ps_id
2540: AND associated_cash_receipt_id = l_ass_cr_id
2541: AND chargeback_customer_trx_id iS NULL;
2542: --

Line 2567: /**** FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )

2563: IF PG_DEBUG in ('Y', 'C') THEN
2564: arp_standard.debug('validate_args: ' || 'after validate_cb_reversal in app_delete' );
2565: END IF;
2566: --
2567: /**** FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2568: LOOP
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_standard.debug('validate_args: ' || 'inside for ar_adjustments_C in app_delete' );
2571: END IF;

Line 2570: arp_standard.debug('validate_args: ' || 'inside for ar_adjustments_C in app_delete' );

2566: --
2567: /**** FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2568: LOOP
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_standard.debug('validate_args: ' || 'inside for ar_adjustments_C in app_delete' );
2571: END IF;
2572: IF ( validate_cb_reversal(
2573: l_adj_rec.chargeback_customer_trx_id, l_cb_count
2574: p_module_name, p_module_version ) <> TRUE ) THEN

Line 2587: FROM ar_adjustments adj,

2583: -- However, this should be done at a different level.
2584: --
2585: /* SELECT adj.adjustment_id,
2586: ps.payment_schedule_id
2587: FROM ar_adjustments adj,
2588: ar_payment_schedules ps
2589: WHERE adj.associated_cash_receipt_id = l_ass_cr_id
2590: AND adj.payment_schedule_id = l_ps_id
2591: AND adj.chargeback_customer_trx_id = ps.customer_trx_id(+)

Line 2707: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,

2703: l_ps_rec ar_payment_schedules%ROWTYPE;
2704:
2705: l_count NUMBER DEFAULT 0;
2706: --
2707: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2708: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2709: SELECT a.chargeback_customer_trx_id,
2710: a.adjustment_id,
2711: a.status

Line 2712: FROM ar_adjustments a,

2708: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2709: SELECT a.chargeback_customer_trx_id,
2710: a.adjustment_id,
2711: a.status
2712: FROM ar_adjustments a,
2713: ar_adjustments b
2714: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2715: AND a.associated_cash_receipt_id = l_ass_cr_id
2716: AND a.payment_schedule_id = l_ps_id

Line 2713: ar_adjustments b

2709: SELECT a.chargeback_customer_trx_id,
2710: a.adjustment_id,
2711: a.status
2712: FROM ar_adjustments a,
2713: ar_adjustments b
2714: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2715: AND a.associated_cash_receipt_id = l_ass_cr_id
2716: AND a.payment_schedule_id = l_ps_id
2717: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID

Line 2721: CURSOR ar_adjustments_radj_C(

2717: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2718: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2719: AND b.customer_trx_id is null;
2720: --
2721: CURSOR ar_adjustments_radj_C(
2722: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2723: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2724: SELECT adjustment_id,
2725: status

Line 2726: FROM ar_adjustments

2722: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2723: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2724: SELECT adjustment_id,
2725: status
2726: FROM ar_adjustments
2727: WHERE associated_cash_receipt_id = l_ass_cr_id
2728: AND payment_schedule_id = l_ps_id
2729: AND status <> 'R'
2730: AND associated_application_id = p_ra_id --Bug2144783

Line 2763: arp_standard.debug( 'Select from ar_adjustments failed' );

2759: WHERE receivable_application_id = p_ra_id;
2760: EXCEPTION
2761: WHEN NO_DATA_FOUND THEN
2762: IF PG_DEBUG in ('Y', 'C') THEN
2763: arp_standard.debug( 'Select from ar_adjustments failed' );
2764: END IF;
2765: RETURN;
2766: END;
2767: ELSE

Line 2846: FROM ar_adjustments

2842: l_app_rec.tax_applied,
2843: l_app_rec.freight_applied,
2844: l_app_rec.receivables_charges_applied,
2845: l_app_rec.charges_type_adjusted
2846: FROM ar_adjustments
2847: WHERE payment_schedule_id = l_ps_id
2848: AND associated_cash_receipt_id = l_ass_cr_id;
2849: --
2850: IF PG_DEBUG in ('Y', 'C') THEN

Line 2855: FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )

2851: arp_standard.debug( 'before for reverse_action in app_delete' );
2852: arp_standard.debug( to_char( l_ps_id ) );
2853: arp_standard.debug( to_char( l_ass_cr_id ) );
2854: END IF;
2855: FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2856: LOOP
2857: l_count := l_count + 1;
2858: IF PG_DEBUG in ('Y', 'C') THEN
2859: arp_standard.debug( 'inside for ar_adjustments_C in app_delete' );

Line 2859: arp_standard.debug( 'inside for ar_adjustments_C in app_delete' );

2855: FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2856: LOOP
2857: l_count := l_count + 1;
2858: IF PG_DEBUG in ('Y', 'C') THEN
2859: arp_standard.debug( 'inside for ar_adjustments_C in app_delete' );
2860: END IF;
2861: --
2862: -- reverse chargeback
2863: --

Line 2889: arp_standard.debug( 'before if ar_adjustments_C%ROWCOUNT in app_delete ' );

2885: END IF;
2886: END LOOP;
2887: --
2888: IF PG_DEBUG in ('Y', 'C') THEN
2889: arp_standard.debug( 'before if ar_adjustments_C%ROWCOUNT in app_delete ' );
2890: END IF;
2891: IF ( l_count = 0 AND l_adj_amount = 0 AND
2892: l_app_rec.amount_adjusted_pending = 0 ) THEN
2893: IF PG_DEBUG in ('Y', 'C') THEN

Line 2904: arp_standard.debug( 'before for ar_adjustments_radj_C in app_delete' );

2900: -- Reverse adjustments , call armradj,
2901: -- select only adjustments that have not been rejected
2902: --
2903: IF PG_DEBUG in ('Y', 'C') THEN
2904: arp_standard.debug( 'before for ar_adjustments_radj_C in app_delete' );
2905: END IF;
2906: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )
2907: LOOP
2908: IF PG_DEBUG in ('Y', 'C') THEN

Line 2906: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )

2902: --
2903: IF PG_DEBUG in ('Y', 'C') THEN
2904: arp_standard.debug( 'before for ar_adjustments_radj_C in app_delete' );
2905: END IF;
2906: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )
2907: LOOP
2908: IF PG_DEBUG in ('Y', 'C') THEN
2909: arp_standard.debug( 'inside for ar_adjustments_radj_C in app_delete' );
2910: END IF;

Line 2909: arp_standard.debug( 'inside for ar_adjustments_radj_C in app_delete' );

2905: END IF;
2906: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )
2907: LOOP
2908: IF PG_DEBUG in ('Y', 'C') THEN
2909: arp_standard.debug( 'inside for ar_adjustments_radj_C in app_delete' );
2910: END IF;
2911: arp_process_adjustment.reverse_adjustment( l_adj_rec.adjustment_id,
2912: p_reversal_gl_date,
2913: p_reversal_date,