22: workflow processes but has not converted to BES.
23:
24: ***************************************************************************************/
25:
26: PROCEDURE Get_Fnd_User_Role
27: ( p_fnd_user_id IN NUMBER,
28: x_role_name OUT NOCOPY VARCHAR2,
29: x_role_display_name OUT NOCOPY VARCHAR2 );
30:
23:
24: ***************************************************************************************/
25:
26: PROCEDURE Get_Fnd_User_Role
27: ( p_fnd_user_id IN NUMBER,
28: x_role_name OUT NOCOPY VARCHAR2,
29: x_role_display_name OUT NOCOPY VARCHAR2 );
30:
31:
473: IF (l_administrator IS NULL) THEN
474: raise l_ADMINISTRATOR_NOT_SET;
475: END IF;
476:
477: get_fnd_user_role
478: ( p_fnd_user_id => l_user_id,
479: x_role_name => l_initiator_role,
480: x_role_display_name => l_dummy );
481:
474: raise l_ADMINISTRATOR_NOT_SET;
475: END IF;
476:
477: get_fnd_user_role
478: ( p_fnd_user_id => l_user_id,
479: x_role_name => l_initiator_role,
480: x_role_display_name => l_dummy );
481:
482:
833: --INSERT INTO rm_tmp values (p_Incident_Number, 'In BES wrapper,p_wf_process_id IS NULL ',rm_tmp_seq.nextval);
834:
835: -- Derive Role from User ID
836: IF (p_USER_ID IS NOT NULL) THEN
837: CS_WF_AUTO_NTFY_UPDATE_PKG.get_fnd_user_role
838: ( p_fnd_user_id => p_USER_ID,
839: x_role_name => l_initiator_role,
840: x_role_display_name => l_dummy );
841: END IF;
834:
835: -- Derive Role from User ID
836: IF (p_USER_ID IS NOT NULL) THEN
837: CS_WF_AUTO_NTFY_UPDATE_PKG.get_fnd_user_role
838: ( p_fnd_user_id => p_USER_ID,
839: x_role_name => l_initiator_role,
840: x_role_display_name => l_dummy );
841: END IF;
842:
1708: END Raise_ServiceRequest_Event;
1709:
1710:
1711: ------------------------------------------------------------------------------
1712: -- Procedure : Get_Fnd_User_Role
1713: ------------------------------------------------------------------------------
1714:
1715: PROCEDURE Get_Fnd_User_Role
1716: ( p_fnd_user_id IN NUMBER,
1711: ------------------------------------------------------------------------------
1712: -- Procedure : Get_Fnd_User_Role
1713: ------------------------------------------------------------------------------
1714:
1715: PROCEDURE Get_Fnd_User_Role
1716: ( p_fnd_user_id IN NUMBER,
1717: x_role_name OUT NOCOPY VARCHAR2,
1718: x_role_display_name OUT NOCOPY VARCHAR2 )
1719: IS
1712: -- Procedure : Get_Fnd_User_Role
1713: ------------------------------------------------------------------------------
1714:
1715: PROCEDURE Get_Fnd_User_Role
1716: ( p_fnd_user_id IN NUMBER,
1717: x_role_name OUT NOCOPY VARCHAR2,
1718: x_role_display_name OUT NOCOPY VARCHAR2 )
1719: IS
1720: l_employee_id NUMBER;
1718: x_role_display_name OUT NOCOPY VARCHAR2 )
1719: IS
1720: l_employee_id NUMBER;
1721: BEGIN
1722: -- map the FND user to employee ID
1723: SELECT employee_id INTO l_employee_id
1724: FROM fnd_user
1725: WHERE user_id = p_fnd_user_id;
1726:
1720: l_employee_id NUMBER;
1721: BEGIN
1722: -- map the FND user to employee ID
1723: SELECT employee_id INTO l_employee_id
1724: FROM fnd_user
1725: WHERE user_id = p_fnd_user_id;
1726:
1727: IF (l_employee_id IS NOT NULL) THEN
1728: wf_directory.getrolename
1721: BEGIN
1722: -- map the FND user to employee ID
1723: SELECT employee_id INTO l_employee_id
1724: FROM fnd_user
1725: WHERE user_id = p_fnd_user_id;
1726:
1727: IF (l_employee_id IS NOT NULL) THEN
1728: wf_directory.getrolename
1729: ( p_orig_system => 'PER',
1732: p_display_name => x_role_display_name );
1733: ELSE
1734: wf_directory.getrolename
1735: ( p_orig_system => 'FND_USR',
1736: p_orig_system_id => p_fnd_user_id,
1737: p_name => x_role_name,
1738: p_display_name => x_role_display_name );
1739: END IF;
1740: END Get_Fnd_User_Role;
1736: p_orig_system_id => p_fnd_user_id,
1737: p_name => x_role_name,
1738: p_display_name => x_role_display_name );
1739: END IF;
1740: END Get_Fnd_User_Role;
1741:
1742:
1743:
1744: