DBA Data[Home] [Help]

APPS.HR_APPROVAL_SS dependencies on WF_DIRECTORY

Line 452: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);

448:
449:
450:
451: if g_debug then
452: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);
453: end if;
454:
455: wf_directory.GetRoleName--GetUserName
456: (p_orig_system => l_current_forward_to_origSys

Line 455: wf_directory.GetRoleName--GetUserName

451: if g_debug then
452: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);
453: end if;
454:
455: wf_directory.GetRoleName--GetUserName
456: (p_orig_system => l_current_forward_to_origSys
457: ,p_orig_system_id => l_current_forward_to_id
458: ,p_name => l_current_forward_to_username
459: ,p_display_name => l_current_forward_to_disp_name);

Line 541: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);

537: -- Get the username and display name for forward from person
538: -- and save to item attributes
539: --
540: if g_debug then
541: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);
542: end if;
543: wf_directory.GetRoleName--GetUserName
544: (p_orig_system => l_current_forward_to_origSys
545: ,p_orig_system_id => l_current_forward_to_id

Line 543: wf_directory.GetRoleName--GetUserName

539: --
540: if g_debug then
541: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);
542: end if;
543: wf_directory.GetRoleName--GetUserName
544: (p_orig_system => l_current_forward_to_origSys
545: ,p_orig_system_id => l_current_forward_to_id
546: ,p_name => l_current_forward_to_username
547: ,p_display_name => l_current_forward_to_disp_name);

Line 1045: wf_directory.GetRoleName--GetUserName

1041:
1042:
1043: -- derive wf role details for the selected person id
1044: if ( l_forward_to_person_id is not null ) then
1045: wf_directory.GetRoleName--GetUserName
1046: (p_orig_system => 'PER'
1047: ,p_orig_system_id => l_forward_to_person_id
1048: ,p_name => p_approver_rec.name
1049: ,p_display_name => p_approver_rec.display_name);

Line 1742: l_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;

1738: is
1739: -- local variables
1740: c_proc constant varchar2(60) := 'populatePrllApprDetails';
1741: l_users varchar2(1000) := null;
1742: l_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
1743:
1744: begin
1745: g_debug := hr_utility.debug_enabled;
1746:

Line 1751: wf_directory.GetRoleInfo2(p_role_name,l_approver_role_info_tbl);

1747: if g_debug then
1748: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1749: end if;
1750:
1751: wf_directory.GetRoleInfo2(p_role_name,l_approver_role_info_tbl);
1752:
1753: if g_debug then
1754: hr_utility.set_location('l_approver_role_info_tbl(1).name : '|| l_approver_role_info_tbl(1).name, 999);
1755: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system : '|| l_approver_role_info_tbl(1).orig_system, 999);

Line 1987: wf_directory.RemoveUsersFromAdHocRole

1983: IF c_next_approvers.COUNT <> 0 then
1984: -- Check if the ADHOC role already exists
1985: IF l_role_exists = 'Y' THEN
1986: -- If the role exists, then empty the existing role list
1987: wf_directory.RemoveUsersFromAdHocRole
1988: (role_name => l_role_name,
1989: role_users => NULL);
1990:
1991: -- Add the users we have identified to the role list.

Line 1992: wf_directory.AddUsersToAdHocRole

1988: (role_name => l_role_name,
1989: role_users => NULL);
1990:
1991: -- Add the users we have identified to the role list.
1992: wf_directory.AddUsersToAdHocRole
1993: (role_name => l_role_name,
1994: role_users => l_users);
1995: ELSE
1996: -- Create an ADHOC role for the approver list and add the

Line 1998: wf_directory.CreateAdHocRole

1994: role_users => l_users);
1995: ELSE
1996: -- Create an ADHOC role for the approver list and add the
1997: -- users.
1998: wf_directory.CreateAdHocRole
1999: (role_name => l_role_name,
2000: role_display_name => l_role_display,
2001: role_users => l_users,
2002: expiration_date => NULL);

Line 2170: wf_directory.GetRoleName

2166: ,itemkey => p_item_key
2167: ,aname => 'FORWARD_TO_ORIG_SYS_ATTR'
2168: ,ignore_notfound=>true),'PER');
2169:
2170: wf_directory.GetRoleName
2171: (p_orig_system => lv_role_orig_system
2172: ,p_orig_system_id => lv_role_orig_sys_id
2173: ,p_name => lv_role_name
2174: ,p_display_name => lv_role_disp_name);

Line 3257: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));

3253: --reset wf attributes
3254:
3255: wf_engine.setItemAttrNumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',rec_forwardee.orig_system_id);
3256: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USERNAME',wf_engine.context_new_role);
3257: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3258: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USER',getToString(p_item_key) || wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3259:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);

Line 3258: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USER',getToString(p_item_key) || wf_directory.GetRoleDisplayName(wf_engine.context_new_role));

3254:
3255: wf_engine.setItemAttrNumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',rec_forwardee.orig_system_id);
3256: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USERNAME',wf_engine.context_new_role);
3257: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3258: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USER',getToString(p_item_key) || wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3259:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);

Line 3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;

3618: c_return_user wf_users.name%Type;
3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3624: l_is_parallel varchar2(10) := null;
3625:
3626: begin

Line 3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;

3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3624: l_is_parallel varchar2(10) := null;
3625:
3626: begin
3627: g_debug := hr_utility.debug_enabled;

Line 3657: wf_directory.GetRoleInfo2(c_return_user,c_return_user_role_info_tbl);

3653: hr_utility.set_location('c_creator_user' || c_creator_user,111);
3654:
3655:
3656: -- get the return to user orig system and sys id
3657: wf_directory.GetRoleInfo2(c_return_user,c_return_user_role_info_tbl);
3658:
3659: l_is_parallel := wf_engine.GetItemAttrText(itemtype => p_item_type ,
3660: itemkey => p_item_key,
3661: aname => 'HR_PARALLEL_ATTR',

Line 3687: wf_directory.GetRoleInfo2(l_curr_approver_role,l_curr_approver_role_info_tbl);

3683: ---- get the current approver orig system and sys id
3684:
3685: hr_utility.set_location('l_curr_approver_role' || l_curr_approver_role,111);
3686:
3687: wf_directory.GetRoleInfo2(l_curr_approver_role,l_curr_approver_role_info_tbl);
3688:
3689: hr_utility.set_location('l_curr_approver_role_info_tbl(1).display_name' || l_curr_approver_role_info_tbl(1).display_name,111);
3690: hr_utility.set_location('c_return_user_role_info_tbl(1).display_name' || c_return_user_role_info_tbl(1).display_name,111);
3691:

Line 4016: lv_role_displayName :=wf_directory.getroledisplayname(p_user_name);

4012: if g_debug then
4013: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4014: end if;
4015: if(p_orig_system is null or p_orig_system_id is null) then
4016: lv_role_displayName :=wf_directory.getroledisplayname(p_user_name);
4017: else
4018: wf_directory.GetRoleName
4019: (p_orig_system => p_orig_system
4020: ,p_orig_system_id => p_orig_system_id

Line 4018: wf_directory.GetRoleName

4014: end if;
4015: if(p_orig_system is null or p_orig_system_id is null) then
4016: lv_role_displayName :=wf_directory.getroledisplayname(p_user_name);
4017: else
4018: wf_directory.GetRoleName
4019: (p_orig_system => p_orig_system
4020: ,p_orig_system_id => p_orig_system_id
4021: ,p_name => lv_roleName
4022: ,p_display_name => lv_role_displayName);

Line 4057: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_systemId);

4053: lv_orig_systemId := p_orig_system_id;
4054:
4055: if(p_orig_system_id is null) then
4056: if(p_user_name is not null) then
4057: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_systemId);
4058: end if;
4059: end if;
4060:
4061: -- need to revisit the functionality once the AME functionality

Line 4116: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_system_id);

4112: if g_debug then
4113: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4114: end if;
4115: if(p_notification_id is null) then
4116: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_system_id);
4117: else
4118: -- get the original recipient role name
4119: select original_recipient
4120: into lv_user_name

Line 4124: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);

4120: into lv_user_name
4121: from wf_notifications
4122: where notification_id =p_notification_id;
4123:
4124: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);
4125: end if;
4126:
4127: return lv_orig_system;
4128:

Line 4150: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_system_id);

4146: if g_debug then
4147: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4148: end if;
4149: if(p_notification_id is null) then
4150: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_system_id);
4151: else
4152: -- get the original recipient role name
4153: select original_recipient
4154: into lv_user_name

Line 4158: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);

4154: into lv_user_name
4155: from wf_notifications
4156: where notification_id =p_notification_id;
4157:
4158: wf_directory.getroleorigsysinfo(lv_user_name,lv_orig_system,lv_orig_system_id);
4159: end if;
4160:
4161: return lv_orig_system_id;
4162:

Line 4254: wf_directory.GetRoleName--GetUserName

4250: hr_approval_ss.reinitperformerroles(p_notification_id=>null
4251: ,p_transaction_id=>null
4252: ,p_item_type=>p_item_type
4253: ,p_item_key=>p_item_key);
4254: wf_directory.GetRoleName--GetUserName
4255: (p_orig_system => p_rfcUserOrigSystem
4256: ,p_orig_system_id => p_rfcUserOrigSystemId
4257: ,p_name => lv_role_name
4258: ,p_display_name => lv_role_disp_name);

