APPS.POR_CANCEL_NOTIF_PVT dependencies on WF_ITEMS

Line 15: l_itemtype wf_items.item_type%TYPE := 'PORCNWF';

11: *==========================================================================*/
12: FUNCTION Start_WF_Process(reqLineId NUMBER, contractorStatus VARCHAR2)
13: RETURN VARCHAR2 IS
14:
15: l_itemtype wf_items.item_type%TYPE := 'PORCNWF';
16: l_itemkey wf_items.item_key%TYPE;
17: l_wf_created NUMBER := 0;
18: l_wf_process varchar2(100) := 'POR_CONT_CANCEL_WF';
19: l_user_id NUMBER := 0;

Line 16: l_itemkey wf_items.item_key%TYPE;

12: FUNCTION Start_WF_Process(reqLineId NUMBER, contractorStatus VARCHAR2)
13: RETURN VARCHAR2 IS
14:
15: l_itemtype wf_items.item_type%TYPE := 'PORCNWF';
16: l_itemkey wf_items.item_key%TYPE;
17: l_wf_created NUMBER := 0;
18: l_wf_process varchar2(100) := 'POR_CONT_CANCEL_WF';
19: l_user_id NUMBER := 0;
20: l_responsibility_id NUMBER := 0;

Line 43: FROM wf_items

39: -- Check if any process created before with the same wf item type and
40: -- wf item key
41: SELECT count(*)
42: INTO l_wf_created
43: FROM wf_items
44: WHERE
45: item_type=l_itemtype AND
46: item_key = l_itemkey;
47: