1 PACKAGE ota_training_ss AUTHID CURRENT_USER AS
2 /* $Header: otenrwrs.pkh 120.1 2005/06/14 12:05:43 mcaruso noship $*/
3
4 gv_wf_review_region_item constant wf_item_attributes.name%type
5 := 'HR_REVIEW_REGION_ITEM';
6 /*
7 ||===========================================================================
8 || PROCEDURE: save_adv_search
9 ||---------------------------------------------------------------------------
10 ||
11 || Description:
12 || Description:
13 || This procedure will save Advance Search items in Transaction table
14 ||
15 ||
16 || Pre Conditions:
17 ||
18 || In Arguments:
19 ||
20 ||
21 ||
22 || out Arguments:
23 ||
24 || In out Arguments:
25 ||
26 || Post Success:
27 ||
28 ||
29 || Post Failure:
30 || Raises an exception
31 ||
32 || Access Status:
33 || Public.
34 ||
35 ||===========================================================================
36 */
37
38 procedure save_adv_search(
39 p_login_person_id NUMBER default null
40 , p_item_type in varchar2
41 , p_item_key in varchar2
42 , p_activity_id in number
43 , p_save_mode in varchar2 default null
44 , p_error_message out nocopy varchar2
45 , p_keyword in VARCHAR2
46 , p_category in VARCHAR2
47 , p_dmethod in VARCHAR2
48 , p_language in VARCHAR2
49 , p_trndates in VARCHAR2
50 , p_trnorgids in VARCHAR2
51 , p_trnorgnames in VARCHAR2
52 , p_trncompids in VARCHAR2
53 , p_trncompnames in VARCHAR2
54 , p_trncompminlvl in VARCHAR2 --Bug 2509979
55 , p_trncompmaxlvl in VARCHAR2 --Bug 2509979
56 , p_criteria in VARCHAR2
57 , p_oafunc in VARCHAR2
58 , p_processname in VARCHAR2
59 , p_calledfrom in VARCHAR2
60 , p_frommenu in VARCHAR2
61 );
62
63
64
65 procedure save_add_enroll_detail(
66 p_login_person_id NUMBER default null
67 , p_item_type in varchar2
68 , p_item_key in varchar2
69 , p_activity_id in number
70 , p_save_mode in varchar2 default null
71 , p_error_message out nocopy varchar2
72 , p_eventid in VARCHAR2
73 , p_activityversionid in VARCHAR2
74 , p_specialInstruction in VARCHAR2
75 , p_keyflexId in VARCHAR2
76 , p_businessGroupId in VARCHAR2
77 , p_assignmentId in VARCHAR2
78 , p_organizationId in VARCHAR2
79 , p_from in VARCHAR2
80 , p_tdb_information_category in varchar2 default null
81 , p_tdb_information1 in varchar2 default null
82 , p_tdb_information2 in varchar2 default null
83 , p_tdb_information3 in varchar2 default null
84 , p_tdb_information4 in varchar2 default null
85 , p_tdb_information5 in varchar2 default null
86 , p_tdb_information6 in varchar2 default null
87 , p_tdb_information7 in varchar2 default null
88 , p_tdb_information8 in varchar2 default null
89 , p_tdb_information9 in varchar2 default null
90 , p_tdb_information10 in varchar2 default null
91 , p_tdb_information11 in varchar2 default null
92 , p_tdb_information12 in varchar2 default null
93 , p_tdb_information13 in varchar2 default null
94 , p_tdb_information14 in varchar2 default null
95 , p_tdb_information15 in varchar2 default null
96 , p_tdb_information16 in varchar2 default null
97 , p_tdb_information17 in varchar2 default null
98 , p_tdb_information18 in varchar2 default null
99 , p_tdb_information19 in varchar2 default null
100 , p_tdb_information20 in varchar2 default null
101 , p_delegate_person_id in NUMBER default null
102 , p_ccselectiontext in varchar2 default null
103 , p_oafunc in varchar2 default null
104 , p_processname in varchar2 default null
105 , p_calledfrom in varchar2 default null
106 , p_frommenu in varchar2 default null
107 );
108
109
110 -- ---------------------------------------------------------------------------
111 -- ---------------------- < get_adv_search_data_from_tt> -------------------------
112 -- ---------------------------------------------------------------------------
113 -- Purpose: This procedure will get transaction data which are saved earlier
114 -- in the current transaction. This is invoked when a user click BACK
115 -- button to go back from the Review page or make further changes or
116 -- vice-versa. Hence, we need to use
117 -- the item_type item_key passed in to retrieve the transaction record.
118 -- ---------------------------------------------------------------------------
119
120 PROCEDURE get_adv_search_data_from_tt
121 (p_item_type in varchar2
122 ,p_item_key in varchar2
123 ,p_activity_id in varchar2
124 ,p_trans_rec_count out nocopy number
125 ,p_person_id out nocopy number
126 ,p_adv_search_data out nocopy varchar2
127 );
128
129 -- ---------------------------------------------------------------------------
130 -- ---------------------- < get_adv_search_data_from_tt> ---------------------
131 -- ---------------------------------------------------------------------------
132 -- Purpose: This procedure will get transaction data which are pending for
133 -- approval in workflow for a transaction step id.
134 -- This is a overloaded version
135 -- ---------------------------------------------------------------------------
136
137 procedure get_adv_search_data_from_tt
138 (p_transaction_step_id in number
139 ,p_adv_search_data out nocopy varchar2
140 );
141
142
143
144 PROCEDURE get_add_enr_dtl_data_from_tt
145 (p_item_type in varchar2
146 ,p_item_key in varchar2
147 ,p_activity_id in varchar2
148 ,p_trans_rec_count out nocopy number
149 ,p_person_id out nocopy number
150 ,p_add_enroll_detail_data out nocopy varchar2
151 );
152
153
154
155 procedure get_add_enr_dtl_data_from_tt
156 (p_transaction_step_id in number
157 ,p_add_enroll_detail_data out nocopy varchar2
158 );
159
160 PROCEDURE get_review_data_from_tt
161 (p_item_type in varchar2
162 ,p_item_key in varchar2
163 ,p_activity_id in varchar2
164 ,p_person_id out nocopy number
165 ,p_review_data out nocopy varchar2
166 );
167
168 procedure get_review_data_from_tt
169 (p_transaction_step_id in number
170 ,p_review_data out nocopy varchar2
171 );
172
173 procedure process_api
174 (p_validate IN BOOLEAN DEFAULT FALSE
175 ,p_transaction_step_id IN NUMBER DEFAULT NULL
176 ,p_effective_date in varchar2 DEFAULT NULL
177 );
178
179 procedure process_api2
180 (p_validate IN BOOLEAN DEFAULT FALSE
181 ,p_transaction_step_id IN NUMBER DEFAULT NULL
182 ,p_effective_date in varchar2 DEFAULT NULL
183 );
184
185 procedure create_enrollment
186 (itemtype in varchar2,
187 itemkey in varchar2,
188 actid in number,
189 funmode in varchar2,
190 result out nocopy varchar2 );
191
192 procedure cancel_enrollment
193 (itemtype in varchar2,
194 itemkey in varchar2,
195 actid in number,
196 funmode in varchar2,
197 result out nocopy varchar2 );
198
199 procedure validate_enrollment
200 (p_item_type in varchar2,
201 p_item_key in varchar2,
202 p_message out nocopy varchar2);
203
204 Procedure create_segment
205 (p_assignment_id in number
206 ,p_business_group_id_from in number
207 ,p_business_group_id_to in number
208 ,p_organization_id in number
209 ,p_sponsor_organization_id in number
210 ,p_event_id in number
211 ,p_person_id in number
212 ,p_currency_code in varchar2
213 ,p_cost_allocation_keyflex_id in number
214 ,p_user_id in number
215 ,p_finance_header_id out nocopy number
216 ,p_object_version_number out nocopy number
217 ,p_result out nocopy varchar2
218 ,p_from_result out nocopy varchar2
219 ,p_to_result out nocopy varchar2
220 ,p_auto_transfer in varchar2);
221
222 procedure get_min_competence
223 (p_comp_id in varchar2,
224 p_step_value out nocopy varchar2);
225
226 procedure get_max_competence
227 (p_comp_id in varchar2,
228 p_step_value out nocopy varchar2);
229
230 end ota_training_ss;