DBA Data[Home] [Help]

APPS.HR_PROCESS_ADDRESS_SS dependencies on HR_WORKFLOW_SERVICE

Line 1669: l_active_wf_items_tbl hr_workflow_service.active_wf_items_list;

1665: l_proc varchar2(200) := g_package || 'get_address_data_from_tt';
1666: l_transaction_id number;
1667: l_trans_step_id number;
1668: l_trans_obj_vers_num number;
1669: l_active_wf_items_tbl hr_workflow_service.active_wf_items_list;
1670: l_active_item_keys_tbl hr_workflow_service.active_wf_items_list;
1671: l_count integer default 0;
1672: -- l_trans_rec_count integer default 0;
1673: l_trans_rec_count number;

Line 1670: l_active_item_keys_tbl hr_workflow_service.active_wf_items_list;

1666: l_transaction_id number;
1667: l_trans_step_id number;
1668: l_trans_obj_vers_num number;
1669: l_active_wf_items_tbl hr_workflow_service.active_wf_items_list;
1670: l_active_item_keys_tbl hr_workflow_service.active_wf_items_list;
1671: l_count integer default 0;
1672: -- l_trans_rec_count integer default 0;
1673: l_trans_rec_count number;
1674: begin

Line 1693: l_active_wf_items_tbl := hr_workflow_service.check_active_wf_items

1689: --
1690: -- Following function will return a PL/SQL table which has following
1691: -- fields : Item Key, Activity ID
1692: -----------------------------------------------------------------------------
1693: l_active_wf_items_tbl := hr_workflow_service.check_active_wf_items
1694: (p_item_type => p_item_type
1695: ,p_process_name => p_process_name
1696: ,p_current_person_id => p_current_person_id
1697: ,p_activity_name => p_activity_name);