1 package HR_CALENDAR_PKG as
2 /* $Header: hrcalapi.pkh 120.2.12010000.2 2008/11/07 11:00:49 pbalu noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 Name
12 Calendars Business Process
13 Purpose
14 To provide routines to give information about calendars
15 History
16 05 sep 95 N Simpson Created
17 07 sep 95 N Simpson Added function purpose_usage_id
18
19 Version Date BugNo Author Comment
20 -------+-----------+---------+---------+--------------------------------------
21 40.3 18-Jul_97 513292 RThirlby Created another overload of procedure
22 denormalise_calendar. Altered function
23 total_availability to accept parameters
24 for both bg and person pattern in the
25 same (linked) absence.
26 40.4 01-JUL--98 655707 A.Myers Altered function total_availability to
27 accept another parameter which, if
28 supplied, means it has been called by
29 package ssp_ssp_pkg and it is used to
30 dictate the amount of processing to do.
31 */
32 --------------------------------------------------------------------------------
33 function end_date (row_number integer) return date;
34 pragma restrict_references (end_date, WNDS,WNPS);
35
36 function start_date (row_number integer) return date;
37 pragma restrict_references (start_date, WNDS,WNPS);
38
39 function availability_value (row_number integer) return varchar2;
40 pragma restrict_references (availability_value, WNDS, WNPS);
41
42 function schedule_level_value (row_number integer) return number;
43 pragma restrict_references (schedule_level_value, WNDS, WNPS);
44
45 function schedule_rowcount return number;
46 pragma restrict_references (schedule_rowcount, WNDS, WNPS);
47
48 -- Bug 513292 - new overloaded version of this procedure
49 -- Bug 655707 - parameter p_called_from_SSP added to control further processing.
50 -- This will have been set to true in SSP_SSP_PKG.
51 procedure denormalise_calendar (
52 p_person_purpose_usage_id number,
53 p_person_primary_key_value number,
54 p_bg_purpose_usage_id number,
55 p_bg_primary_key_value number,
56 p_period_from date,
57 p_period_to date,
58 p_called_from_SSP boolean default false);
59
60 procedure denormalise_calendar (
61 p_calendar_id number,
62 p_calendar_start_time date,
63 p_period_from date,
64 p_period_to date);
65
66 procedure denormalise_calendar (
67 p_purpose_usage_id number,
68 p_primary_key_value number,
69 p_period_from date,
70 p_period_to date);
71 --
72 -- Bug 513292 - new parameters added so that both BG and Person patterns can
73 -- be returned for same (linked) absence.
74 -- Bug 701750 - new parameter p_processing_level used in SSP processing.
75 --
76 function total_availability (
77 p_availability varchar2,
78 p_person_purpose_usage_id number,
79 p_person_primary_key_value number,
80 p_bg_purpose_usage_id number,
81 p_bg_primary_key_value number,
82 p_period_from date,
83 p_period_to date,
84 p_processing_level number default 0) return number;
85
86 function availability (
87 p_date_and_time date,
88 p_purpose_usage_id number,
89 p_primary_key_value number) return varchar2;
90
91 function purpose_usage_id (
92 p_entity_name varchar2,
93 p_pattern_purpose varchar2) return number;
94 pragma restrict_references (purpose_usage_id, WNDS, WNPS);
95
96 end hr_calendar_pkg;