APPS.JTF_TASK_WF_UTIL dependencies on WF_ITEMS

Line 456: FROM wf_items

452: l_result VARCHAR2(1);
453:
454: CURSOR l_wf_date(b_itemtype VARCHAR2, b_itemkey wf_item_activity_statuses.item_key%TYPE) IS
455: SELECT end_date
456: FROM wf_items
457: WHERE item_type = b_itemtype AND item_key = b_itemkey;
458: BEGIN
459: l_itemkey := TO_CHAR(p_task_id) || '-' || TO_CHAR(p_workflow_process_id);
460: l_itemtype := 'JTFTASK';

Line 597: l_wf_items VARCHAR2(500);

593: l_backcomp_flag VARCHAR2(1);
594:
595: l_logged_res_id jtf_rs_resource_extns.resource_id%TYPE;
596:
597: l_wf_items VARCHAR2(500);
598: BEGIN
599: x_return_status := fnd_api.g_ret_sts_success;
600:
601: -- check whether we need to be backward-compatible for this Workflow

Line 610: l_wf_items := wf_process(p_task_id => p_task_id);

606: -- so we can bail out now
607: RETURN;
608: END IF;
609:
610: l_wf_items := wf_process(p_task_id => p_task_id);
611:
612: OPEN c_task_details;
613: FETCH c_task_details INTO l_task_rec;
614: IF c_task_details%NOTFOUND THEN

Line 624: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);

620: OPEN c_logged_res_id;
621: FETCH c_logged_res_id INTO l_logged_res_id;
622: CLOSE c_logged_res_id;
623:
624: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);
625: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
626:
627: --- Set global attributes so we can use this data later
628: jtf_task_wf_util.g_event := p_event;

Line 625: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);

621: FETCH c_logged_res_id INTO l_logged_res_id;
622: CLOSE c_logged_res_id;
623:
624: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);
625: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
626:
627: --- Set global attributes so we can use this data later
628: jtf_task_wf_util.g_event := p_event;
629: jtf_task_wf_util.g_task_id := p_task_id;