APPS.OTA_LP_NOTIFY_SS dependencies on WF_ITEMS

Line 54: l_item_type wf_items.item_type%type := 'OTWF';

50: )
51: IS
52: l_proc varchar2(72) := g_package||'create_wf_process';
53: l_process wf_activities.name%type :='OTA_LRNG_PATH_NOTIFY_PRC';
54: l_item_type wf_items.item_type%type := 'OTWF';
55: l_item_key wf_items.item_key%type;
56:
57:
58: l_user_name varchar2(80);

Line 55: l_item_key wf_items.item_key%type;

51: IS
52: l_proc varchar2(72) := g_package||'create_wf_process';
53: l_process wf_activities.name%type :='OTA_LRNG_PATH_NOTIFY_PRC';
54: l_item_type wf_items.item_type%type := 'OTWF';
55: l_item_key wf_items.item_key%type;
56:
57:
58: l_user_name varchar2(80);
59: l_creator_person_name PER_ALL_PEOPLE_F.full_name%TYPE;

Line 356: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE

352:
353: end create_wf_process;
354:
355: PROCEDURE get_notification_type
356: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
357: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
358: ,actid IN NUMBER
359: ,funcmode IN VARCHAR2
360: ,resultout OUT nocopy VARCHAR2 ) AS

Line 357: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE

353: end create_wf_process;
354:
355: PROCEDURE get_notification_type
356: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
357: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
358: ,actid IN NUMBER
359: ,funcmode IN VARCHAR2
360: ,resultout OUT nocopy VARCHAR2 ) AS
361:

Line 377: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE

373: END IF;
374: END get_notification_type;
375:
376: PROCEDURE is_Manager_enrolled_path
377: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
378: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
379: ,actid IN NUMBER
380: ,funcmode IN VARCHAR2
381: ,resultout OUT nocopy VARCHAR2 ) AS

Line 378: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE

374: END get_notification_type;
375:
376: PROCEDURE is_Manager_enrolled_path
377: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
378: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
379: ,actid IN NUMBER
380: ,funcmode IN VARCHAR2
381: ,resultout OUT nocopy VARCHAR2 ) AS
382:

Line 445: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE

441: --
442: END is_Manager_enrolled_path;
443:
444: PROCEDURE is_Manager_same_as_creator
445: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
446: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
447: ,actid IN NUMBER
448: ,funcmode IN VARCHAR2
449: ,resultout OUT nocopy VARCHAR2 ) AS

Line 446: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE

442: END is_Manager_enrolled_path;
443:
444: PROCEDURE is_Manager_same_as_creator
445: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
446: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
447: ,actid IN NUMBER
448: ,funcmode IN VARCHAR2
449: ,resultout OUT nocopy VARCHAR2 ) AS
450: l_lp_enrollment_id OTA_LP_ENROLLMENTS.lp_enrollment_id%TYPE;

Line 518: FROM wf_items

514: RETURN BOOLEAN
515: IS
516: CURSOR csr_notification_sent IS
517: SELECT 1
518: FROM wf_items
519: WHERE item_type = 'OTWF'
520: AND item_key = p_itemkey;
521:
522: l_sent number;