APPS.JTF_TASK_WF_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 448: l_itemkey wf_item_activity_statuses.item_key%TYPE;

444: END list_notify_roles;
445:
446: PROCEDURE abort_previous_wf(p_task_id IN NUMBER, p_workflow_process_id IN NUMBER) IS
447: l_itemtype VARCHAR2(8);
448: l_itemkey wf_item_activity_statuses.item_key%TYPE;
449: l_context VARCHAR2(100);
450: wf_not_active EXCEPTION;
451: l_end_date DATE;
452: l_result VARCHAR2(1);

Line 454: CURSOR l_wf_date(b_itemtype VARCHAR2, b_itemkey wf_item_activity_statuses.item_key%TYPE) IS

450: wf_not_active EXCEPTION;
451: l_end_date DATE;
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

Line 511: l_itemkey wf_item_activity_statuses.item_key%TYPE;

507: l_format_mask CONSTANT VARCHAR2(80) := fnd_profile.VALUE('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS';
508:
509: l_process jtf_task_types_b.workflow%TYPE;
510: l_itemtype VARCHAR2(8) := 'JTFTASK';
511: l_itemkey wf_item_activity_statuses.item_key%TYPE;
512: l_wf_process_id NUMBER;
513:
514: CURSOR c_task_details IS
515: SELECT t.task_number