APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPE_REG

Line 655: UPDATE JTF_UM_USERTYPE_REG SET STATUS_CODE='APPROVED'

651: CLOSE USERTYPE_ROLES;
652:
653: -- Update the status
654:
655: UPDATE JTF_UM_USERTYPE_REG SET STATUS_CODE='APPROVED'
656: WHERE USERTYPE_ID = X_USERTYPE_ID
657: AND USER_ID = X_USER_ID
658: and status_code='PENDING' and nvl(effective_end_date, SYSDATE + 1) > SYSDATE;
659:

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 885: FROM JTF_UM_USERTYPE_REG reg, FND_USER fu

881: IS
882:
883: CURSOR FIND_UT_APPWF_INFO IS
884: SELECT reg.WF_ITEM_TYPE, to_char (reg.USERTYPE_REG_ID)
885: FROM JTF_UM_USERTYPE_REG reg, FND_USER fu
886: WHERE fu.USER_NAME = P_USERNAME
887: AND fu.USER_ID = reg.USER_ID
888: AND STATUS_CODE = 'PENDING'
889: AND (reg.EFFECTIVE_END_DATE is null

Line 1466: FROM JTF_UM_USERTYPE_REG UTREG

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

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 1540: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id

1536: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN
1537:
1538: FOR i IN PRIMARY_USERS LOOP
1539: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USERS');
1540: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id
1541: WHERE USERTYPE_REG_ID = i.USERTYPE_REG_ID;
1542:
1543: COMMIT;
1544: -- this code can result in exceptions hence enclosing in a seperate block

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: */