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 RA_CUSTOMER_TRX

Line 7: p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: NULL_VAR ar_payment_schedules%ROWTYPE; /* Added for Bug 460966 - Oracle 8 */
6: PROCEDURE validate_args_revcb(
7: p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
8: p_reversal_gl_date IN DATE,
9: p_reversal_date IN DATE );
10:
11: PROCEDURE validate_args_cbrev_ct (

Line 12: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE );

8: p_reversal_gl_date IN DATE,
9: p_reversal_date IN DATE );
10:
11: PROCEDURE validate_args_cbrev_ct (
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,

Line 83: p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

79: | In case of receipt CB, p_type will be "RECEIPT" |
80: | in all other cases it will be defaulted to "TRANSACTION"
81: +===========================================================================*/
82: PROCEDURE reverse_chargeback(
83: p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
84: p_reversal_gl_date IN DATE,
85: p_reversal_date IN DATE,
86: p_module_name IN VARCHAR2,
87: p_module_version IN VARCHAR2,

Line 144: ra_customer_trx ct

140:
141: SELECT dist.code_combination_id
142: INTO l_adj_rec.code_combination_id
143: FROM ra_cust_trx_line_gl_dist dist,
144: ra_customer_trx ct
145: WHERE ct.customer_trx_id = p_cb_ct_id
146: AND ct.customer_trx_id = dist.customer_trx_id
147: AND dist.account_class = 'REV';
148:

Line 297: p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

293: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
294: | |
295: +===========================================================================*/
296: PROCEDURE validate_args_revcb(
297: p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
298: p_reversal_gl_date IN DATE,
299: p_reversal_date IN DATE ) IS
300: BEGIN
301: IF PG_DEBUG in ('Y', 'C') THEN

Line 450: FROM ra_customer_trx ct,

446: END IF;
447: --
448: SELECT count( distinct ct.customer_trx_id )
449: INTO l_count
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,

Line 514: FUNCTION validate_cb_reversal ( p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

510: | This is an ovreloaded procedure |
511: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
512: | |
513: +===========================================================================*/
514: FUNCTION validate_cb_reversal ( p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
515: p_module_name IN VARCHAR2,
516: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
517: l_sum NUMBER DEFAULT 0;
518: --

Line 609: FROM ra_customer_trx ct,

605: END IF;
606: BEGIN
607: SELECT count(*)
608: INTO l_count
609: FROM ra_customer_trx ct,
610: ar_payment_schedules ps
611: WHERE ct.customer_trx_id = p_ct_id
612: AND ps.customer_trx_id = ct.customer_trx_id
613: AND ps.class = 'CB';

Line 664: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE ) IS

660: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
661: | |
662: +===========================================================================*/
663: PROCEDURE validate_args_cbrev_ct (
664: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
665: BEGIN
666: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_ct' );
667: IF ( p_ct_id is NULL ) THEN
668: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1039: 2. Insert header RA_CUSTOMER_TRX

1035: ARP_NON_DB_PKG.check_creation_sign procedures.
1036:
1037: The algorithm for creating chargebacks:
1038: 1. Instantiate variables with default values
1039: 2. Insert header RA_CUSTOMER_TRX
1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES
1041: 4. Insert revenue account GL distribution
1042: into RA_CUST_TRX_LINE_GL_DIST
1043: 5. Insert receivables account GL distribution

Line 1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES

1036:
1037: The algorithm for creating chargebacks:
1038: 1. Instantiate variables with default values
1039: 2. Insert header RA_CUSTOMER_TRX
1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES
1041: 4. Insert revenue account GL distribution
1042: into RA_CUST_TRX_LINE_GL_DIST
1043: 5. Insert receivables account GL distribution
1044: into RA_CUST_TRX_LINE_GL_DIST

Line 1064: ARTITRXB.pls Table handler for ra_customer_trx

1060: - arp_trx_global.system_info.base_precision
1061: - arp_trx_global.system_info.base_min_acc_unit
1062: ARCUTILB.pls
1063: - validate_gl_date
1064: ARTITRXB.pls Table handler for ra_customer_trx
1065: - insert_p
1066: ARTICTLB.pls Table handler for ra_customer_trx_lines
1067: - insert_p
1068: ARTILGDB.pls Table handler ra_cust_trx_line_gl_dist

Line 1066: ARTICTLB.pls Table handler for ra_customer_trx_lines

1062: ARCUTILB.pls
1063: - validate_gl_date
1064: ARTITRXB.pls Table handler for ra_customer_trx
1065: - insert_p
1066: ARTICTLB.pls Table handler for ra_customer_trx_lines
1067: - insert_p
1068: ARTILGDB.pls Table handler ra_cust_trx_line_gl_dist
1069: - insert_p
1070: ARTEADJS.pls Adjustment procedures

Line 1097: ra_customer_trx row was created.

1093:
1094: MODIFICATION HISTORY
1095: 10/09/1995 H.Kaukovuo Created
1096: 7/29/1996 Harri Kaukovuo Bug 386242, term_id was not populated when
1097: ra_customer_trx row was created.
1098: 7/30/1996 Harri Kaukovuo Bug fix 386662 document numbering was missing
1099: from the chargeback adjustment.
1100: 11/17/1997 Genneva Wang Bug fix 412726 - (1) Creation of Chargeback
1101: should give message if GL Account assignment

Line 1208: l_ct_row ra_customer_trx%ROWTYPE;

1204: , p_legal_entity_id IN NUMBER /* R12 LE uptake */
1205: )
1206: IS
1207:
1208: l_ct_row ra_customer_trx%ROWTYPE;
1209: l_ctl_row ra_customer_trx_lines%ROWTYPE;
1210: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;
1211: l_ps_row ar_payment_schedules%ROWTYPE;
1212: l_adj_row ar_adjustments%ROWTYPE;

Line 1209: l_ctl_row ra_customer_trx_lines%ROWTYPE;

1205: )
1206: IS
1207:
1208: l_ct_row ra_customer_trx%ROWTYPE;
1209: l_ctl_row ra_customer_trx_lines%ROWTYPE;
1210: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;
1211: l_ps_row ar_payment_schedules%ROWTYPE;
1212: l_adj_row ar_adjustments%ROWTYPE;
1213:

Line 1265: l_org_id ra_customer_trx.org_id%type;

1261: l_creation_method_code ar_receipt_classes.creation_method_code%type;
1262: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
1263: l_instrument_type iby_trxn_extensions_v.instrument_type%type;
1264: l_instr_assignment_id iby_trxn_extensions_v.instr_assignment_id%type;
1265: l_org_id ra_customer_trx.org_id%type;
1266: l_create_msg_count NUMBER;
1267: l_create_msg_data VARCHAR2(2000);
1268: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1269: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

Line 1348: -- RA_CUSTOMER_TRX already in form level. In client/server model

1344: -- init_app_struct (l_app_row);
1345:
1346: -- First initialize chargeback header
1347: -- NOTE that old Forms 2.3 program did the initial insert into
1348: -- RA_CUSTOMER_TRX already in form level. In client/server model
1349: -- inserting into RA_CUSTOMER_TRX is done here.
1350:
1351: -- Copy values from the applied transaction
1352:

Line 1349: -- inserting into RA_CUSTOMER_TRX is done here.

1345:
1346: -- First initialize chargeback header
1347: -- NOTE that old Forms 2.3 program did the initial insert into
1348: -- RA_CUSTOMER_TRX already in form level. In client/server model
1349: -- inserting into RA_CUSTOMER_TRX is done here.
1350:
1351: -- Copy values from the applied transaction
1352:
1353: -- snambiar - p_app_customer_trx_id -4 is used for receipt chargeback

Line 1405: , ra_customer_trx ct

1401: , ln_trx_number /*bug 5550153*/
1402: FROM
1403: ar_payment_schedules ps
1404: , ra_cust_trx_line_gl_dist ctlgd
1405: , ra_customer_trx ct
1406: WHERE
1407: ct.customer_trx_id = p_app_customer_trx_id
1408: AND ct.customer_trx_id = ps.customer_trx_id
1409: AND ct.customer_trx_id = ctlgd.customer_trx_id(+)

Line 1625: -- Insert header into RA_CUSTOMER_TRX table

1621: RAISE;
1622: END; -- Select printing option
1623:
1624: -- ---------------------------------------------------
1625: -- Insert header into RA_CUSTOMER_TRX table
1626: -- ---------------------------------------------------
1627:
1628: -- Call table handler, get trx_number and customer_trx_id back
1629: -- The main procedure will return trx_number and customer_trx_id

Line 1668: FROM RA_CUSTOMER_TRX

1664: WHERE receipt_method_id = l_ct_row.receipt_method_id;
1665:
1666: SELECT org_id
1667: INTO l_org_id
1668: FROM RA_CUSTOMER_TRX
1669: WHERE customer_trx_id = l_ct_row.customer_trx_id;
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: IF PG_DEBUG in ('Y', 'C') THEN

Line 1706: UPDATE ra_customer_trx

1702: l_create_return_status,
1703: l_payment_trxn_extension_id,
1704: l_ct_row.trx_date);
1705:
1706: UPDATE ra_customer_trx
1707: SET payment_trxn_extension_id = l_payment_trxn_extension_id
1708: WHERE customer_trx_id = p_out_customer_trx_id;
1709:
1710: END IF;

Line 1716: -- Get line type info for RA_CUSTOMER_TRX_LINES columns

1712: END IF;
1713: /*Bug 13788971 - Payment Intrument details population - End*/
1714:
1715: -- ---------------------------------------------------
1716: -- Get line type info for RA_CUSTOMER_TRX_LINES columns
1717: -- - memo_line_id = 1 means chargeback memo line
1718: -- ---------------------------------------------------
1719: IF p_app_customer_trx_id <> -4 THEN
1720: BEGIN

Line 1779: -- Set values for RA_CUSTOMER_TRX_LINES columns

1775: END;
1776: END IF;
1777:
1778: -- ---------------------------------------------------
1779: -- Set values for RA_CUSTOMER_TRX_LINES columns
1780: -- ---------------------------------------------------
1781:
1782: l_ctl_row.customer_trx_id := l_ct_row.customer_trx_id;
1783: l_ctl_row.line_number := 1;

Line 1798: -- Insert line into RA_CUSTOMER_TRX_LINES table

1794: l_ct_row.default_ussgl_trx_code_context;
1795: l_ctl_row.set_of_books_id := p_set_of_books_id;
1796:
1797: -- ---------------------------------------------------
1798: -- Insert line into RA_CUSTOMER_TRX_LINES table
1799: -- ---------------------------------------------------
1800:
1801: arp_ctl_pkg.insert_p(
1802: -- IN

Line 2374: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

2370: , p_attribute13 IN VARCHAR2
2371: , p_attribute14 IN VARCHAR2
2372: , p_attribute15 IN VARCHAR2) IS
2373:
2374: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
2375:
2376: BEGIN
2377:
2378: IF PG_DEBUG in ('Y', 'C') THEN

Line 2656: l_customer_id ra_customer_trx.paying_customer_id%type;

2652: l_extension_id NUMBER;
2653: l_init_extension_id NUMBER;
2654: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2655:
2656: l_customer_id ra_customer_trx.paying_customer_id%type;
2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;

Line 2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;

2653: l_init_extension_id NUMBER;
2654: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2655:
2656: l_customer_id ra_customer_trx.paying_customer_id%type;
2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;
2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

Line 2658: l_org_id ra_customer_trx.org_id%type;

2654: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2655:
2656: l_customer_id ra_customer_trx.paying_customer_id%type;
2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;
2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
2662: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 2660: l_trx_number ra_customer_trx.trx_number%type;

2656: l_customer_id ra_customer_trx.paying_customer_id%type;
2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;
2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
2662: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2663:
2664: l_start_date DATE;

Line 2662: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;
2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
2662: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2663:
2664: l_start_date DATE;
2665: l_end_date DATE;
2666: