[Home] [Help]
PACKAGE: APPS.HR_UTIL_MISC_SS
Source
1 PACKAGE HR_UTIL_MISC_SS AUTHID CURRENT_USER AS
2 /* $Header: hrutlmss.pkh 120.11.12010000.1 2008/07/28 03:57:26 appldev 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_employee_check (
69 itemtype in varchar2,
70 itemkey in varchar2,
71 actid in number,
72 funcmode in varchar2,
73 resultout out nocopy varchar2
74 );
75 FUNCTION getObjectName(
76 p_object IN varchar2,
77 p_object_id IN number,
78 p_bg_id IN number,
79 p_value IN varchar2
80 )
81 return varchar2;
82
83 FUNCTION check_term_access (
84 p_function IN VARCHAR2
85 ,p_person_id IN NUMBER
86 ,p_eff_date IN DATE
87 )
88 RETURN VARCHAR2;
89
90 FUNCTION check_primary_access (
91 p_selected_person_id NUMBER,
92 p_effective_date DATE)
93 RETURN VARCHAR2;
94
95 PROCEDURE initialize_am ;
96
97 PROCEDURE SET_SYS_CTX (
98 p_legCode in varchar2
99 ,p_bgId in varchar2
100 );
101
102 function get_person_id return number;
103
104 FUNCTION getCompSourceInfo (
105 p_competence_id IN NUMBER
106 ,p_person_id IN NUMBER
107 ) RETURN VARCHAR2;
108
109 FUNCTION get_in_preferred_currency_num(
110 p_amount IN NUMBER
111 ,p_from_currency IN VARCHAR2
112 ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
113 ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
114 ) RETURN NUMBER;
115
116 FUNCTION get_in_preferred_currency_str(
117 p_amount IN NUMBER
118 ,p_from_currency IN VARCHAR2
119 ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
120 ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
121 ) RETURN VARCHAR2;
122
123 FUNCTION get_preferred_currency(
124 p_from_currency IN VARCHAR2
125 ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
126 ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
127 ) RETURN VARCHAR2;
128
129 FUNCTION get_employee_salary(
130 p_assignment_id IN NUMBER
131 ,P_Effective_Date IN date
132 ) RETURN NUMBER;
133
134 PROCEDURE populateInterimEntityList (
135 entity_data PER_INTERIM_ENTITY_LIST_STRUCT
136 ,p_retain_cache IN VARCHAR2
137 );
138
139 PROCEDURE clearInterimEntityList ;
140
141 procedure isPersonTerminated (
142 result out nocopy varchar2,
143 p_person_id varchar2,
144 p_assignment_id varchar2
145 );
146
147 procedure getDeploymentPersonID (person_id in number, result out nocopy number );
148
149 END HR_UTIL_MISC_SS;