1 Package per_osv_bus as
2 /* $Header: peosvrhi.pkh 120.0 2005/05/31 12:38:25 appldev noship $ */
3
4 --
5 -- ---------------------------------------------------------------------------
6 -- |----------------------< set_security_group_id >--------------------------|
7 -- ---------------------------------------------------------------------------
8
9 Procedure get_business_group_id
10 (p_organization_structure_id in number
11 ,p_business_group_id out nocopy number);
12
13 --
14 -- ---------------------------------------------------------------------------
15 -- |----------------------< set_security_group_id >--------------------------|
16 -- ---------------------------------------------------------------------------
17 -- {Start Of Comments}
18 --
19 -- Description:
20 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
21 -- group context.
22 -- It is only valid to call this procedure when the primary key
23 -- is within a buisiness group context.
24 --
25 -- Prerequisites:
26 -- The primary key identified by p_org_structure_version_id
27 -- already exists.
28 --
29 -- In Arguments:
30 -- p_org_structure_version_id
31 --
32 --
33 -- Post Success:
34 -- The security_group_id will be set in CLIENT_INFO.
35 --
36 -- Post Failure:
37 -- An error is raised if the value does not exist.
38 -- An error is also raised when the primary key data is outside
39 -- of a buisiness group context.
40 --
41 -- Access Status:
42 -- Internal Development Use Only.
43 --
44 -- {End Of Comments}
45 -- ---------------------------------------------------------------------------
46 procedure set_security_group_id
47 (p_org_structure_version_id in number
48 );
49 --
50 --
51 -- ---------------------------------------------------------------------------
52 -- |---------------------< return_legislation_code >-------------------------|
53 -- ---------------------------------------------------------------------------
54 -- {Start Of Comments}
55 --
56 -- Description:
57 -- Return the legislation code for a specific primary key value
58 --
59 -- Prerequisites:
60 -- The primary key identified by p_org_structure_version_id
61 -- already exists.
62 --
63 -- In Arguments:
64 -- p_org_structure_version_id
65 --
66 --
67 -- Post Success:
68 -- The business group's legislation code will be returned.
69 --
70 -- Post Failure:
71 -- An error is raised if the value does not exist.
72 --
73 -- Access Status:
74 -- Internal Development Use Only.
75 --
76 -- {End Of Comments}
77 -- ---------------------------------------------------------------------------
78 FUNCTION return_legislation_code
79 (p_org_structure_version_id in number
80 ) RETURN varchar2;
81 --
82 --
83 -- ----------------------------------------------------------------------------
84 -- |---------------------------< insert_validate >----------------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start of comments}
87 --
88 -- Description:
89 -- This procedure controls the execution of all insert business rules
90 -- validation.
91 --
92 -- Prerequisites:
93 -- This private procedure is called from ins procedure.
94 --
95 -- In Parameters:
96 -- A Pl/Sql record structure.
97 --
98 -- Post Success:
99 -- Processing continues.
100 --
101 -- Post Failure:
102 -- If a business rules fails the error will not be handled by this procedure
103 -- unless explicity coded.
104 --
105 -- Developer Implementation Notes:
106 -- For insert, your business rules should be executed from this procedure
107 -- and should ideally (unless really necessary) just be straight procedure
108 -- or function calls. Try and avoid using conditional branching logic.
109 --
110 -- Access Status:
111 -- Internal Row Handler Use Only.
112 --
113 -- {End of comments}
114 -- ----------------------------------------------------------------------------
115 Procedure insert_validate
116 (p_effective_date in date
117 ,p_rec in per_osv_shd.g_rec_type
118 ,p_gap_warning out nocopy boolean);
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_effective_date in date
149 ,p_rec in per_osv_shd.g_rec_type
150 ,p_gap_warning out nocopy boolean);
151 --
152 -- ----------------------------------------------------------------------------
153 -- |---------------------------< delete_validate >----------------------------|
154 -- ----------------------------------------------------------------------------
155 -- {Start Of Comments}
156 --
157 -- Description:
158 -- This procedure controls the execution of all delete business rules
159 -- validation.
160 --
161 -- Prerequisites:
162 -- This private procedure is called from del procedure.
163 --
164 -- In Parameters:
165 -- A Pl/Sql record structure.
166 --
167 -- Post Success:
168 -- Processing continues.
169 --
170 -- Post Failure:
171 -- If a business rules fails the error will not be handled by this procedure
172 -- unless explicity coded.
173 --
174 -- Developer Implementation Notes:
175 -- For delete, your business rules should be executed from this procedure
176 -- and should ideally (unless really necessary) just be straight procedure
177 -- or function calls. Try and avoid using conditional branching logic.
178 --
179 -- Access Status:
180 -- Internal Row Handler Use Only.
181 --
182 -- {End Of Comments}
183 -- ----------------------------------------------------------------------------
184 Procedure delete_validate
185 (p_rec in per_osv_shd.g_rec_type
186 );
187 --
188 end per_osv_bus;