1 PACKAGE HR_BUDGET_CALENDAR AUTHID CURRENT_USER as
2 /* $Header: pybudcal.pkh 115.0 99/07/17 05:46:36 porting ship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9 Name
10 hr_budget_calendar
11 Purpose
12 Maintains budgetary calendars ie. creates and removes time periods
13 representing years of calendar.
14 Notes
15 Used by the PAYWSDCL (Define Budgetary Calendar) form.
16 History
17 11-Mar-94 J.S.Hobbs 40.0 Date created.
18 ============================================================================*/
19 --
20 -----------------------------------------------------------------------------
21 -- Name --
22 -- midpoint_offset --
23 -- Purpose --
24 -- Returns the midpoint offset used by a semi-monthly calendar. --
25 -- Arguments --
26 -- See Below. --
27 -- Notes --
28 -- Used in the PAYWSDCL (Define Budgetary Calendar) form on post query --
29 -- to display the midpoint offset used in semi-monthly calendars. --
30 -----------------------------------------------------------------------------
31 --
32 function midpoint_offset
33 (
34 p_period_set_name varchar2,
35 p_start_date date
36 ) return number;
37 --
38 -----------------------------------------------------------------------------
39 -- Name --
40 -- num_of_cal_yrs --
41 -- Purpose --
42 -- Counts the number of calendar years that have already been created --
43 -- for a calendar. --
44 -- Arguments --
45 -- See below. --
46 -- Notes --
47 -- Used in the PAYWSDCL (Define Budgetary Calendar) form on post query --
48 -- to display the current number of calendar years created. --
49 -----------------------------------------------------------------------------
50 --
51 function num_of_cal_yrs
52 (
53 p_period_set_name varchar2
54 ) return number;
55 --
56 -----------------------------------------------------------------------------
57 -- Name --
58 -- gen_budget_calendar --
59 -- Purpose --
60 -- Generates a number of years of time periods for a calendar. --
61 -- Arguments --
62 -- See Below. --
63 -- Notes --
64 -- None. --
65 -----------------------------------------------------------------------------
66 --
67 procedure generate
68 (
69 p_period_set_name varchar2,
70 p_midpoint_offset number,
71 p_number_of_years number
72 );
73 --
74 -----------------------------------------------------------------------------
75 -- Name --
76 -- remove --
77 -- Purpose --
78 -- Removes a number of years of time periods for a calendar. --
79 -- Arguments --
80 -- p_number_of_years should be the number of calendar years that exist --
81 -- after the code has completed. --
82 -- Notes --
83 -- None. --
84 -----------------------------------------------------------------------------
85 --
86 procedure remove
87 (
88 p_period_set_name varchar2,
89 p_number_of_years number,
90 p_at_least_one_year boolean
91 );
92 --
93 end HR_BUDGET_CALENDAR;