APPS.HR_QUA_AWARDS_UTIL_SS dependencies on WF_ITEMS

Line 3279: (p_item_type in wf_items.item_type%type

3275: -- End of Procedure start_transaction
3276:
3277: -- Start of Function get_pending_items
3278: Function get_pending_items
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

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 3309: l_active_wf_items_list(l_count).active_item_key := I.item_key;

3305: l_count := 0;
3306: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3307: For I in csr_pending_items Loop
3308: l_count := l_count + 1;
3309: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3312: End Loop;
3313: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

Line 3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;

3306: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3307: For I in csr_pending_items Loop
3308: l_count := l_count + 1;
3309: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3312: End Loop;
3313: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3314: hr_utility.set_location('Exiting:'||l_proc, 20);

Line 3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;

3307: For I in csr_pending_items Loop
3308: l_count := l_count + 1;
3309: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3312: End Loop;
3313: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3314: hr_utility.set_location('Exiting:'||l_proc, 20);
3315: return l_active_wf_items_list;

Line 3315: return l_active_wf_items_list;

3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3312: End Loop;
3313: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3314: hr_utility.set_location('Exiting:'||l_proc, 20);
3315: return l_active_wf_items_list;
3316: End get_pending_items;
3317:
3318: -- Start of Procedure get_pending_transaction_steps
3319: