1 PACKAGE HR_UTIL_MISC_SS AUTHID CURRENT_USER AS
2 /* $Header: hrutlmss.pkh 120.24.12020000.5 2013/02/04 11:10:45 ckondapi ship $ */
3
4 TYPE EntityTabTyp IS TABLE of NUMBER index by binary_integer;
5
6 g_entity_list EntityTabTyp;
7 g_eff_date DATE:= sysdate;
8 g_year_start DATE;
9 g_loginPrsnBGId NUMBER;
10 g_loginPrsnCurrencyCode VARCHAR2(30);
11 g_rate_type VARCHAR2(30);
12
13 PROCEDURE initLoginPrsnCtx(p_eff_date IN DATE);
14
15 PROCEDURE populateInterimPersonList (
16 person_data PER_INTERIM_PERSON_LIST_STRUCT
17 );
18
19 PROCEDURE populateInterimListFromMyList (
20 person_id number
21 );
22
23 PROCEDURE addToMyListFromInterimList (
24 prsn_id number
25 );
26
27 PROCEDURE setEffectiveDate
28 (p_effective_date in date);
29
30
31 PROCEDURE clear_cache;
32
33 PROCEDURE populate_entity_list (
34 p_elist IN HR_MISC_SS_NUMBER_TABLE,
35 p_retain_cache in VARCHAR2
36 );
37
38 FUNCTION entity_exists (
39 p_entity_id IN Number
40 )
41 RETURN VARCHAR2;
42
43 FUNCTION validate_selected_function (
44 p_api_version IN NUMBER
45 ,p_function IN VARCHAR2
46 ,p_object_name IN VARCHAR2
47 ,p_person_id IN VARCHAR2
48 ,p_instance_pk2_value IN VARCHAR2
49 ,p_user_name IN VARCHAR2
50 ,p_eff_date IN DATE
51 )
52 RETURN VARCHAR2;
53
54 FUNCTION check_cwk_access (
55 p_function IN VARCHAR2
56 ,p_person_id IN NUMBER
57 ,p_eff_date IN DATE
58 )
59 RETURN VARCHAR2;
60
61 FUNCTION check_akregion_code (
62 p_ak_region IN VARCHAR2
63 )
64 RETURN VARCHAR2;
65
66 PROCEDURE check_ota_installed (appl_id number, status out NOCOPY varchar2);
67
68 PROCEDURE is_primary_assign (
69 itemtype in varchar2,
70 itemkey in varchar2,
71 actid in number,
72 funcmode in varchar2,
73 resultout out nocopy varchar2
74 );
75
76 PROCEDURE is_voluntary_termination (
77 itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 funcmode in varchar2,
81 resultout out nocopy varchar2
82 );
83
84 FUNCTION get_apl_asgs_count(
85 p_person_id IN number,
86 p_effective_date IN date)
87 return number;
88
89 FUNCTION get_assign_termination_date(
90 p_assignment_id IN number) return date;
91
92 PROCEDURE is_employee_check (
93 itemtype in varchar2,
94 itemkey in varchar2,
95 actid in number,
96 funcmode in varchar2,
97 resultout out nocopy varchar2
98 );
99 FUNCTION getObjectName(
100 p_object IN varchar2,
101 p_object_id IN number,
102 p_bg_id IN number,
103 p_value IN varchar2
104 )
105 return varchar2;
106
107 FUNCTION check_term_access (
108 p_function IN VARCHAR2
109 ,p_person_id IN NUMBER
110 ,p_eff_date IN DATE
111 )
112 RETURN VARCHAR2;
113
114 FUNCTION check_primary_access (
115 p_selected_person_id NUMBER,
116 p_effective_date DATE)
117 RETURN VARCHAR2;
118
119 PROCEDURE initialize_am ;
120
121 PROCEDURE SET_SYS_CTX (
122 p_legCode in varchar2
123 ,p_bgId in varchar2
124 );
125
126 function get_person_id return number;
127
128 FUNCTION getCompSourceInfo (
129 p_competence_id IN NUMBER
130 ,p_person_id IN NUMBER
131 ) RETURN VARCHAR2;
132
133 FUNCTION get_in_preferred_currency_num(
134 p_amount IN NUMBER
135 ,p_from_currency IN VARCHAR2
136 ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
137 ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
138 ) RETURN NUMBER;
139
140 FUNCTION get_in_preferred_currency_str(
141 p_amount IN NUMBER
142 ,p_from_currency IN VARCHAR2
143 ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
144 ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
145 ) RETURN VARCHAR2;
146
147 FUNCTION get_preferred_currency(
148 p_from_currency IN VARCHAR2
149 ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
150 ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
151 ) RETURN VARCHAR2;
152
153 FUNCTION get_employee_salary(
154 p_assignment_id IN NUMBER
155 ,P_Effective_Date IN date
156 ) RETURN NUMBER;
157
158 FUNCTION get_employee_salary(
159 p_assignment_id in number
160 ,p_Effective_Date in date
161 ,p_proposed_salary IN NUMBER
162 ,p_pay_annual_factor IN number
163 ,p_pay_basis in varchar2
164 ) RETURN NUMBER;
165
166 PROCEDURE populateInterimEntityList (
167 entity_data PER_INTERIM_ENTITY_LIST_STRUCT
168 ,p_retain_cache IN VARCHAR2
169 );
170
171 PROCEDURE clearInterimEntityList ;
172
173 procedure isPersonTerminated (
174 result out nocopy varchar2,
175 p_person_id varchar2,
176 p_assignment_id varchar2
177 );
178
179 procedure getDeploymentPersonID (person_id in number, result out nocopy number );
180
181 FUNCTION getBusinessGroup(
182 p_function_id IN number,
183 p_bg_id IN number,
184 p_person_id IN number
185 )RETURN per_all_people_f.business_group_id%Type;
186
187 FUNCTION get_parameter_value (
188 p_parameter_list IN VARCHAR2
189 ,p_parameter IN VARCHAR2
190 )
191 RETURN VARCHAR2;
192
193 procedure merge_attachments (
194 p_source_entity_name in varchar2 default 'PQH_SS_ATTACHMENT'
195 ,p_dest_entity_name in varchar2
196 ,p_source_pk1_value in varchar2 default null
197 ,p_dest_pk1_value in varchar2
198 ,p_return_status in out nocopy varchar2 );
199
200 procedure saveAttachment(
201 p_transaction_id in Number default null
202 ,p_return_status out nocopy varchar2);
203
204
205 function getAttachToEntity(
206 p_transaction_id in number)
207 return boolean ;
208
209 function getUpgradeCheck(
210 p_transaction_id in number)
211 return varchar2;
212
213 function getLocName (p_loc_id in number, p_bg_id in number)
214 return varchar2;
215 function getOrgName (p_org_id in number, p_bg_id in number)
216 return varchar2;
217 function getGradeName (p_grade_id in number, p_bg_id in number)
218 return varchar2;
219 function getPositionName (p_position_id in number, p_bg_id in number)
220 return varchar2;
221 function getJobName (p_job_id in number, p_bg_id in number)
222 return varchar2;
223
224 PROCEDURE is_us_emp_check (
225 itemtype in varchar2,
226 itemkey in varchar2,
227 actid in number,
228 funcmode in varchar2,
229 resultout out nocopy varchar2
230 );
231
232 function is_basic_det_chg (
233 p_person_id in number
234 ) return varchar2;
235
236
237 function getLocNameNew (p_rptg_grp_id in number,p_plan_id in number, p_loc_id in
238 number, p_bg_id in number)
239 return varchar2;
240 function getOrgNameNew (p_rptg_grp_id in number,p_plan_id in number, p_org_id in
241 number, p_bg_id in number)
242 return varchar2;
243 function getGradeNameNew (p_rptg_grp_id in number,p_plan_id in number,
244 p_grade_id in number, p_bg_id in number)
245 return varchar2;
246 function getPositionNameNew (p_rptg_grp_id in number,p_plan_id in number,
247 p_position_id in number, p_bg_id in number)
248 return varchar2;
249 function getJobNameNew (p_rptg_grp_id in number,p_plan_id in number, p_job_id in
250 number,p_bg_id in number)
251 return varchar2;
252 function getManagerName (p_rptg_grp_id in number,p_plan_id in
253 number,p_assignment_id in number, p_bg_id in number)
254 return varchar2;
255
256 procedure get_item_type_and_key (
257 p_transaction_id IN VARCHAR2
258 ,p_itemType OUT NOCOPY VARCHAR2
259 ,p_itemKey OUT NOCOPY VARCHAR2 );
260
261 procedure setApprSFLResponseContext( p_item_type in varchar2,
262 p_item_key in varchar2,
263 p_act_id in number,
264 funmode in varchar2,
265 result out nocopy varchar2 );
266 function isQkFn
267 (
268 fn_name in varchar2
269 ) return varchar2;
270
271 function isBpRv
272 (
273 fn_name in varchar2
274 ) return varchar2;
275
276 function isEffDateReq
277 (
278 fn_name in varchar2
279 ) return varchar2;
280
281 --------------------------------------------------------------------------
282 --------------------------get_wf_bprv--------------------------------
283 --------------------------------------------------------------------------
284
285 PROCEDURE get_wf_bprv (
286 itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
287 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
288 actid IN NUMBER,
289 funcmode IN VARCHAR2,
290 resultout OUT nocopy VARCHAR2 );
291
292 function check_trans_step_exists
293 (
294 itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
295 itemkey IN WF_ITEMS.ITEM_KEY%TYPE
296 ) return varchar2;
297
298 END HR_UTIL_MISC_SS;