1 Package irc_iof_bus AUTHID CURRENT_USER as
2 /* $Header: iriofrhi.pkh 120.2 2011/01/24 12:14:46 amikukum ship $ */
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_offer_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_offer_id
19 --
20 --
21 -- Post Success:
22 -- The security_group_id will be set in CLIENT_INFO.
23 --
24 -- Post Failure:
25 -- An error is raised if the value does not exist.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 -- ---------------------------------------------------------------------------
32 procedure set_security_group_id
33 (p_offer_id in number
34 ,p_associated_column1 in varchar2 default null
35 );
36 --
37 --
38 -- ---------------------------------------------------------------------------
39 -- |---------------------< return_legislation_code >-------------------------|
40 -- ---------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- Return the legislation code for a specific primary key value
45 --
46 -- Prerequisites:
47 -- The primary key identified by p_offer_id
48 -- already exists.
49 --
50 -- In Arguments:
51 -- p_offer_id
52 --
53 --
54 -- Post Success:
55 -- The business group's legislation code will be returned.
56 --
57 -- Post Failure:
58 -- An error is raised if the value does not exist.
59 --
60 -- Access Status:
61 -- Internal Development Use Only.
62 --
63 -- {End Of Comments}
64 -- ---------------------------------------------------------------------------
65 FUNCTION return_legislation_code
66 (p_offer_id in number
67 ) RETURN varchar2;
68 --
69 --
70 -- ----------------------------------------------------------------------------
71 -- |---------------------< chk_multiple_fields_updated >----------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 -- This procedure ensures that not more than one field has been updated in the
77 -- offer record.
78 --
79 -- Pre Conditions:
80 -- None
81 --
82 -- In Arguments:
83 -- All the IRC_OFFERS table fields except object_version_number and respondent_id
84 --
85 -- Post Success:
86 -- If only one field has been updated, p_mutiple_fields_updated will be set to
87 -- 'false'. If multiple fields have been updated, p_mutiple_fields_updated will be
88 -- set to 'true'.
89 --
90 -- Post Failure:
91 -- None
92 --
93 -- Access Status:
94 -- Internal Development Use Only.
95 --
96 -- {End Of Comments}
97 -- ----------------------------------------------------------------------------
98 Procedure chk_multiple_fields_updated
99 ( p_offer_id in number
100 ,p_offer_status in varchar2 default null
101 ,p_discretionary_job_title in varchar2 default null
102 ,p_offer_extended_method in varchar2 default null
103 ,p_expiry_date in date default null
104 ,p_proposed_start_date in date default null
105 ,p_offer_letter_tracking_code in varchar2 default null
106 ,p_offer_postal_service in varchar2 default null
107 ,p_offer_shipping_date in date default null
108 ,p_applicant_assignment_id in number default null
109 ,p_offer_assignment_id in number default null
110 ,p_address_id in number default null
111 ,p_template_id in number default null
112 ,p_offer_letter_file_type in varchar2 default null
113 ,p_offer_letter_file_name in varchar2 default null
114 ,p_attribute_category in varchar2 default null
115 ,p_attribute1 in varchar2 default null
116 ,p_attribute2 in varchar2 default null
117 ,p_attribute3 in varchar2 default null
118 ,p_attribute4 in varchar2 default null
119 ,p_attribute5 in varchar2 default null
120 ,p_attribute6 in varchar2 default null
121 ,p_attribute7 in varchar2 default null
122 ,p_attribute8 in varchar2 default null
123 ,p_attribute9 in varchar2 default null
124 ,p_attribute10 in varchar2 default null
125 ,p_attribute11 in varchar2 default null
126 ,p_attribute12 in varchar2 default null
127 ,p_attribute13 in varchar2 default null
128 ,p_attribute14 in varchar2 default null
129 ,p_attribute15 in varchar2 default null
130 ,p_attribute16 in varchar2 default null
131 ,p_attribute17 in varchar2 default null
132 ,p_attribute18 in varchar2 default null
133 ,p_attribute19 in varchar2 default null
134 ,p_attribute20 in varchar2 default null
135 ,p_attribute21 in varchar2 default null
136 ,p_attribute22 in varchar2 default null
137 ,p_attribute23 in varchar2 default null
138 ,p_attribute24 in varchar2 default null
139 ,p_attribute25 in varchar2 default null
140 ,p_attribute26 in varchar2 default null
141 ,p_attribute27 in varchar2 default null
142 ,p_attribute28 in varchar2 default null
143 ,p_attribute29 in varchar2 default null
144 ,p_attribute30 in varchar2 default null
145 ,p_mutiple_fields_updated out nocopy boolean
146 );
147 --
148 -- ----------------------------------------------------------------------------
149 -- |---------------------------< insert_validate >----------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start of comments}
152 --
153 -- Description:
154 -- This procedure controls the execution of all insert business rules
155 -- validation.
156 --
157 -- Prerequisites:
158 -- This private procedure is called from ins procedure.
159 --
160 -- In Parameters:
161 -- A Pl/Sql record structure.
162 --
163 -- Post Success:
164 -- Processing continues.
165 --
166 -- Post Failure:
167 -- If a business rules fails the error will not be handled by this procedure
168 -- unless explicity coded.
169 --
170 -- Developer Implementation Notes:
171 -- For insert, your business rules should be executed from this procedure
172 -- and should ideally (unless really necessary) just be straight procedure
173 -- or function calls. Try and avoid using conditional branching logic.
174 --
175 -- Access Status:
176 -- Internal Row Handler Use Only.
177 --
178 -- {End of comments}
179 -- ----------------------------------------------------------------------------
180 Procedure insert_validate
181 (p_effective_date in date
182 ,p_rec in out nocopy irc_iof_shd.g_rec_type
183 );
184 --
185 -- ----------------------------------------------------------------------------
186 -- |---------------------------< update_validate >----------------------------|
187 -- ----------------------------------------------------------------------------
188 -- {Start Of Comments}
189 --
190 -- Description:
191 -- This procedure controls the execution of all update business rules
192 -- validation.
193 --
194 -- Prerequisites:
195 -- This private procedure is called from upd procedure.
196 --
197 -- In Parameters:
198 -- A Pl/Sql record structure.
199 --
200 -- Post Success:
201 -- Processing continues.
202 --
203 -- Post Failure:
204 -- If a business rules fails the error will not be handled by this procedure
205 -- unless explicity coded.
206 --
207 -- Access Status:
208 -- Internal Row Handler Use Only.
209 --
210 -- {End Of Comments}
211 -- ----------------------------------------------------------------------------
212 Procedure update_validate
213 (p_effective_date in date
214 ,p_rec in out nocopy irc_iof_shd.g_rec_type
215 );
216 --
217 -- ----------------------------------------------------------------------------
218 -- |---------------------------< delete_validate >----------------------------|
219 -- ----------------------------------------------------------------------------
220 -- {Start Of Comments}
221 --
222 -- Description:
223 -- This procedure controls the execution of all delete business rules
224 -- validation.
225 --
226 -- Prerequisites:
227 -- This private procedure is called from del procedure.
228 --
229 -- In Parameters:
230 -- A Pl/Sql record structure.
231 --
232 -- Post Success:
233 -- Processing continues.
234 --
235 -- Post Failure:
236 -- If a business rules fails the error will not be handled by this procedure
237 -- unless explicity coded.
238 --
239 -- Developer Implementation Notes:
240 -- For delete, your business rules should be executed from this procedure
241 -- and should ideally (unless really necessary) just be straight procedure
242 -- or function calls. Try and avoid using conditional branching logic.
243 --
244 -- Access Status:
245 -- Internal Row Handler Use Only.
246 --
247 -- {End Of Comments}
248 -- ----------------------------------------------------------------------------
249 Procedure delete_validate
250 (p_rec in irc_iof_shd.g_rec_type
251 );
252 --
253 end irc_iof_bus;