APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_AUTH_PRINCIPALS_B

Line 1164: * in the table JTF_AUTH_PRINCIPALS_B

1160: * p_role_id
1161: * description: The value of the JTF_AUTH_PRINCIPAL_ID
1162: * required : Y
1163: * validation : Must exist as a JTF_AUTH_PRONCIPAL_ID
1164: * in the table JTF_AUTH_PRINCIPALS_B
1165: * p_source_name
1166: * description: The value of the name of the source
1167: * required : Y
1168: * validation : Must be "USERTYPE" or "ENROLLMENT"

Line 1183: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B

1179: p_source_name in varchar2,
1180: p_source_id in varchar2
1181: ) IS
1182:
1183: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B
1184: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id AND IS_USER_FLAG = 0;
1185:
1186: l_owner_table_name varchar2(50);
1187: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;

Line 1187: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;

1183: CURSOR FIND_ROLE_NAME IS SELECT PRINCIPAL_NAME FROM JTF_AUTH_PRINCIPALS_B
1184: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id AND IS_USER_FLAG = 0;
1185:
1186: l_owner_table_name varchar2(50);
1187: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;
1188:
1189: BEGIN
1190:
1191: IF p_source_name <> 'USERTYPE' OR p_source_name <> 'ENROLLMENT' THEN