APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPES_B

Line 645: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',

641:
642: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
643: ( USER_NAME => X_USER_NAME,
644: ROLE_NAME => p_principal_name,
645: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',
646: OWNERTABLE_KEY => X_USERTYPE_ID
647: );
648:
649:

Line 697: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg

693: JTF_DEBUG_PUB.LOG_DEBUG (2, MODULE_NAME, 'Start Raising Event');
694:
695: Select ut.APPLICATION_ID,ut.USERTYPE_KEY,reg.USERTYPE_REG_ID
696: Into l_app_id, l_usertype_key, l_usertype_reg_id
697: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg
698: where ut.USERTYPE_ID=reg.USERTYPE_ID and reg.USER_ID=X_USER_ID
699: and reg.status_code='APPROVED' and
700: nvl(reg.EFFECTIVE_END_DATE,sysdate+1) > sysdate;
701:

Line 749: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B

745: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM
746: )
747: IS
748:
749: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B
750: WHERE USERTYPE_KEY = P_USERTYPE_KEY
751: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
752:
753: l_party_type HZ_PARTIES.party_type%type;

Line 928: cursor find_usertype is select usertype_id from jtf_um_usertypes_b

924: cursor find_default_resp is select responsibility_key, application_id from
925: jtf_um_usertype_resp where usertype_id = l_usertype_id
926: and (effective_end_date is null or effective_end_date > sysdate) ;
927:
928: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
929: where usertype_key = l_usertype_key
930: and (effective_end_date is null or effective_end_date > sysdate) ;
931:
932: cursor find_user_id is select user_id from fnd_user where user_name = P_USERNAME;

Line 990: cursor find_usertype is select usertype_id from jtf_um_usertypes_b

986: cursor find_default_role is select principal_name from
987: jtf_um_usertype_role where usertype_id = l_usertype_id
988: and (effective_end_date is null or effective_end_date > sysdate) ;
989:
990: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
991: where usertype_key = l_usertype_key
992: and (effective_end_date is null or effective_end_date > sysdate) ;
993:
994: BEGIN

Line 1028: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',

1024: if P_USERNAME is not null then
1025: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
1026: ( USER_NAME => P_USERNAME,
1027: ROLE_NAME => l_principal_name,
1028: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',
1029: OWNERTABLE_KEY => l_usertype_id
1030: );
1031: end if;
1032: end if;

Line 1152: l_owner_table_name := 'JTF_UM_USERTYPES_B';

1148: CLOSE FIND_ROLE_NAME;
1149:
1150: IF p_source_name = 'USERTYPE' THEN
1151:
1152: l_owner_table_name := 'JTF_UM_USERTYPES_B';
1153:
1154: ELSIF p_source_name = 'ENROLLMENT' THEN
1155:
1156: l_owner_table_name := 'ENROLLMENT';

Line 1451: l_new_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'BUSINESSUSER';

1447:
1448: l_new_usertype_id NUMBER := 0;
1449: l_pending_users NUMBER := 0;
1450:
1451: l_new_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'BUSINESSUSER';
1452: l_old_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'PRIMARYUSER';
1453:
1454: l_user_name varchar2(100);
1455: l_org_name varchar2(360);

Line 1452: l_old_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'PRIMARYUSER';

1448: l_new_usertype_id NUMBER := 0;
1449: l_pending_users NUMBER := 0;
1450:
1451: l_new_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'BUSINESSUSER';
1452: l_old_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'PRIMARYUSER';
1453:
1454: l_user_name varchar2(100);
1455: l_org_name varchar2(360);
1456: l_email varchar2(200);

Line 1461: FROM JTF_UM_USERTYPES_B

1457:
1458:
1459: CURSOR FIND_BUS_UT_ID IS
1460: SELECT USERTYPE_ID
1461: FROM JTF_UM_USERTYPES_B
1462: WHERE USERTYPE_KEY = l_new_ut_key
1463: AND NVL(EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1464:
1465: CURSOR PRIMARY_USERS IS SELECT USERTYPE_REG_ID, USER_ID

Line 1467: WHERE UTREG.USERTYPE_ID IN (SELECT USERTYPE_ID FROM JTF_UM_USERTYPES_B

1463: AND NVL(EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1464:
1465: CURSOR PRIMARY_USERS IS SELECT USERTYPE_REG_ID, USER_ID
1466: FROM JTF_UM_USERTYPE_REG UTREG
1467: WHERE UTREG.USERTYPE_ID IN (SELECT USERTYPE_ID FROM JTF_UM_USERTYPES_B
1468: WHERE USERTYPE_KEY = l_old_ut_key)
1469: AND UTREG.STATUS_CODE = 'APPROVED'
1470: AND NVL(UTREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1471: AND NOT EXISTS

Line 1479: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1475: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1476: );
1477: /*
1478: CURSOR PENDING_USERS IS SELECT f.user_name, p.party_name, f.email_address
1479: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1480: WHERE UT.USERTYPE_KEY = l_old_ut_key
1481: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1482: AND UTREG.user_id = f.user_Id
1483: AND UTREG.STATUS_CODE = 'PENDING'

Line 1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1485: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1486: */
1487: CURSOR PENDING_USERS IS
1488: SELECT f.user_name, p.party_name, f.email_address
1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1490: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1491: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1492: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1493: AND R.object_table_name = 'HZ_PARTIES'

Line 1589: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT

1585:
1586: fnd_file.new_line(fnd_file.log,1);
1587: /*
1588: SELECT COUNT(*) INTO l_pending_users
1589: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT
1590: WHERE UT.USERTYPE_KEY = l_old_ut_key
1591: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1592: AND UTREG.STATUS_CODE = 'PENDING';
1593: */