1 Package per_sos_bus as
2 /* $Header: pesosrhi.pkh 120.0 2005/05/31 21:24:52 appldev 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_solution_id
15 -- p_solution_set_name
16 -- p_user_id
17 -- already exists.
18 --
19 -- In Arguments:
20 -- p_solution_id
21 -- p_solution_set_name
22 -- p_user_id
23 --
24 --
25 -- Post Success:
26 -- The security_group_id will be set in CLIENT_INFO.
27 --
28 -- Post Failure:
29 -- An error is raised if the value does not exist.
30 --
31 -- Access Status:
32 -- Internal Development Use Only.
33 --
34 -- {End Of Comments}
35 -- ---------------------------------------------------------------------------
36 procedure set_security_group_id
37 (p_solution_id in number
38 ,p_solution_set_name in varchar2
39 ,p_user_id in number
40 ,p_associated_column1 in varchar2 default null
41 ,p_associated_column2 in varchar2 default null
42 ,p_associated_column3 in varchar2 default null
43 );
44 --
45 --
46 -- ---------------------------------------------------------------------------
47 -- |---------------------< return_legislation_code >-------------------------|
48 -- ---------------------------------------------------------------------------
49 -- {Start Of Comments}
50 --
51 -- Description:
52 -- Return the legislation code for a specific primary key value
53 --
54 -- Prerequisites:
55 -- The primary key identified by p_solution_id
56 -- p_solution_set_name
57 -- p_user_id
58 -- already exists.
59 --
60 -- In Arguments:
61 -- p_solution_id
62 -- p_solution_set_name
63 -- p_user_id
64 --
65 --
66 -- Post Success:
67 -- The business group's legislation code will be returned.
68 --
69 -- Post Failure:
70 -- An error is raised if the value does not exist.
71 --
72 -- Access Status:
73 -- Internal Development Use Only.
74 --
75 -- {End Of Comments}
76 -- ---------------------------------------------------------------------------
77 FUNCTION return_legislation_code
78 (p_solution_id in number
79 ,p_solution_set_name in varchar2
80 ,p_user_id in number
81 ) RETURN varchar2;
82 --
83 --
84 -- ----------------------------------------------------------------------------
85 -- |---------------------------< insert_validate >----------------------------|
86 -- ----------------------------------------------------------------------------
87 -- {Start of comments}
88 --
89 -- Description:
90 -- This procedure controls the execution of all insert business rules
91 -- validation.
92 --
93 -- Prerequisites:
94 -- This private procedure is called from ins procedure.
95 --
96 -- In Parameters:
97 -- A Pl/Sql record structure.
98 --
99 -- Post Success:
100 -- Processing continues.
101 --
102 -- Post Failure:
103 -- If a business rules fails the error will not be handled by this procedure
104 -- unless explicity coded.
105 --
106 -- Developer Implementation Notes:
107 -- For insert, your business rules should be executed from this procedure
108 -- and should ideally (unless really necessary) just be straight procedure
109 -- or function calls. Try and avoid using conditional branching logic.
110 --
111 -- Access Status:
112 -- Internal Row Handler Use Only.
113 --
114 -- {End of comments}
115 -- ----------------------------------------------------------------------------
116 Procedure insert_validate
117 (p_rec in per_sos_shd.g_rec_type
118 );
119 --
120 -- ----------------------------------------------------------------------------
121 -- |---------------------------< update_validate >----------------------------|
122 -- ----------------------------------------------------------------------------
123 -- {Start Of Comments}
124 --
125 -- Description:
126 -- This procedure controls the execution of all update business rules
127 -- validation.
128 --
129 -- Prerequisites:
130 -- This private procedure is called from upd procedure.
131 --
132 -- In Parameters:
133 -- A Pl/Sql record structure.
134 --
135 -- Post Success:
136 -- Processing continues.
137 --
138 -- Post Failure:
139 -- If a business rules fails the error will not be handled by this procedure
140 -- unless explicity coded.
141 --
142 -- Access Status:
143 -- Internal Row Handler Use Only.
144 --
145 -- {End Of Comments}
146 -- ----------------------------------------------------------------------------
147 Procedure update_validate
148 (p_rec in per_sos_shd.g_rec_type
149 );
150 --
151 -- ----------------------------------------------------------------------------
152 -- |---------------------------< delete_validate >----------------------------|
153 -- ----------------------------------------------------------------------------
154 -- {Start Of Comments}
155 --
156 -- Description:
157 -- This procedure controls the execution of all delete business rules
158 -- validation.
159 --
160 -- Prerequisites:
161 -- This private procedure is called from del procedure.
162 --
163 -- In Parameters:
164 -- A Pl/Sql record structure.
165 --
166 -- Post Success:
167 -- Processing continues.
168 --
169 -- Post Failure:
170 -- If a business rules fails the error will not be handled by this procedure
171 -- unless explicity coded.
172 --
173 -- Developer Implementation Notes:
174 -- For delete, your business rules should be executed from this procedure
175 -- and should ideally (unless really necessary) just be straight procedure
176 -- or function calls. Try and avoid using conditional branching logic.
177 --
178 -- Access Status:
179 -- Internal Row Handler Use Only.
180 --
181 -- {End Of Comments}
182 -- ----------------------------------------------------------------------------
183 Procedure delete_validate
184 (p_rec in per_sos_shd.g_rec_type
185 );
186 --
187 end per_sos_bus;