1 PACKAGE pay_se_tax_table_upload
2 /* $Header: pysettup.pkh 120.2 2007/02/15 17:58:33 vetsrini noship $ */
3 AS
4 PROCEDURE main (
5 errbuf OUT NOCOPY VARCHAR2
6 ,retcode OUT NOCOPY NUMBER
7 ,p_data_file_name IN VARCHAR2
8 ,p_tax_table_type IN VARCHAR2
9 ,p_effective_start_date IN VARCHAR2
10 ,p_business_group IN NUMBER
11 );
12
13 PROCEDURE PURGE (
14 errbuf OUT NOCOPY VARCHAR2
15 ,retcode OUT NOCOPY NUMBER
16 ,p_business_group IN NUMBER
17 ,p_effective_start_date IN VARCHAR2
18 ,p_effective_end_date IN VARCHAR2
19 );
20
21 PROCEDURE check_date (
22 p_effective_start_date IN VARCHAR2
23 ,p_effective_end_date IN VARCHAR2
24 ,p_message_name IN VARCHAR2
25 );
26
27 PROCEDURE upload_tax_to_temp_table (
28 errbuf OUT NOCOPY VARCHAR2
29 ,retcode OUT NOCOPY NUMBER
30 ,p_data_file_name IN VARCHAR2
31 ,p_tax_table_type IN VARCHAR2
32 );
33
34 PROCEDURE upload_tax_to_main_table (
35 errbuf OUT NOCOPY VARCHAR2
36 ,retcode OUT NOCOPY NUMBER
37 ,p_legislation_code IN VARCHAR2
38 ,p_effective_start_date IN DATE
39 ,p_business_group IN NUMBER
40 ,p_tax_table_type IN VARCHAR2
41 );
42
43 PROCEDURE split_line (
44 p_line IN VARCHAR2
45 ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE
46 ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
47 ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
48 ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
49 ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50 ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51 ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52 ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53 ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54 ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55 ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56 ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
57 ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
58 );
59
60 PROCEDURE end_date_child (
61 p_range_table_id IN NUMBER
62 ,p_effective_start_date IN DATE
63 );
64 END pay_se_tax_table_upload;