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:

Line 114: INSERT into ra_cust_trx_line_gl_dist

110: the program_id logic to use -5 instead of a valid value.
111: That way, we can tell if this code created the tax or
112: if it came from somewhere else (rev rec, autoaccounting) */
113:
114: INSERT into ra_cust_trx_line_gl_dist
115: (
116: /* gl_dist_id used to be here - now populated by BRI trigger */
117: customer_trx_id, /* credit memo customer_trx_id */
118: customer_trx_line_id, /* credit memo customer_trx_line_id */

Line 237: ra_cust_trx_line_gl_dist ctlgd,

233: FROM
234: fnd_currencies foreign_fc,
235: ra_customer_trx ct,
236: ra_customer_trx_lines ctl,
237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,
240: ra_customer_trx_lines prev_ctl,
241: ra_cust_trx_line_gl_dist prev_ctlgd

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

234: fnd_currencies foreign_fc,
235: ra_customer_trx ct,
236: ra_customer_trx_lines ctl,
237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,
240: ra_customer_trx_lines prev_ctl,
241: ra_cust_trx_line_gl_dist prev_ctlgd
242: WHERE

Line 241: ra_cust_trx_line_gl_dist prev_ctlgd

237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,
240: ra_customer_trx_lines prev_ctl,
241: ra_cust_trx_line_gl_dist prev_ctlgd
242: WHERE
243: ct.customer_trx_id = p_customer_trx_id
244: AND ct.customer_trx_id = ctl.customer_trx_id
245: AND ctl.line_type = 'TAX'

Line 274: of ra_cust_trx_line_gl_dist */

270: END copy_inv_tax_dists;
271:
272: /* Records tax accounting prior to deletion in global plsql tables.
273: These rows are later used for a bulk update
274: of ra_cust_trx_line_gl_dist */
275:
276: PROCEDURE record_tax_accounts(p_customer_trx_id IN number)
277: IS
278:

Line 293: ra_cust_trx_line_gl_dist tgl,

289: zx.tax, -- ZX tax code
290: tgl.code_combination_id, -- tax account!
291: tl.vat_tax_id -- Tax Rate ID
292: FROM ra_customer_trx_lines tl,
293: ra_cust_trx_line_gl_dist tgl,
294: zx_lines zx
295: WHERE tl.customer_trx_id = p_customer_trx_id
296: AND tl.line_type = 'TAX'
297: AND tl.customer_trx_line_id = tgl.customer_trx_line_id

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

331: arp_debug.debug('arp_etax_services_pkg.record_tax_accounts()-');
332: END IF;
333: END record_tax_accounts;
334:
335: /* Uses tax account tables to bulk update ra_cust_trx_line_gl_dist with
336: corrected or overridden accounts. */
337:
338: PROCEDURE replace_tax_accounts
339: IS

Line 377: UPDATE ra_cust_trx_line_gl_dist gld

373: reasons to not preserve the original tax accounts */
374: IF t_customer_trx_id.EXISTS(1)
375: THEN
376: FORALL i IN t_customer_trx_id.FIRST .. t_customer_trx_id.LAST
377: UPDATE ra_cust_trx_line_gl_dist gld
378: SET code_combination_id = t_code_combination_id(i)
379: WHERE customer_trx_id = t_customer_trx_id(i)
380: AND account_class = 'TAX'
381: AND cust_trx_line_gl_dist_id IN

Line 383: FROM ra_cust_trx_line_gl_dist tgl,

379: WHERE customer_trx_id = t_customer_trx_id(i)
380: AND account_class = 'TAX'
381: AND cust_trx_line_gl_dist_id IN
382: (SELECT tgl.cust_trx_line_gl_dist_id
383: FROM ra_cust_trx_line_gl_dist tgl,
384: ra_customer_trx_lines tl,
385: zx_lines zx
386: WHERE tl.customer_trx_id = t_customer_trx_id(i)
387: AND tl.link_to_cust_trx_line_id =

Line 892: RA_CUST_TRX_LINE_GL_DIST REC,

888: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DESCRIPTION(1)
889: FROM
890: RA_CUSTOMER_TRX TRX,
891: RA_CUSTOMER_TRX_LINES LINES,
892: RA_CUST_TRX_LINE_GL_DIST REC,
893: FND_CURRENCIES CURR,
894: FND_DOCUMENT_SEQUENCES SEQ,
895: AR_SYSTEM_PARAMETERS AR,
896: RA_BATCH_SOURCES BS,

Line 2565: FROM ra_cust_trx_line_gl_dist

2561: IF l_rules_check_flag = 'Y'
2562: THEN
2563: SELECT account_set_flag
2564: INTO l_account_set_flag
2565: FROM ra_cust_trx_line_gl_dist
2566: WHERE customer_trx_id = p_customer_trx_id
2567: AND account_class = 'REC'
2568: AND latest_rec_flag = 'Y';
2569: