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