1 Package pay_range_api as
2 /* $Header: pyranapi.pkh 120.0.12000000.2 2007/02/10 10:10:44 vetsrini noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< create_range >------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- This procedure creates range for tax tables
12 --
13 -- Prerequisites:
14 -- p_RANGE_TABLE_ID,P_LOW_BAND,P_HIGH_BAND,P_AMOUNT1
15 -- must be passed
16 --
17 -- In Parameter:
18 --
19 --
20 -- Post Success:
21 -- Development dependant.
22 --
23 -- Post Failure:
24 -- Developement dependant.
25 --
26 -- Developer Implementation Notes:
27 --
28 -- Access Status:
29 -- Internal Development Use Only.
30 --
31 -- {End Of Comments}
32 -- ----------------------------------------------------------------------------
33 procedure create_range
34 (
35 p_RANGE_TABLE_ID in NUMBER default NULL
36 ,P_LOW_BAND in NUMBER default NULL
37 ,P_HIGH_BAND in NUMBER default NULL
38 ,P_AMOUNT1 in NUMBER default NULL
39 ,P_AMOUNT2 in NUMBER default NULL
40 ,P_AMOUNT3 in NUMBER default NULL
41 ,P_AMOUNT4 in NUMBER default NULL
42 ,P_AMOUNT5 in NUMBER default NULL
43 ,P_AMOUNT6 in NUMBER default NULL
44 ,P_AMOUNT7 in NUMBER default NULL
45 ,P_AMOUNT8 in NUMBER default NULL
46 ,p_EFFECTIVE_START_DATE in DATE default NULL
47 ,p_EFFECTIVE_END_DATE in DATE default NULL
48 ,p_object_version_number OUT nocopy number
49 ,p_range_id OUT nocopy number
50 );
51
52 --
53 -- ----------------------------------------------------------------------------
54 -- |----------------------------< update_range >------------------------|
55 -- ----------------------------------------------------------------------------
56 --
57 -- {Start Of Comments}
58 --
59 -- Description:
60 -- This procedure updates the existing range
61 --
62 -- Prerequisites:
63 -- p_range_table_id,p_range_id,code
64 -- must be passed
65 --
66 -- In Parameter:
67 --
68 --
69 -- Post Success:
70 -- Development dependant.
71 --
72 -- Post Failure:
73 -- Developement dependant.
74 --
75 -- Developer Implementation Notes:
76 --
77 -- Access Status:
78 -- Internal Development Use Only.
79 --
80 -- {End Of Comments}
81 -- ----------------------------------------------------------------------------
82 procedure update_range
83 ( p_range_id in number
84 ,p_object_version_number in out nocopy number
85 ,p_range_table_id in number default hr_api.g_number
86 ,p_low_band in number default hr_api.g_number
87 ,p_high_band in number default hr_api.g_number
88 ,p_amount1 in number default hr_api.g_number
89 ,p_amount2 in number default hr_api.g_number
90 ,p_amount3 in number default hr_api.g_number
91 ,p_amount4 in number default hr_api.g_number
92 ,p_amount5 in number default hr_api.g_number
93 ,p_amount6 in number default hr_api.g_number
94 ,p_amount7 in number default hr_api.g_number
95 ,p_amount8 in number default hr_api.g_number
96 ,p_effective_start_date in date default hr_api.g_date
97 ,p_effective_end_date in date default hr_api.g_date
98 );
99 --
100 -- ----------------------------------------------------------------------------
101 -- |----------------------------< delete_range >------------------------|
102 -- ----------------------------------------------------------------------------
103 --
104 -- {Start Of Comments}
105 --
106 -- Description:
107 -- The procedure will delete range for tax tables
108 --
109 -- Prerequisites:
110 -- p_range_id must be passed
111 --
112 --
113 -- In Parameter:
114 --
115 --
116 -- Post Success:
117 -- Development dependant.
118 --
119 -- Post Failure:
120 -- Developement dependant.
121 --
122 -- Developer Implementation Notes:
123 --
124 -- Access Status:
125 -- Internal Development Use Only.
126 --
127 -- {End Of Comments}
128 -- ----------------------------------------------------------------------------
129 procedure delete_range
130 ( p_range_id in number
131 ,p_object_version_number in number
132 );
133
134 end pay_range_api;