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_UTIL_PVT dependencies on FND_USER

Line 65: * 1. User_name from fnd_user where email_address = p_requester_email_Address

61: * requester_email does not correspond to a valid user
62: * Other Comments :
63: * DEFAULTING LOGIC
64: *
65: * 1. User_name from fnd_user where email_address = p_requester_email_Address
66: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
67: * per_all_people_f using the email_address)
68: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
69: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'

Line 66: * 2. User_name from fnd_user where employee_id = person_id (retrieved from

62: * Other Comments :
63: * DEFAULTING LOGIC
64: *
65: * 1. User_name from fnd_user where email_address = p_requester_email_Address
66: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
67: * per_all_people_f using the email_address)
68: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
69: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
70: * and contact_point = p_requester_email_Address

Line 68: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id

64: *
65: * 1. User_name from fnd_user where email_address = p_requester_email_Address
66: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
67: * per_all_people_f using the email_address)
68: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
69: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
70: * and contact_point = p_requester_email_Address
71: *
72: * In all the above cases the user, employee, party etc. have to be valid.

Line 85: from fnd_user

81: cursor c_user is
82:
83: -- from fnd tables
84: select user_name
85: from fnd_user
86: where upper(email_address) = p_requester_email
87: and (nvl(end_date, sysdate + 1) > sysdate or
88: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE))
89:

Line 94: select fnd.user_name

90:
91: union
92:
93: -- from HR tables
94: select fnd.user_name
95: from fnd_user fnd, per_all_people_f per
96: where per.person_id = fnd.employee_id
97: and per.effective_end_date > sysdate
98: and (nvl(fnd.end_date, sysdate+1) > sysdate or

Line 95: from fnd_user fnd, per_all_people_f per

91: union
92:
93: -- from HR tables
94: select fnd.user_name
95: from fnd_user fnd, per_all_people_f per
96: where per.person_id = fnd.employee_id
97: and per.effective_end_date > sysdate
98: and (nvl(fnd.end_date, sysdate+1) > sysdate or
99: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))

Line 105: select fnd.user_name

101:
102: union
103:
104: -- from TCA tables
105: select fnd.user_name
106: from hz_contact_points hcp, fnd_user fnd
107: where hcp.owner_table_id = fnd.customer_id
108: and hcp.owner_table_name = 'HZ_PARTIES'
109: and hcp.contact_point_type = 'EMAIL'

Line 106: from hz_contact_points hcp, fnd_user fnd

102: union
103:
104: -- from TCA tables
105: select fnd.user_name
106: from hz_contact_points hcp, fnd_user fnd
107: where hcp.owner_table_id = fnd.customer_id
108: and hcp.owner_table_name = 'HZ_PARTIES'
109: and hcp.contact_point_type = 'EMAIL'
110: and upper(hcp.email_address) = p_requester_email;

Line 192: * 1. Email address from fnd_users where user_name = p_requester_user_name

188: * requester_email does not correspond to a valid user
189: * Other Comments :
190: * DEFAULTING LOGIC
191: * If only the user name is passed then the email is defaulted using the following logic
192: * 1. Email address from fnd_users where user_name = p_requester_user_name
193: * 2. Email from per_all_people_F where person_id = employee_id
194: * (retrieved from fnd_users using the user_name)
195: * 3. Email from hz_contact_points where owner_type_id = party_id and
196: * owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.

Line 194: * (retrieved from fnd_users using the user_name)

190: * DEFAULTING LOGIC
191: * If only the user name is passed then the email is defaulted using the following logic
192: * 1. Email address from fnd_users where user_name = p_requester_user_name
193: * 2. Email from per_all_people_F where person_id = employee_id
194: * (retrieved from fnd_users using the user_name)
195: * 3. Email from hz_contact_points where owner_type_id = party_id and
196: * owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.
197: * Party_id here is obtained from the customer id stored in fnd_user where
198: * user_name = p_requester_user_name.

Line 197: * Party_id here is obtained from the customer id stored in fnd_user where

193: * 2. Email from per_all_people_F where person_id = employee_id
194: * (retrieved from fnd_users using the user_name)
195: * 3. Email from hz_contact_points where owner_type_id = party_id and
196: * owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.
197: * Party_id here is obtained from the customer id stored in fnd_user where
198: * user_name = p_requester_user_name.
199: * In all the above cases the user, employee, party etc. have to be valid.
200: *
201: * The same logic is used to validate the requester_email.

