[Home] [Help]
PACKAGE: APPS.ZX_TAX_CONTENT_UPLOAD
Source
1 PACKAGE ZX_TAX_CONTENT_UPLOAD AS
2 /* $Header: zxldgeorates.pls 120.3 2006/06/08 01:39:28 akaran ship $ */
3
4 --
5 -- Procedure to create master reference geography
6 --
7 PROCEDURE CREATE_GEOGRAPHY
8 (
9 errbuf OUT NOCOPY VARCHAR2,
10 retcode OUT NOCOPY VARCHAR2,
11 p_batch_size IN NUMBER,
12 p_worker_id IN NUMBER,
13 p_num_workers IN NUMBER,
14 p_tax_content_source IN VARCHAR2,
15 p_last_run_version IN NUMBER
16 );
17
18 --
19 -- Procedure to create tax geography for cities and jurisidictions for all
20 --
21 PROCEDURE CREATE_TAX_ZONES
22 (
23 errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY VARCHAR2,
25 p_tax_content_source IN VARCHAR2,
26 p_last_run_version IN NUMBER,
27 p_tax_regime_code IN VARCHAR2,
28 p_tax_zone_type IN VARCHAR2
29 );
30
31 --
32 -- Procedure to create master geography for postal codes
33 --
34 PROCEDURE CREATE_ZIP
35 (
36 errbuf OUT NOCOPY VARCHAR2,
37 retcode OUT NOCOPY VARCHAR2,
38 p_tax_content_source IN VARCHAR2,
39 p_last_run_version IN NUMBER
40 );
41
42 --
43 -- Procedure to create geography identifiers for alternate city names
44 --
45 PROCEDURE CREATE_ALTERNATE_CITIES
46 (
47 errbuf OUT NOCOPY VARCHAR2,
48 retcode OUT NOCOPY VARCHAR2,
49 p_tax_content_source IN VARCHAR2,
50 p_last_run_version IN NUMBER
51 );
52
53 --
54 -- Procedure to create rates
55 --
56 PROCEDURE CREATE_RATES
57 (
58 errbuf OUT NOCOPY VARCHAR2,
59 retcode OUT NOCOPY VARCHAR2,
60 p_tax_content_source IN VARCHAR2,
61 p_last_run_version IN NUMBER,
62 p_tax_regime_code IN VARCHAR2
63 );
64
65 --
66 -- Procedure to pre-process interface data and call other programs
67 --
68 PROCEDURE PROCESS_DATA
69 (
70 errbuf OUT NOCOPY VARCHAR2,
71 retcode OUT NOCOPY VARCHAR2,
72 p_batch_size IN NUMBER,
73 p_num_workers IN NUMBER,
74 p_tax_content_source_id IN NUMBER,
75 p_tax_regime_code IN VARCHAR2
76 );
77
78 --
79 -- Procedure to ppst-process interface data and call other programs
80 --
81 PROCEDURE POST_PROCESS_DATA
82 (
83 errbuf OUT NOCOPY VARCHAR2,
84 retcode OUT NOCOPY VARCHAR2,
85 p_tax_content_source_id IN NUMBER,
86 p_tax_regime_code IN VARCHAR2,
87 p_file_location_name IN VARCHAR2
88 );
89
90 --
91 -- Procedure to validate parameters and call SQL LOADER
92 --
93 PROCEDURE LOAD_FILE
94 (
95 errbuf OUT NOCOPY VARCHAR2,
96 retcode OUT NOCOPY VARCHAR2,
97 p_file_location_name IN VARCHAR2,
98 p_tax_content_source_id IN NUMBER,
99 p_tax_regime_code IN VARCHAR2
100 );
101
102 END ZX_TAX_CONTENT_UPLOAD; -- Package spec