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 2359: | p_adj_id - Adjustment Id of inserted ar_adjustments row|

2355: | p_module_name - Name of module that called this proc. |
2356: | p_module_name - Version of the module that called this |
2357: | function |
2358: | OUT: |
2359: | p_adj_id - Adjustment Id of inserted ar_adjustments row|
2360: | |
2361: | RETURNS : FALSE or TRUE |
2362: | |
2363: | NOTES - This could be a public function later |

Line 2381: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;

2377: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2378: p_module_name IN VARCHAR2,
2379: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2380: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2381: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;
2382: l_ct_id ra_customer_trx.customer_trx_id%TYPE;
2383: l_adj_amt NUMBER;
2384: l_pend_amt NUMBER;
2385: l_pmt NUMBER;

Line 2549: FROM ar_adjustments

2545: -- Check if deletion would result in negative amount_due
2546: --
2547: SELECT NVL( SUM( amount), 0 )
2548: INTO l_adj_amount
2549: FROM ar_adjustments
2550: WHERE payment_schedule_id = l_ps_id
2551: AND associated_cash_receipt_id = l_ass_cr_id
2552: AND status = 'A';
2553:

Line 2556: FROM ar_adjustments

2552: AND status = 'A';
2553:
2554: SELECT NVL( SUM( amount), 0 )
2555: INTO l_adj_amount_twb
2556: FROM ar_adjustments
2557: WHERE payment_schedule_id = l_ps_id
2558: AND associated_cash_receipt_id is null
2559: AND status = 'A';
2560: --

Line 2598: FROM ar_adjustments a,

2594: END IF;
2595: --
2596: SELECT count( distinct a.chargeback_customer_trx_id )
2597: INTO l_cb_count
2598: FROM ar_adjustments a,
2599: ar_adjustments b
2600: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2601: AND a.associated_cash_receipt_id = l_ass_cr_id
2602: AND a.payment_schedule_id = l_ps_id

Line 2599: ar_adjustments b

2595: --
2596: SELECT count( distinct a.chargeback_customer_trx_id )
2597: INTO l_cb_count
2598: FROM ar_adjustments a,
2599: ar_adjustments b
2600: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2601: AND a.associated_cash_receipt_id = l_ass_cr_id
2602: AND a.payment_schedule_id = l_ps_id
2603: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID

Line 2633: FROM ar_adjustments

2629: ), 0
2630: )
2631: INTO l_adj_amt,
2632: l_pend_amt
2633: FROM ar_adjustments
2634: WHERE payment_schedule_id = l_ps_id
2635: AND associated_cash_receipt_id = l_ass_cr_id
2636: AND chargeback_customer_trx_id iS NULL;
2637: --

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

2658: IF PG_DEBUG in ('Y', 'C') THEN
2659: arp_debug.debug( 'after validate_cb_reversal in app_delete' );
2660: END IF;
2661: --
2662: /**** FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2663: LOOP
2664: IF PG_DEBUG in ('Y', 'C') THEN
2665: arp_debug.debug( 'inside for ar_adjustments_C in app_delete' );
2666: END IF;

Line 2665: arp_debug.debug( 'inside for ar_adjustments_C in app_delete' );

2661: --
2662: /**** FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2663: LOOP
2664: IF PG_DEBUG in ('Y', 'C') THEN
2665: arp_debug.debug( 'inside for ar_adjustments_C in app_delete' );
2666: END IF;
2667: IF ( validate_cb_reversal(
2668: l_adj_rec.chargeback_customer_trx_id, l_cb_count
2669: p_module_name, p_module_version ) <> TRUE ) THEN

Line 2682: FROM ar_adjustments adj,

2678: -- However, this should be done at a different level.
2679: --
2680: /* SELECT adj.adjustment_id,
2681: ps.payment_schedule_id
2682: FROM ar_adjustments adj,
2683: ar_payment_schedules ps
2684: WHERE adj.associated_cash_receipt_id = l_ass_cr_id
2685: AND adj.payment_schedule_id = l_ps_id
2686: AND adj.chargeback_customer_trx_id = ps.customer_trx_id(+)

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

2798: l_ps_rec ar_payment_schedules%ROWTYPE;
2799:
2800: l_count NUMBER DEFAULT 0;
2801: --
2802: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2803: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2804: SELECT a.chargeback_customer_trx_id,
2805: a.adjustment_id,
2806: a.status

Line 2807: FROM ar_adjustments a,

2803: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2804: SELECT a.chargeback_customer_trx_id,
2805: a.adjustment_id,
2806: a.status
2807: FROM ar_adjustments a,
2808: ar_adjustments b
2809: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2810: AND a.associated_cash_receipt_id = l_ass_cr_id
2811: AND a.payment_schedule_id = l_ps_id

Line 2808: ar_adjustments b

2804: SELECT a.chargeback_customer_trx_id,
2805: a.adjustment_id,
2806: a.status
2807: FROM ar_adjustments a,
2808: ar_adjustments b
2809: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2810: AND a.associated_cash_receipt_id = l_ass_cr_id
2811: AND a.payment_schedule_id = l_ps_id
2812: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID

Line 2816: CURSOR ar_adjustments_radj_C(

2812: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2813: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2814: AND b.customer_trx_id is null;
2815: --
2816: CURSOR ar_adjustments_radj_C(
2817: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2818: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2819: SELECT adjustment_id,
2820: status

Line 2821: FROM ar_adjustments

2817: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2818: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2819: SELECT adjustment_id,
2820: status
2821: FROM ar_adjustments
2822: WHERE associated_cash_receipt_id = l_ass_cr_id
2823: AND payment_schedule_id = l_ps_id
2824: AND status <> 'R'
2825: AND associated_application_id = p_ra_id --Bug2144783

Line 2830: FROM ar_adjustments

2826: AND chargeback_customer_trx_id is null
2827: UNION
2828: SELECT adjustment_id,
2829: status
2830: FROM ar_adjustments
2831: WHERE associated_cash_receipt_id = l_ass_cr_id
2832: AND payment_schedule_id = l_ps_id
2833: AND status <> 'R'
2834: AND associated_application_id is null

Line 2867: arp_debug.debug( 'Select from ar_adjustments failed' );

2863: WHERE receivable_application_id = p_ra_id;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: IF PG_DEBUG in ('Y', 'C') THEN
2867: arp_debug.debug( 'Select from ar_adjustments failed' );
2868: END IF;
2869: RETURN;
2870: END;
2871: ELSE

Line 2950: FROM ar_adjustments

2946: l_app_rec.tax_applied,
2947: l_app_rec.freight_applied,
2948: l_app_rec.receivables_charges_applied,
2949: l_app_rec.charges_type_adjusted
2950: FROM ar_adjustments
2951: WHERE payment_schedule_id = l_ps_id
2952: AND associated_cash_receipt_id = l_ass_cr_id;
2953: --
2954: IF PG_DEBUG in ('Y', 'C') THEN

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

2955: arp_debug.debug( 'before for reverse_action in app_delete' );
2956: arp_debug.debug( to_char( l_ps_id ) );
2957: arp_debug.debug( to_char( l_ass_cr_id ) );
2958: END IF;
2959: FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2960: LOOP
2961: l_count := l_count + 1;
2962: IF PG_DEBUG in ('Y', 'C') THEN
2963: arp_debug.debug( 'inside for ar_adjustments_C in app_delete' );

Line 2963: arp_debug.debug( 'inside for ar_adjustments_C in app_delete' );

2959: FOR l_adj_rec IN ar_adjustments_C( l_ps_id, l_ass_cr_id )
2960: LOOP
2961: l_count := l_count + 1;
2962: IF PG_DEBUG in ('Y', 'C') THEN
2963: arp_debug.debug( 'inside for ar_adjustments_C in app_delete' );
2964: END IF;
2965: --
2966: -- reverse chargeback
2967: --

Line 2993: arp_debug.debug( 'before if ar_adjustments_C%ROWCOUNT in app_delete ' );

2989: END IF;
2990: END LOOP;
2991: --
2992: IF PG_DEBUG in ('Y', 'C') THEN
2993: arp_debug.debug( 'before if ar_adjustments_C%ROWCOUNT in app_delete ' );
2994: END IF;
2995: IF ( l_count = 0 AND l_adj_amount = 0 AND
2996: l_app_rec.amount_adjusted_pending = 0 ) THEN
2997: IF PG_DEBUG in ('Y', 'C') THEN

Line 3008: arp_debug.debug( 'before for ar_adjustments_radj_C in app_delete' );

3004: -- Reverse adjustments , call armradj,
3005: -- select only adjustments that have not been rejected
3006: --
3007: IF PG_DEBUG in ('Y', 'C') THEN
3008: arp_debug.debug( 'before for ar_adjustments_radj_C in app_delete' );
3009: END IF;
3010: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )
3011: LOOP
3012: IF PG_DEBUG in ('Y', 'C') THEN

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

3006: --
3007: IF PG_DEBUG in ('Y', 'C') THEN
3008: arp_debug.debug( 'before for ar_adjustments_radj_C in app_delete' );
3009: END IF;
3010: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )
3011: LOOP
3012: IF PG_DEBUG in ('Y', 'C') THEN
3013: arp_debug.debug( 'inside for ar_adjustments_radj_C in app_delete' );
3014: END IF;

Line 3013: arp_debug.debug( 'inside for ar_adjustments_radj_C in app_delete' );

3009: END IF;
3010: FOR l_adj_rec IN ar_adjustments_radj_C( l_ps_id, l_ass_cr_id )
3011: LOOP
3012: IF PG_DEBUG in ('Y', 'C') THEN
3013: arp_debug.debug( 'inside for ar_adjustments_radj_C in app_delete' );
3014: END IF;
3015: arp_process_adjustment.reverse_adjustment( l_adj_rec.adjustment_id,
3016: p_reversal_gl_date,
3017: p_reversal_date,

Line 9221: ar_adjustments adj

9217:
9218: cursor c_dep_exists is
9219: SELECT trx.initial_customer_trx_id
9220: FROM ra_customer_trx trx,
9221: ar_adjustments adj
9222: WHERE trx.customer_trx_id = p_cm_cust_trx_id
9223: AND adj.customer_trx_id = p_inv_cust_trx_id
9224: AND adj.subsequent_trx_id = p_cm_cust_trx_id; --Bug 14376534
9225:

Line 9230: from ar_adjustments_all adj,

9226: cursor c_comm_adj(p_inv_customer_trx_id number,
9227: p_cm_customer_trx_id number,
9228: p_initial_customer_trx_id number) is
9229: select adj.adjustment_id
9230: from ar_adjustments_all adj,
9231: ra_customer_trx ra
9232: where adj.customer_trx_id = p_inv_customer_trx_id
9233: and adj.subsequent_trx_id = p_cm_customer_trx_id
9234: and ra.initial_customer_trx_id = p_initial_customer_trx_id

Line 9239: l_adj_rec ar_adjustments%ROWTYPE;

9235: and adj.customer_trx_id = ra.customer_trx_id;
9236:
9237: l_initial_customer_trx_id number;
9238: l_adjustment_id number;
9239: l_adj_rec ar_adjustments%ROWTYPE;
9240: l_app_rec arp_global.app_rec_type;
9241: l_rev_gl_date DATE ;
9242: l_default_gl_date DATE;
9243: l_error_message VARCHAR2(128);