APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_WORKFLOW_SERVICE

Line 3283: ) return hr_workflow_service.active_wf_trans_items_list is

3279: (p_item_type in wf_items.item_type%type
3280: ,p_api_name in varchar2
3281: ,p_current_person_id in number
3282: ,p_result_code in varchar2
3283: ) return hr_workflow_service.active_wf_trans_items_list is
3284:
3285: -- Local cursor definitions
3286: cursor csr_pending_items is
3287: select transaction_step_id, activity_id, t.item_key

Line 3301: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;

3297: and s.activity_result_code = p_result_code;
3298:
3299: -- Local variable definitions
3300: l_count integer;
3301: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
3302: l_proc varchar2(72) := g_package||'get_pending_items';
3303: Begin
3304: hr_utility.set_location('Entering:'||l_proc, 5);
3305: l_count := 0;

Line 3328: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;

3324: ,p_process_name in varchar2
3325: ,p_activity_name in varchar2
3326: ,p_transaction_step_id out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
3327:
3328: l_active_item_keys hr_workflow_service.active_wf_trans_items_list;
3329: l_pending_count number;
3330: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
3331: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
3332: l_is_workflow_complete varchar2(1) := 'N';