APPS.FUN_CONTACTUS_EMAIL dependencies on FND_USER

Line 162: | FND User with the user_id set to p_user_id.

158: | PUBLIC PROCEDURE get_user_info
159: |
160: | DESCRIPTION
161: | This procedure returns the full name and email address for the
162: | FND User with the user_id set to p_user_id.
163: |
164: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
165: | Called from BC4J.
166: |

Line 175: | p_user_id IN FND user Id

171: |
172: | RETURNS
173: |
174: | PARAMETERS
175: | p_user_id IN FND user Id
176: | p_full_name OUT full name
177: | p_email_address OUT email address
178: | p_return_status OUT return status. 'S' if found user info, 'F' otherwise.
179: |

Line 190: l_user_name fnd_user.user_name%TYPE;

186: p_full_name OUT NOCOPY VARCHAR2,
187: p_email_address OUT NOCOPY VARCHAR2,
188: p_return_status OUT NOCOPY VARCHAR2)
189: IS
190: l_user_name fnd_user.user_name%TYPE;
191: l_email_address fnd_user.email_address%TYPE;
192: l_employee_id fnd_user.employee_id%TYPE;
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;

Line 191: l_email_address fnd_user.email_address%TYPE;

187: p_email_address OUT NOCOPY VARCHAR2,
188: p_return_status OUT NOCOPY VARCHAR2)
189: IS
190: l_user_name fnd_user.user_name%TYPE;
191: l_email_address fnd_user.email_address%TYPE;
192: l_employee_id fnd_user.employee_id%TYPE;
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;
195: BEGIN

Line 192: l_employee_id fnd_user.employee_id%TYPE;

188: p_return_status OUT NOCOPY VARCHAR2)
189: IS
190: l_user_name fnd_user.user_name%TYPE;
191: l_email_address fnd_user.email_address%TYPE;
192: l_employee_id fnd_user.employee_id%TYPE;
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;
195: BEGIN
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 193: l_customer_id fnd_user.customer_id%TYPE;

189: IS
190: l_user_name fnd_user.user_name%TYPE;
191: l_email_address fnd_user.email_address%TYPE;
192: l_employee_id fnd_user.employee_id%TYPE;
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;
195: BEGIN
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,

Line 194: l_vendor_id fnd_user.supplier_id%TYPE;

190: l_user_name fnd_user.user_name%TYPE;
191: l_email_address fnd_user.email_address%TYPE;
192: l_employee_id fnd_user.employee_id%TYPE;
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;
195: BEGIN
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
198: 'start get_user_info');

Line 217: FROM fnd_user

213: -- Get basic info and user type
214: SELECT user_name, email_address, employee_id, customer_id, supplier_id
215: INTO l_user_name, l_email_address, l_employee_id, l_customer_id,
216: l_vendor_id
217: FROM fnd_user
218: WHERE user_id = p_user_id
219: AND SYSDATE BETWEEN NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE);
220:
221: IF (l_employee_id IS NOT NULL) THEN

Line 222: -- FND user is an employee

218: WHERE user_id = p_user_id
219: AND SYSDATE BETWEEN NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE);
220:
221: IF (l_employee_id IS NOT NULL) THEN
222: -- FND user is an employee
223: SELECT pwx.full_name full_name, pwx.email_address email_address
224: INTO p_full_name, p_email_address
225: FROM fnd_user fu, per_workforce_current_x pwx
226: WHERE fu.employee_id IS NOT NULL

Line 225: FROM fnd_user fu, per_workforce_current_x pwx

221: IF (l_employee_id IS NOT NULL) THEN
222: -- FND user is an employee
223: SELECT pwx.full_name full_name, pwx.email_address email_address
224: INTO p_full_name, p_email_address
225: FROM fnd_user fu, per_workforce_current_x pwx
226: WHERE fu.employee_id IS NOT NULL
227: AND fu.employee_id = pwx.person_id
228: AND SYSDATE BETWEEN NVL(fu.start_date, SYSDATE) AND NVL(fu.end_date, SYSDATE)
229: AND fu.user_id = p_user_id;

Line 232: -- FND User is a customer

228: AND SYSDATE BETWEEN NVL(fu.start_date, SYSDATE) AND NVL(fu.end_date, SYSDATE)
229: AND fu.user_id = p_user_id;
230:
231: ELSIF (l_customer_id IS NOT NULL) THEN
232: -- FND User is a customer
233: SELECT hp.party_name full_name, hp.email_address email_address
234: INTO p_full_name, p_email_address
235: FROM fnd_user fu, hz_parties hp
236: WHERE fu.customer_id IS NOT NULL

Line 235: FROM fnd_user fu, hz_parties hp

231: ELSIF (l_customer_id IS NOT NULL) THEN
232: -- FND User is a customer
233: SELECT hp.party_name full_name, hp.email_address email_address
234: INTO p_full_name, p_email_address
235: FROM fnd_user fu, hz_parties hp
236: WHERE fu.customer_id IS NOT NULL
237: AND fu.customer_id = hp.party_id
238: AND fu.user_id = p_user_id;
239:

Line 241: -- FND User is a supplier

237: AND fu.customer_id = hp.party_id
238: AND fu.user_id = p_user_id;
239:
240: ELSIF (l_vendor_id IS NOT NULL) THEN
241: -- FND User is a supplier
242: SELECT pvc.last_name || ', ' || pvc.first_name full_name, pvc.email_address email_address
243: INTO p_full_name, p_email_address
244: FROM fnd_user fu, po_vendor_contacts pvc
245: WHERE fu.supplier_id IS NOT NULL

Line 244: FROM fnd_user fu, po_vendor_contacts pvc

240: ELSIF (l_vendor_id IS NOT NULL) THEN
241: -- FND User is a supplier
242: SELECT pvc.last_name || ', ' || pvc.first_name full_name, pvc.email_address email_address
243: INTO p_full_name, p_email_address
244: FROM fnd_user fu, po_vendor_contacts pvc
245: WHERE fu.supplier_id IS NOT NULL
246: AND fu.supplier_id = pvc.vendor_contact_id
247: AND NVL(pvc.inactive_date, SYSDATE) >= SYSDATE
248: AND fu.user_id = p_user_id;

Line 257: -- Use email address defiend in FND User if not set elsewhere

253: IF (p_full_name IS NULL) THEN
254: p_full_name := l_user_name;
255: END IF;
256:
257: -- Use email address defiend in FND User if not set elsewhere
258: IF (p_email_address IS NULL) THEN
259: p_email_address := l_email_address;
260: END IF;
261: p_return_status := G_RETURN_SUCCESS;