APPS.OTA_COMPETENCE_SS dependencies on WF_ITEMS

Line 12: PROCEDURE check_Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

8: -- ---------------------------------------------------------------------------
9: -- |----------------------< check_Update_competence >--------------------------|
10: -- ---------------------------------------------------------------------------
11: --
12: PROCEDURE check_Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
13: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
14: actid IN NUMBER,
15: funcmode IN VARCHAR2,
16: resultout OUT nocopy VARCHAR2 );

Line 13: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

9: -- |----------------------< check_Update_competence >--------------------------|
10: -- ---------------------------------------------------------------------------
11: --
12: PROCEDURE check_Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
13: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
14: actid IN NUMBER,
15: funcmode IN VARCHAR2,
16: resultout OUT nocopy VARCHAR2 );
17:

Line 22: PROCEDURE Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

18: -- ---------------------------------------------------------------------------
19: -- |----------------------< Update_competence >--------------------------|
20: -- ---------------------------------------------------------------------------
21: --
22: PROCEDURE Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
23: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
24: actid IN NUMBER,
25: funcmode IN VARCHAR2,
26: resultout OUT nocopy VARCHAR2 );

Line 23: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

19: -- |----------------------< Update_competence >--------------------------|
20: -- ---------------------------------------------------------------------------
21: --
22: PROCEDURE Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
23: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
24: actid IN NUMBER,
25: funcmode IN VARCHAR2,
26: resultout OUT nocopy VARCHAR2 );
27:

Line 33: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

29: -- |----------------------< get_approval_req >--------------------------|
30: -- ---------------------------------------------------------------------------
31: --
32:
33: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
34: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
35: actid IN NUMBER,
36: funcmode IN VARCHAR2,
37: resultout OUT nocopy VARCHAR2 );

Line 34: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

30: -- ---------------------------------------------------------------------------
31: --
32:
33: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
34: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
35: actid IN NUMBER,
36: funcmode IN VARCHAR2,
37: resultout OUT nocopy VARCHAR2 );
38: -- ---------------------------------------------------------------------------

Line 84: p_itemtype in wf_items.item_type%type,

80: ||===========================================================================
81: */
82:
83: Procedure create_wf_process(p_process in wf_process_activities.process_name%type,
84: p_itemtype in wf_items.item_type%type,
85: p_person_id in number ,
86: p_eventid in ota_Events.event_id%type default null,
87: p_learningpath_ids in varchar2 default null,
88: p_certification_Id in number default null,

Line 89: p_itemkey out nocopy wf_items.item_key%type);

85: p_person_id in number ,
86: p_eventid in ota_Events.event_id%type default null,
87: p_learningpath_ids in varchar2 default null,
88: p_certification_Id in number default null,
89: p_itemkey out nocopy wf_items.item_key%type);
90: /*
91: ||===========================================================================
92: || PROCEDURE: save_Comptence_info
93: ||---------------------------------------------------------------------------

Line 124: p_item_type in wf_items.item_type%type,

120: */
121:
122: Procedure save_Comptence_info(
123: p_person_id in number ,
124: p_item_type in wf_items.item_type%type,
125: p_item_key in wf_items.item_key%type,
126: p_Competence_id in varchar2,
127: p_level_id in varchar2,
128: p_level_override in varchar2 default null,

Line 125: p_item_key in wf_items.item_key%type,

121:
122: Procedure save_Comptence_info(
123: p_person_id in number ,
124: p_item_type in wf_items.item_type%type,
125: p_item_key in wf_items.item_key%type,
126: p_Competence_id in varchar2,
127: p_level_id in varchar2,
128: p_level_override in varchar2 default null,
129: p_date_from in varchar2 default null,