APPS.HR_UTIL_MISC_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2618: lv_item_type wf_item_activity_statuses.item_type%type;

2614: p_transaction_id IN VARCHAR2
2615: ,p_itemType OUT NOCOPY VARCHAR2
2616: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
2617: c_proc varchar2(30) default 'get_item_type_and_key';
2618: lv_item_type wf_item_activity_statuses.item_type%type;
2619: lv_item_key wf_item_activity_statuses.item_key%type;
2620: lv_activity_id wf_item_activity_statuses.process_activity%type;
2621: dummy varchar2(10) := null;
2622: begin

Line 2619: lv_item_key wf_item_activity_statuses.item_key%type;

2615: ,p_itemType OUT NOCOPY VARCHAR2
2616: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
2617: c_proc varchar2(30) default 'get_item_type_and_key';
2618: lv_item_type wf_item_activity_statuses.item_type%type;
2619: lv_item_key wf_item_activity_statuses.item_key%type;
2620: lv_activity_id wf_item_activity_statuses.process_activity%type;
2621: dummy varchar2(10) := null;
2622: begin
2623: g_debug := hr_utility.debug_enabled;

Line 2620: lv_activity_id wf_item_activity_statuses.process_activity%type;

2616: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
2617: c_proc varchar2(30) default 'get_item_type_and_key';
2618: lv_item_type wf_item_activity_statuses.item_type%type;
2619: lv_item_key wf_item_activity_statuses.item_key%type;
2620: lv_activity_id wf_item_activity_statuses.process_activity%type;
2621: dummy varchar2(10) := null;
2622: begin
2623: g_debug := hr_utility.debug_enabled;
2624: if g_debug then

Line 2683: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;

2679: FROM hr_api_transactions
2680: WHERE transaction_id = p_txn_id;
2681: l_transaction_ref_table VARCHAR2(50);
2682: l_transaction_ref_id NUMBER;
2683: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2684: begin
2685: g_debug := hr_utility.debug_enabled;
2686:
2687: if g_debug then