APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_WORKFLOW_SERVICE

Line 3070: ) return hr_workflow_service.active_wf_trans_items_list is

3066: (p_item_type in wf_items.item_type%type
3067: ,p_api_name in varchar2
3068: ,p_current_person_id in number
3069: ,p_result_code in varchar2
3070: ) return hr_workflow_service.active_wf_trans_items_list is
3071:
3072: -- Local cursor definitions
3073: cursor csr_pending_items is
3074: select transaction_step_id, activity_id, t.item_key

Line 3088: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;

3084: and s.activity_result_code = p_result_code;
3085:
3086: -- Local variable definitions
3087: l_count integer;
3088: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
3089: l_proc varchar2(72) := g_package||'get_pending_items';
3090: Begin
3091: hr_utility.set_location('Entering:'||l_proc, 5);
3092: l_count := 0;

Line 3115: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;

3111: ,p_process_name in varchar2
3112: ,p_activity_name in varchar2
3113: ,p_transaction_step_id out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
3114:
3115: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;
3116: l_pending_count number;
3117: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3118: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
3119: l_is_workflow_complete varchar2(1) := 'N';