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_CREDIT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 163: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

159: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
160: p_freight_type IN varchar2,
161: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
162: p_mode IN varchar2,
163: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
164: p_currency_code IN fnd_currencies.currency_code%type,
165: p_status OUT NOCOPY varchar2)
166: IS
167: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;

Line 1180: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1176: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1177: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1178: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1179: p_currency_code IN fnd_currencies.currency_code%type,
1180: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1181: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1182: p_compute_tax IN varchar2,
1183: p_line_percent IN number,
1184: p_credit_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 1488: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1484: p_form_name IN varchar2,
1485: p_form_version IN number,
1486: p_trx_rec IN ra_customer_trx%rowtype,
1487: p_trx_class IN ra_cust_trx_types.type%type,
1488: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1489: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1490: p_currency_code IN fnd_currencies.currency_code%type,
1491: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1492: p_line_percent IN number,

Line 1741: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1737:
1738: PROCEDURE rerun_aa(
1739: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1740: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1741: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1742: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1743: p_status OUT NOCOPY varchar2)
1744: IS
1745: l_ccid number;

Line 1742: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,

1738: PROCEDURE rerun_aa(
1739: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1740: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1741: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1742: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1743: p_status OUT NOCOPY varchar2)
1744: IS
1745: l_ccid number;
1746: l_concat_segments varchar2(2000);

Line 1866: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1862: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
1863: ) IS
1864:
1865: l_line_rec ra_customer_trx_lines%rowtype;
1866: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1867:
1868: BEGIN
1869:
1870: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');

Line 1966: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1962: +===========================================================================*/
1963: PROCEDURE set_header_flags(
1964: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1965: p_new_trx_rec IN ra_customer_trx%rowtype,
1966: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1967: p_exch_rate_changed_flag OUT NOCOPY boolean,
1968: p_gl_date_changed_flag OUT NOCOPY boolean,
1969: p_complete_changed_flag OUT NOCOPY boolean,
1970: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)

Line 1973: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

1969: p_complete_changed_flag OUT NOCOPY boolean,
1970: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)
1971: IS
1972: l_old_trx_rec ra_customer_trx%rowtype;
1973: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1974: BEGIN
1975: arp_util.debug('arp_process_credit.set_header_flags()+');
1976:
1977: arp_ct_pkg.fetch_p(l_old_trx_rec, p_customer_trx_id);

Line 1989: FROM ra_cust_trx_line_gl_dist

1985: THEN
1986:
1987: SELECT gl_date
1988: INTO l_old_gl_date
1989: FROM ra_cust_trx_line_gl_dist
1990: WHERE customer_trx_id = p_customer_trx_id
1991: AND account_class = 'REC'
1992: AND latest_rec_flag = 'Y';
1993:

Line 2061: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

2057: p_form_version IN number,
2058: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2059: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2060: p_trx_class IN ra_cust_trx_types.type%type,
2061: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2062: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2063: p_currency_code IN fnd_currencies.currency_code%type,
2064: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2065: p_line_percent IN number,

Line 2080: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

2076: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2077: p_status OUT NOCOPY varchar2)
2078: IS
2079: l_old_trx_rec ra_customer_trx%rowtype;
2080: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
2081: l_exchange_rate ra_customer_trx.exchange_rate%type;
2082: l_exch_rate_changed_flag boolean;
2083: l_complete_changed_flag boolean;
2084: l_gl_date_changed_flag boolean;

Line 2119: ra_cust_trx_line_gl_dist gld,

2115: trx.trx_number trx_number,
2116: trx.customer_trx_id customer_trx_id,
2117: trx.org_id org_id
2118: FROM ra_customer_trx trx,
2119: ra_cust_trx_line_gl_dist gld,
2120: xla_transaction_entities_upg xet,
2121: xla_events ev
2122: WHERE trx.customer_trx_id = p_customer_trx_id
2123: AND trx.customer_trx_id = gld.customer_trx_id

Line 2604: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

2600: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2601: p_line_percent IN number,
2602: p_freight_percent IN number,
2603: p_memo_line_type IN ar_memo_lines.line_type%type,
2604: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2605: p_currency_code IN fnd_currencies.currency_code%type,
2606: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2607: p_compute_tax IN varchar2,
2608: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 2639: l_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

2635: l_freight_type varchar2(1);
2636: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
2637:
2638: l_result integer;
2639: l_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
2640: l_concat_segments varchar2(200);
2641: l_num_failed_dist_rows number;
2642: l_rows_processed number;
2643: l_errorbuf varchar2(2000);

Line 3144: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3141: p_line_percent IN number,
3142: p_freight_percent IN number,
3143: p_memo_line_type IN ar_memo_lines.line_type%type,
3144: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3145: p_currency_code IN fnd_currencies.currency_code%type,
3146: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
3147: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
3148: p_rerun_aa IN varchar2,

Line 3413: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

3409: +===========================================================================*/
3410:
3411: PROCEDURE freight_post_update(
3412: p_frt_rec IN ra_customer_trx_lines%rowtype,
3413: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3414: p_frt_ccid IN
3415: ra_cust_trx_line_gl_dist.code_combination_id%type)
3416: IS
3417: l_ccid

Line 3415: ra_cust_trx_line_gl_dist.code_combination_id%type)

3411: PROCEDURE freight_post_update(
3412: p_frt_rec IN ra_customer_trx_lines%rowtype,
3413: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3414: p_frt_ccid IN
3415: ra_cust_trx_line_gl_dist.code_combination_id%type)
3416: IS
3417: l_ccid
3418: ra_cust_trx_line_gl_dist.code_combination_id%type;
3419: l_concat_segments varchar2(200);

Line 3418: ra_cust_trx_line_gl_dist.code_combination_id%type;

3414: p_frt_ccid IN
3415: ra_cust_trx_line_gl_dist.code_combination_id%type)
3416: IS
3417: l_ccid
3418: ra_cust_trx_line_gl_dist.code_combination_id%type;
3419: l_concat_segments varchar2(200);
3420: l_num_failed_dist_rows number;
3421: l_rows_processed number;
3422: l_errorbuf varchar2(200);