1 Package pay_ppe_bus AUTHID CURRENT_USER as
2 /* $Header: pypperhi.pkh 115.0 2000/06/07 04:40:52 pkm ship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< set_security_group_id >--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
11 -- group context.
12 --
13 -- Prerequisites:
14 -- The primary key identified by p_process_event_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_process_event_id
19 --
20 --
21 -- Post Success:
22 -- The security_group_id will be set in CLIENT_INFO.
23 --
24 -- Post Failure:
25 -- An error is raised if the value does not exist.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 -- ---------------------------------------------------------------------------
32 procedure set_security_group_id
33 (p_process_event_id in number
34 );
35 --
36 --
37 -- ---------------------------------------------------------------------------
38 -- |---------------------< return_legislation_code >-------------------------|
39 -- ---------------------------------------------------------------------------
40 -- {Start Of Comments}
41 --
42 -- Description:
43 -- Return the legislation code for a specific primary key value
44 --
45 -- Prerequisites:
46 -- The primary key identified by p_process_event_id
47 -- already exists.
48 --
49 -- In Arguments:
50 -- p_process_event_id
51 --
52 --
53 -- Post Success:
54 -- The business group's legislation code will be returned.
55 --
56 -- Post Failure:
57 -- An error is raised if the value does not exist.
58 --
59 -- Access Status:
60 -- Internal Development Use Only.
61 --
62 -- {End Of Comments}
63 -- ---------------------------------------------------------------------------
64 FUNCTION return_legislation_code
65 (p_process_event_id in number
66 ) RETURN varchar2;
67 --
68 -- ----------------------------------------------------------------------------
69 -- |---------------------------< chk_change_type >----------------------------|
70 -- ----------------------------------------------------------------------------
71 -- {Start of comments}
72 --
73 -- Description:
74 -- This procedure validates the change type is applicable.
75 --
76 -- Prerequisites:
77 -- The primary key identified by p_process_event_id already exists.
78 --
79 -- In Parameters:
80 -- A Pl/Sql record structure.
81 --
82 -- Post Success:
83 -- Processing continues.
84 --
85 -- Post Failure:
86 -- Error if change_type not recognised.
87 --
88 -- Access Status:
89 -- Internal Row Handler Use Only.
90 --
91 -- {End of comments}
92 -- ----------------------------------------------------------------------------
93 Procedure chk_change_type
94 (p_rec in pay_ppe_shd.g_rec_type
95 );
96 --
97 -- ----------------------------------------------------------------------------
98 -- |---------------------------< chk_status >----------------------------|
99 -- ----------------------------------------------------------------------------
100 -- {Start of comments}
101 --
102 -- Description:
103 -- This procedure validates the status code is applicable.
104 --
105 -- Prerequisites:
106 -- The primary key identified by p_process_event_id already exists.
107 --
108 -- In Parameters:
109 -- A Pl/Sql record structure.
110 --
111 -- Post Success:
112 -- Processing continues.
113 --
114 -- Post Failure:
115 -- Error if change_type not recognised.
116 --
117 -- Access Status:
118 -- Internal Row Handler Use Only.
119 --
120 -- {End of comments}
121 -- ----------------------------------------------------------------------------
122 Procedure chk_status
123 (p_rec in pay_ppe_shd.g_rec_type
124 );
125 --
126 -- ----------------------------------------------------------------------------
127 -- |---------------------------< chk_assignment_exists >----------------------------|
128 -- ----------------------------------------------------------------------------
129 -- {Start of comments}
130 --
131 -- Description:
132 -- This procedure validates the status code is applicable.
133 --
134 -- Prerequisites:
135 -- The primary key identified by p_process_event_id already exists.
136 --
137 -- In Parameters:
138 -- A Pl/Sql record structure.
139 --
140 -- Post Success:
141 -- Processing continues.
142 --
143 -- Post Failure:
144 -- Error if change_type not recognised.
145 --
146 -- Access Status:
147 -- Internal Row Handler Use Only.
148 --
149 -- {End of comments}
150 -- ----------------------------------------------------------------------------
151 Procedure chk_assignment_exists
152 (p_rec in pay_ppe_shd.g_rec_type
153 );
154 --
155 -- ----------------------------------------------------------------------------
156 -- |---------------------------< insert_validate >----------------------------|
157 -- ----------------------------------------------------------------------------
158 -- {Start of comments}
159 --
160 -- Description:
161 -- This procedure controls the execution of all insert business rules
162 -- validation.
163 --
164 -- Prerequisites:
165 -- This private procedure is called from ins procedure.
166 --
167 -- In Parameters:
168 -- A Pl/Sql record structure.
169 --
170 -- Post Success:
171 -- Processing continues.
172 --
173 -- Post Failure:
174 -- If a business rules fails the error will not be handled by this procedure
175 -- unless explicity coded.
176 --
177 -- Developer Implementation Notes:
178 -- For insert, your business rules should be executed from this procedure and
179 -- should ideally (unless really necessary) just be straight procedure or
180 -- function calls. Try and avoid using conditional branching logic.
181 --
182 -- Access Status:
183 -- Internal Row Handler Use Only.
184 --
185 -- {End of comments}
186 -- ----------------------------------------------------------------------------
187 Procedure insert_validate
188 (p_rec in pay_ppe_shd.g_rec_type
189 );
190 --
191 -- ----------------------------------------------------------------------------
192 -- |---------------------------< update_validate >----------------------------|
193 -- ----------------------------------------------------------------------------
194 -- {Start Of Comments}
195 --
196 -- Description:
197 -- This procedure controls the execution of all update business rules
198 -- validation.
199 --
200 -- Prerequisites:
201 -- This private procedure is called from upd procedure.
202 --
203 -- In Parameters:
204 -- A Pl/Sql record structure.
205 --
206 -- Post Success:
207 -- Processing continues.
208 --
209 -- Post Failure:
210 -- If a business rules fails the error will not be handled by this procedure
211 -- unless explicity coded.
212 --
213 -- Developer Implementation Notes:
214 -- For update, your business rules should be executed from this procedure and
215 -- should ideally (unless really necessary) just be straight procedure or
216 -- function calls. Try and avoid using conditional branching logic.
217 --
218 -- Access Status:
219 -- Internal Row Handler Use Only.
220 --
221 -- {End Of Comments}
222 -- ----------------------------------------------------------------------------
223 Procedure update_validate
224 (p_rec in pay_ppe_shd.g_rec_type
225 );
226 --
227 -- ----------------------------------------------------------------------------
228 -- |---------------------------< delete_validate >----------------------------|
229 -- ----------------------------------------------------------------------------
230 -- {Start Of Comments}
231 --
232 -- Description:
233 -- This procedure controls the execution of all delete business rules
234 -- validation.
235 --
236 -- Prerequisites:
237 -- This private procedure is called from del procedure.
238 --
239 -- In Parameters:
240 -- A Pl/Sql record structure.
241 --
242 -- Post Success:
243 -- Processing continues.
244 --
245 -- Post Failure:
246 -- If a business rules fails the error will not be handled by this procedure
247 -- unless explicity coded.
248 --
249 -- Developer Implementation Notes:
250 -- For delete, your business rules should be executed from this procedure and
251 -- should ideally (unless really necessary) just be straight procedure or
252 -- function calls. Try and avoid using conditional branching logic.
253 --
254 -- Access Status:
255 -- Internal Row Handler Use Only.
256 --
257 --
258 -- ----------------------------------------------------------------------------
259 Procedure delete_validate
260 (p_rec in pay_ppe_shd.g_rec_type
261 );
262 --
263 end pay_ppe_bus;