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