DBA Data[Home] [Help]

APPS.HR_DT_ATTRIBUTE_SUPPORT dependencies on HR_API

Line 70: if nvl(p_new_value, hr_api.g_varchar2) =

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.

Line 71: nvl(p_current_value, hr_api.g_varchar2) then

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;

Line 180: if p_new_value = hr_api.g_varchar2 then

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

Line 203: if nvl(p_current_value, hr_api.g_varchar2) =

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

Line 204: nvl(g_old_value(l_index), hr_api.g_varchar2) and

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;

Line 237: if l_new_value = hr_api.g_number then

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;

Line 270: if trunc(p_new_value) = hr_api.g_date then

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;