1657: l_proc varchar2(200) := g_package || 'get_address_data_from_tt';
1658: l_transaction_id number;
1659: l_trans_step_id number;
1660: l_trans_obj_vers_num number;
1661: l_active_wf_items_tbl hr_workflow_service.active_wf_items_list;
1662: l_active_item_keys_tbl hr_workflow_service.active_wf_items_list;
1663: l_count integer default 0;
1664: -- l_trans_rec_count integer default 0;
1665: l_trans_rec_count number;
1658: l_transaction_id number;
1659: l_trans_step_id number;
1660: l_trans_obj_vers_num number;
1661: l_active_wf_items_tbl hr_workflow_service.active_wf_items_list;
1662: l_active_item_keys_tbl hr_workflow_service.active_wf_items_list;
1663: l_count integer default 0;
1664: -- l_trans_rec_count integer default 0;
1665: l_trans_rec_count number;
1666: begin
1681: --
1682: -- Following function will return a PL/SQL table which has following
1683: -- fields : Item Key, Activity ID
1684: -----------------------------------------------------------------------------
1685: l_active_wf_items_tbl := hr_workflow_service.check_active_wf_items
1686: (p_item_type => p_item_type
1687: ,p_process_name => p_process_name
1688: ,p_current_person_id => p_current_person_id
1689: ,p_activity_name => p_activity_name);