DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SS dependencies on FND_USER

Line 951: l_fnd_user_id fnd_user.user_id%type default null;

947: IS
948: l_user_id NUMBER;
949: l_resp_id NUMBER;
950: l_resp_appl_id NUMBER;
951: l_fnd_user_id fnd_user.user_id%type default null;
952: l_session_user_id varchar2(100);
953: l_session_resp_id NUMBER;
954: BEGIN
955:

Line 966: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,

962: -- with the work item context required to execute
963: -- the workflow safely
964: l_session_user_id := FND_GLOBAL.USER_ID;
965: l_session_resp_id := FND_GLOBAL.RESP_ID;
966: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,
967: itemkey =>p_itemkey,
968: aname =>'HR_USER_ID_ATTR',
969: ignore_notfound=>true);
970:

Line 976: IF ((l_session_user_id = l_fnd_user_id) and (l_session_resp_id = l_resp_id)) then

972: itemkey =>p_itemkey,
973: aname =>'HR_RESP_ID_ATTR',
974: ignore_notfound=>true);
975:
976: IF ((l_session_user_id = l_fnd_user_id) and (l_session_resp_id = l_resp_id)) then
977: -- session already has proper values ignore reset
978: p_result := 'COMPLETE';
979: else
980: -- HR_RESP_ID_ATTR

Line 992: fnd_global.apps_initialize(user_id =>l_fnd_user_id,

988: aname =>'HR_RESP_APPL_ID_ATTR',
989: ignore_notfound=>true);
990:
991: -- set the fnd session context with the last approver user id
992: fnd_global.apps_initialize(user_id =>l_fnd_user_id,
993: resp_id =>l_resp_id,
994: resp_appl_id=> l_resp_appl_id);
995:
996:

Line 2413: l_username fnd_user.user_name%TYPE default null;

2409: orig_recipient varchar2(320);
2410: from_role varchar2(320);
2411: more_info_role varchar2(320);
2412:
2413: l_username fnd_user.user_name%TYPE default null;
2414: userRoles Wf_Directory.RoleTable;
2415: matchFound boolean;
2416: begin
2417: