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

Line 16: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,

12: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE );
13:
14: PROCEDURE validate_args_cbrev_group(
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,
17: p_ct_count IN NUMBER );
18: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19:
20: /*===========================================================================+

Line 93: l_adj_rec ar_adjustments%ROWTYPE;

89: l_amount NUMBER;
90: l_acctd_amount NUMBER;
91: l_ps_id NUMBER;
92: --
93: l_adj_rec ar_adjustments%ROWTYPE;
94: --
95: l_return_code VARCHAR2(20);
96: l_app_rec arp_global.app_rec_type;
97: --

Line 101: l_new_adjustment_number ar_adjustments.adjustment_number%TYPE;

97: --
98: l_msg_count number;
99: l_msg_data varchar2(250);
100: l_return_status varchar2(10);
101: l_new_adjustment_number ar_adjustments.adjustment_number%TYPE;
102: l_new_adjustment_id ar_adjustments.adjustment_id%TYPE;
103: l_mesg varchar2(250);
104: adj_api_failure exception;
105: --

Line 102: l_new_adjustment_id ar_adjustments.adjustment_id%TYPE;

98: l_msg_count number;
99: l_msg_data varchar2(250);
100: l_return_status varchar2(10);
101: l_new_adjustment_number ar_adjustments.adjustment_number%TYPE;
102: l_new_adjustment_id ar_adjustments.adjustment_id%TYPE;
103: l_mesg varchar2(250);
104: adj_api_failure exception;
105: --
106: BEGIN

Line 354: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,

350: | |
351: +===========================================================================*/
352: FUNCTION validate_cb_reversal (
353: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
354: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,
355: p_ct_count IN NUMBER, p_module_name IN VARCHAR2,
356: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
357: l_sum NUMBER DEFAULT 0;
358: --

Line 382: FROM ar_adjustments b,

378: INTO l_sum
379: FROM ar_receivable_applications ra
380: WHERE ra.applied_customer_trx_id in (
381: SELECT a.chargeback_customer_trx_id
382: FROM ar_adjustments b,
383: ar_adjustments a
384: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
385: AND a.associated_cash_receipt_id = p_ass_cr_id
386: AND a.payment_schedule_id = p_ps_id

Line 383: ar_adjustments a

379: FROM ar_receivable_applications ra
380: WHERE ra.applied_customer_trx_id in (
381: SELECT a.chargeback_customer_trx_id
382: FROM ar_adjustments b,
383: ar_adjustments a
384: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
385: AND a.associated_cash_receipt_id = p_ass_cr_id
386: AND a.payment_schedule_id = p_ps_id
387: AND b.receivables_trx_id(+) =

Line 412: FROM ar_adjustments

408: arp_standard.debug( 'inside SELECT nvl 2nd in app_delete' );
409: END IF;
410: SELECT NVL( sum( amount ), 0 )
411: INTO l_sum
412: FROM ar_adjustments
413: WHERE customer_trx_id in (
414: SELECT a.chargeback_customer_trx_id
415: FROM ar_adjustments a,
416: ar_adjustments b

Line 415: FROM ar_adjustments a,

411: INTO l_sum
412: FROM ar_adjustments
413: WHERE customer_trx_id in (
414: SELECT a.chargeback_customer_trx_id
415: FROM ar_adjustments a,
416: ar_adjustments b
417: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
418: AND a.associated_cash_receipt_id = p_ass_cr_id
419: AND a.payment_schedule_id = p_ps_id

Line 416: ar_adjustments b

412: FROM ar_adjustments
413: WHERE customer_trx_id in (
414: SELECT a.chargeback_customer_trx_id
415: FROM ar_adjustments a,
416: ar_adjustments b
417: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
418: AND a.associated_cash_receipt_id = p_ass_cr_id
419: AND a.payment_schedule_id = p_ps_id
420: AND b.receivables_trx_id(+) =

Line 454: FROM ar_adjustments b,

450: FROM ra_customer_trx ct,
451: ar_payment_schedules ps
452: WHERE ct.customer_trx_id in (
453: SELECT a.chargeback_customer_trx_id
454: FROM ar_adjustments b,
455: ar_adjustments a
456: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
457: AND a.associated_cash_receipt_id = p_ass_cr_id
458: AND a.payment_schedule_id = p_ps_id

Line 455: ar_adjustments a

451: ar_payment_schedules ps
452: WHERE ct.customer_trx_id in (
453: SELECT a.chargeback_customer_trx_id
454: FROM ar_adjustments b,
455: ar_adjustments a
456: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
457: AND a.associated_cash_receipt_id = p_ass_cr_id
458: AND a.payment_schedule_id = p_ps_id
459: AND b.receivables_trx_id(+) =

Line 573: FROM ar_adjustments

569: arp_standard.debug( 'inside SELECT nvl 2nd in app_delete' );
570: END IF;
571: SELECT NVL( sum( amount ), 0 )
572: INTO l_sum
573: FROM ar_adjustments
574: WHERE customer_trx_id = p_ct_id
575: AND NVL( postable, 'Y') = 'Y';
576: --
577: EXCEPTION

Line 707: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,

703: | |
704: +===========================================================================*/
705: PROCEDURE validate_args_cbrev_group(
706: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
707: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,
708: p_ct_count IN NUMBER ) IS
709: BEGIN
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_group' );

Line 825: p_adj_rec IN OUT NOCOPY AR_ADJUSTMENTS%ROWTYPE) IS

821: 4/2/1996 Harri Kaukovuo Created
822: ===========================================================================
823: */
824: PROCEDURE init_adj_struct (
825: p_adj_rec IN OUT NOCOPY AR_ADJUSTMENTS%ROWTYPE) IS
826: BEGIN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_standard.debug ('arp_process_chargeback.init_adj_struct()+');
829: END IF;

Line 1051: 9. Initialize variables for inserting a row into AR_ADJUSTMENTS

1047:
1048: 7. Initialize, then populate app_struct and ps_struct
1049:
1050: 8. Update AR_PAYMENT_SCHEDULES
1051: 9. Initialize variables for inserting a row into AR_ADJUSTMENTS
1052: 10. Insert into AR_ADJUSTMENTS by calling armiadj
1053:
1054: SCOPE
1055: Public

Line 1052: 10. Insert into AR_ADJUSTMENTS by calling armiadj

1048: 7. Initialize, then populate app_struct and ps_struct
1049:
1050: 8. Update AR_PAYMENT_SCHEDULES
1051: 9. Initialize variables for inserting a row into AR_ADJUSTMENTS
1052: 10. Insert into AR_ADJUSTMENTS by calling armiadj
1053:
1054: SCOPE
1055: Public
1056:

Line 1210: l_adj_row ar_adjustments%ROWTYPE;

1206: l_ct_row ra_customer_trx%ROWTYPE;
1207: l_ctl_row ra_customer_trx_lines%ROWTYPE;
1208: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;
1209: l_ps_row ar_payment_schedules%ROWTYPE;
1210: l_adj_row ar_adjustments%ROWTYPE;
1211:
1212: ln_app_payment_schedule_id NUMBER;
1213:
1214: ln_line_applied NUMBER;

Line 1957: -- Set values for AR_ADJUSTMENTS columns

1953: */
1954:
1955:
1956: -- ---------------------------------------------------
1957: -- Set values for AR_ADJUSTMENTS columns
1958: -- ---------------------------------------------------
1959:
1960: -- Caroline M Clyde December 23, 1997
1961: -- Log 597194

Line 2391: FROM ar_adjustments adj

2387: , ln_tax_adj
2388: , ln_frt_adj
2389: , ln_chrg_adj
2390: , lc_status
2391: FROM ar_adjustments adj
2392: WHERE adj.chargeback_customer_trx_id = p_customer_trx_id
2393: AND adj.receivables_trx_id = -11;
2394:
2395: EXCEPTION