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
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
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
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
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
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: --
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: --
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;
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: --
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;
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: --
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;
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;