Line 4478: wf_directory.getroleorigsysinfo(lv_creator_role,

4474: lv_creator_role := wf_engine.getitemattrtext(lv_item_type,
4475: lv_item_key,
4476: 'CREATOR_PERSON_USERNAME');
4477: -- get the orig sys info
4478: wf_directory.getroleorigsysinfo(lv_creator_role,
4479: lv_creator_orig_system,
4480: lv_creator_orig_sys_id);
4481:
4482: handleRFCAction(p_approval_notification_id =>p_approval_notification_id,

Line 4513: wf_directory.GetRoleName

4509: if(lv_role_orig_sys_id is not null) then
4510: -- need to revisit with role based support in SSHR transaction
4511: lv_role_orig_system := 'PER';
4512:
4513: wf_directory.GetRoleName
4514: (p_orig_system => lv_role_orig_system
4515: ,p_orig_system_id => lv_role_orig_sys_id
4516: ,p_name => lv_role_name
4517: ,p_display_name => lv_role_disp_name);

Line 4556: wf_directory.GetRoleName

4552:
4553: if(lv_role_orig_sys_id is not null) then
4554: -- need to revisit with role based support in SSHR transaction
4555: lv_role_orig_system := 'PER';
4556: wf_directory.GetRoleName
4557: (p_orig_system => lv_role_orig_system
4558: ,p_orig_system_id => lv_role_orig_sys_id
4559: ,p_name => lv_role_name
4560: ,p_display_name => lv_role_disp_name);

Line 4600: wf_directory.GetRoleName

4596: ,itemkey => p_item_key
4597: ,aname => 'FORWARD_FROM_ORIG_SYS_ATTR'
4598: ,ignore_notfound=>true),'PER');
4599:
4600: wf_directory.GetRoleName
4601: (p_orig_system => lv_role_orig_system
4602: ,p_orig_system_id => lv_role_orig_sys_id
4603: ,p_name => lv_role_name
4604: ,p_display_name => lv_role_disp_name);

Line 4647: wf_directory.GetRoleName

4643: ,itemkey => p_item_key
4644: ,aname => 'RETURN_TO_USER_ORIG_SYS'
4645: ,ignore_notfound=>true);
4646:
4647: wf_directory.GetRoleName
4648: (p_orig_system => lv_role_orig_system
4649: ,p_orig_system_id => lv_role_orig_sys_id
4650: ,p_name => lv_role_name
4651: ,p_display_name => lv_role_disp_name);

Line 4703: wf_directory.GetRoleName

4699: lv_role_orig_system := 'PER';
4700:
4701: -- derive the role for HR_APPRAISEE_USER_NAME_ATTR
4702: if((l_appraisee_person_id is not null)and (l_appraisee_person_id<>'')) then
4703: wf_directory.GetRoleName
4704: (p_orig_system => lv_role_orig_system
4705: ,p_orig_system_id => l_appraisee_person_id
4706: ,p_name => lv_role_name
4707: ,p_display_name => lv_role_disp_name);

Line 4721: wf_directory.GetRoleName

4717: end if;
4718:
4719: -- derive the role for HR_MAIN_APPRAISER_USERNAME
4720: if(l_main_appraiser_id is not null) then
4721: wf_directory.GetRoleName
4722: (p_orig_system => lv_role_orig_system
4723: ,p_orig_system_id => l_main_appraiser_id
4724: ,p_name => lv_role_name
4725: ,p_display_name => lv_role_disp_name);

Line 4739: wf_directory.GetRoleName

4735: end if;
4736:
4737: -- derive the role for SUPERVISOR_USERNAME
4738: if(l_appraiser_person_id is not null) then
4739: wf_directory.GetRoleName
4740: (p_orig_system => lv_role_orig_system
4741: ,p_orig_system_id => l_appraiser_person_id
4742: ,p_name => lv_role_name
4743: ,p_display_name => lv_role_disp_name);

Line 4938: wf_directory.getrolename

4934: l_suffix(3) := 'DISPLAY_NAME';
4935: l_suffix(4) := 'ORIG_SYS';
4936: -- get the USERNAME and DISPLAY_NAME from workflow
4937: begin
4938: wf_directory.getrolename
4939: (p_orig_system => p_service_orig_sys
4940: ,p_orig_system_id => p_service_orig_sys_id
4941: ,p_name => l_username
4942: ,p_display_name => l_display_name);

Line 5233: wf_directory.getRoleName

5229: --
5230: -- ---------------------------------
5231: -- Get the Role for the Owner
5232: -- ---------------------------------
5233: wf_directory.getRoleName
5234: (p_orig_system => 'PER'
5235: ,p_orig_system_id => lr_transaction_rec.creator_person_id
5236: ,p_name => l_role_name
5237: ,p_display_name => l_role_displayname);

Line 5350: wf_directory.getusername

5346: -- appraisal specfic
5347:
5348: -- set the item attributes specific to appraisals
5349: -- get the wf role info for the login user
5350: wf_directory.getusername
5351: (p_orig_system => 'PER'
5352: ,p_orig_system_id => fnd_global.employee_id
5353: ,p_name => lv_loginPersonUserName
5354: ,p_display_name => lv_loginPersonDispName);

Line 6164: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(l_current_forward_to_username1));

6160: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
6161: end if;
6162:
6163: if(l_is_parallel = 'PARALLEL') then
6164: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(l_current_forward_to_username1));
6165: end if;
6166:
6167: result := wf_engine.eng_trans_default;
6168: else