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_learner_full_name varchar2(240);

Line 377: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE

373:
374: end create_wf_process;
375:
376: PROCEDURE get_notification_type
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 create_wf_process;
375:
376: PROCEDURE get_notification_type
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 398: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE

394: END IF;
395: END get_notification_type;
396:
397: PROCEDURE is_Manager_enrolled_path
398: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
399: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
400: ,actid IN NUMBER
401: ,funcmode IN VARCHAR2
402: ,resultout OUT nocopy VARCHAR2 ) AS

Line 399: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE

395: END get_notification_type;
396:
397: PROCEDURE is_Manager_enrolled_path
398: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
399: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
400: ,actid IN NUMBER
401: ,funcmode IN VARCHAR2
402: ,resultout OUT nocopy VARCHAR2 ) AS
403:

Line 466: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE

462: --
463: END is_Manager_enrolled_path;
464:
465: PROCEDURE is_Manager_same_as_creator
466: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
467: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
468: ,actid IN NUMBER
469: ,funcmode IN VARCHAR2
470: ,resultout OUT nocopy VARCHAR2 ) AS

Line 467: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE

463: END is_Manager_enrolled_path;
464:
465: PROCEDURE is_Manager_same_as_creator
466: (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
467: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
468: ,actid IN NUMBER
469: ,funcmode IN VARCHAR2
470: ,resultout OUT nocopy VARCHAR2 ) AS
471: l_lp_enrollment_id OTA_LP_ENROLLMENTS.lp_enrollment_id%TYPE;

Line 539: FROM wf_items

535: RETURN BOOLEAN
536: IS
537: CURSOR csr_notification_sent IS
538: SELECT 1
539: FROM wf_items
540: WHERE item_type = 'OTWF'
541: AND item_key = p_itemkey;
542:
543: l_sent number;