Line 212: from fnd_user

208: x_return_Status out NOCOPY varchar2) is
209:
210: cursor c_user(l_user_name in varchar2) is
211: select email_address, customer_id, employee_id
212: from fnd_user
213: where user_name = l_user_name
214: and (nvl(end_date, sysdate + 1) > sysdate or
215: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
216:

Line 265: -- check to see if email available in fnd_user

261: l_wf_user_name := p_requester_user_name;
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: if p_requester_user_name is not NULL then
265: -- check to see if email available in fnd_user
266: open c_user(p_requester_user_name);
267: fetch c_user into x_email, l_customer_id, l_employee_id;
268: if (c_user%NOTFOUND) then
269: close c_user;

Line 381: * 1. User_name from fnd_user where email_address = p_requester_email_Address

377: * requester_email does not correspond to a valid user
378: * Other Comments :
379: * DEFAULTING LOGIC
380: *
381: * 1. User_name from fnd_user where email_address = p_requester_email_Address
382: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
383: * per_all_people_f using the email_address)
384: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
385: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'

Line 382: * 2. User_name from fnd_user where employee_id = person_id (retrieved from

378: * Other Comments :
379: * DEFAULTING LOGIC
380: *
381: * 1. User_name from fnd_user where email_address = p_requester_email_Address
382: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
383: * per_all_people_f using the email_address)
384: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
385: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
386: * and contact_point = p_requester_email_Address

Line 384: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id

380: *
381: * 1. User_name from fnd_user where email_address = p_requester_email_Address
382: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
383: * per_all_people_f using the email_address)
384: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
385: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
386: * and contact_point = p_requester_email_Address
387: *
388: * In all the above cases the user, employee, party etc. have to be valid.

Line 402: from fnd_user

398: x_wf_user_name out NOCOPY varchar2,
399: x_return_Status out NOCOPY varchar2) is
400: cursor c_user is
401: select user_name
402: from fnd_user
403: where upper(email_address) = p_requester_email
404: and (nvl(end_date, sysdate + 1) > sysdate or
405: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
406:

Line 408: select fnd.user_name

404: and (nvl(end_date, sysdate + 1) > sysdate or
405: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
406:
407: cursor c_employee is
408: select fnd.user_name
409: from fnd_user fnd, per_all_people_f per
410: where per.person_id = fnd.employee_id
411: and per.effective_end_date > sysdate
412: and (nvl(fnd.end_date, sysdate+1) > sysdate or

Line 409: from fnd_user fnd, per_all_people_f per

405: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
406:
407: cursor c_employee is
408: select fnd.user_name
409: from fnd_user fnd, per_all_people_f per
410: where per.person_id = fnd.employee_id
411: and per.effective_end_date > sysdate
412: and (nvl(fnd.end_date, sysdate+1) > sysdate or
413: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))

Line 417: select fnd.user_name

413: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))
414: and upper(per.email_address) = p_requester_email;
415:
416: cursor c_party is
417: select fnd.user_name
418: from hz_contact_points hcp, fnd_user fnd
419: where hcp.owner_table_id = fnd.customer_id
420: and hcp.owner_table_name = 'HZ_PARTIES'
421: and hcp.contact_point_type = 'EMAIL'

Line 418: from hz_contact_points hcp, fnd_user fnd

414: and upper(per.email_address) = p_requester_email;
415:
416: cursor c_party is
417: select fnd.user_name
418: from hz_contact_points hcp, fnd_user fnd
419: where hcp.owner_table_id = fnd.customer_id
420: and hcp.owner_table_name = 'HZ_PARTIES'
421: and hcp.contact_point_type = 'EMAIL'
422: and upper(hcp.email_address) = p_requester_email;

Line 426: from fnd_user

