[Home] [Help]
1: package body hr_au_routes as
2: -- $Header: pyaurout.pkb 115.5 2003/10/20 02:13:44 puchil ship $
3:
4: -- Copyright (c) 1999 Oracle Corporation
5: -- All rights reserved
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-';
23: --
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
108: return date is
109: --
110: begin
111: --
112: return span_start( p_input_date, p_frequency, to_char(hr_au_routes.get_fiscal_date(p_business_group_id),'dd-mm-') );
113: --
114: end fiscal_span_start;
115: --
116: ------------------------------get_anniversary_date--------------------------------
155: begin
156: --
157: -- calculate the span start of the anniversary date
158: --
159: return span_start(p_input_date, 1, to_char(hr_au_routes.get_anniversary_date(p_assignment_action_id, p_input_date), 'dd-mm-'));
160: --
161: end anniversary_span_start;
162: --
163: end hr_au_routes;
159: return span_start(p_input_date, 1, to_char(hr_au_routes.get_anniversary_date(p_assignment_action_id, p_input_date), 'dd-mm-'));
160: --
161: end anniversary_span_start;
162: --
163: end hr_au_routes;