[Home] [Help]
163: -- Purpose: This procedure is overloaded so that it will accept p_person_id
164: -- and p_called_from as parameters.
165: -- ----------------------------------------------------------------------------
166: procedure create_process
167: (p_process_name in wf_process_activities.process_name%type
168: ,p_item_type in wf_items.item_type%type
169: ,p_person_id in varchar2 default null
170: ,p_called_from in varchar2 default null
171: ,p_item_attribute in g_varchar2_tab_type
196: -- activity_result_code to a table.
197: -- ----------------------------------------------------------------------------
198: function check_active_wf_items
199: (p_item_type in wf_items.item_type%type
200: ,p_process_name in wf_process_activities.process_name%type
201: ,p_current_person_id in per_people_f.person_id%type
202: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
203: ,p_activity_result_code in varchar2
204: )
206: --
207: --
208: function check_active_wf_items
209: (p_item_type in wf_items.item_type%type
210: ,p_process_name in wf_process_activities.process_name%type
211: ,p_current_person_id in per_people_f.person_id%type
212: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
213: )
214: return active_wf_items_list;
230: -- share the same api name, which is hr_process_address_ss.
231: -- ----------------------------------------------------------------------------
232: FUNCTION get_active_wf_items
233: (p_item_type in wf_items.item_type%type
234: ,p_process_name in wf_process_activities.process_name%type
235: ,p_current_person_id in per_people_f.person_id%type
236: ,p_api_name in hr_api_transaction_steps.api_name%type
237: ,p_activity_result_code in varchar2 default null
238: ,p_address_context in varchar2 default null
247: ,funcmode in varchar2
248: ,resultout out nocopy varchar2);
249: --
250: /*procedure start_cleanup_process
251: (p_process_name in wf_process_activities.process_name%type
252: ,p_item_type in wf_items.item_type%type
253: );
254: */
255:
255:
256: procedure start_cleanup_process(
257: p_item_type in wf_items.item_type%type
258: ,p_transaction_age in wf_item_attribute_values.number_value%type
259: ,p_process_name in wf_process_activities.process_name%type default 'HR_BACKGROUND_CLEANUP_PRC',
260: p_transaction_status in varchar2 default 'ALL'
261: ) ;
262: --
263: