eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_COMPETENCE_SS dependencies on WF_ITEMS

Line 248: p_item_type in wf_items.item_type%type,

244: -- ---------------------------------------------------------------------------
245: --
246: Procedure save_Comptence_info(
247: p_person_id in number ,
248: p_item_type in wf_items.item_type%type,
249: p_item_key in wf_items.item_key%type,
250: p_Competence_id in varchar2,
251: p_level_id in varchar2,
252: p_level_override in varchar2,

Line 249: p_item_key in wf_items.item_key%type,

245: --
246: Procedure save_Comptence_info(
247: p_person_id in number ,
248: p_item_type in wf_items.item_type%type,
249: p_item_key in wf_items.item_key%type,
250: p_Competence_id in varchar2,
251: p_level_id in varchar2,
252: p_level_override in varchar2,
253: p_date_from in varchar2,

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

496: -- ---------------------------------------------------------------------------
497: -- |----------------------< Update_competence >--------------------------|
498: -- ---------------------------------------------------------------------------
499: --
500: PROCEDURE Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
501: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
502: actid IN NUMBER,
503: funcmode IN VARCHAR2,
504: resultout OUT nocopy VARCHAR2 )

Line 501: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

497: -- |----------------------< Update_competence >--------------------------|
498: -- ---------------------------------------------------------------------------
499: --
500: PROCEDURE Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
501: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
502: actid IN NUMBER,
503: funcmode IN VARCHAR2,
504: resultout OUT nocopy VARCHAR2 )
505: is

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

588: -- ---------------------------------------------------------------------------
589: -- |----------------------< check_Update_competence >--------------------------|
590: -- ---------------------------------------------------------------------------
591: --
592: PROCEDURE check_Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
593: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
594: actid IN NUMBER,
595: funcmode IN VARCHAR2,
596: resultout OUT nocopy VARCHAR2 )

Line 593: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

589: -- |----------------------< check_Update_competence >--------------------------|
590: -- ---------------------------------------------------------------------------
591: --
592: PROCEDURE check_Update_competence ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
593: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
594: actid IN NUMBER,
595: funcmode IN VARCHAR2,
596: resultout OUT nocopy VARCHAR2 )
597: is

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

680: -- ---------------------------------------------------------------------------
681: -- |----------------------< get_approval_req >--------------------------|
682: -- ---------------------------------------------------------------------------
683: --
684: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
685: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
686: actid IN NUMBER,
687: funcmode IN VARCHAR2,
688: resultout OUT nocopy VARCHAR2 )

Line 685: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

681: -- |----------------------< get_approval_req >--------------------------|
682: -- ---------------------------------------------------------------------------
683: --
684: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
685: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
686: actid IN NUMBER,
687: funcmode IN VARCHAR2,
688: resultout OUT nocopy VARCHAR2 )
689: IS

Line 1401: p_itemtype in wf_items.item_type%type,

1397: -- ---------------------------------------------------------------------------
1398: --
1399:
1400: Procedure create_wf_process(p_process in wf_process_activities.process_name%type,
1401: p_itemtype in wf_items.item_type%type,
1402: p_person_id in number ,
1403: p_eventid in ota_Events.event_id%type,
1404: p_learningpath_ids in varchar2 ,
1405: p_certification_Id in number default null,

Line 1406: p_itemkey out nocopy wf_items.item_key%type)

1402: p_person_id in number ,
1403: p_eventid in ota_Events.event_id%type,
1404: p_learningpath_ids in varchar2 ,
1405: p_certification_Id in number default null,
1406: p_itemkey out nocopy wf_items.item_key%type)
1407: is
1408:
1409: l_proc varchar2(72) := g_package||'create_wf_process';
1410: l_process wf_activities.name%type := upper(p_process);

Line 1411: l_item_type wf_items.item_type%type := upper(p_itemtype);

1407: is
1408:
1409: l_proc varchar2(72) := g_package||'create_wf_process';
1410: l_process wf_activities.name%type := upper(p_process);
1411: l_item_type wf_items.item_type%type := upper(p_itemtype);
1412: l_item_key wf_items.item_key%type;
1413:
1414: l_LP_ids varchar2(4000) := p_learningpath_ids;
1415:

Line 1412: l_item_key wf_items.item_key%type;

1408:
1409: l_proc varchar2(72) := g_package||'create_wf_process';
1410: l_process wf_activities.name%type := upper(p_process);
1411: l_item_type wf_items.item_type%type := upper(p_itemtype);
1412: l_item_key wf_items.item_key%type;
1413:
1414: l_LP_ids varchar2(4000) := p_learningpath_ids;
1415:
1416: l_LP_startPos number(15):=1;