eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPES_B

Line 700: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',

696:
697: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
698: ( USER_NAME => X_USER_NAME,
699: ROLE_NAME => p_principal_name,
700: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',
701: OWNERTABLE_KEY => X_USERTYPE_ID
702: );
703:
704:

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 804: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B

800: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM
801: )
802: IS
803:
804: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B
805: WHERE USERTYPE_KEY = P_USERTYPE_KEY
806: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
807:
808: l_party_type HZ_PARTIES.party_type%type;

Line 983: cursor find_usertype is select usertype_id from jtf_um_usertypes_b

979: cursor find_default_resp is select responsibility_key, application_id from
980: jtf_um_usertype_resp where usertype_id = l_usertype_id
981: and (effective_end_date is null or effective_end_date > sysdate) ;
982:
983: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
984: where usertype_key = l_usertype_key
985: and (effective_end_date is null or effective_end_date > sysdate) ;
986:
987: cursor find_user_id is select user_id from fnd_user where user_name = P_USERNAME;

Line 1045: cursor find_usertype is select usertype_id from jtf_um_usertypes_b

1041: cursor find_default_role is select principal_name from
1042: jtf_um_usertype_role where usertype_id = l_usertype_id
1043: and (effective_end_date is null or effective_end_date > sysdate) ;
1044:
1045: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
1046: where usertype_key = l_usertype_key
1047: and (effective_end_date is null or effective_end_date > sysdate) ;
1048:
1049: BEGIN

Line 1083: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',

1079: if P_USERNAME is not null then
1080: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
1081: ( USER_NAME => P_USERNAME,
1082: ROLE_NAME => l_principal_name,
1083: OWNERTABLE_NAME => 'JTF_UM_USERTYPES_B',
1084: OWNERTABLE_KEY => l_usertype_id
1085: );
1086: end if;
1087: end if;

Line 1207: l_owner_table_name := 'JTF_UM_USERTYPES_B';

1203: CLOSE FIND_ROLE_NAME;
1204:
1205: IF p_source_name = 'USERTYPE' THEN
1206:
1207: l_owner_table_name := 'JTF_UM_USERTYPES_B';
1208:
1209: ELSIF p_source_name = 'ENROLLMENT' THEN
1210:
1211: l_owner_table_name := 'ENROLLMENT';

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

1502:
1503: l_new_usertype_id NUMBER := 0;
1504: l_pending_users NUMBER := 0;
1505:
1506: l_new_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'BUSINESSUSER';
1507: l_old_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'PRIMARYUSER';
1508:
1509: l_user_name varchar2(100);
1510: l_org_name varchar2(360);

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

1503: l_new_usertype_id NUMBER := 0;
1504: l_pending_users NUMBER := 0;
1505:
1506: l_new_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'BUSINESSUSER';
1507: l_old_ut_key JTF_UM_USERTYPES_B.USERTYPE_KEY%TYPE := 'PRIMARYUSER';
1508:
1509: l_user_name varchar2(100);
1510: l_org_name varchar2(360);
1511: l_email varchar2(200);

Line 1516: FROM JTF_UM_USERTYPES_B

1512:
1513:
1514: CURSOR FIND_BUS_UT_ID IS
1515: SELECT USERTYPE_ID
1516: FROM JTF_UM_USERTYPES_B
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

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

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
1526: AND NOT EXISTS

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