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.

[Home] [Help]

APPS.ARP_PROCESS_CREDIT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 182: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

178: p_uncr_freight_amount IN ra_customer_trx_lines.extended_amount%type,
179: p_freight_type IN varchar2,
180: p_freight_ctlid IN ra_customer_trx_lines.customer_trx_line_id%type,
181: p_mode IN varchar2,
182: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
183: p_currency_code IN fnd_currencies.currency_code%type,
184: p_status OUT NOCOPY varchar2)
185: IS
186: l_credited_frt_ctlid ra_customer_trx.customer_trx_id%type;

Line 1210: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1206: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1207: p_credit_line_amount IN ra_customer_trx_lines.extended_amount%type,
1208: p_credit_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1209: p_currency_code IN fnd_currencies.currency_code%type,
1210: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1211: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1212: p_compute_tax IN varchar2,
1213: p_line_percent IN number,
1214: p_credit_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 1518: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1514: p_form_name IN varchar2,
1515: p_form_version IN number,
1516: p_trx_rec IN ra_customer_trx%rowtype,
1517: p_trx_class IN ra_cust_trx_types.type%type,
1518: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1519: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1520: p_currency_code IN fnd_currencies.currency_code%type,
1521: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1522: p_line_percent IN number,

Line 1771: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1767:
1768: PROCEDURE rerun_aa(
1769: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1770: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1771: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1772: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1773: p_status OUT NOCOPY varchar2)
1774: IS
1775: l_ccid number;

Line 1772: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,

1768: PROCEDURE rerun_aa(
1769: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1770: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
1771: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1772: p_credit_amount IN ra_cust_trx_line_gl_dist.amount%type,
1773: p_status OUT NOCOPY varchar2)
1774: IS
1775: l_ccid number;
1776: l_concat_segments varchar2(2000);

Line 1896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1892: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
1893: ) IS
1894:
1895: l_line_rec ra_customer_trx_lines%rowtype;
1896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1897:
1898: BEGIN
1899:
1900: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');

Line 1996: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

1992: +===========================================================================*/
1993: PROCEDURE set_header_flags(
1994: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1995: p_new_trx_rec IN ra_customer_trx%rowtype,
1996: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1997: p_exch_rate_changed_flag OUT NOCOPY boolean,
1998: p_gl_date_changed_flag OUT NOCOPY boolean,
1999: p_complete_changed_flag OUT NOCOPY boolean,
2000: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)

Line 2003: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

1999: p_complete_changed_flag OUT NOCOPY boolean,
2000: p_old_trx_rec OUT NOCOPY ra_customer_trx%rowtype)
2001: IS
2002: l_old_trx_rec ra_customer_trx%rowtype;
2003: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2004: BEGIN
2005: arp_util.debug('arp_process_credit.set_header_flags()+');
2006:
2007: arp_ct_pkg.fetch_p(l_old_trx_rec, p_customer_trx_id);

Line 2019: FROM ra_cust_trx_line_gl_dist

2015: THEN
2016:
2017: SELECT gl_date
2018: INTO l_old_gl_date
2019: FROM ra_cust_trx_line_gl_dist
2020: WHERE customer_trx_id = p_customer_trx_id
2021: AND account_class = 'REC'
2022: AND latest_rec_flag = 'Y';
2023:

Line 2091: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

2087: p_form_version IN number,
2088: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2089: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2090: p_trx_class IN ra_cust_trx_types.type%type,
2091: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2092: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2093: p_currency_code IN fnd_currencies.currency_code%type,
2094: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2095: p_line_percent IN number,

Line 2110: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

2106: p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
2107: p_status OUT NOCOPY varchar2)
2108: IS
2109: l_old_trx_rec ra_customer_trx%rowtype;
2110: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
2111: l_exchange_rate ra_customer_trx.exchange_rate%type;
2112: l_exch_rate_changed_flag boolean;
2113: l_complete_changed_flag boolean;
2114: l_gl_date_changed_flag boolean;

Line 2149: ra_cust_trx_line_gl_dist gld,

2145: trx.trx_number trx_number,
2146: trx.customer_trx_id customer_trx_id,
2147: trx.org_id org_id
2148: FROM ra_customer_trx trx,
2149: ra_cust_trx_line_gl_dist gld,
2150: xla_transaction_entities_upg xet,
2151: xla_events ev
2152: WHERE trx.customer_trx_id = p_customer_trx_id
2153: AND trx.customer_trx_id = gld.customer_trx_id

Line 2634: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

2630: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2631: p_line_percent IN number,
2632: p_freight_percent IN number,
2633: p_memo_line_type IN ar_memo_lines.line_type%type,
2634: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2635: p_currency_code IN fnd_currencies.currency_code%type,
2636: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2637: p_compute_tax IN varchar2,
2638: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 2669: l_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

2665: l_freight_type varchar2(1);
2666: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
2667:
2668: l_result integer;
2669: l_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
2670: l_concat_segments varchar2(200);
2671: l_num_failed_dist_rows number;
2672: l_rows_processed number;
2673: l_errorbuf varchar2(2000);

Line 3184: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3181: p_line_percent IN number,
3182: p_freight_percent IN number,
3183: p_memo_line_type IN ar_memo_lines.line_type%type,
3184: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3185: p_currency_code IN fnd_currencies.currency_code%type,
3186: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
3187: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
3188: p_rerun_aa IN varchar2,

Line 3453: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

3449: +===========================================================================*/
3450:
3451: PROCEDURE freight_post_update(
3452: p_frt_rec IN ra_customer_trx_lines%rowtype,
3453: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3454: p_frt_ccid IN
3455: ra_cust_trx_line_gl_dist.code_combination_id%type)
3456: IS
3457: l_ccid

Line 3455: ra_cust_trx_line_gl_dist.code_combination_id%type)

3451: PROCEDURE freight_post_update(
3452: p_frt_rec IN ra_customer_trx_lines%rowtype,
3453: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3454: p_frt_ccid IN
3455: ra_cust_trx_line_gl_dist.code_combination_id%type)
3456: IS
3457: l_ccid
3458: ra_cust_trx_line_gl_dist.code_combination_id%type;
3459: l_concat_segments varchar2(200);

Line 3458: ra_cust_trx_line_gl_dist.code_combination_id%type;

3454: p_frt_ccid IN
3455: ra_cust_trx_line_gl_dist.code_combination_id%type)
3456: IS
3457: l_ccid
3458: ra_cust_trx_line_gl_dist.code_combination_id%type;
3459: l_concat_segments varchar2(200);
3460: l_num_failed_dist_rows number;
3461: l_rows_processed number;
3462: l_errorbuf varchar2(200);