APPS.OTA_WF dependencies on FND_USER

Line 1701: l_user_name fnd_user.user_name%type;

1697: IS
1698:
1699: l_proc varchar2(72) := g_package||'update_owner_email';
1700: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
1701: l_user_name fnd_user.user_name%type;
1702:
1703:
1704: CURSOR c_uom IS
1705: SELECT

Line 1718: FROM FND_USER

1714: ol.line_id = l_line_id;
1715:
1716: CURSOR c_event IS
1717: SELECT user_name
1718: FROM FND_USER
1719: WHERE employee_id IN(
1720: select owner_id from
1721: ota_events where
1722: line_id = l_line_id);

Line 2092: l_cur_email_id fnd_user.email_address%TYPE := null;

2088: l_user_name wf_users.name%TYPE ;
2089: l_nid number;
2090: l_email_ids varchar2(32767) := p_email_addresses;
2091: l_person_ids varchar2(32767) := p_person_ids;
2092: l_cur_email_id fnd_user.email_address%TYPE := null;
2093: l_cur_person_id varchar2(100) := null;
2094:
2095: cursor get_user_name_from_email(p_email_address varchar2) is
2096: select user_name

Line 2097: from fnd_user

2093: l_cur_person_id varchar2(100) := null;
2094:
2095: cursor get_user_name_from_email(p_email_address varchar2) is
2096: select user_name
2097: from fnd_user
2098: where upper(email_address)=upper(p_email_address)
2099: and (end_date is null or end_date >=sysdate);
2100:
2101: cursor get_user_name_from_person_id(p_person_id varchar2) is

Line 2103: from fnd_user

2099: and (end_date is null or end_date >=sysdate);
2100:
2101: cursor get_user_name_from_person_id(p_person_id varchar2) is
2102: select user_name
2103: from fnd_user
2104: where EMPLOYEE_ID = p_person_id
2105: and (end_date is null or end_date >=sysdate);
2106:
2107: BEGIN

Line 2120: if l_cur_email_id is not null then --{ if the email is not null fetch the role from fnd_users table

2116: l_user_name := null;
2117: l_cur_email_id := SUBSTR(l_email_ids,1,INSTR(l_email_ids,',')-1);
2118: l_cur_person_id := SUBSTR(l_person_ids,1,INSTR(l_person_ids,',')-1);
2119:
2120: if l_cur_email_id is not null then --{ if the email is not null fetch the role from fnd_users table
2121: open get_user_name_from_email(l_cur_email_id);
2122: fetch get_user_name_from_email into l_user_name;
2123: if get_user_name_from_email%notfound then --{ if the role not found for that email id
2124: close get_user_name_from_email;

Line 2125: if l_cur_person_id is not null then --{ if the person id not null then fetch the role from the fnd_users table

2121: open get_user_name_from_email(l_cur_email_id);
2122: fetch get_user_name_from_email into l_user_name;
2123: if get_user_name_from_email%notfound then --{ if the role not found for that email id
2124: close get_user_name_from_email;
2125: if l_cur_person_id is not null then --{ if the person id not null then fetch the role from the fnd_users table
2126: open get_user_name_from_person_id(l_cur_person_id);
2127: fetch get_user_name_from_person_id into l_user_name;
2128: if get_user_name_from_person_id%notfound then --{ if the role is not found for the person id
2129: close get_user_name_from_person_id;

Line 2142: elsif l_cur_person_id is not null then -- if the email id is null and person id not null then fetch the role from the fnd_users table

2138: end if; --}
2139: else
2140: close get_user_name_from_email;
2141: end if; --}
2142: elsif l_cur_person_id is not null then -- if the email id is null and person id not null then fetch the role from the fnd_users table
2143: open get_user_name_from_person_id(l_cur_person_id);
2144: fetch get_user_name_from_person_id into l_user_name;
2145: close get_user_name_from_person_id;
2146: end if; --}