422: and upper(hcp.email_address) = p_requester_email;
423:
424: cursor c_user1(l_party_id in number) is
425: select user_name
426: from fnd_user
427: where customer_id = l_party_id
428: and (nvl(end_date, sysdate+1) > sysdate or
429: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
430:

Line 450: -- get the user name from fnd_user

446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: if p_requester_email is not NULL then
449:
450: -- get the user name from fnd_user
451: open c_user;
452: fetch c_user into x_user_name;
453: close c_user;
454:

Line 524: * 1. Email address from fnd_users where user_name = x_requester_user_name

520: * requester_email does not correspond to a valid user
521: * Other Comments :
522: * DEFAULTING LOGIC
523: * If only the user name is passed then the email is defaulted using the following logic
524: * 1. Email address from fnd_users where user_name = x_requester_user_name
525: * 2. Email from per_all_people_F where person_id = employee_id
526: * (retrieved from fnd_users using the user_name)
527: * 3. Email from hz_contact_points where owner_type_id = party_id
528: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.

Line 526: * (retrieved from fnd_users using the user_name)

522: * DEFAULTING LOGIC
523: * If only the user name is passed then the email is defaulted using the following logic
524: * 1. Email address from fnd_users where user_name = x_requester_user_name
525: * 2. Email from per_all_people_F where person_id = employee_id
526: * (retrieved from fnd_users using the user_name)
527: * 3. Email from hz_contact_points where owner_type_id = party_id
528: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.
529: * Party_id here is obtained from the customer id stored in fnd_user where
530: * user_name = x_requester_user_name.

Line 529: * Party_id here is obtained from the customer id stored in fnd_user where

525: * 2. Email from per_all_people_F where person_id = employee_id
526: * (retrieved from fnd_users using the user_name)
527: * 3. Email from hz_contact_points where owner_type_id = party_id
528: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.
529: * Party_id here is obtained from the customer id stored in fnd_user where
530: * user_name = x_requester_user_name.
531: * In all the above cases the user, employee, party etc. have to be valid.
532: *
533: * If only the email address is specified, the user name is determined using a similar logic

Line 534: * 1. User_name from fnd_user where email_address = x_requester_email_Address

530: * user_name = x_requester_user_name.
531: * In all the above cases the user, employee, party etc. have to be valid.
532: *
533: * If only the email address is specified, the user name is determined using a similar logic
534: * 1. User_name from fnd_user where email_address = x_requester_email_Address
535: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
536: * per_all_people_f using the email_address)
537: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
538: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'

Line 535: * 2. User_name from fnd_user where employee_id = person_id (retrieved from

531: * In all the above cases the user, employee, party etc. have to be valid.
532: *
533: * If only the email address is specified, the user name is determined using a similar logic
534: * 1. User_name from fnd_user where email_address = x_requester_email_Address
535: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
536: * per_all_people_f using the email_address)
537: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
538: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
539: * and contact_point = x_requester_email_Address

Line 537: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id

533: * If only the email address is specified, the user name is determined using a similar logic
534: * 1. User_name from fnd_user where email_address = x_requester_email_Address
535: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
536: * per_all_people_f using the email_address)
537: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
538: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
539: * and contact_point = x_requester_email_Address
540: *
541: */

Line 565: from fnd_user

561:
562: /*
563: cursor c_update_email(l_user_name in varchar2) is
564: select email_address
565: from fnd_user
566: where user_name = l_user_name;
567: */
568:
569: begin

Line 615: -- the email should be picked up from FND_USER, PER_PEOPLE_F or TCA

