[Home] [Help]
931: -- Method to initialize the session apps context if there is no context already
932: -- set.
933: -- The method checks the current session context userid ,
934: -- If the userid is not same stored in the item attribute HR_USER_ID_ATTR
935: -- then the fnd_global.apps_initialize called with
936: -- user id as stored in the item attribute HR_USER_ID_ATTR.
937: -- ------------------------------------------------------------------------
938:
939:
960: ) THEN
961: -- Code that compares current session context
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',
961: -- Code that compares current session context
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);
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:
1052: ,p_name => 'HR_USER_ID_ATTR');
1053: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1054: itemkey => p_item_key,
1055: aname => 'HR_USER_ID_ATTR',
1056: avalue => FND_GLOBAL.USER_ID ) ;
1057: -- get the resp_id, FND_GLOBAL.RESP_ID
1058: hr_approval_wf.create_item_attrib_if_notexist
1059: (p_item_type => p_item_type
1060: ,p_item_key => p_item_key
1053: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1054: itemkey => p_item_key,
1055: aname => 'HR_USER_ID_ATTR',
1056: avalue => FND_GLOBAL.USER_ID ) ;
1057: -- get the resp_id, FND_GLOBAL.RESP_ID
1058: hr_approval_wf.create_item_attrib_if_notexist
1059: (p_item_type => p_item_type
1060: ,p_item_key => p_item_key
1061: ,p_name => 'HR_RESP_ID_ATTR');
1061: ,p_name => 'HR_RESP_ID_ATTR');
1062: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1063: itemkey => p_item_key,
1064: aname => 'HR_RESP_ID_ATTR',
1065: avalue => FND_GLOBAL.RESP_ID ) ;
1066:
1067: -- get resp_appl_id , FND_GLOBAL.RESP_APPL_ID
1068: hr_approval_wf.create_item_attrib_if_notexist
1069: (p_item_type => p_item_type
1063: itemkey => p_item_key,
1064: aname => 'HR_RESP_ID_ATTR',
1065: avalue => FND_GLOBAL.RESP_ID ) ;
1066:
1067: -- get resp_appl_id , FND_GLOBAL.RESP_APPL_ID
1068: hr_approval_wf.create_item_attrib_if_notexist
1069: (p_item_type => p_item_type
1070: ,p_item_key => p_item_key
1071: ,p_name => 'HR_RESP_APPL_ID_ATTR');
1071: ,p_name => 'HR_RESP_APPL_ID_ATTR');
1072: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1073: itemkey => p_item_key,
1074: aname => 'HR_RESP_APPL_ID_ATTR',
1075: avalue => FND_GLOBAL.RESP_APPL_ID ) ;
1076: hr_approval_wf.create_item_attrib_if_notexist
1077: (p_item_type => p_item_type
1078: ,p_item_key => p_item_key
1079: ,p_name => 'HR_DEFER_COMMIT_ATTR');
1526:
1527: if(lv_restrict_edit_to_owner='Y') then
1528: hr_utility.set_location('process configured to restrict edit to owner/creator, no edit so returning',4);
1529: -- get the current login user name and compare with the creator user name
1530: if(fnd_global.USER_NAME=wf_engine.GetItemAttrText(itemtype=>lv_item_type,
1531: itemkey=>lv_item_key,
1532: aname=>'CREATOR_PERSON_USERNAME',
1533: ignore_notfound=>TRUE))then
1534: null;
2374:
2375:
2376: -- check if the ln_nextApprover_person_id is null
2377: if(ln_nextApprover_person_id is null) then
2378: return fnd_global.user_name;
2379: else
2380: wf_directory.GetUserName(p_orig_system => 'PER'
2381: ,p_orig_system_id => ln_nextApprover_person_id
2382: ,p_name => ln_nextApprover_userName