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 FND_USER

Line 170: FROM FND_USER

166: IS
167: CURSOR CUSTOMER_ID
168: IS
169: SELECT CUSTOMER_ID
170: FROM FND_USER
171: WHERE USER_ID = X_USER_ID
172: AND (NVL(END_DATE,SYSDATE+1) > SYSDATE OR to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;
173:
174: CURSOR ORG_PARTY_ID

Line 177: FROM hz_relationships HZR,FND_USER FU

173:
174: CURSOR ORG_PARTY_ID
175: IS
176: SELECT FU.CUSTOMER_ID,HZR.SUBJECT_ID,HZR.OBJECT_ID
177: FROM hz_relationships HZR,FND_USER FU
178: WHERE FU.USER_ID = X_USER_ID
179: AND FU.CUSTOMER_ID = HZR.PARTY_ID
180: AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
181: AND HZR.subject_type = 'PERSON'

Line 303: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(

299: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
300: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
301:
302: BEGIN
303: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(
304: user_id => X_USER_ID,
305: responsibility_id => X_RESPONSIBILITY_ID,
306: responsibility_application_id => X_APPLICATION_ID
307: ) THEN

Line 310: Removed this direct update call as fnd_user_resp_groups is no

306: responsibility_application_id => X_APPLICATION_ID
307: ) THEN
308:
309: /*
310: Removed this direct update call as fnd_user_resp_groups is no
311: longer a table. Converted this call to use an API instead.
312:
313: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
314: WHERE USER_ID = X_USER_ID

Line 313: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE

309: /*
310: Removed this direct update call as fnd_user_resp_groups is no
311: longer a table. Converted this call to use an API instead.
312:
313: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
314: WHERE USER_ID = X_USER_ID
315: AND RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
316: AND RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;
317: */

Line 318: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

314: WHERE USER_ID = X_USER_ID
315: AND RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
316: AND RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;
317: */
318: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(
319: user_id => X_USER_ID,
320: responsibility_id => X_RESPONSIBILITY_ID,
321: responsibility_application_id => X_APPLICATION_ID,
322: start_date => sysdate,

Line 361: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

357: )
358: IS
359: BEGIN
360:
361: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(
362: user_id => X_USER_ID,
363: responsibility_id => X_RESPONSIBILITY_ID,
364: responsibility_application_id => X_APPLICATION_ID,
365: start_date => sysdate,

Line 561: select start_date,end_date into userStartDate,userEndDate from FND_USER

557: --changes for 3899304
558: -- the user name which has been reserved has to be enabled.
559: -- enable user only if the user is a pending user.
560:
561: select start_date,end_date into userStartDate,userEndDate from FND_USER
562: where user_id = X_USER_ID;
563:
564: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
565: and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then

Line 566: fnd_user_pkg.EnableUser (

562: where user_id = X_USER_ID;
563:
564: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
565: and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
566: fnd_user_pkg.EnableUser (
567: username => X_USER_NAME,
568: start_date => sysdate,
569: end_date => fnd_user_pkg.null_date);
570: end if;

Line 569: end_date => fnd_user_pkg.null_date);

565: and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
566: fnd_user_pkg.EnableUser (
567: username => X_USER_NAME,
568: start_date => sysdate,
569: end_date => fnd_user_pkg.null_date);
570: end if;
571: --end of changes for 3899304
572: -- removing JTF_PENDING_REMOVAL resp assigned during registration process
573: -- as we now have a check to assign default responsibility only if there

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 932: cursor find_user_id is select user_id from fnd_user where user_name = P_USERNAME;

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;
933:
934: BEGIN
935:
936: -- Map account type to user type

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 1548: from hz_parties p, hz_relationships r, fnd_user f

1544: -- this code can result in exceptions hence enclosing in a seperate block
1545: -- as the following block is used for logging
1546: BEGIN
1547: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1548: from hz_parties p, hz_relationships r, fnd_user f
1549: where
1550: p.party_id = r.object_id and r.party_id = f.customer_id
1551: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1552: AND R.object_table_name = 'HZ_PARTIES'