1 Package per_obj_bus AUTHID CURRENT_USER as
2 /* $Header: peobjrhi.pkh 120.4.12010000.1 2008/07/28 05:04:18 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 -- The following two global variables are only to be
9 -- used by the return_legislation_code function.
10 --
11 g_legislation_code varchar2(150) default null;
12 g_objective_id number default null;
13 --
14 -- ----------------------------------------------------------------------------
15 -- |------------------------< Externalized chk_ procedures >------------------|
16 -- ----------------------------------------------------------------------------
17 -- ----------------------------------------------------------------------------
18 -- |------------------------< chk_appraisal >---------------------------------|
19 -- ----------------------------------------------------------------------------
20 -- {Start of Comments}
21 -- see body: must always be checked api_updating or not
22 --
23 -- ACCESS STATUS
24 -- Internal HR Development Use Only
25 --
26 -- {End of Comments}
27 -- ----------------------------------------------------------------------------
28 procedure chk_appraisal
29 (p_appraisal_id in per_objectives.appraisal_id%TYPE
30 ,p_business_group_id in per_objectives.business_group_id%TYPE
31 );
32 -- ----------------------------------------------------------------------------
33 -- |------------------------< chk_owned_by_person >---------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start of Comments}
36 -- see body: must always be checked api_updating or not
37 --
38 -- ACCESS STATUS
39 -- Internal HR Development Use Only
40 --
41 -- {End of Comments}
42 -- ----------------------------------------------------------------------------
43 procedure chk_owned_by_person
44 (p_owning_person_id in per_objectives.owning_person_id%TYPE
45 ,p_business_group_id in per_objectives.business_group_id%TYPE
46 ,p_appraisal_id in per_objectives.appraisal_id%TYPE
47 ,p_effective_date in date
48 );
49 -- ----------------------------------------------------------------------------
50 -- |---------------------------< insert_validate >----------------------------|
51 -- ----------------------------------------------------------------------------
52 -- {Start Of Comments}
53 --
54 -- Description:
55 -- This procedure controls the execution of all insert business rules
56 -- validation.
57 --
58 -- Pre Conditions:
59 -- This private procedure is called from ins procedure.
60 --
61 -- In Parameters:
62 -- A Pl/Sql record structre.
63 --
64 -- Post Success:
65 -- Processing continues.
66 --
67 -- Post Failure:
68 -- If a business rules fails the error will not be handled by this procedure
69 -- unless explicity coded.
70 --
71 -- Developer Implementation Notes:
72 -- For insert, your business rules should be executed from this procedure and
73 -- should ideally (unless really necessary) just be straight procedure or
74 -- function calls. Try and avoid using conditional branching logic.
75 --
76 -- Access Status:
77 -- Internal Table Handler Use Only.
78 --
79 -- {End Of Comments}
80 -- ----------------------------------------------------------------------------
81 Procedure insert_validate(p_rec in per_obj_shd.g_rec_type
82 ,p_effective_date in date
83 ,p_weighting_over_100_warning out nocopy boolean
84 ,p_weighting_appraisal_warning out nocopy boolean
85 );
86 --
87 -- ----------------------------------------------------------------------------
88 -- |---------------------------< update_validate >----------------------------|
89 -- ----------------------------------------------------------------------------
90 -- {Start Of Comments}
91 --
92 -- Description:
93 -- This procedure controls the execution of all update business rules
94 -- validation.
95 --
96 -- Pre Conditions:
97 -- This private procedure is called from upd procedure.
98 --
99 -- In Parameters:
100 -- A Pl/Sql record structre.
101 --
102 -- Post Success:
103 -- Processing continues.
104 --
105 -- Post Failure:
106 -- If a business rules fails the error will not be handled by this procedure
107 -- unless explicity coded.
108 --
109 -- Developer Implementation Notes:
110 -- For update, your business rules should be executed from this procedure and
111 -- should ideally (unless really necessary) just be straight procedure or
112 -- function calls. Try and avoid using conditional branching logic.
113 --
114 -- Access Status:
115 -- Internal Table Handler Use Only.
116 --
117 -- {End Of Comments}
118 -- ----------------------------------------------------------------------------
119 Procedure update_validate(p_rec in per_obj_shd.g_rec_type
120 ,p_effective_date in date
121 ,p_weighting_over_100_warning out nocopy boolean
122 ,p_weighting_appraisal_warning out nocopy boolean
123 );
124 --
125 -- ----------------------------------------------------------------------------
126 -- |---------------------------< delete_validate >----------------------------|
127 -- ----------------------------------------------------------------------------
128 -- {Start Of Comments}
129 --
130 -- Description:
131 -- This procedure controls the execution of all delete business rules
132 -- validation.
133 --
134 -- Pre Conditions:
135 -- This private procedure is called from del procedure.
136 --
137 -- In Parameters:
138 -- A Pl/Sql record structre.
139 --
140 -- Post Success:
141 -- Processing continues.
142 --
143 -- Post Failure:
144 -- If a business rules fails the error will not be handled by this procedure
145 -- unless explicity coded.
146 --
147 -- Developer Implementation Notes:
148 -- For delete, your business rules should be executed from this procedure and
149 -- should ideally (unless really necessary) just be straight procedure or
150 -- function calls. Try and avoid using conditional branching logic.
151 --
152 -- Access Status:
153 -- Internal Table Handler Use Only.
154 --
155 -- {End Of Comments}
156 -- ----------------------------------------------------------------------------
157 Procedure delete_validate(p_rec in per_obj_shd.g_rec_type);
158 --
159 --
160 -- ----------------------------------------------------------------------------
161 -- |-----------------------< return_legislation_code >-------------------------|
162 -- ----------------------------------------------------------------------------
163 -- {Start Of Comments}
164 --
165 -- Description:
166 -- This function gets the legislation code
167 --
168 -- Pre Conditions:
169 -- This private procedure will be called from the user hook procedures.
170 --
171 -- In Parameters:
172 -- the primary key of the table (per_objectives)
173 --
174 -- Post Success:
175 -- Processing continues.
176 --
177 -- Post Failure:
178 -- If the legislation code is not found then it errors out
179 --
180 -- Developer Implementation Notes:
181 --
182 -- Access Status:
183 -- Internal Table Handler Use Only.
184 --
185 -- {End Of Comments}
186 -- ----------------------------------------------------------------------------
187 --
188 function return_legislation_code
189 (p_objective_id in per_objectives.objective_id%TYPE
190 ) return varchar2;
191 --
192 end per_obj_bus;
[Home] [Help]