DBA Data[Home] [Help]

APPS.HR_DT_ATTRIBUTE_SUPPORT dependencies on HR_UTILITY

Line 67: hr_utility.set_location('Entering:'|| l_proc, 5);

63: l_proc varchar2(72) := g_package||'add_parameter';
64: l_current_value varchar2(32767);
65: --
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

Line 93: hr_utility.set_location(' Leaving:'|| l_proc, 10);

89: -- increment the index counter
90: g_index := g_index + 1;
91: end if;
92: return(l_current_value);
93: hr_utility.set_location(' Leaving:'|| l_proc, 10);
94: end add_parameter;
95: -- ----------------------------------------------------------------------------
96: -- |-------------------------< get_parameter_index >--------------------------|
97: -- ----------------------------------------------------------------------------

Line 135: hr_utility.set_location('Entering:'|| l_proc, 5);

131: l_found_name boolean := false;
132: --
133: begin
134: --
135: hr_utility.set_location('Entering:'|| l_proc, 5);
136: -- ensure at least one element exists
137: if g_index > 0 then
138: -- determine index position of the parameter
139: for i in 0..(g_index - 1) loop

Line 157: hr_utility.set_location(' Leaving:'|| l_proc, 10);

153: -- parameter does not exist
154: p_changing := false;
155: p_index := null;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 10);
158: end is_parameter_changing;
159: -- ----------------------------------------------------------------------------
160: -- |------------------------< get_parameter_char >----------------------------|
161: -- ----------------------------------------------------------------------------

Line 176: hr_utility.set_location('Entering:'|| l_proc, 5);

172: l_changing boolean;
173: --
174: begin
175: --
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

Line 217: hr_utility.set_location(' Leaving:'|| l_proc, 10);

213: l_current_value := p_current_value;
214: end if;
215: end if;
216: return(l_current_value);
217: hr_utility.set_location(' Leaving:'|| l_proc, 10);
218: end get_parameter_char;
219: -- ----------------------------------------------------------------------------
220: -- |----------------------< get_parameter_number >----------------------------|
221: -- ----------------------------------------------------------------------------

Line 233: hr_utility.set_location('Entering:'|| l_proc, 5);

229: l_new_value number := p_new_value;
230: --
231: begin
232: --
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

Line 249: hr_utility.set_location(' Leaving:'|| l_proc, 10);

245: ,p_parameter_name => p_parameter_name
246: ,p_new_value => to_char(l_new_value)
247: ,p_current_value => p_current_value)));
248: --
249: hr_utility.set_location(' Leaving:'|| l_proc, 10);
250: end get_parameter_number;
251: -- ----------------------------------------------------------------------------
252: -- |-------------------------< get_parameter_date >---------------------------|
253: -- ----------------------------------------------------------------------------

Line 266: hr_utility.set_location('Entering:'|| l_proc, 5);

262: l_current_value varchar2(30) := to_char(trunc(p_current_value), g_date_format);
263: --
264: begin
265: --
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

Line 282: hr_utility.set_location(' Leaving:'|| l_proc, 10);

278: ,p_parameter_name => p_parameter_name
279: ,p_new_value => to_char(l_new_value, g_date_format)
280: ,p_current_value => l_current_value), g_date_format));
281: --
282: hr_utility.set_location(' Leaving:'|| l_proc, 10);
283: end get_parameter_date;
284: -- ----------------------------------------------------------------------------
285: -- |-----------------------< is_current_row_changing >------------------------|
286: -- ----------------------------------------------------------------------------

Line 295: hr_utility.set_location('Entering:'|| l_proc, 5);

291: l_found boolean := false;
292: --
293: begin
294: --
295: hr_utility.set_location('Entering:'|| l_proc, 5);
296: -- only process if at least one element has been set
297: if g_index > 0 then
298: -- determine if at least one parameter change exists
299: for l_index in 0..(g_index - 1) loop

Line 306: hr_utility.set_location(' Leaving:'|| l_proc, 10);

302: exit;
303: end if;
304: end loop;
305: end if;
306: hr_utility.set_location(' Leaving:'|| l_proc, 10);
307: return(l_found);
308: end is_current_row_changing;
309: -- ----------------------------------------------------------------------------
310: -- |---------------------< reset_parameter_statuses >-------------------------|

Line 318: hr_utility.set_location('Entering:'|| l_proc, 5);

314: l_proc varchar2(72) := g_package||'reset_parameter_statuses';
315: l_index binary_integer;
316: --
317: begin
318: hr_utility.set_location('Entering:'|| l_proc, 5);
319: -- only process if at least one element has been set
320: if g_index > 0 then
321: for l_index in 0..(g_index - 1) loop
322: g_parameter_status(l_index) := true;

Line 325: hr_utility.set_location(' Leaving:'|| l_proc, 10);

321: for l_index in 0..(g_index - 1) loop
322: g_parameter_status(l_index) := true;
323: end loop;
324: end if;
325: hr_utility.set_location(' Leaving:'|| l_proc, 10);
326: end reset_parameter_statuses;
327: --
328: end hr_dt_attribute_support;