APPS.JTF_UM_UTIL_PVT dependencies on JTF_AUTH_PRINCIPALS_B

Line 1565: CURSOR VALIDATE_ROLE IS SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B

1561: p_auth_principal_id in number
1562: ) return boolean IS
1563:
1564: l_procedure_name CONSTANT varchar2(30) := 'check_role';
1565: CURSOR VALIDATE_ROLE IS SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B
1566: WHERE JTF_AUTH_PRINCIPAL_ID = p_auth_principal_id AND IS_USER_FLAG = 0;
1567:
1568: CURSOR CHECK_ROLE_ASSIGNMENT IS SELECT JTF_AUTH_PRINCIPAL_MAPPING_ID FROM JTF_AUTH_PRINCIPAL_MAPS
1569: WHERE JTF_AUTH_PARENT_PRINCIPAL_ID = p_auth_principal_id

Line 1571: (SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B ROLE, FND_USER FU

1567:
1568: CURSOR CHECK_ROLE_ASSIGNMENT IS SELECT JTF_AUTH_PRINCIPAL_MAPPING_ID FROM JTF_AUTH_PRINCIPAL_MAPS
1569: WHERE JTF_AUTH_PARENT_PRINCIPAL_ID = p_auth_principal_id
1570: AND JTF_AUTH_PRINCIPAL_ID IN
1571: (SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B ROLE, FND_USER FU
1572: WHERE FU.USER_NAME = ROLE.PRINCIPAL_NAME AND FU.USER_ID = p_user_id);
1573:
1574: l_role_id number;
1575: l_dummy number;

Line 1654: CURSOR VALIDATE_ROLE_NAME IS SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B

1650: p_principal_name in varchar2
1651: ) return boolean IS
1652:
1653: l_procedure_name CONSTANT varchar2(30) := 'check_role';
1654: CURSOR VALIDATE_ROLE_NAME IS SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B
1655: WHERE PRINCIPAL_NAME = p_principal_name AND IS_USER_FLAG = 0;
1656:
1657: l_role_id number;
1658:

Line 1710: * in the table JTF_AUTH_PRINCIPALS_B

1706: * p_role_id
1707: * description: The value of the JTF_AUTH_PRINCIPAL_ID
1708: * required : Y
1709: * validation : Must exist as a JTF_AUTH_PRONCIPAL_ID
1710: * in the table JTF_AUTH_PRINCIPALS_B
1711: * p_source_name
1712: * description: The value of the name of the source
1713: * required : Y
1714: * validation : Must be "USERTYPE" or "ENROLLMENT"

Line 1730: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B

1726: p_source_id in varchar2
1727: ) IS
1728:
1729: l_procedure_name CONSTANT varchar2(30) := 'grant_roles';
1730: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B
1731: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id;
1732: l_role_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;
1733:
1734: BEGIN

Line 1732: l_role_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;

1728:
1729: l_procedure_name CONSTANT varchar2(30) := 'grant_roles';
1730: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B
1731: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id;
1732: l_role_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;
1733:
1734: BEGIN
1735: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1736: p_message => l_procedure_name