66: begin
67: hr_utility.set_location('Entering:'|| l_proc, 5);
68: -- check to see if the attribute is changing. we only add
69: -- to the pl/sql table structures when values are changing.
70: if nvl(p_new_value, hr_api.g_varchar2) =
71: nvl(p_current_value, hr_api.g_varchar2) then
72: -- the new value is the same as the current value therefore
73: -- we cannot be updating the attribute. set the return value
74: -- to the current value.
67: hr_utility.set_location('Entering:'|| l_proc, 5);
68: -- check to see if the attribute is changing. we only add
69: -- to the pl/sql table structures when values are changing.
70: if nvl(p_new_value, hr_api.g_varchar2) =
71: nvl(p_current_value, hr_api.g_varchar2) then
72: -- the new value is the same as the current value therefore
73: -- we cannot be updating the attribute. set the return value
74: -- to the current value.
75: l_current_value := p_current_value;
176: hr_utility.set_location('Entering:'|| l_proc, 5);
177: -- if on first row add the parameter
178: if p_effective_date_row then
179: -- determine if the user value is using a system default
180: if p_new_value = hr_api.g_varchar2 then
181: -- value is using a system default, set to the current row value
182: l_new_value := p_current_value;
183: else
184: -- value is not using a system default
199: ,p_changing => l_changing
200: ,p_index => l_index);
201: --
202: if l_changing then
203: if nvl(p_current_value, hr_api.g_varchar2) =
204: nvl(g_old_value(l_index), hr_api.g_varchar2) and
205: g_parameter_status(l_index) then
206: l_current_value := g_new_value(l_index);
207: else
200: ,p_index => l_index);
201: --
202: if l_changing then
203: if nvl(p_current_value, hr_api.g_varchar2) =
204: nvl(g_old_value(l_index), hr_api.g_varchar2) and
205: g_parameter_status(l_index) then
206: l_current_value := g_new_value(l_index);
207: else
208: g_parameter_status(l_index) := false;
233: hr_utility.set_location('Entering:'|| l_proc, 5);
234: --
235: if p_effective_date_row then
236: -- determine if the user value is using a system default
237: if l_new_value = hr_api.g_number then
238: -- value is using a system default, set to the current row value
239: l_new_value := p_current_value;
240: end if;
241: end if;
266: hr_utility.set_location('Entering:'|| l_proc, 5);
267: --
268: if p_effective_date_row then
269: -- determine if the user value is using a system default
270: if trunc(p_new_value) = hr_api.g_date then
271: -- value is using a system default, set to the current row value
272: l_new_value := trunc(p_current_value);
273: end if;
274: end if;