eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_AU_ROUTES dependencies on HR_UTILITY

Line 9: -- 20-Oct-2003 puchil 3198671 Made the calls to hr_utility as conditional.

5: -- All rights reserved
6:
7: -- Date Author Bug/CR Num Notes
8: -- -----------+--------+----------+-----------------------------------------
9: -- 20-Oct-2003 puchil 3198671 Made the calls to hr_utility as conditional.
10: -- 20-Oct-2003 puchil 3198671 Removed functions which were not
11: -- used after BRA implementation.
12: -- 18 Jun 2003 Ragovind 3004966 Peformance Fix. Added /*+RULE */ to route code
13: -- 24 Mar 2003 Kaverma 2856638 Modified cursor cur_asg_td and added dbdrv commands

Line 18: g_debug boolean := hr_utility.debug_enabled;

14: -- 18 Feb 2000 JTurner Fixed problem with date format in
15: -- get_fiscal_date function
16: -- 13-NOV-1999 sgoggin Created
17:
18: g_debug boolean := hr_utility.debug_enabled;
19: g_package varchar2(33) := 'hr_au_routes.';
20: g_fin_year_start constant varchar2(6) := '01-07-';
21: g_fbt_year_start constant varchar2(6) := '01-04-';
22: g_cal_year_start constant varchar2(6) := '01-01-';

Line 37: hr_utility.set_location('Entering: hr_au_routes.span_start',1);

33: l_start date;
34: --
35: begin
36: if g_debug then
37: hr_utility.set_location('Entering: hr_au_routes.span_start',1);
38: end if;
39: -- Get the year component of the input date
40: l_year := to_number(to_char(p_input_date,'yyyy'));
41: if g_debug then

Line 42: hr_utility.trace(' span_start: l_year='||to_char(l_year));

38: end if;
39: -- Get the year component of the input date
40: l_year := to_number(to_char(p_input_date,'yyyy'));
41: if g_debug then
42: hr_utility.trace(' span_start: l_year='||to_char(l_year));
43: hr_utility.trace(' span_start: p_frequency='||to_char(p_frequency));
44: hr_utility.trace(' span_start: p_start_dd_mm='||p_start_dd_mm);
45: hr_utility.trace(' span_start: p_input_date='||to_char(p_input_date,'DD-MON-YYYY'));
46: end if;

Line 43: hr_utility.trace(' span_start: p_frequency='||to_char(p_frequency));

39: -- Get the year component of the input date
40: l_year := to_number(to_char(p_input_date,'yyyy'));
41: if g_debug then
42: hr_utility.trace(' span_start: l_year='||to_char(l_year));
43: hr_utility.trace(' span_start: p_frequency='||to_char(p_frequency));
44: hr_utility.trace(' span_start: p_start_dd_mm='||p_start_dd_mm);
45: hr_utility.trace(' span_start: p_input_date='||to_char(p_input_date,'DD-MON-YYYY'));
46: end if;
47: --

Line 44: hr_utility.trace(' span_start: p_start_dd_mm='||p_start_dd_mm);

40: l_year := to_number(to_char(p_input_date,'yyyy'));
41: if g_debug then
42: hr_utility.trace(' span_start: l_year='||to_char(l_year));
43: hr_utility.trace(' span_start: p_frequency='||to_char(p_frequency));
44: hr_utility.trace(' span_start: p_start_dd_mm='||p_start_dd_mm);
45: hr_utility.trace(' span_start: p_input_date='||to_char(p_input_date,'DD-MON-YYYY'));
46: end if;
47: --
48: if p_input_date >= to_date(p_start_dd_mm||to_char(l_year),'dd-mm-yyyy') then

Line 45: hr_utility.trace(' span_start: p_input_date='||to_char(p_input_date,'DD-MON-YYYY'));

41: if g_debug then
42: hr_utility.trace(' span_start: l_year='||to_char(l_year));
43: hr_utility.trace(' span_start: p_frequency='||to_char(p_frequency));
44: hr_utility.trace(' span_start: p_start_dd_mm='||p_start_dd_mm);
45: hr_utility.trace(' span_start: p_input_date='||to_char(p_input_date,'DD-MON-YYYY'));
46: end if;
47: --
48: if p_input_date >= to_date(p_start_dd_mm||to_char(l_year),'dd-mm-yyyy') then
49: l_start := to_date(p_start_dd_mm||to_char(l_year),'dd-mm-yyyy');

Line 54: hr_utility.trace(' span_start: l_start='||to_char(l_year));

50: else
51: l_start := to_date(p_start_dd_mm||to_char(l_year -1),'dd-mm-yyyy');
52: end if;
53: if g_debug then
54: hr_utility.trace(' span_start: l_start='||to_char(l_year));
55: end if;
56: --
57: -- cater for weekly based frequency based on 52 per annum
58: --

Line 68: hr_utility.trace(' span_start: l_start='||to_char(l_start,'DD-MON-YYYY'));

64: p_input_date,l_start)/(12/p_frequency)));
65: end if;
66: --
67: if g_debug then
68: hr_utility.trace(' span_start: l_start='||to_char(l_start,'DD-MON-YYYY'));
69: hr_utility.set_location('Exiting: span_start',10);
70: end if;
71: return l_start;
72: --

Line 69: hr_utility.set_location('Exiting: span_start',10);

65: end if;
66: --
67: if g_debug then
68: hr_utility.trace(' span_start: l_start='||to_char(l_start,'DD-MON-YYYY'));
69: hr_utility.set_location('Exiting: span_start',10);
70: end if;
71: return l_start;
72: --
73: end span_start;