1 Package per_psh_bus as
2 /* $Header: pepshrhi.pkh 120.2 2006/05/08 19:34:18 tpapired 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_sharing_instance_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_sharing_instance_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_sharing_instance_id in number
34 ,p_associated_column1 in varchar2 default null
35 );
36 --
37 --
38 -- ---------------------------------------------------------------------------
39 -- |---------------------< return_legislation_code >-------------------------|
40 -- ---------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- Return the legislation code for a specific primary key value
45 --
46 -- Prerequisites:
47 -- The primary key identified by p_sharing_instance_id
48 -- already exists.
49 --
50 -- In Arguments:
51 -- p_sharing_instance_id
52 --
53 --
54 -- Post Success:
55 -- The business group's legislation code will be returned.
56 --
57 -- Post Failure:
58 -- An error is raised if the value does not exist.
59 --
60 -- Access Status:
61 -- Internal Development Use Only.
62 --
63 -- {End Of Comments}
64 -- ---------------------------------------------------------------------------
65 FUNCTION return_legislation_code
66 (p_sharing_instance_id in number
67 ) RETURN varchar2;
68 --
69 -- ----------------------------------------------------------------------------
70 -- |--------------------------< chk_scorecard_id >----------------------------|
71 -- ----------------------------------------------------------------------------
72 -- {Start Of Comments}
73 --
74 -- Description:
75 -- This procedure is used to validate that the specified scorecard exists
76 --
77 -- Pre Conditions:
78 -- The scorecard must already exist.
79 --
80 -- In Arguments:
81 -- p_scorecard_id
82 -- p_person_id
83 --
84 -- Post Success:
85 -- Processing continues if the scorecard is valid.
86 --
87 -- Post Failure:
88 -- An application error is raised if the scorecard does not exist.
89 --
90 -- {End Of Comments}
91 -- ----------------------------------------------------------------------------
92 Procedure chk_scorecard_id
93 (p_scorecard_id IN number
94 ,p_person_id IN number
95 );
96 --
97 --
98 -----------------------------------------------------------------------------
99 --------------------------------<chk_person_id>------------------------------
100 -----------------------------------------------------------------------------
101 --
102 -- Description:
103 -- - Validates that the person_id has been entered
104 -- as it is a mandatory column
105 --
106 -- Pre_conditions:
107 -- -
108 --
109 -- In Arguments:
110 -- p_person_id
111 --
112 -- Post Success:
113 -- Process continues if :
114 -- Person id is valid as of effective date.
115 --
116 -- Post Failure:
117 -- An application error is raised and processing is terminated if any of
118 -- the following cases are found :
119 -- -- person_id is not set or invalid
120 --
121 -- Access Status
122 -- Internal Table Handler Use Only.
123 --
124 --
125 procedure chk_person_id
126 (p_person_id in per_objectives.owning_person_id%TYPE
127 );
128 --
129 -- ----------------------------------------------------------------------------
130 -- |----------------------< chk_scorecard_person_unique >---------------------|
131 -- ----------------------------------------------------------------------------
132 -- {Start Of Comments}
133 --
134 -- Description:
135 -- This procedure is used to validate that the specified scorecard
136 -- and person_id combination doesn;t already exist.
137 --
138 -- Pre Conditions:
139 -- none
140 --
141 -- In Arguments:
142 -- p_scorecard_id
143 -- p_person_id
144 --
145 --
146 -- Post Success:
147 -- Processing continues if the combination does not exist.
148 --
149 -- Post Failure:
150 -- An application error is raised if the combination already exists.
151 --
152 -- {End Of Comments}
153 -- ----------------------------------------------------------------------------
154 Procedure chk_scorecard_person_unique
155 (p_scorecard_id IN number
156 ,p_person_id IN number
157 );
158 --
159 -- ----------------------------------------------------------------------------
160 -- |---------------------------< insert_validate >----------------------------|
161 -- ----------------------------------------------------------------------------
162 -- {Start of comments}
163 --
164 -- Description:
165 -- This procedure controls the execution of all insert business rules
166 -- validation.
167 --
168 -- Prerequisites:
169 -- This private procedure is called from ins procedure.
170 --
171 -- In Parameters:
172 -- A Pl/Sql record structure.
173 --
174 -- Post Success:
175 -- Processing continues.
176 --
177 -- Post Failure:
178 -- If a business rules fails the error will not be handled by this procedure
179 -- unless explicity coded.
180 --
181 -- Developer Implementation Notes:
182 -- For insert, your business rules should be executed from this procedure
183 -- and should ideally (unless really necessary) just be straight procedure
184 -- or function calls. Try and avoid using conditional branching logic.
185 --
186 -- Access Status:
187 -- Internal Row Handler Use Only.
188 --
189 -- {End of comments}
190 -- ----------------------------------------------------------------------------
191 Procedure insert_validate
192 (p_rec in per_psh_shd.g_rec_type
193 );
194 --
195 -- ----------------------------------------------------------------------------
196 -- |---------------------------< update_validate >----------------------------|
197 -- ----------------------------------------------------------------------------
198 -- {Start Of Comments}
199 --
200 -- Description:
201 -- This procedure controls the execution of all update business rules
202 -- validation.
203 --
204 -- Prerequisites:
205 -- This private procedure is called from upd procedure.
206 --
207 -- In Parameters:
208 -- A Pl/Sql record structure.
209 --
210 -- Post Success:
211 -- Processing continues.
212 --
213 -- Post Failure:
214 -- If a business rules fails the error will not be handled by this procedure
215 -- unless explicity coded.
216 --
217 -- Access Status:
218 -- Internal Row Handler Use Only.
219 --
220 -- {End Of Comments}
221 -- ----------------------------------------------------------------------------
222 Procedure update_validate
223 (p_rec in per_psh_shd.g_rec_type
224 );
225 --
226 -- ----------------------------------------------------------------------------
227 -- |---------------------------< delete_validate >----------------------------|
228 -- ----------------------------------------------------------------------------
229 -- {Start Of Comments}
230 --
231 -- Description:
232 -- This procedure controls the execution of all delete business rules
233 -- validation.
234 --
235 -- Prerequisites:
236 -- This private procedure is called from del procedure.
237 --
238 -- In Parameters:
239 -- A Pl/Sql record structure.
240 --
241 -- Post Success:
242 -- Processing continues.
243 --
244 -- Post Failure:
245 -- If a business rules fails the error will not be handled by this procedure
246 -- unless explicity coded.
247 --
248 -- Developer Implementation Notes:
249 -- For delete, your business rules should be executed from this procedure
250 -- and should ideally (unless really necessary) just be straight procedure
251 -- or function calls. Try and avoid using conditional branching logic.
252 --
253 -- Access Status:
254 -- Internal Row Handler Use Only.
255 --
256 -- {End Of Comments}
257 -- ----------------------------------------------------------------------------
258 Procedure delete_validate
259 (p_rec in per_psh_shd.g_rec_type
260 );
261 --
262 end per_psh_bus;