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_TRX_TAX_UTIL dependencies on RA_CUSTOMER_TRX

Line 31: ra_customer_trx_lines.customer_trx_id%type,

27:
28: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
29:
30: PROCEDURE get_default_line_num(p_customer_trx_id IN
31: ra_customer_trx_lines.customer_trx_id%type,
32: p_customer_trx_line_id IN
33: ra_customer_trx_lines.customer_trx_line_id%type,
34: p_line_number OUT NOCOPY
35: ra_customer_trx_lines.line_number%type )

Line 33: ra_customer_trx_lines.customer_trx_line_id%type,

29:
30: PROCEDURE get_default_line_num(p_customer_trx_id IN
31: ra_customer_trx_lines.customer_trx_id%type,
32: p_customer_trx_line_id IN
33: ra_customer_trx_lines.customer_trx_line_id%type,
34: p_line_number OUT NOCOPY
35: ra_customer_trx_lines.line_number%type )
36: IS
37:

Line 35: ra_customer_trx_lines.line_number%type )

31: ra_customer_trx_lines.customer_trx_id%type,
32: p_customer_trx_line_id IN
33: ra_customer_trx_lines.customer_trx_line_id%type,
34: p_line_number OUT NOCOPY
35: ra_customer_trx_lines.line_number%type )
36: IS
37:
38: BEGIN
39:

Line 46: FROM ra_customer_trx_lines

42: END IF;
43:
44: SELECT nvl( max(line_number), 0 ) + 1
45: INTO p_line_number
46: FROM ra_customer_trx_lines
47: WHERE customer_trx_id = p_customer_trx_id
48: AND link_to_cust_trx_line_id = p_customer_trx_line_id
49: AND line_type = 'TAX';
50:

Line 109: ra_customer_trx.trx_date%type,

105: mtl_system_items.inventory_item_id%type,
106: p_organization_id IN
107: mtl_system_items.organization_id%type,
108: p_trx_date IN
109: ra_customer_trx.trx_date%type,
110: p_invoicing_rule_id IN
111: ra_customer_trx.invoicing_rule_id%type,
112: p_description OUT NOCOPY
113: mtl_system_items.description%type,

Line 111: ra_customer_trx.invoicing_rule_id%type,

107: mtl_system_items.organization_id%type,
108: p_trx_date IN
109: ra_customer_trx.trx_date%type,
110: p_invoicing_rule_id IN
111: ra_customer_trx.invoicing_rule_id%type,
112: p_description OUT NOCOPY
113: mtl_system_items.description%type,
114: p_primary_uom_code OUT NOCOPY
115: mtl_system_items.primary_uom_code%type,

Line 248: ra_customer_trx_lines.customer_trx_id%type,

244: | |
245: +===========================================================================*/
246:
247: PROCEDURE select_summary(p_customer_trx_id IN
248: ra_customer_trx_lines.customer_trx_id%type,
249: p_customer_trx_line_id IN number,
250: p_mode IN varchar2,
251: p_total IN OUT NOCOPY
252: ra_customer_trx_lines.extended_amount%type,

Line 252: ra_customer_trx_lines.extended_amount%type,

248: ra_customer_trx_lines.customer_trx_id%type,
249: p_customer_trx_line_id IN number,
250: p_mode IN varchar2,
251: p_total IN OUT NOCOPY
252: ra_customer_trx_lines.extended_amount%type,
253: p_total_rtot_db IN OUT NOCOPY
254: ra_customer_trx_lines.extended_amount%type)
255: IS
256:

Line 254: ra_customer_trx_lines.extended_amount%type)

250: p_mode IN varchar2,
251: p_total IN OUT NOCOPY
252: ra_customer_trx_lines.extended_amount%type,
253: p_total_rtot_db IN OUT NOCOPY
254: ra_customer_trx_lines.extended_amount%type)
255: IS
256:
257: BEGIN
258:

Line 265: FROM ra_customer_trx_lines

261: END IF;
262:
263: SELECT nvl(sum(extended_amount),0), nvl(sum(extended_amount),0)
264: INTO p_total, p_total_rtot_db
265: FROM ra_customer_trx_lines
266: WHERE customer_trx_id = p_customer_trx_id
267: AND NVL( link_to_cust_trx_line_id, -10 ) =
268: DECODE(p_mode,
269: 'LINE', p_customer_trx_line_id,

Line 311: ra_customer_trx_lines.customer_trx_line_id%type

307: | |
308: +===========================================================================*/
309:
310: PROCEDURE check_last_line_on_delete(p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type
312: ,
313: p_only_tax_line_flag OUT NOCOPY BOOLEAN)
314: IS
315: l_only_tax_line_flag varchar2(2);

Line 326: FROM ra_customer_trx_lines

322: INTO l_only_tax_line_flag
323: FROM dual
324: WHERE EXISTS
325: (SELECT 'deleted last tax line'
326: FROM ra_customer_trx_lines
327: WHERE link_to_cust_trx_line_id = p_customer_trx_line_id
328: AND line_type = 'TAX'
329: having count(*) = 1
330: ) ;

Line 373: ra_customer_trx_lines.customer_trx_line_id%type,

369: | |
370: +===========================================================================*/
371:
372: PROCEDURE check_unique_line(p_customer_trx_line_id IN
373: ra_customer_trx_lines.customer_trx_line_id%type,
374: p_customer_trx_line_num IN
375: ra_customer_trx_lines.line_number%type,
376: p_unique_line_flag OUT NOCOPY Boolean )
377: IS

Line 375: ra_customer_trx_lines.line_number%type,

371:
372: PROCEDURE check_unique_line(p_customer_trx_line_id IN
373: ra_customer_trx_lines.customer_trx_line_id%type,
374: p_customer_trx_line_num IN
375: ra_customer_trx_lines.line_number%type,
376: p_unique_line_flag OUT NOCOPY Boolean )
377: IS
378: l_unique_line_flag varchar2(2);
379: BEGIN

Line 389: FROM ra_customer_trx_lines

385: INTO l_unique_line_flag
386: FROM dual
387: WHERE EXISTS
388: (SELECT 'unique tax line'
389: FROM ra_customer_trx_lines
390: WHERE link_to_cust_trx_line_id = p_customer_trx_line_id
391: AND line_type = 'TAX'
392: AND line_number = p_customer_trx_line_num
393: ) ;

Line 440: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

436: | |
437: +===========================================================================*/
438:
439:
440: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
441: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )
442:
443: RETURN NUMBER IS
444: l_balance_due number;

Line 441: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )

437: +===========================================================================*/
438:
439:
440: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
441: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )
442:
443: RETURN NUMBER IS
444: l_balance_due number;
445: Begin

Line 453: FROM ra_customer_trx_lines ctl,

449: Which Are Complete */
450:
451: SELECT nvl(sum(extended_amount),0)
452: INTO l_balance_due
453: FROM ra_customer_trx_lines ctl,
454: ra_customer_trx ct
455: WHERE previous_customer_trx_line_id = p_prev_cust_trx_line_id
456: AND customer_trx_line_id <> p_cust_trx_line_id
457: AND ctl.customer_trx_id = ct.customer_trx_id

Line 454: ra_customer_trx ct

450:
451: SELECT nvl(sum(extended_amount),0)
452: INTO l_balance_due
453: FROM ra_customer_trx_lines ctl,
454: ra_customer_trx ct
455: WHERE previous_customer_trx_line_id = p_prev_cust_trx_line_id
456: AND customer_trx_line_id <> p_cust_trx_line_id
457: AND ctl.customer_trx_id = ct.customer_trx_id
458: AND ct.complete_flag = 'Y';