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

Line 29: TYPE amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%TYPE

25: | Table records for record and replace tax accounts |
26: +--------------------------------------------------------*/
27: TYPE table_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE regime_type IS TABLE OF zx_lines.tax_regime_code%TYPE
32: INDEX BY BINARY_INTEGER;
33: TYPE tax_type IS TABLE OF zx_lines.tax%TYPE

Line 35: TYPE flag_type IS TABLE OF ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE

31: TYPE regime_type IS TABLE OF zx_lines.tax_regime_code%TYPE
32: INDEX BY BINARY_INTEGER;
33: TYPE tax_type IS TABLE OF zx_lines.tax%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE flag_type IS TABLE OF ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE account_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE
38: INDEX BY BINARY_INTEGER;
39: TYPE tax_rate_type IS TABLE OF ra_customer_trx_lines_all.vat_tax_id%TYPE

Line 37: TYPE account_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE

33: TYPE tax_type IS TABLE OF zx_lines.tax%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE flag_type IS TABLE OF ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE account_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE
38: INDEX BY BINARY_INTEGER;
39: TYPE tax_rate_type IS TABLE OF ra_customer_trx_lines_all.vat_tax_id%TYPE
40: INDEX BY BINARY_INTEGER;
41: TYPE collected_tax_ccid_type IS TABLE OF ra_cust_trx_line_gl_dist_all.collected_tax_ccid%TYPE

Line 41: TYPE collected_tax_ccid_type IS TABLE OF ra_cust_trx_line_gl_dist_all.collected_tax_ccid%TYPE

37: TYPE account_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE
38: INDEX BY BINARY_INTEGER;
39: TYPE tax_rate_type IS TABLE OF ra_customer_trx_lines_all.vat_tax_id%TYPE
40: INDEX BY BINARY_INTEGER;
41: TYPE collected_tax_ccid_type IS TABLE OF ra_cust_trx_line_gl_dist_all.collected_tax_ccid%TYPE
42: INDEX BY BINARY_INTEGER;
43: TYPE attr_cat_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute_category%type
44: INDEX BY BINARY_INTEGER;
45: TYPE attr_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute1%type

Line 43: TYPE attr_cat_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute_category%type

39: TYPE tax_rate_type IS TABLE OF ra_customer_trx_lines_all.vat_tax_id%TYPE
40: INDEX BY BINARY_INTEGER;
41: TYPE collected_tax_ccid_type IS TABLE OF ra_cust_trx_line_gl_dist_all.collected_tax_ccid%TYPE
42: INDEX BY BINARY_INTEGER;
43: TYPE attr_cat_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute_category%type
44: INDEX BY BINARY_INTEGER;
45: TYPE attr_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute1%type
46: INDEX BY BINARY_INTEGER;
47: TYPE commnt_type IS TABLE OF ra_cust_trx_line_gl_dist_all.comments%type

Line 45: TYPE attr_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute1%type

41: TYPE collected_tax_ccid_type IS TABLE OF ra_cust_trx_line_gl_dist_all.collected_tax_ccid%TYPE
42: INDEX BY BINARY_INTEGER;
43: TYPE attr_cat_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute_category%type
44: INDEX BY BINARY_INTEGER;
45: TYPE attr_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute1%type
46: INDEX BY BINARY_INTEGER;
47: TYPE commnt_type IS TABLE OF ra_cust_trx_line_gl_dist_all.comments%type
48: INDEX BY BINARY_INTEGER;
49:

Line 47: TYPE commnt_type IS TABLE OF ra_cust_trx_line_gl_dist_all.comments%type

43: TYPE attr_cat_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute_category%type
44: INDEX BY BINARY_INTEGER;
45: TYPE attr_type IS TABLE OF ra_cust_trx_line_gl_dist_all.attribute1%type
46: INDEX BY BINARY_INTEGER;
47: TYPE commnt_type IS TABLE OF ra_cust_trx_line_gl_dist_all.comments%type
48: INDEX BY BINARY_INTEGER;
49:
50:
51: t_customer_trx_id table_id_type;

Line 141: INSERT into ra_cust_trx_line_gl_dist

137: the program_id logic to use -5 instead of a valid value.
138: That way, we can tell if this code created the tax or
139: if it came from somewhere else (rev rec, autoaccounting) */
140:
141: INSERT into ra_cust_trx_line_gl_dist
142: (
143: /* gl_dist_id used to be here - now populated by BRI trigger */
144: customer_trx_id, /* credit memo customer_trx_id */
145: customer_trx_line_id, /* credit memo customer_trx_line_id */

Line 264: ra_cust_trx_line_gl_dist ctlgd,

260: FROM
261: fnd_currencies foreign_fc,
262: ra_customer_trx ct,
263: ra_customer_trx_lines ctl,
264: ra_cust_trx_line_gl_dist ctlgd,
265: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
266: ra_customer_trx prev_ct,
267: ra_customer_trx_lines prev_ctl,
268: ra_cust_trx_line_gl_dist prev_ctlgd

Line 265: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */

261: fnd_currencies foreign_fc,
262: ra_customer_trx ct,
263: ra_customer_trx_lines ctl,
264: ra_cust_trx_line_gl_dist ctlgd,
265: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
266: ra_customer_trx prev_ct,
267: ra_customer_trx_lines prev_ctl,
268: ra_cust_trx_line_gl_dist prev_ctlgd
269: WHERE

Line 268: ra_cust_trx_line_gl_dist prev_ctlgd

264: ra_cust_trx_line_gl_dist ctlgd,
265: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
266: ra_customer_trx prev_ct,
267: ra_customer_trx_lines prev_ctl,
268: ra_cust_trx_line_gl_dist prev_ctlgd
269: WHERE
270: ct.customer_trx_id = p_customer_trx_id
271: AND ct.customer_trx_id = ctl.customer_trx_id
272: AND ctl.line_type = 'TAX'

Line 301: of ra_cust_trx_line_gl_dist */

297: END copy_inv_tax_dists;
298:
299: /* Records tax accounting prior to deletion in global plsql tables.
300: These rows are later used for a bulk update
301: of ra_cust_trx_line_gl_dist */
302:
303: PROCEDURE record_tax_accounts(p_customer_trx_id IN number)
304: IS
305:

Line 338: ra_cust_trx_line_gl_dist tgl,

334: tgl.attribute14,
335: tgl.attribute15,
336: tgl.comments
337: FROM ra_customer_trx_lines tl,
338: ra_cust_trx_line_gl_dist tgl,
339: zx_lines zx
340: WHERE tl.customer_trx_id = p_customer_trx_id
341: AND tl.line_type = 'TAX'
342: AND tl.customer_trx_line_id = tgl.customer_trx_line_id

Line 399: /* Uses tax account tables to bulk update ra_cust_trx_line_gl_dist with

395: arp_debug.debug('arp_etax_services_pkg.record_tax_accounts()-');
396: END IF;
397: END record_tax_accounts;
398:
399: /* Uses tax account tables to bulk update ra_cust_trx_line_gl_dist with
400: corrected or overridden accounts. */
401:
402: PROCEDURE replace_tax_accounts
403: IS

Line 443: UPDATE ra_cust_trx_line_gl_dist gld

439: reasons to not preserve the original tax accounts */
440: IF t_customer_trx_id.EXISTS(1)
441: THEN
442: FORALL i IN t_customer_trx_id.FIRST .. t_customer_trx_id.LAST
443: UPDATE ra_cust_trx_line_gl_dist gld
444: SET code_combination_id = t_code_combination_id(i),
445: collected_tax_ccid = t_collected_tax_ccid(i),
446: comments = t_comments(i),
447: attribute_category = t_attribute_category(i),

Line 467: FROM ra_cust_trx_line_gl_dist tgl,

463: WHERE customer_trx_id = t_customer_trx_id(i)
464: AND account_class = 'TAX'
465: AND cust_trx_line_gl_dist_id IN
466: (SELECT tgl.cust_trx_line_gl_dist_id
467: FROM ra_cust_trx_line_gl_dist tgl,
468: ra_customer_trx_lines tl,
469: zx_lines zx
470: WHERE tl.customer_trx_id = t_customer_trx_id(i)
471: AND tl.link_to_cust_trx_line_id =

Line 1004: RA_CUST_TRX_LINE_GL_DIST REC,

1000: l_allow_overapp
1001: FROM
1002: RA_CUSTOMER_TRX TRX,
1003: RA_CUSTOMER_TRX_LINES LINES,
1004: RA_CUST_TRX_LINE_GL_DIST REC,
1005: FND_CURRENCIES CURR,
1006: FND_DOCUMENT_SEQUENCES SEQ,
1007: AR_SYSTEM_PARAMETERS AR,
1008: RA_BATCH_SOURCES BS,

Line 2814: FROM ra_cust_trx_line_gl_dist

2810: IF l_rules_check_flag = 'Y'
2811: THEN
2812: SELECT account_set_flag
2813: INTO l_account_set_flag
2814: FROM ra_cust_trx_line_gl_dist
2815: WHERE customer_trx_id = p_customer_trx_id
2816: AND account_class = 'REC'
2817: AND latest_rec_flag = 'Y';
2818: