APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_AUTH_PRINCIPALS_B

Line 1109: * in the table JTF_AUTH_PRINCIPALS_B

1105: * p_role_id
1106: * description: The value of the JTF_AUTH_PRINCIPAL_ID
1107: * required : Y
1108: * validation : Must exist as a JTF_AUTH_PRONCIPAL_ID
1109: * in the table JTF_AUTH_PRINCIPALS_B
1110: * p_source_name
1111: * description: The value of the name of the source
1112: * required : Y
1113: * validation : Must be "USERTYPE" or "ENROLLMENT"

Line 1128: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B

1124: p_source_name in varchar2,
1125: p_source_id in varchar2
1126: ) IS
1127:
1128: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B
1129: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id AND IS_USER_FLAG = 0;
1130:
1131: l_owner_table_name varchar2(50);
1132: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;

Line 1132: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;

1128: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B
1129: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id AND IS_USER_FLAG = 0;
1130:
1131: l_owner_table_name varchar2(50);
1132: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;
1133:
1134: BEGIN
1135:
1136: IF p_source_name <> 'USERTYPE' OR p_source_name <> 'ENROLLMENT' THEN