1 package AR_BPA_UTILS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARBPAUTS.pls 120.3 2005/08/03 00:21:19 lishao noship $*/
3 pg_debug varchar2(1);
4
5 FUNCTION fn_get_header_level_so ( p_customer_trx_id IN number ) return varchar2 ;
6
7 FUNCTION fn_get_header_level_co ( p_customer_trx_id IN number ) return varchar2 ;
8
9 FUNCTION fn_get_billing_line_level ( p_customer_trx_id IN number ) return varchar2;
10
11 FUNCTION fn_get_profile_class_name ( p_customer_trx_id IN number ) return varchar2;
12
13 FUNCTION fn_get_tax_printing_option ( p_bill_to_site_use_id IN number, p_bill_to_customer_id in number) return varchar2;
14
15 FUNCTION fn_trx_has_groups ( p_customer_trx_id IN number ) return varchar2;
16
17 FUNCTION fn_get_line_taxrate ( p_customer_trx_line_id IN number) return varchar2;
18
19 FUNCTION fn_get_line_taxname ( p_customer_trx_line_id IN number) return varchar2;
20
21 FUNCTION fn_get_line_taxcode ( p_customer_trx_line_id IN number) return varchar2;
22
23 FUNCTION fn_get_group_taxrate (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2;
24
25 FUNCTION fn_get_group_taxname (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2;
26
27 FUNCTION fn_get_group_taxcode (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2;
28
29 FUNCTION fn_get_group_taxyn (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2;
30
31 FUNCTION fn_get_line_description ( p_customer_trx_line_id IN number) return varchar2;
32
33 /* Return contact name */
34 FUNCTION fn_get_contact_name (p_contact_id IN NUMBER) return varchar2 ;
35
36 /* Return contact phone */
37 FUNCTION fn_get_phone (p_contact_id IN NUMBER) return varchar2 ;
38
39 /* Return contact fax */
40 FUNCTION fn_get_fax (p_contact_id IN NUMBER) return varchar2 ;
41
42 function get_tax_description(
43 tax_rate in number,
44 vat_tax_id in number,
45 tax_exemption_id in number,
46 location_rate_id in number,
47 tax_precedence in number,
48 D_euro_taxable_amount in varchar2 ) return varchar2 ;
49
50 procedure create_dup_areas(
51 p_orig_template_id IN NUMBER,
52 p_dup_template_id IN NUMBER
53 );
54
55 procedure DELETE_FLEXFIELD_ITEMS (
56 P_DATASRC_APP_ID in NUMBER
57 );
58
59 procedure UPDATE_VIEW_ITEM (
60 P_ITEM_ID in NUMBER default null,
61 P_ITEM_CODE in VARCHAR2,
62 P_DISPLAY_LEVEL in VARCHAR2,
63 P_DATA_SOURCE_ID in NUMBER,
64 P_DISPLAY_ENABLED_FLAG in VARCHAR2,
65 P_SEEDED_APPLICATION_ID in NUMBER,
66 P_DATA_TYPE in VARCHAR2,
67 P_COLUMN_NAME in VARCHAR2,
68 P_ITEM_NAME in VARCHAR2,
69 P_DISPLAY_PROMPT in VARCHAR2,
70 P_ITEM_DESCRIPTION in VARCHAR2,
71 P_FLEXFIELD_ITEM_FLAG in VARCHAR2,
72 P_AMOUNT_ITEM_FLAG IN VARCHAR2,
73 P_ASSIGNMENT_ENABLED_FLAG IN VARCHAR2,
74 P_DISPLAYED_MULTI_LEVEL_FLAG IN VARCHAR2,
75 P_TAX_ITEM_FLAG in VARCHAR2,
76 P_TOTALS_ENABLED_FLAG in VARCHAR2,
77 P_LINK_ENABLED_FLAG in VARCHAR2,
78 P_ITEM_TYPE in VARCHAR2
79 );
80
81 procedure DELETE_VIEW_ITEM (
82 P_ITEM_ID in NUMBER
83 );
84
85 PROCEDURE debug (
86 p_message IN VARCHAR2,
87 p_log_level IN NUMBER default FND_LOG.LEVEL_STATEMENT,
88 p_module_name IN VARCHAR2 default 'ar.plsql.ar_bpa_utils_pkg');
89
90 end AR_BPA_UTILS_PKG;