APPS.JTF_TASK_WF_UTIL dependencies on WF_ITEMS

Line 489: FROM wf_items

485: l_result VARCHAR2(1);
486:
487: CURSOR l_wf_date(b_itemtype VARCHAR2, b_itemkey wf_item_activity_statuses.item_key%TYPE) IS
488: SELECT end_date
489: FROM wf_items
490: WHERE item_type = b_itemtype AND item_key = b_itemkey;
491: BEGIN
492: l_itemkey := TO_CHAR(p_task_id) || '-' || TO_CHAR(p_workflow_process_id);
493: l_itemtype := 'JTFTASK';

Line 630: l_wf_items VARCHAR2(500);

626: l_backcomp_flag VARCHAR2(1);
627:
628: l_logged_res_id jtf_rs_resource_extns.resource_id%TYPE;
629:
630: l_wf_items VARCHAR2(500);
631: BEGIN
632: x_return_status := fnd_api.g_ret_sts_success;
633:
634: -- check whether we need to be backward-compatible for this Workflow

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

639: -- so we can bail out now
640: RETURN;
641: END IF;
642:
643: l_wf_items := wf_process(p_task_id => p_task_id);
644:
645: OPEN c_task_details;
646: FETCH c_task_details INTO l_task_rec;
647: IF c_task_details%NOTFOUND THEN

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

653: OPEN c_logged_res_id;
654: FETCH c_logged_res_id INTO l_logged_res_id;
655: CLOSE c_logged_res_id;
656:
657: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);
658: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
659:
660: --- Set global attributes so we can use this data later
661: jtf_task_wf_util.g_event := p_event;

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

654: FETCH c_logged_res_id INTO l_logged_res_id;
655: CLOSE c_logged_res_id;
656:
657: l_itemtype := SUBSTR(l_wf_items, 1, INSTR(l_wf_items, ',') - 1);
658: l_process := SUBSTR(l_wf_items, INSTR(l_wf_items, ',') + 1);
659:
660: --- Set global attributes so we can use this data later
661: jtf_task_wf_util.g_event := p_event;
662: jtf_task_wf_util.g_task_id := p_task_id;