APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPE_REG

Line 511: from jtf_um_usertype_reg ut,

507: p_name => l_user_name,
508: p_display_name => l_user_display_name);
509: if(l_user_name is not null) then
510: select NOTIFICATION_PREFERENCE into l_notif_pref
511: from jtf_um_usertype_reg ut,
512: wf_local_roles wlr
513: where ut.status_code='PENDING'
514: and '__JTA_UM'||USERTYPE_REG_ID = name
515: and ut.user_id = userId;

Line 710: UPDATE JTF_UM_USERTYPE_REG SET STATUS_CODE='APPROVED'

706: CLOSE USERTYPE_ROLES;
707:
708: -- Update the status
709:
710: UPDATE JTF_UM_USERTYPE_REG SET STATUS_CODE='APPROVED'
711: WHERE USERTYPE_ID = X_USERTYPE_ID
712: AND USER_ID = X_USER_ID
713: and status_code='PENDING' and nvl(effective_end_date, SYSDATE + 1) > SYSDATE;
714:

Line 752: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg

748: JTF_DEBUG_PUB.LOG_DEBUG (2, MODULE_NAME, 'Start Raising Event');
749:
750: Select ut.APPLICATION_ID,ut.USERTYPE_KEY,reg.USERTYPE_REG_ID
751: Into l_app_id, l_usertype_key, l_usertype_reg_id
752: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg
753: where ut.USERTYPE_ID=reg.USERTYPE_ID and reg.USER_ID=X_USER_ID
754: and reg.status_code='APPROVED' and
755: nvl(reg.EFFECTIVE_END_DATE,sysdate+1) > sysdate;
756:

Line 940: FROM JTF_UM_USERTYPE_REG reg, FND_USER fu

936: IS
937:
938: CURSOR FIND_UT_APPWF_INFO IS
939: SELECT reg.WF_ITEM_TYPE, to_char (reg.USERTYPE_REG_ID)
940: FROM JTF_UM_USERTYPE_REG reg, FND_USER fu
941: WHERE fu.USER_NAME = P_USERNAME
942: AND fu.USER_ID = reg.USER_ID
943: AND STATUS_CODE = 'PENDING'
944: AND (reg.EFFECTIVE_END_DATE is null

Line 1521: FROM JTF_UM_USERTYPE_REG UTREG

1517: WHERE USERTYPE_KEY = l_new_ut_key
1518: AND NVL(EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1519:
1520: CURSOR PRIMARY_USERS IS SELECT USERTYPE_REG_ID, USER_ID
1521: FROM JTF_UM_USERTYPE_REG UTREG
1522: WHERE UTREG.USERTYPE_ID IN (SELECT USERTYPE_ID FROM JTF_UM_USERTYPES_B
1523: WHERE USERTYPE_KEY = l_old_ut_key)
1524: AND UTREG.STATUS_CODE = 'APPROVED'
1525: AND NVL(UTREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE

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

1530: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1531: );
1532: /*
1533: CURSOR PENDING_USERS IS SELECT f.user_name, p.party_name, f.email_address
1534: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1535: WHERE UT.USERTYPE_KEY = l_old_ut_key
1536: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1537: AND UTREG.user_id = f.user_Id
1538: AND UTREG.STATUS_CODE = 'PENDING'

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

1540: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1541: */
1542: CURSOR PENDING_USERS IS
1543: SELECT f.user_name, p.party_name, f.email_address
1544: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1545: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1546: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1547: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1548: AND R.object_table_name = 'HZ_PARTIES'

Line 1596: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id

1592: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN
1593:
1594: FOR i IN PRIMARY_USERS LOOP
1595: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USERS');
1596: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id
1597: WHERE USERTYPE_REG_ID = i.USERTYPE_REG_ID;
1598:
1599: COMMIT;
1600: -- this code can result in exceptions hence enclosing in a seperate block

Line 1645: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT

1641:
1642: fnd_file.new_line(fnd_file.log,1);
1643: /*
1644: SELECT COUNT(*) INTO l_pending_users
1645: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT
1646: WHERE UT.USERTYPE_KEY = l_old_ut_key
1647: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1648: AND UTREG.STATUS_CODE = 'PENDING';
1649: */