1 PACKAGE ZX_TAX_RECOVERY_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxpotrxrecs.pls 120.1 2005/09/21 23:35:59 hongliu ship $ */
3
4 /* Get Purchase Order Distribution Rate */
5
6 FUNCTION Get_Po_Distribution_Rate (p_distribution_id IN po_distributions_all.po_distribution_id%TYPE) RETURN NUMBER;
7
8 /* Check if account in range */
9 TYPE get_rec_rate_tbl1 IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;
10 -- pg_get_tax_recovery_rate_tab get_rec_rate_tbl;
11 FUNCTION account_in_range
12 (p_passed_concat_segs IN VARCHAR2,
13 p_db_concat_segs_low IN VARCHAR2,
14 p_db_concat_segs_high IN VARCHAR2,
15 p_chart_of_accts IN VARCHAR2) return NUMBER ;
16
17
18 /* Check if account is overlapping */
19
20 FUNCTION account_overlap
21 (p_form_concat_segs_low IN VARCHAR2,
22 p_form_concat_segs_high IN VARCHAR2,
23 p_db_concat_segs_low IN VARCHAR2,
24 p_db_concat_segs_high IN VARCHAR2) return NUMBER ;
25
26
27
28 /* Get Tax rule Rate */
29
30 FUNCTION Get_Rule_Rate (p_rule IN NUMBER,
31 p_tax_date IN DATE default SYSDATE,
32 p_vendorclass po_vendors.vendor_type_lookup_code%TYPE,
33 p_concatenate in VARCHAR2) RETURN NUMBER;
34
35
36 /* Get Default Rate */
37
38 PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%TYPE,
39 p_tax_id IN ap_tax_codes_all.tax_id%TYPE,
40 p_tax_date IN DATE default SYSDATE,
41 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
42 p_vendor_id IN po_vendors.vendor_id%TYPE,
43 p_distribution_id IN po_distributions_all.po_distribution_id%TYPE,
44 p_tax_user_override_flag IN VARCHAR2,
45 p_user_tax_recovery_rate IN ap_tax_codes_all.tax_rate%TYPE,
46 p_concatenated_segments IN VARCHAR2,
47 p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE,
48 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
49 p_item_org_id IN mtl_system_items.organization_id%TYPE,
50 APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
51 FUNC_SHORT_NAME IN VARCHAR2 default 'NONE',
52 p_calling_sequence IN VARCHAR2,
53 p_chart_of_accounts_id IN gl_ledgers.chart_of_accounts_id%TYPE,
54 p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,
55 p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,
56 p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,
57 p_tax_recovery_rate IN OUT NOCOPY number);
58 END ZX_TAX_RECOVERY_PKG;