1 Package ben_xel_bus as
2 /* $Header: bexelrhi.pkh 120.1 2005/06/08 13:15:50 tjesumic 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 -- It is only valid to call this procedure when the primary key
13 -- is within a buisiness group context.
14 --
15 -- Prerequisites:
16 -- The primary key identified by p_ext_data_elmt_id
17 -- already exists.
18 --
19 -- In Arguments:
20 -- p_ext_data_elmt_id
21 --
22 --
23 -- Post Success:
24 -- The security_group_id will be set in CLIENT_INFO.
25 --
26 -- Post Failure:
27 -- An error is raised if the value does not exist.
28 -- An error is also raised when the primary key data is outside
29 -- of a buisiness group context.
30 --
31 -- Access Status:
32 -- Internal Development Use Only.
33 --
34 -- {End Of Comments}
35 -- ---------------------------------------------------------------------------
36 procedure set_security_group_id
37 (p_ext_data_elmt_id in number
38 );
39 --
40 --
41 --
42 Procedure chk_xml_name_format
43 ( p_xml_tag_name in out nocopy varchar2
44 ) ;
45
46 -- ---------------------------------------------------------------------------
47 -- |---------------------< return_legislation_code >-------------------------|
48 -- ---------------------------------------------------------------------------
49 --
50 -- Description:
51 -- Return the legislation code for a specific primary key value
52 --
53 -- Prerequisites:
54 -- The primary key identified by p_ext_data_elmt_id already exists.
55 --
56 -- In Arguments:
57 -- p_ext_data_elmt_id
58 --
59 -- Post Success:
60 -- If the value is found this function will return the values business
61 -- group legislation code.
62 --
63 -- Post Failure:
64 -- An error is raised if the value does not exist.
65 --
66 -- Access Status:
67 -- Internal Development Use Only.
68 --
69 function return_legislation_code
70 (p_ext_data_elmt_id in number) return varchar2;
71 --
72 --
73 -- ----------------------------------------------------------------------------
74 -- |---------------------------< insert_validate >----------------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start Of Comments}
77 --
78 -- Description:
79 -- This procedure controls the execution of all insert business rules
80 -- validation.
81 --
82 -- Prerequisites:
83 -- This private procedure is called from ins procedure.
84 --
85 -- In Parameters:
86 -- A Pl/Sql record structre.
87 --
88 -- Post Success:
89 -- Processing continues.
90 --
91 -- Post Failure:
92 -- If a business rules fails the error will not be handled by this procedure
93 -- unless explicity coded.
94 --
95 -- Developer Implementation Notes:
96 -- For insert, your business rules should be executed from this procedure and
97 -- should ideally (unless really necessary) just be straight procedure or
98 -- function calls. Try and avoid using conditional branching logic.
99 --
100 -- Access Status:
101 -- Internal Row Handler Use Only.
102 --
103 -- {End Of Comments}
104 -- ----------------------------------------------------------------------------
105 Procedure insert_validate(p_rec in ben_xel_shd.g_rec_type
106 ,p_effective_date in date);
107 --
108 -- ----------------------------------------------------------------------------
109 -- |---------------------------< update_validate >----------------------------|
110 -- ----------------------------------------------------------------------------
111 -- {Start Of Comments}
112 --
113 -- Description:
114 -- This procedure controls the execution of all update business rules
115 -- validation.
116 --
117 -- Prerequisites:
118 -- This private procedure is called from upd procedure.
119 --
120 -- In Parameters:
121 -- A Pl/Sql record structre.
122 --
123 -- Post Success:
124 -- Processing continues.
125 --
126 -- Post Failure:
127 -- If a business rules fails the error will not be handled by this procedure
128 -- unless explicity coded.
129 --
130 -- Developer Implementation Notes:
131 -- For update, your business rules should be executed from this procedure and
132 -- should ideally (unless really necessary) just be straight procedure or
133 -- function calls. Try and avoid using conditional branching logic.
134 --
135 -- Access Status:
136 -- Internal Row Handler Use Only.
137 --
138 -- {End Of Comments}
139 -- ----------------------------------------------------------------------------
140 Procedure update_validate(p_rec in ben_xel_shd.g_rec_type
141 ,p_effective_date in date);
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 structre.
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 and
167 -- should ideally (unless really necessary) just be straight procedure or
168 -- 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(p_rec in ben_xel_shd.g_rec_type
176 ,p_effective_date in date);
177 --
178 end ben_xel_bus;