DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY pay_jp_formula_function_pkg AS
2: /* $Header: pyjpffuc.pkb 120.0.12010000.2 2009/02/09 05:50:38 keyazawa ship $ */
3: --
4: c_package constant varchar2(30) := 'pay_jp_formula_function_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: /* ------------------------------------------------------------------------------------ --
8: -- GET_TABLE_VALUE_WITH_DEFAULT
9: -- return the value of specified user defined table

Line 268: hr_utility.set_location(l_proc,0);

264: --
265: begin
266: --
267: if g_debug then
268: hr_utility.set_location(l_proc,0);
269: end if;
270: --
271: -- normally not pass here.
272: if l_effective_date is null then

Line 291: hr_utility.set_location(l_proc,10);

287: --
288: end if;
289: --
290: if g_debug then
291: hr_utility.set_location(l_proc,10);
292: hr_utility.trace('l_effective_date : '||to_char(l_effective_date,'YYYY/MM/DD'));
293: end if;
294: --
295: if g_effective_date is not null

Line 292: hr_utility.trace('l_effective_date : '||to_char(l_effective_date,'YYYY/MM/DD'));

288: end if;
289: --
290: if g_debug then
291: hr_utility.set_location(l_proc,10);
292: hr_utility.trace('l_effective_date : '||to_char(l_effective_date,'YYYY/MM/DD'));
293: end if;
294: --
295: if g_effective_date is not null
296: and g_effective_date = l_effective_date then

Line 313: hr_utility.set_location(l_proc,20);

309: --
310: end loop loop_glb;
311: --
312: if g_debug then
313: hr_utility.set_location(l_proc,20);
314: hr_utility.trace('l_value : '||l_value);
315: end if;
316: --
317: else

Line 314: hr_utility.trace('l_value : '||l_value);

310: end loop loop_glb;
311: --
312: if g_debug then
313: hr_utility.set_location(l_proc,20);
314: hr_utility.trace('l_value : '||l_value);
315: end if;
316: --
317: else
318: --

Line 324: hr_utility.set_location(l_proc,30);

320: --
321: end if;
322: --
323: if g_debug then
324: hr_utility.set_location(l_proc,30);
325: end if;
326: --
327: if not l_skip then
328: --

Line 358: hr_utility.set_location(l_proc,40);

354: --
355: close csr_global_value;
356: --
357: if g_debug then
358: hr_utility.set_location(l_proc,40);
359: hr_utility.trace('g_glb_tbl.count : '||g_glb_tbl.count);
360: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_name : '||g_glb_tbl(g_glb_tbl.count).global_name);
361: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_value : '||g_glb_tbl(g_glb_tbl.count).global_value);
362: end if;

Line 359: hr_utility.trace('g_glb_tbl.count : '||g_glb_tbl.count);

355: close csr_global_value;
356: --
357: if g_debug then
358: hr_utility.set_location(l_proc,40);
359: hr_utility.trace('g_glb_tbl.count : '||g_glb_tbl.count);
360: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_name : '||g_glb_tbl(g_glb_tbl.count).global_name);
361: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_value : '||g_glb_tbl(g_glb_tbl.count).global_value);
362: end if;
363: --

Line 360: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_name : '||g_glb_tbl(g_glb_tbl.count).global_name);

356: --
357: if g_debug then
358: hr_utility.set_location(l_proc,40);
359: hr_utility.trace('g_glb_tbl.count : '||g_glb_tbl.count);
360: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_name : '||g_glb_tbl(g_glb_tbl.count).global_name);
361: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_value : '||g_glb_tbl(g_glb_tbl.count).global_value);
362: end if;
363: --
364: end if;

Line 361: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_value : '||g_glb_tbl(g_glb_tbl.count).global_value);

357: if g_debug then
358: hr_utility.set_location(l_proc,40);
359: hr_utility.trace('g_glb_tbl.count : '||g_glb_tbl.count);
360: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_name : '||g_glb_tbl(g_glb_tbl.count).global_name);
361: hr_utility.trace('g_glb_tbl(g_glb_tbl.count).global_value : '||g_glb_tbl(g_glb_tbl.count).global_value);
362: end if;
363: --
364: end if;
365: --

Line 367: hr_utility.trace('final l_value : '||l_value);

363: --
364: end if;
365: --
366: if g_debug then
367: hr_utility.trace('final l_value : '||l_value);
368: hr_utility.set_location(l_proc,1000);
369: end if;
370: --
371: return l_value;

Line 368: hr_utility.set_location(l_proc,1000);

364: end if;
365: --
366: if g_debug then
367: hr_utility.trace('final l_value : '||l_value);
368: hr_utility.set_location(l_proc,1000);
369: end if;
370: --
371: return l_value;
372: end get_global_value;