1 Package hxc_han_bus as
2 /* $Header: hxchanrhi.pkh 120.0 2006/06/19 08:36:25 gsirigin noship $ */
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_comp_notification_id
15 -- p_object_version_number
16 -- already exists.
17 --
18 -- In Arguments:
19 -- p_comp_notification_id
20 -- p_object_version_number
21 --
22 --
23 -- Post Success:
24 -- The security_group_id will be set in CLIENT_INFO.
25 --
26 -- Post Failure:
27 -- An error is raised if the value does not exist.
28 --
29 -- Access Status:
30 -- Internal Development Use Only.
31 --
32 -- {End Of Comments}
33 -- ---------------------------------------------------------------------------
34 procedure set_security_group_id
35 (p_comp_notification_id in number
36 ,p_object_version_number in number
37 ,p_associated_column1 in varchar2 default null
38 ,p_associated_column2 in varchar2 default null
39 );
40 --
41 --
42 -- ---------------------------------------------------------------------------
43 -- |---------------------< return_legislation_code >-------------------------|
44 -- ---------------------------------------------------------------------------
45 -- {Start Of Comments}
46 --
47 -- Description:
48 -- Return the legislation code for a specific primary key value
49 --
50 -- Prerequisites:
51 -- The primary key identified by p_comp_notification_id
52 -- p_object_version_number
53 -- already exists.
54 --
55 -- In Arguments:
56 -- p_comp_notification_id
57 -- p_object_version_number
58 --
59 --
60 -- Post Success:
61 -- The business group's legislation code will be returned.
62 --
63 -- Post Failure:
64 -- An error is raised if the value does not exist.
65 --
66 -- Access Status:
67 -- Internal Development Use Only.
68 --
69 -- {End Of Comments}
70 -- ---------------------------------------------------------------------------
71 FUNCTION return_legislation_code
72 (p_comp_notification_id in number
73 ,p_object_version_number in number
74 ) RETURN varchar2;
75 --
76 --
77 -- ---------------------------------------------------------------------------
78 -- |---------------------< chk_notification_action_code >---------------------|
79 -- ---------------------------------------------------------------------------
80 -- {Start Of Comments}
81 --
82 -- Description:
83 -- Checks if the action code belongs to the set of notifications i.e It
84 -- must have one of these values - APPROVED, AUTO-APPROVE, ERROR,REJECTED,
85 -- REQUEST-APPROVAL, REQUEST-APPROVAL-RESEND, SUBMISSION,TRANSFER.
86 --
87 -- Prerequisites:
88 -- Notification action code must be passed.
89 --
90 -- In Arguments:
91 -- p_notification_action_code
92 --
93 --
94 -- Post Success:
95 -- Processing continues if the action code passed belongs to the list.
96 --
97 -- Post Failure:
98 -- An error is raised if the value does not belong to the list.
99 --
100 -- Access Status:
101 -- Internal Development Use Only.
102 --
103 -- {End Of Comments}
104 -- ---------------------------------------------------------------------------
105
106 Procedure chk_notification_action_code
107 ( p_notification_action_code in varchar2
108 );
109
110
111 --
112 --
113 -- ---------------------------------------------------------------------------
114 -- |---------------------< chk_notification_recip_code >---------------------|
115 -- ---------------------------------------------------------------------------
116 -- {Start Of Comments}
117 --
118 -- Description:
119 -- Checks if the recipient code belongs to the set of recipients i.e It
120 -- must have one of these values - ADMIN, APPROVER, ERROR-ADMIN,PREPARER,
121 -- SUPERVISOR, WORKER.
122 --
123 -- Prerequisites:
124 -- Notification recipient code must be passed.
125 --
126 -- In Arguments:
127 -- p_notification_recipient_code
128 --
129 --
130 -- Post Success:
131 -- Processing continues if the recipient code passed belongs to the list.
132 --
133 -- Post Failure:
134 -- An error is raised if the value does not belong to the list.
135 --
136 -- Access Status:
137 -- Internal Development Use Only.
138 --
139 -- {End Of Comments}
140 -- ---------------------------------------------------------------------------
141 Procedure chk_notification_recip_code
142 ( p_notification_recipient_code in varchar2
143 ) ;
144
145
146
147
148 --
149 --
150 -- ----------------------------------------------------------------------------
151 -- |---------------------------< insert_validate >----------------------------|
152 -- ----------------------------------------------------------------------------
153 -- {Start of comments}
154 --
155 -- Description:
156 -- This procedure controls the execution of all insert business rules
157 -- validation.
158 --
159 -- Prerequisites:
160 -- This private procedure is called from ins procedure.
161 --
162 -- In Parameters:
163 -- A Pl/Sql record structure.
164 --
165 -- Post Success:
166 -- Processing continues.
167 --
168 -- Post Failure:
169 -- If a business rules fails the error will not be handled by this procedure
170 -- unless explicity coded.
171 --
172 -- Developer Implementation Notes:
173 -- For insert, your business rules should be executed from this procedure
174 -- and should ideally (unless really necessary) just be straight procedure
175 -- or function calls. Try and avoid using conditional branching logic.
176 --
177 -- Access Status:
178 -- Internal Row Handler Use Only.
179 --
180 -- {End of comments}
181 -- ----------------------------------------------------------------------------
182 Procedure insert_validate
183 (p_rec in hxc_han_shd.g_rec_type
184 );
185 --
186 -- ----------------------------------------------------------------------------
187 -- |---------------------------< update_validate >----------------------------|
188 -- ----------------------------------------------------------------------------
189 -- {Start Of Comments}
190 --
191 -- Description:
192 -- This procedure controls the execution of all update business rules
193 -- validation.
194 --
195 -- Prerequisites:
196 -- This private procedure is called from upd procedure.
197 --
198 -- In Parameters:
199 -- A Pl/Sql record structure.
200 --
201 -- Post Success:
202 -- Processing continues.
203 --
204 -- Post Failure:
205 -- If a business rules fails the error will not be handled by this procedure
206 -- unless explicity coded.
207 --
208 -- Access Status:
209 -- Internal Row Handler Use Only.
210 --
211 -- {End Of Comments}
212 -- ----------------------------------------------------------------------------
213 Procedure update_validate
214 (p_rec in hxc_han_shd.g_rec_type
215 );
216 --
217 -- ----------------------------------------------------------------------------
218 -- |---------------------------< delete_validate >----------------------------|
219 -- ----------------------------------------------------------------------------
220 -- {Start Of Comments}
221 --
222 -- Description:
223 -- This procedure controls the execution of all delete business rules
224 -- validation.
225 --
226 -- Prerequisites:
227 -- This private procedure is called from del procedure.
228 --
229 -- In Parameters:
230 -- A Pl/Sql record structure.
231 --
232 -- Post Success:
233 -- Processing continues.
234 --
235 -- Post Failure:
236 -- If a business rules fails the error will not be handled by this procedure
237 -- unless explicity coded.
238 --
239 -- Developer Implementation Notes:
240 -- For delete, your business rules should be executed from this procedure
241 -- and should ideally (unless really necessary) just be straight procedure
242 -- or function calls. Try and avoid using conditional branching logic.
243 --
244 -- Access Status:
245 -- Internal Row Handler Use Only.
246 --
247 -- {End Of Comments}
248 -- ----------------------------------------------------------------------------
249 Procedure delete_validate
250 (p_rec in hxc_han_shd.g_rec_type
251 );
252 --
253 end hxc_han_bus;