611: end if;
612:
613:
614: -- default the email address if user name is not NULL
615: -- the email should be picked up from FND_USER, PER_PEOPLE_F or TCA
616:
617: if (l_requester_user_name is not null) then
618: get_email(p_requester_user_name => l_requester_user_name,
619: p_requester_email => l_requester_email,

Line 929: * description: FND user's username. The recipient of the notification.

925: * Parameters :
926: * input parameters
927: * @param
928: * p_username
929: * description: FND user's username. The recipient of the notification.
930: * required : N
931: * validation : Must be a valid FND User.
932: * default : null
933: * p_subject

Line 931: * validation : Must be a valid FND User.

927: * @param
928: * p_username
929: * description: FND user's username. The recipient of the notification.
930: * required : N
931: * validation : Must be a valid FND User.
932: * default : null
933: * p_subject
934: * description: The subject of the notification.
935: * required : Y

Line 999: * description: FND user's username. The recipient of the notification.

995: * Parameters :
996: * input parameters
997: * @param
998: * p_username
999: * description: FND user's username. The recipient of the notification.
1000: * required : N
1001: * validation : Must be a valid FND User.
1002: * default : null
1003: * p_email_address

Line 1001: * validation : Must be a valid FND User.

997: * @param
998: * p_username
999: * description: FND user's username. The recipient of the notification.
1000: * required : N
1001: * validation : Must be a valid FND User.
1002: * default : null
1003: * p_email_address
1004: * description: Send to this email.
1005: * required : N

Line 1352: select user_id from fnd_user

1348: where responsibility_id = p_resp_id;
1349:
1350: -- determine the userid given the username
1351: cursor C_user_id(p_username in varchar2) is
1352: select user_id from fnd_user
1353: where user_name = p_username;
1354:
1355: -- determine whether or not the resp id corresponds to "jtf_pending_approval"
1356: cursor C_is_pending_resp(p_resp_id in number, p_appl_id in number) is

Line 1442: cursor find_user_id is select user_id from fnd_user where

1438: */
1439:
1440: function VALIDATE_USER_ID(p_user_id number) return boolean is
1441:
1442: cursor find_user_id is select user_id from fnd_user where
1443: user_id = p_user_id and (nvl(end_date, sysdate+1) > sysdate or
1444: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
1445:
1446: l_procedure_name CONSTANT varchar2(30) := 'VALIDATE_USER_ID';

Line 1571: (SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B ROLE, FND_USER FU

1567:
1568: CURSOR CHECK_ROLE_ASSIGNMENT IS SELECT JTF_AUTH_PRINCIPAL_MAPPING_ID FROM JTF_AUTH_PRINCIPAL_MAPS
1569: WHERE JTF_AUTH_PARENT_PRINCIPAL_ID = p_auth_principal_id
1570: AND JTF_AUTH_PRINCIPAL_ID IN
1571: (SELECT JTF_AUTH_PRINCIPAL_ID FROM JTF_AUTH_PRINCIPALS_B ROLE, FND_USER FU
1572: WHERE FU.USER_NAME = ROLE.PRINCIPAL_NAME AND FU.USER_ID = p_user_id);
1573:
1574: l_role_id number;
1575: l_dummy number;

Line 1791: CURSOR GET_ID IS SELECT USER_ID FROM FND_USER WHERE USER_NAME = p_user_name;

1787: function GET_USER_ID(p_user_name varchar2) return NUMBER IS
1788:
1789: l_procedure_name CONSTANT varchar2(30) := 'GET_USER_ID';
1790:
1791: CURSOR GET_ID IS SELECT USER_ID FROM FND_USER WHERE USER_NAME = p_user_name;
1792: l_user_id NUMBER;
1793:
1794: BEGIN
1795:

Line 1890: Wrapper for FND_USER_PKG.validate_user_name, which is a procedure and raises an

1886: return l_party_type;
1887: END CHECK_PARTY_TYPE;
1888:
1889: /*
1890: Wrapper for FND_USER_PKG.validate_user_name, which is a procedure and raises an
1891: exception. We require this wrapper as we dont know whether the exception is due
1892: to invalid username or something other exception .We check the sqlcode and accordingly
1893: process.We cannot have a boolean function as we cannot access it from the JDBC layer.
1894:

Line 1904: fnd_user_pkg.validate_user_name(username);

1900: is
1901:
1902:
1903: begin
1904: fnd_user_pkg.validate_user_name(username);
1905: return 1;
1906: exception
1907: when others then
1908: IF sqlcode = -20001 then

Line 1921: x_return_status := fnd_user_pkg.TestUserName (x_user_name => username);

1917: function validate_user_name_in_use(username varchar2) return number
1918: is
1919: x_return_status pls_integer;
1920: begin
1921: x_return_status := fnd_user_pkg.TestUserName (x_user_name => username);
1922:
1923: IF x_return_status = fnd_user_pkg.USER_OK_CREATE then
1924: return 1;
1925: Else

Line 1923: IF x_return_status = fnd_user_pkg.USER_OK_CREATE then

1919: x_return_status pls_integer;
1920: begin
1921: x_return_status := fnd_user_pkg.TestUserName (x_user_name => username);
1922:
1923: IF x_return_status = fnd_user_pkg.USER_OK_CREATE then
1924: return 1;
1925: Else
1926: return 0;
1927: End if;