APPS.HR_QUA_AWARDS_UTIL_SS dependencies on WF_ITEMS

Line 3066: (p_item_type in wf_items.item_type%type

3062: -- End of Procedure start_transaction
3063:
3064: -- Start of Function get_pending_items
3065: Function get_pending_items
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

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

3092: l_count := 0;
3093: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3094: For I in csr_pending_items Loop
3095: l_count := l_count + 1;
3096: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3097: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3098: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3099: End Loop;
3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

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

3093: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3094: For I in csr_pending_items Loop
3095: l_count := l_count + 1;
3096: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3097: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3098: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3099: End Loop;
3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3101: hr_utility.set_location('Exiting:'||l_proc, 20);

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

3094: For I in csr_pending_items Loop
3095: l_count := l_count + 1;
3096: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3097: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3098: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3099: End Loop;
3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3101: hr_utility.set_location('Exiting:'||l_proc, 20);
3102: return l_active_wf_items_list;

Line 3102: return l_active_wf_items_list;

3098: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3099: End Loop;
3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3101: hr_utility.set_location('Exiting:'||l_proc, 20);
3102: return l_active_wf_items_list;
3103: End get_pending_items;
3104:
3105: -- Start of Procedure get_pending_transaction_steps
3106: