[Home] [Help]
PACKAGE: APPS.PER_COMPETENCE_DATA_PUMP
Source
1 PACKAGE PER_COMPETENCE_DATA_PUMP AUTHID CURRENT_USER AS
2 /* $Header: pecompdp.pkh 115.3 2004/03/18 10:15:23 ynegoro noship $ */
3 -- -------------------------------------------------------------------------
4 -- --------------------< get_rsc_old_id >------------------------------
5 -- -------------------------------------------------------------------------
6 -- DESCRIPTION
7 -- This function returns the
8 --
9 FUNCTION get_rsc_old_id
10 (p_data_pump_always_call IN varchar2
11 ,p_old_rating_scale_name IN VARCHAR2
12 ,p_business_group_id IN NUMBER)
13 RETURN BINARY_INTEGER;
14 PRAGMA RESTRICT_REFERENCES (get_rsc_old_id , WNDS);
15 -- -------------------------------------------------------------------------
16 -- -------------------------------------------------------------------------
17 -- --------------------< get_rating_scale_id >------------------------------
18 -- -------------------------------------------------------------------------
19 -- DESCRIPTION
20 -- This function returns the
21 --
22 FUNCTION get_rating_scale_id
23 (p_data_pump_always_call IN varchar2
24 ,p_rating_scale_name IN VARCHAR2
25 ,p_business_group_id IN NUMBER)
26 RETURN BINARY_INTEGER;
27 PRAGMA RESTRICT_REFERENCES (get_rating_scale_id , WNDS);
28 -- -------------------------------------------------------------------------
29 -- --------------------< get_rsc_ovn >---------------------------
30 -- -------------------------------------------------------------------------
31 -- DESCRIPTION
32 -- This function returns the ovn for rating scale
33 --
34 FUNCTION get_rsc_ovn
35 (p_data_pump_always_call IN varchar2
36 ,p_old_rating_scale_name IN VARCHAR2
37 ,p_business_group_id IN NUMBER)
38 RETURN BINARY_INTEGER;
39 PRAGMA RESTRICT_REFERENCES (get_rsc_ovn , WNDS);
40 -- -------------------------------------------------------------------------
41 -- --------------------< get_cpn_ovn >--------------------------------
42 -- -------------------------------------------------------------------------
43 -- DESCRIPTION
44 -- This function returns the
45 --
46 FUNCTION get_cpn_ovn
47 (p_data_pump_always_call IN varchar2
48 ,p_competence_name IN VARCHAR2
49 ,p_business_group_id IN NUMBER)
50 RETURN BINARY_INTEGER;
51 PRAGMA RESTRICT_REFERENCES (get_cpn_ovn , WNDS);
52 -- -------------------------------------------------------------------------
53 -- --------------------< get_competence_id >--------------------------------
54 -- -------------------------------------------------------------------------
55 -- DESCRIPTION
56 -- This function returns the
57 --
58 FUNCTION get_competence_id
59 (p_data_pump_always_call IN varchar2
60 ,p_competence_name IN VARCHAR2
61 ,p_business_group_id IN NUMBER)
62 RETURN BINARY_INTEGER;
63 PRAGMA RESTRICT_REFERENCES (get_competence_id , WNDS);
64 -- -------------------------------------------------------------------------
65 -- ------------< get_parent_comp_element_id >-------------------------
66 -- -------------------------------------------------------------------------
67 -- DESCRIPTION
68 -- This function returns the
69 --
70 FUNCTION get_parent_comp_element_id
71 RETURN BINARY_INTEGER;
72 PRAGMA RESTRICT_REFERENCES (get_parent_comp_element_id , WNDS);
73 -- -------------------------------------------------------------------------
74 -- --------------------< get_enterprise_id >--------------------------------
75 -- -------------------------------------------------------------------------
76 -- DESCRIPTION
77 -- This function returns the
78 --
79 FUNCTION get_enterprise_id
80 RETURN BINARY_INTEGER;
81 PRAGMA RESTRICT_REFERENCES (get_enterprise_id , WNDS);
82 --
83 -- -------------------------------------------------------------------------
84 -- --------------------< get_proficiency_level_id >-------------------------
85 -- -------------------------------------------------------------------------
86 -- DESCRIPTION
87 -- This function returns the
88 --
89 FUNCTION get_proficiency_level_id
90 RETURN BINARY_INTEGER;
91 PRAGMA RESTRICT_REFERENCES (get_proficiency_level_id , WNDS);
92 -- -------------------------------------------------------------------------
93 -- --------------------< get_position_id >----------------------------------
94 -- -------------------------------------------------------------------------
95 -- DESCRIPTION
96 -- This function returns the
97 --
98 FUNCTION get_position_id
99 RETURN BINARY_INTEGER;
100 PRAGMA RESTRICT_REFERENCES (get_position_id , WNDS);
101 -- -------------------------------------------------------------------------
102 -- --------------------< get_activity_version_id >--------------------------
103 -- -------------------------------------------------------------------------
104 -- DESCRIPTION
105 -- This function returns the
106 --
107 FUNCTION get_activity_version_id
108 RETURN BINARY_INTEGER;
109 PRAGMA RESTRICT_REFERENCES (get_activity_version_id , WNDS);
110 -- -------------------------------------------------------------------------
111 -- --------------------< get_person_id >------------------------------------
112 -- -------------------------------------------------------------------------
113 -- DESCRIPTION
114 -- This function returns the
115 --
116 FUNCTION get_person_id
117 RETURN BINARY_INTEGER;
118 PRAGMA RESTRICT_REFERENCES (get_person_id , WNDS);
119 -- -------------------------------------------------------------------------
120 -- --------------------< get_high_proficiency_level_id >--------------------
121 -- -------------------------------------------------------------------------
122 -- DESCRIPTION
123 -- This function returns the
124 --
125 FUNCTION get_high_proficiency_level_id
126 RETURN BINARY_INTEGER;
127 PRAGMA RESTRICT_REFERENCES (get_high_proficiency_level_id , WNDS);
128 -- -------------------------------------------------------------------------
129 -- --------------------< get_assessment_id >--------------------------------
130 -- -------------------------------------------------------------------------
131 -- DESCRIPTION
132 -- This function returns the
133 --
134 FUNCTION get_assessment_id
135 RETURN BINARY_INTEGER;
136 PRAGMA RESTRICT_REFERENCES (get_assessment_id , WNDS);
137 -- -------------------------------------------------------------------------
138 -- --------------------< get_assessment_type_id >---------------------------
139 -- -------------------------------------------------------------------------
140 -- DESCRIPTION
141 -- This function returns the
142 --
143 FUNCTION get_assessment_type_id
144 RETURN BINARY_INTEGER;
145 PRAGMA RESTRICT_REFERENCES (get_assessment_type_id , WNDS);
146 -- -------------------------------------------------------------------------
147 -- --------------------< get_weighting_level_id >---------------------------
148 -- -------------------------------------------------------------------------
149 -- DESCRIPTION
150 -- This function returns the
151 --
152 FUNCTION get_weighting_level_id
153 RETURN BINARY_INTEGER;
154 PRAGMA RESTRICT_REFERENCES (get_weighting_level_id , WNDS);
155 -- -------------------------------------------------------------------------
156 -- --------------------< get_rating_level_id >---------------------------
157 -- -------------------------------------------------------------------------
158 -- DESCRIPTION
159 -- This function returns the
160 --
161 FUNCTION get_rating_level_id
162 (p_data_pump_always_call IN varchar2
163 ,p_rating_scale_name IN VARCHAR2
164 ,p_competence_name IN VARCHAR2
165 ,p_rating_level_name IN VARCHAR2
166 ,p_business_group_id IN NUMBER)
167 RETURN BINARY_INTEGER;
168 PRAGMA RESTRICT_REFERENCES (get_rating_level_id , WNDS);
169 -- -------------------------------------------------------------------------
170 -- --------------------< get_rtl_old_if >---------------------------
171 -- -------------------------------------------------------------------------
172 -- DESCRIPTION
173 -- This function returns the
174 --
175 FUNCTION get_rtl_ovn
176 (p_data_pump_always_call IN varchar2
177 ,p_rating_scale_name IN VARCHAR2
178 ,p_competence_name IN VARCHAR2
179 ,p_old_rating_level_name IN VARCHAR2
180 ,p_business_group_id IN NUMBER)
181 RETURN BINARY_INTEGER;
182 PRAGMA RESTRICT_REFERENCES (get_rtl_ovn , WNDS);
183 -- -------------------------------------------------------------------------
184 -- --------------------< get_rtl_old_if >---------------------------
185 -- -------------------------------------------------------------------------
186 -- DESCRIPTION
187 -- This function returns the
188 --
189 FUNCTION get_rtl_old_id
190 (p_data_pump_always_call IN varchar2
191 ,p_rating_scale_name IN VARCHAR2
192 ,p_competence_name IN VARCHAR2
193 ,p_old_rating_level_name IN VARCHAR2
194 ,p_business_group_id IN NUMBER)
195 RETURN BINARY_INTEGER;
196 PRAGMA RESTRICT_REFERENCES (get_rtl_old_id , WNDS);
197 -- -------------------------------------------------------------------------
198 -- --------------------< get_valid_grade_id >-------------------------------
199 -- -------------------------------------------------------------------------
200 -- DESCRIPTION
201 -- This function returns the
202 --
203 FUNCTION get_valid_grade_id
204 RETURN BINARY_INTEGER;
205 PRAGMA RESTRICT_REFERENCES (get_valid_grade_id , WNDS);
206 -- -------------------------------------------------------------------------
207 -- --------------------< get_object_id >-------------------------------
208 -- -------------------------------------------------------------------------
209 -- DESCRIPTION
210 -- This function returns the
211 --
212 FUNCTION get_object_id
213 RETURN BINARY_INTEGER;
214 PRAGMA RESTRICT_REFERENCES (get_object_id , WNDS);
215 -- -------------------------------------------------------------------------
216 -- ----------------< get_qualification_type_id >-------------------------
217 -- -------------------------------------------------------------------------
218 -- DESCRIPTION
219 -- This function returns the
220 --
221 FUNCTION get_qualification_type_id
222 (p_data_pump_always_call IN varchar2
223 ,p_qualification_type_name IN VARCHAR2
224 )
225 RETURN BINARY_INTEGER;
226 PRAGMA RESTRICT_REFERENCES (get_qualification_type_id , WNDS);
227 --
228 END PER_COMPETENCE_DATA_PUMP ;