[Home] [Help]
PACKAGE: APPS.OTA_COMPETENCE_SS
Source
1 PACKAGE OTA_COMPETENCE_SS AUTHID CURRENT_USER as
2 /* $Header: otcmpupd.pkh 120.1 2005/06/13 02:56:22 dbatra noship $ */
3
4
5 -- Global variables
6 g_date_format varchar2(10) := 'RRRR/MM/DD';
7
8 -- ---------------------------------------------------------------------------
9 -- |----------------------< check_Update_competence >--------------------------|
10 -- ---------------------------------------------------------------------------
11 --
12 PROCEDURE check_Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
13 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
14 actid IN NUMBER,
15 funcmode IN VARCHAR2,
16 resultout OUT nocopy VARCHAR2 );
17
18 -- ---------------------------------------------------------------------------
19 -- |----------------------< Update_competence >--------------------------|
20 -- ---------------------------------------------------------------------------
21 --
22 PROCEDURE Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
23 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
24 actid IN NUMBER,
25 funcmode IN VARCHAR2,
26 resultout OUT nocopy VARCHAR2 );
27
28 -- ---------------------------------------------------------------------------
29 -- |----------------------< get_approval_req >--------------------------|
30 -- ---------------------------------------------------------------------------
31 --
32
33 PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
34 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
35 actid IN NUMBER,
36 funcmode IN VARCHAR2,
37 resultout OUT nocopy VARCHAR2 );
38 -- ---------------------------------------------------------------------------
39 -- |----------------------< validate_competence_update >--------------------------|
40 -- ---------------------------------------------------------------------------
41 --
42
43 procedure validate_competence_update
44 (p_item_type in varchar2,
45 p_item_key in varchar2,
46 p_message out nocopy varchar2);
47
48
49 Function generate_url(p_func varchar2) return varchar2;
50 /*
51 ||===========================================================================
52 || PROCEDURE: create_wf_process
53 ||---------------------------------------------------------------------------
54 ||
55 || Description:
56 || Description:
57 || This procedure will launch the workflow process required to update
58 || competencies
59 ||
60 ||
61 || Pre Conditions:
62 ||
63 || In Arguments:
64 ||
65 ||
66 ||
67 || out Arguments:
68 ||
69 || In out Arguments:
70 ||
71 || Post Success:
72 ||
73 ||
74 || Post Failure:
75 || Raises an exception
76 ||
77 || Access Status:
78 || Public.
79 ||
80 ||===========================================================================
81 */
82
83 Procedure create_wf_process(p_process in wf_process_activities.process_name%type,
84 p_itemtype in wf_items.item_type%type,
85 p_person_id in number ,
86 p_eventid in ota_Events.event_id%type default null,
87 p_learningpath_ids in varchar2 default null,
88 p_certification_Id in number default null,
89 p_itemkey out nocopy wf_items.item_key%type);
90 /*
91 ||===========================================================================
92 || PROCEDURE: save_Comptence_info
93 ||---------------------------------------------------------------------------
94 ||
95 || Description:
96 || Description:
97 || This procedure will save the comptency relaetd information in transaction
98 || table
99 ||
100 || Pre Conditions:
101 ||
102 || In Arguments:
103 ||
104 ||
105 ||
106 || out Arguments:
107 ||
108 || In out Arguments:
109 ||
110 || Post Success:
111 ||
112 ||
113 || Post Failure:
114 || Raises an exception
115 ||
116 || Access Status:
117 || Public.
118 ||
119 ||===========================================================================
120 */
121
122 Procedure save_Comptence_info(
123 p_person_id in number ,
124 p_item_type in wf_items.item_type%type,
125 p_item_key in wf_items.item_key%type,
126 p_Competence_id in varchar2,
127 p_level_id in varchar2,
128 p_level_override in varchar2 default null,
129 p_date_from in varchar2 default null,
130 p_date_to in varchar2 default null,
131 p_source in varchar2 default null,
132 p_certification_date in varchar2 default null,
133 p_certification_method in varchar2 default null,
134 p_certification_next in varchar2 default null,
135 p_comments in varchar2 default null,
136 p_from in varchar2 default null);
137
138 /*
139 ||===========================================================================
140 || PROCEDURE: get_Comptence_eff_date
141 ||---------------------------------------------------------------------------
142 ||
143 || Description:
144 || Description:
145 || This procedure will get the competency relaetd date to be
146 || saved in transaction table
147 ||
148 ||
149 || Pre Conditions:
150 ||
151 || In Arguments:
152 ||
153 ||
154 ||
155 || out Arguments:
156 ||
157 || In out Arguments:
158 ||
159 || Post Success:
160 ||
161 ||
162 || Post Failure:
163 || Raises an exception
164 ||
165 || Access Status:
166 || Public.
167 ||
168 ||===========================================================================
169 */
170
171 Function get_Competence_eff_date(
172 p_comp_id in per_competence_elements.competence_id%type,
173 p_id in ota_events.event_id%type,
174 p_obj_type in varchar2
175 ) return date;
176
177 /*
178 ||===========================================================================
179 || PROCEDURE: get_review_data
180 ||---------------------------------------------------------------------------
181 ||
182 || Description:
183 || Description:
184 || This procedure will get the competency relaetd information from transaction table
185 ||
186 ||
187 || Pre Conditions:
188 ||
189 || In Arguments:
190 ||
191 ||
192 ||
193 || out Arguments:
194 ||
195 || In out Arguments:
196 ||
197 || Post Success:
198 ||
199 ||
200 || Post Failure:
201 || Raises an exception
202 ||
203 || Access Status:
204 || Public.
205 ||
206 ||===========================================================================
207 */
208
209
210 PROCEDURE get_review_data
211 (p_item_type in varchar2
212 ,p_item_key in varchar2
213 ,p_review_data out nocopy long
214 ,p_from out nocopy varchar2);
215
216 PROCEDURE process_api
217 (p_validate IN BOOLEAN default false,p_transaction_step_id IN NUMBER default null);
218
219 /*
220 ||===========================================================================
221 || PROCEDURE: COMP_RETREIVE
222 ||---------------------------------------------------------------------------
223 ||
224 || Description:
225 || Description:
226 || This procedure will get the competency relaetd information from base table
227 || for an event and associated LP (if completed)
228 ||
229 ||
230 || Pre Conditions:
231 ||
232 || In Arguments:
233 ||
234 ||
235 ||
236 || out Arguments:
237 ||
238 || In out Arguments:
239 ||
240 || Post Success:
241 ||
242 ||
243 || Post Failure:
244 || Raises an exception
245 ||
246 || Access Status:
247 || Public.
248 ||
249 ||===========================================================================
250 */
251
252 PROCEDURE COMP_RETREIVE ( p_event_id IN NUMBER
253 , p_learning_path_ids IN VARCHAR2
254 , p_certification_id IN Number
255 , p_person_id in number default null
256 , p_comp_ids OUT NOCOPY VARCHAR2
257 , p_level_ids OUT NOCOPY VARCHAR2
258 ,p_eff_date_from out nocopy varchar2
259 ,p_eff_date_to out nocopy varchar2);
260
261 end ota_Competence_ss;
262
263