DBA Data[Home] [Help]

APPS.ARP_TRX_TAX_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 5: ra_customer_trx_lines.customer_trx_id%type,

1: PACKAGE ARP_TRX_TAX_UTIL AUTHID CURRENT_USER AS
2: /* $Header: ARTCTTXS.pls 115.2 2002/11/15 03:33:13 anukumar ship $ */
3:
4: PROCEDURE get_default_line_num(p_customer_trx_id IN
5: ra_customer_trx_lines.customer_trx_id%type,
6: p_customer_trx_line_id IN
7: ra_customer_trx_lines.customer_trx_line_id%type,
8: p_line_number OUT NOCOPY
9: ra_customer_trx_lines.line_number%type );

Line 7: ra_customer_trx_lines.customer_trx_line_id%type,

3:
4: PROCEDURE get_default_line_num(p_customer_trx_id IN
5: ra_customer_trx_lines.customer_trx_id%type,
6: p_customer_trx_line_id IN
7: ra_customer_trx_lines.customer_trx_line_id%type,
8: p_line_number OUT NOCOPY
9: ra_customer_trx_lines.line_number%type );
10:
11: PROCEDURE get_item_flex_defaults(p_inventory_item_id IN

Line 9: ra_customer_trx_lines.line_number%type );

5: ra_customer_trx_lines.customer_trx_id%type,
6: p_customer_trx_line_id IN
7: ra_customer_trx_lines.customer_trx_line_id%type,
8: p_line_number OUT NOCOPY
9: ra_customer_trx_lines.line_number%type );
10:
11: PROCEDURE get_item_flex_defaults(p_inventory_item_id IN
12: mtl_system_items.inventory_item_id%type,
13: p_organization_id IN

Line 37: ra_customer_trx_lines.customer_trx_id%type,

33: p_rule_start_date OUT NOCOPY
34: date );
35:
36: PROCEDURE select_summary(p_customer_trx_id IN
37: ra_customer_trx_lines.customer_trx_id%type,
38: p_customer_trx_line_id IN number,
39: p_mode IN varchar2,
40: p_total IN OUT NOCOPY
41: ra_customer_trx_lines.extended_amount%type,

Line 41: ra_customer_trx_lines.extended_amount%type,

37: ra_customer_trx_lines.customer_trx_id%type,
38: p_customer_trx_line_id IN number,
39: p_mode IN varchar2,
40: p_total IN OUT NOCOPY
41: ra_customer_trx_lines.extended_amount%type,
42: p_total_rtot_db IN OUT NOCOPY
43: ra_customer_trx_lines.extended_amount%type);
44:
45: PROCEDURE check_last_line_on_delete(p_customer_trx_line_id IN

Line 43: ra_customer_trx_lines.extended_amount%type);

39: p_mode IN varchar2,
40: p_total IN OUT NOCOPY
41: ra_customer_trx_lines.extended_amount%type,
42: p_total_rtot_db IN OUT NOCOPY
43: ra_customer_trx_lines.extended_amount%type);
44:
45: PROCEDURE check_last_line_on_delete(p_customer_trx_line_id IN
46: ra_customer_trx_lines.customer_trx_line_id%type
47: ,

Line 46: ra_customer_trx_lines.customer_trx_line_id%type

42: p_total_rtot_db IN OUT NOCOPY
43: ra_customer_trx_lines.extended_amount%type);
44:
45: PROCEDURE check_last_line_on_delete(p_customer_trx_line_id IN
46: ra_customer_trx_lines.customer_trx_line_id%type
47: ,
48: p_only_tax_line_flag OUT NOCOPY BOOLEAN);
49:
50: PROCEDURE check_unique_line(p_customer_trx_line_id IN

Line 51: ra_customer_trx_lines.customer_trx_line_id%type ,p_customer_trx_line_num IN

47: ,
48: p_only_tax_line_flag OUT NOCOPY BOOLEAN);
49:
50: PROCEDURE check_unique_line(p_customer_trx_line_id IN
51: ra_customer_trx_lines.customer_trx_line_id%type ,p_customer_trx_line_num IN
52: ra_customer_trx_lines.line_number%type,
53: p_unique_line_flag OUT NOCOPY BOOLEAN ) ;
54: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
55: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )

Line 52: ra_customer_trx_lines.line_number%type,

48: p_only_tax_line_flag OUT NOCOPY BOOLEAN);
49:
50: PROCEDURE check_unique_line(p_customer_trx_line_id IN
51: ra_customer_trx_lines.customer_trx_line_id%type ,p_customer_trx_line_num IN
52: ra_customer_trx_lines.line_number%type,
53: p_unique_line_flag OUT NOCOPY BOOLEAN ) ;
54: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
55: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )
56: RETURN NUMBER;

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

50: PROCEDURE check_unique_line(p_customer_trx_line_id IN
51: ra_customer_trx_lines.customer_trx_line_id%type ,p_customer_trx_line_num IN
52: ra_customer_trx_lines.line_number%type,
53: p_unique_line_flag OUT NOCOPY BOOLEAN ) ;
54: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
55: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )
56: RETURN NUMBER;
57: PROCEDURE check_tax_code(p_tax_code IN
58: ar_vat_tax.tax_code%type,

Line 55: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )

51: ra_customer_trx_lines.customer_trx_line_id%type ,p_customer_trx_line_num IN
52: ra_customer_trx_lines.line_number%type,
53: p_unique_line_flag OUT NOCOPY BOOLEAN ) ;
54: FUNCTION tax_balance(p_prev_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
55: p_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type )
56: RETURN NUMBER;
57: PROCEDURE check_tax_code(p_tax_code IN
58: ar_vat_tax.tax_code%type,
59: p_adhoc_tax_flag OUT NOCOPY BOOLEAN ) ;