PACKAGE: APPS.PAY_NO_TAX_TABLE_UPLOAD

Source

1 PACKAGE PAY_NO_TAX_TABLE_UPLOAD
2 /* $Header: pynottup.pkh 120.0.12000000.1 2007/01/17 23:14:22 appldev noship $ */
3 AS
4 
5 PROCEDURE MAIN
6 (
7 errbuf                  OUT  nocopy  VARCHAR2,
8 retcode                 OUT  nocopy  NUMBER,
9 p_data_file_name         IN          VARCHAR2,
10 p_effective_start_date   IN          VARCHAR2,
11 p_business_group         IN          NUMBER
12 );
13 
14 
15 PROCEDURE PURGE(
16 errbuf                   OUT  nocopy VARCHAR2,
17 retcode                  OUT  nocopy NUMBER,
18 p_business_group       IN  NUMBER,
19 p_effective_start_date   IN   VARCHAR2,
20 p_effective_end_date     IN   VARCHAR2
21 );
22 
23 PROCEDURE check_date
24 (
25 p_effective_start_date   IN   varchar2,
26 p_effective_end_date     IN   varchar2,
27 p_message_name           IN   varchar2
28 );
29 
30 
31 PROCEDURE Upload_Tax_To_Temp_Table
32 (
33 errbuf          OUT nocopy VARCHAR2,
34 retcode         OUT nocopy  NUMBER,
35 p_data_file_name IN  VARCHAR2
36 );
37 
38 PROCEDURE Upload_Tax_To_Main_Table
39 (
40 errbuf             OUT  nocopy VARCHAR2,
41 retcode            OUT  nocopy NUMBER,
42 p_legislation_code     IN  VARCHAR2,
43 p_effective_start_date IN  DATE,
44 p_business_group       IN  NUMBER
45 );
46 
47 
48 PROCEDURE split_line
49 (
50 p_line             IN  VARCHAR2
51 ,p_RANGE_TABLE_NUMBER   OUT nocopy PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE
52 ,p_EARNINGS_TYPE        out nocopy PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE
53 ,p_PERIOD_FREQUENCY     OUT nocopy PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE
54 ,p_LOW_BAND             OUT nocopy PAY_RANGES_F.LOW_BAND%TYPE
55 ,p_AMOUNT1              OUT nocopy PAY_RANGES_F.AMOUNT1%TYPE
56 );
57 
58 
59 
60 PROCEDURE END_DATE_CHILD
61 (
62 p_Range_Table_id in Number
63 ,p_effective_start_date in DATE
64 );
65 END pay_no_tax_table_upload;