1 PACKAGE HrFastAnswers AUTHID CURRENT_USER AS
2 /* $Header: hrfstans.pkh 120.0 2005/05/29 06:59:25 appldev noship $ */
3
4 G_REGION_SEGMENT varchar2(100);
5
6 -- Exceptions raised when a report is run with the fast formula either
7 -- not existing, or existing and not being compiled.
8 -- mjandrew - 28-JUN-2000 - Bug 1323212 and Bug 976335
9 FF_Not_Compiled Exception;
10 FF_Not_Exist Exception;
11
12
13 TYPE LeavingReasonsType is table of Varchar2(30)
14 index by Binary_Integer;
15
16 FUNCTION GetBudgetValue
17 ( p_budget_metric_formula_id IN NUMBER
18 , p_assignment_id IN NUMBER
19 , p_effective_date IN DATE
20 , p_session_date IN DATE )
21 RETURN NUMBER;
22
23 FUNCTION GetBudgetValue
24 ( p_budget_metric IN VARCHAR2
25 , p_assignment_id IN NUMBER
26 , p_session_date IN DATE default sysdate )
27 RETURN NUMBER;
28
29 FUNCTION GetBudgetValue
30 ( p_budget_metric_formula_id IN NUMBER
31 , p_budget_metric IN VARCHAR2
32 , p_assignment_id IN NUMBER
33 , p_effective_date IN DATE
34 , p_session_date IN DATE )
35 RETURN NUMBER;
36
37 FUNCTION GetUtilHours(
38 p_formula_id IN NUMBER
39 ,p_assignment_id IN NUMBER
40 ,p_effective_date IN DATE
41 ,p_session_date IN DATE
42 ) RETURN NUMBER;
43
44 FUNCTION Get_Hours_Worked(
45 p_assign_id IN NUMBER
46 ,p_earned_date IN DATE
47 ,p_multiple IN NUMBER
48 ) RETURN NUMBER;
49
50 PROCEDURE GetAssignmentCategory(
51 p_org_param_id IN NUMBER
52 ,p_assignment_id IN NUMBER
53 ,p_period_start_date IN DATE
54 ,p_period_end_date IN DATE
55 ,p_top_org IN NUMBER
56 ,p_movement_type IN VARCHAR2
57 ,p_assignment_category OUT NOCOPY VARCHAR2
58 ,p_leaving_reason OUT NOCOPY VARCHAR2
59 ,p_service_band OUT NOCOPY VARCHAR2
60 );
61 pragma restrict_references( GetAssignmentCategory, WNPS, WNDS );
62
63 FUNCTION GetAssignmentCategory(
64 p_org_param_id IN NUMBER
65 ,p_assignment_id IN NUMBER
66 ,p_period_start_date IN DATE
67 ,p_period_end_date IN DATE
68 ,p_top_org IN NUMBER
69 ,p_movement_type IN VARCHAR2
70 ) RETURN VARCHAR2;
71 pragma restrict_references( GetAssignmentCategory, WNPS, WNDS );
72
73 FUNCTION GetAssignmentCategory
74 ( p_assignment_id IN NUMBER
75 , p_period_start_date IN DATE
76 , p_period_end_date IN DATE
77 , p_top_org IN NUMBER
78 , p_movement_type IN VARCHAR2 )
79 RETURN VARCHAR2;
80 pragma restrict_references( GetAssignmentCategory, WNPS, WNDS );
81
82 FUNCTION GetLeavingReason(
83 p_org_param_id IN NUMBER
84 ,p_assignment_id IN NUMBER
85 ,p_period_start_date IN DATE
86 ,p_period_end_date IN DATE
87 ,p_top_org IN NUMBER
88 ,p_movement_type IN VARCHAR2
89 ) RETURN VARCHAR2;
90 pragma restrict_references( GetLeavingReason, WNPS, WNDS );
91
92 FUNCTION GetLeavingReasonMeaning(
93 p_org_param_id IN NUMBER
94 ,p_assignment_id IN NUMBER
95 ,p_period_start_date IN DATE
96 ,p_period_end_date IN DATE
97 ,p_top_org IN NUMBER
98 ,p_movement_type IN VARCHAR2
99 ) RETURN VARCHAR2;
100 --pragma restrict_references( GetLeavingReasonMeaning, WNPS, WNDS );
101
102 FUNCTION Get_Service_Band_Name(
103 p_org_param_id IN NUMBER
104 ,p_assignment_id IN NUMBER
105 ,p_period_start_date IN DATE
106 ,p_period_end_date IN DATE
107 ,p_top_org IN NUMBER
108 ,p_movement_type IN VARCHAR2
109 ) RETURN VARCHAR2;
110 --
111 -- 4365287 Comment the pragma as its not required and causes
112 -- compilation issues with changed FND code
113 --
114 --pragma restrict_references( Get_Service_Band_Name, WNPS, WNDS );
115
116 FUNCTION Get_Service_Band_Order(
117 p_org_param_id IN NUMBER
118 ,p_assignment_id IN NUMBER
119 ,p_period_start_date IN DATE
120 ,p_period_end_date IN DATE
121 ,p_top_org IN NUMBER
122 ,p_movement_type IN VARCHAR2
123 ) RETURN NUMBER;
124 pragma restrict_references( Get_Service_Band_Order, WNPS, WNDS );
125
126 procedure LoadOrgHierarchy
127 ( p_organization_id IN Number
128 , p_org_struct_version_id IN Number );
129
130 procedure LoadOrgHierarchy
131 ( p_organization_id IN Number );
132
133 procedure LoadOrgHierarchy
134 ( p_organization_id IN Number
135 , p_org_struct_version_id IN Number
136 , p_organization_process IN Varchar2
137 , p_org_list OUT NOCOPY Varchar2 );
138
139 function OrgInHierarchy
140 ( p_organization_id Number )
141 return Number;
142 pragma restrict_references (OrgInHierarchy, WNPS, WNDS);
143 --
144 function OrgInHierarchy
145 ( p_organization_id_group Number
146 , p_organization_id_child Number )
147 return Number;
148 pragma restrict_references (OrgInHierarchy, WNPS, WNDS);
149 --
150 FUNCTION GetOrgStructElement RETURN NUMBER;
151 --pragma restrict_references( GetOrgStructElement, WNPS, WNDS );
152 --
153 FUNCTION GetOrgStructVersion RETURN NUMBER;
154 --pragma restrict_references( GetOrgStructVersion, WNPS, WNDS );
155 --
156 PROCEDURE Initialize(p_user_id IN NUMBER
157 ,p_resp_id IN NUMBER
158 ,p_resp_appl_id IN NUMBER
159 ,p_business_group_id OUT NOCOPY NUMBER
160 ,p_org_structure_version_id OUT NOCOPY NUMBER
161 ,p_sec_group_id IN NUMBER default 0);
162
163 PROCEDURE ClearLeavingReasons;
164 --
165 FUNCTION GetLeavingReasons RETURN LeavingReasonsType;
166 --
167 PROCEDURE SetLeavingReasons(
168 p_index IN NUMBER
169 ,p_value IN VARCHAR2 );
170 --
171 FUNCTION get_poplist(p_select_statement VARCHAR2
172 ,p_parameter_list VARCHAR2
173 ,p_parameter_name VARCHAR2
174 ,p_parameter_value VARCHAR2
175 ,p_report_name VARCHAR2
176 ,p_report_link VARCHAR2) RETURN VARCHAR2;
177
178 function business_group_id return NUMBER;
179 pragma restrict_references (business_group_id, WNPS, WNDS);
180 function org_structure_version_id return NUMBER;
181 pragma restrict_references (org_structure_version_id, WNPS, WNDS);
182 --
183 function ConvertToHours
184 ( p_formula_id in Number
185 , p_assignment_id in Number
186 , p_screen_value in Varchar2
187 , p_uom in Varchar2
188 , p_effective_date in Date
189 , p_session_date in Date )
190 return Number;
191 --
192 function TrainingConvertDuration
193 ( p_formula_id In Number
194 , p_from_duration In Number
195 , p_from_units In Varchar2
196 , p_to_units In Varchar2
197 , p_activity_version_name In Varchar2
198 , p_event_name In Varchar2
199 , p_session_date In Date )
200 return Number;
201 --
202 function GetLocationId
203 ( p_level IN Number
204 , p_location_id IN Number
205 , p_position_id IN Number
206 , p_organization_id IN Number
207 , p_business_group_id IN Number )
208 return Number;
209 --
210 function GetGeographyDimension
211 ( p_level IN Number
212 , p_location_id IN Number
213 , p_position_id IN Number
214 , p_organization_id IN Number
215 , p_business_group_id IN Number )
216 return Varchar2;
217
218 function GetReportingHierarchy
219 return Number;
220 -- pragma restrict_references( GetReportingHierarchy, WNPS, WNDS );
221
222 function Get_Region_Segment
223 return varchar2;
224
225 --
226
227 PROCEDURE Raise_FF_Not_Exist
228 ( p_bgttyp in VarChar2 );
229
230 PROCEDURE Raise_FF_Not_Compiled
231 ( p_formula_id in Number );
232
233 PROCEDURE CheckFastFormulaCompiled
234 ( p_formula_id in Number
235 , p_bgttyp in VarChar2 );
236
237 --
238
239 END HrFastAnswers;