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