DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on FND_USER

Line 26: PROCEDURE Get_Fnd_User_Role

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:

Line 27: ( p_fnd_user_id IN NUMBER,

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:

Line 477: get_fnd_user_role

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:

Line 478: ( p_fnd_user_id => l_user_id,

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:

Line 837: CS_WF_AUTO_NTFY_UPDATE_PKG.get_fnd_user_role

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;

Line 838: ( p_fnd_user_id => p_USER_ID,

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:

Line 1712: -- Procedure : Get_Fnd_User_Role

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,

Line 1715: PROCEDURE Get_Fnd_User_Role

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

Line 1716: ( p_fnd_user_id IN NUMBER,

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;

Line 1722: -- map the FND user to employee ID

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:

Line 1724: FROM fnd_user

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

Line 1725: WHERE user_id = p_fnd_user_id;

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',

Line 1736: p_orig_system_id => p_fnd_user_id,

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;

Line 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: