1 PACKAGE ARP_TRX_LINE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ARTCTLTS.pls 120.5 2008/11/04 09:56:25 nemani ship $ */
3
4 FUNCTION derive_last_date_to_cr(
5 p_customer_trx_line_id IN number,
6 p_last_period_to_cr IN number,
7 p_period_set_name IN varchar2 DEFAULT NULL) RETURN date;
8
9
10 FUNCTION derive_last_pd_to_cr( p_customer_trx_line_id IN number,
11 p_last_date_to_credit IN date ) RETURN number;
12
13 PROCEDURE get_default_line_num(p_customer_trx_id IN number,
14 p_line_number OUT NOCOPY number );
15
16 PROCEDURE get_item_flex_defaults(p_inventory_item_id IN Number,
17 p_organization_id IN Number,
18 p_trx_date IN Date,
19 p_invoicing_rule_id IN Number,
20 p_description OUT NOCOPY varchar2,
21 p_primary_uom_code OUT NOCOPY varchar2,
22 p_primary_uom_name OUT NOCOPY varchar2,
23 p_accounting_rule_id OUT NOCOPY number,
24 p_accounting_rule_name OUT NOCOPY varchar2,
25 p_accounting_rule_duration OUT NOCOPY number,
26 p_accounting_rule_type OUT NOCOPY varchar2,
27 p_rule_start_date OUT NOCOPY date,
28 p_frequency OUT NOCOPY varchar2
29 );
30
31 PROCEDURE get_max_line_number(p_customer_trx_id IN number,
32 p_line_number OUT NOCOPY number );
33
34 FUNCTION get_oe_header_id(p_oe_line_id IN VARCHAR2,
35 p_interface_context IN VARCHAR2 ) RETURN NUMBER;
36
37 FUNCTION get_tax_classification_code(p_vat_tax_id IN Number) RETURN VARCHAR2;
38
39 FUNCTION get_tax_amount(p_customer_trx_id IN NUMBER,
40 p_tax_type IN VARCHAR2) RETURN NUMBER;
41
42 FUNCTION get_tax_amount(p_customer_trx_id IN NUMBER,
43 p_customer_trx_line_id IN NUMBER,
44 p_tax_type IN VARCHAR2) RETURN NUMBER;
45
46 END ARP_TRX_LINE_UTIL;