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 610: select start_date,end_date into userStartDate,userEndDate from FND_USER

606: --changes for 3899304
607: -- the user name which has been reserved has to be enabled.
608: -- enable user only if the user is a pending user.
609:
610: select start_date,end_date into userStartDate,userEndDate from FND_USER
611: where user_id = X_USER_ID;
612:
613: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE) and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
614: fnd_user_pkg.EnableUser (

Line 614: fnd_user_pkg.EnableUser (

610: select start_date,end_date into userStartDate,userEndDate from FND_USER
611: where user_id = X_USER_ID;
612:
613: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE) and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
614: fnd_user_pkg.EnableUser (
615: username => X_USER_NAME,
616: start_date => sysdate,
617: end_date => fnd_user_pkg.null_date);
618: setApproverNotifPref(X_USER_NAME, X_USER_ID); --added for bug# 7661549

Line 617: end_date => fnd_user_pkg.null_date);

613: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE) and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
614: fnd_user_pkg.EnableUser (
615: username => X_USER_NAME,
616: start_date => sysdate,
617: end_date => fnd_user_pkg.null_date);
618: setApproverNotifPref(X_USER_NAME, X_USER_ID); --added for bug# 7661549
619: --Added for bug 7661549
620: /*wf_directory.SetUserAttr(user_name => X_USER_NAME,
621: orig_system => 'FND_USR',

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

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;
988:
989: BEGIN
990:
991: -- Map account type to user type

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

1600: -- this code can result in exceptions hence enclosing in a seperate block
1601: -- as the following block is used for logging
1602: BEGIN
1603: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1604: from hz_parties p, hz_relationships r, fnd_user f
1605: where
1606: p.party_id = r.object_id and r.party_id = f.customer_id
1607: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1608: AND R.object_table_name = 'HZ_PARTIES'