DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SERVICE dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 23: activity_result_code wf_item_activity_statuses_v.activity_result_code%type,

19: g_varchar2_tab_default g_varchar2_tab_type;
20: --
21: TYPE active_wf_items_rec IS RECORD (
22: active_item_key wf_items.item_key%type,
23: activity_result_code wf_item_activity_statuses_v.activity_result_code%type,
24: activity_id wf_item_activity_statuses_v.activity_id%type
25: );
26: --
27: TYPE active_wf_items_list IS TABLE OF active_wf_items_rec INDEX BY BINARY_INTEGER;

Line 24: activity_id wf_item_activity_statuses_v.activity_id%type

20: --
21: TYPE active_wf_items_rec IS RECORD (
22: active_item_key wf_items.item_key%type,
23: activity_result_code wf_item_activity_statuses_v.activity_result_code%type,
24: activity_id wf_item_activity_statuses_v.activity_id%type
25: );
26: --
27: TYPE active_wf_items_list IS TABLE OF active_wf_items_rec INDEX BY BINARY_INTEGER;
28: --

Line 31: ,activity_id wf_item_activity_statuses_v.activity_id%type

27: TYPE active_wf_items_list IS TABLE OF active_wf_items_rec INDEX BY BINARY_INTEGER;
28: --
29: TYPE active_wf_trans_items_rec IS RECORD (
30: active_item_key wf_items.item_key%type
31: ,activity_id wf_item_activity_statuses_v.activity_id%type
32: ,trans_step_id hr_api_transaction_steps.transaction_step_id %type
33: ,activity_result_code
34: wf_item_activity_statuses_v.activity_result_code%type
35: );

Line 34: wf_item_activity_statuses_v.activity_result_code%type

30: active_item_key wf_items.item_key%type
31: ,activity_id wf_item_activity_statuses_v.activity_id%type
32: ,trans_step_id hr_api_transaction_steps.transaction_step_id %type
33: ,activity_result_code
34: wf_item_activity_statuses_v.activity_result_code%type
35: );
36: --
37: TYPE active_wf_trans_items_list IS TABLE OF active_wf_trans_items_rec
38: INDEX BY BINARY_INTEGER;

Line 159: return wf_item_activity_statuses_v.activity_result_code%type;

155: function get_activity_reentry_value
156: (p_item_type in wf_items.item_type%type
157: ,p_item_key in wf_items.item_key%type
158: ,p_actid in wf_activity_attr_values.process_activity_id%type)
159: return wf_item_activity_statuses_v.activity_result_code%type;
160: -- ----------------------------------------------------------------------------
161: -- |------------------------------< create_process >--------------------------|
162: -- ----------------------------------------------------------------------------
163: -- Purpose: This procedure is overloaded so that it will accept p_person_id

Line 190: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type);

186: procedure transition_activity
187: (p_item_type in wf_items.item_type%type
188: ,p_item_key in wf_items.item_key%type
189: ,p_actid in wf_activity_attr_values.process_activity_id%type
190: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type);
191: -- ----------------------------------------------------------------------------
192: -- |-------------------------< check_active_wf_items >-- ---------------------|
193: -- ----------------------------------------------------------------------------
194: -- Purpose: This function is overloaded. It will only return the pending

Line 202: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

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: )
205: return active_wf_items_list;
206: --

Line 212: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

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;
215: --
216: -- ----------------------------------------------------------------------------