1 Package pay_cft_bus AUTHID CURRENT_USER as
2 /* $Header: pycatrhi.pkh 120.4.12020000.2 2012/11/27 10:14:53 pracagra ship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------
6 -- |---------------------< return_legislation_code >-------------------------|
7 -- ---------------------------------------------------------------------------
8 --
9 -- Description:
10 -- Return the legislation code for a specific primary key value
11 --
12 -- Prerequisites:
13 -- The primary key identified by p_emp_fed_tax_inf_id already exists.
14 --
15 -- In Arguments:
16 -- p_emp_fed_tax_inf_id
17 --
18 -- Post Success:
19 -- If the value is found this function will return the values business
20 -- group legislation code.
21 --
22 -- Post Failure:
23 -- An error is raised if the value does not exist.
24 --
25 -- Access Status:
26 -- Internal Development Use Only.
27 --
28 function return_legislation_code
29 (p_emp_fed_tax_inf_id in number) return varchar2;
30 --
31 /* For Bug Number 13258136 -Start */
32 -- ----------------------------------------------------------------------------
33 -- |-----------------------< chk_cpp_election_date>---------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description
38 -- This procedure executes the cpp election date validations.
39 --
40 -- Pre Conditions
41 -- None.
42 --
43 -- Post Success
44 -- Processing continues
45 --
46 -- Post Failure
47 -- Error handled by procedure
48 --
49 -- Access Status
50 -- Internal table handler use only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure chk_cpp_election_date(p_emp_fed_tax_inf_id in number,
55 p_cpp_election_date in date,
56 p_cpp_revocation_date in date,
57 p_cpp_qpp_exempt_flag in varchar2, --Added for bug 13542083
58 p_effective_date in date,
59 p_cpp_election_warning out nocopy boolean,
60 p_object_version_number in number);
61 --
62 -- ----------------------------------------------------------------------------
63 -- |-----------------------< chk_cpp_revocation_date>--------------------------|
64 -- ----------------------------------------------------------------------------
65 -- {Start Of Comments}
66 --
67 -- Description
68 -- This procedure executes the cpp revocation date validations.
69 --
70 -- Pre Conditions
71 -- None.
72 --
73 -- Post Success
74 -- Processing continues
75 --
76 -- Post Failure
77 -- Error handled by procedure
78 --
79 -- Access Status
80 -- Internal table handler use only.
81 --
82 -- {End Of Comments}
83 -- ----------------------------------------------------------------------------
84
85 Procedure chk_cpp_revocation_date(p_emp_fed_tax_inf_id in number,
86 p_cpp_election_date in date,
87 p_cpp_revocation_date in date,
88 p_cpp_qpp_exempt_flag in varchar2, --Added for bug 13542083
89 p_effective_date in date,
90 p_cpp_revocation_warning out nocopy boolean,
91 p_object_version_number in number);
92
93 /* For Bug Number 13258136 -End */
94 -- ----------------------------------------------------------------------------
95 -- |---------------------------< insert_validate >----------------------------|
96 -- ----------------------------------------------------------------------------
97 -- {Start Of Comments}
98 --
99 -- Description:
100 -- This procedure controls the execution of all insert business rules
101 -- validation.
102 --
103 -- Prerequisites:
104 -- This private procedure is called from ins procedure.
105 --
106 -- In Parameters:
107 -- A Pl/Sql record structre.
108 --
109 -- Post Success:
110 -- Processing continues.
111 --
112 -- Post Failure:
113 -- If a business rules fails the error will not be handled by this procedure
114 -- unless explicity coded.
115 --
116 -- Developer Implementation Notes:
117 -- For insert, your business rules should be executed from this procedure and
118 -- should ideally (unless really necessary) just be straight procedure or
119 -- function calls. Try and avoid using conditional branching logic.
120 --
121 -- Access Status:
122 -- Internal Row Handler Use Only.
123 --
124 -- {End Of Comments}
125 -- ----------------------------------------------------------------------------
126 Procedure insert_validate
127 (p_rec in pay_cft_shd.g_rec_type,
128 p_effective_date in date,
129 p_datetrack_mode in varchar2,
130 p_validation_start_date in date,
131 p_validation_end_date in date);
132 --
133 -- ----------------------------------------------------------------------------
134 -- |---------------------------< update_validate >----------------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start Of Comments}
137 --
138 -- Description:
139 -- This procedure controls the execution of all update business rules
140 -- validation.
141 --
142 -- Prerequisites:
143 -- This private procedure is called from upd procedure.
144 --
145 -- In Parameters:
146 -- A Pl/Sql record structre.
147 --
148 -- Post Success:
149 -- Processing continues.
150 --
151 -- Post Failure:
152 -- If a business rules fails the error will not be handled by this procedure
153 -- unless explicity coded.
154 --
155 -- Developer Implementation Notes:
156 -- For update, your business rules should be executed from this procedure and
157 -- should ideally (unless really necessary) just be straight procedure or
158 -- function calls. Try and avoid using conditional branching logic.
159 --
160 -- Access Status:
161 -- Internal Row Handler Use Only.
162 --
163 -- {End Of Comments}
164 -- ----------------------------------------------------------------------------
165 Procedure update_validate
166 (p_rec in pay_cft_shd.g_rec_type,
167 p_effective_date in date,
168 p_datetrack_mode in varchar2,
169 p_validation_start_date in date,
170 p_validation_end_date in date);
171 --
172 -- ----------------------------------------------------------------------------
173 -- |---------------------------< delete_validate >----------------------------|
174 -- ----------------------------------------------------------------------------
175 -- {Start Of Comments}
176 --
177 -- Description:
178 -- This procedure controls the execution of all delete business rules
179 -- validation.
180 --
181 -- Prerequisites:
182 -- This private procedure is called from del procedure.
183 --
184 -- In Parameters:
185 -- A Pl/Sql record structre.
186 --
187 -- Post Success:
188 -- Processing continues.
189 --
190 -- Post Failure:
191 -- If a business rules fails the error will not be handled by this procedure
192 -- unless explicity coded.
193 --
194 -- Developer Implementation Notes:
195 -- For delete, your business rules should be executed from this procedure and
196 -- should ideally (unless really necessary) just be straight procedure or
197 -- function calls. Try and avoid using conditional branching logic.
198 --
199 -- Access Status:
200 -- Internal Row Handler Use Only.
201 --
202 -- {End Of Comments}
203 -- ----------------------------------------------------------------------------
204 Procedure delete_validate
205 (p_rec in pay_cft_shd.g_rec_type,
206 p_effective_date in date,
207 p_datetrack_mode in varchar2,
208 p_validation_start_date in date,
209 p_validation_end_date in date);
210 --
211 end pay_cft_bus;