1 Package ota_tsp_bus AUTHID CURRENT_USER as
2 /* $Header: ottsp01t.pkh 120.0 2005/05/29 07:54:17 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------< check_analysis_criteria_id >-----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure ensures that data has been entered in the
11 -- information field of the skills form
12 --
13 -- Pre Conditions:
14 -- This private procedure is called from insert_validate and
15 -- update_validate procedures.
16 --
17 -- In Arguments:
18 -- A PL/SQL number type.
19 --
20 -- Post Success:
21 -- Processing continues.
22 --
23 -- Post Failure:
24 -- The procedure raises an error and stops processing.
25 --
26 -- {End Of Comments}
27 ------------------------------------------------------------------------------
28 Procedure check_analysis_criteria_id (p_analysis_criteria_id in number);
29 --
30 -- ----------------------------------------------------------------------------
31 -- |---------------------------< insert_validate >----------------------------|
32 -- ----------------------------------------------------------------------------
33 -- {Start Of Comments}
34 --
35 -- Description:
36 -- This procedure controls the execution of all insert business rules
37 -- validation.
38 --
39 -- Pre Conditions:
40 -- This private procedure is called from ins procedure.
41 --
42 -- In Arguments:
43 -- A Pl/Sql record structre.
44 --
45 -- Post Success:
46 -- Processing continues.
47 --
48 -- Post Failure:
49 -- If a business rules fails the error will not be handled by this procedure
50 -- unless explicity coded.
51 --
52 -- Developer Implementation Notes:
53 -- For insert, your business rules should be coded within this procedure and
54 -- should ideally (unless really necessary) just be straight procedure or
55 -- function calls. Try and avoid using conditional branching logic.
56 --
57 -- Access Status:
58 -- Internal Development Use Only.
59 --
60 -- {End Of Comments}
61 -- ----------------------------------------------------------------------------
62 Procedure insert_validate(p_rec in ota_tsp_shd.g_rec_type);
63 --
64 -- ----------------------------------------------------------------------------
65 -- |---------------------------< update_validate >----------------------------|
66 -- ----------------------------------------------------------------------------
67 -- {Start Of Comments}
68 --
69 -- Description:
70 -- This procedure controls the execution of all update business rules
71 -- validation.
72 --
73 -- Pre Conditions:
74 -- This private procedure is called from upd procedure.
75 --
76 -- In Arguments:
77 -- A Pl/Sql record structre.
78 --
79 -- Post Success:
80 -- Processing continues.
81 --
82 -- Post Failure:
83 -- If a business rules fails the error will not be handled by this procedure
84 -- unless explicity coded.
85 --
86 -- Developer Implementation Notes:
87 -- For update, your business rules should be coded within this procedure and
88 -- should ideally (unless really necessary) just be straight procedure or
89 -- function calls. Try and avoid using conditional branching logic.
90 --
91 -- Access Status:
92 -- Internal Development Use Only.
93 --
94 -- {End Of Comments}
95 -- ----------------------------------------------------------------------------
96 Procedure update_validate(p_rec in ota_tsp_shd.g_rec_type);
97 --
98 -- ----------------------------------------------------------------------------
99 -- |---------------------------< delete_validate >----------------------------|
100 -- ----------------------------------------------------------------------------
101 -- {Start Of Comments}
102 --
103 -- Description:
104 -- This procedure controls the execution of all delete business rules
105 -- validation.
106 --
107 -- Pre Conditions:
108 -- This private procedure is called from del procedure.
109 --
110 -- In Arguments:
111 -- A Pl/Sql record structre.
112 --
113 -- Post Success:
114 -- Processing continues.
115 --
116 -- Post Failure:
117 -- If a business rules fails the error will not be handled by this procedure
118 -- unless explicity coded.
119 --
120 -- Developer Implementation Notes:
121 -- For delete, your business rules should be coded within this procedure and
122 -- should ideally (unless really necessary) just be straight procedure or
123 -- function calls. Try and avoid using conditional branching logic.
124 --
125 -- Access Status:
126 -- Internal Development Use Only.
127 --
128 -- {End Of Comments}
129 -- ----------------------------------------------------------------------------
130 Procedure delete_validate(p_rec in ota_tsp_shd.g_rec_type);
131 --
132 -- ---------------------------------------------------------------------------
133 -- |----------------------< set_security_group_id >--------------------------|
134 -- ---------------------------------------------------------------------------
135 -- {Start Of Comments}
136 --
137 -- Description:
138 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
139 -- group context.
140 --
141 -- Prerequisites:
142 -- The primary key identified by p_SKILL_PROVISION_ID
143 -- already exists.
144 --
145 -- In Arguments:
146 -- p_skill_provision_id
147 --
148 --
149 -- Post Success:
150 -- The security_group_id will be set in CLIENT_INFO.
151 --
152 -- Post Failure:
153 -- An error is raised if the value does not exist.
154 --
155 -- Access Status:
156 -- Internal Development Use Only.
157 --
158 -- {End Of Comments}
159 -- ---------------------------------------------------------------------------
160 procedure set_security_group_id
161 (p_skill_provision_id in number
162 ,p_associated_column1 in varchar2 default null
163 );
164
165 --
166 -- ----------------------------------------------------------------------------
167 -- |-----------------------< return_legislation_code >-------------------------|
168 -- ----------------------------------------------------------------------------
169 --
170 -- {Start Of Comments}
171 --
172 -- Description:
173 -- This function will be used by the user hooks. This will be used
174 -- of by the user hooks of ota_skill_provisions usiness process.
175 --
176 -- Pre Conditions:
177 -- This function will be called by the user hook packages.
178 --
179 -- In Arguments:
180 -- p_skill_provison_id
181 --
182 -- Post Success:
183 -- Processing continues.
184 --
185 -- Post Failure:
186 -- Errors out
187 --
188 -- Developer Implementation Notes:
189 --
190 -- Access Status:
191 -- Internal Development Use Only.
192 --
193 -- {End Of Comments}
194 --------------------------------------------------------------------------------
195 --
196
197 Function return_legislation_code
198 ( p_skill_provision_id in number
199 ) return varchar2;
200 end ota_tsp_bus;
[Home] [Help]