1 PACKAGE ZX_TCM_GEO_JUR_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxcjurs.pls 120.13.12010000.2 2009/09/29 09:32:25 msakalab ship $ */
3
4
5 TYPE tax_jurisdiction_rec_type IS RECORD
6 ( tax_jurisdiction_id NUMBER,
7 tax_jurisdiction_code VARCHAR2(30),
8 ----- effective_from DATE,
9 ----- effective_to DATE,
10 tax_regime_code VARCHAR2(30),
11 ----- coll_tax_authority_id NUMBER,
12 ----- rep_tax_authority_id NUMBER,
13 tax VARCHAR2(30),
14 ----- zone_geography_id NUMBER,
15 ----- inner_city_jurisdiction_flag VARCHAR2(1),
16 precedence_level NUMBER
17 ----- default_jurisdiction_flg VARCHAR2(1),
18 ----- default_flg_effective_from DATE,
19 ----- default_flg_effective_to DATE
20 );
21
22 TYPE tax_jurisdiction_rec_tbl_type IS TABLE of tax_jurisdiction_rec_type INDEX BY BINARY_INTEGER;
23
24 -- bug fix 4090639
25 ----- g_jurisdiction_rec_tbl tax_jurisdiction_rec_tbl_type;
26
27 PROCEDURE get_zone
28 ( p_location_id IN NUMBER,
29 p_location_type IN VARCHAR2,
30 p_zone_type IN VARCHAR2,
31 p_trx_date IN DATE,
32 x_zone_tbl OUT NOCOPY HZ_GEO_GET_PUB.zone_tbl_type,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE get_pos_loc_or_site
36 ( p_party_type IN VARCHAR2,
37 x_loc_tbl OUT NOCOPY VARCHAR2,
38 x_loc_site OUT NOCOPY VARCHAR2,
39 x_return_status OUT NOCOPY VARCHAR2);
40
41
42 PROCEDURE get_tax_jurisdictions
43 ( p_location_id IN NUMBER,
44 p_location_type IN VARCHAR2,
45 p_tax IN VARCHAR2,
46 p_tax_regime_code IN VARCHAR2,
47 p_trx_date IN DATE,
48 x_tax_jurisdiction_rec OUT NOCOPY tax_jurisdiction_rec_type,
49 x_jurisdictions_found OUT NOCOPY VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE get_master_geography
53 (p_location_id IN VARCHAR2,
54 p_location_type IN VARCHAR2,
55 p_geography_type IN VARCHAR2,
56 x_geography_id OUT NOCOPY NUMBER,
57 x_geography_code OUT NOCOPY VARCHAR2,
58 x_geography_name OUT NOCOPY VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2);
60
61 TYPE LOCATION_TYPE_TBL_TYPE IS TABLE OF VARCHAR2(30) index by binary_integer;
62 TYPE LOCATION_ID_TBL_TYPE IS TABLE OF NUMBER index by binary_integer;
63
64
65 /*Added by Usha for bug 4458010 */
66 PROCEDURE RETRIEVE_GEO_VALUE
67 ( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
68 p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
69 p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
70 p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
71 p_location_type IN VARCHAR2,
72 p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
73 p_geography_type IN VARCHAR2,
74 x_geography_value OUT NOCOPY VARCHAR2,
75 x_geography_id OUT NOCOPY NUMBER,
76 x_geo_val_found OUT NOCOPY BOOLEAN);
77
78 PROCEDURE populate_loc_geography_info
79 (EVENT_CLASS_MAPPING_ID IN NUMBER,
80 TRX_ID IN NUMBER,
81 TRX_LINE_ID IN NUMBER,
82 TRX_LEVEL_TYPE IN VARCHAR2,
83 LOCATION_TYPE_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_TYPE_TBL_TYPE,
84 LOCATION_ID_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_ID_TBL_TYPE,
85 x_return_status OUT NOCOPY VARCHAR2);
86
87 TYPE GEOGRAPHY_ID_TBL_TYPE IS TABLE OF NUMBER index by VARCHAR2(200);
88 g_geography_id_tbl GEOGRAPHY_ID_TBL_TYPE;
89
90 TYPE GEOGRAPHY_TYPE_TBL_TYPE IS TABLE OF VARCHAR2(30) index by VARCHAR2(200);
91 g_geography_type_tbl GEOGRAPHY_TYPE_TBL_TYPE;
92
93 TYPE GEOGRAPHY_NAME_TBL_TYPE IS TABLE OF VARCHAR2(360) index by VARCHAR2(200);
94 g_geography_name_tbl GEOGRAPHY_NAME_TBL_TYPE;
95 END;